Package org.silverpeas.core.admin.domain.driver.sqldriver

Class SQLUserTable

java.lang.Object

org.silverpeas.core.admin.domain.driver.sqldriver.SQLUserTable

public class SQLUserTable
extends Object

a DAO to manage the DomainSQL_User table.

Method Summary

Modifier and Type	Method	Description
int	createUser(Connection c, UserDetail user)	Inserts in the database a new user row.
void	deleteUser(Connection c, int userId)
List<Integer>	getAllUserIds(Connection c)	Returns all the groups in a given userRole (not recursive).
List<UserDetail>	getAllUsers(Connection c)	Returns all the groups in a given userRole (not recursive).
protected String	getColumns()
UserDetail	getUser(Connection c, int userId)	Returns the User with the given id.
List<UserDetail>	getUsers(Connection c, Collection<Integer> userIds)	Returns users corresponding to given user ids.
List<UserDetail>	getUsersBySpecificProperty(Connection c, String propertyName, String value)	Returns all the groups in a given userRole (not recursive).
void	updateUser(Connection c, UserDetail ud)

Methods inherited from class java.lang.Object

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

Method Detail

createUser

public int createUser(Connection c,
                      UserDetail user)
               throws AdminException

Inserts in the database a new user row.

Throws:

AdminException

deleteUser

public void deleteUser(Connection c,
                       int userId)
                throws AdminException

Throws:

AdminException

updateUser

public void updateUser(Connection c,
                       UserDetail ud)
                throws AdminException

Throws:

AdminException

getAllUserIds

public List<Integer> getAllUserIds(Connection c)
                            throws AdminException

Returns all the groups in a given userRole (not recursive).

Throws:

AdminException

getAllUsers

public List<UserDetail> getAllUsers(Connection c)
                             throws AdminException

Returns all the groups in a given userRole (not recursive).

Throws:

AdminException

getUsersBySpecificProperty

public List<UserDetail> getUsersBySpecificProperty(Connection c,
                                                   String propertyName,
                                                   String value)
                                            throws AdminException

Returns all the groups in a given userRole (not recursive).

Throws:

AdminException

getUser

public UserDetail getUser(Connection c,
                          int userId)
                   throws AdminException

Returns the User with the given id.

Throws:

AdminException

getUsers

public List<UserDetail> getUsers(Connection c,
                                 Collection<Integer> userIds)
                          throws AdminException

Returns users corresponding to given user ids.

Throws:

AdminException

getColumns

protected String getColumns()