Breaking News: Grepper is joining You.com. Read the official announcement!

What is the better method of using JDBC in Spring?

Anjali Sharma answered on January 9, 2023 Popularity 1/10 Helpfulness 1/10

answer What is the better method of using JDBC in Spring?

What is the better method of using JDBC in Spring?

Comment

If JDBC is used with the template class called JdbcTemplate, it gives a better performance.

public class RelationalDataAccessApplication implements CommandLineRunner {

  private static final Logger log = LoggerFactory.getLogger(RelationalDataAccessApplication.class);

  public static void main(String args[]) {
    SpringApplication.run(RelationalDataAccessApplication.class, args);
  }

  @Autowired
  JdbcTemplate jdbcTemplate;

  @Override
  public void run(String... strings) throws Exception {

    log.info("Creating tables");

    jdbcTemplate.execute("DROP TABLE customers IF EXISTS");
    jdbcTemplate.execute("CREATE TABLE customers(" +
        "id SERIAL, first_name VARCHAR(255), last_name VARCHAR(255))");

    // Split up the array of whole names into an array of first/last names
    List<Object[]> splitUpNames = Arrays.asList("John Woo", "Jeff Dean", "Josh Bloch", "Josh Long").stream()
        .map(name -> name.split(" "))
        .collect(Collectors.toList());

    // Use a Java 8 stream to print out each tuple of the list
    splitUpNames.forEach(name -> log.info(String.format("Inserting customer record for %s %s", name[0], name[1])));

    // Uses JdbcTemplate's batchUpdate operation to bulk load data
    jdbcTemplate.batchUpdate("INSERT INTO customers(first_name, last_name) VALUES (?,?)", splitUpNames);

    log.info("Querying for customer records where first_name = 'Josh':");
    jdbcTemplate.query(
        "SELECT id, first_name, last_name FROM customers WHERE first_name = ?", new Object[] { "Josh" },
        (rs, rowNum) -> new Customer(rs.getLong("id"), rs.getString("first_name"), rs.getString("last_name"))
    ).forEach(customer -> log.info(customer.toString()));
  }
}

https://spring.io/guides/gs/relational-data-access/

Popularity 1/10 Helpfulness 1/10 Language javascript

Source: Grepper

Tags: javascript jdbc using

Link to this answer
Share Copy Link

Contributed on Jan 09 2023

Anjali Sharma

0 Answers Avg Quality 2/10

What is the better method of using JDBC in Spring?

Contents

More Related Answers

What is the better method of using JDBC in Spring?

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.