lendmodel.java

java课程的资料以及实验的代码

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

public class LendModel {
   String assetid;
   String empno;
   String usedate;
   String retdate;
   String isreturn;
   String lender;
   String remarks;

   DbConn dbc;
   Connection conn;
   public LendModel() {
   }
   public LendModel( String s0,
                     String s1,
                     String s2,
                     String s3,
                     String s4,
                     String s5,
                     String s6
         			) {
   	assetid = s0;	empno = s1;	
   	usedate = s2;	retdate = s3;
   	isreturn = s4;	lender = s5;
   	remarks = s6;
   }
   
   public void setAll(String s1,
   					  String s2,
                      String s3,	
                      String s4,
                      String s5,
                      String s6
                      ) {
	empno = s1;	usedate = s2;
   	retdate = s3;	isreturn = s4;
   	lender = s5;	remarks = s6;
   }
   
   public String getAssetId() {
   	return assetid;
   }
   public String getEmpNo() {
   	return empno;
   }
   public String getUseDate() {
   	return usedate;
   }
   public String getRetDate() {
   	return retdate;
   }
   public String getIsReturn() {
   	return isreturn;
   }
   public String getLender() {
   	return lender;
   }
   public String getRemarks() {
   	return remarks;
   }
  
   public void lendReturn() {
      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("insert into LEND (assetid,empno,usedate,retdate,isreturn,lender,remarks) values (?,?,?,?,?,?,?)");
      pstmt.setInt(1, Integer.parseInt(assetid));          
      pstmt.setInt(2, Integer.parseInt(empno));   
      pstmt.setString(3, usedate);
      pstmt.setString(4, retdate);
      pstmt.setString(5, isreturn);
      pstmt.setString(6, lender);
      pstmt.setString(7, remarks);
      pstmt.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,empno,usedate,retdate,isreturn,lender,rtrim(remarks) FROM lend where assetid = "+Integer.parseInt(assetid);
      try {
      Statement stmt = conn.createStatement();
      ResultSet rset = stmt.executeQuery (sql);
      while (rset.next()) {
			empno = rset.getString(2);
			usedate = rset.getString(3);
			retdate = rset.getString(4);
			isreturn = rset.getString(5);
			lender = rset.getString(6);
			remarks = rset.getString(7);
      }
      conn.commit(); 
      rset.close();
      stmt.close();
      conn.close();
      }
      catch (java.sql.SQLException s) {
	System.out.println("exception: " + s.getMessage());
      }
    }
    
}