MySQL Tutorials - Herong's Tutorial Examples - v4.40, by Dr. Herong Yang
Java Programs and MySQL Servers
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 Class - com.mysql.cj.jdbc.Driver
Connection URL Tests on Older MySQL Connector/J
Creating Connections with DataSource Class
Getting Driver and Server Information
Takeaways:
Table of Contents
MySQL Introduction and Installation
Introduction of MySQL Programs
Perl Programs and MySQL Servers
►Java Programs and MySQL Servers
Character Strings and Bit Strings
Table Column Types for Different Types of Values
Using DDL to Create Tables and Indexes
Using DML to Insert, Update and Delete Records
Using SELECT to Query Database
Transaction Management and Isolation Levels
Defining and Calling Stored Procedures
Variables, Loops and Cursors Used in Stored Procedures
Using Administration Statements
Installing MySQL Server on Linux