修改学生信息 java_Java课程设计---修改学生基本信息

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);

}

}

});