Spring
ReviewMapper.xml
Birthmark
2019. 2. 24. 17:30
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 | <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="global.sesoc.test.dao.BookReviewMapper"> <insert id="reviewWrite" parameterType="BookReview"> insert into BOOKREVIEW( SEQ, NAME, REGDATE, REVIEW )VALUES( bookreview_seq.NEXTVAL, #{name}, DEFAULT, #{review} ) </insert> <select id="reviewList" resultType="BookReview"> select SEQ, NAME, REGDATE, REVIEW from BOOKREVIEW order by REGDATE DESC </select> <delete id="reviewDelete" parameterType="int"> delete BOOKREVIEW where SEQ = #{seq} </delete> </mapper> | cs |