aspose file tools*
The moose likes JDBC and the fly likes Iterating through resultset Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Iterating through resultset" Watch "Iterating through resultset" New topic
Author

Iterating through resultset

Arka Sharma
Ranch Hand

Joined: Jun 15, 2011
Posts: 103

Hi,

I have executed an SQL query on the primary key of the table.So either no record will be returned or only one record will be returned.So do I need to iterate through the resultset by Iterator interface ? Is there any better way to access the resultset having only one record ?

Thanks,
Arka
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 39408
    
  28
I thought you used while(rs,next()) ... and I thought you can't get an Iterator for a ResultSet.

But you should find the details in the Java Tutorials.
Arka Sharma
Ranch Hand

Joined: Jun 15, 2011
Posts: 103

Actually I'm using Hibernate.And I'm doing like

Iterator iterator = query.list();

And the HQL query is like " from Operator where OperatorId = :OperatorId" now this OperatorId is the primary key for Operator.So do I need to get the iterator and iterate through the list since only either one or no record will be returned by that query.

Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 39408
    
  28
You ought to have told the full details; it is very different to use Hibernate, which I don't know about.
I couldn't find a list() method in the API index matching yours. It does seem peculiar that a method called list() returns an Iterator, rather than a "list". If "list" means java.util.List, that is an Iterable and you can get an Iterator for that.
ResultSet doesn't seem to have an isEmpty() method, but you can try declaring a boolean isEmpty and you can set isEmpty to false inside the while (rs.next())... loop.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Iterating through resultset