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

Differentiate between a statement and a preparedstatement.

931

What are the exceptions in jdbc?

902

Is jdbc a framework?

843

How can I create a custom RowSetMetaData object from scratch?

934

What are the different types of lockings in jdbc?

853

What is metadata in programming?

941

Differentiate between type_scroll_insensitive and type_scroll_sensitive.

883

What are four types of JDBC driver?

1051

What happens if we don't close the connection in jdbc?

825

What is jdbc resultsetmetadata interface?

912

How to check jdbc driver version in websphere?

1014

What are the functions of the jdbc connection interface?

921

What is an advantage of using the jdbc connection pool?

822

Explain the role of driver in jdbc.

939

What is a statement in java?

852