Java Database Connection: JDBC and MySQL

Java Database Connection: JDBC and MySQL

Learn how to connect to a MySQL database with Java JDBC




In this course, you learn how to connect to a MySQL database using Java JDBC.

The course starts with an overview of the JDBC API. Then you learn how to set up your development environment with the appropriate MySQL database drivers. Next the course shows you how to submit a SQL query and process the result set. Also, you learn how to perform SQL insert, updates and deletes.

The course moves on to advanced topics such as Prepared Statements to handle SQL paramaters. You also learn how to call stored procedures using various parameter types (IN, INOUT, OUT and ResultSet). Next, the course shows you how to process large data types such as BLOBs and CLOBs. Finally, the course wraps up with a section on reading database connection information from a configuration file.

Who Is This Course Suitable For?

Java developers: beginner, intermediate or advanced


You Will Learn How To

Connect to a MySQL Database with Java
Submit SQL statements to insert, update and delete data
Handle SQL parameters with Prepared Statements
Calls stored procedures and handle various parameter types (IN, INOUT etc..)
Read and write BLOB and CLOB data files
Configure your database connection information with properties files
Source Code

All source code is available for download
All database scripts are available for download
Course Requirements

You should have the following software already installed.

MySQL Database
Java Development Kit

What are the requirements?

Students should have basic knowledge of Java progamming.
Students should have basic experience with MySQL

What am I going to get from this course?

Over 18 lectures and 1.5 hours of content!
Connect to a MySQL Database with Java
Submit SQL statements to insert, update and delete data
Handle SQL parameters with Prepared Statements
Calls stored procedures and handle various parameter types (IN, INOUT etc..)
Read and write BLOB and CLOB data files
Configure your database connection information with properties files

What is the target audience?

The course is appropriate for all Java developers: beginners to advanced