tjtablemodel.java

固定资产管理

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

public class TJtableModel {
   Connection conn;
   public TJtableModel() {
   	conn = (new DbConn()).getConnection();
   }
   
   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 {
      Statement stmt1 = conn.createStatement();
      if (Share.isleaf) {
         ResultSet rset1 = stmt1.executeQuery ("select subcateid from category where subcatename = '"+Share.condition+"'");
         if (rset1.next())
           subcateid = rset1.getInt(1);
         else 
           subcateid = 0;
      }
      else {
         ResultSet rset1 = stmt1.executeQuery ("select cateid from category where catename = '"+Share.condition+"'");
         if(rset1.next())
           cateid = rset1.getInt(1);
         else
           cateid = 0;
      }
      stmt1.close();
      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 = "+cateid+" or a.subcateid = "+subcateid;
      Statement stmt = conn.createStatement();
      ResultSet rset = stmt.executeQuery (sql);
      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;
   } 
}