What is Spring JdbcTemplate and what is the problem of JDBC API?
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.
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.
Read More →