How to use JDBC Template classes to control basic JDBC processing and error handling
The JdbcTemplate class is the central class in the JDBC core package. It simplifies the use of JDBC as it handles the creation and release of resources. So common problem such as forgetting to close the connection is handled by Spring Container. It executes the core JDBC workflow like statement creation and execution, so application code only provides SQL statements and extracts results. This class executes SQL queries, update statements or stored procedure calls, doing iteration over ResultSets and extraction of returned parameter values. It also has ability to catch JDBC exceptions and translates them to more informative, exception.