Servlet & JSP day11 - 회원 정보 프로그램(회원탈퇴<DB연동>)

RemoveMemberServlet.java

☞ package : member.servlet

☞ url-pattern : /removeMember

☞ session scope에 MemberDTO 객체가 존재하는지 조회(로그인 여부)하여 존재하지 않는 경우 로그인 페이지로 이동하고 존재하는 경우(로그인 상태)에는 session scope에 존재하는 MemberDTO를 조회하여 조회한 객체의 id 정보를 통해 database에 그 id와 관련된 MemberDTO객체를 invalidate() 메소드를 통해 소멸시킨다.

 

소스보기

package member.servlet;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletContext;
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.util.DatabaseUtility;

public class RemoveMemberServlet 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 resUrl = null;
  HttpSession session = request.getSession();
  MemberDTO dto = (MemberDTO)session.getAttribute("dto");
  
  ServletContext ctx = getServletContext();
  String url = ctx.getInitParameter("url");
  String user = ctx.getInitParameter("user");
  String password = ctx.getInitParameter("password");
  
  Connection conn =null;
  PreparedStatement pstmt = null;
  String sql = "delete from member where id = ?";
  
  if(dto == null) {
   resUrl = "/login_form.jsp";
  }
  try {
   conn = DriverManager.getConnection(url, user, password);
   
   pstmt = conn.prepareStatement(sql);
   pstmt.setString(1, dto.getId());
   pstmt.executeUpdate();
   resUrl = "/index.html";
   session.invalidate();
  } catch (SQLException e) {
   e.printStackTrace();
   session.setAttribute("error_message" , e.getMessage());
   resUrl = "/res/error.jsp";
  } finally {
   DatabaseUtility.close(pstmt, conn);
  }
  RequestDispatcher rdp = request.getRequestDispatcher(resUrl);
  rdp.forward(request, response);
  
 }

}