lendmodel.java

固定资产管理

/*
 *LendModel.java：建立固定资产借用与归还实体类。
 *包括：与数据库进行增、删、改、查操作。
 */
 
import java.sql.*;
import java.math.*;

public class LendModel {
   String assetid;
   String assetname;
   String model;
   String price;
   String empno;
   String usedate;
   String retdate;
   String isreturn;
   String lender;
   String remarks;
   DbConn dbc;
   Connection conn;
   public LendModel(String s0) {
   	assetid = s0;
   }
   public void setlend(String s1,String s2,String s3,String s4,String s5) {
        empno = s1;             	
   	usedate = s2;
   	retdate = s3;
   	isreturn = s4;
   	remarks = s5;
   	lender = Share.operator;
   }
   public void setret(String s1,String s2,String s3) {
        retdate = s1;             	
   	isreturn = s2;
   	remarks = s3;
   	lender = Share.operator;
   }
   public String getAssetId() {
   	return assetid;
   }
   public String getAssetName() {
   	return assetname;
   }
   public String getEmpno() {
   	return empno;
   }
   public String getUsedate() {
   	return usedate;
   }
   public String getModel() {
   	return model;
   }
   public String getPrice() {
   	return price;
   }
   public String getRetdate() {
   	return retdate;
   }
   public String getIsreturn() {
   	return isreturn;
   }
   public String getLender() {
   	return lender;
   }
   public String getRemarks() {
   	return remarks;
   }
   public void insert() {
   }
   
   public void select() {
      String sql;
      dbc = new DbConn();
      conn = dbc.getConnection();
      sql = "SELECT a.assetid,rtrim(a.asset_name),rtrim(a.model),a.price,l.empno,l.usedate,l.retdate,l.isreturn,l.lender,rtrim(l.remarks) FROM asset a,lend l where a.assetid = l.assetid and a.assetid = "+Integer.parseInt(assetid);
      try {
      Statement stmt = conn.createStatement();
      ResultSet rset = stmt.executeQuery (sql);
      boolean b = rset.next();
      	        assetname = rset.getString(2);
		model = rset.getString(3);
		price = rset.getString(4);
		empno = rset.getString(5);
		usedate = rset.getString(6);
		retdate = rset.getString(7);
		isreturn = rset.getString(8);
		lender = rset.getString(9);
		remarks = rset.getString(10);
      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 lend set empno = ?,usedate = ?,retdate = ?,isreturn = ?,remarks = ?,lender = ?  where assetid = "+Integer.parseInt(assetid));
      pstmt.setInt(1, Integer.parseInt(empno));   
      pstmt.setString(2, usedate);
      pstmt.setString(3, retdate);
      pstmt.setString(4, isreturn);
      pstmt.setString(5, remarks);
      pstmt.setString(6, lender);
      pstmt.execute();
      conn.commit();
      conn.close();
      }
      catch (java.sql.SQLException s) {
	System.out.println("exception: " + s.getMessage());
      }
   }
   
   public void delete() {
   }
}