Java Database Connectivity (JDBC) is an API specification for connecting and moving data from the frontend to the backend. The classes and interfaces are written in Java. Nowadays, it also supports Kotlin. We will write in Kotlin throughout this chapter. This basically acts as an interface or bridge between the Java-based application and database. JDBC is very similar to the Open Database Connectivity (ODBC). Like ODBC, JDBC enables a JDBC application to access a collection of data.
In the Spring Framework, the JDBC is divided into the following four separate packages:
- Core: This is the JDBC's core functionality and JdbcTemplate, SimpleJdbcInsert, and SimpleJdbcCall are the important classes of this core part
- DataSource: This is used to access data sources
- Object: The JDBC can access in an object-oriented manner. As a business object...