aboutsummaryrefslogtreecommitdiffstats
path: root/src/main/java
diff options
context:
space:
mode:
Diffstat (limited to 'src/main/java')
-rw-r--r--src/main/java/at/ac/tuwien/sepm/assignment/groupphase/einsatzverwaltung/dao/H2RegistrationDAO.java8
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) {