1 files changed, 29 insertions, 0 deletions
diff --git a/src/main/java/org/openslx/satellitedaemon/db/DbUser.java b/src/main/java/org/openslx/satellitedaemon/db/DbUser.java
new file mode 100644
index 0000000..133adf4
--- /dev/null
+++ b/src/main/java/org/openslx/satellitedaemon/db/DbUser.java
@@ -0,0 +1,29 @@
+package org.openslx.satellitedaemon.db;
+
+public class DbUser
+{
+
+	public final String userId;
+	public final String firstName;
+	public final String lastName;
+	public final String email;
+	
+	public DbUser(String userId, String firstName, String lastName, String email) {
+		this.userId = userId;
+		this.firstName = firstName;
+		this.lastName = lastName;
+		this.email = email;
+	}
+	
+	/**
+	 * Returns DbUser with given userId.
+	 * @param userId
+	 * @return DbUser with userId.
+	 */
+	public static DbUser getUserById(String userId) {
+		return MySQL.findUniqueOrNull( DbUser.class, "SELECT user.userID, user.Vorname AS firstName, " +
+				"user.Nachname AS lastName, user.mail AS email" +
+				"FROM m_user user" +
+				"WHERE userID = ?", userId );
+	}
+}