assetmanager.java

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

package asset;

import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.swing.JOptionPane;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;
import javax.swing.tree.DefaultMutableTreeNode;
import javax.swing.ListSelectionModel;
import java.awt.Toolkit;
import java.awt.Dimension;
import javax.swing.JDialog;

/**
 * 此类用于固定资产管理控制
 */
public class AssetManager {


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

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

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

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

    // 此方法用于添加数据
    public void addToAsset(AssetModel assetModel) throws SQLException {
        // 插入语句
        sql = new StringBuffer("insert into asset (assetid,asset_name,cateid,subcateid,model,price,purchase_date,status,useby,remarks) values(" +
                               Integer.parseInt(assetModel.getassedid()) +
                               ",'" + assetModel.getasset_name() + "'," +
                               Integer.parseInt(assetModel.getcateid()) +
                               "," + Integer.parseInt(assetModel.getsubcateid()) +
                               ",'" + assetModel.getmodel() + "'," +
                               Float.parseFloat(assetModel.getprice()) + ",'" +
                               assetModel.getpurchase_date() + "','" +
                               assetModel.getstatus() + "','" + assetModel.getuseby() +
                               "','" + assetModel.getremarks() + "')");

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

    }

    // 此方法用于修改数据
    public void updateAsset(AssetModel assetModel) throws SQLException {
        int assetid = Integer.parseInt(assetModel.getassedid());
        //修改语句
        sql = new StringBuffer("update ASSET set asset_name='" +
                               assetModel.getasset_name() +
                               "',cateid=" + Integer.parseInt(assetModel.getcateid()) +
                               ",subcateid=" +
                               Integer.parseInt(assetModel.getsubcateid()) +
                               ",model='" + assetModel.getmodel() + "',price=" +
                               Float.parseFloat(assetModel.getprice()) +
                               ",purchase_date='" + assetModel.getpurchase_date() +
                               "',status='" + assetModel.getstatus() +
                               "',useby='" + assetModel.getuseby() + "',remarks='" +
                               assetModel.getremarks() + "' where assetid =" +
                               assetid + "and deleteFlag = 1");

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

    //此方法用于删除数据
    public void deleteAsset(AssetModel assetModel) throws SQLException {
        int assetid = Integer.parseInt(assetModel.getassedid());
        //System.out.println(assetid);
        //删除语句
        sql = new StringBuffer(
                "update ASSET set deleteFlag = 0 where assetid = " + assetid);
        stmt = con.createStatement();
        int rs = stmt.executeUpdate(sql.toString());
        //System.out.println(rs);
        stmt.close();
    }


    //此方法用语查询数据库
    public ResultSet select(AssetModel assetModel, int index) throws SQLException {
        if (index == 0) {
            //根据资产名称查询
            sql = new StringBuffer(
                    "select * from ASSET where asset_name like '%" +
                    assetModel.getasset_name() + "%' and deleteflag = 1");
            stmt = con.createStatement();
            rs = stmt.executeQuery(sql.toString());
            return rs;
        }
        if (index == 1) {
            //根据录入日期查询
            sql = new StringBuffer(
                    "select * from ASSET where purchase_date like '%" +
                    assetModel.getpurchase_date() + "%' and deleteflag = 1");
            stmt = con.createStatement();
            rs = stmt.executeQuery(sql.toString());
            return rs;

        }

        if (index == 2) {
            //根据产品状态查询
            sql = new StringBuffer(
                    "select * from ASSET where status like '%" +
                    assetModel.getstatus() + "%' and deleteflag = 1");
        }
        stmt = con.createStatement();
        rs = stmt.executeQuery(sql.toString());
        return rs;

    }
    //此方法用于资产table表显示记录
    public void displayAsset(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.getObject(3), rs.getObject(4), rs.getString(5),
                       rs.getObject(6), rs.getObject(7), rs.getString(8),
                       rs.getString(9), rs.getString(10)});
        }
        jTable.setModel(model);
        jTable.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);//设置jTable只能单行选择
        ConnectionManager.closeResultSet(rs);
        ConnectionManager.closeStatement(stmt);

      }
      catch (Exception ex) {

      }

    }

    public void dialogCenterDisplay(JDialog jDialog) {

      //居中显示开始
      Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
      Dimension frameSize = jDialog.getSize();
      if (frameSize.height > screenSize.height) {
        frameSize.height = screenSize.height;
      }
      if (frameSize.width > screenSize.width) {
        frameSize.width = screenSize.width;
      }
      jDialog.setLocation( (screenSize.width - frameSize.width) / 2,
                          (screenSize.height - frameSize.height) / 2);
      //居中显示结束

    }


}