ibatis 分页查询只需写一条sql的方法

这里是ORALCE。

mysql也可以参考。思路是一样的。

sqlmap

<select id="selectAccType" resultClass="java.util.HashMap"
		parameterClass="com.xx.acctype.dto.AccTypeQueryDTO"
		remapResults="true">
		<include refid="Commons.prefixSql" />
		select T2.ACC_TYPE_ID as "accTypeId", T2.ACC_TYPE_NAME as
		"accTypeName",
		DECODE(T2.ISSUER_ID,0,T3.ISSUER_GROUP_NAME,T1.ISSUER_NAME) as
		"issuerName" from TB_ENT_ISSUER T1, TB_ENT_ACCTYPE T2,
		TB_ENT_ISSUER_GROUP T3 where T1.ISSUER_ID(+)=T2.ISSUER_ID and
		T3.ISSUER_GROUP_ID(+)=T2.ISSUER_GROUP_ID and T2.DATA_STATE = 1
		<dynamic>
			<isNotEmpty prepend="and" property="accTypeId">
				ACC_TYPE_ID = #accTypeId:DECIMAL#
			</isNotEmpty>
</dynamic>
		<include refid="Commons.suffixSql" />
	</select><