BoardMapper.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.mapper.BoardMapper">
	
	<select id="getListWithPaging" resultType="org.joonzis.domain.BoardVO">
		<![CDATA[
			select bno,title, content, writer, regdate, updatedate, replycnt from 
			(SELECT /*+index_desc(tbl_board pk_board)*/
			ROWNUM rn, bno,title, content,writer,regdate,updatedate,replycnt from tbl_board
			where rownum <= #{pageNum} * #{amount} )   
			where rn > (#{pageNum} - 1) * #{amount}
		]]>
	</select>
	
	<insert id="insert" parameterType="org.joonzis.domain.BoardVO">
		INSERT INTO tbl_board
		VALUES(
			seq_board.nextval,
			#{title},
			#{content},
			#{writer},
			  sysdate,
			  sysdate,
			  0
		)
	</insert>
	
	<select id="read" parameterType="long" resultType="org.joonzis.domain.BoardVO">
		select * from tbl_board where bno=#{bno}
	</select>
	
	<delete id="delete" parameterType="long">
	 	delete from tbl_board where bno=#{bno}
	</delete>
	
	<update id="update" parameterType="org.joonzis.domain.BoardVO">
		update tbl_board set title=#{title}, content=#{content}, writer=#{writer}, updateDate = sysdate
		where bno=#{bno} 
	</update>
	
	<select id="getTotalCount" resultType="int">
		select count(*) from tbl_board where bno > 0	
	</select>
	
	<update id="updateReplyCnt">
		update tbl_board set replycnt = replycnt + #{amount} where bno=#{bno}
	</update>
	
	<select id="getMaxBno" resultType="long">
		select max(bno) from tbl_board
	</select>
</mapper>