Archive for July 19th, 2007|Daily archive page

java: testing empty resultset

I really don’t understand why the java.sql.ResultSet don’t provide an isEmpty() method or something similar and it’s true that I rarely need this method, however, sometimes this happen. Here is how I test for empty resultset in java.

ResultSet rs = ...
boolean  emptyRs = true;

while(rs.next()){
   emptyRs = false;
   ...
}

if(emptyRs){
   ...
}

or better (i prefer this one)

ResultSet rs = ...

if(rs.next()){
   do{
      ...
   }while(rs.next());
}else{
   //is empty
}