skoinfo.rfc.user.dao
Class UserDAO

java.lang.Object
  skoinfo.rfc.user.dao.UserDAO

public class UserDAO
extends java.lang.Object

User DAO

Version:

RFC 1.1 Released, 2008.11.18

Author:

조용로

Constructor Summary

UserDAO()

Method Summary

void	changePassWord(org.hibernate.Session session, java.lang.String userPw, java.lang.String userId) 패스워드 변경
UserVO	checkCertify(org.hibernate.Session session, java.lang.String des) 1.
java.util.List<ElectUserVO>	checkElectUser(org.hibernate.Session session, java.lang.String userBirthDay, java.lang.String userRegNum, java.lang.String userName)
int	checkElectUserLog(org.hibernate.Session session, java.lang.String userBirthDay, java.lang.String userRegNum, java.lang.String userName, java.lang.String date)
boolean	checkId(org.hibernate.Session session, java.lang.String userId) 사용자 ID Check
void	deleteElectUser(org.hibernate.Session session, ElectUserVO electUserVO) 선거인명부 사용자정보 삭제 [2010-05-12 : 원서형]
void	deleteUser(org.hibernate.Session session, UserVO userVO) User Delete
java.util.List<ElectUserVO>	getElectList(org.hibernate.Session session, java.lang.String searchType, java.lang.String keyword, java.lang.String startDt, java.lang.String endDt, int beginRow, int rowCount, java.util.List<OrderBy> orderByList) 선거인명부 목록 [2010-05-11 : 원서형]
java.util.List<ElectUserLogVO>	getElectLogList(org.hibernate.Session session, java.lang.String searchType, java.lang.String keyword, java.lang.String startDt, java.lang.String endDt, int beginRow, int rowCount, java.util.List<OrderBy> orderByList) 선거인명부 열람 목록 [2010-05-20 : 원서형]
ElectUserVO	getElectUser(org.hibernate.Session session, long userSid) 선거인명부 사용자 정보 [2010-05-13 : 원서형]
ElectUserVO	getElectUser(org.hibernate.Session session, java.lang.String userBirthDay, java.lang.String userRegNum, java.lang.String userName) 선거인명부 사용자정보 [2010-05-11 : 원서형]
int	getElectUserCount(org.hibernate.Session session, java.lang.String searchType, java.lang.String keyword, java.lang.String startDt, java.lang.String endDt) 선거인명부 Count [2010-05-11 : 원서형]
java.util.List<ElectUserVO>	getElectUserList(org.hibernate.Session session, java.lang.String userBirthDay, java.lang.String userRegNum, java.lang.String userName) 선거인명부 사용자정보 리스트 [2010-05-11 : 원서형]
int	getElectUserLogCount(org.hibernate.Session session, java.lang.String searchType, java.lang.String keyword, java.lang.String startDt, java.lang.String endDt) 선거인명부 열람 Count [2010-05-20 : 원서형]
int	getOutUserCount(org.hibernate.Session session) 탈퇴 회원 count
java.util.List<OutMemberVO>	getOutUserList(org.hibernate.Session session, int beginRow, int rowCount) 탈퇴 회원 목록
UserVO	getUser(org.hibernate.Session session, long userSid) Get User Info
UserVO	getUser(org.hibernate.Session session, java.lang.String userId) Get User Info
UserVO	getUser(org.hibernate.Session session, java.lang.String userId, java.lang.String userPw)
UserVO	getUser(org.hibernate.Session session, java.lang.String userId, java.lang.String userPw, java.lang.String groupCd)
int	getUserCount(org.hibernate.Session session, java.lang.String groupCd, java.lang.String userType, java.lang.String officeCd, java.lang.String searchType, java.lang.String keyword) User Count
int	getUserCount(org.hibernate.Session session, java.lang.String groupCd, java.lang.String userType, java.lang.String officeCd, java.lang.String searchType, java.lang.String keyword, java.lang.String userStatus)
UserVO	getUserInfo(org.hibernate.Session session, java.lang.String userId, java.lang.String groupCd)
UserVO	getUserInfoSubDn(org.hibernate.Session session, java.lang.String subDn) 인증서 정보로 회원 정보 찾기
java.util.List<UserVO>	getUserList(org.hibernate.Session session, java.lang.String groupCd, java.lang.String userType, java.lang.String officeCd, java.lang.String searchType, java.lang.String keyword, int beginRow, int rowCount, java.util.ArrayList orderByList) User List
java.util.List<UserVO>	getUserList(org.hibernate.Session session, java.lang.String groupCd, java.lang.String userType, java.lang.String officeCd, java.lang.String searchType, java.lang.String keyword, int beginRow, int rowCount, java.util.ArrayList orderByList, java.lang.String userStatus)
java.util.List<UserVO>	getUserVisitList(org.hibernate.Session session, java.lang.String groupCd, int beginRow, int rowCount) User List
UserVO	getUupInfoUser(org.hibernate.Session session, java.lang.String dupInfo) GPIN 중복가입자 찾기
void	initElect(org.hibernate.Session session) 선거인명부 초기화 [2010-05-11 : 원서형]
void	loginTimeUpdate(org.hibernate.Session session, UserVO userVO) 로그인 시간 업데이트
UserVO	SearchSUser(org.hibernate.Session session, java.lang.String userName, java.lang.String userRegNum, java.lang.String groupCd) 자체인증 아이디 찾기 [2010-04-16 : 원서형]
UserVO	SearchSUser(org.hibernate.Session session, java.lang.String userId, java.lang.String userName, java.lang.String userRegNum, java.lang.String groupCd) 자체인증 비밀번호 찾기 [2010-04-16 : 원서형]
UserVO	SearchUser(org.hibernate.Session session, java.lang.String userName, java.lang.String userRegNum) SearchUser 아이디 찾기
UserVO	SearchUser(org.hibernate.Session session, java.lang.String userId, java.lang.String userName, java.lang.String userRegNum) SearchUser 비밀번호 찾기
UserVO	SearchUser(org.hibernate.Session session, java.lang.String userId, java.lang.String userName, java.lang.String userRegNum, java.lang.String userEmail)
java.util.List<UserVO>	SearchUserEId(org.hibernate.Session session, java.lang.String userName, java.lang.String userRegNum, java.lang.String userEmail)
UserVO	SearchUserPwd(org.hibernate.Session session, java.lang.String userId, java.lang.String userPw)
UserVO	setUser(UserVO orginVO) 사용자 정보담기
void	updateElectLogRegDate(org.hibernate.Session session, ElectUserVO electUserVO)
void	updateElectRegDate(org.hibernate.Session session, ElectUserVO electUserVO)
void	updateElectUser(org.hibernate.Session session, ElectUserVO electUserVO) 선거인명부 사용자정보 수정 [2010-05-13 : 원서형]
void	updateEmailUser(org.hibernate.Session session, long userSid, java.lang.String userStatus) 이메일 인증 업데이트 1.
void	updateExistUser(org.hibernate.Session session, java.lang.String userId, java.lang.String userRegNum) 기존 유저 재인증 후 수정 (userId, userName, userRegNum) [2010-03-02 : 원서형]
void	updateOfficeLvPs(org.hibernate.Session session, UserVO userVO) 직급,직책변경
void	updateOfficeUser(org.hibernate.Session session, UserVO userVO)
void	updateUser(org.hibernate.Session session, UserVO userVO) 사용자 수정
void	updateUserCheck(org.hibernate.Session session, long userSid, java.lang.String groupSid, java.lang.String userLevel, java.lang.String userState) 회원관리 목록보기 회원 체크값으로 그룹,권한,상태 값 수정 함수 박 형 민
void	updateUserPwd(org.hibernate.Session session, UserVO userVO) 사용자 비밀번호 수정 [2010-01-07 : 원서형]
void	writeElect(org.hibernate.Session session, ElectUserVO electUserVO) 선거인명부 등록 [2010-05-11 : 원서형]
void	writeElectUser(org.hibernate.Session session, ElectUserVO origUserVO) 선거인명부 사용자정보 등록 [2010-05-13 : 원서형]
void	writeOutUser(org.hibernate.Session session, UserVO userVO) 탈퇴 회원 등록
UserVO	writeUser(org.hibernate.Session session, UserVO userVO) 사용자 등록

Methods inherited from class java.lang.Object

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

Constructor Detail

UserDAO

public UserDAO()

Method Detail

getUserCount

public int getUserCount(org.hibernate.Session session,
                        java.lang.String groupCd,
                        java.lang.String userType,
                        java.lang.String officeCd,
                        java.lang.String searchType,
                        java.lang.String keyword)

User Count

Returns:

사용자 수

getUserCount

public int getUserCount(org.hibernate.Session session,
                        java.lang.String groupCd,
                        java.lang.String userType,
                        java.lang.String officeCd,
                        java.lang.String searchType,
                        java.lang.String keyword,
                        java.lang.String userStatus)

getUserList

public java.util.List<UserVO> getUserList(org.hibernate.Session session,
                                          java.lang.String groupCd,
                                          java.lang.String userType,
                                          java.lang.String officeCd,
                                          java.lang.String searchType,
                                          java.lang.String keyword,
                                          int beginRow,
                                          int rowCount,
                                          java.util.ArrayList orderByList)

User List

Parameters:

시작 - 라인 위치

라인 - 수

라인 - 수

Returns:

User List

getUserList

public java.util.List<UserVO> getUserList(org.hibernate.Session session,
                                          java.lang.String groupCd,
                                          java.lang.String userType,
                                          java.lang.String officeCd,
                                          java.lang.String searchType,
                                          java.lang.String keyword,
                                          int beginRow,
                                          int rowCount,
                                          java.util.ArrayList orderByList,
                                          java.lang.String userStatus)

getUserVisitList

public java.util.List<UserVO> getUserVisitList(org.hibernate.Session session,
                                               java.lang.String groupCd,
                                               int beginRow,
                                               int rowCount)

User List

Parameters:

시작 - 라인 위치

라인 - 수

라인 - 수

Returns:

User List

setUser

public UserVO setUser(UserVO orginVO)
               throws java.lang.Exception

사용자 정보담기

Parameters:

User - Id

Returns:

UserVO

Throws:

java.lang.Exception

getUser

public UserVO getUser(org.hibernate.Session session,
                      long userSid)
               throws java.lang.Exception

Get User Info

Parameters:

User - Id

Returns:

UserVO

Throws:

java.lang.Exception

getUserInfo

public UserVO getUserInfo(org.hibernate.Session session,
                          java.lang.String userId,
                          java.lang.String groupCd)
                   throws java.lang.Exception

Throws:

java.lang.Exception

getUser

public UserVO getUser(org.hibernate.Session session,
                      java.lang.String userId)
               throws java.lang.Exception

Get User Info

Parameters:

User - Id

User - Password

Returns:

UserVO

Throws:

java.lang.Exception

getUser

public UserVO getUser(org.hibernate.Session session,
                      java.lang.String userId,
                      java.lang.String userPw)
               throws java.lang.Exception

Throws:

java.lang.Exception

getUser

public UserVO getUser(org.hibernate.Session session,
                      java.lang.String userId,
                      java.lang.String userPw,
                      java.lang.String groupCd)
               throws java.lang.Exception

Throws:

java.lang.Exception

getUupInfoUser

public UserVO getUupInfoUser(org.hibernate.Session session,
                             java.lang.String dupInfo)
                      throws java.lang.Exception

GPIN 중복가입자 찾기

Parameters:

dupInfo -

Returns:

UserVO

Throws:

java.lang.Exception

getUserInfoSubDn

public UserVO getUserInfoSubDn(org.hibernate.Session session,
                               java.lang.String subDn)
                        throws java.lang.Exception

인증서 정보로 회원 정보 찾기

Parameters:

dupInfo -

Returns:

UserVO

Throws:

java.lang.Exception

SearchUser

public UserVO SearchUser(org.hibernate.Session session,
                         java.lang.String userName,
                         java.lang.String userRegNum)
                  throws java.lang.Exception

SearchUser 아이디 찾기

Parameters:

userName -

userRegNum -

Returns:

UserVO

Throws:

java.lang.Exception

SearchUser

public UserVO SearchUser(org.hibernate.Session session,
                         java.lang.String userId,
                         java.lang.String userName,
                         java.lang.String userRegNum)
                  throws java.lang.Exception

SearchUser 비밀번호 찾기

Parameters:

userId -

userName -

userRegNum -

Returns:

UserVO

Throws:

java.lang.Exception

SearchUser

public UserVO SearchUser(org.hibernate.Session session,
                         java.lang.String userId,
                         java.lang.String userName,
                         java.lang.String userRegNum,
                         java.lang.String userEmail)
                  throws java.lang.Exception

Throws:

java.lang.Exception

SearchUserPwd

public UserVO SearchUserPwd(org.hibernate.Session session,
                            java.lang.String userId,
                            java.lang.String userPw)
                     throws java.lang.Exception

Throws:

java.lang.Exception

SearchSUser

public UserVO SearchSUser(org.hibernate.Session session,
                          java.lang.String userName,
                          java.lang.String userRegNum,
                          java.lang.String groupCd)
                   throws java.lang.Exception

자체인증 아이디 찾기 [2010-04-16 : 원서형]

Parameters:

session -

userName -

userRegNum -

groupCd -

Returns:

Throws:

java.lang.Exception

SearchSUser

public UserVO SearchSUser(org.hibernate.Session session,
                          java.lang.String userId,
                          java.lang.String userName,
                          java.lang.String userRegNum,
                          java.lang.String groupCd)
                   throws java.lang.Exception

자체인증 비밀번호 찾기 [2010-04-16 : 원서형]

Parameters:

session -

userId -

userName -

userRegNum -

userEmail -

Returns:

Throws:

java.lang.Exception

SearchUserEId

public java.util.List<UserVO> SearchUserEId(org.hibernate.Session session,
                                            java.lang.String userName,
                                            java.lang.String userRegNum,
                                            java.lang.String userEmail)
                                     throws java.lang.Exception

Throws:

java.lang.Exception

checkId

public boolean checkId(org.hibernate.Session session,
                       java.lang.String userId)

사용자 ID Check

Parameters:

userId -

Returns:

boolean

checkCertify

public UserVO checkCertify(org.hibernate.Session session,
                           java.lang.String des)

 1. MethodName : checkcertify
 2. ClassName  : UserDAO
 3. Comment   : 메일 인증 확인 
 4. 작성자    : 박형민
 5. 작성일    : 2010. 8. 23. 오후 4:46:29
 

Parameters:

session -

des - 인증값

Returns:

boolean

writeUser

public UserVO writeUser(org.hibernate.Session session,
                        UserVO userVO)
                 throws java.lang.Exception

사용자 등록

Parameters:

userId -

Returns:

long

Throws:

java.lang.Exception

updateUser

public void updateUser(org.hibernate.Session session,
                       UserVO userVO)
                throws java.lang.Exception

사용자 수정

Parameters:

userId -

Throws:

java.lang.Exception

updateEmailUser

public void updateEmailUser(org.hibernate.Session session,
                            long userSid,
                            java.lang.String userStatus)
                     throws java.lang.Exception

이메일 인증 업데이트

 1. MethodName : updateEmailUser
 2. ClassName  : UserDAO
 3. Comment   : 
 4. 작성자    : 박형민
 5. 작성일    : 2010. 8. 24. 오후 1:28:53
 

Parameters:

session -

userSid -

userStatus -

Throws:

java.lang.Exception

changePassWord

public void changePassWord(org.hibernate.Session session,
                           java.lang.String userPw,
                           java.lang.String userId)
                    throws java.lang.Exception

패스워드 변경

Parameters:

session -

isEncypt -

userPw -

userId -

Throws:

java.lang.Exception

updateExistUser

public void updateExistUser(org.hibernate.Session session,
                            java.lang.String userId,
                            java.lang.String userRegNum)
                     throws java.lang.Exception

기존 유저 재인증 후 수정 (userId, userName, userRegNum) [2010-03-02 : 원서형]

Throws:

java.lang.Exception

updateUserPwd

public void updateUserPwd(org.hibernate.Session session,
                          UserVO userVO)
                   throws java.lang.Exception

사용자 비밀번호 수정 [2010-01-07 : 원서형]

Parameters:

userId -

Throws:

java.lang.Exception

updateOfficeUser

public void updateOfficeUser(org.hibernate.Session session,
                             UserVO userVO)
                      throws java.lang.Exception

Throws:

java.lang.Exception

deleteUser

public void deleteUser(org.hibernate.Session session,
                       UserVO userVO)

User Delete

loginTimeUpdate

public void loginTimeUpdate(org.hibernate.Session session,
                            UserVO userVO)

로그인 시간 업데이트

updateOfficeLvPs

public void updateOfficeLvPs(org.hibernate.Session session,
                             UserVO userVO)

직급,직책변경

writeOutUser

public void writeOutUser(org.hibernate.Session session,
                         UserVO userVO)
                  throws java.lang.Exception

탈퇴 회원 등록

Throws:

java.lang.Exception

getOutUserCount

public int getOutUserCount(org.hibernate.Session session)

탈퇴 회원 count

Returns:

사용자 수

getOutUserList

public java.util.List<OutMemberVO> getOutUserList(org.hibernate.Session session,
                                                  int beginRow,
                                                  int rowCount)

탈퇴 회원 목록

Parameters:

시작 - 라인 위치

출력 - 수

Returns:

User List

getElectUserCount

public int getElectUserCount(org.hibernate.Session session,
                             java.lang.String searchType,
                             java.lang.String keyword,
                             java.lang.String startDt,
                             java.lang.String endDt)
                      throws java.lang.Exception

선거인명부 Count [2010-05-11 : 원서형]

Parameters:

session -

searchType -

keyword -

Returns:

Throws:

java.lang.Exception

getElectUserLogCount

public int getElectUserLogCount(org.hibernate.Session session,
                                java.lang.String searchType,
                                java.lang.String keyword,
                                java.lang.String startDt,
                                java.lang.String endDt)
                         throws java.lang.Exception

선거인명부 열람 Count [2010-05-20 : 원서형]

Parameters:

session -

searchType -

keyword -

Returns:

Throws:

java.lang.Exception

getElectList

public java.util.List<ElectUserVO> getElectList(org.hibernate.Session session,
                                                java.lang.String searchType,
                                                java.lang.String keyword,
                                                java.lang.String startDt,
                                                java.lang.String endDt,
                                                int beginRow,
                                                int rowCount,
                                                java.util.List<OrderBy> orderByList)
                                         throws java.lang.Exception

선거인명부 목록 [2010-05-11 : 원서형]

Parameters:

session -

searchType -

keyword -

beginRow -

rowCount -

orderByList -

Returns:

Throws:

java.lang.Exception

getElectLogList

public java.util.List<ElectUserLogVO> getElectLogList(org.hibernate.Session session,
                                                      java.lang.String searchType,
                                                      java.lang.String keyword,
                                                      java.lang.String startDt,
                                                      java.lang.String endDt,
                                                      int beginRow,
                                                      int rowCount,
                                                      java.util.List<OrderBy> orderByList)
                                               throws java.lang.Exception

선거인명부 열람 목록 [2010-05-20 : 원서형]

Parameters:

session -

searchType -

keyword -

beginRow -

rowCount -

orderByList -

Returns:

Throws:

java.lang.Exception

writeElect

public void writeElect(org.hibernate.Session session,
                       ElectUserVO electUserVO)

선거인명부 등록 [2010-05-11 : 원서형]

Parameters:

session -

electUserVO -

deleteElectUser

public void deleteElectUser(org.hibernate.Session session,
                            ElectUserVO electUserVO)

선거인명부 사용자정보 삭제 [2010-05-12 : 원서형]

Parameters:

session -

electUserVO -

initElect

public void initElect(org.hibernate.Session session)

선거인명부 초기화 [2010-05-11 : 원서형]

Parameters:

session -

getElectUser

public ElectUserVO getElectUser(org.hibernate.Session session,
                                long userSid)
                         throws java.lang.Exception

선거인명부 사용자 정보 [2010-05-13 : 원서형]

Parameters:

session -

userSid -

Returns:

Throws:

java.lang.Exception

getElectUser

public ElectUserVO getElectUser(org.hibernate.Session session,
                                java.lang.String userBirthDay,
                                java.lang.String userRegNum,
                                java.lang.String userName)
                         throws java.lang.Exception

선거인명부 사용자정보 [2010-05-11 : 원서형]

Parameters:

session -

userBirthDay -

userRegNum -

userName -

Returns:

Throws:

java.lang.Exception

getElectUserList

public java.util.List<ElectUserVO> getElectUserList(org.hibernate.Session session,
                                                    java.lang.String userBirthDay,
                                                    java.lang.String userRegNum,
                                                    java.lang.String userName)
                                             throws java.lang.Exception

선거인명부 사용자정보 리스트 [2010-05-11 : 원서형]

Parameters:

session -

userBirthDay -

userRegNum -

userName -

Returns:

Throws:

java.lang.Exception

checkElectUser

public java.util.List<ElectUserVO> checkElectUser(org.hibernate.Session session,
                                                  java.lang.String userBirthDay,
                                                  java.lang.String userRegNum,
                                                  java.lang.String userName)
                                           throws java.lang.Exception

Throws:

java.lang.Exception

checkElectUserLog

public int checkElectUserLog(org.hibernate.Session session,
                             java.lang.String userBirthDay,
                             java.lang.String userRegNum,
                             java.lang.String userName,
                             java.lang.String date)
                      throws java.lang.Exception

Throws:

java.lang.Exception

writeElectUser

public void writeElectUser(org.hibernate.Session session,
                           ElectUserVO origUserVO)
                    throws java.lang.Exception

선거인명부 사용자정보 등록 [2010-05-13 : 원서형]

Parameters:

session -

origUserVO -

Throws:

java.lang.Exception

updateElectUser

public void updateElectUser(org.hibernate.Session session,
                            ElectUserVO electUserVO)
                     throws java.lang.Exception

선거인명부 사용자정보 수정 [2010-05-13 : 원서형]

Parameters:

session -

electUserVO -

Throws:

java.lang.Exception

updateElectRegDate

public void updateElectRegDate(org.hibernate.Session session,
                               ElectUserVO electUserVO)
                        throws java.lang.Exception

Throws:

java.lang.Exception

updateElectLogRegDate

public void updateElectLogRegDate(org.hibernate.Session session,
                                  ElectUserVO electUserVO)
                           throws java.lang.Exception

Throws:

java.lang.Exception

updateUserCheck

public void updateUserCheck(org.hibernate.Session session,
                            long userSid,
                            java.lang.String groupSid,
                            java.lang.String userLevel,
                            java.lang.String userState)
                     throws java.lang.Exception

회원관리 목록보기 회원 체크값으로 그룹,권한,상태 값 수정 함수 박 형 민

Parameters:

session -

userSid - 회원 기본키

groupSid - 변경 그룹

userLevel - 변경 레벨

userState - 변경 상태

Throws:

java.lang.Exception