ResultSet.getRow() will give you the row number where the resultset cursor

i have 1000 records in resultset, how to get first 100
records from resultset, because resultset fetch all 1000
records at a time?

Question Posted / sri

Answer Posted / sri

ResultSet.getRow() will give you the row number where the
resultset cursor is in , check for ResultSet.getRow()==100
and then break out of the loop

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Is jdbc object oriented?

998

What is odbc and jdbc?

1086

Explain how to make updates to the updatable resultsets.

977

What is a jdbctemplate?

983

What is a jdbc connection string?

997

What are the classes and methods used for sending sql statements to database?

1144

What is an advantage of using the jdbc connection pool?

936

How can we retrieve the file in the oracle database?

1017

Does JDBC support stored procedures?

1065

What do you understand by jdbc driver and explain its types?

999

Which package contains jdbc api?

1095

What is sqlwarning and discuss the procedure of retrieving warnings?

1088

How you restrict a user to cut and paste from the html page using java programing?

946

What is a datasource in java?

1012

How to connect multiple database in jdbc?

1161