mybaits 分页查询

	<select id="selectByMapSum" resultType="LONG" parameterType="map">
		select count(*)
		from tableName
		where  1=1 
		<if test="loanAcNo != null">
			and loanAcNo in
		<foreach item="item" index="index" collection="loanAcNo" open="("
			separator="," close=")">
			#{item}
		</foreach>
		</if>
		<if test="beginDate != null">
			AND sRepayDate &gt;= #{beginDate,jdbcType=DATE}
		</if>
		<if test="endDate != null">
			AND sRepayDate &lt;= #{endDate,jdbcType=DATE}
		</if>
		<if test="acFlag != null">
				and acFlag &lt;&gt; #{acFlag,jdbcType=VARCHAR}
		</if>
	</select>
<!--分页查询  -->
	<select id="selectByMap" resultMap="BaseResultMap"
		parameterType="map">
		select
		<include refid="Base_Column_List" />
		from tableName
		where  1=1 
		<if test="loanAcNo != null">
			and loanAcNo in
		<foreach item="item" index="index" collection="loanAcNo" open="("
			separator="," close=")">
			#{item}
		</foreach>
		</if>
		<if test="beginDate != null">
			AND sRepayDate &gt;= #{beginDate,jdbcType=DATE}
		</if>
		<if test="endDate != null">
			AND sRepayDate &lt;= #{endDate,jdbcType=DATE}
		</if>
		<if test="acFlag != null">
				and acFlag &lt;&gt; #{acFlag,jdbcType=VARCHAR}
		</if>
		order by loanAcNo desc
		limit #{startNum,jdbcType=INTEGER},#{endNum,jdbcType=INTEGER}
	</select>