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/EmployeeDatabaseDao.java | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/src/main/java/at/ac/tuwien/sepm/assignment/groupphase/einsatzverwaltung/dao/EmployeeDatabaseDao.java b/src/main/java/at/ac/tuwien/sepm/assignment/groupphase/einsatzverwaltung/dao/EmployeeDatabaseDao.java index 81b8c86..f16f98e 100644 --- a/src/main/java/at/ac/tuwien/sepm/assignment/groupphase/einsatzverwaltung/dao/EmployeeDatabaseDao.java +++ b/src/main/java/at/ac/tuwien/sepm/assignment/groupphase/einsatzverwaltung/dao/EmployeeDatabaseDao.java @@ -20,11 +20,9 @@ public class EmployeeDatabaseDao implements EmployeeDAO { private static final Logger LOG = LoggerFactory.getLogger(MethodHandles.lookup().lookupClass()); private static final String INSERT_EMPLOYEE_VERSION = - "INSERT INTO EmployeeVersion(name, birthday, educationLevel, isDriver, isPilot " + - "VALUES(?, ?, ?, ?, ?)"; - private static final String INSERT_EMPLOYEE = - "INSERT INTO Employee(version) VALUES(?)"; - + "INSERT INTO EmployeeVersion(name, birthday, educationLevel, isDriver, isPilot) " + + "VALUES(?, ?, ?, ?, ?)"; + private static final String INSERT_EMPLOYEE = "INSERT INTO Employee(version) VALUES(?)"; private final PreparedStatement insertEmployeeVersion, insertEmployee; @@ -34,10 +32,11 @@ public class EmployeeDatabaseDao implements EmployeeDAO { try { final var connection = connectionManager.getConnection(); - insertEmployeeVersion = connection.prepareStatement( + insertEmployeeVersion = + connection.prepareStatement( INSERT_EMPLOYEE_VERSION, Statement.RETURN_GENERATED_KEYS); - insertEmployee = connection.prepareStatement( - INSERT_EMPLOYEE, Statement.RETURN_GENERATED_KEYS); + insertEmployee = + connection.prepareStatement(INSERT_EMPLOYEE, Statement.RETURN_GENERATED_KEYS); } catch (SQLException e) { throw new PersistenceException(e); @@ -50,7 +49,8 @@ public class EmployeeDatabaseDao implements EmployeeDAO { // Assumption: the given employee is already validated (from service) try { insertEmployeeVersion.setString(1, employee.name()); - insertEmployeeVersion.setTimestamp(2, Timestamp.valueOf(employee.birthday().atStartOfDay())); + insertEmployeeVersion.setTimestamp( + 2, Timestamp.valueOf(employee.birthday().atStartOfDay())); insertEmployeeVersion.setString(3, employee.educationLevel().toString()); insertEmployeeVersion.setBoolean(4, employee.isDriver()); insertEmployeeVersion.setBoolean(5, employee.isPilot()); |