egovframework.rfc3.question.dao
Class QuestionDAO

java.lang.Object
  extended by org.springframework.dao.support.DaoSupport
      extended by org.springframework.orm.ibatis.support.SqlMapClientDaoSupport
          extended by egovframework.rte.psl.dataaccess.EgovAbstractDAO
              extended by egovframework.rfc3.common.dao.RfcCMSAbstractDAO
                  extended by egovframework.rfc3.question.dao.QuestionDAO
All Implemented Interfaces:
org.springframework.beans.factory.InitializingBean

@Repository(value="QuestionDAO")
public class QuestionDAO
extends RfcCMSAbstractDAO


Constructor Summary
QuestionDAO()
           
 
Method Summary
 java.util.HashMap AnswersQuestionNum(QuestionUserInfoVO questionUserInfoVO)
           
 void deleteAnQuestion(AnQuestionVO anQuestionVO)
           
 void deleteAnQuestionItem(AnQuestionVO anQuestionVO)
           
 void deleteQuestion(QuestionVO questionVO)
           
 void deleteQuestionUserInfo(QuestionUserInfoVO questionUserInfoVO)
           
 void deleteQuestionUserResult(QuestionUserInfoVO questionUserInfoVO)
           
 AnQuestionVO getAnQuestion(AnQuestionVO anQuestionVO)
           
 QuestionVO getQuestion(QuestionVO questionVO)
           
 void insertAnQuestion(AnQuestionVO anQuestionVO)
           
 void insertAnQuestionItem(AnQuestionItemVO anQuestionItemVO)
           
 void insertQuestion(QuestionVO questionVO)
           
 void insertQuestionResult(QuestionResultVO questionResultVO)
           
 void insertQuestionUserInfo(QuestionUserInfoVO questionUserInfoVO)
           
 java.util.List<AnQuestionItemVO> selectAnQuestionItemList(AnQuestionVO anQuestionVO)
           
 java.util.List<AnQuestionVO> selectAnQuestionList(QuestionVO questionVO)
           
 java.util.List<QuestionUserInfoVO> selectQuestionEventLotList(QuestionUserInfoVO questionUserInfoVO)
           
 egovframework.rte.psl.dataaccess.util.EgovMap selectQuestionEventLotTotal(QuestionUserInfoVO questionUserInfoVO)
           
 java.util.List<QuestionVO> selectQuestionList(QuestionVO questionVO)
           
 int selectQuestionListTotal(QuestionVO questionVO)
           
 java.util.List<QuestionResultVO> selectQuestionResult(AnQuestionItemVO anQuestionItemVO)
           
 int selectQuestionResultCnt(AnQuestionItemVO anQuestionItemVO)
          설문 카운팅 문항전체 & 문항단일 카운팅
 java.util.List<QuestionUserInfoVO> selectQuestionUserInfoList(QuestionUserInfoVO questionUserInfoVO)
           
 int selectQuestionUserInfoListTotal(QuestionUserInfoVO questionUserInfoVO)
           
 java.util.List<QuestionResultVO> selectQuestionUserList(QuestionVO questionVO)
           
 java.util.List<QuestionResultVO> selectQuestionUserResult(QuestionUserInfoVO questionUserInfoVO)
           
 java.util.List<QuestionVO> selectQuestionWebList(QuestionVO questionVO)
           
 int selectQuestionWebListTotal(QuestionVO questionVO)
           
 java.util.List<QuestionResultVO> selectResultUserResult(AnQuestionItemVO anQuestionItemVO)
           
 QuestionResultVO selectResultUserResultExcel(QuestionResultVO questionResultVO)
           
 QuestionResultVO selectResultUserResultExcel2(QuestionResultVO questionResultVO)
           
 java.util.List<QuestionUserInfoVO> selectResultUserResultList(QuestionUserInfoVO questionUserInfoVO)
           
 void updateAnQuestion(AnQuestionVO anQuestionVO)
           
 void updateAnQuestionItem(AnQuestionItemVO anQuestionItemVO)
           
 void updateAnQuestionOrder(AnQuestionVO anQuestionVO)
           
 void updateQuestion(QuestionVO questionVO)
           
 void updateQuestionAnswerCount(QuestionVO questionVO)
           
 
Methods inherited from class egovframework.rfc3.common.dao.RfcCMSAbstractDAO
delete, desDecoding, desDecoding2, desDecodingList, desDecodingList2, desEncoding, desEncoding2, insert, list, listWithPaging, selectByPk, setSuperSqlMapClient, update
 
Methods inherited from class org.springframework.orm.ibatis.support.SqlMapClientDaoSupport
getDataSource, getSqlMapClient, getSqlMapClientTemplate, setDataSource, setSqlMapClient, setSqlMapClientTemplate
 
Methods inherited from class org.springframework.dao.support.DaoSupport
afterPropertiesSet
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

QuestionDAO

public QuestionDAO()
Method Detail

selectQuestionListTotal

public int selectQuestionListTotal(QuestionVO questionVO)
                            throws java.lang.Exception
Throws:
java.lang.Exception

selectQuestionList

public java.util.List<QuestionVO> selectQuestionList(QuestionVO questionVO)
                                              throws java.lang.Exception
Throws:
java.lang.Exception

insertQuestion

public void insertQuestion(QuestionVO questionVO)
                    throws java.lang.Exception
Throws:
java.lang.Exception

updateQuestion

public void updateQuestion(QuestionVO questionVO)
                    throws java.lang.Exception
Throws:
java.lang.Exception

updateQuestionAnswerCount

public void updateQuestionAnswerCount(QuestionVO questionVO)
                               throws java.lang.Exception
Throws:
java.lang.Exception

getQuestion

public QuestionVO getQuestion(QuestionVO questionVO)
                       throws java.lang.Exception
Throws:
java.lang.Exception

deleteQuestion

public void deleteQuestion(QuestionVO questionVO)
                    throws java.lang.Exception
Throws:
java.lang.Exception

selectAnQuestionList

public java.util.List<AnQuestionVO> selectAnQuestionList(QuestionVO questionVO)
                                                  throws java.lang.Exception
Throws:
java.lang.Exception

getAnQuestion

public AnQuestionVO getAnQuestion(AnQuestionVO anQuestionVO)
                           throws java.lang.Exception
Throws:
java.lang.Exception

insertAnQuestion

public void insertAnQuestion(AnQuestionVO anQuestionVO)
                      throws java.lang.Exception
Throws:
java.lang.Exception

updateAnQuestion

public void updateAnQuestion(AnQuestionVO anQuestionVO)
                      throws java.lang.Exception
Throws:
java.lang.Exception

updateAnQuestionOrder

public void updateAnQuestionOrder(AnQuestionVO anQuestionVO)
                           throws java.lang.Exception
Throws:
java.lang.Exception

deleteAnQuestion

public void deleteAnQuestion(AnQuestionVO anQuestionVO)
                      throws java.lang.Exception
Throws:
java.lang.Exception

selectAnQuestionItemList

public java.util.List<AnQuestionItemVO> selectAnQuestionItemList(AnQuestionVO anQuestionVO)
                                                          throws java.lang.Exception
Throws:
java.lang.Exception

insertAnQuestionItem

public void insertAnQuestionItem(AnQuestionItemVO anQuestionItemVO)
                          throws java.lang.Exception
Throws:
java.lang.Exception

updateAnQuestionItem

public void updateAnQuestionItem(AnQuestionItemVO anQuestionItemVO)
                          throws java.lang.Exception
Throws:
java.lang.Exception

deleteAnQuestionItem

public void deleteAnQuestionItem(AnQuestionVO anQuestionVO)
                          throws java.lang.Exception
Throws:
java.lang.Exception

selectQuestionWebListTotal

public int selectQuestionWebListTotal(QuestionVO questionVO)
                               throws java.lang.Exception
Throws:
java.lang.Exception

selectQuestionWebList

public java.util.List<QuestionVO> selectQuestionWebList(QuestionVO questionVO)
                                                 throws java.lang.Exception
Throws:
java.lang.Exception

insertQuestionResult

public void insertQuestionResult(QuestionResultVO questionResultVO)
                          throws java.lang.Exception
Throws:
java.lang.Exception

selectQuestionResult

public java.util.List<QuestionResultVO> selectQuestionResult(AnQuestionItemVO anQuestionItemVO)
                                                      throws java.lang.Exception
Throws:
java.lang.Exception

selectResultUserResult

public java.util.List<QuestionResultVO> selectResultUserResult(AnQuestionItemVO anQuestionItemVO)
                                                        throws java.lang.Exception
Throws:
java.lang.Exception

selectQuestionUserResult

public java.util.List<QuestionResultVO> selectQuestionUserResult(QuestionUserInfoVO questionUserInfoVO)
                                                          throws java.lang.Exception
Throws:
java.lang.Exception

selectQuestionUserInfoListTotal

public int selectQuestionUserInfoListTotal(QuestionUserInfoVO questionUserInfoVO)
                                    throws java.lang.Exception
Throws:
java.lang.Exception

selectQuestionUserInfoList

public java.util.List<QuestionUserInfoVO> selectQuestionUserInfoList(QuestionUserInfoVO questionUserInfoVO)
                                                              throws java.lang.Exception
Throws:
java.lang.Exception

selectQuestionEventLotList

public java.util.List<QuestionUserInfoVO> selectQuestionEventLotList(QuestionUserInfoVO questionUserInfoVO)
                                                              throws java.lang.Exception
Throws:
java.lang.Exception

selectQuestionEventLotTotal

public egovframework.rte.psl.dataaccess.util.EgovMap selectQuestionEventLotTotal(QuestionUserInfoVO questionUserInfoVO)
                                                                          throws java.lang.Exception
Throws:
java.lang.Exception

insertQuestionUserInfo

public void insertQuestionUserInfo(QuestionUserInfoVO questionUserInfoVO)
                            throws java.lang.Exception
Throws:
java.lang.Exception

selectQuestionUserList

public java.util.List<QuestionResultVO> selectQuestionUserList(QuestionVO questionVO)
                                                        throws java.lang.Exception
Throws:
java.lang.Exception

selectResultUserResultExcel

public QuestionResultVO selectResultUserResultExcel(QuestionResultVO questionResultVO)
                                             throws java.lang.Exception
Throws:
java.lang.Exception

selectResultUserResultExcel2

public QuestionResultVO selectResultUserResultExcel2(QuestionResultVO questionResultVO)
                                              throws java.lang.Exception
Throws:
java.lang.Exception

selectResultUserResultList

public java.util.List<QuestionUserInfoVO> selectResultUserResultList(QuestionUserInfoVO questionUserInfoVO)
                                                              throws java.lang.Exception
Throws:
java.lang.Exception

selectQuestionResultCnt

public int selectQuestionResultCnt(AnQuestionItemVO anQuestionItemVO)
설문 카운팅 문항전체 & 문항단일 카운팅


deleteQuestionUserInfo

public void deleteQuestionUserInfo(QuestionUserInfoVO questionUserInfoVO)
                            throws java.lang.Exception
Throws:
java.lang.Exception

deleteQuestionUserResult

public void deleteQuestionUserResult(QuestionUserInfoVO questionUserInfoVO)
                              throws java.lang.Exception
Throws:
java.lang.Exception

AnswersQuestionNum

public java.util.HashMap AnswersQuestionNum(QuestionUserInfoVO questionUserInfoVO)
                                     throws java.lang.Exception
Throws:
java.lang.Exception