java异步批量插入返回主键列表

最新推荐文章于 2024-06-07 00:17:01 发布

原创最新推荐文章于 2024-06-07 00:17:01 发布 · 447 阅读

0 ·

CC 4.0 BY-SA版权

java 专栏收录该内容

46 篇文章

订阅专栏

本文介绍了一个使用Java线程池进行批量数据插入的并发编程案例。通过创建固定大小的线程池，提交多个Callable任务并收集Future结果，实现了高效的数据批量处理。文章展示了如何利用ExecutorService、Callable和Future接口来优化数据库操作，提高程序执行效率。


        StringBuffer buffer = new StringBuffer();
        ExecutorService fixedThreadPool = Executors.newFixedThreadPool(10);
        List<Future> listFuture = new ArrayList<Future>();
        for (int i = 0; i < number; i++) {
            Callable myCallable = new Callable() {
                @Override
                public Object call() throws Exception {
                    Map ruleMember = buildCouponRuleMember(couponRule);
                    addStartDateAndEndDate(ruleMember, couponRule);
                    ruleMember.put("writeOffCode",getCode());
                    db().insert("couponRule.addCouponMember", ruleMember);
                    Thread.sleep(50);
                    return ruleMember.get("id");
                }
            };
            Future future = fixedThreadPool.submit(myCallable);
            listFuture.add(future);
        }
        fixedThreadPool.shutdown();
        for (Future future : listFuture) {
            try {
                buffer.append(future.get()+ ",");
            } catch (InterruptedException e) {
                e.printStackTrace();
            } catch (ExecutionException e) {
                e.printStackTrace();
            }
        }

        return buffer.toString();