com.silverpeas.pdcSubscription.ejb
Class PdcSubscriptionDAO

java.lang.Object
  com.silverpeas.pdcSubscription.ejb.PdcSubscriptionDAO

public class PdcSubscriptionDAO
extends Object

Field Summary

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

PdcSubscriptionDAO()

Method Summary

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