jdbctemplete批量处理优化

1.spring.datasource.url = jdbc:mysql://192.168.15.44:3306/ml_test?useSSL=false&useUnicode=true&characterEncoding=utf-8&rewriteBatchedStatements=true&autoReconnect=true
加rewriteBatchedStatements=true开启mysql批量处理
从底层代码来说，不打开会一条一条执行不会批处理
2.加事务
3.jdbctemplete理论上10万每次5万条，需要分批处理

源码：

public int[] batchUpdate(String sql, final BatchPreparedStatementSetter pss) throws DataAccessException {
 
    return execute(sql, new PreparedStatementCallback<int[]>() {
      public int[] doInPreparedStatement(PreparedStatement ps) throws SQLException {
        try {
          int batchSize = pss.getBatchSize();
          InterruptibleBatchPreparedStatementSetter ipss =
              (pss instanceof InterruptibleBatchPreparedStatementSetter ?
              (InterruptibleBatchPreparedStatementSetter) pss : null);
          if (JdbcUtils.supportsBatchUpdates(ps.getConnection())) {
            for (int i = 0; i < batchSize; i++) {
              pss.setValues(ps, i);
              if (ipss != null && ipss.isBatchExhausted(i)) {
                break;
              }
              ps.addBatch();
            }
            return ps.executeBatch();
          }
          else {
            List<Integer> rowsAffected = new ArrayList<Integer>();
            for (int i = 0; i < batchSize; i++) {
              pss.setValues(ps, i);
              if (ipss != null && ipss.isBatchExhausted(i)) {
                break;
              }
              rowsAffected.add(ps.executeUpdate());
            }
            int[] rowsAffectedArray = new int[rowsAffected.size()];
            for (int i = 0; i < rowsAffectedArray.length; i++) {
              rowsAffectedArray[i] = rowsAffected.get(i);
            }
            return rowsAffectedArray;
          }
        }
        finally {
          if (pss instanceof ParameterDisposer) {
            ((ParameterDisposer) pss).cleanupParameters();
          }
        }
      }
    });
  }