Mybatis怎么批量插入

原文地址：https://github.com/mybatis/mybatis-3/wiki/FAQ#how-do-i-code-a-batch-insert

How do I code a batch insert?

First, code a simple insert statement like this:

<insert id="insertName">  insert into names (name) values (#{value})</insert>

Then execute a batch in Java code like this:

List<String> names = new ArrayList<String>();names.add("Fred");names.add("Barney");names.add("Betty");names.add("Wilma");SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH);try {  NameMapper mapper = sqlSession.getMapper(NameMapper.class);  for (String name : names) {    mapper.insertName(name);  }  sqlSession.commit();} finally {  sqlSession.close();}