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 jdbctemplate thread safe?

909

What are the 4 types of jdbc drivers?

1019

How to test jdbc connection to sql server?

1030

How MS-Access DB can be accessed over a network, using JDBC API?

2436

Explain the difference between rowset vs. Resultset in jdbc?

1008

What is ojvm used for?

992

What is the role of class.forname while loading drivers?

1011

Why resultset is used in java?

941

What are the differences between resultset and rowset?

1137

How can I determine where a given table is referenced via foreign keys?

1005

What does executequery return in java?

931

Is jpa faster than jdbc?

887

password, is stored in as plain text. What can I do to protect my passwords?

975

Why “no suitable driver” error occurs?

1094

Give an example of code used for setting up connection with a driver.

969