mybatis foreach应用

最新推荐文章于 2021-08-09 16:30:40 发布

knife1220

最新推荐文章于 2021-08-09 16:30:40 发布

阅读量157

点赞数

CC 4.0 BY-SA版权

分类专栏： java mybatis

本文链接：https://blog.youkuaiyun.com/caideb/article/details/81698182

java 同时被 2 个专栏收录

81 篇文章

订阅专栏

mybatis

14 篇文章

订阅专栏

1.单个参数

public List<Article> getInIds(List<String> ids);

<select id="getInIds" resultType="com.testmybatis.model.Article">
		select * from article 
		where 
		type = 1 
		<if test="list !=null and list.size>0">
		and  id in 
		 <foreach item="item" index="index" collection="list" open="(" separator="," close=")">  
 				 #{item}  
 		</foreach> 
 		</if>	
	</select>

2.多个参数

public List<Article> getInIdsAndType(@Param("type")int type,@Param("list")List<String> ids);

<select id="getInIdsAndType" resultType="com.testmybatis.model.Article">
		select * from article 
		where 
		type = #{type} 
		<if test="list !=null and list.size>0">
		and  id in 
		 <foreach item="item" index="index" collection="list" open="(" separator="," close=")">  
 				 #{item}  
 		</foreach> 
 		</if>	
	</select>