ReplyMapper.xml

<?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>