Question

急求mysql数据库中表的内容怎么在netbeans中table表格中显示？

这是代码

try {
String url = "jdbc:mysql://localhost:3306/book?";
Class.forName("com.mysql.jdbc.Driver"); //注册
conn = DriverManager.getConnection(url, "root", "123456"); //连接
statement = conn.createStatement();
sql = "select * from book2 where book_id=" + colValue + "";
rs = statement.executeQuery(sql);
int i = 0;
int j = 0;
while (rs.next()) {
jTable1.setValueAt(rs.getString(1), i, j);
jTable1.setValueAt(rs.getString(2), i, j + 1);
jTable1.setValueAt(rs.getString(3), i, j + 2);
jTable1.setValueAt(rs.getString(4), i, j + 3);
jTable1.setValueAt(rs.getString(5), i, j + 4);
jTable1.setValueAt(rs.getString(6), i, j + 5);
jTable1.setValueAt(rs.getString(7), i, j + 6);
jTable1.setValueAt(rs.getString(8), i, j + 7);
i++;
j = 0;
}
} catch (Exception e) {
System.out.println(e);
}

• 你的回答被采纳后将获得：
• 系统奖励15（财富值+成长值）+难题奖励10（财富值+成长值）+提问者悬赏25（财富值+成长值）

Answer 1

获取数据库内容：
public static String getUserName(String ID){
String name = "";
try{
conn = new QQJDBCConnector().getConnection();
stmt=conn.createStatement();
sql="select user.name from user where user.ID = '"+ID+"'";
rs=stmt.executeQuery(sql);
while(rs.next()) {
name=rs.getString("name");
}
stmt.close() ;
conn.close() ;
}
catch (Exception e){
System.out.println(e.getMessage());
}
return name;
}