コード例 #1
0
 @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"));
 }
コード例 #2
0
 @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"));
 }
コード例 #3
0
 @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"));
 }