创建一个JDBC表格模型代码,Java代码库,德仔网

代码语言
代码分类
【Java】创建一个JDBC表格模型
作者:DDT / 发布于2012/6/12/ 484
创建一个JDBC表格模型
import javax.swing.*; 
import javax.swing.table.*; 
import java.sql.*; 
import java.util.*;
/** an immutable table model built from getting 
metadata about a table in a jdbc database 
*/ 
public class JDBCTableModel extends AbstractTableModel {
Object[][] contents;
String[] columnNames;
Class[] columnClasses;</div>
<div>public JDBCTableModel (Connection conn,
 String tableName)
throws SQLException {
super();
getTableContents (conn, tableName);</div>
<div>}
protected void getTableContents (Connection conn,
 String tableName)
throws SQLException {</div>
<div>// get metadata: what columns exist and what
// types (classes) are they?
DatabaseMetaData meta = conn.getMetaData();
System.out.println ("got meta = " + meta);
ResultSet results =
meta.getColumns (null, null, tableName, null) ;
System.out.println ("got column results");
ArrayList colNamesList = new ArrayList();
ArrayList colClassesList = new ArrayList();
while (results.next()) {
colNamesList.add (results.getString ("COLUMN_NAME")); 
System.out.println ("name: " + 
results.getString ("COLUMN_NAME"));
int dbType = results.getInt ("DATA_TYPE");
switch (dbType) {
case Types.INTEGER:
colClassesList.add (Integer.class); break; 
case Types.FLOAT:
colClassesList.add (Float.class); break; 
case Types.DOUBLE: 
case Types.REAL:
colClassesList.add (Double.class); break; 
case Types.DATE: 
case Types.TIME: 
case Types.TIMESTAMP:
colClassesList.add (java.sql.Date.class); break; 
default:
colClassesList.add (String.class); break; 
}; 
System.out.println ("type: " +
results.getInt ("DATA_TYPE"));
}
columnNames = new String [colNamesList.size()];
colNamesList.toArray (columnNames);
columnClasses = new Class [colClassesList.size()];
colClassesList.toArray (columnClasses);

// get all data from table and put into
// contents array</div>
<div>Statement statement =
conn.createStatement ();
results = statement.executeQuery ("SELECT * FROM " +
 tableName);
ArrayList rowList = new ArrayList();
while (results.next()) {
ArrayList cellList = new ArrayList(); 
for (int i = 0; i<columnClasses.length; i++) { 
Object cellValue = null;</div>
<div>
if (columnClasses[i] == String.class) 
cellValue = results.getString (columnNames[i]); 
else if (columnClasses[i] == Integer.class) 
cellValue = new Integer ( 
results.getInt (columnNames[i])); 
else if (columnClasses[i] == Float.class) 
cellValue = new Float ( 
results.getInt (columnNames[i])); 
else if (columnClasses[i] == Double.class) 
cellValue = new Double ( 
results.getDouble (columnNames[i]));
else if (columnClasses[i] == java.sql.Date.class) 
cellValue = results.getDate (columnNames[i]); 
else 
System.out.println ("Can't assign " + 
columnNames[i]);
cellList.add (cellValue);
}// for
Object[] cells = cellList.toArray();
rowList.add (cells);

} // while
// finally create contents two-dim array
contents = new Object[rowList.size()] [];
for (int i=0; i<contents.length; i++)</div>
<div>contents[i] = (Object []) rowList.get (i);
System.out.println ("Created model with " +
 contents.length + " rows");</div>
<div>// close stuff
results.close();
statement.close();</div>
<div>}
// AbstractTableModel methods
public int getRowCount() {
return contents.length;
}
<div>public int getColumnCount() {
if (contents.length == 0)
return 0;
else
return contents[0].length;
}
<div>public Object getValueAt (int row, int column) {
return contents [row][column];
}
<div>// overrides methods for which AbstractTableModel
// has trivial implementations</div>
<div>public Class getColumnClass (int col) {
return columnClasses [col];
}
<div>public String getColumnName (int col) { 
return columnNames [col]; 
} 
}
</div>
试试其它关键字
　JDBC表格模型　
同语言下
可能有用的
DDT贡献的其它代码(160)