<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>
转载于:https://www.cnblogs.com/qq1988627/archive/2011/08/02/6606900.html