Spring 5 Design Patterns

Solving problems with Spring's JdbcTemplate

Spring's JdbcTemplate solves both the problems listed in the last section. JdbcTemplate greatly simplifies the use of the JDBC API, and it eliminates repetitive boilerplate code. It alleviates the common causes of bugs, and handles SQLExceptions properly without sacrificing power. It provides full access to the standard JDBC constructs. Let's see the same code using Spring's JdbcTemplate class to solve these two problems:

• Removing redundant code from the application using JdbcTemplate: Suppose you want a count of the accounts in a bank. The following code is required if you use the JdbcTemplate class:

        int count = jdbcTemplate.queryForObject("SELECT COUNT(*)         FROM ACCOUNT", Integer.class); 
 

If ...