com.stratelia.webactiv.util.questionContainer.ejb
Class QuestionContainerDAO

java.lang.Object
  com.stratelia.webactiv.util.questionContainer.ejb.QuestionContainerDAO

public class QuestionContainerDAO
extends Object

This class is made to access database only (table SB_QuestionContainer_QC and SB_QuestionContainer_Comment)

Author:

neysseri

Field Summary

static String	COMMENTCOLUMNNAMES
static String	QUESTIONCONTAINERCOLUMNNAMES

Constructor Summary

QuestionContainerDAO()

Method Summary

static void	addAVoter(Connection con, QuestionContainerPK questionContainerPK) Method declaration
static void	addComment(Connection con, Comment comment) Method declaration
static void	closeQuestionContainer(Connection con, QuestionContainerPK questionContainerPK) Method declaration
static QuestionContainerPK	createQuestionContainerHeader(Connection con, QuestionContainerHeader questionContainerHeader) Method declaration
static void	deleteComments(Connection con, QuestionContainerPK qcPK) Method declaration
static void	deleteQuestionContainerHeader(Connection con, QuestionContainerPK questionContainerPK) Method declaration
static Collection<QuestionContainerHeader>	getClosedQuestionContainers(Connection con, QuestionContainerPK questionContainerPK) Method declaration
static Collection<Comment>	getComments(Connection con, QuestionContainerPK qcPK) Method declaration
static Collection<QuestionContainerHeader>	getInWaitQuestionContainers(Connection con, QuestionContainerPK qcPK) Method declaration
static Collection<QuestionContainerHeader>	getNotClosedQuestionContainers(Connection con, QuestionContainerPK questionContainerPK) Method declaration
static Collection<QuestionContainerHeader>	getOpenedQuestionContainers(Connection con, QuestionContainerPK questionContainerPK) Method declaration
static QuestionContainerHeader	getQuestionContainerHeader(Connection con, QuestionContainerPK questionContainerPK) Method declaration
static Collection<QuestionContainerHeader>	getQuestionContainers(Connection con, List<QuestionContainerPK> pks)
static Collection<QuestionContainerHeader>	getQuestionContainers(Connection con, QuestionContainerPK questionContainerPK) Method declaration
static void	openQuestionContainer(Connection con, QuestionContainerPK questionContainerPK) Method declaration
static void	updateQuestionContainerHeader(Connection con, QuestionContainerHeader questionContainerHeader) Method declaration

Methods inherited from class java.lang.Object

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

Field Detail

QUESTIONCONTAINERCOLUMNNAMES

public static final String QUESTIONCONTAINERCOLUMNNAMES

See Also:

Constant Field Values

COMMENTCOLUMNNAMES

public static final String COMMENTCOLUMNNAMES

See Also:

Constant Field Values

Constructor Detail

QuestionContainerDAO

public QuestionContainerDAO()

Method Detail

getQuestionContainers

public static Collection<QuestionContainerHeader> getQuestionContainers(Connection con,
                                                                        QuestionContainerPK questionContainerPK)
                                                                 throws SQLException

Method declaration

Parameters:

con -

questionContainerPK -

Returns:

Throws:

SQLException

See Also:

getQuestionContainers

public static Collection<QuestionContainerHeader> getQuestionContainers(Connection con,
                                                                        List<QuestionContainerPK> pks)
                                                                 throws SQLException

Throws:

SQLException

getOpenedQuestionContainers

public static Collection<QuestionContainerHeader> getOpenedQuestionContainers(Connection con,
                                                                              QuestionContainerPK questionContainerPK)
                                                                       throws SQLException

Method declaration

Parameters:

con -

questionContainerPK -

Returns:

Throws:

SQLException

See Also:

getNotClosedQuestionContainers

public static Collection<QuestionContainerHeader> getNotClosedQuestionContainers(Connection con,
                                                                                 QuestionContainerPK questionContainerPK)
                                                                          throws SQLException

Method declaration

Parameters:

con -

questionContainerPK -

Returns:

Throws:

SQLException

See Also:

getClosedQuestionContainers

public static Collection<QuestionContainerHeader> getClosedQuestionContainers(Connection con,
                                                                              QuestionContainerPK questionContainerPK)
                                                                       throws SQLException

Method declaration

Parameters:

con -

questionContainerPK -

Returns:

Throws:

SQLException

See Also:

getInWaitQuestionContainers

public static Collection<QuestionContainerHeader> getInWaitQuestionContainers(Connection con,
                                                                              QuestionContainerPK qcPK)
                                                                       throws SQLException

Method declaration

Parameters:

con -

qcPK -

Returns:

Throws:

SQLException

See Also:

getQuestionContainerHeader

public static QuestionContainerHeader getQuestionContainerHeader(Connection con,
                                                                 QuestionContainerPK questionContainerPK)
                                                          throws SQLException

Method declaration

Parameters:

con -

questionContainerPK -

Returns:

Throws:

SQLException

See Also:

closeQuestionContainer

public static void closeQuestionContainer(Connection con,
                                          QuestionContainerPK questionContainerPK)
                                   throws SQLException

Method declaration

Parameters:

con -

questionContainerPK -

Throws:

SQLException

See Also:

openQuestionContainer

public static void openQuestionContainer(Connection con,
                                         QuestionContainerPK questionContainerPK)
                                  throws SQLException

Method declaration

Parameters:

con -

questionContainerPK -

Throws:

SQLException

See Also:

createQuestionContainerHeader

public static QuestionContainerPK createQuestionContainerHeader(Connection con,
                                                                QuestionContainerHeader questionContainerHeader)
                                                         throws SQLException

Method declaration

Parameters:

con -

questionContainerHeader -

Returns:

Throws:

SQLException

See Also:

updateQuestionContainerHeader

public static void updateQuestionContainerHeader(Connection con,
                                                 QuestionContainerHeader questionContainerHeader)
                                          throws SQLException

Method declaration

Parameters:

con -

questionContainerHeader -

Throws:

SQLException

See Also:

deleteQuestionContainerHeader

public static void deleteQuestionContainerHeader(Connection con,
                                                 QuestionContainerPK questionContainerPK)
                                          throws SQLException

Method declaration

Parameters:

con -

questionContainerPK -

Throws:

SQLException

See Also:

addAVoter

public static void addAVoter(Connection con,
                             QuestionContainerPK questionContainerPK)
                      throws SQLException

Method declaration

Parameters:

con -

questionContainerPK -

Throws:

SQLException

See Also:

addComment

public static void addComment(Connection con,
                              Comment comment)
                       throws SQLException

Method declaration

Parameters:

con -

comment -

Throws:

SQLException

See Also:

getComments

public static Collection<Comment> getComments(Connection con,
                                              QuestionContainerPK qcPK)
                                       throws SQLException

Method declaration

Parameters:

con -

qcPK -

Returns:

Throws:

SQLException

See Also:

deleteComments

public static void deleteComments(Connection con,
                                  QuestionContainerPK qcPK)
                           throws SQLException

Method declaration

Parameters:

con -

qcPK -

Throws:

SQLException

See Also: