/**
* Title 财务管理系统
* @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.setinoutt(rs.getInt("inoutt"));
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.setinoutt(rs.getInt("inoutt"));
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.setinoutt(rs.getInt("inoutt"));
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("GB2312"));
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.setinoutt(rs.getInt("inoutt"));
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.getInt(1);
}catch(Exception e){
Sys
没有合适的资源?快使用搜索试试~ 我知道了~
财务管理系统(JSP+Servlet+JavaBean)
共177个文件
class:56个
jsp:52个
gif:29个
5星 · 超过95%的资源 需积分: 13 184 下载量 4 浏览量
2013-10-29
19:43:16
上传
评论 12
收藏 248KB RAR 举报
温馨提示
财务管理系统(JSP+Servlet+JavaBean),数据库采用mysql,如果用兴趣,可以下载下去参考一下 。
资源推荐
资源详情
资源评论
收起资源包目录
财务管理系统(JSP+Servlet+JavaBean) (177个子文件)
DispPay.class 8KB
DispPay.class 8KB
DBConnectionManager.class 7KB
DBConnectionManager.class 7KB
DispMaster.class 5KB
DispNews.class 5KB
DispMaster.class 5KB
DBConnect.class 4KB
DBConnect.class 4KB
DBConnectionManager$DBConnectionPool.class 4KB
DBConnectionManager$DBConnectionPool.class 4KB
MasterControl.class 3KB
MasterControl.class 3KB
DispLog.class 3KB
NewsControl.class 3KB
DispLog.class 3KB
DispPaytype.class 3KB
DispPaytype.class 3KB
Pay.class 3KB
Pay.class 3KB
DispClass.class 2KB
PayControl.class 2KB
DispClass.class 2KB
PayControl.class 2KB
GetDate.class 2KB
GetDate.class 2KB
PaytypeControl.class 2KB
DispPayer.class 2KB
PayerControl.class 2KB
ClassControl.class 2KB
DispPayer.class 2KB
PaytypeControl.class 2KB
PayerControl.class 2KB
ClassControl.class 2KB
Master.class 2KB
Master.class 2KB
LogControl.class 2KB
News.class 2KB
LogControl.class 2KB
CodeFilter.class 2KB
CodeFilter.class 2KB
ParamUtils.class 2KB
ParamUtils.class 2KB
UnicodeFilter.class 1KB
DisPage.class 1KB
DisPage.class 1KB
ToUnicode.class 1KB
Log.class 1KB
Log.class 1KB
ToUnicode.class 1KB
Paytype.class 897B
Paytype.class 894B
Payer.class 720B
Payer.class 719B
IClass.class 706B
IClass.class 706B
.classpath 362B
org.eclipse.wst.jsdt.ui.superType.container 49B
css.css 4KB
login.gif 29KB
title.gif 3KB
usert.gif 2KB
admin_left_1.gif 2KB
admin_left_9.gif 2KB
admin_left_5.gif 2KB
admin_left_3.gif 2KB
title_bg_quit.gif 2KB
temp_r1_c1.gif 2KB
admin_left_6.gif 1KB
temp_r4_c1.gif 1KB
admin_left_7.gif 1KB
admin_left_2.gif 1KB
loading.gif 862B
plus.gif 395B
submit.gif 318B
reset.gif 306B
drop1.gif 289B
drop2.gif 289B
left2.gif 287B
left1.gif 287B
right2.gif 286B
right1.gif 286B
userd.gif 279B
minus.gif 237B
bullet.gif 179B
admin_bg_1.gif 173B
temp_r2_c1(1).gif 131B
close.gif 106B
DispPay.java 14KB
DBConnectionManager.java 9KB
DispMaster.java 5KB
DBConnect.java 4KB
DispPaytype.java 4KB
MasterControl.java 3KB
DispLog.java 3KB
PayControl.java 3KB
GetDate.java 2KB
DispPayer.java 2KB
Pay.java 2KB
PaytypeControl.java 2KB
共 177 条
- 1
- 2
「已注销」
- 粉丝: 2
- 资源: 21
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
- 1
- 2
前往页