egovframework.rfc3.question.dao
Class QuestionDAO
java.lang.Object
org.springframework.dao.support.DaoSupport
org.springframework.orm.ibatis.support.SqlMapClientDaoSupport
egovframework.rte.psl.dataaccess.EgovAbstractDAO
egovframework.rfc3.common.dao.RfcCMSAbstractDAO
egovframework.rfc3.question.dao.QuestionDAO
- All Implemented Interfaces:
- org.springframework.beans.factory.InitializingBean
@Repository(value="QuestionDAO")
public class QuestionDAO
- extends RfcCMSAbstractDAO
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 |
QuestionDAO
public QuestionDAO()
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