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

What is the difference between ojdbc6 and ojdbc7?

885

What is jdbc connection?

1087

Does jdbctemplate use prepared statements?

910

How to update a resultset programmatically?

1081

Explain the JDBC Architecture?

1019

Why should we close database connections in java?

1145

Does jdbc use ssl?

932

If I use the JDBC API, do I have to use ODBC underneath?

1038

List some new features available in jdbc 4.0?

908

What class.forname will do while loading drivers of jdbc?

941

What is jdbc and explain jdbc architecture?

1017

Why do we need jdbc api?

975

How to set NULL values in JDBC PreparedStatement?

979

What does adapter class provide?

944

What is the use of jdbc api?

976