<select id="queryPo" parameterClass="po" resultClass="po"> <isGreaterThan property="start" compareValue="0"> SELECT * FROM (SELECT PO.*,ROWNUM rn FROM ( </isGreaterThan> <![CDATA[ SELECT * FROM PO ]]> <dynamic prepend="WHERE"> <isNotEmpty property="id"> <isGreaterThan property="id" compareValue="0" prepend="AND"> id=#id# </isGreaterThan> </isNotEmpty> <isNotEmpty property="poNo" prepend="AND"> poNo=#poNo# </isNotEmpty> </dynamic> <isGreaterThan property="limit" compareValue="0"> <![CDATA[ ) PO WHERE ROWNUM >= #start#) WHERE rn < #start#+#limit# ]]> </isGreaterThan> </select>
ibatis分页查询
最新推荐文章于 2021-02-08 05:25:47 发布