16.2 Java Database Connectivity Practical
HTML-код
- Опубликовано: 20 июл 2024
- Check out our courses:
Spring and Microservices Weekend Live Batch : bit.ly/spring-live-weekend
Coupon: TELUSKO20 (20% Discount)
Master Java Spring Development : bit.ly/java-spring-cloud
Coupon: TELUSKO20 (20% Discount)
Udemy Courses:
Java:- bit.ly/JavaUdemyTelusko
Java Spring:- bit.ly/SpringUdemyTelusko
Java For Programmers:- bit.ly/javaProgrammers
Python : bit.ly/pythonUdemySummer
Git : bit.ly/Git-Telusko
Docker : bit.ly/docker_udemy
For More Queries WhatsApp or Call on : +919008963671
website : courses.telusko.com/
Instagram : / navinreddyofficial
Linkedin : / navinreddy20
TELUSKO Android App : bit.ly/TeluskoApp
this video tells about steps to follow for connecting java program to mysql database.
Java JDBC is a java API to connect and execute query with the database. JDBC API uses jdbc drivers to connect with the database.
7 Steps to Connect Application to database
1)Import the package
2)Load and Register driver
3)Create Connection
4)Create Statement
5)Execute the query
6)process the results
7)close connection
Editing Monitors :
amzn.to/2RfKWgL
amzn.to/2Q665JW
amzn.to/2OUP21a.
Editing Laptop :
ASUS ROG Strix - (new version) amzn.to/2RhumwO
Camera : amzn.to/2OR56AV
lens : amzn.to/2JihtQo
Mics
amzn.to/2RlIe9F
amzn.to/2yDkx5F
Java:- bit.ly/JavaUdemyTelusko
Spring:- bit.ly/SpringUdemyTelusko
More Learning :
Java :- bit.ly/3x6rr0N
Python :- bit.ly/3GRc7JX
Django :- bit.ly/3MmoJK6
JavaScript :- bit.ly/3tiAlHo
Node JS :- bit.ly/3GT4liq
Rest Api :-bit.ly/3MjhZwt
Servlet :- bit.ly/3Q7eA7k
Spring Framework :- bit.ly/3xi7buh
Design Patterns in Java :- bit.ly/3MocXiq
Docker :- bit.ly/3xjWzLA
Blockchain Tutorial :- bit.ly/3NSbOkc
Corda Tutorial:- bit.ly/3thbUKa
Hyperledger Fabric :- bit.ly/38RZCRB
NoSQL Tutorial :- bit.ly/3aJpRuc
Mysql Tutorial :- bit.ly/3thpr4L
Data Structures using Java :- bit.ly/3MuJa7S
Git Tutorial :- bit.ly/3NXyCPu
Donation:
PayPal Id : navinreddy20
www.telusko.com
this is 6 year old video and still most of developers are learning from this video.. that's what quality of teaching ...thank you navin sir.
better than hinduhater
Better than My Professor at my college.
@@sagargupta341 Respect is not a gift that should be given for free, it should be earned. if his professors aren't doing their intended task then he isn't obliged to respect them.
@@sagargupta341 it does, you aren't obliged to respect them if they haven't earned. I am tired of explaining this baseless arguement to many "I am entitled" people.
My too
@Suraj Kamble pune mere wale attitude khatarnak
@@sagargupta341 u r right and little bit wrong too.....giving respect is a quality but there are other qualities too we should use them 🤣😂
Thanks you Telusko sir , your way of teaching is very understandable , thank you again for sharing your knowledge to millions of people , God Bless you , keep doing it .
Hi
Telusko, your tutorials are excellent. Thanks, I appreciated your videos.
complex topics are made easy by Naveen sir and I love your way of explanation sir tq
Great tutor!You are so clear in what you are teaching and make the concepts easy to understand.Thank you Navin!
Sir you deserve more views and sunscribers
You are definitely one of the best teacher in the world
simple, effective and free of cost
May God bless you everywhere
Love you from the core of my heart 💓
I resonate with your view.
MAN... the satisfaction when the correct result is printed on your console :)
Very clear explanation
Every one easily understood for the JDBC tutorial
Great anna 👏👏keep it up way for more and more videos
This will help me alot for a School project i am working on thanks... and keep up the good work
Thank You So Much Navin Sir. In my batch maximum students are tensed just coz of Advance Java . But to be honest I wasn't as my Trainer is also their who is dedicatedly trying his best. The Main Reason I Was Relaxed JUST BECAUSE OF YOU SIR. Feeling so COOOOOOOOOL.
which year student are you ma'am
10:58 The table named gariblog, extremely relatable!
i hopefully guessed the error before 18:55 . Your teaching style is awesome sir!!
Thank you sir!! One of the greatest teachers ! Because of you only people from non CS background also can learn such difficult topics so easily! Your videos guide me in each and every step throughout my career. 🙏🙏
Steve Jobs!
to let u know i watched it complete
Thank you sir, I already worked with JDBC but I wanted to watch you video, cause I know there's something to learn from your video that others don't teach
i would make you understand in very less code
Wooww
Well thanks for all the vids so far i've learned alot especially since i had to look up alot for myself but that's fine since this is how it should be ! Oh and the very first person who found an Apple waaaaas EVA in the garden of Eden ;) !!!!
My course teacher left ths topic for self study (because she can't teach it), but telusko taught me very well.
Thanks a lot
Lol, she left the installation process for self study? Or the whole of Mysql itself? Lmao hahaha 🤣
Very well explained. Thankyou Naveen sir! :)
sir,your videos are awesome. Whenever i see your videos i will be knowing something new.
Thank you so much Telusko! Appreciate a Lot!
Naveen, Can you explain the difference between spring-jdbc and ojdbc jars ? and when one over the other is used.
Sir your way of teaching is imaginable
Sir you are my super hero..If I am the owner of DC I will definitely cast you as Superman
And Bum "Error" 😄
Best Java Teacher on RUclips Many Love From Pakistan
🥰
For those who are getting exception in connecting to database, use latest connector. 5.1.49 worked for me.
your teaching is very well brother. no one can tell like you
This video is really helpful. Thank you very much sir.
You !!! Such a blast man... I learned from basic of db connection just becoz of uhh 📈🙌🏻
naveen is a good man he share his own knowledge thousands of people with out nationality from Somalia
your videos are very helpful, i wish i could have found your channel sooner
Brilliant explanation...you are JDBC spiderman...
Great explanation. Thanks so much.
Great. Took a while for the set up.
i like the way u explain thank you sir............ keep it ahed
you helped me...thanks so much for these amazing videos
simply superub! sir thank you
It's grate education better performance my teacher
the legend Steve Job
thanks for this wonderful video.
@Bijendra Rathore bro chill. The OP's comment is itself 4 years old 😂😂
@@siddhantsingh3392 🤣
far far better than professor of my college
just got what i want . one word for - great.
Explained very well.
Great tutorial! Which macOS are you using?
Steve Jobs, Your videos are very easy to understand
how do you get the hyperlink help on key words to pop up those help libraries? do I have to install some help file libraries? if so which ones?
Awesome Explanation Navin
These videos are so damn good. Thanks a lot.
Hello sir, i am using sql plus and oracle 11g database so which driver should i use ??
Please let me know fast my project is pending
Best video on JDBC
thanks for the explanation sir ☺
A tidy explaination.😊
you are great teacher thanks sir
Awesome explanation Navin
Very very good explanation
Informative session,Brohh
12:26 Navin sir had 14K subs on Apr 2016, and 1.03M subs on 10 Jul 2020.
Great progress sir, all the best, keep it up.
And now 2.22M Subscibers
Best tutorial ever!!!!!!!!!!!!
I am in class 9. But still I can understand whatever you taught. Thanks a lot.
What are doing you here Amindra
Wowo
Bhai kya kr rha h
chutiya bna raha hai
@@abhishekmaurya9503 lol
You're gonna go a long way boy.
Sir, how to use scrap book in java instead going for workbench and what should be given in URL if scarp book is used
Here, we are using rs. next() only one time, which means the cursor will point to second row(Navin). For getting Mahesh we should use rs.next() one more time right?
Well done ! Keep on ...
Thank u so much it helped me alot.
Sir can u plz reply that how are u able to open connection.class, Driver.class file???
really good stuff , thanks alot
OP sir ho gya aapki kripa se
Sir, with out using netbeans and eclipse how can we add a library in notepad++ or codeblocks and how can we run this java program.
YOU ARE A LIFE SAVER.
best jdbc tut on utube
great explanation thank you
Sir, I have created a desktop application using java eclipse program to generate a random password and otp each time the user enters a user name,
The user name, generated password, otp are stored in mysql workbench using jdbc, the username attribute in the table is mentioned as primary key, so it restricts entry with same username i.e if the usename is already taken into database, the new user cannot request for password and opt with the same username, I want to set a time limit for the data entered in the data base
As the entered data remains into the database only for 30 minutes, so it becomes like a pre registration application for any event, where the user registers for the event, the generated password and otp are shown to the user which he has to physically note down, and then use it to get validated for entering the event within half an hour.
Please suggest me a way to increase the security and imposing the time constraint sir.
thanks for a good tutorial, and i pretend that i didn't see the movies you have downloaded at 5.06 🙈
Would you please shot a video on how to install and set up mysql database on mac and then connect to java.
Can anyone help me understand , how did Sir underlined DriverManager Class and checked methods inside ? any help would be appreciated
Does it matter what version of JDBC I download if I want to use Microsoft SQL server 2017?
getInt(), getString() can be used if there are fewer columns and you know the type of columns of the table. What if you want to display 20 or 50 or more columns? How do you iterate the value from a resultSet and display values of all the columns including null?
bro do you get the answer
resultSet.getNext();
Thank you so much, this video is so extraordinary helpful !!!!! I was exactly searching for this code-db-connection in Java, and there could not be any better explanation.. thank you so much from Munich, Germany :D
Glad it helped!
@@Telusko .. and it works! 😁 I have created an input GUI where names of current players of my favorite team (FCBayern) can be inserted into a database, then sorted by shirt number and given back (just as an example..)😆🙃 I owe you so much, not just for this tutorial but for all of them - thanx a million!!! 👍😆
@@health.upgradedbyscience.7309 Great work :)
Keep Learning, Keep Growing :)
Thank you, i will! 😄 Recently i mainly studied math with Abdul Baris algorithm tutorials.. such outstanding teachers, the two of you!! 👍highly appreciate all of your training and support!!!!!!!!!!!! 😆
thank you my life saver
Sir if i want to display the data with tabular format means if column name is " username " and I want to display the data with column name then how I can do that stuff....
Thanks a lot.
thank you sir..
Hi sir thanks alot for ur videos. Am 2012 passed out B. Tech with CSE, no job experience till now. I want to start career in IT,recently I completed core java training, I started to attend interviews but everybody is saying we want 2017 to 2019 passed outs, but my friends are suggesting AI and ML, DATA SCIENCE, course worth 3laks at iiit bangalore. What shall I do sir? Please suggest me to start career.
I have a question, How can getConnection() static method can return the instance of Connection interface, because Connection is an interface and we can not create instance for connection.
hi sir, this is a nice video.
U'RE THE BEST!!!!!
Thank you Sir . 👾
Really Thanks man😊
Thanks for video
Thank you so much sir...
thank you very much !
Sir how to connect jdbc if we are using mysql by phpmyadmin?
Thank you so much sir ❤️
Thank You Sir, Steve Jobs, Steve Wozniak, Ronald Wayne are the founders of Apple company.
thank you so much
sir if i want run my project in device but Database in another device in the local network
how do i do it ?
Great sir love u
Nice sirji 🔥
If you run above code first time then you may face time zone error so to tackle that error you have add
' ?useTimezone=true&serverTimezone=UTC' this sentence after your database name in URL
very good video sir
Is there a tutorial where you use Data Source instead of Driver Manager?
What are the sub objects will close when call connection.close. here using connection pool