Connect to Mysql database with java (Netbeans)

How to connect my a MySQL Database using Netbeans 8.0.2, Java, and PHP myAdmin. Also show how to write an insert statement using java

Table of Contents:

[alexbmx]

was trying yesterday stoned about 4hours to connect my db with eclipse and i failed, i woke up this morning, i downloaded Netbeans and i followed ur steps, and i did my connection + insert query in about 15mins. JUST THANKS !!

[yesicachristina]

I'm a beginner, and some days I'm confused about this. Thank you very much, this video is very helpful. <3

[saulogueds]

I don't know why ppl still dislike a video like this.. Thank you Juan! Excellent video!

[lalittomar]

thank you so much bro it even work in 2021 with some changes in SQL !! YOU MADE MY DAY THANKS BROTHER !!

[crisucris]

Surprised people disliked this. It works as intended.

[fransiscusstephanus]

2019 and it still work!!! really helpful

[ilhamakhyar]

if you have the problem with database connection... maybe this one can help you

first make sure you have database for the connection, you can create it using phpMyadmin. After that back to netbeans, on the left side there's 3 tabs (projects, files, services) click on services tab and you can see there's name "Databases" list, click on "MySQL Server at localhost...." . Inside you can see list of the database name, right click and click again connect (type the your database username and password) After that you can see something like and that is your connection

remember that's the number of the connection (3306 for me) for every computer maybe different

[gunfireminiplay]

Great video, just saved me a lot of time

[arverezzle]

if you guys got this error:
.
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax
.
.
instead of separating the value like " String Fname: "jame"; " try to just write it on stmt.executeUpdate()
.
For Example:
.
stmt.executeUpdate("INSERT INTO video(id_vid, nama_vid, lokasi_vid, extension_vid)" + "VALUES ('1', 'Xenojiiva', 'videos', 'mp4')");
.
i hope this help you

[vanko]

Very good tutorial Juan. Thanks a lot! It would be great if all the tutorials online were like that!

[samintha]

Thanks for your video. But I cannot browse apple desktop subfolder like you did. Do you know why ?

[saticin]

Great help for me this video, he clearly describe how connect mysql database for beginners.

[arsalaninam]

Sir. when i use the insert query . It gives me this error You have an error in your SQL syntax;"

[matanissler]

Thank you very much! I found out that MySQL is a great tool!

[princesselizabethsayam]

what if I extract the connector/j but it only have one jar file on files of msql connector. instead of having mysql jar and mysql bin.jar, I only have mysql jar file. help

[mattvideo]

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near i keep getting this error why is that so?

[adilhussainbhatti]

WoW!
it helps alot sir.Thanx Juan Nadal

[user__]

i hop the oposite from DB SQL to netbeans !! i hope to make the table from phpmyadmin TO netbeans ! can same1 help me ?

[kkwilson]

Hey, In adding the Connection/J jar file to your project, you right-clicked and selected "add jar folder". But I don't get this option when I right-click. Am I missing something?

[kushanedirisuriya]

sir if i iuse jsp is there any different in thius process?