[server] I'm stupid (add missing classes)

1 files changed, 39 insertions, 0 deletions

diff --git a/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLocation.java b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLocation.java
new file mode 100644
index 00000000..e14bcf0d
--- /dev/null
+++ b/dozentenmodulserver/src/main/java/org/openslx/bwlp/sat/database/mappers/DbLocation.java
@@ -0,0 +1,39 @@
+package org.openslx.bwlp.sat.database.mappers;
+
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.util.ArrayList;
+import java.util.List;
+
+import org.apache.log4j.Logger;
+import org.openslx.bwlp.sat.database.Database;
+import org.openslx.bwlp.sat.database.MysqlConnection;
+import org.openslx.bwlp.sat.database.MysqlStatement;
+import org.openslx.bwlp.sat.util.Configuration;
+import org.openslx.bwlp.sat.util.Util;
+import org.openslx.bwlp.thrift.iface.Location;
+
+public class DbLocation {
+
+	private static final Logger LOGGER = Logger.getLogger(DbLocation.class);
+
+	public static final List<Location> getLocations() throws SQLException {
+		List<Location> list = new ArrayList<>();
+		String locationsTable = Configuration.getDbLocationTable();
+		if (Util.isEmptyString(locationsTable))
+			return list;
+		try (MysqlConnection connection = Database.getConnection()) {
+			MysqlStatement stmt = connection.prepareStatement("SELECT locationid, locationname FROM "
+					+ locationsTable);
+			ResultSet rs = stmt.executeQuery();
+			while (rs.next()) {
+				list.add(new Location(rs.getInt("locationid"), rs.getString("locationname")));
+			}
+		} catch (SQLException e) {
+			LOGGER.error("Query failed in DbLocation.getLocations()", e);
+			throw e;
+		}
+		return list;
+	}
+
+}