Package org.silverpeas.core.personalorganizer.service

Class CategoryDAO

java.lang.Object

org.silverpeas.core.personalorganizer.service.CategoryDAO

public class CategoryDAO
extends Object

Field Summary

Fields

Modifier and Type	Field	Description
static String	CATEGORYCOLUMNNAMES

Constructor Summary

Constructors

Constructor	Description
CategoryDAO()

Method Summary

Modifier and Type	Method	Description
static void	addJournalCategory(Connection con, String journalId, String categoryId)
static Collection<Category>	getAllCategories(Connection con)
static Category	getCategory(Connection con, String categoryId)
static Category	getCategoryFromResultSet(ResultSet rs)
static Collection<Category>	getJournalCategories(Connection con, String journalId)
static void	removeJournal(Connection con, String id)
static void	removeJournalCategory(Connection con, String journalId, String categoryId)

Methods inherited from class java.lang.Object

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

Field Detail

CATEGORYCOLUMNNAMES

public static final String CATEGORYCOLUMNNAMES

See Also:

Constant Field Values

Constructor Detail

CategoryDAO

public CategoryDAO()

Method Detail

getCategoryFromResultSet

public static Category getCategoryFromResultSet(ResultSet rs)
                                         throws SQLException

Throws:

SQLException

getJournalCategories

public static Collection<Category> getJournalCategories(Connection con,
                                                        String journalId)
                                                 throws SQLException

Throws:

SQLException

getCategory

public static Category getCategory(Connection con,
                                   String categoryId)
                            throws SQLException

Throws:

SQLException

getAllCategories

public static Collection<Category> getAllCategories(Connection con)
                                             throws SQLException

Throws:

SQLException

addJournalCategory

public static void addJournalCategory(Connection con,
                                      String journalId,
                                      String categoryId)
                               throws SQLException

Throws:

SQLException

removeJournalCategory

public static void removeJournalCategory(Connection con,
                                         String journalId,
                                         String categoryId)
                                  throws SQLException

Throws:

SQLException

removeJournal

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

Throws:

SQLException