protected void assertResult(String expected,Statement stat,String sql) throws SQLException {
  ResultSet rs=stat.executeQuery(sql);
  if (rs.next()) {
    String actual=rs.getString(1);
    assertEquals(expected,actual);
  }
 else {
    assertEquals(expected,null);
  }
}

protected void assertResult ( String expected , Statement stat , String sql ) throws SQLException { ResultSet rs = stat . executeQuery ( sql ) ; if ( rs . next ( ) ) { String actual = rs . getString ( 1 ) ; assertEquals ( expected , actual ) ; } else { assertEquals ( expected , null ) ; } }
check that the result set of a query is exactly this value .
