16.3 Java Database Connectivity Practical Part 2

Подписаться 2,4 млн

Просмотров 249 тыс.

50% 1

Fetch Multiple records from database | mysql
Once you successfully logged into database, instantiates a 'Statement' object that carries your SQL language query to the database then instantiates a 'ResultSet' object that retrieves the results of your query, and executes a simple while loop, which retrieves and displays those results.
Check out our website: www.telusko.com
Follow Telusko on Twitter: / navinreddy20
Follow on Facebook:
Telusko : / teluskolearnings
Navin Reddy : / navintelusko
Follow Navin Reddy on Instagram: / navinreddy20
Subscribe to our other channel:
Navin Reddy : / @navinreddy
Telusko Hindi :
/ @teluskohindi
Subscribe to the channel and learn Programming in easy way.
Java Tutorial for Beginners: goo.gl/p10QfB
C Tutorial Playlist : goo.gl/8v92pu
Android Tutorial for Beginners Playlist : goo.gl/MzlIUJ
XML Tutorial : goo.gl/Eo79do
Design Patterns in Java : goo.gl/Kd2MWE
Socket Programming in Java : goo.gl/jlMEbg
Spring MVC Tutorial : goo.gl/9ubbG2
OpenShift Tutorial for Beginners : goo.gl/s58BQH
Spring Framework with Maven : goo.gl/MaEluO
Sql Tutorial for Beginners : goo.gl/x3PrTg
String Handling in Java : goo.gl/zUdPwa
Array in Java : goo.gl/uXTaUy
Java Servlet : goo.gl/R5nHp8
Exception Handling in Java : goo.gl/N4NbAW

Опубликовано:

15 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 60

@hardikrana2185 8 лет назад

Apple Founder Steve Jobs & Steve Wozniak

@kovacsi.5812 Год назад

Its a blessing that i found your youtube channel.

@vladanulardzic5859 5 лет назад

Well done ! Keep on ...

@kartikgarg3592 Год назад

tjhanks 4 this wonderful video

@amanuellebassi7294 3 года назад

You are awesome my friend!

@justinbanza4751 3 года назад

Thank you very much for this video

@pokerasmitar551 7 лет назад

Great tutorials! thanks!

@amrounmohand9814 7 лет назад

Pokeras Mitar

@akshaysontakke3055 2 года назад

Sir i have been doing as you said but eclipse showing errors ....?? 😧

@bubainath246 Год назад

Thanks a lot ❤

@latoquyen5071 7 лет назад

Thank you so much

@lakshmism3544 8 лет назад

how to Fetch this data in to jspbecause I wanted to see all the data in one wed page can you explaine

@prajwal3043 Год назад

Co-founders of apple is Steve jobs and Steve Wozniak

@vadlakuntanaveen1377 2 года назад

love you sir

@sonalibiswal5472 4 года назад

Founder of Oracle-Larry Ellison Founder of Apple - Steve Jobs

@sandeshmore6510 8 лет назад

sir in this video we r storing int value into the string type of variable ...how the code getting output without any error ???

@anujchaturvedi6296 3 года назад

userData=resultset.getInt(1)+" "+resultset.getString(2) After the getInt() method , we have used +" " which "cast" int into String.

@teluskosupport Год назад

Double quotes will explicitly cast the value into the string.

@cu9366 6 лет назад

thankyou sir

@abdulwahid_mohammed 6 лет назад

I tried to connect to the data base and I got the following error Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. how to solve it?

@NavdeepBillowria 6 лет назад

In your URL you have to set like this : String url ="jdbc:mysql://localhost:3306/sakila?useSSL=false"; .... here sakila is databasename

@abdulwahid_mohammed 6 лет назад

Navdeep Singh thanks this solve the warning

@muhammadroshan7315 5 лет назад

use String url = "jdbc:mysql://localhost:3306/studentdb?useSSL=false"; here studentdb is the name of database which I created. You can have any name that you want to

@abhishekshah2964 6 лет назад

rani and navin , kya baat hai . rab ne bana di jodi .

@martin5658 6 лет назад

Hello sir I was having query In jdbc bank program how to transfer money from one account to another because when we use update it only updates table how can I transfer from one table to another values..

@DeathBender 5 лет назад

you just store the value instead of only printing it to the console and use that value in another statement to insert it into another table

@juileekudale9790 2 года назад

Sooo good

@Dontfkwithme69 8 лет назад

you said u the rs.next() is used to shift the pointer to the next row so u used it three times before using the while loops, but u dint use rs.next() inside the body of while loop yet the code is working. may i know why?

@pokerasmitar551 7 лет назад

Because statement "while(rs.next())" means that while there is next row in your database table it will do the code in the curly brackets.

@teluskosupport Год назад

rs.next() will shift the pointer to the next line and rs.next() in while loop will iterate through all rows till new line does not meet and execute the code present inside the while loop each time.

@AadityaKavthekar 4 года назад

Hi Navin Sir, Thank you so much for the video. It is really helpful :) I have one doubt: Inside of while loop, we have given 1 and 2 constants as we know there are only two columns. Can we make it generic instead of giving constants?

@leonkingsley4467 3 года назад

i know im randomly asking but does anybody know a tool to get back into an Instagram account..? I was stupid lost the login password. I appreciate any help you can offer me.

@enriqueuriel3452 3 года назад

@Leon Kingsley Instablaster =)

@leonkingsley4467 3 года назад

@Enrique Uriel I really appreciate your reply. I got to the site through google and Im waiting for the hacking stuff now. Takes quite some time so I will get back to you later with my results.

@leonkingsley4467 3 года назад

@Enrique Uriel It worked and I finally got access to my account again. Im so happy! Thanks so much, you saved my account !

@enriqueuriel3452 3 года назад

@Leon Kingsley Happy to help xD

@Mr.Indian662 4 года назад

Unable to load authentication plugin 'caching_sha2_password'. how to resolve this problem

@gouthamgoud5255 6 лет назад

Hi sir, can u please share the information on how to connect java with mango db

@ColoursOfMySoul 5 лет назад

Can u make a video on callable statement?

@rushikeshbandiwadekar3730 3 года назад

Can we connect with postgres SQL

@subramanigr8741 5 лет назад

apple founder is SteveJobs

@akashshrestha01 5 лет назад

cool

@twilightsaga8309 3 года назад

sir please continue in netbeans

@ramyacd559 6 лет назад

How to open connectivity with selenium server?

@deepakkumarsahu2797 4 года назад

I have also used mysql connector jar file but still eclipse fetching errors why sir??

@teluskosupport Год назад

Use the latest version of the jar and also set the variable classpath for it.

@Sinam-Tedhe-Medhe 7 лет назад

founder of Apple is Steve

@prateekshapkumtakar5390 3 года назад

Changes made in eclipse is not reflecting in mysql database!! What do I do

@teluskosupport Год назад

It might be possible that your eclipse is not connecting with the database properly. Check the connectivity once and also add the sql jar properly by adding classpath.