@Test
 public void testGetGeneratedKeys() {
   MockResultSet result = new MockResultSet("id");
   statementHandler.prepareGeneratedKeys("insert into table", result);
   statementHandler.prepareGeneratedKeys("insert .*", result);
   assertSame(result, statementHandler.getGeneratedKeys("insert into table abc"));
   assertSame(result, statementHandler.getGeneratedKeys("insert .*"));
   assertNull(statementHandler.getGeneratedKeys("insert into othertable"));
   statementHandler.setUseRegularExpressions(true);
   assertSame(result, statementHandler.getGeneratedKeys("insert into table"));
   assertSame(result, statementHandler.getGeneratedKeys("INSERt regular"));
   statementHandler.setCaseSensitive(true);
   assertNull(statementHandler.getGeneratedKeys("INSERt regular"));
 }
 @Test
 public void testGetResultSet() {
   MockResultSet result = new MockResultSet("id");
   statementHandler.prepareResultSet("select column from table", result);
   statementHandler.prepareResultSet("select .*", result);
   assertSame(result, statementHandler.getResultSet("select column from table"));
   assertNull(statementHandler.getResultSet("select xyz from table"));
   statementHandler.setUseRegularExpressions(true);
   assertSame(result, statementHandler.getResultSet("select column from table"));
   assertSame(result, statementHandler.getResultSet("SELECT xyz from table"));
   statementHandler.setCaseSensitive(true);
   assertNull(statementHandler.getResultSet("SELECT xyz from table"));
   MockResultSet result0 = new MockResultSet("id0");
   MockResultSet result1 = new MockResultSet("id1");
   MockResultSet[] results = new MockResultSet[] {result0, result1};
   statementHandler.clearResultSets();
   statementHandler.prepareResultSets("select abc", results);
   assertSame(result0, statementHandler.getResultSet("select abc"));
 }
 @Test
 public void testGetThrowsSQLException() {
   SQLException exc = new BatchUpdateException();
   statementHandler.prepareThrowsSQLException("[abc] statement", exc);
   statementHandler.prepareThrowsSQLException("[abc] statementxyz");
   assertFalse(statementHandler.getThrowsSQLException("a stAtement"));
   assertNull(statementHandler.getSQLException("a stAtement"));
   statementHandler.setUseRegularExpressions(true);
   assertTrue(statementHandler.getThrowsSQLException("a stAtement"));
   assertSame(exc, statementHandler.getSQLException("a stAtement"));
   statementHandler.setCaseSensitive(true);
   assertFalse(statementHandler.getThrowsSQLException("a stAtement"));
   assertNull(statementHandler.getSQLException("a stAtement"));
   assertTrue(statementHandler.getThrowsSQLException("b statement"));
   assertSame(exc, statementHandler.getSQLException("b statement"));
   assertTrue(statementHandler.getThrowsSQLException("b statementxyz"));
   assertNotSame(exc, statementHandler.getSQLException("b statementxyz"));
   String message = statementHandler.getSQLException("b statementxyz").getMessage();
   assertTrue(message.indexOf("[abc] statementxyz") != -1);
 }