mytablemodel.java

是适合于使用的管理系统 可以在现实中使用

package mysiloer;

import javax.swing.table.DefaultTableModel;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.Vector;
import java.math.BigDecimal;

/**
 * <p>Title: MySiloer</p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2005</p>
 * <p>Company: yskey</p>
 * @author 杨涛
 * @version 1.0
 */

public class MyTableModel extends DefaultTableModel {

  private ResultSet set;
  private Vector colNameVector, contentVector;
  public MyTableModel(ResultSet set) {
    try{
      this.set = set;
      colNameVector = new Vector();
      contentVector = new Vector();
      ResultSetMetaData metaDate = set.getMetaData();
      int colCount = metaDate.getColumnCount();
      for(int i = 1; i <= colCount; i++){
        colNameVector.add(metaDate.getColumnLabel(i));
        System.out.println(metaDate.getColumnClassName(i));
      }
      while(set.next()){
//        for(int i = 1; i <= colCount; i++){
        try{
          contentVector.add(set.getString(1));
          contentVector.add(set.getString(2));
          contentVector.add(set.getString(3));
          contentVector.add(set.getString(4));
          contentVector.add(set.getString(5));
//          System.out.println(set.getObject(i).getClass().newInstance());
//          System.out.println(set.getString(i));
        }
        catch(Exception e){
          System.err.println(e.toString());
        }
//        }
      }
//      for(int i = 0; i<contentVector.size();i++){
//        System.out.println(contentVector.elementAt(i).toString());
//      }
      this.setColumnCount(colCount);
//      this.setDataVector(contentVector, colNameVector);
    }
    catch(SQLException e){
      System.out.println(e.toString());
    }

  }
  public MyTableModel() {

  }
}