Scribd
Upload
7 views3 pages

JDBC Connecting Java Applications To Databases

JDBC (Java Database Connectivity) is an API that connects Java applications to various relational databases, allowing for efficient execution of SQL queries and data manipulation. It features a standardized architecture with four layers and supports multiple driver types, primarily using Type-4 drivers for direct database communication. JDBC is essential for a range of applications, from simple tools to complex enterprise systems, ensuring database independence and reliability.

Uploaded by

sanchishubhra2119
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
7 views3 pages

JDBC Connecting Java Applications To Databases

JDBC (Java Database Connectivity) is an API that connects Java applications to various relational databases, allowing for efficient execution of SQL queries and data manipulation. It features a standardized architecture with four layers and supports multiple driver types, primarily using Type-4 drivers for direct database communication. JDBC is essential for a range of applications, from simple tools to complex enterprise systems, ensuring database independence and reliability.

Uploaded by

sanchishubhra2119
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

JDBC Java

⑦ API apps.
JDBC: Connecting Java Applications to Databases
JDBC (Java Database Connectivity) is a powerful API that serves as a bridge between Java applications and relational databases. It enables Java
programmes to seamlessly connect to databases, execute SQL queries, and retrieve or manipulate data efficiently. The beauty of JDBC lies in its
database independence—developers can write code once and use it with different database systems like MySQL, Oracle, PostgreSQL, SQL Server,
and more without major modifications.

This standardised approach has made JDBC the foundation for database operations in Java applications, from simple desktop tools to complex
enterprise systems. Whether you're building a banking application, e-commerce platform, or content management system, JDBC provides the
essential functionality to interact with your data layer reliably and efficiently.
Java Application (senulet, applet)

allows Java
JDBC API to execute
SQL & get
results from
database.
> Be Driver
Drivers.

☐
SQL oracle Postgresql
JDBC Architecture and Processing Models
Core Components Driver Types
The JDBC architecture consists of four essential layers working JDBC supports four driver types, though modern development
together: primarily uses Type-4:

01
1 2
Application Layer
JDBC-ODBC Bridge Native-API
Java applications or servlets that need database access
Deprecated, no longer 2 Partially Java, uses native
02 supported libraries
JDK 1.2 ◦¥#ideas
JDBC API
Interfaces (Driver, Connection, Statement, PreparedStatement, 3 4
ResultSet) and classes (DriverManager, Types) for database operations
Network Protocol Thin Driver
03
Fully Java, middleware Fully Java, direct database
DriverManager approach communication—most
widely used today
Manages database-specific drivers and establishes connections
Socket information.

04

JDBC Drivers
Handle communication between application and database

Processing Models

Two-Tier Architecture Three-Tier Architecture


Java application communicates directly with the User requests flow through a middle-tier
database through JDBC driver. Ideal for client- application server before reaching the
Tara server setups where the application runs on the database. The server processes queries, applies
senolet ↓
user's system and connects to a remote Application business logic, and returns results to the client
JDBC server
database server. —commonly used in enterprise web
Driver Java JDBC
applications.
→ Drioa
Senulet
client SQL

You might also like