Servlet & JSP day17 - MVC 모델을 응용한 회원정보 관리(로그인)

LoginServlet.java

☞ package : member.servlet

☞ type : Servlet - Controller 역할

package member.servlet;

import java.io.IOException;
import java.sql.SQLException;

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

import member.dto.MemberDTO;
import member.model.service.MemberManagerService;

public class LoginServlet extends HttpServlet {
 private static final long serialVersionUID = 1L;

 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  doPost(request, response);
 }
 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  String id = request.getParameter("id");
  String password = request.getParameter("password");
  HttpSession session = request.getSession();
  MemberManagerService mms = MemberManagerService.getInstance();
  String resUrl = null;
  
  try {
   MemberDTO mto = mms.getMemberById(id);
   if(mto !=null) {
    if(password.equals(mto.getPassword())) {
     session.setAttribute("mto", mto);
     resUrl = "/res/login_success.jsp";
    } else {
     session.setAttribute("error_message", "비밀번호가 일치하지 않습니다.");
     resUrl = "/login_form.jsp";
    }
   } else {
    session.setAttribute("error_message", "ID가 일치하지 않습니다,");
    resUrl = "/login_form.jsp";
   }
  } catch (SQLException e) {
   e.printStackTrace();
   session.setAttribute("error_message", e.getMessage());
   resUrl = "/res/error.jsp";
  }
  
  RequestDispatcher rdp = request.getRequestDispatcher(resUrl);
  rdp.forward(request, response);
 }
}

 

MemberDAO.java

☞ package : member.model.dao

☞ type : class - Data Access Object(Model 역할)

package member.model.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import member.dto.MemberDTO;
import member.model.service.MemberManagerService;
import member.util.DatabaseUtility;

public class MemberDAO {

 private static MemberDAO instance = new MemberDAO();
 private DatabaseUtility dbUtil;
 public static MemberDAO getInstance() {
  return instance;
 }
 private MemberDAO() {
  dbUtil = DatabaseUtility.getInstance();
 }
 public MemberDTO selectMemberById(String id) throws SQLException {
  MemberDTO mto = null;
  Connection conn =null;
  PreparedStatement pstmt =null;
  ResultSet rset = null;
  String sql = "select id, password, name, register_number1, register_number2, mileage from member where id=?";
  
  try {
   conn = dbUtil.getDataSource().getConnection();
   pstmt = conn.prepareStatement(sql);
   pstmt.setString(1, id);
   rset = pstmt.executeQuery();
   if(rset.next())
   {
    mto = new MemberDTO(rset.getString(1), rset.getString(2), rset.getString(3), rset.getString(4), rset.getString(5), rset.getInt(6));
   }
  } finally {
   if(rset !=null) rset.close();
   if(pstmt !=null) pstmt.close();
   if(conn !=null) pstmt.close();
  }
  return mto;
 }

 

MemberManagerService.java

☞ package : member.model.service

☞ type : class - Business Logic을 처리(Model역할)

package member.model.service;

import java.sql.SQLException;
import java.util.ArrayList;

import member.dto.MemberDTO;
import member.exception.DuplicatedIdException;
import member.exception.DuplicatedRegisterNumberException;
import member.model.dao.MemberDAO;

public class MemberManagerService {

private static MemberManagerService instance = new MemberManagerService();
private MemberDAO dao;
private MemberManagerService() {
dao = MemberDAO.getInstance();
}
public static MemberManagerService getInstance() {
return instance;
}

public MemberDTO getMemberById(String id) throws SQLException {
return dao.selectMemberById(id);
}

}

 

login_form.jsp

☞ folder : WebContent

☞ 로그인을 위한 입력 폼 구성

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<jsp:include page="/menu.jsp"/>
로그인 폼<br>
<c:if test="${ sessionScope.error_message != null }">
 <font color="red" size="3">${sessionScope.error_message }</font>
</c:if>
 <form action="/${initParam.context_root }/login" method="post">
  ID : <input type="text" name="id" size="10"><br>
  PWD : <input type="password" name="password" size="10" maxlength="10"><br>
  <input type="submit" value="로그인">
 </form>
 <form action="/${initParam.context_root }/logout" method="post">
  <input type="submit" value="로그아웃">
 </form>

</body>
</html>

 

login_success.jsp

☞ folder : WebContent/res

☞ type : 데이터베이스에 등록되어 있는 ID와 Password를 입력된 ID와 Password와 비교하여 일치하면 Login_success.jsp를 출력

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<jsp:include page="/menu.jsp"/>
${sessionScope.mto.id }님이 로그인 했습니다.<br>
<a href="/${initParam.context_root }/logout">로그아웃</a>
<a href="/${initParam.context_root }/getMemberInfo">회원정보조회</a>
<a href="/${initParam.context_root }/removeMember">회원탈퇴</a>
</body>
</html>