Spring JdbcTemplate:-
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:
1 We need to write a lot of code before and after executing the
query, such as creating connection, statement, closing resultset, connection
etc.
2 We need to perform exception handling code on the database logic.
3 We need to handle transaction.
4 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.