@Test
 public void testGetReturnsResultSet() {
   statementHandler.prepareReturnsResultSet("select.*", false);
   assertNull(statementHandler.getReturnsResultSet("select abc"));
   statementHandler.setUseRegularExpressions(true);
   assertEquals(Boolean.FALSE, statementHandler.getReturnsResultSet("select abc"));
 }
 @Test
 public void testClearMethods() {
   statementHandler.prepareResultSet("select", new MockResultSet("id"));
   statementHandler.prepareUpdateCount("select", 3);
   statementHandler.prepareThrowsSQLException("select");
   statementHandler.prepareReturnsResultSet("select", true);
   statementHandler.prepareGeneratedKeys("select", new MockResultSet("id"));
   statementHandler.clearResultSets();
   statementHandler.clearUpdateCounts();
   statementHandler.clearThrowsSQLException();
   statementHandler.clearReturnsResultSet();
   statementHandler.clearGeneratedKeys();
   assertNull(statementHandler.getResultSet("select"));
   assertNull(statementHandler.getUpdateCount("select"));
   assertFalse(statementHandler.getThrowsSQLException("select"));
   assertNull(statementHandler.getReturnsResultSet("select"));
   assertNull(statementHandler.getGeneratedKeys("select"));
 }
 @Test
 public void testPreparedSQLOrdered() {
   MockResultSet result1 = new MockResultSet("id1");
   MockResultSet result2 = new MockResultSet("id2");
   statementHandler.prepareResultSet("select", result1);
   statementHandler.prepareResultSet("SelecT", result2);
   statementHandler.prepareUpdateCount("SelecT", 3);
   statementHandler.prepareUpdateCount("select2", 2);
   statementHandler.prepareReturnsResultSet("select", false);
   statementHandler.prepareReturnsResultSet("selecT", true);
   statementHandler.prepareGeneratedKeys("seLECT", result1);
   statementHandler.prepareGeneratedKeys("select", result2);
   assertSame(result2, statementHandler.getResultSet("select"));
   assertSame(result2, statementHandler.getResultSets("select")[0]);
   assertEquals(new Integer(3), statementHandler.getUpdateCount("SELECT"));
   assertEquals(new Integer(3), statementHandler.getUpdateCounts("selecT")[0]);
   assertTrue(statementHandler.getReturnsResultSet("select").booleanValue());
   assertSame(result1, statementHandler.getGeneratedKeys("select"));
 }