What is ResultSet in jdbc ? How to fetch data ? | HINDI | JDBC #13

In this video, I will explain what is ResultSet in JDBC? How we can fetch data?
What is ResultSet? How to fetch data? | HINDI | JDBC #13
/STEP 1. Import required packages
import java.sql.*;
public class Main{
// JDBC driver name and database URL
static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
static final String DB_URL = "jdbc:mysql://localhost/STUDENTS";
// Database credentials
static final String USER = "username";
static final String PASS = "password";
public static void main(String[] args) {
Connection conn = null;
Statement stmt = null;
try{
//STEP 2: Register JDBC driver
Class.forName("com.mysql.jdbc.Driver");
//STEP 3: Open a connection
System.out.println("Connecting to a selected database...");
conn = DriverManager.getConnection(DB_URL, USER, PASS);
System.out.println("Connected database successfully...");
//STEP 4: Execute a query
System.out.println("Creating statement...");
stmt = conn.createStatement();
String sql = "SELECT id, first, last, age FROM Registration";
ResultSet rs = stmt.executeQuery(sql);
//STEP 5: Extract data from result set
while(rs.next()){
//Retrieve by column name
int id = rs.getInt("id");
int age = rs.getInt("age");
String first = rs.getString("first");
String last = rs.getString("last");
//Display values
System.out.print("ID: " + id);
System.out.print(", Age: " + age);
System.out.print(", First: " + first);
System.out.println(", Last: " + last);
}
rs.close();
}catch(SQLException se){
//Handle errors for JDBC
se.printStackTrace();
}catch(Exception e){
//Handle errors for Class.forName
e.printStackTrace();
}finally{
//finally block used to close resources
try{
if(stmt!=null)
conn.close();
}catch(SQLException se){
}// do nothing
try{
if(conn!=null)
conn.close();
}catch(SQLException se){
se.printStackTrace();
}//end finally try
}//end try
System.out.println("Goodbye!");
}//end main
}//end Class

[@user-sz8bi1fc3r]

Very clear and concise series for jdbc ! Thanks

[@amritapatjoshi3199]

By far one of the best channel ever that provides clear understanding in simple language. Sir Thank you so much.
Your teaching style is very beautiful.
Keep doing such amazing work.

[@akashjariwala5354]

Sir needed to laern JDBC and i found your channel amazing so i started your course. Sir, is this course complete? If not then please tell us the topics which are left so i can cover them on my own. I am on a deadline.
Thank you sir for amazing explanation

[@anjaligaikwad692]

Just Finished this series..Thankyou Sir!!!

[@BEYOU2111]

Thank you sir for this series . 🙏 Sir please can you continue this series 🙏🙏🙏

[@user-kw1id7jo2c]

Thanks for the series..,its realy help me

[@08_ankush72]

Thank you sir for your tutorial ... Now iam ready for learn more on java frameworks

[@priyankabiradar3299]

so knowledgeable series durgesh big fan .

[@luvrathore7884]

Thanks for the tutorial , Brother !!

[@vishwasverma9990]

Thank you bhai for this tutorial i gained much more knowledge ❤️❤️

[@viveksrivastava5478]

Excellent Series

[@manishsalve5322]

Thank you so much Durgesh Sir for providing such quality content. I really enjoyed and learned a lot from this entire playlist. TYSM

[@nehagusain2582]

Really helpful

[@prasantdwivedi9325]

Waooo sir amazing tutorials

[@NoName-py4dj]

bohot sahi bhai

[@VikramKumar-dq2is]

Please continue this playlist

[@ce105vaibhavrathod2]

Thank you sirrrrr

[@ashishkumarsingh6618]

Two words: Thank you

[@mohammedajazquadri7869]

Acha padhate ap

[@butterfly-er6zs]

Thank you

[@sonytv_livesharktank]

Thanku

[@nawazkamboo8750]

Sir please make video on Row Set

[@ritikchoudhary9601]

nice 😊

[@vigneshpaygude3045]

Please ek bar metadata and callablestatement pn video bano

[@DigvijaySingh-zd9hq]

Great playlist. Is there a video on how to do the mapping between ImageName in DB and the image stored in a file? And then finally display on webpage?

[@ashwindev1090]

Sir please saare types ke statements ko acche se sikhayiye alag se video banake aur aage rowset bhi

[@amanprakash7415]

please complete this tutorial as soon as possible

[@abhijitpawar2480]

series is amazing but incomplete

[@soumyadeepmallick6282]

Sir why you stopped making videos on jdbc ?? Please continue.

[@MahtabAlam-eu2hb]

Hello Sir. I am from Mumbai can you just tell me this one is complete advance java tutorial...

[@shivampali9033]

Hello Bhai
Bhot sahi video series👏👏...!
Next video kab dalonge RollSet ka?

[@prasantdwivedi9325]

Next video upload kro sahbbbb

[@saurabhdighe7409]

Rollset nhi RowSet

[@codewithbrijesh6172]

please complete this playlist.

[@massiahplays2261]

sir what is resultset metadata

[@gamerg9271]

sir please row set ka video laye

[@ajinkyakamble173]

Itni he series hai kya ??.... Whan will be the nxt video come??

[@Everydayshorts913]

playlist toh puri kardete yrr

[@massiahplays2261]

bhai jdbc me import mcq question do meri exam hai 1 din baad

[@abhishekbarman8610]

sir next video kab ayegi?

[@anmolbansal4184]

bhai next video kb aayegi iss series mein?

[@sufiyansalman2780]

Sir please complete the remainning jdbc

[@BitFire007]

sir yahi bs last video hai jdbc ki ya fir iss hi series ki kahi or bhi upload hai

[@KishlayRajSanu]

bhai etne hi videos h is series me?

[@ritikbhardwaj4061]

whats after JDBC????

[@jabroomunda]

Where is the rowset video you promised towards the end of this video. could not find it in the comments.

[@dhirajsardar1430]

yes bro , I also tried to find out but couldn't find out.

[@RajNa27_11]

I have one question. Can we do Interface object. I read we are create only class object not interface.

[@lodhiyavishnu4714]

We cannot create object for interface in java.

[@AshutabSingh]

You can create object of the implementing class of the interface

[@dhirajsardar1430]

you read right . we can create the objec of the classes only , this is because the interfaces follow abstraction and abstraction doesn't allow to create object.

[@komaldumbre583]

Next Video sir?

[@saurabhdighe7409]

RowSet ka set ka vdo or Link

[@shankar7435]

Where is RowSet video link?
Rest of the videos are hoid but this video has nothing but use RowSet instead of ResultSet. Dont lower your level by such hallow videos sor. Rest are good.

[@rushikeshpotdar118]

after ResultSet you not create a video on rowset

[@manjitonline]

ab pura video spring me ja kar dekho

[@devidaspophalnare]

Brother isake age ke videos kaha milenge

[@riteshdangi7460]

sal bhr ho gyea next video kbb aae gi

[@mohdaltamash2571]

Bhai bs ab sms ka koi solution bta do. 😅

[@LearnCodeWithDurgesh]

hn bhai banayenge uski bhi video..

[@mohdaltamash2571]

@@LearnCodeWithDurgesh as soon as possible
I'm waiting for it.

[@tusharmusician]

@@LearnCodeWithDurgesh jdbc ko complete krdo please 🙏🏻

[@abhishektambewagh6156]

how to fetch particular data ??

[@yogeshkuthe8920]

Is this palylist incomplete??

[@shantohossain1372]

yes but the core concept is cover

[@santoshlives331]

bhai sab to theek hai leikn coding karte wqt etna jald baji kyu karte hai wahi samjne wala part hota usi ko app uda dete hai...
ek bhi method sahi se describes nahi karte aur etna object bana lete hai ki use me sab confuse ho jata hai.
is problem ko overcome kare less coding maximum output.

[@LearnCodeWithDurgesh]

Object nhi banaoge to coding kaise hogi bro...Code ko samjho samjh ayega