<?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.comment">
<select id="insertComment_t" parameterType="org.joonzis.ex.CVO">
INSERT INTO comment_t VALUES(
comment_seq.nextval,
#{writer},
#{content},
#{pw},
#{ip},
sysdate,
#{b_idx}
)
</select>
<select id="getCommentList" resultType="org.joonzis.ex.CVO" parameterType="int">
select * from comment_t where b_idx=#{b_idx}
</select>
<delete id="deleteComment_t" parameterType="int">
DELETE FROM comment_t WHERE c_idx=#{c_idx}
</delete>
</mapper>
