毕业设计：基于jsp的财务管理系统

/** * Title 财务管理系统 * @author: trowa * Company: http://www.upol.cn * Copyright: Copyright (c) 2004 * @version 1.0 * 费用类型表中的一些查询操作 */ package caiwu; import java.sql.*; import java.util.*; public class DispPay extends Pay{ public ResultSet rs; //得到所有的费用 public Vector allPay(){ DBConnect dbc = null; Vector allPayVector = new Vector(); try{ dbc = new DBConnect(); dbc.prepareStatement("SELECT * FROM pay order by id desc"); rs = dbc.executeQuery(); while(rs.next()){ Pay pay = new Pay(); pay.setId(rs.getInt("id")); pay.setClassid(rs.getInt("classid")); pay.setPayerid(rs.getInt("payerid")); pay.setPaytypeid(rs.getInt("paytypeid")); pay.setMoney(rs.getInt("money")); pay.setInout(rs.getInt("inandout")); pay.setProject(rs.getString("project")); pay.setMessage(rs.getString("message")); pay.setAddtime(rs.getString("addtime")); allPayVector.add(pay); } }catch(Exception e){ System.err.println(e); }finally{ try{ dbc.close(); }catch(Exception e){ e.printStackTrace(); } } return allPayVector; } //得到所有的年份 public Vector allAddtime_year(){ DBConnect dbc = null; Vector allPayVector = new Vector(); try{ dbc = new DBConnect(); dbc.prepareStatement("select distinct year(addtime) From pay"); rs = dbc.executeQuery(); while(rs.next()){ Pay pay = new Pay(); pay.setAddtime_year(rs.getInt("year(addtime)")); allPayVector.add(pay); } }catch(Exception e){ System.err.println(e); }finally{ try{ dbc.close(); }catch(Exception e){ e.printStackTrace(); } } return allPayVector; } //得到部门所有的费用记录 public Vector classidtoallPay(){ DBConnect dbc = null; Vector allPayVector = new Vector(); try{ dbc = new DBConnect(); dbc.prepareStatement("SELECT * FROM pay where classid=? order by id desc"); dbc.setInt(1,Classid); rs = dbc.executeQuery(); while(rs.next()){ Pay pay = new Pay(); pay.setId(rs.getInt("id")); pay.setClassid(rs.getInt("classid")); pay.setPayerid(rs.getInt("payerid")); pay.setPaytypeid(rs.getInt("paytypeid")); pay.setMoney(rs.getInt("money")); pay.setInout(rs.getInt("inandout")); pay.setProject(rs.getString("project")); pay.setMessage(rs.getString("message")); pay.setAddtime(rs.getString("addtime")); allPayVector.add(pay); } }catch(Exception e){ System.err.println(e); }finally{ try{ dbc.close(); }catch(Exception e){ e.printStackTrace(); } } return allPayVector; } //根据id得到费用记录 public Pay idToPay(){ DBConnect dbc = null; Pay pay = new Pay(); try{ dbc = new DBConnect(); dbc.prepareStatement("SELECT * FROM pay where id=?"); dbc.setInt(1,Id); rs = dbc.executeQuery(); if(rs.next()){ //pay.setId(rs.getInt("id")); pay.setClassid(rs.getInt("classid")); pay.setPayerid(rs.getInt("payerid")); pay.setPaytypeid(rs.getInt("paytypeid")); pay.setMoney(rs.getInt("money")); pay.setInout(rs.getInt("inandout")); pay.setProject(rs.getString("project")); pay.setMessage(rs.getString("message")); pay.setAddtime(rs.getString("addtime")); } }catch(Exception e){ System.err.println(e); }finally{ try{ dbc.close(); }catch(Exception e){ e.printStackTrace(); } } return pay; } //搜索费用记录 public Vector searchallPay(){ DBConnect dbc = null; Vector allPayVector = new Vector(); try{ dbc = new DBConnect(); dbc.prepareStatement("SELECT * FROM pay where "+Sqlstr+" order by id desc"); //dbc.setBytes(1,Sqlstr.getBytes("UTF-8")); rs = dbc.executeQuery(); while(rs.next()){ Pay pay = new Pay(); pay.setId(rs.getInt("id")); pay.setClassid(rs.getInt("classid")); pay.setPayerid(rs.getInt("payerid")); pay.setPaytypeid(rs.getInt("paytypeid")); pay.setMoney(rs.getInt("money")); pay.setInout(rs.getInt("inandout")); pay.setProject(rs.getString("project")); pay.setMessage(rs.getString("message")); pay.setAddtime(rs.getString("addtime")); allPayVector.add(pay); } }catch(Exception e){ System.err.println(e); }finally{ try{ dbc.close(); }catch(Exception e){ e.printStackTrace(); } } return allPayVector; } //获得搜索记录总条数 public int searchpaynum() { DBConnect dbc = null; int paycount = 0; try{ dbc = new DBConnect(); dbc.prepareStatement("SELECT count(*) FROM pay where "+Sqlstr); rs = dbc.executeQuery(); if(rs.next()) paycount = rs.get