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