qq_a沙漏中的时光_0
代码:private void fillStudentTable(Student student) {
DefaultTableModel dtm = (DefaultTableModel) studentTable.getModel();//studentTable 为表格对象(Jtable)
dtm.setRowCount(0);// 清空表数据
Connection con = null;
PreparedStatement pstmt = null;
try {
con = dbUtil.getCon();
pstmt = studentDao.getPreparedStatement(con);
ResultSetMetaData rsmd = pstmt.getMetaData();
int num = rsmd.getColumnCount();// 获取元数据列数
num = (num - 6) / 2;// 去掉学号,id等,得到共有多少周
ResultSet rs = studentDao.list(con, student);
while (rs.next()) {
Vector v = new Vector();
v.add(rs.getString("id"));
v.add(rs.getString("studentNumber"));
v.add(rs.getString("studentName"));
v.add(rs.getString("className"));
v.add(rs.getString("mac"));
v.add(rs.getString("totalGrade"));
for (int i = 1; i <= num; i++) {
v.add(rs.getString("weekSign" + i));
v.add(rs.getString("weekGrade" + i));
}
dtm.addRow(v);
}
} catch (ClassNotFoundException e) {
JOptionPane.showMessageDialog(null, "mysql驱动异常");
e.printStackTrace();
} catch (SQLException e) {
JOptionPane.showMessageDialog(null, "签到情况获取失败");
e.printStackTrace();
} finally {
try {
dbUtil.closeCon(con);
} catch (Exception e) {
e.printStackTrace();
}
}
}