22.1 - Setting a connection to the database using Spring JDBC
22.2 - Using the JdbcTemplate Class to view member information
JDBC (Java Database Connectivity) serves as the foundation of Java data access technologies, making it a widely used data access technique that most developers can easily grasp. However, as time has passed, SQL queries have become overly complex, leading to difficulties in development and maintenance.
Particularly, improper handling of shared resources like the Connection object has become a source of bugs. Spring's JDBC addresses these drawbacks while preserving the strengths of the traditional JDBC. It not only provides a concise API but also offers enhanced features of JDBC.
While practical development often involves using database-related frameworks like MyBatis or Hibernate rather than Spring JDBC, understanding the fundamental features of Spring JDBC can still be helpful.
In the DAO class, the class that provides the actual JDBC functionality of Spring is called JdbcTemplate.
SQL related methods provided by the JdbcTemplate Class