@Test
 public void testGetUpdateCount() {
   statementHandler.prepareUpdateCount(".*", 3);
   statementHandler.prepareUpdateCount("insert xyz", 4);
   assertEquals(new Integer(4), statementHandler.getUpdateCount("insert xyz"));
   assertEquals(new Integer(3), statementHandler.getUpdateCount(".*"));
   statementHandler.setUseRegularExpressions(true);
   assertEquals(new Integer(3), statementHandler.getUpdateCount("insert xyz"));
   assertEquals(new Integer(3), statementHandler.getUpdateCount("insert"));
   statementHandler.setExactMatch(true);
   assertEquals(new Integer(4), statementHandler.getUpdateCount("insert Xyz"));
   assertNull(statementHandler.getUpdateCount("insert"));
   statementHandler.prepareUpdateCounts("update", new int[] {1, 2});
   assertEquals(new Integer(1), statementHandler.getUpdateCount("update"));
 }
 @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"));
 }