mybaits 分页查询

最新推荐文章于 2025-08-14 19:22:02 发布

原创最新推荐文章于 2025-08-14 19:22:02 发布 · 161 阅读

0 ·

CC 4.0 BY-SA版权

mybatis 分页专栏收录该内容

1 篇文章

订阅专栏

本文介绍了一个使用MyBatis实现的分页查询和记录总数查询的方法。通过XML映射文件定义SQL语句，支持根据贷款账号、开始日期、结束日期和账户标志进行过滤。采用动态SQL实现条件查询，并利用LIMIT关键字完成分页。


	<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>