Spring JdbcTemplate is a powerful mechanism to connect to the database and
execute SQL queries. It internally uses JDBC api, but eliminates a lot of
problems of JDBC API.The JdbcTemplate can be used within a DAO implementation
through direct instantiation with a DataSource reference, or be configured in a
Spring IoC container and given to DAOs as a bean reference.
Problems of JDBC API:
The problems of JDBC API are as follows:
We need to write a lot of code before and after executing the
query, such as creating connection, statement, closing resultset, connection
We need to perform exception handling code on the database logic.
We need to handle transaction.
Repetition of all these codes from one to another database logic
is a time consuming task.
Advantage of Spring JdbcTemplate:
Spring JdbcTemplate eliminates all the above mentioned problems of JDBC
API. It provides you methods to write the queries directly, so it saves a lot of
work and time.