com.stratelia.silverpeas.silverStatisticsPeas.control
Class SilverStatisticsPeasDAOConnexion

java.lang.Object
  com.stratelia.silverpeas.silverStatisticsPeas.control.SilverStatisticsPeasDAOConnexion

public class SilverStatisticsPeasDAOConnexion
extends Object

Class declaration Get connections data from database

Author:

Field Summary

static int	INDICE_COUNTCONNEXION
static int	INDICE_DURATION
static int	INDICE_ID
static int	INDICE_LIB

Constructor Summary

SilverStatisticsPeasDAOConnexion()

Method Summary

static Collection[]	getStatsConnexion(String startDate, String endDate) Returns the total number of connections per month.
static Collection<String[]>	getStatsConnexionAllAll(String startDate, String endDate) donne les stats global pour l'enemble de tous les users cad 2 infos, la collection contient donc un seul element
static Collection<String[]>	getStatsConnexionAllGroup(String dateBegin, String dateEnd, int groupId) Returns the group stats : Group name, number of connexions, mean connexion time and group id for all the users of a group.
static Collection<String[]>	getStatsConnexionAllUser(String dateBegin, String dateEnd, int idUser) donne les stats pour un user seulement cad 2 infos, la collection contient donc un seul element
static Collection<String[]>	getStatsConnexionGroupAll(String dateBegin, String dateEnd) Returns the groups stats : group name, number of connexions, mean connexion time and group id for all the groups.
static Collection<String[]>	getStatsConnexionUserAll(String dateBegin, String dateEnd) Returns the user stats : User last name, number of connexions, mean connexion time and user id for all Silverpeas users.
static Collection<String[]>	getStatsConnexionUserUser(String dateBegin, String dateEnd, int userId) Returns the user stats : User last name, number of connexions, mean connexion time and user id.
static Collection[]	getStatsGroupConnexion(String startDate, String endDate, String groupId) Returns the group stats : group name, number of connexions, mean connexion time and group id for all the specified group.
static Collection[]	getStatsUser(String startDate, String endDate) Returns the number of distinct users connections per month.
static Collection[]	getStatsUserConnexion(String startDate, String endDate, String idUser) donne les stats pour un groupe
static Collection[]	getStatsUserFq(String startDate, String endDate, int min, int max)
static Collection<String>	getYears()

Methods inherited from class java.lang.Object

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

Field Detail

INDICE_LIB

public static final int INDICE_LIB

See Also:

Constant Field Values

INDICE_COUNTCONNEXION

public static final int INDICE_COUNTCONNEXION

See Also:

Constant Field Values

INDICE_DURATION

public static final int INDICE_DURATION

See Also:

Constant Field Values

INDICE_ID

public static final int INDICE_ID

See Also:

Constant Field Values

Constructor Detail

SilverStatisticsPeasDAOConnexion

public SilverStatisticsPeasDAOConnexion()

Method Detail

getStatsConnexionAllAll

public static Collection<String[]> getStatsConnexionAllAll(String startDate,
                                                           String endDate)
                                                    throws SQLException,
                                                           UtilException

donne les stats global pour l'enemble de tous les users cad 2 infos, la collection contient donc un seul element

Parameters:

startDate -

endDate -

Returns:

Throws:

SQLException

UtilException

See Also:

getStatsUser

public static Collection[] getStatsUser(String startDate,
                                        String endDate)
                                 throws SQLException,
                                        ParseException,
                                        UtilException

Returns the number of distinct users connections per month.

Parameters:

startDate -

endDate -

Returns:

the number of distinct users connections per month.

Throws:

SQLException

ParseException

UtilException

getStatsConnexion

public static Collection[] getStatsConnexion(String startDate,
                                             String endDate)
                                      throws SQLException,
                                             ParseException,
                                             UtilException

Returns the total number of connections per month.

Parameters:

startDate -

endDate -

Returns:

the total number of connections per month.

Throws:

SQLException

ParseException

UtilException

getStatsConnexionAllUser

public static Collection<String[]> getStatsConnexionAllUser(String dateBegin,
                                                            String dateEnd,
                                                            int idUser)
                                                     throws SQLException,
                                                            UtilException

donne les stats pour un user seulement cad 2 infos, la collection contient donc un seul element

Parameters:

dateBegin -

dateEnd -

idUser -

Returns:

Throws:

SQLException

UtilException

See Also:

getStatsUserConnexion

public static Collection[] getStatsUserConnexion(String startDate,
                                                 String endDate,
                                                 String idUser)
                                          throws SQLException,
                                                 ParseException,
                                                 UtilException

donne les stats pour un groupe

Returns:

Throws:

SQLException

ParseException

UtilException

getStatsGroupConnexion

public static Collection[] getStatsGroupConnexion(String startDate,
                                                  String endDate,
                                                  String groupId)
                                           throws SQLException,
                                                  ParseException,
                                                  UtilException

Returns the group stats : group name, number of connexions, mean connexion time and group id for all the specified group.

Parameters:

startDate -

endDate -

groupId -

Returns:

the group stats : group name, number of connexions, mean connexion time and group id for all the groups.

Throws:

SQLException

UtilException

ParseException

getStatsConnexionGroupAll

public static Collection<String[]> getStatsConnexionGroupAll(String dateBegin,
                                                             String dateEnd)
                                                      throws SQLException,
                                                             UtilException

Returns the groups stats : group name, number of connexions, mean connexion time and group id for all the groups.

Parameters:

dateBegin -

dateEnd -

Returns:

the group stats : group name, number of connexions, mean connexion time and group id for all the groups.

Throws:

SQLException

UtilException

getStatsConnexionAllGroup

public static Collection<String[]> getStatsConnexionAllGroup(String dateBegin,
                                                             String dateEnd,
                                                             int groupId)
                                                      throws SQLException,
                                                             UtilException

Returns the group stats : Group name, number of connexions, mean connexion time and group id for all the users of a group.

Parameters:

dateBegin - .

dateEnd - .

groupId - .

Returns:

the group stats : Group last name, number of connexions, mean connexion time and group id for all the users of a group.

Throws:

SQLException

UtilException

getStatsConnexionUserAll

public static Collection<String[]> getStatsConnexionUserAll(String dateBegin,
                                                            String dateEnd)
                                                     throws SQLException,
                                                            UtilException

Returns the user stats : User last name, number of connexions, mean connexion time and user id for all Silverpeas users.

Parameters:

dateBegin -

dateEnd -

Returns:

the user stats : User last name, number of connexions, mean connexion time and user id for all Silverpeas users.

Throws:

SQLException

UtilException

getStatsConnexionUserUser

public static Collection<String[]> getStatsConnexionUserUser(String dateBegin,
                                                             String dateEnd,
                                                             int userId)
                                                      throws SQLException,
                                                             UtilException

Returns the user stats : User last name, number of connexions, mean connexion time and user id.

Parameters:

dateBegin -

dateEnd -

userId -

Returns:

Throws:

SQLException

UtilException

See Also:

getYears

public static Collection<String> getYears()
                                   throws SQLException,
                                          UtilException

Throws:

SQLException

UtilException

getStatsUserFq

public static Collection[] getStatsUserFq(String startDate,
                                          String endDate,
                                          int min,
                                          int max)
                                   throws SQLException,
                                          ParseException,
                                          UtilException

Parameters:

startDate -

endDate -

min -

max -

Returns:

Throws:

SQLException

ParseException

UtilException