/* * (non-Javadoc) * * @see org.cuny.sensors.dao.IDao#save(java.lang.Object) */ @Override public RawFile save(RawFile obj) throws Exception { Map<String, Object> parameters = new HashMap<String, Object>(5); parameters.put(FILE_NAME, obj.getFilename()); parameters.put(FILE_SIZE, obj.getFileSize()); parameters.put(STATUS, obj.getStatus().toString()); parameters.put(BUILDING, obj.getBuilding()); parameters.put(CAMPUS, obj.getCampus()); Number newId = insertActor.executeAndReturnKey(parameters); obj.setId(newId.longValue()); return obj; }
/* * (non-Javadoc) * * @see org.cuny.sensors.dao.IDao#update(java.lang.Object) */ @Override public RawFile update(RawFile obj) throws Exception { RawFile old = get(obj.getId()); this.jdbcTemplate.update( "update " + TABLE_NAME + " set " + FILE_NAME + " = ?, " + FILE_SIZE + " = ?, " + DATASET_COUNT + " = ?, " + SENSOR_COUNT + " = ?, " + RECORD_COUNT + " = ?, " + BUILDING + " = ?," + CAMPUS + " = ?," + STATUS + " = ?," + NOTES + " = ? where " + ID + " = ?", obj.getFilename(), obj.getFileSize(), obj.getDatasetCount(), obj.getSensorCount(), obj.getRecordCount(), obj.getBuilding(), obj.getCampus(), obj.getStatus().toString(), obj.getNotes(), obj.getId()); return old; }