首先,创建一个简单的insert语句:
<insert id="insertName">
insert into names(name) values (#{value})
</insert>
然后在Java代码中像下面这样执行批处理插入:
List<String> names = new ArrayList();
names.add("wsd");
names.add("llx");
names.add("zzl");
names.add("wcm");
// 注意这里 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();
}