Iterating through resultset

[Arka Sharma]

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]

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]

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]

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.