mybatis batchExecutor

最新推荐文章于 2025-03-10 17:29:07 发布

blingbling_也不会发光

最新推荐文章于 2025-03-10 17:29:07 发布

阅读量501

点赞数

分类专栏：技术文档文章标签： java

本文链接：https://blog.youkuaiyun.com/wxx729418277/article/details/124374743

版权

技术文档专栏收录该内容

10 篇文章

订阅专栏

@Autowired
    private SqlSessionFactory sqlSessionFactory;
//
//    @Resource
//    private RoleEntityMapper roleEntityMapper;


    public int testBatchExecutorInsert(ArrayList<RoleEntityWithBLOBs> objects) {

        RoleEntityMapper roleEntityMapper;
        SqlSession sqlSession = null;
        int i = 0;

        try {
            sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH);

//            SqlSession session = ssf.openSession(ExecutorType.BATCH);
//            session = ssf.openSession();
            roleEntityMapper = sqlSession.getMapper(RoleEntityMapper.class);
            for (RoleEntityWithBLOBs role :objects){
                i += roleEntityMapper.insertMulti(role);
            }
            sqlSession.commit();
        }catch (Exception e){
            log.error("批量插入更新异常",e);
            if (sqlSession != null) {
                sqlSession.rollback();
            }
        }finally {
            if (null != sqlSession) {
                sqlSession.close();
            }
        }
        return i;
    }

MyBatis Dynamic SQL – Insert Statements