运用多线程批量修改数据

最新推荐文章于 2024-05-31 16:24:57 发布

鹤忧

最新推荐文章于 2024-05-31 16:24:57 发布

阅读量883

点赞数

CC 4.0 BY-SA版权

分类专栏： Java 文章标签：多线程

本文链接：https://blog.youkuaiyun.com/qq_37980436/article/details/73487654

Java 专栏收录该内容

13 篇文章

订阅专栏

这篇博客探讨了如何通过实现Runnable接口并编写run方法，来利用多线程技术进行大规模数据的批量修改。文章内容简洁，主要关注于实际操作和业务逻辑的实现。

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

多线程批量修改数据

@RequestMapping("Test")
public class UpdateByThread implements Runnable {

    private int startId;
    private int endId;

    //批量修改
    @Autowired
    ExaminationErrorMapper examinationErrorMapper;

    @Autowired
    ExaminationErrorCustMapper examinationErrorCustMapper;

    public UpdateByThread(int startId,int endId){
        this.startId=startId;
        this.endId=endId;
    }

    @Override
    public void run() {

        ApplicationContext ac = new FileSystemXmlApplicationContext("classpath:config/applicationContext.xml");

        examinationErrorMapper = (ExaminationErrorMapper) ac.getBean("examinationErrorMapper");
        examinationErrorCustMapper = (ExaminationErrorCustMapper) ac.getBean("examinationErrorCustMapper");

        String threadName = Thread.currentThread().getName();
        int begin=Integer.valueOf(threadName.substring(threadName.indexOf("-")+1,threadName.length()));
        //先查出需要修改的数据(建议使用limit 一条一条处理)
        ExaminationError ee = examinationErrorCustMapper.selectOne(startId,endId,begin,1);

        ExaminationError record = new ExaminationError();
        record.setId(ee.getId());
        record.setErrorcontent(String.valueOf(ee.getUserid()));

        examinationErrorMapper.updateByPrimaryKeySelective(record);


    }

}

实现Runnable接口，根据业务逻辑写run方法，（以上是测试，所以..）

@Controller
@RequestMapping(value="/Test")
public class TestContorller {


    private static Logger logger = LoggerFactory.getLogger(TestContorller.class);

    @RequestMapping(value = "/UpBT", method = RequestMethod.GET)
    @ResponseBody
    Map<String, Object> UpBT(HttpServletRequest request, HttpServletResponse response) throws Exception {
        Map<String, Object> result = new HashMap<String, Object>();
        try{

            Integer startId = Integer.valueOf(request.getParameter("startId"));
            Integer endId = Integer.valueOf(request.getParameter("endId"));
            for(int i=0;i<50;i++){
                new Thread(new UpdateByThread(startId,endId), "scoreAPI-"+i).start();
            }
            result.put("message","调用批量接口成功");
            result.put("code", "0000");
        }catch(Exception e){
            e.printStackTrace();

            result.put("code","9999");
            result.put("message","调用批量接口失败");
            return result;
        }
        return result;

      }
    }