使用Java Config在SQL中进行Spring批处理后期绑定 [英] Spring Batch Late Binding Within SQL Using Java Config

问题描述

我们正在将基于xml的spring批处理配置转换为java config.
在JdbcCursorItemReader的xml形式中，我们使用了后期绑定:

We are converting xml-based spring batch configuration to java config.
In xml form of JdbcCursorItemReader we were using late binding:

SELECT * FROM MY_TABLE _#{jobParameters [param1]}

SELECT * FROM MY_TABLE_#{jobParameters[param1]}

如何使用Java配置语法来实现?

How can this be implemented using Java config syntax?

推荐答案

您可以如下实现:

@Bean
@StepScope
public JdbcCursorItemReader jdbcCursorItemReader(@Value("#{jobParameters['param1']}") String param1) {
    return new JdbcCursorItemReaderBuilder<>()
            .sql("SELECT * FROM MY_TABLE_" + param1)
            // set other properties
            .build();
}

参考文档在每个页面上都包含一个切换开关，使您可以查看Java和Xml配置中的示例.这对您的迁移很有帮助.在此处查看示例: https://docs. spring.io/spring-batch/4.0.x/reference/html/readersAndWriters.html#readersAndWriters

The reference documentation contains a toggle on each page that allows you to see examples in either Java and Xml configuration. This can be helpful in your migration. See example here: https://docs.spring.io/spring-batch/4.0.x/reference/html/readersAndWriters.html#readersAndWriters

这篇关于使用Java Config在SQL中进行Spring批处理后期绑定的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！