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
I suggest you go over the mySQL tutorial in freecodecamp channel before watching this video. I used the database I created while watching that video on this tutorial and it worked well for me :)
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.
We are glad you found our video helpful. Like and share our video with your peers and also do not forget to subscribe to our channel for not missing video updates. We will be coming up with more such videos. Cheers!
JDBC works as an interface between your Java Application and your SQL Database. Say you wanted to show the table called Students on a Java GUI application, jdbc would be your option.
Let’s say Facebook used Java for server logic. You try to fetch some data. That request reaches the server. Now, obviously, there aren’t people reading your queries, looking them up on SQL directly, and sending the results to you. You want your servers to be able to be able to do queries, and combine it with logic to produce presentable outputs. In this case, you can use JDBC. Are you trying to stalk someone on FB? Cool, let’s check if you have the permissions to do so (logic). You do? Okay, here’s the query (SQL Data). Now let’s send the data to you (networking logic). This happens on one server request.
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
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.
Hi, Simplilearn provides online training across the world. We would be happy to help you regarding this. Please visit us at www.simplilearn.com and drop us a query and we will get back to you! Thanks!
jdbc and file i/o are two different things. Jdbc is the interface between the Database management system (MySQL in this video) and the java application. File i/o is, as the name suggests, the java api used to input data in a file in the form of plain text or bytes.
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?
because 'universityData' is a string the getString method says: "Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language." it retrieves the current field in the table *as a String* I believe that we would get a data type mismatch exception if we would use getInt(), because universityData is String and not Integer
Hi, Simplilearn provides online training across the world. We would be happy to help you regarding this. Please visit us at www.simplilearn.com and drop us a query and we will get back to you! Thanks!
🔥Full Stack Developer (MERN Stack): www.simplilearn.com/full-stack-developer-course-mern-certification-training?OrEsC-QjUA&
🔥Full Stack Java Developer (Masters): www.simplilearn.com/java-full-stack-developer-certification?OrEsC-QjUA&
🔥Caltech Coding Bootcamp (US Only): www.simplilearn.com/coding-bootcamp?OrEsC-QjUA&
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
I suggest you go over the mySQL tutorial in freecodecamp channel before watching this video. I used the database I created while watching that video on this tutorial and it worked well for me :)
yeah i have no idea what he did with cmd
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.
We are glad you found our video helpful. Like and share our video with your peers and also do not forget to subscribe to our channel for not missing video updates. We will be coming up with more such videos. Cheers!
gotta love when he gets an error and just cuts the video as if this isnt a tutorial
Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!
Thank you so so much for this helpful video. I love how you guys make everything simple and break it down
Glad it was helpful!
You are the best person on CZcams right now!
Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!
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?
JDBC works as an interface between your Java Application and your SQL Database. Say you wanted to show the table called Students on a Java GUI application, jdbc would be your option.
I was gonna ask this question but I don't know why he hasn't answered yet
Let’s say Facebook used Java for server logic.
You try to fetch some data.
That request reaches the server.
Now, obviously, there aren’t people reading your queries, looking them up on SQL directly, and sending the results to you.
You want your servers to be able to be able to do queries, and combine it with logic to produce presentable outputs.
In this case, you can use JDBC. Are you trying to stalk someone on FB? Cool, let’s check if you have the permissions to do so (logic). You do? Okay, here’s the query (SQL Data). Now let’s send the data to you (networking logic).
This happens on one server request.
This is exactly what I needed, awesome video
Glad to hear it! Thank you for watching!
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?
on Mac OSX Workbench comes without MySql server, you got to install it separately.
Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!
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.
Thank you for bringing this to our attention. We’re sorry you had a bad experience. We’ll strive to do better
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 for bringing this to our attention. We’re sorry you had a bad experience. We will look into the dataset once again.
Well explained!
Thank you!
Great Example thank you.
Glad it was helpful!
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.
Hi, Simplilearn provides online training across the world. We would be happy to help you regarding this. Please visit us at www.simplilearn.com and drop us a query and we will get back to you! Thanks!
thanks a lot sir.
Most welcome
Good job! But sincerely speaking I didn't understand it.
Finally, someone with pure English accent
Hope you enjoyed our video! We have a ton more videos like this on our channel. We hope you will join our community!
AWESOME EXPALNATION THANK U SO MUCH
You are welcome!
I appreciate your useful video. Where can I find the code?
Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.
Great vid thanks!
Glad you liked it!
Interesting
Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!
Salamou Alaykom Thank you So much
Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : )
fr all the homies put throws SQLException even when it being caught in a try block
Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!
please can u tell me .........what is the difference between java file input/output and jdbc?
jdbc and file i/o are two different things.
Jdbc is the interface between the Database management system (MySQL in this video) and the java application.
File i/o is, as the name suggests, the java api used to input data in a file in the form of plain text or bytes.
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?
because 'universityData' is a string
the getString method says:
"Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language."
it retrieves the current field in the table *as a String*
I believe that we would get a data type mismatch exception if we would use getInt(), because universityData is String and not Integer
nice try on accent bro
Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!
A lot of unnecessary animations, just go straight to the point, thank you anyway
Thank you for your review. We’ll strive to do better.
Iam getting *terminated docsconnectionpropshelper * eror in every program. Please help
Hi, Simplilearn provides online training across the world. We would be happy to help you regarding this. Please visit us at www.simplilearn.com and drop us a query and we will get back to you! Thanks!