[스프링 -1]Spring 회원가입하기 (DB저장,mapper,mybatis)

 

0.처음으로 Vo  페이지 만들기

 멤버 변수를 지정해준다음에 setter , getter 만들어주세요

public class MemberVo {
    private int member_idx;
    private String member_id;
    private String member_name;
    private String member_pw;
    private String member_phone;
    private Date member_regdate;
    
    
    private int member_grade;
    private String member_delyn;
    private Date member_deldate;
    
    
    
    
    public int getMember_idx() {
        return member_idx;
    }
    public void setMember_idx(int member_idx) {
        this.member_idx = member_idx;
    }
    public String getMember_id() {
        return member_id;
    }
    public void setMember_id(String member_id) {
        this.member_id = member_id;
    }
    public String getMember_name() {
        return member_name;
    }
    public void setMember_name(String member_name) {
        this.member_name = member_name;
    }
    public String getMember_pw() {
        return member_pw;
    }
    public void setMember_pw(String member_pw) {
        this.member_pw = member_pw;
    }
    public String getMember_phone() {
        return member_phone;
    }
    public void setMember_phone(String member_phone) {
        this.member_phone = member_phone;
    }
    public Date getMember_regdate() {
        return member_regdate;
    }
    public void setMember_regdate(Date member_regdate) {
        this.member_regdate = member_regdate;
    }
    public int getMember_grade() {
        return member_grade;
    }
    public void setMember_grade(int member_grade) {
        this.member_grade = member_grade;
    }
    public String getMember_delyn() {
        return member_delyn;
    }
    public void setMember_delyn(String member_delyn) {
        this.member_delyn = member_delyn;
    }
    public Date getMember_deldate() {
        return member_deldate;
    }
    public void setMember_deldate(Date member_deldate) {
        this.member_deldate = member_deldate;
    }
 

1. JSP 페이지 구현하기 ( 간단한 FORM 객체 )

 
<form name="joinForm" action="/spring/joinProcess.do" method="post">
    <input type="email" name="member_id" id="member_id" value="" maxlength="80" placeholder="아이디(이메일)" /><br/>
    <input type="button" id="checkId" value="중복검사"><br/>
    <div><span id="result_checkId" style="font-size:12px;"></span></div>
    
    <input type="password" name="member_pw"  value="" maxlength="20" placeholder="비밀번호"><p/>            
    <input type="text" name="member_name" maxlength="40" value="" placeholder="이름"><p/>
    <input type="tel" name="member_phone"  value="" autocomplete="off" placeholder="휴대폰 번호"><p/>
    <input type="submit" value="가입하기">
    <input type="reset"  value="취소하기">
</form> 

저는 /Spring/joinprocess.do 로 보내보겠습니다.

2. Controller [ JSP 페이지 >> Controller ( form action mapping 이동 )

@PostMapping("/joinProcess.do")
public String joinProcess(MemberVo memberVo) {  
//form 에서 전송된 VO 값이 memberVo 에저장
 
int result=memberService.join(memberVo);//int 로 받는 이유는 DB 에서 정상적으로//회원가입이 되면 "1"행이 실행된거 알기위해서에요
    String viewPage = null;
    if(result==1) { // DB 저장 성공시실행
    viewPage = "redirect:/home.do";
    }else{ // DB저장 실패시 실행
    viewPage = "member/join";
        }
        return viewPage;
    }

 

만들어준 MemberVO memberVo 값에 JSP 에서 name 값이 자동으로 저장되어서

 

int result = memberService.join(memberVo);  join 멤버 값을 넣어줍니다.

 

3. Controller 에서 Service page 로 memberVo 값이동

 

public int join(MemberVo memberVo) {
int result=0;//변수 0 으로 초기화선언
result = memberDao.joinMember(memberVo);
        
        return result;
    }

@Repository
public class MemberDao {
    
    private SqlSession sqlSession;
    
    public static final String MAPPER = "ezen.dev.spring.member";
    
    @Autowired
    public MemberDao(SqlSession sqlSession) {
        this.sqlSession = sqlSession;
    }
    
    public int joinMember(MemberVo memberVo) {
    
        
        return sqlSession.insert(MAPPER+".joinMember", memberVo);
   }

<mapper namespace = "ezen.dev.spring.member">
 
    <insert id="joinMember" parameterType="memberVo">
        insert into member(member_id, member_pw, member_name, member_phone) 
         values(#{member_id}, #{member_pw}, #{member_name}, #{member_phone})
    </insert>

memberVO 값을 받아서 DB 실행을 시켜 결과 값이 나오면 됨

 

6.정상적으로 회원가입 완료 !!!

 

 

감사합니다~