多线程事务回滚sqlSession

最新推荐文章于 2025-03-10 09:26:17 发布

最爱茄子包

最新推荐文章于 2025-03-10 09:26:17 发布

阅读量611

点赞数

文章标签： java 数据库开发语言

本文链接：https://blog.youkuaiyun.com/a543768773/article/details/128564661

版权

该代码示例展示了如何在Java中利用SqlContext获取SqlSession，然后通过多线程并行处理批量保存EmployeeDO列表。在事务中，首先关闭自动提交，执行删除操作，接着将数据平均分配到多个子列表并异步执行保存操作。如果任何保存失败，则回滚事务，否则提交事务并记录成功信息。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

 @Resource
SqlContext sqlContext;
/**
 * 多线程事务.
 * @param employeeDOList
 */
@Override
public void saveThread(List<EmployeeDO> employeeDOList) throws SQLException {
    // 获取数据库连接,获取会话(内部自有事务)
    SqlSession sqlSession = sqlContext.getSqlSession();
    Connection connection = sqlSession.getConnection();
    try {
        // 设置手动提交
        connection.setAutoCommit(false);
        EmployeeMapper employeeMapper = sqlSession.getMapper(EmployeeMapper.class);
        //先做删除操作
        employeeMapper.delete(null);
        ExecutorService service = ExecutorConfig.getThreadPool();
        List<Callable<Integer>> callableList  = new ArrayList<>();
        List<List<EmployeeDO>> lists=averageAssign(employeeDOList, 5);
        for (int i =0;i<lists.size();i++){
            List<EmployeeDO> list  = lists.get(i);
            Callable<Integer> callable = () -> employeeMapper.saveBatch(list);
            callableList.add(callable);
        }
        //执行子线程
       List<Future<Integer>> futures = service.invokeAll(callableList);
        for (Future<Integer> future:futures) {
            if (future.get()<=0){
                connection.rollback();
                 return;
            }
        }
        connection.commit();
        logger.info("save successful!");
    }catch (Exception e){
        connection.rollback();
        log.info("error",e);
        throw new ServiceException("10002","businsess exception");
       // throw new ServiceException(ExceptionCodeEnum.EMPLOYEE_SAVE_OR_UPDATE_ERROR);
    }
}

xml or mybatisplus

// sql
<insert id="saveBatch" parameterType="List">
 INSERT INTO
 employee (employee_id,age,employee_name,birth_date,gender,id_number,creat_time,update_time,status)
 values
     <foreach collection="list" item="item" index="index" separator=",">
     (
     #{item.employeeId},
     #{item.age},
     #{item.employeeName},
     #{item.birthDate},
     #{item.gender},
     #{item.idNumber},
     #{item.creatTime},
     #{item.updateTime},
     #{item.status}
         )
     </foreach>
 </insert>