Example usage for org.springframework.batch.item.database BeanPropertyItemSqlParameterSourceProvider BeanPropertyItemSqlParameterSourceProvider

Introduction

In this page you can find the example usage for org.springframework.batch.item.database BeanPropertyItemSqlParameterSourceProvider BeanPropertyItemSqlParameterSourceProvider.

Prototype

BeanPropertyItemSqlParameterSourceProvider

Source Link

Usage

From source file:my.sandbox.spring.batch.demo.writers.ProductWriter.java

public ProductWriter() {
    setItemSqlParameterSourceProvider(new BeanPropertyItemSqlParameterSourceProvider<Product>());
    setSql("INSERT INTO product (description, price, purchase_date) VALUES (:description, :price, :purchaseDate)");
}

---

From source file:org.my.spring.batch.java.config.demo.writers.ProductWriter.java

@Autowired
public ProductWriter(@Qualifier("job1DataSource") DataSource dataSource) {
    setDataSource(dataSource);//w ww.jav  a2 s  .c o  m
    setItemSqlParameterSourceProvider(new BeanPropertyItemSqlParameterSourceProvider<Product>());
    setSql("INSERT INTO product (description, price, purchase_date) VALUES (:description, :price, :purchaseDate)");
}

---

From source file:com.github.jrrdev.mantisbtsync.core.jobs.issues.writers.BugCustomFieldsWriter.java

/**
 * Default constructor.//from   w w w .j av  a2s. c  om
 */
public BugCustomFieldsWriter() {
    writer = new JdbcBatchItemWriter<BugCustomFieldValue>();
    writer.setItemSqlParameterSourceProvider(
            new BeanPropertyItemSqlParameterSourceProvider<BugCustomFieldValue>());
    writer.setSql(SQL_QUERY);
    writer.setAssertUpdates(false);
}

---

From source file:com.github.jrrdev.mantisbtsync.core.jobs.issues.writers.BugNotesWriter.java

/**
 * Default constructor./*  w  w  w. ja v  a 2s  .c  o m*/
 */
public BugNotesWriter() {
    writer = new JdbcBatchItemWriter<BugNoteBean>();
    writer.setItemSqlParameterSourceProvider(new BeanPropertyItemSqlParameterSourceProvider<BugNoteBean>());
    writer.setSql(SQL_QUERY);
    writer.setAssertUpdates(false);
}

---

From source file:com.github.jrrdev.mantisbtsync.core.jobs.issues.writers.BugHistoryWriter.java

/**
 * Default constructor./*from w w w.  j  a  v a2s  .c o  m*/
 */
public BugHistoryWriter() {
    writer = new JdbcBatchItemWriter<BugHistoryBean>();
    writer.setItemSqlParameterSourceProvider(new BeanPropertyItemSqlParameterSourceProvider<BugHistoryBean>());
    writer.setSql(SQL_QUERY);
    writer.setAssertUpdates(false);
}

---

From source file:com.github.jrrdev.mantisbtsync.core.jobs.projects.ProjectsWritersConfiguration.java

/**
 * Build the writer upserting the data related to the categories of a project.
 * Perform upsert in the mantis_category_table table.
 *
 * @param dataSource/*from w  ww  . j a v  a  2  s  .  c  o  m*/
 *          The datasource
 * @return the writer upserting the data related to the categories of a project
 */
@Bean
@StepScope
public JdbcBatchItemWriter<ProjectCategoryBean> projectCategoriesWriter(final DataSource dataSource) {

    final JdbcBatchItemWriter<ProjectCategoryBean> writer = new JdbcBatchItemWriter<ProjectCategoryBean>();
    writer.setItemSqlParameterSourceProvider(
            new BeanPropertyItemSqlParameterSourceProvider<ProjectCategoryBean>());
    writer.setSql(
            "INSERT INTO mantis_category_table (name, project_id)\n" + " SELECT :name, :projectId FROM dual\n"
                    + " WHERE NOT EXISTS (SELECT 1 FROM mantis_category_table dest\n"
                    + "         WHERE dest.name = :name AND dest.project_id = :projectId)");
    writer.setDataSource(dataSource);
    writer.setAssertUpdates(false);
    return writer;
}

---

From source file:io.spring.marchmadness.MooreStatConfiguration.java

@Bean
public ItemWriter<MooreNcaaStat> writer(DataSource dataSource) {
    JdbcBatchItemWriter<MooreNcaaStat> writer = new JdbcBatchItemWriter<MooreNcaaStat>();
    writer.setItemSqlParameterSourceProvider(new BeanPropertyItemSqlParameterSourceProvider<MooreNcaaStat>());
    writer.setSql("INSERT INTO MOORE_NCAA_STATS (YEAR, RANK, " + "NAME, " + "WIN, " + "LOSS, " + "TIE, "
            + "SOS, " + "PR ) VALUES (:year, :rank, :name, :win, :loss, :tie, :sos, :pr)");
    writer.setDataSource(dataSource);/*from   ww w.  j  av  a2  s.c o  m*/
    return writer;
}

---

From source file:com.apress.prospringintegration.batch.JobConfiguration.java

@Bean
public JdbcBatchItemWriter dataWriter() {
    JdbcBatchItemWriter jdbcBatchItemWriter = new JdbcBatchItemWriter();
    jdbcBatchItemWriter.setAssertUpdates(true);
    jdbcBatchItemWriter.setDataSource(dataSource);
    jdbcBatchItemWriter.setSql("insert into USER_REGISTRATION(FIRST_NAME, LAST_NAME, COMPANY,"
            + "ADDRESS, CITY, STATE, ZIP, COUNTY, URL, PHONE_NUMBER, FAX )"
            + "values (:firstName, :lastName, :company, :address, :city ,"
            + ":state, :zip, :county, :url, :phoneNumber, :fax )");

    jdbcBatchItemWriter.setItemSqlParameterSourceProvider(new BeanPropertyItemSqlParameterSourceProvider());

    return jdbcBatchItemWriter;
}

---

From source file:io.spring.marchmadness.NcaaStatConfiguration.java

@Bean
public ItemWriter<NcaaStats> writer(DataSource dataSource) {
    JdbcBatchItemWriter<NcaaStats> writer = new JdbcBatchItemWriter<NcaaStats>();
    writer.setItemSqlParameterSourceProvider(new BeanPropertyItemSqlParameterSourceProvider<NcaaStats>());
    writer.setSql("INSERT INTO NCAA_STATS (YEAR," + "RANK, " + "NAME, " + "RATING, " + "WIN, " + "LOSS, "
            + "SCHEDL, " + "SCHEDL_RANK, " + "WIN_TOP_25, " + "LOSS_TOP_25, " + "WIN_TOP_50, " + "LOSS_TOP_50, "
            + "PREDICTOR, " + "PREDICTOR_RANK, " + "GOLDEN_MEAN, " + "GOLDEN_MEAN_RANK, " + "RECENT,"
            + "RECENT_RANK) VALUES (:year, :rank, :name, :rating, :win, :loss, "
            + ":schedl, :schedlRank, :winTop25, :lossTop25, :winTop50, :lossTop50, "
            + ":predictor, :predictorRank, :goldenMean, :goldenMeanRank, :recent, " + ":recentRank)");
    writer.setDataSource(dataSource);/*from  w  w  w  .  ja  va2s. c om*/
    return writer;
}

---

From source file:io.spring.batch.configuration.BatchConfiguration.java

@Bean
protected JdbcBatchItemWriter<Customer> writer(DataSource dataSource) {
    JdbcBatchItemWriter<Customer> writer = new JdbcBatchItemWriter<>();
    writer.setDataSource(dataSource);/*w  ww .  ja v  a 2 s.c o  m*/
    writer.setSql("INSERT INTO CUSTOMER VALUES(:customerName, :qty)");
    writer.setItemSqlParameterSourceProvider(new BeanPropertyItemSqlParameterSourceProvider<Customer>());
    writer.afterPropertiesSet();

    return writer;
}

---

• «
• 1
• 2
• »