Iterating resultset

[Prasath Premkumar]

Hi all,

I have a confusion about iterating resultset.

    while(resultset.next()){
   //do getting data..
   }

If the above code segment checks for empty resultsets too, then whats the advantage of using,

 if(resultset.first()){
 while(resultset.next()){
   //do getting data..
   }
 }

Can anyone please explain this and what is the best way to do the iterating part?

Thanks in advance.

[Christophe Verré]

Calling first() allow you to move the cursor back to the ResultSet. This could be useful if you are using the same ResultSet somewhere else, and you want to reiterate from the start. If you don't, then you don't need to use first().