assettypemanager.java

资金源码管理系统,用java开发的,有用的人可以试试看

package asset;

import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.SQLException;
import javax.swing.table.DefaultTableModel;
import javax.swing.JTable;
import javax.swing.ListSelectionModel;

public class AssetTypeManager {

  // 表示与数据库的连接
    private Connection con = ConnectionManager.getConnection();

    // 表示执行静态 sql 语句的对象
    private Statement stmt;

    // 表示返回的结果集
    private ResultSet rs;

    // 表示执行的 sql 语句
    private StringBuffer sql;

    CateModel cateModel = new CateModel();

    // 此方法用于添加数据
    public void addToCategory(CateModel cateModel) throws SQLException {
        sql = new StringBuffer("insert into category(cateid,catename,subcateid,subcatename) values("+Integer.parseInt(cateModel.getcateid())+
                ",'"+cateModel.getcatename()+"',"+Integer.parseInt(cateModel.getsubcateid())+",'"+
                 cateModel.getsubcatename()+"')");

        stmt = con.createStatement();
        stmt.executeUpdate(sql.toString());
        stmt.close();
    }

    //此方法用于资产管理类别的修改
    public void change(CateModel cateModel) throws SQLException {
        stmt = con.createStatement();
        stmt.executeUpdate("update category set cateid =" +
                           Integer.parseInt(cateModel.getcateid()) + ", catename='" +
                           cateModel.getcatename() + "', subcateid=" +
                           Integer.parseInt(cateModel.getsubcateid()) +
                           ", subcatename='" +
                           cateModel.getsubcatename() +
                           "' ,deleteflag=1 where cateid=" + cateModel.getcateid() +
                           "and subcateid=" + cateModel.getsubcateid());
        stmt.close();

    }

    //此方法用于资产管理类别的删除
    public void deleteLB(CateModel cateModel) throws SQLException {
        stmt = con.createStatement();
        stmt.executeUpdate(
                "update category set deleteFlag= 0 where  cateid =" +
                Integer.parseInt(cateModel.getcateid()) + "and subcateid=" +
                Integer.parseInt(cateModel.getsubcateid()));
        stmt.close();
        //stmt.executeUpdate("delete from category where cateid =" +mainId +"and subcateid=" +sonId);
        //在下表中显示删除后剩余的内容

    }

   //资产管理类别查询
    public void selectMainId(CateModel cateModel,int i) throws SQLException {
     // --主类编号查询
        if(i==0){
        stmt = con.createStatement();
        rs = stmt.executeQuery( "select * from category where deleteflag=1 and cateid = " +
                                Integer.parseInt(cateModel.getcateid()) +
                                "group by cateid,catename,subcateid,subcatename,deleteflag" );
               }

     //--子类编号查询
   if(i==1){
          stmt = con.createStatement();
         rs = stmt.executeQuery(
                                         "select * from category where deleteflag=1 and subcateid =" +
                                         Integer.parseInt(cateModel.getsubcateid()) +
                                         "group by cateid,catename,subcateid,subcatename,deleteflag");
                                  }

     //--主类名称查询
    if(i==2){
          stmt = con.createStatement();
          rs = stmt.executeQuery(
                              "select * from category where deleteflag=1 and catename =" +
                              "'" +
                              cateModel.getcatename() + "'" +
                              "group by cateid,catename,subcateid,subcatename,deleteflag");
                        }

     //--子类名称查询

  if(i==3) {

            stmt = con.createStatement();
            rs = stmt.executeQuery(
                          "select * from category where deleteflag=1 and subcatename =" +
                          "'" +
                          cateModel.getsubcatename() + "'" +
                          "group by cateid,catename,subcateid,subcatename,deleteflag");

                      }
    }

    //此方法用于资产table表显示记录
 public void displayAssetType(JTable jTable, String sql) {
   try {
     //初始table 表
     stmt = con.createStatement();
     rs = stmt.executeQuery(sql);

     // 创建table模板
     DefaultTableModel model = new DefaultTableModel();
     model.setColumnIdentifiers(new Object[] {"大类编号", "大类名称", "小类编号",
                                "小类名称"});
     while (rs.next()) {
       model.addRow(new Object[] {rs.getString(1), rs.getString(2),
                    rs.getString(3), rs.getString(4)});
     }
     jTable.setModel(model);
     jTable.setSelectionMode(ListSelectionModel.SINGLE_SELECTION); //设置jTable只能单行选择
     ConnectionManager.closeResultSet(rs);
     ConnectionManager.closeStatement(stmt);

   }
   catch (Exception ex) {

   }

 }



}