如何通过spring boot batch JdbcBatchItemWriter()将java Char插入到MariaDB CHAR(1)

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-batch</artifactId>
</dependency>
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>

import org.springframework.batch.item.ItemWriter;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import import java.util.List;

public class CharItemWriter implements ItemWriter<Character> {
    
    @Autowired
    private JdbcTemplate jdbcTemplate;

    @Override
    public void write(List<? extends Character> characters) throws Exception {
        String sql = "INSERT INTO your_table_name (char_column) VALUES (?)";
        jdbcTemplate.batchUpdate(sql, characters, 1, (ps, character) -> {
            ps.setString(1, String.valueOf(character));
        });
    }
}

spring.datasource.url=jdbc:mysql://your_database_host:your_port/your_database_name
spring.datasource.username=your_username
spring.datasource.password=your_password
spring.datasource.driver-class-name=your_driver_class_name

import org.springframework.batch.core.Job;
import org.springframework.batch.core.Step;
import import org.springframework.batch.core.configuration.annotation.EnableBatchProcessing;
import org.springframework.batch.core.configuration.annotation.JobBuilderFactory;
import org.springframework.batch.core.configuration.annotation.StepBuilderFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

@Configuration
@EnableBatchProcessing
public class BatchJobConfig {

    @Autowired
    private JobBuilderFactory jobBuilderFactory;

    @Autowired
    private StepBuilderFactory stepBuilderFactory;

    @Autowired
    private CharItemWriter charItemWriter;

    @Bean
    public ItemReader<Character> charItemReader() {
        // 实现自定义的ItemReader，从数据源读取需要插入的Java Char数据
        // 可以使用FlatFileItemReader、JdbcCursorItemReader等
    }

    @Bean
    public ItemProcessor<Character, Character> charItemProcessor() {
        // 实现自定义的ItemProcessor，对读取的数据进行处理，如果需要的话
    }

    @Bean
    public Step charInsertStep(ItemReader<Character> charItemReader, ItemProcessor<Character, Character> charItemProcessor) {
        return stepBuilderFactory.get("charInsertStep")
                .<Character, Character>chunk(100)
                .reader(charItemReader)
                .processor(charItemProcessor)
                .writer(charItemWriter)
                .build();
    }

    @Bean
    public Job charInsertJob(Step charInsertStep) {
        return jobBuilderFactory.get("charInsertJob")
                .start(charInsertStep)
                .build();
    }
}

import org.springframework.batch.core.Job;
import org.springframework.batch.core.JobParameters;
import org.springframework.batch.core.JobParametersBuilder;
import import org.springframework.batch.core.launch.JobLauncher;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;

@Component
public class BatchJobInvoker {

    @Autowired
    private JobLauncher jobLauncher;

    @Autowired
    private Job charInsertJob;

    public void runBatchJob() throws Exception {
        JobParameters jobParameters = new JobParametersBuilder()
                .addLong("timestamp", System.currentTimeMillis())
                .toJobParameters();
        jobLauncher.run(charInsertJob, jobParameters);
    }
}