SqlSessionTemplate进行批量操作
1、在spring中配置SqlSessionFactoryBean
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="configLocation" value="classpath:mybatis-config.xml"></property>
<property name="dataSource" ref="dataSource"></property>
<property name="typeAliasesPackage" value="com.atguigu.ssm.pojo"></property>
</bean>
2、配置SqlSessionTemplate
<bean class="org.mybatis.spring.SqlSessionTemplate">
<constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory"></constructor-arg>
<constructor-arg name="executorType" value=""></constructor-arg>
</bean>
3、测试类
1、通过@RunWith注解加载spring的IOC容器
2、通过@ContextConfiguration指定配置文件
3、自动装配sqlSession
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = "classpath:spring.xml")
public class MapperTest {
@Autowired
private SqlSession sqlSession;
@Test
public void testCRUD(){
EmployeeMapper mapper = sqlSession.getMapper(EmployeeMapper.class);
for (int i = 1; i<= 1000; i++){
String uname = UUID.randomUUID().toString().substring(0, 5)+i;
mapper.insertSelective(new Employee(null, uname, "M", uname+"@guigu.com",1));
}
System.out.println("finish");
}
}