How to check if resultset has only one row or more?

[Vidya Moorthy]

I have to do a query to a table. If resultset has only one row, I have to set the bean in one particular way and if the resultset has multiple rows in a different way.
I tried

//If it has multiple rows set ABC in the bean
if (rs.next) {
 bean.setABC("ABC");
}
//It it has one row set ABC2 in the bean
else if(rs.first) {
 bean.setABC("ABC2");
}
//If none of these set Something else in the bean
else{
 bean.setABC("Something Else);
}

The problem with this code is even if the row count from the query is one, it sets ABC into the bean.
Should I try to get the count and then check if count > 1? If that is the case, then I have to do two queries, one to get the count and the other to do the query itself. Please advise.
Thanks in advance
Vidyaram

[Paul Clapham]

Just read the records to find out how many there are:

if (rs.next()) {
  // There are some records
  if (rs.next()) {
    // There is more than one record
  } else {
    // There is exactly one record
  }
} else {
  // There are no records
}

But if it were me I would be considering writing a query involving "count(*)" rather than potentially returning a large number of rows just to ignore them.

[Seetharaman Venkatasamy]

Paul Clapham wrote:But if it were me I would be considering writing a query involving "count(*)" rather than potentially returning a large number of rows just to ignore them.

Indeed; this is the best way

[Vidya Moorthy]

Thank you for posting the answers quickly!

Vidyaram