skoinfo.rfc.reservation.dao
Class ReservationDAO

java.lang.Object
  skoinfo.rfc.reservation.dao.ReservationDAO

public class ReservationDAO
extends java.lang.Object

Constructor Summary

ReservationDAO()

Method Summary

int	adminReservationDup(org.hibernate.Session session, ReservationVO reservationVO) 관리자예약 중복검사 DAO
void	deleteReservation(org.hibernate.Session session, ReservationVO reservationVO) 예약한정보 삭제(예약신청자 삭제(관리자가 삭제)) DAO
void	deleteRoom(org.hibernate.Session session, ReservationRoomVO reservationRoomVO) 객실 , 예약정보 삭제 DAO
void	deleteStr(org.hibernate.Session session, ReservationStructureVO reservationStructureVO) 건물,평수,룸 삭제 DAO
java.util.List<ReservationStructureVO>	getReservationStructureList(org.hibernate.Session session, java.lang.String groupCd) 숲속의집 예약서비스 리스트(컨탠츠) DAO
java.util.List<ReservationVO>	getReservationUserList(org.hibernate.Session session, java.lang.String groupCd, long resStrSid, long resRoomSid, java.lang.String resSize, java.lang.String toDay, java.lang.String nextDay) 예약목록(사용자) DAO
java.util.List<ReservationVO>	resAdminList(org.hibernate.Session session, java.lang.String groupCd, long resRoomSid, int beginRow, int rowCount, java.util.ArrayList orderByList) 관리자 예약관리 목록(검색타입이 객실일때) DAO
java.util.List<ReservationVO>	resAdminList(org.hibernate.Session session, java.lang.String groupCd, java.lang.String keyword, java.lang.String keywordSize, java.lang.String keywordStatus, java.lang.String keyword1, java.lang.String keyword2, java.lang.String searchType, int beginRow, int rowCount, java.util.ArrayList orderByList) 관리자 예약관리 목록 DAO
java.util.List<ReservationRoomVO>	reservationLedgerList(org.hibernate.Session session, java.lang.String admin_today, java.lang.String groupCd) 관리자 예약대장 리스트 목록 DAO
java.util.List<ReservationVO>	reservationList(org.hibernate.Session session, long resStrSid, java.lang.String toDay, java.lang.String nextDay) 예약현황보기(사용자) DAO
java.util.List<ReservationRoomVO>	reservationRoomList(org.hibernate.Session session, long resStrSid) 객실목록 리스트(전채예약현황보기(사용자)) DAO
java.util.List<ReservationRoomVO>	reservationRoomList(org.hibernate.Session session, java.lang.String groupCd, java.lang.String keyword, java.lang.String searchType, long resStrSid, int beginRow, int rowCount, java.util.ArrayList orderByList)
java.util.List<ReservationStructureVO>	reservationStrList(org.hibernate.Session session, java.lang.String groupCd, java.lang.String keyword, java.lang.String searchType, int beginRow, int rowCount, java.util.ArrayList orderByList)
void	reservationUserWrite(org.hibernate.Session session, ReservationVO resVO) 예약저장(사용자) DAO
java.util.List<ReservationRoomVO>	resRoomList(org.hibernate.Session session, long resStrSid) 객실목록 리스트(관리자) DAO
java.util.List<ReservationRoomVO>	resRoomList(org.hibernate.Session session, java.lang.String groupCd, long resStrSid, java.lang.String resSize, java.lang.String toDay, java.lang.String nextDay) 예약목록현황 룸리스트(사용자) DAO
java.util.List<ReservationStructureVO>	resStrList(org.hibernate.Session session, java.lang.String groupCd) 건물 리스트(관리자) DAO
java.util.List<ReservationVO>	resStructurcList(org.hibernate.Session session, java.lang.String groupCd, java.lang.String toDay, java.lang.String nextDay, long resRoomSid, boolean isManager) 예약현황보기(사용자) DAO
static int	resTotalCount(org.hibernate.Session session, java.lang.String groupCd, long resRoomSid) 예약관리 리스트 카운트(검색타입이 객실일 경우) DAO
static int	resTotalCount(org.hibernate.Session session, java.lang.String groupCd, java.lang.String keyword, java.lang.String keywordSize, java.lang.String keywordStatus, java.lang.String keyword1, java.lang.String keyword2, java.lang.String searchType) 예약관리 리스트 카운트 DAO
java.util.List<ReservationStructureVO>	resUserStrList(org.hibernate.Session session, java.lang.String groupCd) 건물 리스트(사용자) DAO
static int	roomTotalCount(org.hibernate.Session session, java.lang.String groupCd, long resStrSid, java.lang.String keyword, java.lang.String searchType) 객실 카운트 DAO
long	serchPrice(ReservationVO resVO, ReservationRoomVO reservationRoomVO) 가격 함수 DAO
static int	strTotalCount(org.hibernate.Session session, java.lang.String groupCd, java.lang.String keyword, java.lang.String searchType) 건물 카운트 DAO
java.util.List<ReservationRoomVO>	toTalResRoomList(org.hibernate.Session session) 총객실목록 리스트(관리자) DAO
java.util.List<ReservationRoomVO>	toTalResSizeList(org.hibernate.Session session) 총 평수 리스트(관리자) DAO
void	updateRes(org.hibernate.Session session, ReservationVO reservationVO) 예약 수정 DAO
void	updateRoom(org.hibernate.Session session, ReservationRoomVO reservationRoomVO) 객실 수정 DAO
void	updateStatus(org.hibernate.Session session, ReservationVO reservationVO) 예약 상태 수정 DAO
void	updateStr(org.hibernate.Session session, ReservationStructureVO reservationStructureVO) 건물 수정 DAO
int	userEventListCount(org.hibernate.Session session, java.lang.String keyword, java.lang.String searchType, java.lang.Long adminEventSid, java.lang.String year) 카운트 DAO
int	userReservationDup(org.hibernate.Session session, ReservationVO reservationVO) 사용자예약 중복검사 DAO
java.util.List<ReservationRoomVO>	userResRoomList(org.hibernate.Session session, java.lang.String groupCd) 객실목록 리스트(사용자) DAO
java.util.List<ReservationStructureVO>	userResStrList(org.hibernate.Session session, java.lang.String groupCd) 건물목록 리스트(사용자) DAO
java.util.List<ReservationVO>	userSearchRevoke(org.hibernate.Session session, java.lang.String resUserNm, java.lang.String resUserMp) 예약현황 취소 리스트 보기(사용자) DAO
java.util.List<ReservationVO>	userSearchRevokeOk(org.hibernate.Session session, java.lang.String resUserNm, java.lang.String resUserMp, java.lang.String resSid) 예약현황 취소(사용자) DAO
void	userWriteRes(org.hibernate.Session session, ReservationVO reservationVO) 사용자예약관련 저장 DAO
ReservationVO	viewRes(org.hibernate.Session session, ReservationVO reservationVO) 예약관리 보기 DAO
java.lang.String	viewRoom(org.hibernate.Session session, long resRoomSid) 객실 보기(관리자 예약현황보기) DAO
ReservationRoomVO	viewRoom(org.hibernate.Session session, ReservationRoomVO reservationRoomVO) 객실 보기 DAO
java.lang.String	viewStr(org.hibernate.Session session, long resStrSid) 건물 보기(관리자 예약현황보기) DAO
ReservationStructureVO	viewStr(org.hibernate.Session session, ReservationStructureVO reservationStructureVO) 건물 보기 DAO
ReservationRoomVO	viewUserRoom(org.hibernate.Session session, ReservationRoomVO reservationRoomVO) 룸 보기(사용자) DAO
void	writeRes(org.hibernate.Session session, ReservationVO resVO, ReservationRoomVO reservationRoomVO) admin예약저장 DAO
void	writeResRoom(org.hibernate.Session session, ReservationRoomVO resRoomVO) admin객실저장 DAO
void	writeResStr(org.hibernate.Session session, ReservationStructureVO resStrVO) admin건물저장 DAO

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

ReservationDAO

public ReservationDAO()

Method Detail

userEventListCount

public int userEventListCount(org.hibernate.Session session,
                              java.lang.String keyword,
                              java.lang.String searchType,
                              java.lang.Long adminEventSid,
                              java.lang.String year)
                       throws java.lang.Exception

카운트 DAO

Parameters:

session - 디비세션

keyword - 검색어

Returns:

조건에 해당하는 레코드 건수를 반환한다.

Throws:

java.lang.Exception - 처리

resTotalCount

public static int resTotalCount(org.hibernate.Session session,
                                java.lang.String groupCd,
                                java.lang.String keyword,
                                java.lang.String keywordSize,
                                java.lang.String keywordStatus,
                                java.lang.String keyword1,
                                java.lang.String keyword2,
                                java.lang.String searchType)
                         throws java.lang.Exception

예약관리 리스트 카운트 DAO

Parameters:

session - 디비세션

keyword - 검색어

Returns:

조건에 해당하는 레코드 건수를 반환한다.

Throws:

java.lang.Exception - 처리

resTotalCount

public static int resTotalCount(org.hibernate.Session session,
                                java.lang.String groupCd,
                                long resRoomSid)
                         throws java.lang.Exception

예약관리 리스트 카운트(검색타입이 객실일 경우) DAO

Parameters:

session - 디비세션

keyword - 검색어

Returns:

조건에 해당하는 레코드 건수를 반환한다.

Throws:

java.lang.Exception - 처리

strTotalCount

public static int strTotalCount(org.hibernate.Session session,
                                java.lang.String groupCd,
                                java.lang.String keyword,
                                java.lang.String searchType)
                         throws java.lang.Exception

건물 카운트 DAO

Parameters:

session - 디비세션

keyword - 검색어

Returns:

조건에 해당하는 레코드 건수를 반환한다.

Throws:

java.lang.Exception - 처리

roomTotalCount

public static int roomTotalCount(org.hibernate.Session session,
                                 java.lang.String groupCd,
                                 long resStrSid,
                                 java.lang.String keyword,
                                 java.lang.String searchType)
                          throws java.lang.Exception

객실 카운트 DAO

Parameters:

session - 디비세션

keyword - 검색어

Returns:

조건에 해당하는 레코드 건수를 반환한다.

Throws:

java.lang.Exception - 처리

resAdminList

public java.util.List<ReservationVO> resAdminList(org.hibernate.Session session,
                                                  java.lang.String groupCd,
                                                  long resRoomSid,
                                                  int beginRow,
                                                  int rowCount,
                                                  java.util.ArrayList orderByList)
                                           throws java.lang.Exception

관리자 예약관리 목록(검색타입이 객실일때) DAO

Parameters:

session - 디비세션

groupCd - 그룹코드

beginRow - 페이지 시작 위치

rowCount - 가져올 자료수

Returns:

조건에 해당하는 자료를 List로 반환

Throws:

java.lang.Exception - 처리

resAdminList

public java.util.List<ReservationVO> resAdminList(org.hibernate.Session session,
                                                  java.lang.String groupCd,
                                                  java.lang.String keyword,
                                                  java.lang.String keywordSize,
                                                  java.lang.String keywordStatus,
                                                  java.lang.String keyword1,
                                                  java.lang.String keyword2,
                                                  java.lang.String searchType,
                                                  int beginRow,
                                                  int rowCount,
                                                  java.util.ArrayList orderByList)
                                           throws java.lang.Exception

관리자 예약관리 목록 DAO

Parameters:

session - 디비세션

groupCd - 그룹코드

beginRow - 페이지 시작 위치

rowCount - 가져올 자료수

Returns:

조건에 해당하는 자료를 List로 반환

Throws:

java.lang.Exception - 처리

reservationStrList

public java.util.List<ReservationStructureVO> reservationStrList(org.hibernate.Session session,
                                                                 java.lang.String groupCd,
                                                                 java.lang.String keyword,
                                                                 java.lang.String searchType,
                                                                 int beginRow,
                                                                 int rowCount,
                                                                 java.util.ArrayList orderByList)
                                                          throws java.lang.Exception

Throws:

java.lang.Exception

reservationLedgerList

public java.util.List<ReservationRoomVO> reservationLedgerList(org.hibernate.Session session,
                                                               java.lang.String admin_today,
                                                               java.lang.String groupCd)
                                                        throws java.lang.Exception

관리자 예약대장 리스트 목록 DAO

Parameters:

session - 디비세션

groupCd - 그룹코드

Returns:

조건에 해당하는 자료를 List로 반환

Throws:

java.lang.Exception - 처리

reservationRoomList

public java.util.List<ReservationRoomVO> reservationRoomList(org.hibernate.Session session,
                                                             java.lang.String groupCd,
                                                             java.lang.String keyword,
                                                             java.lang.String searchType,
                                                             long resStrSid,
                                                             int beginRow,
                                                             int rowCount,
                                                             java.util.ArrayList orderByList)
                                                      throws java.lang.Exception

Throws:

java.lang.Exception

getReservationUserList

public java.util.List<ReservationVO> getReservationUserList(org.hibernate.Session session,
                                                            java.lang.String groupCd,
                                                            long resStrSid,
                                                            long resRoomSid,
                                                            java.lang.String resSize,
                                                            java.lang.String toDay,
                                                            java.lang.String nextDay)
                                                     throws java.lang.Exception

예약목록(사용자) DAO

Parameters:

session - 디비세션

keyword - 검색어

Returns:

조건에 해당하는 레코드 건수를 반환한다.

Throws:

java.lang.Exception - 처리

resRoomList

public java.util.List<ReservationRoomVO> resRoomList(org.hibernate.Session session,
                                                     java.lang.String groupCd,
                                                     long resStrSid,
                                                     java.lang.String resSize,
                                                     java.lang.String toDay,
                                                     java.lang.String nextDay)
                                              throws java.lang.Exception

예약목록현황 룸리스트(사용자) DAO

Parameters:

session - 디비세션

keyword - 검색어

Returns:

조건에 해당하는 레코드 건수를 반환한다.

Throws:

java.lang.Exception - 처리

getReservationStructureList

public java.util.List<ReservationStructureVO> getReservationStructureList(org.hibernate.Session session,
                                                                          java.lang.String groupCd)
                                                                   throws java.lang.Exception

숲속의집 예약서비스 리스트(컨탠츠) DAO

Parameters:

session - 디비세션

keyword - 검색어

Returns:

조건에 해당하는 레코드 건수를 반환한다.

Throws:

java.lang.Exception - 처리

serchPrice

public long serchPrice(ReservationVO resVO,
                       ReservationRoomVO reservationRoomVO)
                throws java.lang.Exception

가격 함수 DAO

Returns:

조건에 해당하는 가격을 더해서 반환한다.

Throws:

java.lang.Exception - 처리

writeRes

public void writeRes(org.hibernate.Session session,
                     ReservationVO resVO,
                     ReservationRoomVO reservationRoomVO)
              throws java.lang.Exception

admin예약저장 DAO

Parameters:

ReservationVO - 저장할 ReservationVO

Throws:

java.lang.Exception - 처리

reservationUserWrite

public void reservationUserWrite(org.hibernate.Session session,
                                 ReservationVO resVO)
                          throws java.lang.Exception

예약저장(사용자) DAO

Parameters:

ReservationVO - 저장할 ReservationVO

Throws:

java.lang.Exception - 처리

writeResStr

public void writeResStr(org.hibernate.Session session,
                        ReservationStructureVO resStrVO)
                 throws java.lang.Exception

admin건물저장 DAO

Parameters:

EventVO - 저장할 EventVO

Throws:

java.lang.Exception - 처리

writeResRoom

public void writeResRoom(org.hibernate.Session session,
                         ReservationRoomVO resRoomVO)
                  throws java.lang.Exception

admin객실저장 DAO

Parameters:

EventVO - 저장할 EventVO

Throws:

java.lang.Exception - 처리

userWriteRes

public void userWriteRes(org.hibernate.Session session,
                         ReservationVO reservationVO)
                  throws java.lang.Exception

사용자예약관련 저장 DAO

Parameters:

EventVO - 저장할 EventVO

Throws:

java.lang.Exception - 처리

userReservationDup

public int userReservationDup(org.hibernate.Session session,
                              ReservationVO reservationVO)

사용자예약 중복검사 DAO

Parameters:

EventVO - 저장할 EventVO

Throws:

java.lang.Exception - 처리

adminReservationDup

public int adminReservationDup(org.hibernate.Session session,
                               ReservationVO reservationVO)

관리자예약 중복검사 DAO

Parameters:

EventVO - 저장할 EventVO

Throws:

java.lang.Exception - 처리

resRoomList

public java.util.List<ReservationRoomVO> resRoomList(org.hibernate.Session session,
                                                     long resStrSid)

객실목록 리스트(관리자) DAO

Parameters:

EventVO - 저장할 EventVO

Throws:

java.lang.Exception - 처리

toTalResRoomList

public java.util.List<ReservationRoomVO> toTalResRoomList(org.hibernate.Session session)

총객실목록 리스트(관리자) DAO

Parameters:

EventVO - 저장할 EventVO

Throws:

java.lang.Exception - 처리

toTalResSizeList

public java.util.List<ReservationRoomVO> toTalResSizeList(org.hibernate.Session session)

총 평수 리스트(관리자) DAO

Parameters:

EventVO - 저장할 EventVO

Throws:

java.lang.Exception - 처리

userResRoomList

public java.util.List<ReservationRoomVO> userResRoomList(org.hibernate.Session session,
                                                         java.lang.String groupCd)

객실목록 리스트(사용자) DAO

Parameters:

EventVO - 저장할 EventVO

Throws:

java.lang.Exception - 처리

resStrList

public java.util.List<ReservationStructureVO> resStrList(org.hibernate.Session session,
                                                         java.lang.String groupCd)

건물 리스트(관리자) DAO

Parameters:

EventVO - 저장할 EventVO

Throws:

java.lang.Exception - 처리

resUserStrList

public java.util.List<ReservationStructureVO> resUserStrList(org.hibernate.Session session,
                                                             java.lang.String groupCd)

건물 리스트(사용자) DAO

Parameters:

EventVO - 저장할 EventVO

Throws:

java.lang.Exception - 처리

updateStatus

public void updateStatus(org.hibernate.Session session,
                         ReservationVO reservationVO)
                  throws java.lang.Exception

예약 상태 수정 DAO

Parameters:

AdminEventVO - 수정할 AdminEventVO

Throws:

java.lang.Exception - 처리

updateRes

public void updateRes(org.hibernate.Session session,
                      ReservationVO reservationVO)
               throws java.lang.Exception

예약 수정 DAO

Parameters:

AdminEventVO - 수정할 AdminEventVO

Throws:

java.lang.Exception - 처리

updateStr

public void updateStr(org.hibernate.Session session,
                      ReservationStructureVO reservationStructureVO)
               throws java.lang.Exception

건물 수정 DAO

Parameters:

AdminEventVO - 수정할 AdminEventVO

Throws:

java.lang.Exception - 처리

updateRoom

public void updateRoom(org.hibernate.Session session,
                       ReservationRoomVO reservationRoomVO)
                throws java.lang.Exception

객실 수정 DAO

Parameters:

AdminEventVO - 수정할 AdminEventVO

Throws:

java.lang.Exception - 처리

deleteReservation

public void deleteReservation(org.hibernate.Session session,
                              ReservationVO reservationVO)
                       throws java.lang.Exception

예약한정보 삭제(예약신청자 삭제(관리자가 삭제)) DAO

Parameters:

sid - 삭제할 레이아웃번호

Throws:

java.lang.Exception - 처리

deleteStr

public void deleteStr(org.hibernate.Session session,
                      ReservationStructureVO reservationStructureVO)
               throws java.lang.Exception

건물,평수,룸 삭제 DAO

Parameters:

sid - 삭제할 레이아웃번호

Throws:

java.lang.Exception - 처리

deleteRoom

public void deleteRoom(org.hibernate.Session session,
                       ReservationRoomVO reservationRoomVO)
                throws java.lang.Exception

객실 , 예약정보 삭제 DAO

Parameters:

sid - 삭제할 레이아웃번호

Throws:

java.lang.Exception - 처리

viewRes

public ReservationVO viewRes(org.hibernate.Session session,
                             ReservationVO reservationVO)
                      throws java.lang.Exception

예약관리 보기 DAO

Parameters:

ReservationVO - 가져올 ReservationVO

Throws:

java.lang.Exception - 처리

viewStr

public ReservationStructureVO viewStr(org.hibernate.Session session,
                                      ReservationStructureVO reservationStructureVO)
                               throws java.lang.Exception

건물 보기 DAO

Parameters:

ReservationStructureVO - 가져올 ReservationStructureVO

Throws:

java.lang.Exception - 처리

viewStr

public java.lang.String viewStr(org.hibernate.Session session,
                                long resStrSid)
                         throws java.lang.Exception

건물 보기(관리자 예약현황보기) DAO

Parameters:

ReservationStructureVO - 가져올 ReservationStructureVO

Throws:

java.lang.Exception - 처리

viewRoom

public ReservationRoomVO viewRoom(org.hibernate.Session session,
                                  ReservationRoomVO reservationRoomVO)
                           throws java.lang.Exception

객실 보기 DAO

Parameters:

ReservationRoomVO - 가져올 ReservationRoomVO

Throws:

java.lang.Exception - 처리

viewRoom

public java.lang.String viewRoom(org.hibernate.Session session,
                                 long resRoomSid)
                          throws java.lang.Exception

객실 보기(관리자 예약현황보기) DAO

Parameters:

ReservationRoomVO - 가져올 ReservationRoomVO

Throws:

java.lang.Exception - 처리

viewUserRoom

public ReservationRoomVO viewUserRoom(org.hibernate.Session session,
                                      ReservationRoomVO reservationRoomVO)
                               throws java.lang.Exception

룸 보기(사용자) DAO

Parameters:

ReservationRoomVO - 가져올 ReservationRoomVO

Throws:

java.lang.Exception - 처리

userSearchRevoke

public java.util.List<ReservationVO> userSearchRevoke(org.hibernate.Session session,
                                                      java.lang.String resUserNm,
                                                      java.lang.String resUserMp)
                                               throws java.lang.Exception

예약현황 취소 리스트 보기(사용자) DAO

Parameters:

ReservationVO - 가져올 ReservationVO

Throws:

java.lang.Exception - 처리

userSearchRevokeOk

public java.util.List<ReservationVO> userSearchRevokeOk(org.hibernate.Session session,
                                                        java.lang.String resUserNm,
                                                        java.lang.String resUserMp,
                                                        java.lang.String resSid)
                                                 throws java.lang.Exception

예약현황 취소(사용자) DAO

Parameters:

ReservationVO - 가져올 ReservationVO

Throws:

java.lang.Exception - 처리

resStructurcList

public java.util.List<ReservationVO> resStructurcList(org.hibernate.Session session,
                                                      java.lang.String groupCd,
                                                      java.lang.String toDay,
                                                      java.lang.String nextDay,
                                                      long resRoomSid,
                                                      boolean isManager)
                                               throws java.lang.Exception

예약현황보기(사용자) DAO

Parameters:

ReservationStructureVO - 가져올 ReservationStructureVO

Throws:

java.lang.Exception - 처리

reservationList

public java.util.List<ReservationVO> reservationList(org.hibernate.Session session,
                                                     long resStrSid,
                                                     java.lang.String toDay,
                                                     java.lang.String nextDay)
                                              throws java.lang.Exception

예약현황보기(사용자) DAO

Parameters:

ReservationStructureVO - 가져올 ReservationStructureVO

Throws:

java.lang.Exception - 처리

reservationRoomList

public java.util.List<ReservationRoomVO> reservationRoomList(org.hibernate.Session session,
                                                             long resStrSid)

객실목록 리스트(전채예약현황보기(사용자)) DAO

Parameters:

EventVO - 저장할 EventVO

Throws:

java.lang.Exception - 처리

userResStrList

public java.util.List<ReservationStructureVO> userResStrList(org.hibernate.Session session,
                                                             java.lang.String groupCd)

건물목록 리스트(사용자) DAO

Parameters:

EventVO - 저장할 EventVO

Throws:

java.lang.Exception - 처리