diff options
| author | Dominic Rogetzer <e1627756@student.tuwien.ac.at> | 2018-05-01 16:39:59 +0200 |
|---|---|---|
| committer | Dominic Rogetzer <e01627756@student.tuwien.ac.at> | 2018-05-03 22:48:30 +0200 |
| commit | 58af7e0158b2d7c160cd76d279411c90f124295c (patch) | |
| tree | c442eae00b4d5abc1fc8099cf4f49873df9d7fe0 /src | |
| parent | 795f86fb257c6d5099886390b4dfe9971f5a6371 (diff) | |
| download | sepm-groupproject-58af7e0158b2d7c160cd76d279411c90f124295c.tar.gz sepm-groupproject-58af7e0158b2d7c160cd76d279411c90f124295c.tar.xz sepm-groupproject-58af7e0158b2d7c160cd76d279411c90f124295c.zip | |
fix syntax error in INSERT_EMPLOYEE_VERSION SQL statement, reformat code
Diffstat (limited to 'src')
| -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()); |