Package org.silverpeas.core.pdc.subscription.service

Class PdcSubscriptionDAO

java.lang.Object

org.silverpeas.core.pdc.subscription.service.PdcSubscriptionDAO

public class PdcSubscriptionDAO
extends Object

Field Summary

Fields

Modifier and Type	Field	Description
static String	CREATE_PDC_SEARCHCRITERIA_QUERY
static String	CREATE_PDCSUBSCR_QUERY
static String	FIND_SUBSCRIPTION_BY_AXIS_QUERY
static String	GET_ALL_SUBSCRIPTIONS_QUERY
static String	GET_CRITERIAS_BY_SC_ID_QUERY
static String	GET_SUBSCRIPTION_BY_ID_QUERY
static String	GET_SUBSCRIPTION_BY_USERID_QUERY
static String	PDC_SUBSRIPTION_AXIS_TABLE_NAME
static String	PDC_SUBSRIPTION_TABLE_NAME
static String	REMOVE_SCS_QUERY
static String	REMOVE_SUBSCR_BYID_QUERY
static String	UPDATE_PDC_SUBSCR_QUERY

Constructor Summary

Constructors

Constructor	Description
PdcSubscriptionDAO()

Method Summary

Modifier and Type	Method	Description
static int	createPDCSubscription(Connection conn, PdcSubscription subscription)
static List<PdcSubscription>	getAllPDCSubscriptions(Connection conn)
static List<PdcSubscription>	getPDCSubscriptionByUsedAxis(Connection conn, int axisId)
static List<PdcSubscription>	getPDCSubscriptionByUserId(Connection conn, int userId)
static PdcSubscription	getPDCSubsriptionById(Connection conn, int id)
static void	removePDCSubscriptionById(Connection conn, int id)
static void	removePDCSubscriptionById(Connection conn, int[] ids)
static void	updatePDCSubscription(Connection conn, PdcSubscription subscription)

Methods inherited from class java.lang.Object

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

Field Detail

PDC_SUBSRIPTION_TABLE_NAME

public static final String PDC_SUBSRIPTION_TABLE_NAME

See Also:

Constant Field Values

PDC_SUBSRIPTION_AXIS_TABLE_NAME

public static final String PDC_SUBSRIPTION_AXIS_TABLE_NAME

See Also:

Constant Field Values

GET_SUBSCRIPTION_BY_USERID_QUERY

public static final String GET_SUBSCRIPTION_BY_USERID_QUERY

See Also:

Constant Field Values

GET_ALL_SUBSCRIPTIONS_QUERY

public static final String GET_ALL_SUBSCRIPTIONS_QUERY

See Also:

Constant Field Values

GET_CRITERIAS_BY_SC_ID_QUERY

public static final String GET_CRITERIAS_BY_SC_ID_QUERY

See Also:

Constant Field Values

GET_SUBSCRIPTION_BY_ID_QUERY

public static final String GET_SUBSCRIPTION_BY_ID_QUERY

See Also:

Constant Field Values

CREATE_PDCSUBSCR_QUERY

public static final String CREATE_PDCSUBSCR_QUERY

See Also:

Constant Field Values

CREATE_PDC_SEARCHCRITERIA_QUERY

public static final String CREATE_PDC_SEARCHCRITERIA_QUERY

See Also:

Constant Field Values

UPDATE_PDC_SUBSCR_QUERY

public static final String UPDATE_PDC_SUBSCR_QUERY

See Also:

Constant Field Values

REMOVE_SUBSCR_BYID_QUERY

public static final String REMOVE_SUBSCR_BYID_QUERY

See Also:

Constant Field Values

REMOVE_SCS_QUERY

public static final String REMOVE_SCS_QUERY

See Also:

Constant Field Values

FIND_SUBSCRIPTION_BY_AXIS_QUERY

public static final String FIND_SUBSCRIPTION_BY_AXIS_QUERY

See Also:

Constant Field Values

Constructor Detail

PdcSubscriptionDAO

public PdcSubscriptionDAO()

Method Detail

getPDCSubscriptionByUserId

public static List<PdcSubscription> getPDCSubscriptionByUserId(Connection conn,
                                                               int userId)
                                                        throws PdcSubscriptionRuntimeException,
                                                               SQLException

Throws:

PdcSubscriptionRuntimeException

SQLException

getAllPDCSubscriptions

public static List<PdcSubscription> getAllPDCSubscriptions(Connection conn)
                                                    throws PdcSubscriptionRuntimeException,
                                                           SQLException

Throws:

PdcSubscriptionRuntimeException

SQLException

getPDCSubsriptionById

public static PdcSubscription getPDCSubsriptionById(Connection conn,
                                                    int id)
                                             throws PdcSubscriptionRuntimeException,
                                                    SQLException

Throws:

PdcSubscriptionRuntimeException

SQLException

createPDCSubscription

public static int createPDCSubscription(Connection conn,
                                        PdcSubscription subscription)
                                 throws PdcSubscriptionRuntimeException,
                                        SQLException

Throws:

PdcSubscriptionRuntimeException

SQLException

updatePDCSubscription

public static void updatePDCSubscription(Connection conn,
                                         PdcSubscription subscription)
                                  throws PdcSubscriptionRuntimeException,
                                         SQLException

Throws:

PdcSubscriptionRuntimeException

SQLException

removePDCSubscriptionById

public static void removePDCSubscriptionById(Connection conn,
                                             int id)
                                      throws PdcSubscriptionRuntimeException,
                                             SQLException

Throws:

PdcSubscriptionRuntimeException

SQLException

removePDCSubscriptionById

public static void removePDCSubscriptionById(Connection conn,
                                             int[] ids)
                                      throws PdcSubscriptionRuntimeException,
                                             SQLException

Throws:

PdcSubscriptionRuntimeException

SQLException

getPDCSubscriptionByUsedAxis

public static List<PdcSubscription> getPDCSubscriptionByUsedAxis(Connection conn,
                                                                 int axisId)
                                                          throws PdcSubscriptionRuntimeException,
                                                                 SQLException

Throws:

PdcSubscriptionRuntimeException

SQLException