JdbcTemplate- Table 19.1. Spring JDBC - who does what?
| Action |
Spring |
You |
| Define connection parameters. |
|
X |
| Open the connection. |
X |
|
| Specify the SQL statement. |
|
X |
| Declare parameters and provide parameter values |
|
X |
| Prepare and execute the statement. |
X |
|
| Set up the loop to iterate through the results (if any). |
X |
|
| Do the work for each iteration. |
|
X |
| Process any exception. |
X |
|
| Handle transactions. |
X |
|
| Close the connection, statement and resultset. |
X |
|
- @Transactional
org.springframework.transaction.annotation.Transactional
@Transactional
public void book(String... persons) {
for (String person : persons) {
logger.info("Booking " + person + " in a seat...");
jdbcTemplate.update("insert into BOOKINGS(FIRST_NAME) values (?)", person);
}
}
