개발자로가는길
분류 전체보기
(36)
1.JAVA Web Programming
(34)
[0주차]코딩준비
(4)
[1주차] Servlet-Basic
(4)
[2주차]DB,Model1,Model2
(3)
[3주차]JSP+model2
(7)
[4주차] 게시판 만들기
(16)
[5주차] 페이징빈, Ajax
(0)
2. Spring Framework
(0)
빽's워드프레스
(1)
티스토리 관리
(1)
홈
태그
방명록
관리자
글쓰기
/
/
Model2 Architecture - (6) 회원탈퇴
2019. 8. 3. 23:42
회원탈퇴
1.View
1) WebContent - deleteMember.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
회원 탈퇴
2) WebContent - delete_result.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
회원 탈퇴
HOME
<% String ret = (String)request.getAttribute("ret"); %> <%=ret %>
2. Controller
1) src - controller.HandlerMapping.java에 delete 추가
if(command.equals("delete")) { c = new DeleteController(); }
2) 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 { System.out.println("enter to DeleteController()..."); String ret = ClientDAO.getInstance().deleteMember("minnn"); System.out.println(ret); HttpSession session = request.getSession(); session.invalidate(); request.setAttribute("ret", ret); return "delete_result.jsp"; } }
3.model
1)src - model.ClientDAO.java에 Delete 메소드 추가
// 회원 탈퇴 public String deleteMember(String id) throws SQLException { String ret = null; Connection con = null; PreparedStatement pstmt = null; int result = 0; try { con = getConnection(); String sql = "delete from client where clientId = '"+id+"'"; System.out.println(sql); pstmt = con.prepareStatement(sql); result = pstmt.executeUpdate(); if(result>0) ret = "delete your id. Thank you for using my site. See you and Good luck :)"; else ret = "Not deleted."; } catch (Exception e) { e.printStackTrace(); } finally { closeAll(pstmt, con); } System.out.println(ret); return ret; }
공유하기
게시글 관리
구독하기
개발자로가는길
'
1.JAVA Web Programming
>
[3주차]JSP+model2
' 카테고리의 다른 글
Model2 Architecture - (5) 회원수정
(0)
2019.08.03
Model2 Architecture - (4) 로그아웃
(0)
2019.08.03
Model2 Architecture - (3) 로그인
(0)
2019.08.02
Model2 Architecture - (2) 회원조회
(0)
2019.08.01
Model2 Architecture - (1) 회원가입
(0)
2019.08.01
+ Recent posts
Powered by
Tistory
, Designed by
wallel
Rss Feed
and
Twitter
,
Facebook
,
Youtube
,
Google+
티스토리툴바