Implement Persistence UpdateCar

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 {