Springboot模式下Mybatis的batch模式怎么写

最新推荐文章于 2024-04-30 22:34:44 发布

小小冒险家2022

最新推荐文章于 2024-04-30 22:34:44 发布

阅读量344

点赞数 1

文章标签： spring boot mybatis batch

本文链接：https://blog.csdn.net/zhaokejin521/article/details/131511173

版权

public int addUserSpace(List<UserSpace> userSpaceList) {

        SqlSessionFactory sqlSessionFactory = sqlSessionTemplate.getSqlSessionFactory();
        SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH,false );

        UserSpaceMapper mapper = sqlSession.getMapper(UserSpaceMapper.class);

        for (UserSpace userSpace : userSpaceList) {
            UserSpaceEntity userSpaceEntity = userSpaceConverter.to(userSpace);
            mapper.insert(userSpaceEntity);
        }
        //进行批次提交
        sqlSession.commit();
        //清除缓存
        sqlSession.clearCache();
        //关闭连接
        sqlSession.close();

        return 0;
    }

还有个注意点

spring:
    datasource:
      url: jdbc:mysql://17x.2x.13x.x:33306/knowledge_base?serverTimezone=UTC&characterEncoding=utf8&characterSetResults=utf8&autoReconnect=true&rewriteBatchedStatements=true
      username: root
      password: root123

文章链接：https://www.dianjilingqu.com/230083.html