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