데이트피커에서 값 수정해준걸 ajax로타서 db값까지바꾸는 기능인데 기존값으로만 타네요

Question

<%=FormFieldRenderer.NUMBER("fixedNumberUpdate", "fixedNumber", "input_15", null, "과정기수를 입력해주세요.", null, "{{class_seq}}", true, 0f, 100000f)%> <%=FormFieldRenderer.DATEPICKER("course_class_update_date4", "classStartDate", null, null, "교육기간 시작일을 입력해주세요.", "{{class_start_date}}", "YYYY-MM-DD") %> ~ <%=FormFieldRenderer.DATEPICKER("course_class_update_date5", "classEndDate", null, null, "교육기간 종료일을 입력해주세요.", "{{class_end_date}}", "YYYY-MM-DD") %> $(document).on("click","input[name=fixedNumber]", function () { fixed_period_action(courseCategory, courseCode, classSeq, siteId, classStartDate, classEndDate); }); function fixed_period_action(courseCategory, courseCode,classSeq) { if (courseCategory.indexOf("TRA") > -1 && courseCode !== "") { $.ajax({ url: "<%=WEB_ROOT%>courseClass/periodConfirmClass", type: 'POST', data:{"course_category": courseCategory, "course_code": courseCode, "class_seq":classSeq, "site_id":siteId, "class_start_date": classStartDate, "class_end_date": classEndDate}, success: function(response) { alert("기간확정되었습니다."); }, error: function(request, status, error) { alert("ERROR CODE:" + request.status); } }); } else { alert("기간확정되지 않았습니다."); } } @RequestMapping(value="/periodConfirmClass", method=RequestMethod.POST) @ResponseBody public WevenJsonResult periodConfirmClass(@RequestParam(value="course_category") String courseCategory, @RequestParam(value="course_code") int courseCode, @RequestParam(value="class_seq") int classSeq, @RequestParam(value="site_id") String siteId, @RequestParam(value="class_start_date") String classStartDate, @RequestParam(value="class_end_date") String classEndDate ){ try{ System.err.println("courseCategory : " + courseCategory); System.err.println("courseCode : " + courseCode); System.err.println("classSeq : " + classSeq); System.err.println("siteId : " + siteId); System.err.println("classStartDate :" + classStartDate); System.err.println("classEndDate :" + classEndDate); // 기간확정 처리 this.service.periodConfirmClass(courseCategory,courseCode,classSeq,siteId,classStartDate,classEndDate); return this.out.JSON(true, null, "성공"); } catch(CourseServiceException e){ return this.out.JSON(false, null, "처리 중 에러가 발생하였습니다."); } }public void periodConfirmClass(int courseCode, String courseCategory, int classSeq, String siteId, String classStartDate, String classEndDate){ Map params = new HashMap(); params.put("courseCode",courseCode); params.put("courseCategory",courseCategory); params.put("classSeq",classSeq); params.put("siteId",siteId); params.put("classStartDate",classStartDate); params.put("classEndDate",classEndDate); this.getSqlSession().update("weven.course.class.periodConfirmClass",params); }@Transactional(propagation=Propagation.REQUIRED, rollbackFor={CourseServiceException.class})public void periodConfirmClass(String courseCategory,int courseCode,int classSeq,String siteId, String classStartDate, String classEndDate){ try{ this.dao.periodConfirmClass(courseCode,courseCategory,classSeq,siteId,classStartDate,classEndDate); } catch(CourseServiceException e){ throw new CourseServiceException("기간확정 처리 중 에러가 발생하였습니다.");}} UPDATE COURSE_CLASS SET PERIOD_CONFIRM = 'Y', CLASS_START_DATE= #{classStartDate}, CLASS_END_DATE= #{classEndDate} WHERE 1=1 AND COURSE_CODE= #{courseCode} AND CLASS_SEQ= #{classSeq} AND SITE_ID= #{siteId} 소스를 이런식으로 짰는데 데이트피커 클릭해서 다른날짜 고르면 기존값으로만 타고바뀐값으로 안타네요

데이트피커에서 값 수정해준걸 ajax로타서 db값까지바꾸는 기능인데 기존값으로만 타네요

0개의 답변

Q&A 목록