MyBatis框架使用foreach遍历

最新推荐文章于 2025-04-21 06:00:00 发布

苦涩精灵

最新推荐文章于 2025-04-21 06:00:00 发布

阅读量290

点赞数

CC 4.0 BY-SA版权

分类专栏： My SQL、MyBatis 文章标签： mybatis iterator

本文链接：https://blog.csdn.net/weixin_43873198/article/details/106406218

My SQL、MyBatis 专栏收录该内容

18 篇文章

订阅专栏

本文介绍了一个使用MyBatis框架进行批量查询的具体示例，通过Java代码和XML映射文件展示了如何利用foreach标签从数据库中根据多个用户名查询员工信息。

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

Client.java

package client;

import java.io.*;
import java.util.ArrayList;
import java.util.List;
import org.apache.ibatis.io.*;
import org.apache.ibatis.session.*;
import domain.*;

public class Client {
	public static void main(String args[]) throws IOException {
		InputStream in = Resources.getResourceAsStream("mybatis-config.xml");
		SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(in);
		SqlSession sqlSession = factory.openSession(true);
		List<String> list = new ArrayList<String>();
		list.add("王朝");
		list.add("马汉");
		List<Employee> emp = sqlSession.selectList("findEmployees", list);
		for (Employee em : emp)
			System.out.println("Employee's username: " + em.getUsername() + " Employee's password: " + em.getPassword()
					+ " Employee's sex: " + em.getSex());
		sqlSession.close();
	}
}

UserMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="/">
	<select id="findEmployees" parameterType="ArrayList"
		resultType="domain.Employee">
		select * from employee3
		where username in
		<foreach collection="list" item="item" open="(" close=")"
			index="i" separator=",">
			#{item}
		</foreach>
	</select>
</mapper>