com.stratelia.webactiv.almanach.model
Class EventDAO

java.lang.Object
  com.stratelia.webactiv.almanach.model.EventDAO

public class EventDAO
extends Object

Constructor Summary

EventDAO()

Method Summary

String	addEvent(Connection connection, EventDetail event)
protected void	closeConnection(Connection connection)
protected EventDetail	decodeEventDetailFromResultSet(ResultSet rs)
Collection<EventDetail>	findAllEvents(String... instanceIds)
Collection<EventDetail>	findAllEventsByPK(Collection<EventPK> eventPKs)
Collection<EventDetail>	findAllEventsInPeriod(org.silverpeas.date.Period period, String... instanceIds)
Collection<EventDetail>	findAllEventsInRange(String startDay, String endDay, String... almanachIds) Find all events that can occur in the specified range and for the specified almanachs.
EventDetail	findEventByPK(EventPK pk)
protected void	fixIncorrectDatesForAlreadyExistingEvent(EventDetail event)
protected Connection	openConnection()
void	removeEvent(Connection connection, EventPK pk)
void	updateEvent(EventDetail event)

Methods inherited from class java.lang.Object

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

Constructor Detail

EventDAO

public EventDAO()

Method Detail

updateEvent

public void updateEvent(EventDetail event)
                 throws SQLException,
                        Exception

Throws:

SQLException

Exception

addEvent

public String addEvent(Connection connection,
                       EventDetail event)
                throws SQLException,
                       Exception

Throws:

SQLException

Exception

removeEvent

public void removeEvent(Connection connection,
                        EventPK pk)
                 throws SQLException,
                        Exception

Throws:

SQLException

Exception

findAllEventsInRange

public Collection<EventDetail> findAllEventsInRange(String startDay,
                                                    String endDay,
                                                    String... almanachIds)
                                             throws SQLException,
                                                    Exception

Find all events that can occur in the specified range and for the specified almanachs.

Parameters:

startDay - the start date of the range. It has to be in the format yyyy/MM/dd.

endDay - the end date of the range. It has to be in the format yyyy/MM/dd. If the end date is null or empty, then there is no end date and all events from startDay are taken into account.

almanachIds - the identifiers of the almanachs.

Returns:

a collection of events that should occur in the specified range.

Throws:

SQLException - if an error occurs while executing the SQL request.

Exception - if an error occurs during the process of this method.

findAllEventsInPeriod

public Collection<EventDetail> findAllEventsInPeriod(org.silverpeas.date.Period period,
                                                     String... instanceIds)
                                              throws Exception

Throws:

Exception

findAllEvents

public Collection<EventDetail> findAllEvents(String... instanceIds)
                                      throws SQLException,
                                             Exception

Throws:

SQLException

Exception

findAllEventsByPK

public Collection<EventDetail> findAllEventsByPK(Collection<EventPK> eventPKs)
                                          throws SQLException,
                                                 Exception

Throws:

SQLException

Exception

findEventByPK

public EventDetail findEventByPK(EventPK pk)
                          throws SQLException,
                                 Exception

Throws:

SQLException

Exception

decodeEventDetailFromResultSet

protected EventDetail decodeEventDetailFromResultSet(ResultSet rs)
                                              throws Exception

Throws:

Exception

fixIncorrectDatesForAlreadyExistingEvent

protected void fixIncorrectDatesForAlreadyExistingEvent(EventDetail event)
                                                 throws Exception

Throws:

Exception

openConnection

protected Connection openConnection()
                             throws com.stratelia.webactiv.util.exception.UtilException

Throws:

com.stratelia.webactiv.util.exception.UtilException

closeConnection

protected void closeConnection(Connection connection)