| 내용 |
src/main/java/kr/co/javaspecialist/employees/web/EmpController.java 에 추가
@RequestMapping("/delete/{employeeId}")
public String delete(@PathVariable int employeeId, RedirectAttributes redirectAttrs) {
try {
empRepository.deleteEmp(employeeId);
}catch(RuntimeException e) {
redirectAttrs.addFlashAttribute("message", e.getMessage());
}
return "redirect:/emp/list";
}
src/main/java/kr/co/javaspecialist/employees/model/IEmpRepository.java 에 추가
int deleteEmp(int employeeId);
src/main/java/kr/co/javaspecialist/employees/model/EmpRepository.java 에 추가
public int deleteEmp(int employeeId) {
String sql = "DELETE FROM EMPLOYEES WHERE EMPLOYEE_ID=?";
return jdbcTemplate.update(sql, employeeId);
}
|