/** * Simply inserts object into the database. */ public void save(final Object entity) { final DbQuery q = query(dbOom.entities().insert(entity)); q.autoClose().executeUpdate(); }
protected void executeUpdate(String sql) { DbQuery.query(sql).autoClose().executeUpdate(); }
protected int executeUpdate(DbSession session, String sql) { return DbQuery.query(session, sql).autoClose().executeUpdate(); }
protected void executeUpdate(String sql) { new DbQuery(DbOom.get(), sql).autoClose().executeUpdate(); }
protected int executeUpdate(DbSession session, String s) { return new DbQuery(DbOom.get(), session, s).autoClose().executeUpdate(); }
@Test void testEnums() { DbSession session = new DbThreadSession(cp); String sql = "create table ENUMERATOR(ID int, NAME varchar(20), STATUS int)"; DbQuery query = new DbQuery(DbOom.get(), sql); query.executeUpdate(); Enumerator e = new Enumerator(); e.id = 2; e.name = "Ikigami"; e.status = Enumerator.STATUS.ONE; query = DbOomQuery.query(dbOom.entities().insert(e)); query.executeUpdate(); session.closeSession(); }
@Override @BeforeEach protected void setUp() throws Exception { super.setUp(); DbEntityManager dbEntityManager = DbOom.get().entityManager(); dbEntityManager.registerEntity(User.class); dbEntityManager.registerEntity(Wizard.class); session = new DbThreadSession(cp); executeUpdate("drop table WIZARD if exists"); executeUpdate("drop table USER if exists"); DbQuery query = DbQuery.query( "create table USER (" + "USER_ID IDENTITY," + "NAME varchar(20) not null" + ')'); query.executeUpdate(); query = DbQuery.query("insert into USER values(1, 'Gandalf')"); query.executeUpdate(); query = DbQuery.query( "create table WIZARD (" + "WIZARD_ID IDENTITY," + "LEVEL INT not null" + ')'); query.executeUpdate(); query = DbQuery.query("insert into WIZARD values(1, 7);"); query.executeUpdate(); }
q = query(dbOom.entities().insert(entity)); q.setGeneratedKey(); q.executeUpdate(); final Object nextId = q.getGeneratedKey(); setEntityId(ded, entity, nextId); setEntityId(ded, entity, nextId); q = query(dbOom.entities().insert(entity)); q.executeUpdate();
/** * 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(); }
assertEquals(1, query.executeUpdate()); query.close();
query.autoClose().executeUpdate(); assertTrue(query.isClosed());
/** * Simply inserts object into the database. */ public void save(final Object entity) { final DbQuery q = query(dbOom.entities().insert(entity)); q.autoClose().executeUpdate(); }
q = query(dbOom.entities().insert(entity)); q.setGeneratedKey(); q.executeUpdate(); final Object nextId = q.getGeneratedKey(); setEntityId(ded, entity, nextId); setEntityId(ded, entity, nextId); q = query(dbOom.entities().insert(entity)); q.executeUpdate();