/** * Delete a {@link Operation} in the DB * * @param operation - the {@link Operation} to delete * @return <code>true</code> if the item has been updated, <code>false</code> otherwise. * @throws OHException */ public boolean deleteOperation(Operation operation) throws OHException { DbQueryLogger dbQuery = new DbQueryLogger(); String sqlString = "DELETE FROM OPERATION WHERE OPE_ID_A = ?"; List<Object> parameters = Collections.<Object>singletonList(operation.getCode()); return dbQuery.setDataWithParams(sqlString, parameters, true); }
/** * updates an {@link Operation} in the DB * * @param operation - the {@link Operation} to update * @return <code>true</code> if the item has been updated, <code>false</code> otherwise. * @throws OHException */ public boolean updateOperation(Operation operation) throws OHException { DbQueryLogger dbQuery = new DbQueryLogger(); boolean result = false; try { String sqlString = "UPDATE OPERATION set " + " OPE_DESC = ?," + " OPE_LOCK = OPE_LOCK + 1, " + " OPE_STAT = ?" + " WHERE OPE_ID_A = ?"; List<Object> parameters = new ArrayList<Object>(); parameters.add(operation.getDescription()); parameters.add(operation.getMajor()); parameters.add(operation.getCode()); result = dbQuery.setDataWithParams(sqlString, parameters, true); if (result) operation.setLock(operation.getLock() + 1); } finally { dbQuery.releaseConnection(); } return result; }
/** * insert an {@link Operation} in the DB * * @param operation - the {@link Operation} to insert * @return <code>true</code> if the operation has been inserted, <code>false</code> otherwise. * @throws OHException */ public boolean newOperation(Operation operation) throws OHException { DbQueryLogger dbQuery = new DbQueryLogger(); String sqlString = "INSERT INTO OPERATION (OPE_ID_A, OPE_OCL_ID_A, OPE_DESC, OPE_STAT) VALUES (?, ?, ?, ?)"; List<Object> parameters = new ArrayList<Object>(); parameters.add(operation.getCode()); parameters.add(operation.getType().getCode()); parameters.add(operation.getDescription()); parameters.add(operation.getMajor()); return dbQuery.setDataWithParams(sqlString, parameters, true); }