tablemodel.java

一个资产管理系统的源码

package zichan;

import java.sql.Connection;
import java.sql.Statement;
import java.sql.SQLException;
import java.sql.ResultSet;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class TableModel {
    Connection conn;
    public TableModel() {
        conn=(new DBConnt()).getConnection();
    }
    public int selAsset(String [][] data){
        int page=15;
        int cateid=0;
        int subcateid=0;
        String sql;
        int cont=0;
        if(conn==null){
            System.out.println("未加载驱动程序");
            return -1;
        }
        try{
            Statement sta=conn.createStatement();
            if(Share.isleaf){
                ResultSet rs=sta.executeQuery("select subcateid from category where subcatename = '"+Share.condition+"'");
                if(rs.next()){
                    subcateid=rs.getInt(1);
                }else{
                    subcateid=0;
                }


            }else{
                ResultSet rs=sta.executeQuery("select cateid from category where catename = '"+Share.condition+"'");
                if(rs.next()){
                    cateid=rs.getInt(1);
                }else{
                    cateid=0;
                }
            }
            sta.close();
            sql = "select a.asset_name,a.model,a.price,a.purchase_date,a.status,b.empno,b.isreturn from asset a LEFT OUTER JOIN lend b on (a.assetid=b.assetid) where a.cateid = "+cateid+" or a.subcateid = "+subcateid;
            Statement st=conn.createStatement();
            ResultSet rs=st.executeQuery(sql);
            while(rs.next()&&cont<page){
                data[cont][0] = rs.getString(1);
                data[cont][1] = rs.getString(2);
                data[cont][2] = rs.getString(3);
                data[cont][3] = rs.getString(4);
                data[cont][4] = rs.getString(5);
                data[cont][5] = rs.getString(6);
                data[cont][6] = rs.getString(7);
                cont++;

            }
            rs.close();
            st.close();
        }catch(SQLException ce){
            System.out.println(ce);
        }
        return cont;




    }
}