private Schedule mapData(ResultSet rs) throws SQLException {
Schedule schedule = new Schedule();
schedule.setApplicantId(rs.getInt("applicant_id"));
schedule.setInterviewer(rs.getInt("interviewer"));
schedule.setMessageForApplicant(rs.getString("message_for_applicant"));
schedule.setMessageForInterviewer(rs.getString("message_for_interviewer"));
schedule.setRemarks(rs.getString("remarks"));
schedule.setScheduleDate(rs.getDate("schedule_date"));
schedule.setScheduleTime(rs.getTime("schedule_time"));
schedule.setEditDate(rs.getDate("edit_date"));
schedule.setScheduleId(rs.getInt("schedule_id"));
schedule.setScheduleStatus(rs.getBoolean("schedule_status"));
/*if(rs.getTime("schedule_time")!=null){
schedule.setScheduleTime(rs.getTime("schedule_time"));
}*/
return schedule;
}
@RequestMapping(value = "update", method = RequestMethod.POST)
public String update(
@ModelAttribute(value = "Schedule") Schedule schedule, @Context HttpServletRequest request)
throws ParseException {
schedule.setScheduleId(Integer.parseInt(request.getParameter("id")));
DateFormat formatDate = new SimpleDateFormat("yyyy-MM-dd");
Date formatedDate = formatDate.parse(request.getParameter("schedule_date"));
schedule.setScheduleDate(formatedDate);
SimpleDateFormat sdf = new SimpleDateFormat("HH:mm");
Date SimpleDateFormat = sdf.parse(request.getParameter("schedule_time"));
schedule.setScheduleTime(SimpleDateFormat);
Calendar calendar = Calendar.getInstance();
schedule.setEditDate(calendar.getTime());
scheduleService.update(schedule);
return "redirect:/admin/schedule";
}