comment.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.mybatis.mapper.comment">
	<select id="comment_count_by_idx" parameterType="int" resultType="int">
		SELECT COUNT(*) FROM COMMENT_T WHERE B_IDX=#{b_idx}
	</select>
	<insert id="insert_comment" parameterType="org.joonzis.vo.CVO">
		INSERT INTO COMMENT_T 
		VALUES(
			comment_seq.nextval,
			#{writer},
			#{content},
			#{pw},
			#{ip},
			sysdate,
			#{b_idx}
		)
	</insert>
	<select id="select_comm_by_bidx" parameterType="int" resultType="org.joonzis.vo.CVO">
		SELECT * FROM COMMENT_T WHERE B_IDX=#{b_idx}
	</select>
	<delete id="delete_comm_by_cidx" parameterType="int">
		DELETE FROM COMMENT_T WHERE C_IDX=#{c_idx}
	</delete>
	<delete id="delete_all_comm" parameterType="int">
		DELETE FROM COMMENT_T WHERE B_IDX=#{b_idx}
	</delete>
</mapper>