| 내용 |
src/main/java/kr/co/javaspecialist/employees/web/EmpController.java 에 추가
@RequestMapping(value="/insert", method=RequestMethod.GET)
public String insert() {
return "/emp/details";
}
@RequestMapping(value="/insert", method=RequestMethod.POST)
public String insert(EmpVO emp, RedirectAttributes redirectAttrs) {
try {
empRepository.insertEmp(emp);
}catch(RuntimeException e) {
redirectAttrs.addFlashAttribute("message", e.getMessage());
}
return "redirect:/emp/list";
}
src/main/java/kr/co/javaspecialist/employees/model/IEmpRepository.java 에 추가
int insertEmp(EmpVO emp);
src/main/java/kr/co/javaspecialist/employees/model/EmpRepository.java 에 추가
public int insertEmp(EmpVO emp) {
String sql = "INSERT INTO EMPLOYEES (EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, "
+ " HIRE_DATE, JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
return jdbcTemplate.update(sql, emp.getEmployeeId(), emp.getFirstName(), emp.getLastName(), emp.getEmail(), emp.getPhoneNumber(), emp.getHireDate(), emp.getJobId(), emp.getSalary(), emp.getCommissionPct(), emp.getManagerId(), emp.getDepartmentId());
}
|