diff options
| -rw-r--r-- | src/main/java/at/ac/tuwien/sepm/assignment/groupphase/einsatzverwaltung/dao/VehicleDatabaseDao.java | 28 |
1 files changed, 27 insertions, 1 deletions
diff --git a/src/main/java/at/ac/tuwien/sepm/assignment/groupphase/einsatzverwaltung/dao/VehicleDatabaseDao.java b/src/main/java/at/ac/tuwien/sepm/assignment/groupphase/einsatzverwaltung/dao/VehicleDatabaseDao.java index 82a91e7..62de20a 100644 --- a/src/main/java/at/ac/tuwien/sepm/assignment/groupphase/einsatzverwaltung/dao/VehicleDatabaseDao.java +++ b/src/main/java/at/ac/tuwien/sepm/assignment/groupphase/einsatzverwaltung/dao/VehicleDatabaseDao.java @@ -100,7 +100,33 @@ public class VehicleDatabaseDao implements VehicleDAO { } @Override - public void update(Vehicle vehicle) throws ElementNotFoundException, PersistenceException {} + public void update(Vehicle vehicle) throws ElementNotFoundException, PersistenceException { + String query1 = + "UPDATE VehicleVersion SET name=?, constructionType=?, type=?, hasNef=? WHERE id=?"; + String name = vehicle.type().name() + "-" + vehicle.id(); + PreparedStatement p = null; + try { + p = jdbcConnectionManager.getConnection().prepareStatement(query1); + p.setString(1, vehicle.name()); + p.setString(2, vehicle.constructionType().name()); + if (vehicle.type() == VehicleType.KTW_B) { + p.setString(3, "KTW-B"); + } else { + p.setString(3, name); + } + p.setBoolean(4, vehicle.hasNef()); + p.setLong(5, vehicle.id()); + p.executeUpdate(); + } catch (SQLException e) { + throw new PersistenceException("SQLException : " + e); + } finally { + try { + p.close(); + } catch (SQLException e) { + throw new PersistenceException("SQLException : " + e); + } + } + } @Override public Set<Vehicle> list() throws PersistenceException { |