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