如果需要对同一个表插入数据,我们可以使用batchUpdate来提高效率。
具体代码:
public void batchUpdateCouponByDeductAmount(List<CouponItemTradePrice> list) { String insertSQL = "SQL语句"; List<Object[]> params = new ArrayList<Object[]>(); for (int i = 0; i < list.size(); i++) { CouponItemTradePrice model = list.get(i); Object[] obj = new Object[]{ model.getTradePrice(), model.getTotalDeductAmount(), model.getTotalDeductAmount(), model.getTotalDeductAmount(), model.getTotalDeductAmount(), model.getSeries(), SeqGetUtil.getSharedId(model.getSeries()), tenantNumId, dataSign, }; params.add(obj); } int[] row = jdbcTemplate.batchUpdate(insertSQL, params); }