From 58af7e0158b2d7c160cd76d279411c90f124295c Mon Sep 17 00:00:00 2001
From: Dominic Rogetzer <e1627756@student.tuwien.ac.at>
Date: Tue, 1 May 2018 16:39:59 +0200
Subject: fix syntax error in INSERT_EMPLOYEE_VERSION SQL statement, reformat
code
---
.../einsatzverwaltung/dao/EmployeeDatabaseDao.java | 18 +++++++++---------
1 file changed, 9 insertions(+), 9 deletions(-)
(limited to 'src/main/java/at')
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());
--
cgit v1.2.3-70-g09d2