java 페이징

java 와 ibatis를 이용한 페이징

egovFramework 사용중 적용

1. ibatis

<select id="selectTestDB" parameterClass="egovMap" resultClass="egovMap">

SELECT *

FROM (

SELECT 

ROWNUM AS RNUM

FROM TB_TEST_TABLE

WHERE 1=1

<isNotEmpty prepend="AND" property="endNum">

AND ROWNUM <= #endNum#

</isNotEmpty>

)WHERE 1=1

<isNotEmpty prepend="AND" property="startNum">

AND RNUM <= #startNum#

</isNotEmpty>

</select>

2. java

// 파라미터 pageNo와 numOfRows를 받는다.

int startNum = (pageNo-1)*numOfRows+1; 

int endNum = pageNo*numOfRows;

EgovMap em = new EgovMap();

em.put("startNum",startNum);

em.put("endNum",endNum);