From 95f4150c6074126f2639028a07a629e46300f3d7 Mon Sep 17 00:00:00 2001 From: ulrich <not disclosed> Date: Tue, 27 Dec 2016 09:53:54 +0000 Subject: [PATCH] Funktin Neue Rolle erstellt aber noch nicht mit Server verknuepft --- src/java/de/uhilger/um/api/UserMgr.java | 26 ++++++++++++++++++++------ 1 files changed, 20 insertions(+), 6 deletions(-) diff --git a/src/java/de/uhilger/um/api/UserMgr.java b/src/java/de/uhilger/um/api/UserMgr.java index 399a461..e183a68 100644 --- a/src/java/de/uhilger/um/api/UserMgr.java +++ b/src/java/de/uhilger/um/api/UserMgr.java @@ -4,11 +4,13 @@ import de.uhilger.baselink.Record; import de.uhilger.um.App; import de.uhilger.um.daten.User; +import de.uhilger.um.daten.UserRole; import java.util.List; import org.apache.catalina.realm.RealmBase; /** - * Klasse zur Verwaltung von Benutzern in einer Datenbank + * Klasse zur Verwaltung von Benutzern und Rollen + * in einer Datenbank * * @author Ulrich Hilger */ @@ -17,9 +19,11 @@ private static final String MD5 = "MD5"; private static final Record UserMapper = new GenericRecord(User.class); + private static final Record UserRoleMapper = new GenericRecord(UserRole.class); public static final String SQL_GET_USER_LIST = "getUserList"; public static final String SQL_GET_USER_NAME_LIST = "getUserNameList"; + public static final String SQL_GET_ROLE_LIST = "getRoleList"; public static final String SQL_DELETE_USER = "deleteUser"; /* ----------- Benutzer -------------- */ @@ -52,16 +56,26 @@ /* ------------ Rollen ------------------ */ - public String grantRole(String userId, String roleName) { - return "not implemented"; + public UserRole grantRole(String userId, String roleName) { + UserRole ur = new UserRole(); + ur.setRole(roleName); + ur.setUser(userId); + App.getDatabase().insert(ur, UserRoleMapper); + return ur; } - public String revokeRole(String userId, String roleName) { - return "not implemented"; + public UserRole revokeRole(String userId, String roleName) { + UserRole ur = new UserRole(); + ur.setRole(roleName); + ur.setUser(userId); + App.getDatabase().delete(ur, UserRoleMapper); + return ur; } public List getRoleNamesGranted() { - return null; + String sql = App.getSqlStatement(SQL_GET_ROLE_LIST); + List roleNames = App.getDatabase().select(sql, App.WITHOUT_BLOBS); + return roleNames; } /* ------------ sonstige Methoden -------------- */ -- Gitblit v1.9.3