tcardmodel.java

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

import java.sql.*;
import java.math.*;

public class TCardModel {
   String sql;
   TCard pcard;
   Connection conn;
//   static String strCateId;
   
   public TCardModel() {}
   
   public TCardModel(TCard pc) {
   	pcard = pc;
   	conn = (new DbConn()).getConnection();
   }
   void clearCard() {
   	pcard.jtfAssetId.setText("") ;
        pcard.jtfAssetName.setText("") ;
        pcard.jtfCateId.setText("") ;
        pcard.jtfSubCateId.setText("") ;
        pcard.jtfModel.setText("") ;
        pcard.jtfPrice.setText("") ;
        pcard.jtfPurchaseDate.setText("") ;
        pcard.jtfStatus.setText("") ;
        pcard.jtfUseby.setText("") ;
        pcard.jtfRemarks.setText("") ;
        pcard.jtfEmpno.setText("") ;
        pcard.jtfUsedate.setText("") ;
        pcard.jtfRetdate.setText("") ;
        pcard.jtfIsreturn.setText("") ;
   }
   public void selAssetId(String aid) {
      if (conn == null) {
      	System.out.println("Can not connected yet!");
      	return ;
      }
      clearCard();
      try {
      sql = "select a.assetid,rtrim(a.asset_name),a.cateid,a.subcateid,rtrim(a.model),a.price,a.purchase_date,a.status,a.useby,rtrim(a.remarks),b.empno,b.usedate,b.retdate,b.isreturn from asset a LEFT OUTER JOIN lend b on (a.assetid=b.assetid) where a.assetid = "+Integer.parseInt(aid);
      Statement stmt = conn.createStatement();
      ResultSet rset = stmt.executeQuery (sql);
      if (rset.next()) {
        pcard.jtfAssetId.setText(rset.getString(1));
        pcard.jtfAssetName.setText(rset.getString(2)) ;
        pcard.jtfCateId.setText(rset.getString(3)) ;
//        strCateId=pcard.jtfCateId.getText();
        pcard.jtfSubCateId.setText(rset.getString(4)) ;
        pcard.jtfModel.setText(rset.getString(5)) ;
        pcard.jtfPrice.setText(rset.getString(6)) ;
        pcard.jtfPurchaseDate.setText(rset.getString(7)) ;
        pcard.jtfStatus.setText(rset.getString(8)) ;
        pcard.jtfUseby.setText(rset.getString(9)) ;
        pcard.jtfRemarks.setText(rset.getString(10)) ;
        pcard.jtfEmpno.setText(rset.getString(11)) ;
        pcard.jtfUsedate.setText(rset.getString(12)) ;
        pcard.jtfRetdate.setText(rset.getString(13)) ;
        pcard.jtfIsreturn.setText(rset.getString(14)) ;
      }
      rset.close();
      stmt.close();
      }
      catch (java.sql.SQLException s) {
      	System.out.println("exception: "+s.getMessage());
      }
   }
   public void selAssetName(String aname) {
      if (conn == null) {
      	System.out.println("Can not connected yet!");
      	return ;
      }
      clearCard();
      try {
      sql = "select a.assetid,rtrim(a.asset_name),a.cateid,a.subcateid,rtrim(a.model),a.price,a.purchase_date,a.status,a.useby,rtrim(a.remarks),b.empno,b.usedate,b.retdate,b.isreturn from asset a LEFT OUTER JOIN lend b on (a.assetid=b.assetid) where a.asset_name = '"+aname+"'" ;
      Statement stmt = conn.createStatement();
      ResultSet rset = stmt.executeQuery (sql);
      if (rset.next()) {
        pcard.jtfAssetId.setText(rset.getString(1));
        pcard.jtfAssetName.setText(rset.getString(2)) ;
        pcard.jtfCateId.setText(rset.getString(3)) ;
        pcard.jtfSubCateId.setText(rset.getString(4)) ;
        pcard.jtfModel.setText(rset.getString(5)) ;
        pcard.jtfPrice.setText(rset.getString(6)) ;
        pcard.jtfPurchaseDate.setText(rset.getString(7)) ;
        pcard.jtfStatus.setText(rset.getString(8)) ;
        pcard.jtfUseby.setText(rset.getString(9)) ;
        pcard.jtfRemarks.setText(rset.getString(10)) ;
        pcard.jtfEmpno.setText(rset.getString(11)) ;
        pcard.jtfUsedate.setText(rset.getString(12)) ;
        pcard.jtfRetdate.setText(rset.getString(13)) ;
        pcard.jtfIsreturn.setText(rset.getString(14)) ;
      }
      rset.close();
      stmt.close();
      }
      catch (java.sql.SQLException s) {
      	System.out.println("exception: "+s.getMessage());
      }
   }
   
   
}