Interested to Buy Any Domain ? << Click Here >> for more details...
i have 1000 records in resultset, how to get first 100
records from resultset, because resultset fetch all 1000
records at a time?
- 8 Answers
- 21329 Views
- HSBC, I also Faced
- E-Mail Answers
Answer Posted / sumit
The question is not pretty clear. However, before retriving the records from the database if you want to make sure you get only 100 records in one hit. U can use the following API after creating the statement object.
Statement.setFetchSize(100);
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is JDBC Statement?
What is a jdbc url?
What is phantom read and which isolation level prevents it?
Once I have the Java 2 SDK, Standard Edition, from Sun, what else do I need to connect to a database?
Why do we need jdbc?
What is the meaning of batch updates?
What is the role of class.forname while loading drivers?
What is type 4 jdbc driver?
What are the different types of locking in JDBC?
Which type of JDBC driver is the fastest one?
How can you use preparedstatement in jdbc?
How many packages are available in jdbc api?
Is jdbc a middleware?
Is odbc an api?
Are all the required JDBC drivers to establish connectivity to my database part of the JDK?
