SYSTEM
批量操作
src/content/notes/system/批量操作.md 批量操作
三种方式实现批量操作:
-
标签属性:这种方式属于全局批量 <settings> <setting name="defaultExecutorType" value="BATCH"/> </settings>defaultExecutorType:配置默认的执行器
- SIMPLE 就是普通的执行器(默认,每次执行都要重新设置参数)
- REUSE 执行器会重用预处理语句(只预设置一次参数,多次执行)
- BATCH 执行器不仅重用语句还会执行批量更新(只针对修改操作)
-
SqlSession 会话内批量操作:
public void testBatch() throws IOException{ SqlSessionFactory sqlSessionFactory = getSqlSessionFactory(); // 可以执行批量操作的sqlSession SqlSession openSession = sqlSessionFactory.openSession(ExecutorType.BATCH); long start = System.currentTimeMillis(); try{ EmployeeMapper mapper = openSession.getMapper(EmployeeMapper.class); for (int i = 0; i < 10000; i++) { mapper.addEmp(new Employee(UUID.randomUUID().toString().substring(0, 5), "b", "1")); } openSession.commit(); long end = System.currentTimeMillis(); // 批量:(预编译sql一次==>设置参数===>10000次===>执行1次(类似管道)) // 非批量:(预编译sql=设置参数=执行)==》10000 耗时更多 System.out.println("执行时长:" + (end - start)); }finally{ openSession.close(); } } -
Spring 配置文件方式(applicationContext.xml):
<!--配置一个可以进行批量执行的sqlSession --> <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate"> <constructor-arg name="sqlSessionFactory" ref="sqlSessionFactoryBean"/> <constructor-arg name="executorType" value="BATCH"/> </bean>@Autowired private SqlSession sqlSession;