src/caiwu/DispPay.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

/**
*  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);