com.stratelia.webactiv.util.questionResult.ejb
Class QuestionResultDAO

java.lang.Object
  com.stratelia.webactiv.util.questionResult.ejb.QuestionResultDAO

public class QuestionResultDAO
extends Object

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

Author:

neysseri

Field Summary

static String

QUESTIONRESULTCOLUMNNAMES

Constructor Summary

QuestionResultDAO()

Method Summary

static void	deleteQuestionResultToQuestion(Connection con, ForeignPK questionPK)
static Collection<QuestionResult>	getQuestionResultToQuestion(Connection con, ForeignPK questionPK)
static Collection<QuestionResult>	getQuestionResultToQuestionByParticipation(Connection con, ForeignPK questionPK, int participationId)
static QuestionResult	getUserAnswerToQuestion(Connection con, String userId, ForeignPK questionPK, AnswerPK answerPK)
static Collection<QuestionResult>	getUserQuestionResultsToQuestion(Connection con, String userId, ForeignPK questionPK)
static Collection<QuestionResult>	getUserQuestionResultsToQuestionByParticipation(Connection con, String userId, ForeignPK questionPK, int participationId)
static Collection<String>	getUsersByAnswer(Connection con, String answerId)
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

Constructor Detail

QuestionResultDAO

public QuestionResultDAO()

Method Detail

getUserQuestionResultsToQuestion

public static Collection<QuestionResult> getUserQuestionResultsToQuestion(Connection con,
                                                                          String userId,
                                                                          ForeignPK 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,
                                                                                         ForeignPK questionPK,
                                                                                         int participationId)
                                                                                  throws SQLException

Throws:

SQLException

getQuestionResultToQuestion

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

Throws:

SQLException

getQuestionResultToQuestionByParticipation

public static Collection<QuestionResult> getQuestionResultToQuestionByParticipation(Connection con,
                                                                                    ForeignPK 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,
                                                  ForeignPK questionPK)
                                           throws SQLException

Throws:

SQLException

getUserAnswerToQuestion

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

Throws:

SQLException