java使用netbeans从jtable中的mysql检索数据
我正在尝试将数据从数据库检索到jTable中。我使用NetBeans 8.1。我不能让它工作
我使用此代码插入:
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
String name = jTextField1.getText();
String father = jTextField2.getText();
String mother = jTextField3.getText();
String line1 = jTextField4.getText();
String line2 = jTextField5.getText();
String line3 = jTextField11.getText();
String roll = jTextField6.getText();
String school = jTextField7.getText();
String hobby1 = jTextField8.getText();
String hobby2=jTextField9.getText();
String hobby3 = jTextField10.getText();
String address = line1 + " " + line2 + " " + line3;
//String hobby = hobby1 + " " + hobby2 + " " + hobby3;
java.text.SimpleDateFormat fmt = new java.text.SimpleDateFormat("dd-MM-yyyy");
String date = fmt.format(jDateChooser1.getDate());
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection(
"jdbc:mysql://127.0.0.1:3306/pritam", "root", "root");
PreparedStatement ps = con.prepareStatement(
"insert into basic_info values(?,?,?,?,?,?,?)");
ps.setString(1, name);
ps.setString(2, father);
ps.setString(3, mother);
ps.setString(4, roll);
ps.setString(5, date);
ps.setString(6 ,address);
// ps.setString(7, hobby);
ps.setString(7, school);
ps.executeUpdate();
con.close();
}catch(Exception E) {
System.out.println(E);
}
如何检索jTable中的数据
# 1 楼答案
您需要实现一个AbstractTableModel,如下所示:(我在这里只是举个例子)
NameTableModel。java
NameStoreUI。java
名道。java
我希望你了解这个概念