Ibatis-----SQLMAP分页SQL语句

    <select id="getShopPointList" parameterClass="jp.co.kai.dto.SearchDTO" resultClass="jp.co.kai.dto.SShopDTO">
       <![CDATA[
        SELECT
            M.SHOP_ID as shopId ,
            M.SHOP_NAME as shopName ,
            M.SHOP_POINT as shopPoint ,
            M.SHOP_DOMAIN_NAME as shopDomainName ,
            M.SHOP_FILESV_NO as shopFilesvNo ,
            M.SHOP_SIMPLE_INTRODUCE as shopSimpleIntroduce ,
            M.rowNumber
        FROM (
            SELECT
                B.SHOP_ID  ,
                B.SHOP_NAME  ,
                B.SHOP_POINT ,
                B.SHOP_DOMAIN_NAME ,
                B.SHOP_FILESV_NO ,
                B.SHOP_SIMPLE_INTRODUCE ,
                ROWNUM as rowNumber                
            FROM (
               SELECT DISTINCT
                    A.SHOP_ID  ,
                    A.SHOP_NAME  ,
                    A.SHOP_POINT ,
                    A.SHOP_DOMAIN_NAME ,
                    A.SHOP_FILESV_NO ,
                    A.SHOP_SIMPLE_INTRODUCE
                FROM
                    SHOP_VIEW A
                WHERE
                    A.SHOP_POINT > 0
                ]]>
                <isEqual property="level" compareValue="2">
                    <isNotEmpty  property="id">
                        AND A.FIELD_ID = #id#
                    </isNotEmpty>
                </isEqual>
                <isEqual  property="level" compareValue="1">
                    <isNotEmpty  property="id">
                        AND A.FIELD_CLASS_ID = #id#
                    </isNotEmpty>
                 </isEqual>
                    <isNotEmpty property="keywords">
                    <![CDATA[
                        AND
                     ]]>
                        <iterate property="keywords" conjunction="AND">
                           ( A.SHOP_NAME LIKE #keywords[]#
                           OR A.SHOP_SIMPLE_INTRODUCE LIKE #keywords[]#
                           OR A.SHOP_INTRODUCE LIKE #keywords[]#
                           OR A.SHOP_KEYWORD LIKE #keywords[]#
                           OR A.SHOP_KEYWORD_1 LIKE #keywords[]#
                           OR A.SHOP_KEYWORD_2 LIKE #keywords[]#
                           OR A.SHOP_KEYWORD_3 LIKE #keywords[]#
                           OR A.SHOP_KEYWORD_4 LIKE #keywords[]#
                           OR A.SHOP_KEYWORD_5 LIKE #keywords[]#
                           OR A.SHOP_KEYWORD_6 LIKE #keywords[]#
                           OR A.SHOP_KEYWORD_7 LIKE #keywords[]#
                           OR A.SHOP_KEYWORD_8 LIKE #keywords[]#
                           OR A.SHOP_KEYWORD_9 LIKE #keywords[]# )
                        </iterate>          
                    </isNotEmpty>              
                <![CDATA[
                ORDER BY
                    A.SHOP_POINT DESC ) B
            ) M
        WHERE
        ]]>
            <isNotEmpty property="rowNumEnd">
             <![CDATA[
             M.rowNumber <= #rowNumEnd#
             ]]>
            </isNotEmpty>
            <isNotEmpty property="rowNumStart">
             <![CDATA[
             AND M.rowNumber >= #rowNumStart#
             ]]>
            </isNotEmpty>
    </select>