| | |
| | | import de.uhilger.um.daten.User; |
| | | import de.uhilger.um.daten.UserData; |
| | | import de.uhilger.um.daten.UserRole; |
| | | import de.uhilger.um.web.Initialiser; |
| | | import java.sql.Connection; |
| | | import java.util.List; |
| | | import java.util.Properties; |
| | |
| | | /** Mapper-Objekt fuer Benutzer */ |
| | | private static final Record UserMapper = new GenericRecord(User.class); |
| | | /** Mapper-Objekt fuer Benutzerdaten */ |
| | | private static final Record UserDataMapper = new GenericRecord(UserData.class); |
| | | //private static final Record UserDataMapper = new GenericRecord(UserData.class); |
| | | /** Mapper-Objekt fuer Benutzerrollen */ |
| | | private static final Record UserRoleMapper = new GenericRecord(UserRole.class); |
| | | |
| | |
| | | } |
| | | |
| | | public List getUserNameList() { |
| | | String sql = getSql(SQL_GET_USER_NAME_LIST); |
| | | return getDb().select(sql, UserDataMapper); |
| | | return removeHeadline(getDb().select(getSql(SQL_GET_USER_NAME_LIST), WITHOUT_BLOBS)); |
| | | } |
| | | |
| | | public User deleteUser(User user) { |
| | |
| | | } |
| | | |
| | | public List getRoleNamesGranted() { |
| | | return getDb().select(getSql(SQL_GET_ROLE_LIST), WITHOUT_BLOBS); |
| | | return removeHeadline(getDb().select(getSql(SQL_GET_ROLE_LIST), WITHOUT_BLOBS)); |
| | | } |
| | | |
| | | public List getUserRoleNames(String userId) { |
| | | return getDb().select(getSql(SQL_GET_USER_ROLES), WITHOUT_BLOBS, userId); |
| | | return removeHeadline(getDb().select(getSql(SQL_GET_USER_ROLES), WITHOUT_BLOBS, userId)); |
| | | } |
| | | |
| | | /* ----------- Helfer ---- */ |
| | | |
| | | private List removeHeadline(List list) { |
| | | if(list != null && list.size() > 0) { |
| | | list.remove(0); |
| | | } |
| | | return list; |
| | | } |
| | | |
| | | /** |
| | | * Ein benanntes SQL-Kommando ermitteln |
| | | * @param id Name des gewuenschten SQL-Kommandos |