oracle分页在ibatis中配置代码块

<sql id="paginationStart">
        <dynamic>
            <isNotEqual property="pagination" compareValue="false">
            <![CDATA[ select * from (select row_.*,rownum rownum_ from ( ]]>
            </isNotEqual>
        </dynamic>
    </sql>

    <sql id="paginationEnd">
        <dynamic>
            <isNotEqual property="pagination" compareValue="false">
            <![CDATA[ ) row_ where rownum <= #end#) where rownum_ > #start# ]]>
            </isNotEqual>
        </dynamic>
    </sql>

    <sql id="orderBy">
        <isNotEmpty property="sort">
        <![CDATA[ ORDER BY $sort$ $dir$ ]]>
        </isNotEmpty>
    </sql>

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!