diff options
-rw-r--r-- | src/main/java/at/ac/tuwien/sepm/assignment/groupphase/einsatzverwaltung/dao/H2RegistrationDAO.java | 8 |
1 files changed, 8 insertions, 0 deletions
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) { |