tjtablemodel.java

来自「java课程的资料以及实验的代码」· Java 代码 · 共 51 行

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

public class TJtableModel {
   Connection conn;
   TSearch ts;
	String str;
	TCardModel tcmTemp;
	
   public TJtableModel(TCardModel tcm) {
   		conn = (new DbConn()).getConnection();
   		tcmTemp=tcm;
   }
   
   public int selAssets(String [][] data) {
      int page = 15;
      int cateid = 0;
      int subcateid = 0;
      String sql;
      int cnt=0;
      
      if (conn == null) {
      	System.out.println("Can not connected yet!");
      	return -1;
      }
      try {
      	
      		str=tcmTemp.pcard.jtfCateId.getText();
//		str=TCardModel.strCateId;
      sql = "select a.asset_name,a.model,a.price,a.purchase_date,a.status,b.empno,b.isreturn from asset a LEFT OUTER JOIN lend b on (a.assetid=b.assetid) where a.cateid = ";
      Statement stmt = conn.createStatement();
      ResultSet rset = stmt.executeQuery (sql+str);
      while (rset.next()&&cnt<page) {
        data[cnt][0] = rset.getString(1);
        data[cnt][1] = rset.getString(2);
        data[cnt][2] = rset.getString(3);
        data[cnt][3] = rset.getString(4);
        data[cnt][4] = rset.getString(5);
        data[cnt][5] = rset.getString(6);
        data[cnt][6] = rset.getString(7);
        cnt++;
      }
      rset.close();
      stmt.close();
      }
      catch (java.sql.SQLException s) {
			System.out.println("exception: " + s.getMessage());
      }
    	return cnt;	 
   } 
}