View Javadoc
   package net.plugin.sql.gui.model.table;
   
   import net.plugin.sql.beans.DataSource;
   import net.plugin.sql.util.JDBCConnectionManager;
   import net.plugin.sql.util.DataSourceException;
   
   import javax.swing.table.AbstractTableModel;
   import javax.swing.*;
   import java.sql.*;
  import javax.sql.RowSet;
  import javax.sql.RowSetEvent;
  import javax.sql.RowSetListener;
  
  import sun.jdbc.rowset.CachedRowSet;
  
  public class CachedRowSetTableInfoModel extends AbstractTableModel implements RowSetListener {
      private RowSet rowSet = null;
  
      private static final String[] HEADERS = {"Name", "Type", "Length", "Nullable"};
  
      public CachedRowSetTableInfoModel(RowSet set) {
          super();
          rowSet = set;
          rowSet.addRowSetListener(this);
      }
  
      public void cursorMoved(RowSetEvent event) {
      }
  
      public Class getColumnClass(int column) {
          String cname = "java.lang.String";
          switch (column) {
              case 2:
                  {
                      cname = "java.lang.Integer";
                      break;
                  }
              case 3:
                  {
                      cname = "java.lang.Boolean";
                      break;
                  }
          }
          try {
              return Class.forName(cname);
          } catch (Exception e) {
              e.printStackTrace();
              return super.getColumnClass(column);
          }
      }
  
      public int getColumnCount() {
          return HEADERS.length;
      }
  
      public String getColumnName(int col) {
          return HEADERS[col];
      }
  
      public int getRowCount() {
          try {
              ResultSetMetaData meta = rowSet.getMetaData();
              if (meta == null) {
                  return 0;
              }
              return meta.getColumnCount();
          } catch (SQLException e) {
              return 0;
          }
      }
  
      public Object getValueAt(int row, int col) {
          try {
              ResultSetMetaData meta = rowSet.getMetaData();
              switch (col) {
                  case 0:
                      {
                          return meta.getColumnName(row+1);
                      }
                  case 1:
                      {
                          return meta.getColumnTypeName(row+1);
                      }
                  case 2:
                      {
                          return new Integer(meta.getColumnDisplaySize(row+1));
                      }
                  case 3:
                      {
                          if (meta.isNullable(row+1) == ResultSetMetaData.columnNullable)
                              return new Boolean(true);
                          return new Boolean(false);
                      }
  
              }
          } catch (SQLException e) {
              return null;
          }
          return null;
     }
 
     public void rowChanged(RowSetEvent event) {
         try {
             int row = rowSet.getRow();
 
             if (rowSet.rowDeleted()) {
                 fireTableRowsDeleted(row, row);
             } else if (rowSet.rowInserted()) {
                 fireTableRowsInserted(row, row);
             } else if (rowSet.rowUpdated()) {
                 fireTableRowsUpdated(row, row);
             }
         } catch (SQLException e) {
         }
     }
 
     public void rowSetChanged(RowSetEvent event) {
         fireTableStructureChanged();
     }
 
     public void setValueAt(Object value, int row, int column) {
         try {
             if (!rowSet.absolute(row + 1)) {
                 return;
             }
             rowSet.updateObject(column + 1, value);
         } catch (SQLException e) {
         }
     }
 
     public static void main(String[] args) {
         DataSource ds = new DataSource();
         ds.setName("Test");
         ds.setDriver("oracle.jdbc.driver.OracleDriver");
         ds.setUrl("jdbc:oracle:thin:@hades.genscape.com:1581:test");
         ds.setUser("genscape");
         ds.setPassword("gentest");
         JDBCConnectionManager manager = new JDBCConnectionManager(ds);
         Connection con = null;
         Statement stmt = null;
         ResultSet rs = null;
         CachedRowSet crs = null;
         try {
             con = manager.getConnection();
             stmt = con.createStatement();
             rs = stmt.executeQuery("select * from plant");
             stmt.setMaxRows(25);
             crs = new CachedRowSet();
             crs.populate(rs);
         } catch (DataSourceException e) {
             e.printStackTrace();
         } catch (SQLException e) {
             e.printStackTrace();
         } finally {
             try {
                 rs.close();
                 stmt.close();
                 con.close();
             } catch (SQLException e) {
                 e.printStackTrace();
             }
         }
         JFrame frame = new JFrame("Test");
 //        CachedRowSetTableInfoModel model = new CachedRowSetTableInfoModel(crs);
         CachedRowSetTableInfoModel infoModel = new CachedRowSetTableInfoModel(crs);
         JTable table = new JTable(infoModel);
         JScrollPane jScrollPane = new JScrollPane(table);
         frame.getContentPane().add(jScrollPane);
         frame.pack();
         frame.show();
     }
 
 }