mysqlplus 批量插入_Mybatis使用foreach执行mysql批量插入

在单元测试中定义一个批量插入的单元测试方法：

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 emps = new ArrayList();

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();

}

}

}