Package org.silverpeas.core.questioncontainer.result.dao

Class QuestionResultDAO

java.lang.Object

org.silverpeas.core.questioncontainer.result.dao.QuestionResultDAO

public class QuestionResultDAO
extends Object

This class is made to access database only (table SB_Question_Answer)

Author:

neysseri

Field Summary

Fields

Modifier and Type	Field	Description
static String	QUESTIONRESULTCOLUMNNAMES

Method Summary

Modifier and Type	Method	Description
static void	deleteQuestionResultToQuestion(Connection con, ResourceReference questionPK)
static Collection<QuestionResult>	getQuestionResultToQuestion(Connection con, ResourceReference questionPK)
static Collection<QuestionResult>	getQuestionResultToQuestionByParticipation(Connection con, ResourceReference questionPK, int participationId)
static Results	getResults(Connection con, List<ResourceReference> pks)
static QuestionResult	getUserAnswerToQuestion(Connection con, String userId, ResourceReference questionPK, AnswerPK answerPK)
static Collection<QuestionResult>	getUserQuestionResultsToQuestion(Connection con, String userId, ResourceReference questionPK)
static Collection<QuestionResult>	getUserQuestionResultsToQuestionByParticipation(Connection con, String userId, ResourceReference questionPK, int participationId)
static Collection<String>	getUsersByAnswer(Connection con, String answerId)
static void	setDeleteAllQuestionResultsByInstanceId(Connection con, String instanceId)
static void	setQuestionResultToUser(Connection con, QuestionResult result)

Methods inherited from class java.lang.Object

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

Field Detail

QUESTIONRESULTCOLUMNNAMES

public static final String QUESTIONRESULTCOLUMNNAMES

See Also:

Constant Field Values

Method Detail

getUserQuestionResultsToQuestion

public static Collection<QuestionResult> getUserQuestionResultsToQuestion(Connection con,
                                                                          String userId,
                                                                          ResourceReference questionPK)
                                                                   throws SQLException

Throws:

SQLException

getUsersByAnswer

public static Collection<String> getUsersByAnswer(Connection con,
                                                  String answerId)
                                           throws SQLException

Throws:

SQLException

getUserQuestionResultsToQuestionByParticipation

public static Collection<QuestionResult> getUserQuestionResultsToQuestionByParticipation(Connection con,
                                                                                         String userId,
                                                                                         ResourceReference questionPK,
                                                                                         int participationId)
                                                                                  throws SQLException

Throws:

SQLException

getQuestionResultToQuestion

public static Collection<QuestionResult> getQuestionResultToQuestion(Connection con,
                                                                     ResourceReference questionPK)
                                                              throws SQLException

Throws:

SQLException

getQuestionResultToQuestionByParticipation

public static Collection<QuestionResult> getQuestionResultToQuestionByParticipation(Connection con,
                                                                                    ResourceReference questionPK,
                                                                                    int participationId)
                                                                             throws SQLException

Throws:

SQLException

setQuestionResultToUser

public static void setQuestionResultToUser(Connection con,
                                           QuestionResult result)
                                    throws SQLException

Throws:

SQLException

deleteQuestionResultToQuestion

public static void deleteQuestionResultToQuestion(Connection con,
                                                  ResourceReference questionPK)
                                           throws SQLException

Throws:

SQLException

setDeleteAllQuestionResultsByInstanceId

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

Throws:

SQLException

getUserAnswerToQuestion

public static QuestionResult getUserAnswerToQuestion(Connection con,
                                                     String userId,
                                                     ResourceReference questionPK,
                                                     AnswerPK answerPK)
                                              throws SQLException

Throws:

SQLException

getResults

public static Results getResults(Connection con,
                                 List<ResourceReference> pks)
                          throws SQLException

Throws:

SQLException