将数据库的信息显示在窗体表格上
新手上路,请多关照{:10_333:}在做学生信息管理系统,要在窗体表格上显示全部信息,弄了几次都失败了{:10_266:} 。求大神帮忙,有代码最好啦{:5_91:}
感谢!
新鲜的错误代码为大神们献上,列的名字显示不出来?{:5_94:}
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.swing.JFrame;
import javax.swing.JTable;
import com.cdd.jdbc.GetConn;
public class Main {
public static void main(String[] args) {
frame A = new frame();
}
}
class frame extends JFrame {
public frame() {
int j = 0, i = 0;
String sql2 = "select *from student_information order by userID";
String sql1 = "select *from student_information";
String B[] = { "学号", "姓名", "性别", "生日", "民族", "年纪", "专业" };
setSize(400, 400);
setResizable(true);
setVisible(true);
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
GetConn getconn = new GetConn();
Connection conn = getconn.getConnection();
try {
Statement statement1 = conn.createStatement();
ResultSet resultSet1 = statement1.executeQuery(sql1);
while (resultSet1.next()) {
i++;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
Object A[][] = new Object;
Statement statement2;
try {
statement2 = conn.createStatement();
ResultSet resultSet2 = statement2.executeQuery(sql2);
while (resultSet2.next()) {
A = resultSet2.getString("userID");
A = resultSet2.getString("name");
A = resultSet2.getString("sex");
A = resultSet2.getInt("birdathy");
A = resultSet2.getString("nation");
A = resultSet2.getInt("class");
A = resultSet2.getString("zhaunye");
j++;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
JTable jTable1 = new JTable(A, B);
add(jTable1);
}
}
Clown10101010 发表于 2017-6-21 15:52
新鲜的错误代码为大神们献上,列的名字显示不出来?
在上述代码第 60 行和第 61 行之间写下这两句
JScrollPane scroll = new JScrollPane(jTable1);
add(scroll);
把 add(jTable1) 注释掉
页:
[1]