egovframework.rfc3.contents.dao
Class ContentsDAO

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.contents.dao.ContentsDAO

All Implemented Interfaces:

org.springframework.beans.factory.InitializingBean

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

Constructor Summary

ContentsDAO()

Method Summary

ContentsVO	ContentstBackUoVO(ContentsVO contentsVO) 컨텐츠 삭제시 BackUp 데이터 VO
ContentsVO	contentstVO(ContentsVO contentsVO) indexAction 관련 정보
int	deleteAllContentsToDomain(java.lang.String domainId) 도메인에 해당한는 컨텐츠 전부 삭제
int	deleteContents(ContentsVO contentsVO) 콘텐츠 삭제
java.util.List<ContentsVO>	domainCopyContentstList(ContentsVO contentsVO) 도메인 복사 콘텐츠 리스트
java.util.List<MenuGradeVO>	getSurveyList(MenuGradeVO menuGradeVO) 만족도 리스트
java.util.List<MenuGradeVO>	getSurveyTotalList(MenuGradeVO menuGradeVO) 만족도 카운팅 리스트
int	insertContentsBackUptList(ContentsBackUpVO contentsBackUpVO) Contents BackIUp insert
int	insertContentstList(ContentsVO contentsVO) 콘텐츠 insert
int	selectContentsBackUpPkCnt(ContentsVO contentsVO) 백업 삭제 데이터 복구중 중복값 체크
int	selectContentsBackUpTotCnt(ContentsBackUpVO contentsBackUpVO) Contents BackIUp List Count
int	selectContentsMainCnt(ContentsVO contentsVO) 콘텐츠 메인 중복 카운팅
java.util.List<ContentsBackUpVO>	selectContentstBackUpList(ContentsBackUpVO contentsBackUpVO) Contents BackIUp List
ContentsBackUpVO	selectContentstBackUpVo(ContentsBackUpVO contentsBackUpVO) 복원 백업VO
java.util.List<ContentsVO>	selectContentstList(ContentsVO contentsVO) 콘텐츠 리스트
int	selectContentsTotCnt(ContentsVO contentsVO) 콘텐츠 리스트 카운터
int	selectContentsUpdeteMainCnt(ContentsVO contentsVO) 콘텐츠 수정시 메인 중복 카운팅
int	updateBackupContents(ContentsBackUpVO contentsBackUpVO) 복원후 복원일 업데이트
int	updateContentLinkDate(ContentsVO contentsVO) 컨텐츠 수정시 해당 컨텐츠 링크 수정일 수정
int	updateContents(ContentsVO contentsVO) 콘텐츠 수정
ContentsBackUpVO	viewContentstBackupList(ContentsBackUpVO contentsBackUpVO) 백업컨텐츠 보기
ContentsVO	viewContentstList(ContentsVO contentsVO) 콘텐츠 수정폼

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

ContentsDAO

public ContentsDAO()

Method Detail

selectContentsTotCnt

public int selectContentsTotCnt(ContentsVO contentsVO)
                         throws java.lang.Exception

콘텐츠 리스트 카운터

Parameters:

contentsVO -

Returns:

Throws:

java.lang.Exception

selectContentstList

public java.util.List<ContentsVO> selectContentstList(ContentsVO contentsVO)
                                               throws java.lang.Exception

콘텐츠 리스트

Parameters:

contentsVO -

Returns:

Throws:

java.lang.Exception

insertContentstList

public int insertContentstList(ContentsVO contentsVO)
                        throws java.lang.Exception

콘텐츠 insert

Parameters:

contentsVO -

Returns:

Throws:

java.lang.Exception

viewContentstList

public ContentsVO viewContentstList(ContentsVO contentsVO)
                             throws java.lang.Exception

콘텐츠 수정폼

Parameters:

contentsVO -

Returns:

Throws:

java.lang.Exception

domainCopyContentstList

public java.util.List<ContentsVO> domainCopyContentstList(ContentsVO contentsVO)
                                                   throws java.lang.Exception

도메인 복사 콘텐츠 리스트

Parameters:

contentsVO -

Returns:

Throws:

java.lang.Exception

deleteContents

public int deleteContents(ContentsVO contentsVO)
                   throws java.lang.Exception

콘텐츠 삭제

Parameters:

contentsVO -

Returns:

Throws:

java.lang.Exception

deleteAllContentsToDomain

public int deleteAllContentsToDomain(java.lang.String domainId)
                              throws java.lang.Exception

도메인에 해당한는 컨텐츠 전부 삭제

Parameters:

domainId -

Returns:

Throws:

java.lang.Exception

updateContents

public int updateContents(ContentsVO contentsVO)
                   throws java.lang.Exception

콘텐츠 수정

Parameters:

contentsVO -

Returns:

Throws:

java.lang.Exception

updateContentLinkDate

public int updateContentLinkDate(ContentsVO contentsVO)
                          throws java.lang.Exception

컨텐츠 수정시 해당 컨텐츠 링크 수정일 수정

Parameters:

contentsVO -

Returns:

Throws:

java.lang.Exception

contentstVO

public ContentsVO contentstVO(ContentsVO contentsVO)
                       throws java.lang.Exception

indexAction 관련 정보

Parameters:

contentsVO -

Returns:

Throws:

java.lang.Exception

selectContentsMainCnt

public int selectContentsMainCnt(ContentsVO contentsVO)
                          throws java.lang.Exception

콘텐츠 메인 중복 카운팅

Throws:

java.lang.Exception

selectContentsUpdeteMainCnt

public int selectContentsUpdeteMainCnt(ContentsVO contentsVO)
                                throws java.lang.Exception

콘텐츠 수정시 메인 중복 카운팅

Throws:

java.lang.Exception

ContentstBackUoVO

public ContentsVO ContentstBackUoVO(ContentsVO contentsVO)
                             throws java.lang.Exception

컨텐츠 삭제시 BackUp 데이터 VO

Parameters:

contentsVO -

Returns:

Throws:

java.lang.Exception

selectContentsBackUpTotCnt

public int selectContentsBackUpTotCnt(ContentsBackUpVO contentsBackUpVO)
                               throws java.lang.Exception

Contents BackIUp List Count

Parameters:

contentsBackUpVO -

Returns:

Throws:

java.lang.Exception

selectContentstBackUpList

public java.util.List<ContentsBackUpVO> selectContentstBackUpList(ContentsBackUpVO contentsBackUpVO)
                                                           throws java.lang.Exception

Contents BackIUp List

Parameters:

contentsBackUpVO -

Returns:

Throws:

java.lang.Exception

insertContentsBackUptList

public int insertContentsBackUptList(ContentsBackUpVO contentsBackUpVO)
                              throws java.lang.Exception

Contents BackIUp insert

Parameters:

contentsBackUpVO -

Returns:

Throws:

java.lang.Exception

selectContentstBackUpVo

public ContentsBackUpVO selectContentstBackUpVo(ContentsBackUpVO contentsBackUpVO)
                                         throws java.lang.Exception

복원 백업VO

Parameters:

contentsBackUpVO -

Returns:

Throws:

java.lang.Exception

updateBackupContents

public int updateBackupContents(ContentsBackUpVO contentsBackUpVO)
                         throws java.lang.Exception

복원후 복원일 업데이트

Throws:

java.lang.Exception

viewContentstBackupList

public ContentsBackUpVO viewContentstBackupList(ContentsBackUpVO contentsBackUpVO)
                                         throws java.lang.Exception

백업컨텐츠 보기

Parameters:

contentsBackUpVO -

Returns:

Throws:

java.lang.Exception

selectContentsBackUpPkCnt

public int selectContentsBackUpPkCnt(ContentsVO contentsVO)
                              throws java.lang.Exception

백업 삭제 데이터 복구중 중복값 체크

Parameters:

contentsBackUpVO -

Returns:

Throws:

java.lang.Exception

getSurveyList

public java.util.List<MenuGradeVO> getSurveyList(MenuGradeVO menuGradeVO)
                                          throws java.lang.Exception

만족도 리스트

Parameters:

menuGradeVO -

Returns:

menuCd,count

Throws:

java.lang.Exception

getSurveyTotalList

public java.util.List<MenuGradeVO> getSurveyTotalList(MenuGradeVO menuGradeVO)
                                               throws java.lang.Exception

만족도 카운팅 리스트

Parameters:

menuGradeVO -

Returns:

Throws:

java.lang.Exception