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 ?
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.
Joined: Oct 13, 2005
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.