Package com.openindex.openestate.tool.db.hsql

Class HSqlDbUserHandler

java.lang.Object

com.openindex.openestate.tool.db.DbUserHandlerImpl

com.openindex.openestate.tool.db.hsql.HSqlDbUserHandler

All Implemented Interfaces:

DbUserHandler

public class HSqlDbUserHandler
extends DbUserHandlerImpl

HSqlDbUserHandler.

Author:

Andreas Rudolph

Field Summary

Fields

Modifier and Type	Field	Description
static String	FIELD_GROUP_ID
static String	FIELD_GROUP_NAME
static String	FIELD_GROUP_NOTES
static String	FIELD_PERMISSION_ID
static String	FIELD_PERMISSION_KEY
static String	FIELD_SETTING_KEY
static String	FIELD_SETTING_VALUE
static String	FIELD_USER_ID
static String	FIELD_USER_LOGIN
static String	FIELD_USER_NOTES
static String	PROC_REMOVE_GROUPS
static String	PROC_REMOVE_GROUPS_PERMISSIONS
static String	PROC_REMOVE_PERMISSIONS
static String	PROC_REMOVE_USERS
static String	PROC_REMOVE_USERS_GROUPS
static String	PROC_REMOVE_USERS_PERMISSIONS
static String	PROC_REMOVE_USERS_SETTINGS
static String	PROC_SAVE_GROUPS
static String	PROC_SAVE_GROUPS_PERMISSIONS
static String	PROC_SAVE_PERMISSIONS
static String	PROC_SAVE_USERS
static String	PROC_SAVE_USERS_GROUPS
static String	PROC_SAVE_USERS_PERMISSIONS
static String	PROC_SAVE_USERS_SETTINGS
static String	PROC_SET_USERS_LAST_LOGIN
static String	VIEW_GROUPS
static String	VIEW_GROUPS_PERMISSIONS
static String	VIEW_PERMISSIONS
static String	VIEW_USERS
static String	VIEW_USERS_GROUPS
static String	VIEW_USERS_PERMISSIONS
static String	VIEW_USERS_SETTINGS

Constructor Summary

Constructors

Constructor	Description
HSqlDbUserHandler()

Method Summary

Modifier and Type	Method	Description
long[]	getGroupIds(Connection c, String[] names)
String[]	getGroupNames(Connection c, long[] ids)
Map<String,List<String>>	getGroupPermissions(Connection c, long groupId)
DbGroup[]	getGroups(Connection c, long[] ids)
DbGroup[]	getGroups(Connection c, String[] names)
long[]	getPermissionIds(Connection c, long pluginId, String[] keys)
String[]	getPermissionKeys(Connection c, long pluginId)
DbPermission[]	getPermissions(Connection c, long[] ids)
DbPermission[]	getPermissions(Connection c, long pluginId, String[] keys)
long[]	getUserIds(Connection c, String[] logins)
String[]	getUserLogins(Connection c)
Map<String,List<String>>	getUserPermissions(Connection c, long userId)
DbUser[]	getUsers(Connection c, long[] ids)
DbUser[]	getUsers(Connection c, String[] logins)
void	loadGroupUsers(Connection c, DbGroup[] groups)
void	loadUserGroups(Connection c, DbUser[] users)
void	loadUserSettings(Connection c, DbUser[] users)
void	removeGroups(Connection c, long[] ids)
void	removePermissions(Connection c, long[] ids)
void	removeUsers(Connection c, long[] ids)
void	saveGroup(Connection c, DbPluginHandler pluginHandler, DbGroup group)
void	savePermission(Connection c, DbPermission permission)
void	saveUserCompletely(Connection c, DbPluginHandler pluginHandler, DbUser user)
void	saveUserProfile(Connection c, DbPluginHandler pluginHandler, DbUser user)
void	setUserLastLogin(Connection c, long userId, Date lastLogin)

Methods inherited from class com.openindex.openestate.tool.db.DbUserHandlerImpl

getGroup, getGroup, getGroupIds, getGroupNames, getGroups, getPermission, getPermission, getPermissionIds, getPermissionIds, getPermissions, getPermissions, getUser, getUser, getUserId, getUserIds, getUsers, loadGroupPermissions, loadGroupUsers, loadUserEffectivePermissions, loadUserGroups, loadUserPermissions, loadUserSettings, removeGroup, removeGroup, removeGroups, removePermission, removePermission, removePermissions, removeUser, removeUser, removeUsers, saveGroup, saveUserCompletely, saveUserProfile, setUserLastLogin

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

PROC_REMOVE_GROUPS

public static final String PROC_REMOVE_GROUPS

See Also:

Constant Field Values

PROC_REMOVE_GROUPS_PERMISSIONS

public static final String PROC_REMOVE_GROUPS_PERMISSIONS

See Also:

Constant Field Values

PROC_REMOVE_PERMISSIONS

public static final String PROC_REMOVE_PERMISSIONS

See Also:

Constant Field Values

PROC_REMOVE_USERS

public static final String PROC_REMOVE_USERS

See Also:

Constant Field Values

PROC_REMOVE_USERS_GROUPS

public static final String PROC_REMOVE_USERS_GROUPS

See Also:

Constant Field Values

PROC_REMOVE_USERS_PERMISSIONS

public static final String PROC_REMOVE_USERS_PERMISSIONS

See Also:

Constant Field Values

PROC_REMOVE_USERS_SETTINGS

public static final String PROC_REMOVE_USERS_SETTINGS

See Also:

Constant Field Values

PROC_SAVE_GROUPS

public static final String PROC_SAVE_GROUPS

See Also:

Constant Field Values

PROC_SAVE_GROUPS_PERMISSIONS

public static final String PROC_SAVE_GROUPS_PERMISSIONS

See Also:

Constant Field Values

PROC_SAVE_PERMISSIONS

public static final String PROC_SAVE_PERMISSIONS

See Also:

Constant Field Values

PROC_SAVE_USERS

public static final String PROC_SAVE_USERS

See Also:

Constant Field Values

PROC_SAVE_USERS_GROUPS

public static final String PROC_SAVE_USERS_GROUPS

See Also:

Constant Field Values

PROC_SAVE_USERS_PERMISSIONS

public static final String PROC_SAVE_USERS_PERMISSIONS

See Also:

Constant Field Values

PROC_SAVE_USERS_SETTINGS

public static final String PROC_SAVE_USERS_SETTINGS

See Also:

Constant Field Values

PROC_SET_USERS_LAST_LOGIN

public static final String PROC_SET_USERS_LAST_LOGIN

See Also:

Constant Field Values

VIEW_GROUPS

public static final String VIEW_GROUPS

See Also:

Constant Field Values

VIEW_GROUPS_PERMISSIONS

public static final String VIEW_GROUPS_PERMISSIONS

See Also:

Constant Field Values

VIEW_PERMISSIONS

public static final String VIEW_PERMISSIONS

See Also:

Constant Field Values

VIEW_USERS

public static final String VIEW_USERS

See Also:

Constant Field Values

VIEW_USERS_GROUPS

public static final String VIEW_USERS_GROUPS

See Also:

Constant Field Values

VIEW_USERS_PERMISSIONS

public static final String VIEW_USERS_PERMISSIONS

See Also:

Constant Field Values

VIEW_USERS_SETTINGS

public static final String VIEW_USERS_SETTINGS

See Also:

Constant Field Values

FIELD_USER_ID

public static final String FIELD_USER_ID

See Also:

Constant Field Values

FIELD_USER_LOGIN

public static final String FIELD_USER_LOGIN

See Also:

Constant Field Values

FIELD_USER_NOTES

public static final String FIELD_USER_NOTES

See Also:

Constant Field Values

FIELD_GROUP_ID

public static final String FIELD_GROUP_ID

See Also:

Constant Field Values

FIELD_GROUP_NAME

public static final String FIELD_GROUP_NAME

See Also:

Constant Field Values

FIELD_GROUP_NOTES

public static final String FIELD_GROUP_NOTES

See Also:

Constant Field Values

FIELD_PERMISSION_ID

public static final String FIELD_PERMISSION_ID

See Also:

Constant Field Values

FIELD_PERMISSION_KEY

public static final String FIELD_PERMISSION_KEY

See Also:

Constant Field Values

FIELD_SETTING_KEY

public static final String FIELD_SETTING_KEY

See Also:

Constant Field Values

FIELD_SETTING_VALUE

public static final String FIELD_SETTING_VALUE

See Also:

Constant Field Values

Constructor Detail

HSqlDbUserHandler

public HSqlDbUserHandler()

Method Detail

getGroups

public DbGroup[] getGroups(Connection c,
                           long[] ids)
                    throws SQLException

Specified by:

getGroups in interface DbUserHandler

Specified by:

getGroups in class DbUserHandlerImpl

Throws:

SQLException

getGroups

public DbGroup[] getGroups(Connection c,
                           String[] names)
                    throws SQLException

Specified by:

getGroups in interface DbUserHandler

Specified by:

getGroups in class DbUserHandlerImpl

Throws:

SQLException

getGroupIds

public long[] getGroupIds(Connection c,
                          String[] names)
                   throws SQLException

Specified by:

getGroupIds in interface DbUserHandler

Specified by:

getGroupIds in class DbUserHandlerImpl

Throws:

SQLException

getGroupNames

public String[] getGroupNames(Connection c,
                              long[] ids)
                       throws SQLException

Specified by:

getGroupNames in interface DbUserHandler

Specified by:

getGroupNames in class DbUserHandlerImpl

Throws:

SQLException

getGroupPermissions

public Map<String,List<String>> getGroupPermissions(Connection c,
                                                          long groupId)
                                                   throws SQLException

Specified by:

getGroupPermissions in interface DbUserHandler

Specified by:

getGroupPermissions in class DbUserHandlerImpl

Throws:

SQLException

getPermissionIds

public long[] getPermissionIds(Connection c,
                               long pluginId,
                               String[] keys)
                        throws SQLException

Specified by:

getPermissionIds in interface DbUserHandler

Specified by:

getPermissionIds in class DbUserHandlerImpl

Throws:

SQLException

getPermissionKeys

public String[] getPermissionKeys(Connection c,
                                  long pluginId)
                           throws SQLException

Specified by:

getPermissionKeys in interface DbUserHandler

Specified by:

getPermissionKeys in class DbUserHandlerImpl

Throws:

SQLException

getPermissions

public DbPermission[] getPermissions(Connection c,
                                     long[] ids)
                              throws SQLException

Specified by:

getPermissions in interface DbUserHandler

Specified by:

getPermissions in class DbUserHandlerImpl

Throws:

SQLException

getPermissions

public DbPermission[] getPermissions(Connection c,
                                     long pluginId,
                                     String[] keys)
                              throws SQLException

Specified by:

getPermissions in interface DbUserHandler

Specified by:

getPermissions in class DbUserHandlerImpl

Throws:

SQLException

getUsers

public DbUser[] getUsers(Connection c,
                         long[] ids)
                  throws SQLException

Specified by:

getUsers in interface DbUserHandler

Specified by:

getUsers in class DbUserHandlerImpl

Throws:

SQLException

getUsers

public DbUser[] getUsers(Connection c,
                         String[] logins)
                  throws SQLException

Specified by:

getUsers in interface DbUserHandler

Specified by:

getUsers in class DbUserHandlerImpl

Throws:

SQLException

getUserIds

public long[] getUserIds(Connection c,
                         String[] logins)
                  throws SQLException

Specified by:

getUserIds in interface DbUserHandler

Specified by:

getUserIds in class DbUserHandlerImpl

Throws:

SQLException

getUserLogins

public String[] getUserLogins(Connection c)
                       throws SQLException

Specified by:

getUserLogins in interface DbUserHandler

Specified by:

getUserLogins in class DbUserHandlerImpl

Throws:

SQLException

getUserPermissions

public Map<String,List<String>> getUserPermissions(Connection c,
                                                         long userId)
                                                  throws SQLException

Specified by:

getUserPermissions in interface DbUserHandler

Specified by:

getUserPermissions in class DbUserHandlerImpl

Throws:

SQLException

loadGroupUsers

public void loadGroupUsers(Connection c,
                           DbGroup[] groups)
                    throws SQLException

Specified by:

loadGroupUsers in interface DbUserHandler

Specified by:

loadGroupUsers in class DbUserHandlerImpl

Throws:

SQLException

loadUserGroups

public void loadUserGroups(Connection c,
                           DbUser[] users)
                    throws SQLException

Specified by:

loadUserGroups in interface DbUserHandler

Specified by:

loadUserGroups in class DbUserHandlerImpl

Throws:

SQLException

loadUserSettings

public void loadUserSettings(Connection c,
                             DbUser[] users)
                      throws SQLException

Specified by:

loadUserSettings in interface DbUserHandler

Specified by:

loadUserSettings in class DbUserHandlerImpl

Throws:

SQLException

removeGroups

public void removeGroups(Connection c,
                         long[] ids)
                  throws SQLException

Specified by:

removeGroups in interface DbUserHandler

Specified by:

removeGroups in class DbUserHandlerImpl

Throws:

SQLException

removePermissions

public void removePermissions(Connection c,
                              long[] ids)
                       throws SQLException

Specified by:

removePermissions in interface DbUserHandler

Specified by:

removePermissions in class DbUserHandlerImpl

Throws:

SQLException

removeUsers

public void removeUsers(Connection c,
                        long[] ids)
                 throws SQLException

Specified by:

removeUsers in interface DbUserHandler

Specified by:

removeUsers in class DbUserHandlerImpl

Throws:

SQLException

saveGroup

public void saveGroup(Connection c,
                      DbPluginHandler pluginHandler,
                      DbGroup group)
               throws SQLException

Specified by:

saveGroup in interface DbUserHandler

Specified by:

saveGroup in class DbUserHandlerImpl

Throws:

SQLException

savePermission

public void savePermission(Connection c,
                           DbPermission permission)
                    throws SQLException

Specified by:

savePermission in interface DbUserHandler

Specified by:

savePermission in class DbUserHandlerImpl

Throws:

SQLException

saveUserCompletely

public void saveUserCompletely(Connection c,
                               DbPluginHandler pluginHandler,
                               DbUser user)
                        throws SQLException

Specified by:

saveUserCompletely in interface DbUserHandler

Specified by:

saveUserCompletely in class DbUserHandlerImpl

Throws:

SQLException

saveUserProfile

public void saveUserProfile(Connection c,
                            DbPluginHandler pluginHandler,
                            DbUser user)
                     throws SQLException

Specified by:

saveUserProfile in interface DbUserHandler

Specified by:

saveUserProfile in class DbUserHandlerImpl

Throws:

SQLException

setUserLastLogin

public void setUserLastLogin(Connection c,
                             long userId,
                             Date lastLogin)
                      throws SQLException

Specified by:

setUserLastLogin in interface DbUserHandler

Specified by:

setUserLastLogin in class DbUserHandlerImpl

Throws:

SQLException