mybatis批量插入数据

simple默

于 2018-07-22 03:22:11 发布

阅读量273

点赞数

分类专栏： Mybatis

本文链接：https://blog.csdn.net/qq_39717535/article/details/81151113

版权

Mybatis 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

	<!-- 配置一个可以执行批量的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>

	    @Autowired
	    SqlSession sqlSession;

		EmployeeMapper mapper = sqlSession.getMapper(EmployeeMapper.class);
		for(int i = 0;i<1000;i++){
			String uid = UUID.randomUUID().toString().substring(0,5)+i;
			mapper.insertSelective(new Employee(null,uid, "M", uid+"@atguigu.com", 1));
		}
		System.out.println("批量完成");

记录于尚硅谷ssm-crud的MapperTest