회원가입

일반회원 가입 : 아작스 이용

   아이디 중복검사는 아작스 사용

 

SQL

회원가입할 때는 JOIN 패키지 사용

1. JoinVO를 작성한다.

package egovframework.let.join.service;

import java.io.Serializable;

import egovframework.com.cmm.ComDefaultVO;

public class JoinVO extends ComDefaultVO implements Serializable {

	//아이디
	private String emplyrId;
	//이름
	private String userNm;
	//비밀번호
	private String password;
	//비밀번호 힌트
	private String passwordHint;
	//비밀번호 정답
	private String passwordCnsr;
	//사용자상태코드
	private String emplyrSttusCode;
	//회원고유ID
	private String esntlId;
	//로그인 타입
	private String loginType;
	//가입일자
	private java.util.Date sbscrDe;
	public String getEmplyrId() {
		return emplyrId;
	}
	public void setEmplyrId(String emplyrId) {
		this.emplyrId = emplyrId;
	}
	public String getUserNm() {
		return userNm;
	}
	public void setUserNm(String userNm) {
		this.userNm = userNm;
	}
	public String getPassword() {
		return password;
	}
	public void setPassword(String password) {
		this.password = password;
	}
	public String getPasswordHint() {
		return passwordHint;
	}
	public void setPasswordHint(String passwordHint) {
		this.passwordHint = passwordHint;
	}
	public String getPasswordCnsr() {
		return passwordCnsr;
	}
	public void setPasswordCnsr(String passwordCnsr) {
		this.passwordCnsr = passwordCnsr;
	}
	public String getEmplyrSttusCode() {
		return emplyrSttusCode;
	}
	public void setEmplyrSttusCode(String emplyrSttusCode) {
		this.emplyrSttusCode = emplyrSttusCode;
	}
	public String getEsntlId() {
		return esntlId;
	}
	public void setEsntlId(String esntlId) {
		this.esntlId = esntlId;
	}
	public String getLoginType() {
		return loginType;
	}
	public void setLoginType(String loginType) {
		this.loginType = loginType;
	}
	public java.util.Date getSbscrDe() {
		return sbscrDe;
	}
	public void setSbscrDe(java.util.Date sbscrDe) {
		this.sbscrDe = sbscrDe;
	}	
}

 

2. Joinservice를 작성한다.

package egovframework.let.join.service;


public interface JoinService {
	//회원가입
	public String insertJoin(JoinVO vo) throws Exception;
	
	//아이디 중복체크
	public int duplicateCheck(JoinVO vo) throws Exception;
}

3. JoinServiceImpl을 작성한다.

package egovframework.let.join.service.impl;

import egovframework.let.join.service.JoinService;
import egovframework.let.join.service.JoinVO;
import egovframework.let.utl.sim.service.EgovFileScrty;
import egovframework.rte.fdl.cmmn.EgovAbstractServiceImpl;
import egovframework.rte.fdl.idgnr.EgovIdGnrService;


import javax.annotation.Resource;

public class JoinServiceImpl extends EgovAbstractServiceImpl 
implements JoinService {
	
	@Resource(name = "joinMapper")
	private JoinMapper joinMapper;
	
	@Resource(name = "egovCrudIdGnrService")
	private EgovIdGnrService idgenService;
	
	//회원등록
	@Override
	public String insertJoin(JoinVO vo) throws Exception {
		String esntlId = idgenService.getNextStringId();
		vo.setEsntlId(esntlId);
		
		//입력한 비밀번호를 암호화한다.
		String enpassword = EgovFileScrty.encryptPassword(vo.getPassword(), vo.getEmplyrId());
		vo.setPassword(enpassword);
		
		joinMapper.insertJoin(vo);
		return esntlId;
	}
	
	//ID중복체크
	@Override
	public int duplicateCheck(JoinVO vo) throws Exception {
		return joinMapper.duplicateCheck(vo);
	}
	
}

4.JoinMapper를 작성한다,

package egovframework.let.join.service.impl;

import egovframework.let.join.service.JoinVO;
import egovframework.rte.psl.dataaccess.mapper.Mapper;



@Mapper("joinMapper")
public interface JoinMapper {
	
	//회원등록
	public void insertJoin(JoinVO vo) throws Exception;
	
	//Id중복체크
	int duplicateCheck(JoinVO vo) throws Exception;

}

5.context-idgen.xml를 작성한다.

 <!-- JOIN START -->
    <bean name="joinIdGnrService" class="egovframework.rte.fdl.idgnr.impl.EgovTableIdGnrServiceImpl"
     destroy-method="destroy">
        <property name="dataSource" ref="egov.dataSource" />
        <property name="strategy"   ref="joinStrategy" />
        <property name="blockSize"  value="10"/>
        <property name="table"      value="IDS"/>
        <property name="tableName"  value="ESNTL_ID"/>
    </bean> 
    
    <bean name="joinStrategy"
         class="egovframework.rte.fdl.idgnr.impl.strategy.EgovIdGnrStrategyImpl">
        <property name="prefix" value="ESNTL_" />
        <property name="cipers" value="14" />
        <property name="fillChar" value="0" />
    </bean>  
    <!-- JOIN END-->