Test for an empty ResultSet

  boolean found;
  ResultSet rs;
  ...      
  // execute the query and then
  found = rs.next();
  if (found)
      System.out.println("Record found");
  else
      System.out.println("RECORD NOT FOUND");

A nicer way to do the same would be

  
  ResultSet rs;
  ...  
  if (rs.next()) {
     do {
        System.out.println("Record found");
       } while (rs.next());
     }
  else {
     System.out.println("Record not found");
}