JDBC (Java Database Connectivity) Introduction

JDBC for Oracle - Herong's Tutorial Examples

∟JDBC (Java Database Connectivity) Introduction

This chapter provides a quick introduction about JDBC (Java Database Connectivity). Topics include overview of JDBC; versions of JDBC; JDBC driver types; database connection with DriverManager and DataSource; JDBC driver class and connection URL for DriverManager.

What Is JDBC?

JDBC Version and History

JDBC Driver Types

Establishing Connections from JDBC to Databases

DriverManager - Loading JDBC Driver

DriverManager - Connection URL

Takeaways:

JDBC (Java Database Connectivity) is a Java API that provides universal database access for the Java programming language.
The current version of JDBC API specification is 4.3 and maintained by the JSR 221 group.
JDBC 4.3 has been implemented in Java SE and JDK since version 9.

Table of Contents

About This Book

►JDBC (Java Database Connectivity) Introduction

JDK (Java SE) Installation

Oracle Express Edition Installation on Windows

Oracle JDBC Drivers

Oracle - Reference Implementation of JdbcRowSet

Oracle - PreparedStatement

Oracle - JBDC CallableStatement

Oracle CLOB (Character Large Object) - TEXT

Oracle BLOB (Binary Large Object) - BLOB

Using Connection Pool with JDBC

Archived Tutorials

References

Full Version in PDF/EPUB