Java NetBeans Tutorial: Connecting to a MySQL Database with JDBC and NetBeans

In this video you will learn how to connect to MySQL with Java and NetBeans.

Please subscribe to this channel 🙂

Download Java Source Code

Download Java Source Code

 

Video Transcript

Time – 00:00
Hi, this is Chad (shod) with luv2code.com. In this video, you will learn how to connect to MySQL with Java and NetBeans.

Time – 00:10
Let’s go over the development process. The first thing we’ll do is review the database tables, then we’ll download and add MySQL database driver to NetBeans, then we’ll actually create the Java code.

Time – 00:25
Let’s look at our database and see what data we have. We’ll move to the MySQL workbench tool. See that we have a table called Employees and then we’ll do a select star from that table and we’ll see that we have three employees currently in our database.

Time – 00:46
Now I’ll create a simple NetBeans project. I’ll go to the File menu, I’ll select new Project. Make sure the Java application is selected and click next. For the project name, I’ll give it jdbcdemo, I’ll click Finish. Now what I’ll do is I’ll add a new Java Class. I’ll select the project, I’ll right click, I’ll select New Java Class. For the name of the class I’ll enter demo and hit finish. Now I have a basic Java Class ready to go.

Time – 01:26
I will show you how to download the MySQL database driver and add it to your NetBeans project. First thing we have to do is visit the MySQL website at dev.mysql.com. On this page, we’ll choose the dropdown and we’ll select the platform independent. We’ll choose the second entry here, the ZIP Archive and we’ll click the download button. On the next page right near the bottom, we’ll say no thanks, just start my download. Then we’ll save it to our local system.

Time – 02:07
Now let’s move over to our Finder window on our file system and find the actual file that we just downloaded and I want to uncompressed it because right now it’s a ZIP. I’ll double click it, this will expand it or extract it. I’ll look at it through list view. Now I have this new directory with the artifacts and there’s a MySQL connector Java bin.jar, that’s the actual JDBC driver that we’ll use.

Time – 02:35
Now we need to copy this file to the NetBeans project directory. I’ll right click, I’ll select copy then I’ll switch over to NetBeans, I’ll click the files tab and I’ll select my project and I’ll right click and I’ll say paste. Even though the file is copied over, we still need to tell NetBeans that this a JAR library that we’ll use on our project. What I’ll do know is I’ll click on the projects tab, I’ll go to libraries and I’ll choose add library and now I’ll navigate to that NetBeans project directory where I actually have the file stored. Jbdcdemo and MySQL connector Java bin and I’ll select choose. Then I’ll expand this library’s folder and we’ll see that now this MySQL Java driver is part of this NetBeans project.

Time – 03:37
Now let’s start with the coding. The first thing I need to do is import Java to SQL package and then I’ll drop in code for this main map it and then I’ll walk through the code and show you how it works. This is our main map it, the main routine for the application. Then we have variables for the connection statement and result set. We also have the user id and password that we’ll use.

Time – 04:03
Then the first step is getting a connection to a database. We’ll use the URL, the user id and the password. Then we go through and we create a statement object. Then we use this statement object to execute SQL query, select star from employees, then we’ll process the result set and we’ll simply print out the last name of the employee along with the first name. We have our accession handler and then we also clean up our resources at the end once we’re done.

Time – 04:42
Then to actually run the application, we will right click, select run file and at the bottom we have our output. We have our three employees that were listed in the database and our Java program was able to access it successfully. Great.

Time – 04:59
Okay so this wraps up our video. You learned how to use NetBeans to connect to a MySQL database. Please subscribe to our channel to view more videos on Java, click thumbs up to like our video. Also visit our website luv2code.com to download the Java source code used in this video.

Did you like my blog post?

Signup now and receive an email when I publish new luv2code content.

I will never give away, trade or sell your email address. You can unsubscribe at any time.

8 Comments

  1. Comments  priyanka   |  Saturday, 21 March 2015 at 7:10 am

    hai i need to create login page -containing
    user
    passwrd
    port
    database
    ip address
    connect
    and cancel
    in java using netbeans and i hv to connect to mysql
    so tell me how i can do it plz help me

  2. Comments  Rishi   |  Sunday, 20 September 2015 at 9:25 am

    heii Priyanka give me our mail id. i send u complete code with tutorial

  3. Comments  Rishi   |  Sunday, 20 September 2015 at 9:30 am

    my mail id is jaykarrishi@gmail.com

  4. Comments  Jaz   |  Sunday, 13 December 2015 at 4:34 am

    Hi,
    Would you be able to show me your complete code for this tutorial? I am working on a 3-tier web application and need to set up mysql in netbeans. I’m having so much trouble 🙁

  5. Comments  Jaz   |  Sunday, 13 December 2015 at 4:43 am

    OH 😀 I found the problem!!!!! I imported java.bean.statement and netbeans got confused. Thank you!!

  6. Comments  Chad Darby   |  Sunday, 13 December 2015 at 9:49 am

    Hi Jasmine,

    Happy to hear your resolved your problem. Let me know if you need anything. 🙂

  7. Comments  jimber   |  Thursday, 17 December 2015 at 1:55 am

    sir can i have your sql?

  8. Comments  Chad Darby   |  Thursday, 17 December 2015 at 10:41 am

    The SQL script is in the source code download.

    Download using the links above. Unzip the file and look in “netbeans-jdbcdemo/sql/table-setup.sql”

    Let me know if you need anything else 🙂

Leave a Reply