@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"));
}
