作品详情

5.1程序设计

登陆界面如下

主界面模型图如下

5.1.1设备管理模块

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

界面示意图如下：

源代码：

/* *AssetModel.java：建立固定资产实体类。 *包括：与数据库进行增、删、改、查操作。 */ import java.sql.*;import java.math.*;​public class AssetModel {String assetid;String assetname;String cateid;String subcateid;String model;String price;String purchasedate;String status;String useby;String remarks;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";PreparedStatement pstmt = 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 into LEND (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 = "SELECT assetid,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 set asset_name=?,model=?,price=?,purchase_date=?,status=?,useby=?,remarks=? where assetid = ?");      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 where assetid = "+Integer.parseInt(assetid) ;      try {      PreparedStatement pstmt = conn.prepareStatement(sql);      pstmt.execute();      String sql1 = "delete lend where assetid = "+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());      }   }}