Mybatis通过SqlSessionTemplate进行批量操作

最新推荐文章于 2023-08-29 13:39:47 发布

稚淮粥

最新推荐文章于 2023-08-29 13:39:47 发布

阅读量559

点赞数

文章标签： mybatis java spring

本文链接：https://blog.csdn.net/Az201706/article/details/126925917

版权

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");
    }
}