JDBC Tutorial for Beginners #2 : Connecting Java Program to MySQL Database

In this video, I have shown how to connect our Java program with an existing database in mysql. The URL structure of mysql is also explained. At the end of the video, a successful connection is made to the database from the program.

This tutorial series covers following topics
■ Connecting Java Program to MySQL Database
■ Inserting data into database
■ Fetching data from database
■ Updating an entry in database
■ Creating a table programmatically
■ Using PreparedStatements
■ Display database contents in JTable

- Genuine Coder

[chelidoniii]

thank you so much sir from the philippines

[GelsYT]

to everyone out there getting an error about the Driver, the new location for the driver is
com.mysql.cj.jdbc.Driver
not com.mysql.jdbc.Driver
They have deprecated the old one in jdk 13

[interactived]

If you making tutorial, please, show all steps in 3 IDEs (Netbeans, Eclipse, IDEA). Can't understands step 2 in Eclipse IDE

[iimsleeepy]

after running my program, it says that "Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary."

What do i do

[motan]

This video was very helpful, was having troubles with the jdbc driver

[LZAEEM]

there an error you will get
..
WARN: Establishing SSL connection without server's identity verification is not recommended.
..
the short solution
..

[medhatahmed]

hello genuine coder..how did you import driver manager in this tutorial i’m a little bit confused in how you did it

[mikresimir]

this is best on line tutorial for Connecting Java to MySQL, thank you

[bryanen]

Hi, I have a question about the coding, in the video 7:30 he make the DataBaseProject Pro = new DataBaseProject(); pro.createConnection
I try it my way
DataBase1 pro = new DataBase1();
pro.createConnection();
why the first linehave to put new database ???? DataBase1 pro = new DataBase1();

[ncky]

I get the following error message:


The server time zone value 'Mitteleurop?ische Sommerzeit' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.


Can anybody help please?

[mahdihassani]

Thanks for this tutorial and if you have complete java tutorial please put it.

[liliabaluk]

Thank you for this tutorial, very helpful!

[Titan-dvry]

hey how do you get that "fix all imports" tab quickly whats the shortcut key (6.48)

[mayankpanjabi]

Hii
My question is
1.Server status are no open.
2.runtime are database connection failure.
3.l open server status then come error, error is runtime error: C:/Windows/system 32 include in path to environment variable.
I am including path environment variable but not open server status how can solve this problem.you will explain.

[garrett]

Volume is too low.
Remember, we can always turn down, but can only turn up so far.

[manishkumawat]

Really you are genuine coder.
loved your tutorials.
very helpful...

[ccguru...]

Hello Genuine Coder.
I want to make an application for Desktop Computer. But I want it in a such way that the user will select database after or while installation. Help me in this regard.

[PushpendraKumar-ckop]

thanks man, was stuck on this for long time

[Monray]

thanks for these awesome tutorials, please keep them coming!!