ibatis分页查询

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap namespace="sxzzStudentBank">
<resultMap id="sxzzStudentBankList" class="com.indoo.cedu.entity.SxzzStudentBank">
<result property="id" column="ID" />
<result property="bank" column="BANK" />
<result property="bankOther" column="BANKOTHER" />
<result property="account" column="ACCOUNT" />
<result property="dateStart" column="DATE_START" />
<result property="dateStop" column="DATE_STOP" />
<result property="status" column="STATUS" />
<result property="orgName" column="orgName" />
</resultMap>

<statement id="getSxzzStudentBankfy" resultMap="sxzzStudentBankList"
parameterClass="com.indoo.cedu.entity.ExtendSxzzStudentBank">
<![CDATA[
select p.ID,p.BANK,p.BANKOTHER,p.ACCOUNT ,p.DATE_START ,p.DATE_STOP,p.STATUS, orgName
from (select t.*,rownum rn from
( select bank.*, org.ORG_NAME orgName
from
SXZZ_STUDENT_BANK bank ,
BP_ORG org
where 1=1 and
bank.SCHOOL=org.ID
]]>
<dynamic>
<isNotEmpty prepend="and" property="school">
bank.SCHOOL=#school#
</isNotEmpty>
<isNotEmpty prepend="and" property="bank">
bank.BANK=#bank#
</isNotEmpty>
<isNotEmpty prepend="and" property="account">
bank.ACCOUNT like '%$account$%'
</isNotEmpty>
</dynamic>

<![CDATA[
order by bank.ID desc) t
where rownum <=(#startIndex#+#pageSize#)) p
where p.rn>#startIndex#
]]>
</statement>

<statement id="getSxzzStudentBankNum" resultClass="int"
parameterClass="com.indoo.cedu.entity.ExtendSxzzStudentBank">
<![CDATA[
select count(*) from SXZZ_STUDENT_BANK bank,BP_ORG org where 1=1 and bank.SCHOOL=org.ID
]]>
<dynamic>
<isNotEmpty prepend="and" property="school">
bank.SCHOOL=#school#
</isNotEmpty>
<isNotEmpty prepend="and" property="bank">
bank.BANK=#bank#
</isNotEmpty>
<isNotEmpty prepend="and" property="account">
bank.ACCOUNT like '%$account$%'
</isNotEmpty>
</dynamic>
</statement>

</sqlMap>