1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 | /********************Controller********************/ @RequestMapping(value="/reviewUpdateForm", method=RequestMethod.POST) @ResponseBody public BookReview reviewUpdateForm(int seq) { BookReview result = new BookReview(); result = dao.reviewSelect(seq); return result; } @RequestMapping(value="/reviewUpdate", method=RequestMethod.POST) @ResponseBody public int reviewUpdate(BookReview bookReview) { int result =0; result = dao.reviewUpdate(bookReview); return result; } /********************DAO********************/ public BookReview reviewSelect(int seq) { BookReview result=null; BookReviewMapper mapper = session.getMapper(BookReviewMapper.class); try { result = mapper.reviewSelect(seq); }catch(Exception e) { e.printStackTrace(); } return result; } public int reviewUpdate(BookReview bookReview) { int result = 0; BookReviewMapper mapper = session.getMapper(BookReviewMapper.class); try { result = mapper.reviewUpdate(bookReview); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } return result; } /********************Mapper********************/ <update id="reviewUpdate" parameterType="BookReview" > update BOOKREVIEW set name = #{name}, review = #{review} where SEQ = #{seq} </update> <select id ="reviewSelect" parameterType ="int" resultType="BookReview"> select SEQ ,NAME ,REVIEW ,REGDATE from BOOKREVIEW where SEQ = #{seq} </select> | cs |
'Spring' 카테고리의 다른 글
20190322 (0) | 2019.03.22 |
---|---|
학생등록 (0) | 2019.02.27 |
book.jsp (수정 추가) (0) | 2019.02.26 |
인터셉터, servlet-context.xml에 bean 추가 (0) | 2019.02.25 |
bookreview 결과화면 (0) | 2019.02.24 |
댓글