IncrementerUpdate(DataSource ds) { super(ds, "UPDATE UP_SEQ SET SEQ_VL=? WHERE SEQ_NM=? AND SEQ_VL=?"); super.declareParameter(new SqlParameter(Types.BIGINT)); super.declareParameter(new SqlParameter(Types.VARCHAR)); super.declareParameter(new SqlParameter(Types.BIGINT)); compile(); }
IncrementerUpdateForce(DataSource ds) { super(ds, "UPDATE UP_SEQ SET SEQ_VL=? WHERE SEQ_NM=?"); super.declareParameter(new SqlParameter(Types.BIGINT)); super.declareParameter(new SqlParameter(Types.VARCHAR)); compile(); }
IncrementerCreate(DataSource ds) { super(ds, "INSERT INTO UP_SEQ (SEQ_VL, SEQ_NM) VALUES(?, ?)"); super.declareParameter(new SqlParameter(Types.BIGINT)); super.declareParameter(new SqlParameter(Types.VARCHAR)); compile(); }
SqlUpdate insert = new SqlUpdate(ds, "INSERT INTO company (name) VALUES (?)"); insert.declareParameter(new SqlParameter(Types.VARCHAR)); insert.setReturnGeneratedKeys(true); // assuming auto-generated col is named 'id' insert.setGeneratedKeysColumnNames(new String[] {"id"}); insert.compile(); .... GeneratedKeyHolder keyHolder = new GeneratedKeyHolder(); insert.update(new Object[]{"test"}, keyHolder); System.out.println(keyHolder.getKey().longValue());
deleteLogEntryStatement.declareParameter(new SqlParameter("tenantId", Types.INTEGER)); deleteLogEntryStatement.declareParameter(new SqlParameter("pluginId", Types.VARCHAR)); deleteLogEntryStatement.declareParameter(new SqlParameter("pluginVersion", Types.VARCHAR)); deleteLogEntryStatement.declareParameter(new SqlParameter("startDate", Types.TIMESTAMP)); deleteLogEntryStatement.declareParameter(new SqlParameter("assocTypeId", Types.VARCHAR)); deleteLogEntryStatement.compile();