com.stratelia.silverpeas.domains.sqldriver
Class SQLGroupTable

java.lang.Object
  com.stratelia.silverpeas.domains.sqldriver.SQLGroupTable

public class SQLGroupTable
extends Object

A GroupTable object manages the DomainSQL_Group table.

Constructor Summary

SQLGroupTable(SQLSettings ds)

Method Summary

int	createGroup(Connection c, Group group) Inserts in the database a new Group row.
void	deleteGroup(Connection c, int groupId)
protected Group	fetchGroup(ResultSet rs) Fetch the current group row from a resultSet.
List<Group>	getAllGroups(Connection c) Returns the User whith the given id.
protected String	getColumns()
List<Group>	getDirectSubGroups(Connection c, int groupId) Returns the User whith the given id.
Group	getGroup(Connection c, int groupId) Returns the Group whith the given id.
Group	getGroupByName(Connection c, String groupName) Returns the Group whith the given name.
void	updateGroup(Connection c, Group g)

Methods inherited from class java.lang.Object

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

Constructor Detail

SQLGroupTable

public SQLGroupTable(SQLSettings ds)

Method Detail

getColumns

protected String getColumns()

fetchGroup

protected Group fetchGroup(ResultSet rs)
                    throws SQLException

Fetch the current group row from a resultSet.

Throws:

SQLException

createGroup

public int createGroup(Connection c,
                       Group group)
                throws AdminException

Inserts in the database a new Group row.

Throws:

AdminException

deleteGroup

public void deleteGroup(Connection c,
                        int groupId)
                 throws AdminException

Throws:

AdminException

updateGroup

public void updateGroup(Connection c,
                        Group g)
                 throws AdminException

Throws:

AdminException

getGroup

public Group getGroup(Connection c,
                      int groupId)
               throws AdminException

Returns the Group whith the given id.

Throws:

AdminException

getGroupByName

public Group getGroupByName(Connection c,
                            String groupName)
                     throws AdminException

Returns the Group whith the given name.

Throws:

AdminException

getAllGroups

public List<Group> getAllGroups(Connection c)
                         throws AdminException

Returns the User whith the given id.

Throws:

AdminException

getDirectSubGroups

public List<Group> getDirectSubGroups(Connection c,
                                      int groupId)
                               throws AdminException

Returns the User whith the given id.

Throws:

AdminException