From 5d8f7e3f27c9ffb1c252a41a339c9d39438b9c45 Mon Sep 17 00:00:00 2001 From: Felix Kehrer Date: Fri, 4 May 2018 23:30:10 +0200 Subject: Add missing update to vehicle table --- .../groupphase/einsatzverwaltung/dao/H2RegistrationDAO.java | 8 ++++++++ 1 file changed, 8 insertions(+) diff --git a/src/main/java/at/ac/tuwien/sepm/assignment/groupphase/einsatzverwaltung/dao/H2RegistrationDAO.java b/src/main/java/at/ac/tuwien/sepm/assignment/groupphase/einsatzverwaltung/dao/H2RegistrationDAO.java index 825dc80..c1ea533 100644 --- a/src/main/java/at/ac/tuwien/sepm/assignment/groupphase/einsatzverwaltung/dao/H2RegistrationDAO.java +++ b/src/main/java/at/ac/tuwien/sepm/assignment/groupphase/einsatzverwaltung/dao/H2RegistrationDAO.java @@ -23,6 +23,8 @@ public class H2RegistrationDAO implements RegistrationDAO { private static final String ADD_REGISTRATION = "INSERT INTO Registration (vehicleId, employeeId, start, end, active) VALUES (?,?,?,?,?);"; + private static final String UPDATE_VEHICLE = + "UPDATE Vehicle SET status = 'frei_wache' WHERE id = ?;"; private Connection connection; @@ -64,6 +66,12 @@ public class H2RegistrationDAO implements RegistrationDAO { } } } + + try (PreparedStatement updateVehicle = connection.prepareStatement(UPDATE_VEHICLE)) { + updateVehicle.setLong(1, vehicleId); + updateVehicle.executeUpdate(); + } + connection.commit(); return returnValues; } catch (SQLException e) { -- cgit v1.2.3-70-g09d2