JDBC Tutorials - Herong's Tutorial Examples - v3.15, by Herong Yang
What Is JDBC?
This section provides a quick answer to the question of 'What is JDBC?'
JDBC (Java Database Connectivity) is an API (Application Programming Interface) that provides universal database access for the Java programming language. JDBC is the trademarked name and is not an acronym. But JDBC is often thought of as standing for "Java Database Connectivity."
The latest version of JDBC API specification is JSR-000221 JDBC API Specification 4.5 which is implemented in Java SE 26 and newer versions.
JDBC API 4.5 includes two packages:
The specification of JDBC 4.5 API is documented in JSR (Java Specification Request) 221 maintained by JCP (Java Community Process). See JSR 221: JDBC 4.0 API Specification at https://jcp.org/en/jsr/detail?id=221.
In order to use JDBC to connect Java applications to a specific database server, you need to have a JDBC driver that supports JDBC API for that database server. For example, Microsoft JDBC Drive allows you to access Microsoft SQL Server through the JDBC API.
Table of Contents
►JDBC (Java Database Connectivity) Introduction
Establishing Connections from JDBC to Databases
DriverManager - Loading JDBC Driver
DriverManager - Connection URL
Installing and Running Derby (Java DB)
Derby (Java DB) JDBC DataSource Objects
Derby (Java DB) - DML Statements
Derby (Java DB) - ResultSet Objects of Queries
Derby (Java DB) - PreparedStatement
Summary of JDBC Drivers and Database Servers