From cfa03468e10e28867904a58f86222862859e165c Mon Sep 17 00:00:00 2001 From: Björn Hagemeister Date: Tue, 7 Oct 2014 16:39:06 +0200 Subject: Adapted FielUploadWorker and ThriftConnection for using publishUser(..). But publishUser ist not implemented yet. Plus added class DbUser for reading from user database. --- .../org/openslx/satellitedaemon/db/DbUser.java | 29 ++++++++++++++++++++++ 1 file changed, 29 insertions(+) create mode 100644 src/main/java/org/openslx/satellitedaemon/db/DbUser.java (limited to 'src/main/java/org/openslx/satellitedaemon/db/DbUser.java') 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 ); + } +} -- cgit v1.2.3-55-g7522