orcal 分页语句

<select id="selectPageList" parameterType="Map" resultMap="loanFaceIdentifyMainTaskResultMap">
    select * from (select t.*,rownum rownu from LOAN_FACE_IDENTIFY_MAIN_TASK t
    where rownum &lt;=#{limit}
    <if test="customerManagerNumber != null and customerManagerNumber != ''">
        and customer_manager_number LIKE #{customerManagerNumber}
    </if>

    <if test="loanBusinessSerialNumber != null and loanBusinessSerialNumber != ''">
        and loan_business_serial_number LIKE #{loanBusinessSerialNumber}
    </if>

    <if test="idNumber != null and idNumber != ''">
        and id_number LIKE #{idNumber}
    </if>

    <if test="customerName != null and customerName != ''">
        and customer_name LIKE #{customerName}
    </if>)tt
    where tt.rownu &gt;=#{start} and tt.rownu &lt;=#{limit}
</select>

 

 

两层分页  先根据条件查 然后再分页