Spring JdbcTemplate Notes

Spring provides the jdbctemplate to encapsulate the database JDBC operation details,
Includes: Database connection [on/off], exception escaping, SQL execution, conversion of query results,

Which embodies the pattern of template design mode of thought.

With spring JdbcTemplate, developers only need to complete two of these coding tasks.

2. Specify database connection Parameters

4. Open a database connection

6. Declaring SQL statements

8. precompiling and executing SQL statements

10. Traverse Query Results (if needed)

12. Handle each traversal operation

14. Handle any exceptions that are thrown

16. Processing transactions

18. To close a database connection

Spring will do all the tedious JDBC bottom-level detail work for us.

Spring JdbcTemplate Notes