<select id="selectForList" resultMap="userResult" parameterClass="java.util.Map">
select p.* from (select t.*,rownum from UTAA_USER t
<isParameterPresent>
<include refid="User-Where" />
<isPropertyAvailable property="ABATOR_ORDER_BY_CLAUSE">
order by $ABATOR_ORDER_BY_CLAUSE$
</isPropertyAvailable>
) p where 1=1
<isPropertyAvailable property="rowStartNum">
and p.rownum >= $rowStartNum$
</isPropertyAvailable>
<isPropertyAvailable property="rowEndNum">
<![CDATA[and p.rownum <= $rowEndNum$]]>
</isPropertyAvailable>
</isParameterPresent>
<isNotParameterPresent>
) p
</isNotParameterPresent>
</select>
select p.* from (select t.*,rownum from UTAA_USER t
<isParameterPresent>
<include refid="User-Where" />
<isPropertyAvailable property="ABATOR_ORDER_BY_CLAUSE">
order by $ABATOR_ORDER_BY_CLAUSE$
</isPropertyAvailable>
) p where 1=1
<isPropertyAvailable property="rowStartNum">
and p.rownum >= $rowStartNum$
</isPropertyAvailable>
<isPropertyAvailable property="rowEndNum">
<![CDATA[and p.rownum <= $rowEndNum$]]>
</isPropertyAvailable>
</isParameterPresent>
<isNotParameterPresent>
) p
</isNotParameterPresent>
</select>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货