private static void assertSingleValueQuery(Statement testStmt,String query,Object result) throws Exception {
  ResultSet testRs=testStmt.executeQuery(query);
  assertTrue(testRs.next());
  assertEquals(result,testRs.getObject(1));
  assertFalse(testRs.next());
  testRs.close();
}

private static void assertSingleValueQuery ( Statement testStmt , String query , Object result ) throws Exception { ResultSet testRs = testStmt . executeQuery ( query ) ; assertTrue ( testRs . next ( ) ) ; assertEquals ( result , testRs . getObject ( 1 ) ) ; assertFalse ( testRs . next ( ) ) ; testRs . close ( ) ; }
asserts the execution and return for a simple single value query .
