/**
*  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 DispPaytype extends Paytype{

    public ResultSet rs;

//得到所有的費用類型
    public Vector allPaytype(){
        DBConnect dbc = null;
            Vector allPaytypeVector = new Vector();
            try{
                    dbc  = new DBConnect();
                    dbc.prepareStatement("SELECT * FROM paytype order by id");
                    rs = dbc.executeQuery();
                            while(rs.next()){
                            Paytype paytype = new Paytype();
                            paytype.setId(rs.getInt("id"));
                            paytype.setName(rs.getString("name"));
                            paytype.setInout(rs.getInt("inout"));
                            allPaytypeVector.add(paytype);
                    }
            }catch(Exception e){
                    System.err.println(e);
            }finally{
                    try{
                            dbc.close();
                    }catch(Exception e){
                            e.printStackTrace();
                    }
            }
            return allPaytypeVector;


    }
    //根據支出和收入獲得所有的費用類型
        public Vector inoutPaytype(){
            DBConnect dbc = null;
                Vector allPaytypeVector = new Vector();
                try{
                        dbc  = new DBConnect();
                        dbc.prepareStatement("SELECT * FROM paytype where inout=? order by id");
                        dbc.setInt(1,Inout);
                        rs = dbc.executeQuery();
                                while(rs.next()){
                                Paytype paytype = new Paytype();
                                paytype.setId(rs.getInt("id"));
                                paytype.setName(rs.getString("name"));
                                paytype.setInout(rs.getInt("inout"));
                                allPaytypeVector.add(paytype);
                        }
                }catch(Exception e){
                        System.err.println(e);
                }finally{
                        try{
                                dbc.close();
                        }catch(Exception e){
                                e.printStackTrace();
                        }
                }
                return allPaytypeVector;


    }

//根據id得到所有的費用類型
        public Paytype idToPaytype(){
            DBConnect dbc = null;
                Paytype paytype = new Paytype();
                try{
                        dbc  = new DBConnect();
                        dbc.prepareStatement("SELECT * FROM paytype where id=?");
                        dbc.setInt(1,Id);
                        rs = dbc.executeQuery();
                              if(rs.next()){
                                paytype.setId(rs.getInt("id"));
                                paytype.setName(rs.getString("name"));
                                paytype.setInout(rs.getInt("inout"));
                        }
                }catch(Exception e){
                        System.err.println(e);
                }finally{
                        try{
                                dbc.close();
                        }catch(Exception e){
                                e.printStackTrace();
                        }
                }
                return paytype;
    }



    public DispPaytype() {
    }
}