protected long executeCount(DbSession session, String sql) { return DbQuery.query(session, sql).autoClose().executeCount(); }
protected long executeCount(DbSession session, String s) { return new DbQuery(DbOom.get(), session, s).autoClose().executeCount(); }
assertEquals(0, query.executeCount()); assertEquals(1, executeUpdate(session, "insert into GIRL values(1, 'Anna', 'swim')")); assertEquals(1, query.executeCount()); assertEquals(1, executeUpdate(session, "insert into GIRL values(2, 'Sandra', 'piano')")); assertEquals(2, query.executeCount()); assertEquals(1, executeUpdate(session, "insert into GIRL values(3, 'Monica', 'hacking')")); assertEquals(3, query.executeCount()); assertEquals(0, query.getOpenResultSetCount()); query.close(); assertEquals(1, query.executeCount()); query.close(); assertEquals(1, query.executeCount()); query.close(); assertEquals(1, query.executeCount()); query.close(); assertEquals(1, query.executeCount()); query.close(); assertEquals(1, query.executeCount()); query.close(); assertEquals(1, query.executeCount()); query.close(); assertEquals(1, query.executeCount());
assertEquals(0, query.executeCount()); assertEquals(1, executeUpdate(session, "insert into GIRL values(1, 'Anna', 'swim')")); assertEquals(1, query.executeCount()); assertEquals(1, executeUpdate(session, "insert into GIRL values(2, 'Sandra', 'piano')")); assertEquals(2, query.executeCount()); assertEquals(1, executeUpdate(session, "insert into GIRL values(3, 'Monica', 'hacking')")); assertEquals(3, query.executeCount()); assertEquals(0, query.getOpenResultSetCount()); assertEquals(3, q.executeCount()); dbts.closeSession();
assertEquals(2, dq.executeCount()); assertEquals(0, dq.autoClose().executeCount());
/** * Tests if rollback works. */ @Test void testRollback() { // prepare manager JtxTransactionManager manager = new JtxTransactionManager(); manager.registerResourceManager(new DbJtxResourceManager(cp)); // request transaction JtxTransaction tx = manager.requestTransaction(new JtxTransactionMode(JtxPropagationBehavior.PROPAGATION_REQUIRED, false)); DbSession session = tx.requestResource(DbSession.class); assertNotNull(session); // insert two records DbQuery query = DbQuery.query(session, "insert into GIRL values(4, 'Jeniffer', 'fighting')"); assertEquals(1, query.executeUpdate()); query = DbQuery.query(session, "insert into GIRL values(5, 'Annita', 'bartender')"); assertEquals(1, query.executeUpdate()); // rollback tx.rollback(); // check !!! session = new DbSession(cp); DbQuery query2 = DbQuery.query(session, "select count(*) from GIRL"); long count = query2.executeCount(); assertEquals(0, count); session.closeSession(); }
long value = dbQuery.executeCount(); assertEquals(173, value);
long value = dbQuery.executeCount(); assertEquals(173, value); assertSame(dbSession, dbQuery.getSession());