| 내용 |
src/main/java/kr/co/javaspecialist/employees/web/EmpController.java 에 추가
@RequestMapping("/update")
public String update(EmpVO emp) {
empRepository.updateEmp(emp);
return "redirect:/emp/list";
}
src/main/java/kr/co/javaspecialist/employees/model/IEmpRepository.java 에 추가
int updateEmp(EmpVO emp);
src/main/java/kr/co/javaspecialist/employees/model/EmpRepository.java 에 추가
public int updateEmp(EmpVO emp) {
String sql = "UPDATE EMPLOYEES SET FIRST_NAME=?, LAST_NAME=?, SALARY=? WHERE EMPLOYEE_ID=?";
return jdbcTemplate.update(sql, emp.getFirstName(), emp.getLastName(), emp.getSalary(), emp.getEmployeeId());
}
|