com.stratelia.webactiv.calendar.model
Class ToDoDAO

java.lang.Object
  com.stratelia.webactiv.calendar.model.ToDoDAO

public class ToDoDAO
extends Object

Field Summary

static String

COLUMNNAMES

Constructor Summary

ToDoDAO()

Method Summary

static String	addToDo(Connection con, ToDoHeader toDo)
static List<String>	getAllTodoByUser(Connection con, String userId)
static Collection<ToDoHeader>	getClosedToDoHeaders(Connection con, String organizerId)
static Collection<ToDoHeader>	getNotCompletedToDoHeadersForUser(Connection con, String userId)
static Collection<ToDoHeader>	getOrganizerToDoHeaders(Connection con, String organizerId)
static ToDoHeader	getToDoHeader(Connection con, String toDoId)
static ToDoHeader	getToDoHeaderFromResultSet(ResultSet rs)
static Collection<ToDoHeader>	getToDoHeadersByExternalId(Connection con, String spaceId, String componentId, String externalId)
static Collection<ToDoHeader>	getToDoHeadersByInstanceId(Connection con, String componentId)
static void	removeToDo(Connection con, String id)
static void	removeToDoByInstanceId(Connection con, String instanceId)
static void	updateToDo(Connection con, ToDoHeader toDo)

Methods inherited from class java.lang.Object

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

Field Detail

COLUMNNAMES

public static final String COLUMNNAMES

See Also:

Constant Field Values

Constructor Detail

ToDoDAO

public ToDoDAO()

Method Detail

addToDo

public static String addToDo(Connection con,
                             ToDoHeader toDo)
                      throws SQLException,
                             UtilException

Throws:

SQLException

UtilException

updateToDo

public static void updateToDo(Connection con,
                              ToDoHeader toDo)
                       throws SQLException

Throws:

SQLException

removeToDo

public static void removeToDo(Connection con,
                              String id)
                       throws SQLException

Throws:

SQLException

removeToDoByInstanceId

public static void removeToDoByInstanceId(Connection con,
                                          String instanceId)
                                   throws SQLException

Throws:

SQLException

getNotCompletedToDoHeadersForUser

public static Collection<ToDoHeader> getNotCompletedToDoHeadersForUser(Connection con,
                                                                       String userId)
                                                                throws SQLException,
                                                                       CalendarException

Throws:

SQLException

CalendarException

getOrganizerToDoHeaders

public static Collection<ToDoHeader> getOrganizerToDoHeaders(Connection con,
                                                             String organizerId)
                                                      throws SQLException,
                                                             CalendarException

Throws:

SQLException

CalendarException

getClosedToDoHeaders

public static Collection<ToDoHeader> getClosedToDoHeaders(Connection con,
                                                          String organizerId)
                                                   throws SQLException,
                                                          CalendarException

Throws:

SQLException

CalendarException

getToDoHeadersByExternalId

public static Collection<ToDoHeader> getToDoHeadersByExternalId(Connection con,
                                                                String spaceId,
                                                                String componentId,
                                                                String externalId)
                                                         throws SQLException,
                                                                CalendarException

Throws:

SQLException

CalendarException

getToDoHeadersByInstanceId

public static Collection<ToDoHeader> getToDoHeadersByInstanceId(Connection con,
                                                                String componentId)
                                                         throws SQLException,
                                                                CalendarException

Parameters:

con -

componentId -

Returns:

Throws:

SQLException

CalendarException

getToDoHeaderFromResultSet

public static ToDoHeader getToDoHeaderFromResultSet(ResultSet rs)
                                             throws SQLException,
                                                    CalendarException

Throws:

SQLException

CalendarException

getToDoHeader

public static ToDoHeader getToDoHeader(Connection con,
                                       String toDoId)
                                throws SQLException,
                                       CalendarException

Throws:

SQLException

CalendarException

getAllTodoByUser

public static List<String> getAllTodoByUser(Connection con,
                                            String userId)
                                     throws SQLException

Throws:

SQLException