更新时间:2023-01-12 18:52:22
如果JdbcCursorItemReader不符合您的需要,您始终可以通过实现ItemReader接口***实现自定义读取器。
public interface ItemReader<T> {
T read() throws Exception, UnexpectedInputException, ParseException;
}
只需编写实现此接口的类并插入jdbcTemplate即可查询多个表。
public Class MyCompositeJdbcReader implements ItemReader<ConsolidateResult>{
private JdbcTemplate jdbcTemplate;
public ConsolidateResult read()
throws Exception, UnexpectedInputException, ParseException{
ConsolidateResult cr = new ConsolidateResult();
String name= this.jdbcTemplate.queryForObject(
"select name from customer where id = ?",new Object[]{1}, String.class);
String phoneNumber= this.jdbcTemplate.queryForObject(
"select phone from customer_contact where custid = ?",
new Object[]{1},String.class);
cr.setName(name);
cr.setPhone(phoneNumber);
return cr;
}
}
我没有编译代码,但我希望它能提供一些启示。