mybatis批量入库

创建一个简单的insert语句:

insert into names (name) values (#{value}) 然后在java代码中像下面这样执行批处理插入:

list names = new arraylist();
names.add(“fred”);
names.add(“barney”);
names.add(“betty”);
names.add(“wilma”);

// 注意这里 executortype.batch
sqlsession sqlsession = sqlsessionfactory.opensession(executortype.batch);
try {
 namemapper mapper = sqlsession.getmapper(namemapper.class);
 for (string name : names) {
     mapper.insertname(name);
 }
 sqlsession.commit();
}catch(Exception e){
 e.printStackTrace();
 sqlSession.rollback(); 
 throw e; 
}
 finally {
     sqlsession.close();
}