게시판 - webstudy-board - 회원탈퇴

1. Template

1) WebContent - view - template - sidebar.jsp 수정

<p><a href="${pageContext.request.contextPath}/DispatcherServlet?command=deletePage">회원탈퇴</a></p>

 

2. View

1) WebContent - view - member - delete.jsp 추가

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <div class="card"> <form action="DispatcherServlet" method="post"> <input type="hidden" name="command" value="delete"> <h3>회원탈퇴</h3> <h4>아이디 패스워드를 입력하세요</h4> <table> <tr> <td>아이디</td> <td><input type="text" name="clientId" value="${sessionScope.clientDTO.clientId}" readonly="readonly"></td> </tr> <tr> <td>비밀번호</td> <td><input type="password" name="clientPassword" ></td> </tr> <tr rowspan="2"> <td><input type="submit" value="탈퇴"/></td> </tr> </table> </form> </div>

2) WebContent - view - member - delete_result.jsp 추가

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <script> alert("탈퇴되셨습니다."); location.href="http://localhost:8080/webstudy-board/"; </script>

1) WebContent - view - member - checkClient_fail.jsp 추가

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <script> alert("패스워드가 맞지 않습니다."); location.href="http://localhost:8080/webstudy-board/"; </script>

 

3. Model

1) src - model.ClientDAO.java에  checkClient 메소드 추가

//5. 회원 아이디 패스워드 체크 public int checkClient(String clientId, String clientPassword) throws SQLException { Connection con = null; PreparedStatement pstmt = null; ResultSet rs=null; int result = 0; try { con = getConnection(); String sql = "select count(*) from client where clientId=? and clientPassword=?"; pstmt = con.prepareStatement(sql); pstmt.setString(1, clientId); pstmt.setString(2, clientPassword); rs=pstmt.executeQuery(); if(rs.next()) result=rs.getInt(1); } catch (Exception e) { e.printStackTrace(); } finally { closeAll(rs,pstmt, con); } return result; }

2) src - test.TestCheckClient.java 추가

package test; import java.sql.SQLException; import model.ClientDAO; public class TestCheckClient { public static void main(String[] args) { String clientId="suman"; String clientPassword="sm1233"; try { int checkClient = ClientDAO.getInstance().checkClient(clientId,clientPassword); System.out.println(checkClient); } catch (SQLException e) { e.printStackTrace(); } } }

3) src - model.ClientDAO.java에  deleteMember 메소드 추가

//6. 회원 탈퇴 public void deleteMember(String id) throws SQLException { Connection con = null; PreparedStatement pstmt = null; try { con = getConnection(); String sql = "delete from client where clientId = '"+id+"'"; pstmt = con.prepareStatement(sql); pstmt.executeUpdate(); } catch (Exception e) { e.printStackTrace(); } finally { closeAll(pstmt, con); } }

4) src - test.TestDeleteMember.java 추가

package test; import java.sql.SQLException; import model.ClientDAO; import model.ClientDTO; public class TestDeleteMember { public static void main(String[] args) { try { String clientId="suman"; ClientDTO nowClient=ClientDAO.getInstance().getClientInfo(clientId); System.out.println(nowClient); ClientDAO.getInstance().deleteMember(clientId); nowClient=ClientDAO.getInstance().getClientInfo(clientId); System.out.println(nowClient); } catch (SQLException e) { e.printStackTrace(); } } }

 

4. Controller

1) src - controller.HandlerMapping.java 에 deletePage,delete 추가

else if(command.equals("deletePage")) // 회원탈퇴 페이지 이동 c=new DeletePageController(); else if(command.equals("delete")) // 회원탈퇴 처리 c = new DeleteController();

2) src - controller.DeletePageController.java 추가

package controller; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; public class DeletePageController implements Controller { @Override public String execute(HttpServletRequest request, HttpServletResponse response) throws Exception { request.setAttribute("url", "/view/member/delete.jsp"); return "/view/template/home.jsp"; } }

3) src - controller.DeleteController.java 추가

package controller; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import model.ClientDAO; public class DeleteController implements Controller { @Override public String execute(HttpServletRequest request, HttpServletResponse response) throws Exception { HttpSession session = request.getSession(); if(session==null||session.getAttribute("clientDTO")==null){ return "redirect:index.jsp"; } String clientId=request.getParameter("clientId"); String clientPassword=request.getParameter("clientPassword"); int checkClient = ClientDAO.getInstance().checkClient(clientId,clientPassword); if(checkClient==0) { return "redirect:view/member/checkClient_fail.jsp"; }else { session.invalidate(); ClientDAO.getInstance().deleteMember(clientId); return "redirect:view/member/delete_result.jsp"; } } }