16.2 Java Database Connectivity Practical
Vložit
- čas přidán 27. 07. 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
MAN... the satisfaction when the correct result is printed on your console :)
Great tutor!You are so clear in what you are teaching and make the concepts easy to understand.Thank you Navin!
10:58 The table named gariblog, extremely relatable!
This will help me alot for a School project i am working on thanks... and keep up the good work
Very clear explanation
Every one easily understood for the JDBC tutorial
Great anna 👏👏keep it up way for more and more videos
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.
Steve Jobs!
to let u know i watched it complete
Very well explained. Thankyou Naveen sir! :)
i hopefully guessed the error before 18:55 . Your teaching style is awesome sir!!
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 ;) !!!!
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. 🙏🙏
sir,your videos are awesome. Whenever i see your videos i will be knowing something new.
Thank you so much Telusko! Appreciate a Lot!
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
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
Sir your way of teaching is imaginable
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 🤣
Sir you are my super hero..If I am the owner of DC I will definitely cast you as Superman
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 📈🙌🏻
And Bum "Error" 😄
Best Java Teacher on CZcams Many Love From Pakistan
🥰
you helped me...thanks so much for these amazing videos
For those who are getting exception in connecting to database, use latest connector. 5.1.49 worked for me.
Brilliant explanation...you are JDBC spiderman...
These videos are so damn good. Thanks a lot.
i like the way u explain thank you sir............ keep it ahed
Great explanation. Thanks so much.
your videos are very helpful, i wish i could have found your channel sooner
naveen is a good man he share his own knowledge thousands of people with out nationality from Somalia
Great. Took a while for the set up.
the legend Steve Job
thanks for this wonderful video.
@Bijendra Rathore bro chill. The OP's comment is itself 4 years old 😂😂
@@siddhantsingh3392 🤣
simply superub! sir thank you
Awesome Explanation Navin
just got what i want . one word for - great.
Explained very well.
Best tutorial ever!!!!!!!!!!!!
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
far far better than professor of my college
thanks for the explanation sir ☺
Steve Jobs, Your videos are very easy to understand
A tidy explaination.😊
Awesome explanation Navin
Well done ! Keep on ...
YOU ARE A LIFE SAVER.
It's grate education better performance my teacher
you are great teacher thanks sir
Naveen, Can you explain the difference between spring-jdbc and ojdbc jars ? and when one over the other is used.
really good stuff , thanks alot
best jdbc tut on utube
Best video on JDBC
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.
U'RE THE BEST!!!!!
great explanation thank you
Thank u so much it helped me alot.
Really Thanks man😊
Informative session,Brohh
Very very good explanation
Great tutorial! Which macOS are you using?
hi sir, this is a nice video.
thanks for a good tutorial, and i pretend that i didn't see the movies you have downloaded at 5.06 🙈
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 very much !
5:05 When you see his pirated movies xd
hahaha...
lol
noice
Thank you so much sir...
Thanks a lot.
OP sir ho gya aapki kripa se
Thank you so much sir ❤️
Awesome sir
thank you sir..
thank you my life saver
Thank you Sir . 👾
Thank You Sir, Steve Jobs, Steve Wozniak, Ronald Wayne are the founders of Apple company.
Thanks for video
very good video sir
ur amazing zing zing sir....
Navin legendo...
Great sir love u
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.
thank you so much
Thanks!
Thank you !!!
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
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
Thank you sir 👏🙏
Thanks alot
Thank you sir
I also like this info
Steve Jobs is the founder of Apple .
Thank You very much sir
Thank you..
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?
Excellent exaplanation!!! May Jesus bless you.
ricebag
Would you please shot a video on how to install and set up mysql database on mac and then connect to java.
Thanks for this video. Something is changed now.
In the url variable, after the database name, i had to add this code "?autoReconnect=true&useSSL=false".
For example, in my case is:
String url = "jdbc:mysql://localhost:3306/serra_databaseprova?autoReconnect=true&useSSL=false";
I you don't do this, ssl error will occur.
After this, in the Class.ForName i had to modify a little:
Class.forName("com.mysql.cj.jdbc.Driver").
I my case, for study database purpose, I don't need ssl security enable, so "?autoReconnect=true&useSSL=false" will disable SSL and also suppress the SSL errors (thanks to stackoverflow).
Thanks Telusko for the video
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
bro still am getting this error, pls help me to get out asap
Well you don't have to use SSL and yes telusko is using the old driver which is deprecated. Old Driver "com.mysql.jdbc.Driver" New Driver "com.mysql.cj.jdbc.Driver"
I'm getting the same error. Please help me out.
@@DeathBender when I use "com.mysql.cj.jdbc.Driver" I'm getting class not found exception.
@@thahseenfarook4945 ur error got resolved or not.... Bcoz im getting the same error