diff options
Diffstat (limited to 'src/main/java/at/ac/tuwien/sepm/assignment')
| -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) {  | 
