Mybatis使用foreach执行mysql批量插入

1、在dao中定义一个批量插入的方法：package com.gwolf.dao;import java.util.List;import java.util.Map;import org.apache.ibatis.annotations.MapKey;import org.apache.ibatis.annotations.Param;import com.gwolf.bean.Employee;public interface EmployeeMapper { public void addEmps(@Param("emps") List<Employee> emps); }

3、在单元测试中定义一个批量插入的单元测试方法：package com.gwolf;import java.io.InputStream;import java.util.ArrayList;import java.util.List;import org.apache.ibatis.io.Resources;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;import org.junit.Test;import com.gwolf.bean.Employee;import com.gwolf.dao.EmployeeMapper;public class AppTest { @Test public void testBatchSave() throws Exception { String resource = "mybatis-config.xml"; InputStream inputStream = Resources.getResourceAsStream(resource); SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream); SqlSession sqlSession = sqlSessionFactory.openSession(); try { EmployeeMapper employeeMapper = sqlSession.getMapper(EmployeeMapper.class); List<Employee> emps = new ArrayList<Employee>(); emps.add(new Employee(null, "cc", "gwolf_201@126.com", "M")); emps.add(new Employee(null, "ce", "gwolf_201@126.com", "M")); employeeMapper.addEmps(emps);; }finally { sqlSession.close(); } } }

5、如果需要批量保存，还可以使用foreach遍历，mysql支持values（），（）语法。