File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and the fly likes Result Set method that returns all rows Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Result Set method that returns all rows" Watch "Result Set method that returns all rows" New topic

Result Set method that returns all rows

Shein Zeya

Joined: Jun 04, 2008
Posts: 10
Hi all..

I would like to know one thing that is ; is there a method of Result Set that returns all rows.I searched in documentations but cannot find it. Please do help me .
Thanks a lot.

Regards: Shein

Jeanne Boyarsky
internet detective

Joined: May 26, 2003
Posts: 29245

No. You'd have to write a loop to get all the data out of a result set. A cached result set will return a result set disconnected from the database, but it is still a result set.

[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
I agree. Here's the link:
subject: Result Set method that returns all rows
Similar Threads
A Very little problem in h:dataTable implementation
null object in result sets
why is the List returning empty?
Determine Rows in a ResultSet?
Callable Statement Resultset