Question

MySQL表格如何在netbeans的Jtable中输出

我用netbeans的GUI做了一个表格JTABLE1，如何把MySQL表格如何在netbeans的Jtable中输出，如何编写代码包括数据库的链接?请详细一点回答，感激不尽

Answer 1

连接数据库
public QQJDBCConnector() {
url="jdbc:mysql://localhost/rQQ?useUnicode=true&characterEncoding=utf-8";
user="root";
pws="104814";
conn=null;
}

public Connection getConnection() {
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
conn=DriverManager.getConnection(url,user,pws);
}
catch (Exception e) {
System.out.println("Error occurred obtaining connection");
System.out.println(e.getMessage());
}
return conn;
}
url="jdbc:mysql://localhost/rQQ?useUnicode=true&characterEncoding=utf-8";中rQQ表示你所要连接的数据库名

获取数据库内容：
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;
}