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

🔥Full Stack Developer (MERN Stack): www.simplilearn.com/full-stac...
🔥Full Stack Java Developer (Masters): www.simplilearn.com/java-full...
🔥Caltech Coding Bootcamp (US Only): www.simplilearn.com/coding-bo...
This video is based on Java JDBC Tutorial that explains about Java Database Connection. This Java JDBC Tutorial for beginners is designed to explain the JDBC programming fundamentals in a descriptive step-by-step manner for beginners to understand it with hands-on experience. this video includes the following
00:00 introduction to Java JDBC tutorial
This part of the Java JDBC tutorial gives a brief introduction to Java JDBC
00:30 What is java JDBC? (Java JDBC tutorial)
This part of the Java JDBC tutorial helps us to learn the technicalities of Java JDBC
01:00 need for Java JDBC (Java JDBC tutorial)
This part of the Java JDBC tutorial gives an explanation of the necessity of Java JDBC
01:12 Datatypes in Java JDBC (Java JDBC tutorial)
This part of the Java JDBC tutorial helps us to understand the various data types supported by Java JDBC
02:52 Java JDBC Architecture (Java JDBC tutorial)
This part of the Java JDBC tutorial gives a brief introduction to Java JDBC Architecture
03:30 Java JDBC Environment setup (Java JDBC tutorial)
This part of the Java JDBC tutorial gives you details on the Java JDBC environment setup
04:35 Steps to connect to Java JDBC (Java JDBC tutorial)
This part of the Java JDBC tutorial gives you the step by step procedure to connect to Java JDBC and the application API
07:05 Example of Java JDBC (Java JDBC tutorial)
This part of the Java JDBC tutorial gives a fully functional example based on Java JDBC.
➡️ About Post Graduate Program In Full Stack Web Development
This program will give you the foundation for building full-stack web apps using the Java programming language. You'll begin with the basics of JavaScript, and then venture into some of the more advanced concepts like Angular, Spring Boot, Hibernate, JSPs, and MVC. Now is the perfect time to get started on your career as a full-stack web developer!
✅ Key Features
- Caltech CTME Post Graduate Certificate
- Enrolment in Simplilearn’s JobAssist
- Receive up to 25 CEUs from Caltech CTME
- Simplilearn's JobAssist helps you get noticed by top hiring companies
- Attend Masterclasses from Caltech CTME instructors
- Live virtual classes led by industry experts, hands-on projects and integrated labs
- Online Convocation by Caltech CTME Program Director
- 20 lesson-end and 5 phase-end projects
- Capstone Project in 4 domains
- Caltech CTME Circle Membership
- Build your own portfolio on GitHub
✅ Skills Covered
- Agile
- JAVA
- Hibernate and JPA
- Spring Core 50
- DevOps
- HTML5 and CSS3
- AWS
- JavaScript ES6
- Servlets
- SOAP and REST
- JSP
👉 Learn More At: www.simplilearn.com/pgp-full-...
🔥🔥 Interested in Attending Live Classes? Call Us: IN - 18002127688 / US - [phone]

[@SimplilearnOfficial]

🔥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&

[@sehrishbalouch7068]

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

[@SimplilearnOfficial]

Glad it was helpful!

[@barraged999]

This is exactly what I needed, awesome video

[@SimplilearnOfficial]

Glad to hear it! Thank you for watching!

[@jacoblazar8952]

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.

[@SimplilearnOfficial]

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!

[@purleedef]

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

[@user-in8ht2oo5h]

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 :)

[@jason12518]

yeah i have no idea what he did with cmd

[@bibasniba1832]

You are the best person on KZbin right now!

[@SimplilearnOfficial]

Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!

[@TheSwanjae]

Great Example thank you.

[@SimplilearnOfficial]

Glad it was helpful!

[@_stack]

Well explained!

[@SimplilearnOfficial]

Thank you!

[@samriddhiyashaswini3617]

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?

[@ForcedPositivityMalayalam]

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.

[@tonyblinks5879]

I was gonna ask this question but I don't know why he hasn't answered yet

[@karanupamanyu3897]

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.

[@ItzDiizy]

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

[@SimplilearnOfficial]

Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!

[@michaelthomheadley]

Great vid thanks!

[@SimplilearnOfficial]

Glad you liked it!

[@yashwanthreddygowreddigari1997]

AWESOME EXPALNATION THANK U SO MUCH

[@SimplilearnOfficial]

You are welcome!

[@Andy_a7]

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

[@SimplilearnOfficial]

Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!

[@thekids4488]

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.

[@SimplilearnOfficial]

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!

[@aadityajaiswal7427]

thanks a lot sir.

[@SimplilearnOfficial]

Most welcome

[@nimasafavi8070]

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

[@SimplilearnOfficial]

Hello, thanks for viewing our tutorial. You can find your requested dataset in the video description. Hope that helps.

[@arnabsaha6414]

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?

[@toph_beifong]

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

[@SimplilearnOfficial]

Thank you for bringing this to our attention. We’re sorry you had a bad experience. We will look into the dataset once again.

[@vivianmardikios8577]

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

[@user-in8ht2oo5h]

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.

[@elissonsilvasantos9716]

Interesting

[@SimplilearnOfficial]

Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!

[@danoustn3229]

Salamou Alaykom Thank you So much

[@SimplilearnOfficial]

Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : )

[@ishanrastogi3049]

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.

[@SimplilearnOfficial]

Thank you for bringing this to our attention. We’re sorry you had a bad experience. We’ll strive to do better

[@aliyuumargumel7869]

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

[@elbozo5723]

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

[@SimplilearnOfficial]

Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!

[@rastaramen1536]

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?

[@LEONSKENNEDY91]

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

[@labrat3551]

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

[@SimplilearnOfficial]

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!

[@someverycoolusername6194]

Finally, someone with pure English accent

[@SimplilearnOfficial]

Hope you enjoyed our video! We have a ton more videos like this on our channel. We hope you will join our community!

[@AbhishekGupta-ji4pf]

nice try on accent bro

[@SimplilearnOfficial]

Thanks for watching our video and sharing your thoughts. Do subscribe to our channel and stay tuned for more. Cheers!

[@itrig7679]

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

[@SimplilearnOfficial]

Thank you for your review. We’ll strive to do better.