public static void insert(
DataSource dataSource,
String tableName,
List<String> usingColumns,
List<Map<String, Object>> fields) {
SimpleJdbcInsert jdbcInsert = new SimpleJdbcInsert(dataSource);
jdbcInsert.withTableName(tableName);
List<String> pp = new ArrayList<>();
pp.addAll(usingColumns);
pp.add(tableName + "_id");
jdbcInsert.usingColumns(pp.toArray(new String[usingColumns.size()]));
for (Map<String, Object> field : fields) {
field.put(tableName + "_id", UUID.randomUUID().toString());
}
Map<String, Object>[] batch = fields.toArray(new Map[fields.size()]);
jdbcInsert.executeBatch(batch);
}
