summaryrefslogtreecommitdiffstats
path: root/src/main/java/org/openslx/satellitedaemon/db/DbUser.java
blob: 3aa57d2ce56ff9ceb4bdcf4eb78b0ebe16821956 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
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 final String institution;
	
	public DbUser(String userId, String firstName, String lastName, String email, String institution) {
		this.userId = userId;
		this.firstName = firstName;
		this.lastName = lastName;
		this.email = email;
		this.institution = institution;
	}
	
	/**
	 * 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, user.institution " +
				"FROM m_user user " +
				"WHERE userID = ?", userId );
	}
}