JDBC (Java Database Connectivity) Introduction

JDBC for MySQL - 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

MySQL Installation on Windows

MySQL JDBC Driver (MySQL Connector/J)

MySQL - PreparedStatement

MySQL - Reference Implementation of JdbcRowSet

MySQL - JBDC CallableStatement

MySQL CLOB (Character Large Object) - TEXT

MySQL BLOB (Binary Large Object) - BLOB

Using Connection Pool with JDBC

Archived Tutorials

References

Full Version in PDF/EPUB