bbs_t.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.bbs">
	<select id="total_count_of_bbs" resultType="int">
		SELECT COUNT(*) FROM BBS_T 
	</select>
	
	<select id="select_by_map" resultType="org.joonzis.vo.BVO" parameterType="Map">
		SELECT * FROM
		(SELECT rownum r_num, A.* FROM
		(SELECT * FROM BBS_T ORDER BY B_IDX DESC)A)
		WHERE r_num BETWEEN #{begin} and #{end}
	</select>
	<select id="bbs_by_idx" parameterType="int" resultType="org.joonzis.vo.BVO">
		SELECT * FROM BBS_T WHERE b_idx=#{b_idx}	
	</select>
	<update id="update_hit" parameterType="org.joonzis.vo.BVO">
		UPDATE BBS_T SET HIT=#{hit} WHERE B_IDX=#{b_idx}
	</update>
	<insert id="insert_bbs" parameterType="org.joonzis.vo.BVO">
		INSERT INTO BBS_T
		VALUES(
			bbs_seq.nextval,
			#{writer},
			#{title},
			#{content},
			#{pw},
			0,
			#{ip},
			#{filename},
			sysdate
		)
	</insert>
	<update id="update_bbs" parameterType="org.joonzis.vo.BVO">
		UPDATE BBS_T
		SET
			title=#{title},
			content=#{content},
			filename=#{filename},
			ip=#{ip}
		WHERE
			b_idx=#{b_idx}
	</update>
	<delete id="delete_bbs" parameterType="int">
		DELETE FROM BBS_T WHERE B_IDX = #{b_idx}
	</delete>
</mapper>