更新数据库的几种方式进行对比

最新推荐文章于 2024-02-09 17:18:21 发布

乾少、

最新推荐文章于 2024-02-09 17:18:21 发布

阅读量327

点赞数

文章标签： mybatis java 数据库

本文链接：https://blog.csdn.net/kkkkkqqqq/article/details/129665864

版权

更新数据库的几种方式进行对比

1、Mybatis foreach模式，将单条更新语句拼接成一条语句

模拟插入数据

//初始化数据准备
ArrayList<TradeOrderGoods> tradeOrderGoods = new ArrayList<>();
for (int i = 0; i < rows; i++) {
    TradeOrderGoods orderGoods = new TradeOrderGoods();
    orderGoods.setTradeId(1629584302914176896L);
    orderGoods.setSubTradeId(1629584317753624448L);
    orderGoods.setTaxFee(new BigDecimal(1.00));
    orderGoods.setTaxRate(new BigDecimal(2.00));
    if (YesOrNo.YES.getCode().equals(ifAddMoreFields)){
        orderGoods.setAgentSubTradeId(1111L);
        orderGoods.setActualSendCount(new BigDecimal(0.00));
        orderGoods.setBarcode("fashkljhk");
        orderGoods.setBatchSendCount(new BigDecimal(10.00));
        orderGoods.setGoodsId(111111L);
        orderGoods.setGoodsNo("dsadas123");
        orderGoods.setBaseUnitSellCount(new BigDecimal(11.00));
    }
    tradeOrderGoods.add(orderGoods);
}

数据库的sql

2、batch模式更新-获取batch模式的sqlSession，循环执行

SqlSession sqlSession = sqlSessionFactory.openSession(ExecutorType.BATCH);
TradeOrderGoodsDefineMapper mapper = sqlSession.getMapper(TradeOrderGoodsDefineMapper.class);
long start = System.currentTimeMillis();
for (int i = 0; i < forTimes; i++) {
    for (TradeOrderGoods tradeOrderGood : tradeOrderGoods) {
        mapper.batchUpdateTaxRateAndFee2(tradeOrderGood);
    }
}
sqlSession.commit();
long end = System.currentTimeMillis();