MySQL JDBC Example

1. Connection

• Connecting to MySQL Using JDBC Driver
• Connection to MysQL Using JDBC Driver with Properties
• Connecting to MySQL via an Encrypted Connection using SSL
• Connecting to remote MySQL through SSH using Java

2. Database Metadata Info

• Extracting MySQL Database Metadata via JDBC Driver
• MySQL Database SQL Keywords

3. Data Type

• SQL Data Type vs Java Type
• Get Column Information from ResultSet MetaData
• Reading MySQL Spatial Data Type
• Writing and Reading MySQL BLOB Data Type
• Writing and Reading MySQL Text Data Type

4. Query Execution

• Count Records
• JDBC Select Statement Example
• JDBC Update Statement Example
• JDBC Insert Statement Example
• JDBC Delete Statement Example
• executeQuery, executeUpdate and execute method
• Calling MySQL Stored Procedures from JDBC

5. Transaction

• Committing and Rolling Back a Transaction
• Transaction Isolation Levels
• Show Current Active Transaction

6. Export and Import

• Exporting and importing data between MySQL and File(Json, Excel, CSV)

7. MySQL Dictionary

7.1 Database

• Creating and Selecting a Database

7.2 User

7.3 Table

7.4 View

7.5 Procedure

7.6 Function

7.7 Event

8. Spring JDBC

9. JDBC Connection Pool

• HikariCP
• DBCP

References