<?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="org.joonzis.mapper.ReplyMapper">
<select id="getList" resultType="org.joonzis.domain.ReplyVO">
SELECT * FROM tbl_reply where bno=#{bno} order by rno desc
</select>
<select id="read" parameterType="long" resultType="org.joonzis.domain.ReplyVO">
select * from tbl_reply where rno=#{rno}
</select>
<insert id="insert" parameterType="org.joonzis.domain.ReplyVO">
INSERT INTO tbl_reply(rno, bno, reply, replyer)
VALUES(
seq_reply.nextval,
#{bno},
#{reply},
#{replyer}
)
</insert>
<delete id="delete">
delete from tbl_reply where rno=#{rno}
</delete>
<update id="update">
update tbl_reply set reply=#{reply}, updateDate = sysdate
where rno=#{rno}
</update>
<delete id="deleteAll">
delete tbl_reply where bno=#{bno}
</delete>
</mapper>
