egovframework.rfc3.board.dao
Class BoardDAO

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.board.dao.BoardDAO

All Implemented Interfaces:

org.springframework.beans.factory.InitializingBean

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

도메인 대한 DAO 클래스를 정의한다.

Since:

2010.12.21

Version:

egovframework RFC 3.0

Author:

개발팀 허성철

See Also:

 << 개정이력(Modification Information) >>
   
   수정일      수정자           수정내용
  -------    --------    ---------------------------
   2010.12.21  허성철          최초 생성

 Copyright (C) 2010 by skoinfo  All right reserved.
 

Constructor Summary

BoardDAO()

Method Summary

java.util.List<BoardCountVO>	boardDataCount(BoardSearchVO boardSearchVO)
java.util.List<BoardCountVO>	boardOfficeCount(BoardSearchVO boardSearchVO)
void	deleteBoardAction(BoardActionVO boardActionVO)
void	deleteBoardCategory(BoardCategoryVO boardCategoryVO)
void	deleteBoardData(BoardDataVO boardDataVO) 게시판 삭제 상태 변경
void	deleteBoardDataBak(BoardVO boardVO)
void	deleteBoardDataLike(BoardDataLikeVO boardDataLikeVO)
void	deleteBoardExtension(BoardExtensionVO boardExtensionVO)
void	deleteBoardFile(BoardFileVO boardFileVO)
void	deleteBoardInfo(BoardVO boardVO) 게시판 삭제 플래그 삭제로 변경
void	deleteBoardReplyOffice(BoardReplyVO boardReplyVO)
void	deleteComment(CommentVO commentVO)
void	deleteDataCommentManager(BoardVO boardVO)
void	deleteDataExtManager(BoardVO boardVO)
void	deleteDataFileManager(BoardVO boardVO)
void	deleteDataListManager(BoardVO boardVO)
void	deleteRealBoardData(BoardDataVO boardDataVO)
void	deleteSkin(BoardSkinVO boardSkinVO)
void	deleteSkinEtc(BoardSkinVO boardSkinVO)
void	deleteUserBoardData(BoardDataVO boardDataVO) 게시판 삭제 상태 변경
BoardActionVO	getBoardAction(BoardActionVO boardActionVO)
BoardVO	getBoardBasic(BoardVO boardVO) 게시판 기본정보
BoardVO	getBoardBasicInfo(BoardVO boardVO)
BoardVO	getBoardBasicInfoId(BoardVO boardVO)
BoardCategoryVO	getBoardCategory(BoardCategoryVO boardCategoryVO)
int	getBoardCommentAllCnt(BoardSearchVO boardSearchVO) 만족도 전체리스트 년 월 일 카운트
int	getBoardCommentIdx(BoardSearchVO boardSearchVO)
BoardDataVO	getBoardData(BoardDataVO boardDataVO)
BoardDataVO	getBoardDataBak(BoardDataVO boardDataVO) 삭제 게시물 정보 추출
java.util.List<BoardDataVO>	getBoardDataBakList(BoardVO boardVO)
int	getBoardDataIdx(BoardVO boardVO)
BoardEtcVO	getBoardEtc(BoardEtcVO boardEtcVO) 게시판 기타정보
BoardFileVO	getBoardFile(BoardFileVO boardFileVO)
BoardVO	getBoardItem(BoardVO boardVO) 게시판 항목관련 DAO 영역
java.util.List<MenuVO>	getBoardMenuList(BoardSearchVO boardSearchVO)
BoardDataVO	getBoardRecentlyPosted(BoardDataVO boardDataVO) 관리자 게시판목록 게시판에 따른 최근게시일
BoardReplyVO	getBoardReplyOffice(BoardReplyVO boardReplyVO)
BoardSkinVO	getBoardSkin(BoardSkinVO boardSkinVO)
BoardSkinHistoryVO	getBoardSkinBackup(BoardSkinHistoryVO boardSkinHistoryVO)
BoardSkinEtcVO	getBoardSkinEtc(BoardSkinEtcVO boardSkinEtcVO)
BoardSkinVO	getBoardSkinId(BoardSkinVO boardSkinVO)
CommentVO	getComment(CommentVO commentVO)
int	getCommentCnt(CommentVO commentVO)
java.util.List<CommentVO>	getCommentListAll(BoardSearchVO boardSearchVO) 만족도 전체리스트 년 월 일 검색 ALL
java.util.List<CommentVO>	getCommentListAllPage(BoardSearchVO boardSearchVO) 만족도 전체리스트 년 월 일 검색
java.lang.String	getDataContent(BoardDataVO boardDataVO)
BoardExtensionVO	getDefaultField(BoardExtensionVO boardExtensionVO)
java.util.List<BoardFileVO>	getMultiFileList(BoardVO boardVO)
int	getStarPoint(BoardSearchVO boardSearchVO)
void	initBoardSkinBackup(BoardSkinHistoryVO boardSkinHistoryVO)
void	insertBoardAction(BoardActionVO boardActionVO)
void	insertBoardCategory(BoardCategoryVO boardCategoryVO)
void	insertBoardData(BoardDataVO boardDataVO)
void	insertBoardDataBackup(BoardDataVO boardDataVO) 삭제 게시물 등록
void	insertBoardDataLike(BoardDataLikeVO boardDataLikeVO) 게시판글 좋아요,싫어요,찬성,반대
void	insertBoardEtc(BoardEtcVO boardEtcVO)
void	insertBoardExtension(BoardExtensionVO boardExtensionVO)
void	insertBoardFile(BoardFileVO boardFileVO)
void	insertBoardHistory(BoardHistoryVO boardHistoryVO)
void	insertBoardInfo(BoardVO boardVO) 게시판 등록
void	insertBoardInfoAll(BoardVO boardVO)
void	insertBoardReplyOffice(BoardReplyVO boardReplyVO)
void	insertBoardSkin(BoardSkinVO boardSkinVO)
void	insertBoardSkinBackup(BoardSkinHistoryVO boardSkinHistoryVO)
void	insertBoardSkinEtc(BoardSkinEtcVO boardSkinEtcVO)
void	insertComment(CommentVO commentVO)
void	insertCommentDataLike(CommentLikeVO commentLikeVO) 게시판 댓글에 공감 비공감
void	insertDownloadHistory(DownloadHistoryVO downloadHistoryVO)
void	insertExtensionData(BoardExtensionDataVO boardExtensionDataVO)
java.util.List<BoardReplyVO>	listBoardReplyOffice(BoardReplyVO boardReplyVO) 담당부서 설정
int	passwordValidate(BoardSearchVO boardSearchVO)
void	restoreBoardDataBak(BoardVO boardVO) 삭제 게시물 복구일자 설정
java.util.List<BoardDataVO>	selectBackupHistoryList(BoardDataVO boardDataVO)
int	selectBackupHistoryTotal(BoardDataVO boardDataVO)
int	selectBoardActionCount(BoardActionVO boardActionVO)
java.util.List<BoardActionVO>	selectBoardActionList(BoardActionVO boardActionVO)
java.util.List<BoardActionVO>	selectBoardActionListAll(BoardActionVO boardActionVO)
int	selectBoardActionTotal(BoardActionVO boardActionVO)
java.util.List<BoardVO>	selectBoardAllList(BoardVO boardVO)
java.util.List<BoardCategoryVO>	selectBoardCategory(BoardCategoryVO boardCategoryVO) 게시판 카테고리 관련 DAO 영역
int	selectBoardCategoryCount(BoardCategoryVO boardCategoryVO)
int	selectBoardCommentLikeCnt(CommentLikeVO commentLikeVO)
java.util.List<BoardDataVO>	selectBoardDataBackupList(BoardVO boardVO) 삭제 게시물 목록
int	selectBoardDataBackupTotal(BoardVO boardVO) 삭제 게시물 총 갯수
int	selectBoardDataLikeCnt(BoardDataLikeVO boardDataLikeVO)
java.util.List<BoardDataLikeVO>	selectBoardDataLikeList(BoardDataLikeVO boardDataLikeVO)
java.util.List<BoardDataVO>	selectBoardDataList(BoardSearchVO boardSearchVO) 일반 게시물 검색
int	selectBoardDataListTotal(BoardSearchVO boardSearchVO)
java.util.List<BoardDataVO>	selectBoardDataManagerList(BoardVO boardVO)
java.util.List<BoardDataVO>	selectBoardDataManagerStandbyList(BoardVO boardVO) 게시물 관리 대기 목록
int	selectBoardDataManagerStandbyListCnt(BoardVO boardVO) 게시물 관리 대기 목록수
int	selectBoardDataManagerTotal(BoardVO boardVO)
java.util.List<BoardDataVO>	selectBoardDataOriginal(BoardDataVO boardDataVO)
int	selectBoardDataReplyCnt(BoardDataVO boardDataVO)
int	selectBoardDataReplyCount(BoardDataVO boardDataVO)
java.util.List<BoardDataVO>	selectBoardDataReplyList(BoardDataVO boardDataVO)
int	selectBoardExtensionDataCount(BoardExtensionDataVO boardExtensionDataVO)
java.util.List<BoardExtensionDataVO>	selectBoardExtensionDataList(BoardDataVO boardDataVO)
java.util.List<BoardFileVO>	selectBoardFile(BoardDataVO boardDataVO)
java.util.List<BoardHistoryVO>	selectBoardHistoryList(BoardHistoryVO boardHistoryVO)
int	selectBoardHistoryListTotal(BoardHistoryVO boardHistoryVO)
int	selectBoardIdCount(BoardVO boardVO) 게시판 중복확인
int	selectBoardIdEtcCount(BoardVO boardVO) 게시판 기타정보 중복확인
java.util.List<BoardVO>	selectBoardList(BoardVO boardVO) 게시판 리스트
int	selectBoardListTotal(BoardSkinVO boardSkinVO) 게시판스킨관련 DAO 영역
int	selectBoardListTotal(BoardVO boardVO) 게시판 전체 갯수
java.util.List<BoardDataVO>	selectBoardNoticeDataList(BoardSearchVO boardSearchVO) 공지글 목록 검색
java.util.List<BoardReplyVO>	selectBoardReplyOfficeList(BoardReplyVO boardReplyVO) 게시물 답변부서 정보를 불러온다.
java.util.List<BoardSkinVO>	selectBoardSkinAllList(BoardSkinVO boardSkinVO)
BoardSkinVO	selectBoardSkinArea(BoardSkinVO boardSkinVO)
java.util.List<BoardSkinHistoryVO>	selectBoardSkinBackup(BoardSkinHistoryVO boardSkinHistoryVO)
int	selectBoardSkinEtcCount(BoardSkinEtcVO boardSkinEtcVO)
int	selectBoardSkinIdCount(BoardSkinVO boardSkinVO)
java.util.List<BoardSkinVO>	selectBoardSkinList(BoardSkinVO boardSkinVO)
int	selectCommentCount(BoardSearchVO boardSearchVO)
java.util.List<CommentVO>	selectCommentList(BoardSearchVO boardSearchVO)
java.util.List<CommentVO>	selectCommentListAll(BoardDataVO boardDataVO)
java.util.List<BoardExtensionVO>	selectDefaultField()
int	selectDownloadHistoryTotal(DownloadHistoryVO downloadHistoryVO)
java.util.List<BoardExtensionVO>	selectExtensionField(BoardExtensionVO boardExtensionVO)
int	selectExtensionFieldCount(BoardExtensionVO boardExtensionVO) 게시판 필드관련 DAO 영역
java.util.List<BoardExtensionVO>	selectExtensionFieldUse(BoardExtensionVO boardExtensionVO)
java.util.List<BoardExtensionVO>	selectFieldValidator(BoardExtensionVO boardExtensionVO)
java.util.List<BoardDataVO>	selectNoticeUpdateDataList(BoardSearchVO boardSearchVO) 공지 지난글 목록 검색
java.util.List<BoardDataVO>	selectPeriodUpdateDataList(BoardSearchVO boardSearchVO)
java.util.List<BoardDataVO>	selectScheduleDataList(BoardSearchVO boardSearchVO)
int	selectScheduleDataListTotal(BoardSearchVO boardSearchVO)
java.util.List<BoardDataVO>	selectStandByDataList(BoardSearchVO boardSearchVO) 승인대기 게시물 목록
void	updateBoardAction(BoardActionVO boardActionVO)
void	updateBoardCategory(BoardCategoryVO boardCategoryVO)
void	updateBoardData(BoardDataVO boardDataVO)
void	updateBoardDataAnswerStatus(BoardDataVO boardDataVO)
void	updateBoardDataReplyNotice(BoardDataVO boardDataVO)
void	updateBoardDataStatus(BoardDataVO boardDataVO) 게시물 차단 상태 변경
void	updateBoardEtc(BoardEtcVO boardEtcVO) 게시판 기타정보 수정
void	updateBoardExtension(BoardExtensionVO boardExtensionVO)
void	updateBoardFile(BoardFileVO boardFileVO)
void	updateBoardFileId(BoardFileVO boardFileVO)
void	updateBoardInfo(BoardVO boardVO) 게시판 수정
void	updateBoardItemList(BoardVO boardVO)
void	updateBoardItemView(BoardVO boardVO)
void	updateBoardItemWrite(BoardVO boardVO)
void	updateBoardReplyOffice(BoardReplyVO boardReplyVO)
void	updateBoardSkin(BoardSkinVO boardSkinVO)
void	updateBoardSkinArea(BoardSkinVO boardSkinVO)
void	updateBoardSkinBackup(BoardSkinHistoryVO boardSkinHistoryVO)
void	updateBoardSkinEtc(BoardSkinEtcVO boardSkinEtcVO)
void	updateBoardSkinList(BoardSkinVO boardSkinVO)
void	updateBoardSkinPublic(BoardSkinVO boardSkinVO)
void	updateBoardSkinView(BoardSkinVO boardSkinVO)
void	updateBoardSkinWrite(BoardSkinVO boardSkinVO)
void	updateCommentReplyOrder(CommentVO commentVO)
void	updateDataRegisterDt(BoardDataVO boardDataVO)
void	updateDataReplyOrder(BoardDataVO boardDataVO)
void	updateDataStarPoint(BoardDataVO boardDataVO)
void	updateDataTmpField(BoardDataVO boardDataVo)
void	updateDataViewCount(BoardDataVO boardDataVO)
void	updateExtensionData(BoardExtensionDataVO boardExtensionDataVO)
void	updateFileDeleteStatus(BoardDataVO boardDataVO)
void	updateNoticeData(BoardDataVO boardDataVO) 공지기간 지난글 업데이트
void	updatePeriodData(BoardDataVO boardDataVO)

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

BoardDAO

public BoardDAO()

Method Detail

selectBoardListTotal

public int selectBoardListTotal(BoardVO boardVO)
                         throws java.lang.Exception

게시판 전체 갯수

Parameters:

boardVO -

Returns:

Throws:

java.lang.Exception

selectBoardList

public java.util.List<BoardVO> selectBoardList(BoardVO boardVO)
                                        throws java.lang.Exception

게시판 리스트

Parameters:

boardVO -

Returns:

Throws:

java.lang.Exception

selectBoardAllList

public java.util.List<BoardVO> selectBoardAllList(BoardVO boardVO)
                                           throws java.lang.Exception

Throws:

java.lang.Exception

getBoardBasic

public BoardVO getBoardBasic(BoardVO boardVO)
                      throws java.lang.Exception

게시판 기본정보

Parameters:

boardVO -

Returns:

Throws:

java.lang.Exception

getBoardBasicInfo

public BoardVO getBoardBasicInfo(BoardVO boardVO)
                          throws java.lang.Exception

Throws:

java.lang.Exception

getBoardBasicInfoId

public BoardVO getBoardBasicInfoId(BoardVO boardVO)
                            throws java.lang.Exception

Throws:

java.lang.Exception

insertBoardInfo

public void insertBoardInfo(BoardVO boardVO)
                     throws java.lang.Exception

게시판 등록

Parameters:

boardVO -

Throws:

java.lang.Exception

insertBoardInfoAll

public void insertBoardInfoAll(BoardVO boardVO)
                        throws java.lang.Exception

Throws:

java.lang.Exception

selectBoardIdCount

public int selectBoardIdCount(BoardVO boardVO)
                       throws java.lang.Exception

게시판 중복확인

Parameters:

boardVO -

Throws:

java.lang.Exception

selectBoardIdEtcCount

public int selectBoardIdEtcCount(BoardVO boardVO)
                          throws java.lang.Exception

게시판 기타정보 중복확인

Parameters:

boardVO -

Throws:

java.lang.Exception

updateBoardInfo

public void updateBoardInfo(BoardVO boardVO)
                     throws java.lang.Exception

게시판 수정

Parameters:

boardVO -

Throws:

java.lang.Exception

deleteBoardInfo

public void deleteBoardInfo(BoardVO boardVO)
                     throws java.lang.Exception

게시판 삭제 플래그 삭제로 변경

Parameters:

boardVO -

Throws:

java.lang.Exception

getBoardEtc

public BoardEtcVO getBoardEtc(BoardEtcVO boardEtcVO)
                       throws java.lang.Exception

게시판 기타정보

Parameters:

boardEtcVO -

Throws:

java.lang.Exception

insertBoardEtc

public void insertBoardEtc(BoardEtcVO boardEtcVO)
                    throws java.lang.Exception

Throws:

java.lang.Exception

updateBoardEtc

public void updateBoardEtc(BoardEtcVO boardEtcVO)
                    throws java.lang.Exception

게시판 기타정보 수정

Parameters:

boardEtcVO -

Throws:

java.lang.Exception

selectExtensionFieldCount

public int selectExtensionFieldCount(BoardExtensionVO boardExtensionVO)
                              throws java.lang.Exception

게시판 필드관련 DAO 영역

Throws:

java.lang.Exception

selectFieldValidator

public java.util.List<BoardExtensionVO> selectFieldValidator(BoardExtensionVO boardExtensionVO)
                                                      throws java.lang.Exception

Throws:

java.lang.Exception

selectDefaultField

public java.util.List<BoardExtensionVO> selectDefaultField()
                                                    throws java.lang.Exception

Throws:

java.lang.Exception

getDefaultField

public BoardExtensionVO getDefaultField(BoardExtensionVO boardExtensionVO)
                                 throws java.lang.Exception

Throws:

java.lang.Exception

selectExtensionField

public java.util.List<BoardExtensionVO> selectExtensionField(BoardExtensionVO boardExtensionVO)
                                                      throws java.lang.Exception

Throws:

java.lang.Exception

selectExtensionFieldUse

public java.util.List<BoardExtensionVO> selectExtensionFieldUse(BoardExtensionVO boardExtensionVO)
                                                         throws java.lang.Exception

Throws:

java.lang.Exception

insertBoardExtension

public void insertBoardExtension(BoardExtensionVO boardExtensionVO)
                          throws java.lang.Exception

Throws:

java.lang.Exception

updateBoardExtension

public void updateBoardExtension(BoardExtensionVO boardExtensionVO)
                          throws java.lang.Exception

Throws:

java.lang.Exception

deleteBoardExtension

public void deleteBoardExtension(BoardExtensionVO boardExtensionVO)
                          throws java.lang.Exception

Throws:

java.lang.Exception

selectBoardCategory

public java.util.List<BoardCategoryVO> selectBoardCategory(BoardCategoryVO boardCategoryVO)
                                                    throws java.lang.Exception

게시판 카테고리 관련 DAO 영역

Throws:

java.lang.Exception

getBoardCategory

public BoardCategoryVO getBoardCategory(BoardCategoryVO boardCategoryVO)
                                 throws java.lang.Exception

Throws:

java.lang.Exception

selectBoardCategoryCount

public int selectBoardCategoryCount(BoardCategoryVO boardCategoryVO)
                             throws java.lang.Exception

Throws:

java.lang.Exception

insertBoardCategory

public void insertBoardCategory(BoardCategoryVO boardCategoryVO)
                         throws java.lang.Exception

Throws:

java.lang.Exception

updateBoardCategory

public void updateBoardCategory(BoardCategoryVO boardCategoryVO)
                         throws java.lang.Exception

Throws:

java.lang.Exception

deleteBoardCategory

public void deleteBoardCategory(BoardCategoryVO boardCategoryVO)
                         throws java.lang.Exception

Throws:

java.lang.Exception

getBoardItem

public BoardVO getBoardItem(BoardVO boardVO)
                     throws java.lang.Exception

게시판 항목관련 DAO 영역

Throws:

java.lang.Exception

updateBoardItemList

public void updateBoardItemList(BoardVO boardVO)
                         throws java.lang.Exception

Throws:

java.lang.Exception

updateBoardItemView

public void updateBoardItemView(BoardVO boardVO)
                         throws java.lang.Exception

Throws:

java.lang.Exception

updateBoardItemWrite

public void updateBoardItemWrite(BoardVO boardVO)
                          throws java.lang.Exception

Throws:

java.lang.Exception

selectBoardListTotal

public int selectBoardListTotal(BoardSkinVO boardSkinVO)
                         throws java.lang.Exception

게시판스킨관련 DAO 영역

Throws:

java.lang.Exception

selectBoardSkinList

public java.util.List<BoardSkinVO> selectBoardSkinList(BoardSkinVO boardSkinVO)
                                                throws java.lang.Exception

Throws:

java.lang.Exception

getBoardSkin

public BoardSkinVO getBoardSkin(BoardSkinVO boardSkinVO)
                         throws java.lang.Exception

Throws:

java.lang.Exception

getBoardSkinId

public BoardSkinVO getBoardSkinId(BoardSkinVO boardSkinVO)
                           throws java.lang.Exception

Throws:

java.lang.Exception

selectBoardSkinArea

public BoardSkinVO selectBoardSkinArea(BoardSkinVO boardSkinVO)
                                throws java.lang.Exception

Throws:

java.lang.Exception

updateBoardSkinArea

public void updateBoardSkinArea(BoardSkinVO boardSkinVO)
                         throws java.lang.Exception

Throws:

java.lang.Exception

selectBoardSkinIdCount

public int selectBoardSkinIdCount(BoardSkinVO boardSkinVO)
                           throws java.lang.Exception

Throws:

java.lang.Exception

insertBoardSkin

public void insertBoardSkin(BoardSkinVO boardSkinVO)
                     throws java.lang.Exception

Throws:

java.lang.Exception

updateBoardSkin

public void updateBoardSkin(BoardSkinVO boardSkinVO)
                     throws java.lang.Exception

Throws:

java.lang.Exception

deleteSkin

public void deleteSkin(BoardSkinVO boardSkinVO)
                throws java.lang.Exception

Throws:

java.lang.Exception

deleteSkinEtc

public void deleteSkinEtc(BoardSkinVO boardSkinVO)
                   throws java.lang.Exception

Throws:

java.lang.Exception

insertBoardSkinEtc

public void insertBoardSkinEtc(BoardSkinEtcVO boardSkinEtcVO)
                        throws java.lang.Exception

Throws:

java.lang.Exception

updateBoardSkinEtc

public void updateBoardSkinEtc(BoardSkinEtcVO boardSkinEtcVO)
                        throws java.lang.Exception

Throws:

java.lang.Exception

selectBoardSkinEtcCount

public int selectBoardSkinEtcCount(BoardSkinEtcVO boardSkinEtcVO)
                            throws java.lang.Exception

Throws:

java.lang.Exception

getBoardSkinEtc

public BoardSkinEtcVO getBoardSkinEtc(BoardSkinEtcVO boardSkinEtcVO)
                               throws java.lang.Exception

Throws:

java.lang.Exception

updateBoardSkinPublic

public void updateBoardSkinPublic(BoardSkinVO boardSkinVO)
                           throws java.lang.Exception

Throws:

java.lang.Exception

updateBoardSkinList

public void updateBoardSkinList(BoardSkinVO boardSkinVO)
                         throws java.lang.Exception

Throws:

java.lang.Exception

updateBoardSkinWrite

public void updateBoardSkinWrite(BoardSkinVO boardSkinVO)
                          throws java.lang.Exception

Throws:

java.lang.Exception

updateBoardSkinView

public void updateBoardSkinView(BoardSkinVO boardSkinVO)
                         throws java.lang.Exception

Throws:

java.lang.Exception

selectBoardSkinAllList

public java.util.List<BoardSkinVO> selectBoardSkinAllList(BoardSkinVO boardSkinVO)
                                                   throws java.lang.Exception

Throws:

java.lang.Exception

selectBoardDataListTotal

public int selectBoardDataListTotal(BoardSearchVO boardSearchVO)
                             throws java.lang.Exception

Throws:

java.lang.Exception

selectBoardSkinBackup

public java.util.List<BoardSkinHistoryVO> selectBoardSkinBackup(BoardSkinHistoryVO boardSkinHistoryVO)
                                                         throws java.lang.Exception

Throws:

java.lang.Exception

getBoardSkinBackup

public BoardSkinHistoryVO getBoardSkinBackup(BoardSkinHistoryVO boardSkinHistoryVO)
                                      throws java.lang.Exception

Throws:

java.lang.Exception

insertBoardSkinBackup

public void insertBoardSkinBackup(BoardSkinHistoryVO boardSkinHistoryVO)
                           throws java.lang.Exception

Throws:

java.lang.Exception

initBoardSkinBackup

public void initBoardSkinBackup(BoardSkinHistoryVO boardSkinHistoryVO)
                         throws java.lang.Exception

Throws:

java.lang.Exception

updateBoardSkinBackup

public void updateBoardSkinBackup(BoardSkinHistoryVO boardSkinHistoryVO)
                           throws java.lang.Exception

Throws:

java.lang.Exception

selectBoardDataList

public java.util.List<BoardDataVO> selectBoardDataList(BoardSearchVO boardSearchVO)
                                                throws java.lang.Exception

일반 게시물 검색

Parameters:

boardSearchVO -

Returns:

Throws:

java.lang.Exception

selectBoardNoticeDataList

public java.util.List<BoardDataVO> selectBoardNoticeDataList(BoardSearchVO boardSearchVO)
                                                      throws java.lang.Exception

공지글 목록 검색

Parameters:

boardSearchVO -

Returns:

Throws:

java.lang.Exception

selectStandByDataList

public java.util.List<BoardDataVO> selectStandByDataList(BoardSearchVO boardSearchVO)
                                                  throws java.lang.Exception

승인대기 게시물 목록

Parameters:

boardSearchVO -

Returns:

Throws:

java.lang.Exception

getBoardData

public BoardDataVO getBoardData(BoardDataVO boardDataVO)
                         throws java.lang.Exception

Throws:

java.lang.Exception

getBoardDataIdx

public int getBoardDataIdx(BoardVO boardVO)
                    throws java.lang.Exception

Throws:

java.lang.Exception

passwordValidate

public int passwordValidate(BoardSearchVO boardSearchVO)
                     throws java.lang.Exception

Throws:

java.lang.Exception

insertBoardData

public void insertBoardData(BoardDataVO boardDataVO)
                     throws java.lang.Exception

Throws:

java.lang.Exception

updateBoardData

public void updateBoardData(BoardDataVO boardDataVO)
                     throws java.lang.Exception

Throws:

java.lang.Exception

deleteBoardData

public void deleteBoardData(BoardDataVO boardDataVO)
                     throws java.lang.Exception

게시판 삭제 상태 변경

Parameters:

boardDataVO -

Throws:

java.lang.Exception

updateBoardDataStatus

public void updateBoardDataStatus(BoardDataVO boardDataVO)
                           throws java.lang.Exception

게시물 차단 상태 변경

Parameters:

boardDataVO -

Throws:

java.lang.Exception

updateBoardDataAnswerStatus

public void updateBoardDataAnswerStatus(BoardDataVO boardDataVO)
                                 throws java.lang.Exception

Throws:

java.lang.Exception

updateBoardDataReplyNotice

public void updateBoardDataReplyNotice(BoardDataVO boardDataVO)
                                throws java.lang.Exception

Throws:

java.lang.Exception

selectBoardExtensionDataCount

public int selectBoardExtensionDataCount(BoardExtensionDataVO boardExtensionDataVO)
                                  throws java.lang.Exception

Throws:

java.lang.Exception

insertExtensionData

public void insertExtensionData(BoardExtensionDataVO boardExtensionDataVO)
                         throws java.lang.Exception

Throws:

java.lang.Exception

updateExtensionData

public void updateExtensionData(BoardExtensionDataVO boardExtensionDataVO)
                         throws java.lang.Exception

Throws:

java.lang.Exception

selectBoardExtensionDataList

public java.util.List<BoardExtensionDataVO> selectBoardExtensionDataList(BoardDataVO boardDataVO)
                                                                  throws java.lang.Exception

Throws:

java.lang.Exception

updateDataReplyOrder

public void updateDataReplyOrder(BoardDataVO boardDataVO)
                          throws java.lang.Exception

Throws:

java.lang.Exception

updateDataViewCount

public void updateDataViewCount(BoardDataVO boardDataVO)
                         throws java.lang.Exception

Throws:

java.lang.Exception

updateDataStarPoint

public void updateDataStarPoint(BoardDataVO boardDataVO)
                         throws java.lang.Exception

Throws:

java.lang.Exception

updateDataRegisterDt

public void updateDataRegisterDt(BoardDataVO boardDataVO)
                          throws java.lang.Exception

Throws:

java.lang.Exception

selectBoardFile

public java.util.List<BoardFileVO> selectBoardFile(BoardDataVO boardDataVO)
                                            throws java.lang.Exception

Throws:

java.lang.Exception

getBoardFile

public BoardFileVO getBoardFile(BoardFileVO boardFileVO)
                         throws java.lang.Exception

Throws:

java.lang.Exception

insertBoardFile

public void insertBoardFile(BoardFileVO boardFileVO)
                     throws java.lang.Exception

Throws:

java.lang.Exception

updateBoardFile

public void updateBoardFile(BoardFileVO boardFileVO)
                     throws java.lang.Exception

Throws:

java.lang.Exception

updateBoardFileId

public void updateBoardFileId(BoardFileVO boardFileVO)
                       throws java.lang.Exception

Throws:

java.lang.Exception

deleteBoardFile

public void deleteBoardFile(BoardFileVO boardFileVO)
                     throws java.lang.Exception

Throws:

java.lang.Exception

updateFileDeleteStatus

public void updateFileDeleteStatus(BoardDataVO boardDataVO)
                            throws java.lang.Exception

Throws:

java.lang.Exception

getDataContent

public java.lang.String getDataContent(BoardDataVO boardDataVO)
                                throws java.lang.Exception

Throws:

java.lang.Exception

selectBoardDataReplyCount

public int selectBoardDataReplyCount(BoardDataVO boardDataVO)
                              throws java.lang.Exception

Throws:

java.lang.Exception

selectBoardDataOriginal

public java.util.List<BoardDataVO> selectBoardDataOriginal(BoardDataVO boardDataVO)
                                                    throws java.lang.Exception

Throws:

java.lang.Exception

selectBoardDataReplyList

public java.util.List<BoardDataVO> selectBoardDataReplyList(BoardDataVO boardDataVO)
                                                     throws java.lang.Exception

Throws:

java.lang.Exception

getBoardCommentIdx

public int getBoardCommentIdx(BoardSearchVO boardSearchVO)
                       throws java.lang.Exception

Throws:

java.lang.Exception

selectCommentCount

public int selectCommentCount(BoardSearchVO boardSearchVO)
                       throws java.lang.Exception

Throws:

java.lang.Exception

selectCommentList

public java.util.List<CommentVO> selectCommentList(BoardSearchVO boardSearchVO)
                                            throws java.lang.Exception

Throws:

java.lang.Exception

getComment

public CommentVO getComment(CommentVO commentVO)
                     throws java.lang.Exception

Throws:

java.lang.Exception

updateCommentReplyOrder

public void updateCommentReplyOrder(CommentVO commentVO)
                             throws java.lang.Exception

Throws:

java.lang.Exception

insertComment

public void insertComment(CommentVO commentVO)
                   throws java.lang.Exception

Throws:

java.lang.Exception

deleteComment

public void deleteComment(CommentVO commentVO)
                   throws java.lang.Exception

Throws:

java.lang.Exception

getStarPoint

public int getStarPoint(BoardSearchVO boardSearchVO)
                 throws java.lang.Exception

Throws:

java.lang.Exception

selectBoardActionTotal

public int selectBoardActionTotal(BoardActionVO boardActionVO)
                           throws java.lang.Exception

Throws:

java.lang.Exception

selectBoardActionCount

public int selectBoardActionCount(BoardActionVO boardActionVO)
                           throws java.lang.Exception

Throws:

java.lang.Exception

selectBoardActionList

public java.util.List<BoardActionVO> selectBoardActionList(BoardActionVO boardActionVO)
                                                    throws java.lang.Exception

Throws:

java.lang.Exception

selectBoardActionListAll

public java.util.List<BoardActionVO> selectBoardActionListAll(BoardActionVO boardActionVO)
                                                       throws java.lang.Exception

Throws:

java.lang.Exception

getBoardAction

public BoardActionVO getBoardAction(BoardActionVO boardActionVO)
                             throws java.lang.Exception

Throws:

java.lang.Exception

insertBoardAction

public void insertBoardAction(BoardActionVO boardActionVO)
                       throws java.lang.Exception

Throws:

java.lang.Exception

updateBoardAction

public void updateBoardAction(BoardActionVO boardActionVO)
                       throws java.lang.Exception

Throws:

java.lang.Exception

deleteBoardAction

public void deleteBoardAction(BoardActionVO boardActionVO)
                       throws java.lang.Exception

Throws:

java.lang.Exception

selectBoardHistoryListTotal

public int selectBoardHistoryListTotal(BoardHistoryVO boardHistoryVO)
                                throws java.lang.Exception

Throws:

java.lang.Exception

selectBoardHistoryList

public java.util.List<BoardHistoryVO> selectBoardHistoryList(BoardHistoryVO boardHistoryVO)
                                                      throws java.lang.Exception

Throws:

java.lang.Exception

insertBoardHistory

public void insertBoardHistory(BoardHistoryVO boardHistoryVO)
                        throws java.lang.Exception

Throws:

java.lang.Exception

selectDownloadHistoryTotal

public int selectDownloadHistoryTotal(DownloadHistoryVO downloadHistoryVO)
                               throws java.lang.Exception

Throws:

java.lang.Exception

insertBoardDataBackup

public void insertBoardDataBackup(BoardDataVO boardDataVO)
                           throws java.lang.Exception

삭제 게시물 등록

Throws:

java.lang.Exception

selectBoardDataBackupTotal

public int selectBoardDataBackupTotal(BoardVO boardVO)
                               throws java.lang.Exception

삭제 게시물 총 갯수

Throws:

java.lang.Exception

selectBackupHistoryTotal

public int selectBackupHistoryTotal(BoardDataVO boardDataVO)
                             throws java.lang.Exception

Throws:

java.lang.Exception

selectBoardDataBackupList

public java.util.List<BoardDataVO> selectBoardDataBackupList(BoardVO boardVO)
                                                      throws java.lang.Exception

삭제 게시물 목록

Parameters:

boardVO -

Returns:

Throws:

java.lang.Exception

selectBackupHistoryList

public java.util.List<BoardDataVO> selectBackupHistoryList(BoardDataVO boardDataVO)
                                                    throws java.lang.Exception

Throws:

java.lang.Exception

getBoardDataBak

public BoardDataVO getBoardDataBak(BoardDataVO boardDataVO)
                            throws java.lang.Exception

삭제 게시물 정보 추출

Parameters:

boardDataVO -

Returns:

Throws:

java.lang.Exception

restoreBoardDataBak

public void restoreBoardDataBak(BoardVO boardVO)
                         throws java.lang.Exception

삭제 게시물 복구일자 설정

Parameters:

boardDataVO -

Throws:

java.lang.Exception

getBoardDataBakList

public java.util.List<BoardDataVO> getBoardDataBakList(BoardVO boardVO)
                                                throws java.lang.Exception

Throws:

java.lang.Exception

deleteBoardDataBak

public void deleteBoardDataBak(BoardVO boardVO)
                        throws java.lang.Exception

Throws:

java.lang.Exception

selectBoardDataManagerTotal

public int selectBoardDataManagerTotal(BoardVO boardVO)
                                throws java.lang.Exception

Throws:

java.lang.Exception

selectBoardDataManagerList

public java.util.List<BoardDataVO> selectBoardDataManagerList(BoardVO boardVO)
                                                       throws java.lang.Exception

Throws:

java.lang.Exception

selectBoardDataManagerStandbyListCnt

public int selectBoardDataManagerStandbyListCnt(BoardVO boardVO)
                                         throws java.lang.Exception

게시물 관리 대기 목록수

Parameters:

boardVO -

Returns:

Throws:

java.lang.Exception

selectBoardDataManagerStandbyList

public java.util.List<BoardDataVO> selectBoardDataManagerStandbyList(BoardVO boardVO)
                                                              throws java.lang.Exception

게시물 관리 대기 목록

Parameters:

boardVO -

Returns:

Throws:

java.lang.Exception

deleteDataListManager

public void deleteDataListManager(BoardVO boardVO)
                           throws java.lang.Exception

Throws:

java.lang.Exception

deleteDataFileManager

public void deleteDataFileManager(BoardVO boardVO)
                           throws java.lang.Exception

Throws:

java.lang.Exception

deleteDataExtManager

public void deleteDataExtManager(BoardVO boardVO)
                          throws java.lang.Exception

Throws:

java.lang.Exception

deleteDataCommentManager

public void deleteDataCommentManager(BoardVO boardVO)
                              throws java.lang.Exception

Throws:

java.lang.Exception

getMultiFileList

public java.util.List<BoardFileVO> getMultiFileList(BoardVO boardVO)
                                             throws java.lang.Exception

Throws:

java.lang.Exception

selectCommentListAll

public java.util.List<CommentVO> selectCommentListAll(BoardDataVO boardDataVO)
                                               throws java.lang.Exception

Throws:

java.lang.Exception

selectBoardReplyOfficeList

public java.util.List<BoardReplyVO> selectBoardReplyOfficeList(BoardReplyVO boardReplyVO)
                                                        throws java.lang.Exception

게시물 답변부서 정보를 불러온다.

Parameters:

boardReplyVO -

Returns:

Throws:

java.lang.Exception

insertBoardReplyOffice

public void insertBoardReplyOffice(BoardReplyVO boardReplyVO)
                            throws java.lang.Exception

Throws:

java.lang.Exception

updateBoardReplyOffice

public void updateBoardReplyOffice(BoardReplyVO boardReplyVO)
                            throws java.lang.Exception

Throws:

java.lang.Exception

deleteBoardReplyOffice

public void deleteBoardReplyOffice(BoardReplyVO boardReplyVO)
                            throws java.lang.Exception

Throws:

java.lang.Exception

getBoardReplyOffice

public BoardReplyVO getBoardReplyOffice(BoardReplyVO boardReplyVO)
                                 throws java.lang.Exception

Throws:

java.lang.Exception

selectScheduleDataListTotal

public int selectScheduleDataListTotal(BoardSearchVO boardSearchVO)
                                throws java.lang.Exception

Throws:

java.lang.Exception

selectScheduleDataList

public java.util.List<BoardDataVO> selectScheduleDataList(BoardSearchVO boardSearchVO)
                                                   throws java.lang.Exception

Throws:

java.lang.Exception

insertDownloadHistory

public void insertDownloadHistory(DownloadHistoryVO downloadHistoryVO)
                           throws java.lang.Exception

Throws:

java.lang.Exception

getBoardMenuList

public java.util.List<MenuVO> getBoardMenuList(BoardSearchVO boardSearchVO)
                                        throws java.lang.Exception

Throws:

java.lang.Exception

boardDataCount

public java.util.List<BoardCountVO> boardDataCount(BoardSearchVO boardSearchVO)
                                            throws java.lang.Exception

Throws:

java.lang.Exception

boardOfficeCount

public java.util.List<BoardCountVO> boardOfficeCount(BoardSearchVO boardSearchVO)
                                              throws java.lang.Exception

Throws:

java.lang.Exception

updateDataTmpField

public void updateDataTmpField(BoardDataVO boardDataVo)
                        throws java.lang.Exception

Throws:

java.lang.Exception

listBoardReplyOffice

public java.util.List<BoardReplyVO> listBoardReplyOffice(BoardReplyVO boardReplyVO)
                                                  throws java.lang.Exception

담당부서 설정

Parameters:

boardReplyVO -

Returns:

Throws:

java.lang.Exception

getCommentCnt

public int getCommentCnt(CommentVO commentVO)
                  throws java.lang.Exception

Throws:

java.lang.Exception

deleteUserBoardData

public void deleteUserBoardData(BoardDataVO boardDataVO)
                         throws java.lang.Exception

게시판 삭제 상태 변경

Parameters:

boardDataVO -

Throws:

java.lang.Exception - boardDAO.deleteUserBoardData

deleteRealBoardData

public void deleteRealBoardData(BoardDataVO boardDataVO)
                         throws java.lang.Exception

Throws:

java.lang.Exception

selectBoardDataReplyCnt

public int selectBoardDataReplyCnt(BoardDataVO boardDataVO)
                            throws java.lang.Exception

Throws:

java.lang.Exception

getBoardCommentAllCnt

public int getBoardCommentAllCnt(BoardSearchVO boardSearchVO)
                          throws java.lang.Exception

만족도 전체리스트 년 월 일 카운트

Throws:

java.lang.Exception

getCommentListAllPage

public java.util.List<CommentVO> getCommentListAllPage(BoardSearchVO boardSearchVO)
                                                throws java.lang.Exception

만족도 전체리스트 년 월 일 검색

Parameters:

boardSearchVO -

Returns:

Throws:

java.lang.Exception

getCommentListAll

public java.util.List<CommentVO> getCommentListAll(BoardSearchVO boardSearchVO)
                                            throws java.lang.Exception

만족도 전체리스트 년 월 일 검색 ALL

Parameters:

boardSearchVO -

Returns:

Throws:

java.lang.Exception

selectNoticeUpdateDataList

public java.util.List<BoardDataVO> selectNoticeUpdateDataList(BoardSearchVO boardSearchVO)
                                                       throws java.lang.Exception

공지 지난글 목록 검색

Parameters:

boardSearchVO -

Returns:

Throws:

java.lang.Exception

selectPeriodUpdateDataList

public java.util.List<BoardDataVO> selectPeriodUpdateDataList(BoardSearchVO boardSearchVO)
                                                       throws java.lang.Exception

Throws:

java.lang.Exception

updateNoticeData

public void updateNoticeData(BoardDataVO boardDataVO)
                      throws java.lang.Exception

공지기간 지난글 업데이트

Parameters:

boardDataVO -

Throws:

java.lang.Exception

updatePeriodData

public void updatePeriodData(BoardDataVO boardDataVO)
                      throws java.lang.Exception

Throws:

java.lang.Exception

insertBoardDataLike

public void insertBoardDataLike(BoardDataLikeVO boardDataLikeVO)
                         throws java.lang.Exception

게시판글 좋아요,싫어요,찬성,반대

Parameters:

boardDataLikeVO -

Throws:

java.lang.Exception

deleteBoardDataLike

public void deleteBoardDataLike(BoardDataLikeVO boardDataLikeVO)
                         throws java.lang.Exception

Throws:

java.lang.Exception

selectBoardDataLikeCnt

public int selectBoardDataLikeCnt(BoardDataLikeVO boardDataLikeVO)
                           throws java.lang.Exception

Throws:

java.lang.Exception

selectBoardDataLikeList

public java.util.List<BoardDataLikeVO> selectBoardDataLikeList(BoardDataLikeVO boardDataLikeVO)
                                                        throws java.lang.Exception

Throws:

java.lang.Exception

insertCommentDataLike

public void insertCommentDataLike(CommentLikeVO commentLikeVO)
                           throws java.lang.Exception

게시판 댓글에 공감 비공감

Parameters:

commentLikeVO -

Throws:

java.lang.Exception

selectBoardCommentLikeCnt

public int selectBoardCommentLikeCnt(CommentLikeVO commentLikeVO)
                              throws java.lang.Exception

Throws:

java.lang.Exception

getBoardRecentlyPosted

public BoardDataVO getBoardRecentlyPosted(BoardDataVO boardDataVO)
                                   throws java.lang.Exception

관리자 게시판목록 게시판에 따른 최근게시일

Throws:

java.lang.Exception