Spring 批量安插

Spring 批量插入

    /**     * 批量插入     */    public void insertBudget(List<CostBudget> budgetList) {        final List<CostBudget> budgetListTemp = budgetList;        if(budgetListTemp != null && budgetListTemp.size() > 0) {            String sql= CommonConfig.getString("costbudget.insert.cost_budget","");            this.jdbcTemplate.batchUpdate(sql, new BatchPreparedStatementSetter() {                @Override                public void setValues(PreparedStatement ps, int i) throws SQLException {                    CostBudget costBudget = budgetListTemp.get(i);                    ps.setInt(1, costBudget.getTerm());                    ps.setInt(2, costBudget.getBudgetType());                    ps.setInt(3, costBudget.getDeptId() != null?costBudget.getDeptId():0);                    ps.setString(4, costBudget.getImportDeptName());                    ps.setString(5, costBudget.getKmBh());                    ps.setString(6, costBudget.getImportKmMc());                    ps.setBigDecimal(7, BigDecimal.valueOf(costBudget.getCurrentMonth()));                    ps.setBigDecimal(8, BigDecimal.valueOf(costBudget.getCurrentMonthAdjust()));                    ps.setBigDecimal(9, BigDecimal.valueOf(costBudget.getCurrentMonthAdAfter()));                    ps.setBigDecimal(10, BigDecimal.valueOf(costBudget.getSumCurrent()));                    ps.setBigDecimal(11, BigDecimal.valueOf(costBudget.getSumCurrentAdjust()));                    ps.setBigDecimal(12, BigDecimal.valueOf(costBudget.getSumCurrentAdAfter()));                    ps.setBigDecimal(13, BigDecimal.valueOf(costBudget.getYearBudget()));                    ps.setBigDecimal(14, BigDecimal.valueOf(costBudget.getBudgetCompletionRate()));                    //每2000条进行事物提交                    if (i%2000 == 0) {                        ps.executeBatch(); //执行prepareStatement对象中所有的sql语句                    }                }                @Override                public int getBatchSize() {                    return budgetListTemp.size();                }            });        }    }

?