ibatis分页查询

最新推荐文章于 2024-06-20 10:42:47 发布

weixin_30455067

最新推荐文章于 2024-06-20 10:42:47 发布

阅读量105

点赞数

原文链接：http://www.cnblogs.com/qq1988627/archive/2011/08/02/6606900.html

版权

<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