1、修改窗体
2、在StudentDao中增加修改学生信息的方法
/**
* 修改的方法
*
* @param student
* @return
* @throws SQLException
*/
public boolean update(Student student) throws SQLException {
DbUtil dbUtil = new DbUtil();
String sql = "update tb_student set name='" + student.getName() + "',sno='"
+ student.getSno() + "',sex='" + student.getSex()
+ "',classname='" + student.getClassName() + "' where id ='"
+ student.getId() + "'";
// 在控制台打印sql语句用于检查
System.out.println(sql);
// 处理并返回
return dbUtil.execute(sql);
}
3、在StudentService中增加修改服务
/**
* 修改学生信息服务
*
* @param student
* @return
* @throws SQLException
*/
public boolean editStudent(Student student) throws SQLException {
StudentDao studentDao = new StudentDao();
return studentDao.update(student);
}
4、给窗体中的表格添加点击事件
表格单击完整代码
table.addMouseListener(new MouseAdapter() {
@Override
public void mousePressed(MouseEvent e) {
int row = table.getSelectedRow();
textField_1.setText(table.getValueAt(row, 1) + "");
textField_2.setText(table.getValueAt(row, 2) + "");
String sex = table.getValueAt(row, 3) + "";
if ("男".equals(sex)) {
boy.setSelected(true);
} else if ("女".equals(sex)) {
girl.setSelected(true);
}
}
});