protected int executeUpdate(DbSession session, String s) { return new DbQuery(DbOom.get(), session, s).autoClose().executeUpdate(); }
public Q setInteger(final int index, final Number value) { if (value == null) { setNull(index, Types.INTEGER); } else { setInteger(index, value.intValue()); } return _this(); }
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(); query = DbQuery.query(session, "select count(*) from GIRL where id=:girlId"); query.setInteger("girlId", 1); assertEquals(1, query.executeCount()); query.close(); query = DbQuery.query(session, "select count(*) from GIRL where id=:girlId"); query.setLong("girlId", 1); assertEquals(1, query.executeCount()); query.close(); query = DbQuery.query(session, "select count(*) from GIRL where id=:girlId"); query.setShort("girlId", (short) 1); assertEquals(1, query.executeCount()); query.close(); query = DbQuery.query(session, "select count(*) from GIRL where id=:girlId"); query.setInteger("girlId", Integer.valueOf(1)); assertEquals(1, query.executeCount()); query.close();
/** * @see #setObject(String, Object, Class, int) */ public Q setObject(final String param, final Object value, final Class<? extends SqlType> sqlTypeClass, final int dbSqlType) { init(); final int[] positions = query.getNamedParameterIndices(param); for (final int position : positions) { setObject(position, value, sqlTypeClass, dbSqlType); } return _this(); }
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(); query = DbQuery.query(session, sql); query.setDebugMode(); query.setInteger("id", 2); ResultSet rs = query.execute(); assertEquals(1, query.getOpenResultSetCount()); assertEquals("select * from GIRL where ID = 2", query.getQueryString()); while (rs.next()) { assertEquals(2, rs.getInt(1)); assertFalse(query.isClosed()); session.closeSession(); assertTrue(query.isClosed()); assertEquals(0, query.getOpenResultSetCount()); DbQuery q = DbQuery.query("select count(*) from GIRL"); assertEquals(3, q.executeCount()); dbts.closeSession();
public void setBytes(int index, byte[] value) { init(); try { preparedStatement.setBytes(index, value); } catch (SQLException sex) { throwSetParamError(index, sex); } }
/** * Sets batch parameters with given array of values. */ public Q setBatch(final String name, final long[] array, int startingIndex) { init(); final int batchSize = query.getBatchParameterSize(name); for (int i = 1; i <= batchSize; i++) { final String paramName = name + '.' + i; if (startingIndex < array.length) { setLong(paramName, array[startingIndex]); } else { setNull(paramName, Types.INTEGER); } startingIndex++; } return _this(); }
/** * Sets batch parameters with given array of values. */ public Q setBatch(final String name, final int[] array, int startingIndex) { init(); final int batchSize = query.getBatchParameterSize(name); for (int i = 1; i <= batchSize; i++) { final String paramName = name + '.' + i; if (startingIndex < array.length) { setInteger(paramName, array[startingIndex]); } else { setNull(paramName, Types.INTEGER); } startingIndex++; } return _this(); } /**
if (dbOom.config().isKeysGeneratedByDatabase()) { 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(); q.close();
init(); if (value == null) { setNull(index, Types.NULL); return _this(); throwSetParamError(index, sex); return _this();
protected long executeCount(DbSession session, String s) { return new DbQuery(DbOom.get(), session, s).autoClose().executeCount(); }
public Q setBoolean(final String param, final Boolean value) { if (value == null) { setNull(param, Types.BOOLEAN); } else { setBoolean(param, value.booleanValue()); } return _this(); }
protected int executeUpdate(DbSession session, String sql) { return DbQuery.query(session, sql).autoClose().executeUpdate(); }