Spring JDBC Template:
The Spring JDBC Template has the following advantages compared with standard JDBC
The Spring JDBC Template has the following advantages compared with standard JDBC
- The Spring JDBC template allows to clean-up the resources automatically, e.g. release the database connections.
- The Spring JDBC template converts the standard JDBC SQLExceptions into RuntimeExceptions. This allows the programmer to react more flexible to the errors. The Spring JDBC template converts also the vendor specific error messages into better understandable error messages.
Read More:
This class represents the core of Spring’s JDBC support. It can execute all types of SQL statements. In the
most simplistic view, you can classify the data definition and data manipulation statements. Data
definition statements cover creating various database objects (tables, views, stored procedures, and so
on). Data manipulation statements manipulate the data and can be classified as select and update
statements. A select statement generally returns a set of rows; each row has the same set of columns. An
update statement modifies the data in the database but does not return any results.
The JdbcTemplate class allows you to issue any type of SQL statement to the database and return any
type of result.