Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Java Database Connection: JDBC and MySQL
Rating: 4.5 out of 5(20,424 ratings)
227,493 students

Java Database Connection: JDBC and MySQL

Learn how to connect to a MySQL database with Java JDBC
Created byChad Darby
Last updated 5/2025
English

What you'll learn

  • 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

Course content

9 sections • 25 lectures • 1h 28m total length

  • Course Introduction1:28
  • Download Source Code0:32

    Download
    Download the zip file.

    - http://www.luv2code.com/downloads/udemy-jdbc/jdbc-source-code-v2.zip

    Extract the zip file.

    The zip file contains all of the source code used in the course.

    Setting up the Code
    1. In Eclipse, import the project for your desired lecture

    • For example, you can import files from the directory
    • lecture-03-setting-up-dev-environment


    2. Run the database setup script

    • Each lecture has a specific database setup script
    • You must run this before running the application
    • The script is located in the “sql” subdirectory of each lecture
    • For example with lecture 3, you will find it here:
    • lecture-03-setting-up-dev-environment/jdbc-test/sql/table-setup.sql
    • You can run the SQL script using a SQL tool such as MySQL Workbench


    3. Change the database connection info

    • In the source code, update the database URL, user id and password for your local environment


    4. Finally, run the program in Eclipse

Requirements

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

Description

This course assumes you have some knowledge of databases.

----------

Join 15,000+ highly engaged students


All source code is available for download

Responsive instructor available to answer your questions.

----------

Excellent 5-Star Reviews!

Very well designed course. I like clarity and delivery of contents. I wish there were more courses from Chad !!!!

- Satish Jain

I have to say that I was extremely pleased to note that his lecture material was straightforward and to the point. I was also impressed with how well he structured the contents! His presence was felt as he periodically showed interest in my progress. I would definitely recommend his material to anyone interested in expanding their programming knowledge with additional tools.

- Marc-Alexandru

If you want to learn everything about JDBC - this is the course for you! Excellent content. Brilliant explanation.

- Vishal Kumar

----------

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

Note: This course assumes you have some knowledge of databases.


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

Who this course is for:

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

Report abuse