querytableejb.java

数据库管理系统

package appgdzc.tools;

import javax.swing.table.DefaultTableModel;
import appgdzc.model.facadeQuery;
import appgdzc.tools.GlobaBean;
import java.util.Collection;
import javax.sql.DataSource;

public class QueryTableEJB {
    facadeQuery facadeQueryObject = null;
    String tableName = null;
    String t_zcxx[] = {"设备编号","设备名称","设备型号","设备数量","设备单价","设备金额","生产厂家","出厂日期","购买日期","购买人"};
    String t_zcinout[] = {"流水号","设备编号","借出数量","借出部门","借用人","借用日期","归还数量","归还日期"};
    String t_zcwx[] = {"流水号码","设备编号","设备名称","送修日期","故障原因","维修日期","维修状况","配件名称","维修费用"};
    String t_zczj[] = {"设备编号","设备名称","折旧方法","资产原值","净残率值","使用年限","月折旧率","月折旧额"};
    String t_username[] = {"用户ID","用户姓名","用户口令","重复口令"};
    String[] t_column_name = null;
    String StrSqlQuery = null;

    DefaultTableModel tableModel = null;
    facadeQuery facadequery = null;


    public QueryTableEJB(String tname) {
        tableName = tname;

    }
    public void setColumnName(String[] name){
        this.t_column_name = name;
    }
    public boolean modifyuser(String sqlStr){
        facadequery = GlobaBean.facadeQueryObject;
        try{
            return facadequery.modifyuser(sqlStr);
        }catch(java.rmi.RemoteException remote){
            remote.printStackTrace();
            System.out.println(remote.getMessage());
            return false;
        }
    }
    public DefaultTableModel getTableModel(String sqlstr){
        if (tableName == "t_zcxx") t_column_name = t_zcxx;
        if (tableName == "t_inout") t_column_name = t_zcinout;
        if (tableName == "t_zcwx") t_column_name = t_zcwx;
        if (tableName == "t_zczj") t_column_name = t_zczj;
        if (tableName == "t_user") t_column_name = t_username;
        java.util.Vector vname = new java.util.Vector();
        for(int i = 0 ; i < t_column_name.length; i++){
            vname.addElement(t_column_name[i]);
        }
        tableModel = new DefaultTableModel(vname,0);
        facadequery = GlobaBean.facadeQueryObject;
        try{
            java.util.Collection collection = null;
            java.util.Iterator iterator = null;
            java.util.Vector vdata = null;
            collection = facadequery.getQueryObject(sqlstr);
            System.out.println("collection "+ collection);
            iterator = collection.iterator();
            while(iterator.hasNext()){
                java.util.Vector vData = new java.util.Vector();
                vdata = (java.util.Vector)iterator.next();
                for (int i = 0 ; i <  vdata.size()  ; i ++){
                    System.out.println(vdata.get(i));
                    vData.add(vdata.get(i));
                }
                tableModel.addRow(vData);
            }


        }catch(java.rmi.RemoteException remote){
            System.out.println("remote error:" + remote.getMessage());
            remote.printStackTrace();
            return null;
        }
        return tableModel;
    }

}