作品详情

程序设计

登陆界面如下

5.1.1设备管理模块

固定资产管理弹出界面描述：

界面示意图如下：

源代码：

/*

 *AssetModel.java：建立固定资产实体类。

 *包括：与数据库进行增、删、改、查操作。

 */

import java.sql.*;

import java.math.*;

public class AssetModel{String assetid;String assetname;String cateid;String subcateid;Stringmodel;String price;String purchasedate;String status;String useby;Stringremarks;DbConn dbc;Connection conn;

   public AssetModel() {

   }

/*

* 添加方法

*/

   public void insert() {

      dbc = new DbConn();

      conn = dbc.getConnection();

      try {

      Statement stmt = conn.createStatement();

      ResultSet rset = stmt.executeQuery("select max(assetid)+1 from asset");

      while (rset.next()) {

        assetid= rset.getString(1);

      }

      if (assetid == null) assetid ="1";

PreparedStatementpstmt = conn.prepareStatement("inser tinto ASSET

(assetid,asset_name,cateid,subcateid,model,price,purchase_date,status,useby,remarks)values (?,?,?,?,?,?,?,?,?,?)");

      pstmt.setInt(1,Integer.parseInt(assetid));         

      pstmt.setString(2, assetname);  

      pstmt.setInt(3,Integer.parseInt(cateid));

      pstmt.setInt(4,Integer.parseInt(subcateid));

      pstmt.setString(5, model);

      pstmt.setFloat(6,Float.parseFloat(price));

      pstmt.setString(7, purchasedate);

      pstmt.setString(8, status);

      pstmt.setString(9, useby);

      pstmt.setString(10, remarks);

      pstmt.execute();

      PreparedStatement pstmt1 =

      conn.prepareStatement("insert intoLEND (assetid) values (?)");

      pstmt1.setInt(1,Integer.parseInt(assetid));         

      pstmt1.execute();

      conn.commit();

      conn.close();

      }

      catch (java.sql.SQLException s) {

       System.out.println("exception: " + s.getMessage());

      }

   }

   /*

* 查询方法

*/

   public void select() {

      String sql;

      dbc = new DbConn();

      conn = dbc.getConnection();

      sql = "SELECTassetid,rtrim(asset_name),cateid,subcateid,rtrim(model),price,purchase_date,status,useby,rtrim(remarks)FROM asset where assetid = "+Integer.parseInt(assetid);

      try {

      Statement stmt = conn.createStatement();

      ResultSet rset = stmt.executeQuery (sql);

      while (rset.next()) {

                assetname = rset.getString(2);

              cateid = rset.getString(3);

              subcateid = rset.getString(4);

              model = rset.getString(5);

              price = rset.getString(6);

              purchasedate = rset.getString(7);

              status = rset.getString(8);

              useby = rset.getString(9);

              remarks = rset.getString(10);

      }

      conn.commit();

      rset.close();

      stmt.close();

      conn.close();

      }

      catch (java.sql.SQLException s) {

       System.out.println("exception: " + s.getMessage());

      }

    }

    public void update() {

      dbc = new DbConn();

      conn = dbc.getConnection();

      try {

      PreparedStatement pstmt =conn.prepareStatement("update ASSET setasset_name=?,model=?,price=?,purchase_date=?,status=?,useby=?,remarks=? whereassetid = ?");

      pstmt.setString(1, assetname);         

      pstmt.setString(2, model);  

      pstmt.setFloat(3,Float.parseFloat(price));

      pstmt.setString(4, purchasedate);

      pstmt.setString(5, status);

      pstmt.setString(6, useby);

      pstmt.setString(7, remarks);

      pstmt.setInt(8,Integer.parseInt(assetid));

      pstmt.execute();

      conn.commit();

      conn.close();

      }

      catch (java.sql.SQLException s) {

       System.out.println("exception: " + s.getMessage());

      }

   }

   /*

* 删除方法

*/

   public void delete() {

      dbc = new DbConn();

      conn = dbc.getConnection();

      String sql = "delete asset whereassetid = "+Integer.parseInt(assetid) ;

      try {

      PreparedStatement pstmt =conn.prepareStatement(sql);

      pstmt.execute();

      String sql1 = "delete lend whereassetid = "+Integer.parseInt(assetid) ;

      PreparedStatement pstmt1 =conn.prepareStatement(sql1);

      pstmt1.execute();

      conn.commit();

      conn.close();

      assetid = null;

      assetname = null;

      cateid = "";

      subcateid = "";

      model = null;

      price = null;

      purchasedate = null;

      status = "";

      useby = null;

      remarks = null;

      }

      catch (java.sql.SQLException s) {

       System.out.println("exception: " + s.getMessage());

      }

   }

}

其余4块管理弹出界面描述同上。

源文件