Java JDBC tutorial | Java Database Connectivity | Java Tutorial For Beginners | Simplilearn

Good job! But sincerely speaking I didn't understand it.

Great tutorial. 1. How do we hide the password? 2. Instead of hard-coding the number of columns, isn't there some variable (e.g. result.getNumColumns()) that will automatically get the number of columns from the resutset?

thanks a lot sir.

A lot of unnecessary animations, just go straight to the point, thank you anyway

Finally, someone with pure English accent

I am getting this exception

java.sql.SQLException: Access denied for user 'port'@'localhost' (using password: YES)

Can you tell me what is the issue?

nice try on accent bro

Salamou Alaykom Thank you So much

I appreciate your useful video. Where can I find the code?

It would have been a lot more helpful if you had zoomed in, can't see a single thing clearly,, specially since its light mode.

/iload_1 ~ D=FGg(xy) returnsz f(xy fusion) + iaload ifne 16Aa'b'CB radii u 35deg /

fr all the homies put throws SQLException even when it being caught in a try block

Awesome tutorial for explaining the basics of integrating a MySQL locally hosted server into a java application. I do have a note however. You should be a little more specific in configuration of the connection and warn users that the username and password have to exactly match the SQL setup. or like to pause the video and write down their credentials for later use in the app because i could see some people getting lost there. I got mine up and running and was really excited to start adding custom entries on the SQL side just to run the java app and see that they would appear like magic. your breakdown of how each line of code is connected from driver>connection>statement was especially helpful, as was your reiteration that the query will be how you effectly "speak to" your database from the app. seriously thank you.

Good tutorial, but I'm wondering why you didn't implement reading the data from the ResultSet using specific data types and an index value instead of a loop?

while (rset.next()) {
String universityData = "";

int pos = 0;
universityData += rset.getInt(++pos) + " ";
universityData += rset.getString(++pos) + " ";
universityData += rset.getString(++pos) + " ";
universityData += rset.getString(++pos) + " ";
universityData += rset.getInt(++pos) + " ";
universityData += rset.getInt(++pos) + " ";

System.out.println(universityData);
}

Is there a reason he didn't use this method?

in the last query when you looked at the min for university rank, why did Kiran show up when Raju had the lowest? Also, you said 96 when it read 98??? I'm so confused now

Thank you so so much for this helpful video. I love how you guys make everything simple and break it down

Interesting

gotta love when he gets an error and just cuts the video as if this isnt a tutorial

Great vid thanks!

Do i need to create a connection every time I use a different method? I am trying to create a method to search the database and another method to update the database and im a little confused.

Great Example thank you.

Iam getting *terminated docsconnectionpropshelper * eror in every program. Please help

on Mac OSX Workbench comes without MySql server, you got to install it separately.

please can u tell me .........what is the difference between java file input/output and jdbc?

Thank you for the great explanation. I had a question. If we can simply do the same actions from SQL directly, what is the need of using JDBC?

This is exactly what I needed, awesome video

AWESOME EXPALNATION THANK U SO MUCH

There's a few things I wish you hadn't glossed over: Installing MySQL, setting up a server and being able to run it from the command line, ensuring it was compatible with java and the connector and so forth because they gave me a lot of headaches and weren't covered in the video. However, all the content from about 16 minutes up until the end of the video was explained well and helped me a lot with some questions I had about what was going on in the code. My only real question is how can I get the program to open the initial connection to the server? If I don't have it open and running on the command line, the connection gets rejected by jdbc

Well explained!