如何在Spring Batch中执行多个查询(特别是使用LAST_INSERT_ID())

@Configuration
@EnableBatchProcessing
public class BatchConfiguration {

    @Autowired
    private JobBuilderFactory jobBuilderFactory;

    @Autowired
    private StepBuilderFactory stepBuilderFactory;

    @Autowired
    private DataSource dataSource;

    @Bean
    public ItemReader<YourDataClass> itemReader() {
        JdbcPagingItemReader<YourDataClass> reader = new JdbcPagingItemReader<>();
        reader.setDataSource(dataSource);
        reader.setQueryProvider(queryProvider());
        reader.setPageSize(100);
        reader.setRowMapper(new YourDataClassRowMapper());
        return reader;
    }

    @Bean
    public ItemProcessor<YourDataClass, YourProcessedDataClass> itemProcessor() {
        return new YourItemProcessor();
    }

    @Bean
    public ItemWriter<YourProcessedDataClass> itemWriter() {
        JdbcBatchItemWriter<YourProcessedDataClass> writer = new JdbcBatchItemWriter<>();
        writer.setDataSource(dataSource);
        writer.setSql("INSERT INTO your_table (column1, column2) VALUES (:value1, :value2)");
        writer.setItemSqlParameterSourceProvider(new BeanPropertyItemSqlParameterSourceProvider<>());
        return writer;
    }

    @Bean
    public Step step(ItemReader<YourDataClass> itemReader, ItemProcessor<YourDataClass, YourProcessedDataClass> itemProcessor,
                     ItemWriter<YourProcessedDataClass> itemWriter) {
        return stepBuilderFactory.get("step")
                .<YourDataClass, YourProcessedDataClass>chunk(100)
                .reader(itemReader)
                .processor(itemProcessor)
                .writer(itemWriter)
                .build();
    }

    @Bean
    public Job job(Step step) {
        return jobBuilderFactory.get("job")
                .incrementer(new RunIdIncrementer())
                .flow(step)
                .end()
                .build();
    }

    private QueryProvider queryProvider() {
        // Define your query provider here
    }

    private class YourDataClassRowMapper implements RowMapper<YourDataClass> {
        // Implement the row mapping logic here
    }

    private class YourItemProcessor implements ItemProcessor<YourDataClass, YourProcessedDataClass> {
        // Implement the data processing logic here
    }
}