Java Connect to MySQL Database Step by Step

Learn to write Java code that connects to a MySQL database, inserts a row to a table and get all rows from that table.

Here's what you will learn in this video:
- Create a database in MySQL server using MySQL Command Line Client and MySQL Workbench
- Use MySQL JDBC driver (Connector/J): download MySQL JDBC driver manually; and use Maven dependency
- Code a Java Project:
+ Connect to MySQL database server
+ Insert a new row to the database
+ Get all rows from the database
+ Close the connection

Required Software Programs:
+ Java Development Kit (JDK)
+ MySQL Database Community Server
+ MySQL Workbench
+ Eclipse IDE

This tutorial is perfect to start database programming with Java, using MySQL as the database.

[AK-usby]

Best Tutorial to learn JDBC to Mysql. Easy step by step guide and very helpful for beginners. All you need is to open the Eclipse and follow the steps.

[Alexast]

Genuinely the best Java - MySQL tutorial I found

[fadjamah]

Definelty the best tutorial on JDBC and MySQL. You saved my project. Thank you. Thumbs up (Y)

[vulcangaming]

I absolutely loved this!! Great job man. Loved how you made a humanly mistake in that sql index query. that went a long way to show how honest this is!

[manojp]

Thanks you much sir very helpful video ❤💕

[zettaabyte]

Really helpful. Thanks for the tutorial and I subbed!

[krupeshrao]

Very well explained stuff. Thank you so much.

[nicholascamatti]

Very good video and well explained! Thanks.

[Chathumal]

Thanks a lot.. Quick and Efficient tutorial

[anelemadonda]

thank you very much. this course helped me a lot

[chippandenga]

Great video. my man. Very detailed and indeed step-by-step. Thanks

[jewishbanana]

So if I set up a databse and send an executable to another pc does the pc also need to install MySQL or it just needs to run the executable?

[redscarlet]

I rarely give likes but you deserve a like for saving my time

[sugardaddy]

Thanks you soo much sir you help me alot

[crazy_tolstoy]

Is there any way i connect my project with mysql database on another pc, instead of localhost? Tnx in advance :)

[vijiajay]

I have downloaded command line for python sql ... is this same as for Java?

[ironman.]

Still showing errors, connection isn't established 😔

[rizeli]

Are you on fiverr? If yes what's your contact?. Best

[ilavarasansriraman]

Ravi kumar & Anandi krishna.. Those are indian 🇮🇳👳 names ❤