如何在ItemWriter中处理参数化sql查询？

import org.springframework.batch.item.database.BeanPropertyItemSqlParameterSourceProvider;
import org.springframework.batch.item.database.JdbcBatchItemWriter;
import org.springframework.jdbc.core.PreparedStatementSetter;
import org.springframework.jdbc.datasource.DriverManagerDataSource;

public class MyItemWriter<T> implements ItemWriter<T> {

    private JdbcBatchItemWriter<T> writer;

    public MyItemWriter() {
        writer = new JdbcBatchItemWriter<>();
        writer.setDataSource(getDataSource()); // 设置数据源
        writer.setSql("INSERT INTO my_table (column1, column2) VALUES (?, ?)"); // 设置SQL语句
        writer.setItemSqlParameterSourceProvider(new BeanPropertyItemSqlParameterSourceProvider<>()); // 设置参数映射
    }

    @Override
    public void write(List<? extends T> items) throws Exception {
        writer.write(items); // 执行写入操作
    }

    private DataSource getDataSource() {
        // 创建数据源
        DriverManagerDataSource dataSource = new DriverManagerDataSource();
        dataSource.setDriverClassName("com.mysql.jdbc.Driver");
        dataSource.setUrl("jdbc:mysql://localhost:3306/mydb");
        dataSource.setUsername("root");
        dataSource.setPassword("password");
        return dataSource;
    }
}