[JSP] 로그인, 회원가입, 아이디 중복검사 기능 구현해보기

티스토리 뷰

백엔드/JSP

[JSP] 로그인, 회원가입, 아이디 중복검사 기능 구현해보기

doeunnkimm 2023. 4. 20. 11:30

🚀 로그인, 회원가입, 아이디 중복검사 기능 구현해보기

이번 글에서는 JSP로 위 3가지 기능에 대해 구현해 보겠습니다 :) 작업 순서를 매겨가면서 정리해보겠습니다.

우선 미리 폴더 구조는 아래와 같이 진행했습니다.

0. MyBatis 설정, Action 인터페이스, Result 클래스 생성

📜 src/com.app.mybatis.config (package) / config.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "https://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>
	<settings>
		<setting name="mapUnderscoreToCamelCase" value="true"/>
	</settings>

	<environments default="mysql">
		<environment id="mysql">
			<transactionManager type="JDBC"/>
			<dataSource type="POOLED">
				<property name="driver" value="com.mysql.cj.jdbc.Driver"/>
				<property name="url" value="jdbc:mysql://localhost:3306/app"/>
				<property name="username" value="root"/>
				<property name="password" value="1234"/>
			</dataSource>
		</environment>
	</environments>
</configuration>

📜 src/com.app.mybatis.config (package) / MyBatisConfig.java

package com.app.mybatis.config;

import java.io.IOException;
import java.io.Reader;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

public class MyBatisConfig {
	private static SqlSessionFactory sqlSessionFactory;
	
	static {
		String resource = "com/app/mybatis/config/config.xml";
		try {
			Reader reader = Resources.getResourceAsReader(resource);
			sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
		} catch (IOException e) {
			e.printStackTrace();
		}
	}
	
	public static SqlSessionFactory getSqlSessionFactory() {
		return sqlSessionFactory;
	}
}

📜 src/com.app (package) / Action.java

package com.app;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public interface Action {
	public Result execute(HttpServletRequest req, HttpServletResponse rep) throws IOException, ServletException;
}

📜 src/com.app (package) / Result.java

package com.app;

public class Result {
	private String path;
	private boolean isRedirect;
	
	public Result() {;}

	public String getPath() {
		return path;
	}

	public void setPath(String path) {
		this.path = path;
	}

	public boolean isRedirect() {
		return isRedirect;
	}

	public void setRedirect(boolean isRedirect) {
		this.isRedirect = isRedirect;
	}
}

1. Table 만들기

create database app;
use app;

create table tbl_member(
	member_id int unsigned auto_increment primary key,
	member_identification varchar(500) not null unique,
	member_password varchar(500) not null,
	member_name varchar(500) not null,
	member_birth date not null,
	member_phone varchar(500) not null,
	member_email varchar(500) not null unique
);

2. VO 객체 만들기

📜 src/com.app.member.domain (package) / MemberVo.java

package com.app.member.domain;

public class MemberVO {
	private Long memberId;
	private String memberIdentification;
	private String memberPassword;
	private String memberName;
	private String memberBirth;
	private String memberPhone;
	private String memberEmail;
	
	public MemberVO() {;}

	public Long getMemberId() {
		return memberId;
	}

	public void setMemberId(Long memberId) {
		this.memberId = memberId;
	}

	public String getMemberIdentification() {
		return memberIdentification;
	}

	public void setMemberIdentification(String memberIdentification) {
		this.memberIdentification = memberIdentification;
	}

	public String getMemberPassword() {
		return memberPassword;
	}

	public void setMemberPassword(String memberPassword) {
		this.memberPassword = memberPassword;
	}

	public String getMemberName() {
		return memberName;
	}

	public void setMemberName(String memberName) {
		this.memberName = memberName;
	}

	public String getMemberBirth() {
		return memberBirth;
	}

	public void setMemberBirth(String memberBirth) {
		this.memberBirth = memberBirth;
	}

	public String getMemberPhone() {
		return memberPhone;
	}

	public void setMemberPhone(String memberPhone) {
		this.memberPhone = memberPhone;
	}

	public String getMemberEmail() {
		return memberEmail;
	}

	public void setMemberEmail(String memberEmail) {
		this.memberEmail = memberEmail;
	}

	@Override
	public String toString() {
		return "MemberVO [memberId=" + memberId + ", memberIdentification=" + memberIdentification + ", memberPassword="
				+ memberPassword + ", memberName=" + memberName + ", memberBirth=" + memberBirth + ", memberPhone="
				+ memberPhone + ", memberEmail=" + memberEmail + "]";
	}

	@Override
	public int hashCode() {
		final int prime = 31;
		int result = 1;
		result = prime * result + ((memberId == null) ? 0 : memberId.hashCode());
		return result;
	}

	@Override
	public boolean equals(Object obj) {
		if (this == obj)
			return true;
		if (obj == null)
			return false;
		if (getClass() != obj.getClass())
			return false;
		MemberVO other = (MemberVO) obj;
		if (memberId == null) {
			if (other.memberId != null)
				return false;
		} else if (!memberId.equals(other.memberId))
			return false;
		return true;
	}
}

3. Mapper.xml 만들고 config.xml에 등록하기

📜 src/com.app.mybatis.mapper (package) / memberMapper.xml

해당 파일에서는 비즈니스 로직을 구현하면서 필요한 DB에 접근하는 쿼리문을 여기에 작성하고 DAO에서는 바로 불러서 사용하기만 할 것입니다. 우선 틀만 작성해 둡니다.

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "https://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="member">
</mapper>

이제 여기에 작성한 쿼리문을 MyBatis가 알 수 있도록 MyBatis 관련 패키지에 있는 config.xml에 등록해줍니다.

📜 src/com.app.mybatis.config (package) / config.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "https://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>
	<settings>
		<setting name="mapUnderscoreToCamelCase" value="true"/>
	</settings>

	<environments default="mysql">
		<environment id="mysql">
			<transactionManager type="JDBC"/>
			<dataSource type="POOLED">
				<property name="driver" value="com.mysql.cj.jdbc.Driver"/>
				<property name="url" value="jdbc:mysql://localhost:3306/app"/>
				<property name="username" value="root"/>
				<property name="password" value="1234"/>
			</dataSource>
		</environment>
	</environments>
    
        <mappers>
                <mapper resource="com/mybatis/mapper/memberMapper.xml"/>
        </mappers>
</configuration>

4. Mapper에서 SQL문 작성하기 (1) 회원가입을 위한

📜 src/com.app.mybatis.mapper (package) / memberMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "https://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="member">
	<insert id="insert">
		insert into tbl_member
		(member_identification, member_password, member_name, member_birth, member_phone, member_email)
		values(#{memberIdentification}, #{memberPassword}, #{memberName}, #{memberBirth}, #{memberPhone}, #{memberEmail})
	</insert>
</mapper>

5. DAO 만들어서 서비스 관련 메소드 선언하기 (1) 회원가입을 위한

📜 src/com.app.member.dao (package) / MemberDAO.java

package com.app.member.dao;

public class MemberDAO {
    public SqlSession sqlSession;
    
    public MemberDAO() {
        sqlSession = MyBatisConfig.getSqlSessionFactory().openSession(true);
    }
    
    // 회원가입
    public void insert(MemberVO memberVO) {
        sqlSession.insert("member.insert", memberVO);
    }
}

6. Controller 만들기 with Action 인터페이스 (1) 회원가입을 위한

Controller 이름의 경우 서비스명 + (연산이 필요한 Controller라면 Ok) + Controller 로 짓는 걸로 했습니다.

📜 src/com.app.member.controller (package) / JoinOkController.java

package com.app.member.controller;

public class JoinOkController implements Action {
    @Override
    public Result execute(HttpServletRequest req, HttpServletResponse resp) throw IOException, ServletException {
        MemberDAO memberDAO = new MemberDAO();
        MemberVO memberVO = new MemberVO();
        Result result = new Result();
        
        memberVO.setMemberIdentification(req.getParameter("memberIdentification"));
        memberVO.setMemberPassword(req.getParameter("memberPassword"));
        memberVO.setMemberName(req.getParameter("memberName"));
        memberVO.setMemberBirth(req.getParameter("memberBirth"));
        memberVO.setMemberPhone(req.getParameter("memberPhone"));
        memberVO.setMemberEmail(req.getParameter("memberEmail"));
        
        memberDAO.insert(memberVO);
        
        result.setRedirect(true);
        result.setPath(req.getContextPath() + "/login.member");
    }
}

7. FrontController에서 알맞은 Controller의 execute()를 사용한다

각 클라이언트들은 Front Controller에게 요청을 보내고, Front Controller는 각 요청에 맞는 컨트롤러를 찾아서 호출시킵니다. 공통 코드에 대해서는 Front Controller에서 처리하고, 서로 다른 코드들만 각 Controller에서 처리할 수있도록 합니다.

📜 src/com.app.member (package) / MemberFrontController.java

package com.app.member;

public class MemberFrontController extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("UTF-8");
        
        String target = req.getRequestURI().replace(req.getContextPath() + "/", "").split("\\.")[0];
        Result result = null;
        
        if(target.equals("joinOk")) {
           result = new JoinOkController().excute(req, resp);
        }
        
        if(result !== null) {
            if(result.isRedirect()) {
                resp.sendRedirect(result.getPath());
            } else {
                req.getRequestDispatcher(result.getPath()).forward(req, resp);
            }
        }
    }
    
    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) {
        doGet(req, resp);
    }
}

여기까지 하면 회원가입 구현을 끝이고, 이제 앞으로 서비스 하나를 구현하려고 하면 다시 4로 돌아가면서 비즈니스 로직을 작성하면 되겠습니다 :)

4. Mapper에서 SQL문 작성하기 (2) 로그인을 위한 (3) 아이디 중복검사를 위한

📜 src/com/app.mybatis.mapper (package) / memberMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "https://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="member">
	<insert id="insert">
		insert into tbl_member
		(member_identification, member_password, member_name, member_birth, member_phone, member_email)
		values(#{memberIdentification}, #{memberPassword}, #{memberName}, #{memberBirth}, #{memberPhone}, #{memberEmail})
	</insert>
    
    	<select id="login" resultType="long">
		select member_id from tbl_member 
		where member_identification = #{memberIdentification} and member_password = #{memberPassword}
	</select>
	
	<select id="selectIdentification" resultType="string">
		select member_identification from tbl_member where member_identification = #{memberIdentification}
	</select>
</mapper>

5. DAO 만들어서 서비스 관련 메소드 선언하기 (2)로그인을 위한 (3) 아이디 중복검사를 위한

📜 src/com.app.member.dao (package) / MemberDAO.java

package com.app.member.dao;

import java.util.HashMap;

import org.apache.ibatis.session.SqlSession;

import com.app.member.domain.MemberVO;
import com.app.mybatis.config.MyBatisConfig;

public class MemberDAO {
	public SqlSession sqlSession;
	
	public MemberDAO() {
		sqlSession = MyBatisConfig.getSqlSessionFactory().openSession(true);
	}
	
//	회원가입
	public void insert(MemberVO memberVO) {
		sqlSession.insert("member.insert", memberVO);
	}
	
//	아이디 중복검사
	public String selectIdentification(String memberIdentification) {
		return sqlSession.selectOne("member.selectIdentification", memberIdentification);
	}
	
//	로그인
	public Long login(String memberIdentification, String memberPassword) {
		HashMap<String, String> loginMap = new HashMap<String, String>();
		loginMap.put("memberIdentification", memberIdentification);
		loginMap.put("memberPassword", memberPassword);
		
		return sqlSession.selectOne("member.login", loginMap);
	}
}

6. Controller 만들기 (2)로그인을 위한 (3)아이디 중복검사를 위한

📜 src/ com.app.member.controller (package) / LoginOkConroller.java

package com.app.member.controller;

public class LoginOkController implements Action {
    @Override
    public Result execute(HttpServletRequest req, HttpServletResponse resp) throws IOException, ServletException {
        MemberDAO memberDAO = new MemberDAO();
        Long memberId = memberDAO.login(req.getParameter("memberIdentification"), req.getParameter("memberPassword"));
        HttpSession session = req.getSession();
        Result result = new Result();
        
        result.setRedirect(true);
        
        if(memberId == null) {
            // 로그인 실패
            result.setPath(req.getContextPath() + "/login.member?login=false");
        } else {
            session.setAttribute("memberId", memberId);
            result.setPath(req.getContextPath() + "/list.board");
        }
        return result;
    }
}

📜 src/ com.app.member.controller (package) / CheckIdOkController.java

package com.app.member.controller;

public class CheckIdOkController implements Action {
    @Override
    public Result execute(HttpServeltRequest req, HttpServletResponse resp) throws IOException, ServletException {
        MemberDAO memberDAO = new MemberDAO();
        String memberIdentification = memberDAO.selectIdentification(req.getParameter("memberIdentification"));
        boolean check = memberIdentification == null;
        
        return null;
    }
}

7. FrontController에서 알맞은 Controller의 execute()를 사용한다

📜 src/com.app.member (package) / MemberFrontController.java

package com.app.member;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.app.Result;
import com.app.member.controller.JoinOkController;
import com.app.member.controller.LoginOkController;

public class MemberFrontController extends HttpServlet {

	@Override
	protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		req.setCharacterEncoding("UTF-8");
		
		String target = req.getRequestURI().replace(req.getContextPath() + "/", "").split("\\.")[0];
		Result result = null;
		
		if(target.equals("join")){
			result = new Result();
			result.setPath("templates/member/join.jsp");
			
		} else if(target.equals("joinOk")){
			result = new JoinOkController().execute(req, resp);
			
		} else if(target.equals("login")){
			result = new Result();
			result.setPath("templates/member/login.jsp");
			
		} else if(target.equals("loginOk")) {
			result = new LoginOkController().execute(req, resp);
			
		} else if(target.equals("logout")) {
			req.getSession().invalidate();
			result = new Result();
			result.setPath("templates/member/login.jsp");
		}
		
		
		if(result != null) {
			if(result.isRedirect()) {
				resp.sendRedirect(result.getPath());
			}else {
				req.getRequestDispatcher(result.getPath()).forward(req, resp);
			}
		}
	}
	
	@Override
	protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
		doGet(req, resp);
	}
}

위처럼 0, 1, 2, 3까지는 기본세팅으로 해놓고 새로운 서비스가 필요할 때마다 4, 5, 6, 7을 반복하면 되겠습니다 :)

728x90

LIST

'백엔드 > JSP' 카테고리의 다른 글

[JSP] JSP로 게시판 목록 조회 기능 구현 (0)	2023.04.25
[JSP] MVC 패턴이란? (0)	2023.04.20
[JSP] 서블릿(Servlet)이란 ? (0)	2023.04.19
[JSP] MyBatis란 ? (0)	2023.04.19
[JSP] JSP로 사칙연산 계산기 만들기 (0)	2023.04.19

250x250

공지사항

최근에 올라온 글

최근에 달린 댓글

Total

Today

Yesterday

링크

TAG more

« 2024/11 »
일	월	화	수	목	금	토
					1	2
3	4	5	6	7	8	9
10	11	12	13	14	15	16
17	18	19	20	21	22	23
24	25	26	27	28	29	30

글 보관함

doeunn.log

티스토리 뷰