// 关键部分
Vector<String> columnNames = new Vector<String>();
Vector rows = new Vector();
//执行查询,并获取查询结果
try {
String sql = "select * from fnSubject";
con = DBConnection.getCon();
stmt = con.createStatement();
rs = stmt.executeQuery(sql);
ResultSetMetaData rsmd = rs.getMetaData();
int colNum = rsmd.getColumnCount();//得到列数
columnNames.clear();//清空集合中所有元素
for (int column = 0; column < colNum; column++) {
columnNames.addElement(rsmd.getColumnLabel(column + 1));
}
//获取所有行的信息,加入到向量rows中
rows.clear();//清空集合
while (rs.next()) {
Vector<Object> newRow = new Vector<Object>();
for (int i = 1; i <= colNum; i++) {
newRow.addElement(rs.getObject(i));
}
rows.addElement(newRow);
}
} catch (Exception ex) {
}
//使用查询到结果建立table,并显示table
JDialog jd1=new JDialog(this,"");
JTable book_table = new JTable(rows,columnNames);
JScrollPane scrollPane1 = new JScrollPane(book_table);
book_table.setPreferredScrollableViewportSize(new Dimension(500, 70));
jd1.getContentPane().add(scrollPane1, BorderLayout.CENTER);
jd1.setSize(450,150);
jd1.setLocation(550,100);
jd1.show();