From ac1f1a80e3ae69e3d183175d24d0d7f182d0798e Mon Sep 17 00:00:00 2001 From: Martin Weick Date: Mon, 14 May 2018 10:30:55 +0200 Subject: Implement Persistence UpdateCar --- .../einsatzverwaltung/dao/VehicleDatabaseDao.java | 28 +++++++++++++++++++++- 1 file changed, 27 insertions(+), 1 deletion(-) (limited to 'src/main/java') 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 list() throws PersistenceException { -- cgit v1.2.3-70-g09d2