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
- 21604 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
explain about special characters?
How does jdbc work?
What is the role of the jdbc drivermanager class?
What does connection pooling mean ?
Prepared statements are faster. Why?
What is jdbc driver?
Which type of JDBC driver is the fastest one?
Explain the process of creating tables using NetBeans IDE?
What is jdbc connection class?
Can resultset be null in java?
What is namedparameterjdbctemplate?
What is the role of jdbc drivermanager class?
What is the major difference between java.util.date and java.sql.date data type?
DB2 Universal claims to support JDBC 2.0, But I can only get JDBC 1.0 functionality. What can I do?
What is jdbc connection string?
