后端-框架-MyBatis-动态SQL-foreach

最新推荐文章于 2024-06-12 22:34:57 发布

CaediosViolet

最新推荐文章于 2024-06-12 22:34:57 发布

阅读量190

点赞数

分类专栏：后端框架 MyBatis 文章标签：后端框架 MyBatis 动态SQL foreach

本文链接：https://blog.csdn.net/qq_40925226/article/details/83410237

版权

后端同时被 3 个专栏收录

29 篇文章 0 订阅

订阅专栏

框架

29 篇文章 0 订阅

订阅专栏

MyBatis

9 篇文章 0 订阅

订阅专栏

后端-框架-MyBatis-动态SQL-foreach

public interface UserMapper {
	public List<User> getUserListByRoleIdForeachArray(Integer[] roleIds);
	public List<User> getUserListByRoleIdForeachList(List<Integer> roleList);
	public List<User> getUserListByRoleIdForeachExample(@Param("example")Integer[] roleIds);
}

对于foreach中collection属性为array,即数组

<select id="getUserListByRoleIdForeachArray" resultMap="getUserListByRoleIdForeach">
	select * from smbms_user where userRole in
		<foreach collection="array" item="roleId" open="(" separator="," close=")">
			#{roleId}
		</foreach>
</select>

对于foreach中collection属性为list

<select id="getUserListByRoleIdForeachList" resultMap="getUserListByRoleIdForeach">
	select * from smbms_user where userRole in
		<foreach collection="list" item="roleList" open="(" separator="," close=")">
			#{roleList}
		</foreach>
</select>

接口中起别名对应foreach中collection属性

<select id="getUserListByRoleIdForeachExample" resultMap="getUserListByRoleIdForeach">
	select * from smbms_user where userRole in
		<foreach collection="example" item="roleId" open="(" separator="," close=")">
			#{roleId}
		</foreach>
</select>

Map多参数入参,foreach中collection属性对应相应别名

<select id="getUserListByRoleIdMap" resultMap="getUserListByRoleIdMap">
		select * from smbms_user where gender = #{gender}
			and userRole in
			<foreach collection="roleIds" item="roleId" open="(" separator="," close=")">
				#{roleId}
			</foreach>
	</select>