mybaits 分页查询

最新推荐文章于 2024-07-18 18:15:00 发布

iteye_7916

最新推荐文章于 2024-07-18 18:15:00 发布

阅读量128

点赞数

分类专栏： mybatis 分页

本文链接：https://blog.csdn.net/iteye_7916/article/details/82619089

版权

mybatis 分页专栏收录该内容

1 篇文章 0 订阅

订阅专栏


	<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 >= #{beginDate,jdbcType=DATE}
		</if>
		<if test="endDate != null">
			AND sRepayDate <= #{endDate,jdbcType=DATE}
		</if>
		<if test="acFlag != null">
				and acFlag <> #{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 >= #{beginDate,jdbcType=DATE}
		</if>
		<if test="endDate != null">
			AND sRepayDate <= #{endDate,jdbcType=DATE}
		</if>
		<if test="acFlag != null">
				and acFlag <> #{acFlag,jdbcType=VARCHAR}
		</if>
		order by loanAcNo desc
		limit #{startNum,jdbcType=INTEGER},#{endNum,jdbcType=INTEGER}
	</select>