Oracle 的分页查询，myBatis 配置文件

前端送的参数：

start - 开始记录数，rowStart ，从 0 开始

limit - 每页记录数，pageSize

    <!-- Oracle 11g -->
    
    <select id="selectList" parameterType="category.Bean"
        resultType="category.Bean">
        
        <![CDATA[  
        
        SELECT * FROM 
        (
            SELECT A.*, ROWNUM rowNumber 
            FROM (
                SELECT 
                    "id",
                    "groupCode",
                    "parentId",
                    "number",
                    "name",
                    "description",
                    "value",
                    "status",
                    "insertedDatetime",
                    "insertUserId",
                    "checkedDatetime",
                    "checkerId",
                    "comment"
                FROM "t_category"
                where 1=1                
                    ]]>
                
                    <if test="id!=null and id != '' and id != '0'"> and "id" = #{id}</if>
                    <if test="groupCode!=null and groupCode != ''"> and "groupCode" = #{groupCode}</if>
                    <if test="parentId!=null and parentId != ''"> and "parentId" = #{parentId}</if>
                    <if test="number!=null and number != ''"> and "number like '%${number}%'</if>
                    <if test="name!=null and name != ''"> and "name" like '%${name}%'</if>
                    <if test="description!=null and description != ''"> and "description" = #{description}</if>
                    <if test="value!=null and value != ''"> and "value" = #{value}</if>
                    <if test="status!=null and status != ''"> and "status" = #{status}</if>
                    <if test="insertedDatetime!=null and insertedDatetime != ''"> and "insertedDatetime" = #{insertedDatetime}</if>
                    <if test="insertUserId!=null and insertUserId != ''"> and "insertUserId" = #{insertUserId}</if>
                    <if test="checkedDatetime!=null and checkedDatetime != ''"> and "checkedDatetime" = #{checkedDatetime}</if>
                    <if test="checkerId!=null and checkerId != ''"> and "checkerId" = #{checkerId}</if>
                    <if test="comment!=null and comment != ''"> and "comment" = #{comment}</if>
                    
                    <![CDATA[ 
                    
                ) A   
            WHERE ROWNUM <= ( #{start} + #{limit} )
        )
        WHERE rowNumber > #{start}
        
        ]]>
        
    </select>