lendmanager.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 LendManager {
  // 表示与数据库的连接
      private Connection con = ConnectionManager.getConnection();

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

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

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


      // 此方法用于资产借用
      public void lendAsset(LendModel lendModel) throws SQLException {
          sql = new StringBuffer("insert into lend (assetid,empno,usedate,isreturn,operator,remarks)"
                +" values("+Integer.parseInt(lendModel.getassetid())+","
                +Integer.parseInt(lendModel.getempno())+",'"+lendModel.getusedate()+
                "','"+lendModel.getisreturn()+"','"+lendModel.getOperator()+
                "','"+lendModel.getremarks()+"')");
          stmt = con.createStatement();
          stmt.executeUpdate(sql.toString());
          ConnectionManager.closeResultSet(rs);
          ConnectionManager.closeStatement(stmt);
      }

      // 此方法用于资产归还
      public void returnAsset(LendModel retnModel) throws SQLException {
          sql = new StringBuffer("update lend set retdate = '"+retnModel.getretdate()
                                 +"',isreturn = '" + retnModel.getisreturn() + "',operator = '"
                                + retnModel.getOperator() + "' where isreturn = '借用' and assetid = "
                                 +Integer.parseInt(retnModel.getassetid()));
          stmt = con.createStatement();
          stmt.executeUpdate(sql.toString());
          ConnectionManager.closeResultSet(rs);
          ConnectionManager.closeStatement(stmt);
      }

      // 此方法用于借用归还情况查询
      public ResultSet queryFromLend(int index, String query) throws SQLException {
        switch (index) {
          case 0:
            sql = new StringBuffer("select * from lend where assetid = " +
                                   Integer.parseInt(query));
            break;

          case 1:
            sql = new StringBuffer("select * from lend where operator like '%" +
                                   query + "%'");
            break;
          case 2:
            sql = new StringBuffer("select * from lend where isreturn = '" +
                                   query + "'");
            break;
          case 3:
            sql = new StringBuffer("select * from lend where empno = " +
                                   query);
            break;

        }
          stmt = con.createStatement();
          rs = stmt.executeQuery(sql.toString());
          return rs;
      }
      //此方法用于资产借用table表显示记录
      public void displayLendMag(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.getObject(1), rs.getObject(2),
                         rs.getString(3), rs.getString(4), rs.getString(5),
                         rs.getString(6), rs.getString(7), rs.getString(8)});
          }

          jTable.setModel(model);
          jTable.setSelectionMode(ListSelectionModel.SINGLE_SELECTION); //设置jTable只能单行选择
          ConnectionManager.closeResultSet(rs);
          ConnectionManager.closeStatement(stmt);

        }
        catch (Exception ex) {

        }

      }
}