Java Database Connectivity JDBC

Java Database Connectivity JDBC

Java Database Connectivity (JDBC) JDBC Architecture and API Java Database Connectivity (JDBC) is a standard Java API that allows Java applications to interact with relational databases. JDBC provides a mechanism for connecting to a database, executing SQL queries, and processing the results. It acts as an abstraction layer that hides the complexities of direct database access from developers. 1. JDBC Architecture The JDBC architecture is based on a client-server model. It involves several components that work together to facilitate database communication. Key Components of JDBC Architecture: JDBC API (Java Application) : The API that developers use to connect to the database. It provides interfaces and classes to interact with the database. JDBC Driver Manager : The Driver Manager acts as an intermediary between the Java application and the specific database drivers. It manages the database drivers that are installed on the system. JDBC Drivers : These are specific implementations of the java.sql.Driver interface that communicate with the database. There are four types of JDBC drivers: JDBC-ODBC Bridge Driver (Type 1) Native-API Driver (Type 2) Network Protocol Driver (Type 3) Thin Driver (Type 4) Database : The database that the Java application is interacting with, such as MySQL, Oracle, or PostgreSQL.

Updated July 15, 2026