在单个Spring JDBC更新中从多个查询中检索生成的键

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.PreparedStatementCreator;
import org.springframework.jdbc.core.PreparedStatementCreatorFactory;
import org.springframework.jdbc.support.GeneratedKeyHolder;
import org.springframework.jdbc.support.KeyHolder;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.Statement;
import java.util.Arrays;

public class Example {
    private JdbcTemplate jdbcTemplate;

    public Example(JdbcTemplate jdbcTemplate) {
        this.jdbcTemplate = jdbcTemplate;
    }

    public void updateWithGeneratedKeys() {
        String sql = "INSERT INTO table_name (column1, column2) VALUES (?, ?)";

        PreparedStatementCreatorFactory pscFactory = new PreparedStatementCreatorFactory(sql, Statement.RETURN_GENERATED_KEYS);
        pscFactory.setGeneratedKeysColumnNames("id"); // 设置生成的键的列名

        PreparedStatementCreator psc = pscFactory.newPreparedStatementCreator(Arrays.asList("value1", "value2"));

        KeyHolder keyHolder = new GeneratedKeyHolder();

        jdbcTemplate.update(psc, keyHolder);

        int generatedId = keyHolder.getKey().intValue();
        System.out.println("Generated ID: " + generatedId);
    }
}