首先在myBatis整合中,配置bean:
<!-- 配置一个可以执行批量的sqlSession -->
<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
<constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory"></constructor-arg>
<constructor-arg name="executorType" value="BATCH"></constructor-arg>
</bean>
接着在dao操作如下:
//批量插入
EmployeeMapper mapper = sqlSession.getMapper(EmployeeMapper.class);
for(int i=0; i<=100;i++){
//截取
String uuid =UUID.randomUUID().toString().substring(0, 5)+i;
mapper.insertSelective(new Employee(null,"uuid","j",uuid+"jrey@email.com",1));
}
System.out.println("完成");
}
建个TEST运行便能成功!