myBatis的xml映射文件中传入list集合与数组做条件

最新推荐文章于 2025-03-28 10:25:13 发布

_无往而不胜_

最新推荐文章于 2025-03-28 10:25:13 发布

阅读量1.8w

点赞数 9

分类专栏： java 文章标签： mybatis list参数数组参数集合参数 xml映射

本文链接：https://blog.csdn.net/qq_15204179/article/details/100042550

版权

java 专栏收录该内容

348 篇文章

订阅专栏

本文详细介绍了在MyBatis中如何使用XML映射文件处理List集合和数组作为参数进行数据库查询。通过具体的SQL映射示例和Java代码实现，展示了如何在查询语句中动态构建条件，特别关注于使用foreach标签处理集合和数组元素。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

mybatis的xml映射文件中传入list集合与数组做条件

1.传list集合参数

1.1sql映射:

<select id="queryDeptListByBankLevelAndBankName" parameterType="java.util.HashMap"
			resultMap="queryDeptListByBankLevelAndBankNameResult">
		select DEPTSEQ ,
		DEPTNAME,DEPTID
		from DEPT
		 WHERE 1=1
		<if test="deptIdList != null and deptIdList.size > 0 ">
		 and DEPTID not in
		 <foreach collection="deptIdList" item ="deptId" index="i" open="(" close=")" separator=",">
		           #{deptId}
		 </foreach>
		 </if>
		 ORDER BY DEPTID
	</select>

1.2 java类

将list集合封装到Map中

ArrayList deptIdList = new ArrayList();
        	String [] deptIds = {"006001", "006002", "006003", "006004", "006005"};
        	Collections.addAll(deptIdList, deptIds);
        	Map map = new HashMap();
        	map.put("deptIdList",deptIdList);
       ArrayList<Map> subList = this.sqlMap.queryForList("mcmmcif.queryDeptListByBankLevelAndBankName", map);

2.传数组参数

	<select id="queryDeptListByBankLevelAndBankName" parameterType="java.util.HashMap"
			resultMap="queryDeptListByBankLevelAndBankNameResult">
		select DEPTSEQ ,
		DEPTNAME,DEPTID
		from DEPT
		 WHERE 1=1
		<if test="deptIdList != null and deptIdList.length > 0 ">
		 and DEPTID  in
		 <foreach collection="deptIdList" item ="deptId" index="i" open="(" close=")" separator=",">
		           #{deptId}
		 </foreach>
		 </if>
		 ORDER BY DEPTID
	</select>

2.2 java类

将list集合封装到Map中

String [] deptIds = {"006007","006010","006011","006024","006025","006034","006035"};
        	Map map = new HashMap();
        	map.put("deptIds",deptIds);
        	ArrayList<Map> subList = this.sqlMap.queryForList("mcmmcif.queryDeptListByBankLevelAndBankName", map);