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

Creating Connections with DataSource Class

Getting Driver and Server Information

Creating Tables with AUTO_INCREMENT Columns

"INSERT INTO" Statements

Takeaways:

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