多个插入行PostgreSQL Java Spring Webflux

import org.springframework.jdbc.core.BatchPreparedStatementSetter;
import org.springframework.jdbc.core.JdbcTemplate;

// 创建JdbcTemplate对象
JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);

// 准备插入的数据
List<Object[]> batchArgs = new ArrayList<>();
batchArgs.add(new Object[] { "John", 25 });
batchArgs.add(new Object[] { "Alice", 30 });
batchArgs.add(new Object[] { "Bob", 35 });

// 执行批量插入
String sql = "INSERT INTO users (name, age) VALUES (?, ?)";
jdbcTemplate.batchUpdate(sql, new BatchPreparedStatementSetter() {
    @Override
    public void setValues(PreparedStatement ps, int i) throws SQLException {
        Object[] args = batchArgs.get(i);
        ps.setString(1, (String) args[0]);
        ps.setInt(2, (int) args[1]);
    }

    @Override
    public int getBatchSize() {
        return batchArgs.size();
    }
});