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
}
Comments (1)