@Bean public JdbcBatchItemWriter<Person> writer(DataSource dataSource) { return new JdbcBatchItemWriterBuilder<Person>() .itemSqlParameterSourceProvider(new BeanPropertyItemSqlParameterSourceProvider<>()) .sql("INSERT INTO people (first_name, last_name) VALUES (:firstName, :lastName)") .dataSource(dataSource) .build(); } // end::readerwriterprocessor[]
((JdbcBatchItemWriter<Map<String,Object>>)writer).setItemPreparedStatementSetter(new ColumnMapItemPreparedStatementSetter()); } else if(mappedValue == 2) { writer.setItemSqlParameterSourceProvider(new BeanPropertyItemSqlParameterSourceProvider<>());
@Before public void setUp() throws Exception { namedParameterJdbcOperations = mock(NamedParameterJdbcOperations.class); writer.setSql(sql); writer.setJdbcTemplate(namedParameterJdbcOperations); writer.setItemSqlParameterSourceProvider( new BeanPropertyItemSqlParameterSourceProvider<>()); writer.afterPropertiesSet(); }
@Bean public ItemWriter<WriterSO> writer(DataSource dataSource, ItemPreparedStatementSetter<WriterSO> setter) { JdbcBatchItemWriter<WriterSO> writer = new JdbcBatchItemWriter<>(); writer.setItemSqlParameterSourceProvider(new BeanPropertyItemSqlParameterSourceProvider<>()); writer.setItemPreparedStatementSetter(setter); writer.setSql("insert into writer (id, full_name, random_num) values (?,?,?)"); writer.setDataSource(dataSource); return writer; }
private ItemSqlParameterSourceProvider<StudentDTO> studentSqlParameterSourceProvider() { return new BeanPropertyItemSqlParameterSourceProvider<>(); }
private ItemSqlParameterSourceProvider<StudentDTO> studentSqlParameterSourceProvider() { return new BeanPropertyItemSqlParameterSourceProvider<>(); }
@Bean public JdbcBatchItemWriter<Person> writer() { JdbcBatchItemWriter<Person> writer = new JdbcBatchItemWriter<>(); writer.setItemSqlParameterSourceProvider(new BeanPropertyItemSqlParameterSourceProvider<>()); writer.setSql("INSERT INTO people (first_name, last_name) VALUES (:firstName, :lastName)"); writer.setDataSource(dataSource); return writer; } // end::readerwriterprocessor[]
@Bean public JdbcBatchItemWriter<Customer> customerItemWriter() { JdbcBatchItemWriter<Customer> itemWriter = new JdbcBatchItemWriter<>(); itemWriter.setDataSource(this.dataSource); itemWriter.setSql("INSERT INTO NEW_CUSTOMER VALUES (:id, :firstName, :lastName, :birthdate)"); itemWriter.setItemSqlParameterSourceProvider(new BeanPropertyItemSqlParameterSourceProvider()); itemWriter.afterPropertiesSet(); return itemWriter; }
@Bean public ItemWriter<Partner> writer(){ JdbcBatchItemWriter<Partner> itemWriter = new JdbcBatchItemWriter<Partner>(); itemWriter.setSql("INSERT INTO PARTNER (NAME, EMAIL) VALUES (:name,:email)"); itemWriter.setDataSource(infrastructureConfiguration.dataSource()); itemWriter.setItemSqlParameterSourceProvider(new BeanPropertyItemSqlParameterSourceProvider<Partner>()); return itemWriter; }
@Bean public ItemWriter<Partner> writer(){ JdbcBatchItemWriter<Partner> itemWriter = new JdbcBatchItemWriter<Partner>(); itemWriter.setSql("INSERT INTO PARTNER (NAME, EMAIL) VALUES (:name,:email)"); itemWriter.setDataSource(infrastructureConfiguration.dataSource()); itemWriter.setItemSqlParameterSourceProvider(new BeanPropertyItemSqlParameterSourceProvider<Partner>()); return itemWriter; }
@Bean public ItemWriter<Partner> writer(){ JdbcBatchItemWriter<Partner> itemWriter = new JdbcBatchItemWriter<Partner>(); itemWriter.setSql("INSERT INTO PARTNER (NAME, EMAIL) VALUES (:name,:email)"); itemWriter.setDataSource(infrastructureConfiguration.dataSource()); itemWriter.setItemSqlParameterSourceProvider(new BeanPropertyItemSqlParameterSourceProvider<Partner>()); return itemWriter; }
@Bean public ItemWriter<Partner> writer(){ JdbcBatchItemWriter<Partner> itemWriter = new JdbcBatchItemWriter<Partner>(); itemWriter.setSql("INSERT INTO PARTNER (NAME, EMAIL) VALUES (:name,:email)"); itemWriter.setDataSource(infrastructureConfiguration.dataSource()); itemWriter.setItemSqlParameterSourceProvider(new BeanPropertyItemSqlParameterSourceProvider<Partner>()); return itemWriter; }
@Bean public ItemWriter<Partner> writer(){ JdbcBatchItemWriter<Partner> itemWriter = new JdbcBatchItemWriter<Partner>(); itemWriter.setSql("INSERT INTO PARTNER (NAME, EMAIL) VALUES (:name,:email)"); itemWriter.setDataSource(infrastructureConfiguration.dataSource()); itemWriter.setItemSqlParameterSourceProvider(new BeanPropertyItemSqlParameterSourceProvider<Partner>()); return itemWriter; }
@Bean public ItemWriter<Partner> writer(){ JdbcBatchItemWriter<Partner> itemWriter = new JdbcBatchItemWriter<Partner>(); itemWriter.setSql("INSERT INTO PARTNER (NAME, EMAIL) VALUES (:name,:email)"); itemWriter.setDataSource(infrastructureConfiguration.dataSource()); itemWriter.setItemSqlParameterSourceProvider(new BeanPropertyItemSqlParameterSourceProvider<Partner>()); return itemWriter; }
@Bean public ItemWriter<Partner> writer(){ JdbcBatchItemWriter<Partner> itemWriter = new JdbcBatchItemWriter<Partner>(); itemWriter.setSql("INSERT INTO PARTNER (NAME, EMAIL) VALUES (:name,:email)"); itemWriter.setDataSource(infrastructureConfiguration.dataSource()); itemWriter.setItemSqlParameterSourceProvider(new BeanPropertyItemSqlParameterSourceProvider<Partner>()); return itemWriter; }
@Bean public JdbcBatchItemWriter customerItemWriter() { JdbcBatchItemWriter<Customer> itemWriter = new JdbcBatchItemWriter<>(); itemWriter.setDataSource(this.dataSource); itemWriter.setSql("INSERT INTO NEW_CUSTOMER VALUES (:id, :firstName, :lastName, :birthdate)"); itemWriter.setItemSqlParameterSourceProvider(new BeanPropertyItemSqlParameterSourceProvider()); itemWriter.afterPropertiesSet(); return itemWriter; }
@Bean public JdbcBatchItemWriter<Customer> customerItemWriter() { JdbcBatchItemWriter<Customer> itemWriter = new JdbcBatchItemWriter<>(); itemWriter.setDataSource(this.dataSource); itemWriter.setSql("INSERT INTO NEW_CUSTOMER VALUES (:id, :firstName, :lastName, :birthdate)"); itemWriter.setItemSqlParameterSourceProvider(new BeanPropertyItemSqlParameterSourceProvider()); itemWriter.afterPropertiesSet(); return itemWriter; }
@Bean public JdbcBatchItemWriter<Customer> customerItemWriter() { JdbcBatchItemWriter<Customer> itemWriter = new JdbcBatchItemWriter<>(); itemWriter.setDataSource(this.dataSource); itemWriter.setSql("INSERT INTO CUSTOMER VALUES (:id, :firstName, :lastName, :birthdate)"); itemWriter.setItemSqlParameterSourceProvider(new BeanPropertyItemSqlParameterSourceProvider()); itemWriter.afterPropertiesSet(); return itemWriter; }
@Bean @StepScope public JdbcBatchItemWriter<Customer> customerItemWriter() { JdbcBatchItemWriter<Customer> itemWriter = new JdbcBatchItemWriter<>(); itemWriter.setDataSource(this.dataSource); itemWriter.setSql("INSERT INTO NEW_CUSTOMER VALUES (:id, :firstName, :lastName, :birthdate)"); itemWriter.setItemSqlParameterSourceProvider(new BeanPropertyItemSqlParameterSourceProvider()); itemWriter.afterPropertiesSet(); return itemWriter; }
@Bean @StepScope public JdbcBatchItemWriter<Customer> customerItemWriter() { JdbcBatchItemWriter<Customer> itemWriter = new JdbcBatchItemWriter<>(); itemWriter.setDataSource(this.dataSource); itemWriter.setSql("INSERT INTO NEW_CUSTOMER VALUES (:id, :firstName, :lastName, :birthdate)"); itemWriter.setItemSqlParameterSourceProvider(new BeanPropertyItemSqlParameterSourceProvider()); itemWriter.afterPropertiesSet(); return itemWriter; }