我的数据库中有一些记录,我想在我的java应用程序GUI的Jtable上显示这些记录。我已经自定义了 Jtable,并添加了一些不在我的数据库中的额外列。请协助。下面的代码只在单列中显示一条记录(具体说明列(
public NewJFrame() {
ArrayList data = new ArrayList();
initComponents();
okay.setVisible(true);
try {
String myDriver = "com.mysql.cj.jdbc.Driver";
String myUrl = "jdbc:mysql://localhost:3306/lostfound";
Class.forName(myDriver);
Connection c = DriverManager.getConnection(myUrl, "root", "");
String sql = "SELECT * FROM found";
Statement st = c.createStatement();
// execute the query, and get a java resultset
ResultSet rs =st.executeQuery(sql);
while(rs.next())
{
String name = rs.getString("name");
String description = rs.getString("description");
String location = rs.getString("location");
jTable2.getModel().setValueAt(name, WIDTH, ICONIFIED);
jTable2.getModel().setValueAt(description, WIDTH, ICONIFIED);
jTable2.getModel().setValueAt(location, WIDTH, ICONIFIED);
}
}
catch (SQLException e)
{
System.out.println( e.getMessage() );
} catch (ClassNotFoundException ex) {
Logger.getLogger(NewJFrame.class.getName()).log(Level.SEVERE, null, ex);
}
jTable2.show();
}
您将resultSet
数据分配给单个行和列,您需要一个row
计数器并为每个行递增它,如下所示:
int row=0;
while(rs.next()) {
String name = rs.getString("name");
String description = rs.getString("description");
String location = rs.getString("location");
jTable2.getModel().setValueAt(name, row, 0);//name at column 0 always
jTable2.getModel().setValueAt(description, row, 1);//desc at column 1 always
jTable2.getModel().setValueAt(location, row, 2);//location at column 2 always
row++;//increment row counter for each record
}