MyBatis总结(三十二)--任务84：MyBatis_扩展_批量_BatchExecutor&Spring中配置批量sqlSession

待我称王封你为后i 2022-05-10 02:42 197阅读 0赞

本文内容来自尚硅谷

**目录**

1简单的循环循环一万次的操作方式如下

1.1JUnit

1.2dao

1.3xml

1.4控制台输出

2使用mybatis循环提交

2.1JUnit

2.2控制台效果

2.3如果是在整合了ssm的框架中应该如下配置才能得到批量操作的sqlSession

2.3.1applicationContext.xml配置

2.3.2service层中如下使用sqlSession

--------------------

不使用批量提交来提交一万条insert语句需要10200秒而使用了批量提交只需要4598秒

# 1简单的循环循环一万次的操作方式如下 #

##     1.1JUnit ##

与[helloWorld][]一样，只是循环操作了一万次而已

@Test
    	public void testBatch() throws IOException{
    		SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();
    		
    		//可以执行批量操作的sqlSession
    		SqlSession openSession = sqlSessionFactory.openSession();
    		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次））
    			//Parameters: 616c1(String), b(String), 1(String)==>4598
    			//非批量：（预编译sql=设置参数=执行）==》10000    10200
    			System.out.println("执行时长："+(end-start));
    		}finally{
    			openSession.close();
    		}
    		
    	}

##      1.2dao ##

package com.atguigu.mybatis.dao;
    
    import java.util.List;
    
    import com.atguigu.mybatis.bean.Employee;
    import com.atguigu.mybatis.bean.OraclePage;
    
    public interface EmployeeMapper {
    	
    	public Employee getEmpById(Integer id);
    	
    	public List<Employee> getEmps();
    	
    	public Long addEmp(Employee employee);
    	
    	public void getPageByProcedure(OraclePage page);
    }

##      1.3xml ##

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE mapper
     PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
     "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    <mapper namespace="com.atguigu.mybatis.dao.EmployeeMapper">
    
     	
    	
    	<insert id="addEmp" useGeneratedKeys="true" keyProperty="id">
    		insert into tbl_employee(last_name,email,gender,empStatus) 
    		values(#{lastName},#{email},#{gender},#{empStatus})
    	</insert>
    
    </mapper>

##     1.4控制台输出 ##

可以看出每次循环，都会向数据发送sql然后预编译再执行sql

![70][]

# 2使用mybatis循环提交 #

只需要再获取sqlsession时，设置下参数便可获取到可以批量提交的sqlSession。默认的到的sqlSession时simpl类型的

##     2.1JUnit ##

![70 1][]

##     2.2控制台效果 ##

每次循环都只提交参数就可以了，不用再重新提交sql语句。

![70 2][]

##     2.3如果是在整合了ssm的框架中应该如下配置才能得到批量操作的sqlSession ##

###     2.3.1applicationContext.xml配置 ###

<bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
    		<property name="dataSource" ref="dataSource"></property>
    		
    		<property name="configLocation" value="classpath:mybatis-config.xml"></property>
    		
    		<property name="mapperLocations" value="classpath:mybatis/mapper/*.xml"></property>
    	</bean>
    	
    	
    	<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
    		<constructor-arg name="sqlSessionFactory" ref="sqlSessionFactoryBean"></constructor-arg>
    		<constructor-arg name="executorType" value="BATCH"></constructor-arg>
    	</bean>

<constructor-arg name="executorType" value="BATCH"></constructor-arg>就是来设置sqlSession的值的

###     2.3.2service层中如下使用sqlSession ###

package com.atguigu.mybatis.service;
    
    import java.util.List;
    
    import org.apache.ibatis.session.SqlSession;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    import com.atguigu.mybatis.bean.Employee;
    import com.atguigu.mybatis.dao.EmployeeMapper;
    
    @Service
    public class EmployeeService {
    	
    	@Autowired
    	private EmployeeMapper employeeMapper;
    	
    	@Autowired
    	private SqlSession sqlSession;
    	
    	public List<Employee> getEmps(){
    		//
    		//EmployeeMapper mapper = sqlSession.getMapper(EmployeeMapper.class);
    		return employeeMapper.getEmps();
    	}
    
    }

[helloWorld]: https://blog.csdn.net/lsx2017/article/details/82493457
[70]: /images/20220510/786a3153156d439c98eae6f24e986622.png
[70 1]: /images/20220510/bb0a18fb90de422d9d0571937c61f4b7.png
[70 2]: /images/20220510/ee3026342c1c45a3bd020c115038e539.png