Springboot 多线程实现事务控制

业务背景

工作中有很多,在一个service实现层,有可能调用其他的service,或者说是使用异步线程,这样就不容易控制当前操作成功和失败
不多说,上代码

获取数据库事务控制器

@Component
public class TransactionalUntil {

    @Resource
    private DataSourceTransactionManager dataSourceTransactionManager;

    /**
     * 开启事务
     */
    public TransactionStatus begin() {
        TransactionStatus transaction = dataSourceTransactionManager.getTransaction(new DefaultTransactionAttribute());
        return transaction;
    }

    /**
     * 提交事务
     */
    public void commit(TransactionStatus transactionStatus) {
        dataSourceTransactionManager.commit(transactionStatus);
    }

    /**
     * 回滚事务
     */
    public void rollback(TransactionStatus transactionStatus) {
        dataSourceTransactionManager.rollback(transactionStatus);
    }

}

测试代码

package com.demo.easypdf;

import cn.hutool.core.thread.ThreadUtil;
import com.beust.jcommander.internal.Lists;
import com.demo.easypdf.domain.TestOne;
import com.demo.easypdf.domain.TestT;
import com.demo.easypdf.domain.User;
import com.demo.easypdf.mapper.TestOneMapper;
import com.demo.easypdf.mapper.TestTMapper;
import com.demo.easypdf.mapper.UserMapper;
import com.demo.easypdf.untils.TransactionalUntil;
import lombok.extern.slf4j.Slf4j;
import org.springframework.transaction.TransactionStatus;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RestController;
import wiki.xsx.core.pdf.component.text.XEasyPdfText;
import wiki.xsx.core.pdf.doc.XEasyPdfDocument;
import wiki.xsx.core.pdf.doc.XEasyPdfPage;
import wiki.xsx.core.pdf.handler.XEasyPdfHandler;
import wiki.xsx.core.pdf.template.doc.XEasyPdfTemplateDocument;
import wiki.xsx.core.pdf.template.doc.component.block.XEasyPdfTemplateBlockContainer;
import wiki.xsx.core.pdf.template.doc.component.image.XEasyPdfTemplateImage;
import wiki.xsx.core.pdf.template.doc.component.page.XEasyPdfTemplateCurrentPageNumber;
import wiki.xsx.core.pdf.template.doc.component.page.XEasyPdfTemplateTotalPageNumber;
import wiki.xsx.core.pdf.template.doc.component.text.XEasyPdfTemplateText;
import wiki.xsx.core.pdf.template.doc.page.XEasyPdfTemplatePage;
import wiki.xsx.core.pdf.template.handler.XEasyPdfTemplateHandler;

import javax.annotation.Resource;
import java.util.Collections;
import java.util.List;
import java.util.concurrent.CopyOnWriteArrayList;
import java.util.concurrent.CountDownLatch;
import java.util.concurrent.ExecutorService;
import java.util.concurrent.Executors;
import java.util.concurrent.atomic.AtomicBoolean;

/**
 * @Author: lkz
 * @Title: TestController
 * @Description: TODO
 * @Date: 2023/4/27 23:17
 */
@RestController
@Slf4j
public class TestController {

    @Resource
    private UserMapper userMapper;
    @Resource
    private TestOneMapper testOneMapper;
    @Resource
    private TestTMapper testTMapper;

    private volatile  Boolean is_ok=new Boolean(true);

    @Resource
    private TransactionalUntil transactionalUntil;

    @GetMapping("test2")
    public void testThreadTran(){
        // 监控子线程数据
        CountDownLatch childMonitor = new CountDownLatch(2);
        // 主线程收集子线程运行最终结果
        List<Boolean> childResponse= new CopyOnWriteArrayList<>();
        //子线程在该对象上等待主线程的通知
        CountDownLatch mainMonitor = new CountDownLatch(1);

        ThreadUtil.execAsync(()->{

            // 开启事务
            TransactionStatus transactionStatus = transactionalUntil.begin();
            try {
                // 操作数据库逻辑
                List<User> user = this.getUserList();
                userMapper.insert(user.get(0));
                childResponse.add(Boolean.TRUE);
                childMonitor.countDown();

                mainMonitor.await();
                log.info("user-线程{}正常执行结束,等待其他线程执行结束",Thread.currentThread().getName());
                if(is_ok){
                    // 事务提交
                    log.info("user-线程正常执行,线程事务提交",Thread.currentThread().getName());
                    transactionalUntil.commit(transactionStatus);
                }else{
                    // 事务回滚
                    log.info("user-线程执行出现异常,线程事务回滚",Thread.currentThread().getName());
                    transactionalUntil.rollback(transactionStatus);
                }
            }catch (Exception e){
                // 提交失败
                log.info("user-线程执行出现异常{},",Thread.currentThread().getName());
                childMonitor.countDown();
                childResponse.add(Boolean.FALSE);
                transactionalUntil.rollback(transactionStatus);
            }

        });

        ThreadUtil.execAsync(()->{
            // 开启事务
            TransactionStatus transactionStatus = transactionalUntil.begin();
            try {
                // 操作数据库逻辑
                List<TestT> testTList = this.getTestTList();
                testTMapper.insert(testTList.get(0));
                log.info("test-线程{}正常执行结束,等待其他线程执行结束",Thread.currentThread().getName());
                // 模拟异常
              //  int a=10/0;
                childResponse.add(Boolean.TRUE);
                childMonitor.countDown();
                mainMonitor.await();
                if(is_ok){
                    // 事务提交
                    log.info("test-线程正常执行,线程事务提交",Thread.currentThread().getName());
                    transactionalUntil.commit(transactionStatus);
                }else{
                    // 事务回滚
                    log.info("test-线程执行出现异常,线程事务回滚",Thread.currentThread().getName());
                    transactionalUntil.rollback(transactionStatus);
                }
            }catch (Exception e){
                // 提交失败
                log.info("test-线程执行出现异常{},",Thread.currentThread().getName());
                childMonitor.countDown();
                childResponse.add(Boolean.FALSE);
                transactionalUntil.rollback(transactionStatus);
            }
        });

        try {
            childMonitor.await();
            for(Boolean res:childResponse){
                while (!res){
                    // 如果有一个子线程只想失败,改变mainResult状态 事务回滚
                    log.info("有线程执行失败,修改标识位,事务回滚");
                    is_ok=false;
                    break;
                }
            }
            //主线程获取结果,子线程根据主线程的结果 提交或回滚
            mainMonitor.countDown();
            System.out.println("执行结束-------");
        }catch (Exception e){
            log.info("事务执行失败");
        }

    }


    public List<User> getUserList(){
        List<User> users= Lists.newArrayList();
        for(int i=0;i<20;i++){
            User user = new User();
            user.setId(i);
            user.setUsername("小"+i);
            user.setPassword("asc");
            user.setAge(i+0);
            users.add(user);
        }
        return users;
    }

    public List<TestT> getTestTList(){
        List<TestT> TestT= Lists.newArrayList();
        for(int i=0;i<20;i++){
            TestT tt = new TestT();
            tt.setPhone("i"+"-1234537");
            tt.setId(i);
            TestT.add(tt);
        }
        return TestT;
    }
    public List<TestOne> getTestOneList(){
        List<TestOne> oneList= Lists.newArrayList();
        for(int i=0;i<20;i++){
            TestOne tt = new TestOne();
            tt.setName("i"+"-1234537");
            oneList.add(tt);
        }
        return oneList;
    }

}

测试结果

没有异常

表1
在这里插入图片描述
表二
在这里插入图片描述
控制台打印
在这里插入图片描述

模拟异常

控制台
在这里插入图片描述
数据库无新增
在这里插入图片描述
题外补充:

 // 异步添加 数据
        List<CompletableFuture> futures=new ArrayList<>();
        InheritableThreadLocal threadLocal = new InheritableThreadLocal();
        CompletableFuture<Void> future = CompletableFuture.runAsync(() -> {
            TransactionStatus begin = transactionalUntil.begin();
            threadLocal.set(begin);
            List<CtmsCore> ctmsCores = coreMapper.selectList(new LambdaQueryWrapper<CtmsCore>().eq(CtmsCore::getProjectId, batchEntry.getProjectId())
                    .eq(CtmsCore::getIsStatus, NumEnums.THREE.getType()));
            if (CollUtil.isNotEmpty(ctmsCores)) {
                List<CtmsProjectCoreUseLandmark> batchData = new ArrayList<>();
                for (CtmsCore core : ctmsCores) {
                    StringBuffer buffer = new StringBuffer();
                    int thisSecond = DateUtil.thisSecond();
                    int millisecond = DateUtil.thisMillisecond();
                    buffer.append(String.valueOf(thisSecond)).append(String.valueOf(millisecond));
                    coreLandmarks.forEach(mark -> {
                        CtmsProjectCoreUseLandmark useLandmark = new CtmsProjectCoreUseLandmark();
                        useLandmark.setProjectId(mark.getProjectId());
                        useLandmark.setCoreId(core.getId());
                        useLandmark.setLandmarkName(mark.getLandmarkName());
                        useLandmark.setStage(mark.getStage());
                        useLandmark.setSort(mark.getSort());
                        useLandmark.setWeight(mark.getWeight());
                        useLandmark.setIsBeginNode(mark.getIsBeginNode());
                        useLandmark.setId(mark.getId() + buffer+core.getCoreCode());
                        useLandmark.setTemplateId(mark.getTemplatePlanId());
                        useLandmark.setCoreLandmarkId(mark.getId());
                        if (!mark.getParentId().equals(NumEnums.ZERO.getType()) && StrUtil.isNotEmpty(mark.getParentId())) {
                            useLandmark.setParentId(mark.getParentId() + format + buffer+core.getCoreCode());
                        }
                        batchData.add(useLandmark);
                    });

                }
                if (CollUtil.isNotEmpty(batchData)) {
                    coreUseLandmarkMapper.insertBatch(batchData);
                }

                transactionalUntil.commit(begin);

            }
        }).exceptionally((a) -> {
            if(Objects.nonNull(a)){
                TransactionStatus transactionStatus = (TransactionStatus)threadLocal.get();
                transactionalUntil.rollback(transactionStatus);
            }
            throw ServiceExceptionUtil.exception(new ErrorCode(9999, "应用中心里程碑失败"));

        });
        futures.add(future);
        for(CompletableFuture future1:futures){
            future1.join();
        }

  • 2
    点赞
  • 8
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值