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>