MySQL JDBC Driver (MySQL Connector/J)

JDBC for MySQL - Herong's Tutorial Examples

∟MySQL JDBC Driver (MySQL Connector/J)

This chapter provides tutorial notes on MySQL JDBC driver. Topics include installing MySQL JDBC driver; connection URL and DriverManager class; DataSource and Connection objects; server and driver information; creating tables with auto-increment columns.

MySQL Connector/J - Download and Installation

Loading JDBC Driver for MySQL Server

JDBC Driver Connection URL

Specifying Timezone During Connection

Creating Connections with DataSource Class

Getting Driver and Server Information

Creating Tables with AUTO_INCREMENT Columns

"INSERT INTO" Statements

Takeaways:

MySQL Connector/J is the JDBC driver for Java applications to access MySQL database server.
The connection URL for the MySQL Connector/J JDBC driver is "jdbc:mysql://[host][:port]/[database][?user=xxx&password=xxx]".

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