resultset的jtable显示santino的专栏csdnblog

1、resultset 的 jtable 显示 santino 的专栏 csdnblogResultSet 的 JTable 显示import java.sql.ResultSet;import java.sql.ResultSetMetaData;import java.sql.SQLException;import java.util.Vector;import javax.swing.JOptionPane;import javax.swing.JTable;import javax.swing.table.DefaultTableModel;public class Utilities /

2、* 功能：实现结果集的表格显示*/public static void displayResultSet(JTable table, ResultSetrs)throws SQLException /rs.beforeFirst();/ 指针移到第一条记录前面 boolean hasRecords = rs.next();if (!hasRecords) / 记录集为空，提示一条消息 JOptionPane.showMessageDialog(table, " 无相关记录 ", "Check your input!",JOptionPane.ERROR_

3、MESSAGE);return;Vector<String> columnHeads = newVector<String>();/用于存储表头字段(列名 )Vector<Vector> rows = newVector<Vector>();/用于存储记录行try / 获取字段的名称ResultSetMetaData rsmd = rs.getMetaData(); for (int i = 1; i <= rsmd.getColumnCount();+i)column

4、Heads.addElement(rsmd.getColumnName(i);do /获取记录集rows.addElement(getNextRow(rs, rsmd); while (rs.next();/ 建立相应的 TableModel, 并将 TableModel 应用到 Table 中显示出来DefaultTableModel model = newDefaultTableModel(rows, columnHeads); table.setModel(model); return; catch (SQLException exc) JOptionPane.showMessageDi

5、alog(table,exc.toString(),"Check your input!",JOptionPane.ERROR_MESSAGE);return;/* 被 displayResultSet(JTable table, ResultSet rs)调用 , 以 Vector 形式返回一个记录行*/private static Vector getNextRow(ResultSet rs, ResultSetMetaData rsmd)throws SQLException Vector<String> currentRow = newVector<String>();for (int i = 1; i <= rsmd.get