더블에스 devlog

728x90

4단계 JSP만 delete처리


1. 회원정보 리스트에서 삭제버튼 생성

(삭제버튼 클릭시 해당id값을 가지고 m_delete_pro.jsp이동)


m_list.jsp

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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page import = "java.sql.DriverManager"%>
<%@ page import = "java.sql.Connection"%>
<%@ page import = "java.sql.PreparedStatement"%>
<%@ page import = "java.sql.ResultSet"%>
<%@ page import = "java.sql.SQLException"%>
 
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>회원 정보 리스트</title>
</head>
<body>
    <%= request.getRequestURI()%> <br>
    회원 리스트 <br>
    <table width="100%" border="1">
        <tr>
            <td>아이디</td>
            <td>비밀번호</td>
            <td>권한</td>
            <td>이름</td>
            <td>이메일</td>
            <td>수정</td><!-- **수정버튼작성 -->
            <td>삭제</td><!-- ***삭제버튼생성 -->
        </tr>
    <%
        Connection conn = null;
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        // ResultSet클래스형 데이터 타입으로 객체참조변수 rs를 선언하고 null로 초기화
    
    //JDBC 프로그램 순서
    //01단계 :드라이버 로딩 시작
        Class.forName("com.mysql.jdbc.Driver");
    //01단계 :드라이버 로딩 끝
    
        try{
    //02단계 :DB연결(Connection)시작
            String jdbcDriver = "jdbc:mysql://localhost:3306/doublesdb?" +
                    "useUnicode=true&characterEncoding=euckr";
            String dbUser = "doublesid";
            String dbPass = "doublespw";
            conn = DriverManager.getConnection(jdbcDriver, dbUser, dbPass);
    //02단계 :DB연결(Connection)끝
            System.out.println(conn + "<-- conn m_list.jsp");
            if(conn != null){
                out.println("01 DB연결 성공");
            }else{
                out.println("02 DB연결 실패");
            }
    //03단계 :Query실행을 위한 statement 또는 prepareStatement객체생성 시작
            pstmt = conn.prepareStatement("select * from tb_member");
    //04단계 :Query실행 시작
            rs = pstmt.executeQuery();
            System.out.println(rs + "<-- rs m_list.jsp");
            //System.out.println(rs.next() + "<-- rs.next() m_list.jsp");
            //System.out.println(rs.next() + "<-- rs.next() m_list.jsp");
    //04단계 :Query실행 끝
    //05단계 :Query실행결과 사용
            //System.out.println(rs.next() + "<-- rs.next() m_list.jsp");
            //select문장 통해서 모든 회원 목록 가져와서 한줄씩 
            //(레코드(record) or 로우(row))보여준다 시작 
            
            while(rs.next()){
   %>
            <tr>
                <td><%= rs.getString("m_id")%></td>
                <td><%= rs.getString("m_pw")%></td>
                <td><%= rs.getString("m_level")%></td>
                <td><%= rs.getString("m_name")%></td>
                <td><%= rs.getString("m_email")%></td>
                <td>
                    <a href="<%= request.getContextPath() %>
                    /mupdate/m_update_form.jsp?send_id=<%= rs.getString("m_id")%>">수정클릭</a>
                    <!-- **수정버튼 클릭시 해당id값을 가지고 수정화면으로 이동 -->
                </td>
                <td>
                    <a href="<%= request.getContextPath() %>
                    /mdelete/m_delete_pro.jsp?send_id=<%= rs.getString("m_id")%>">삭제클릭</a>    
                    <!-- **삭제버튼 클릭시 해당id값의 모든정보를 삭제-->        
                </td>
            </tr>
    
    <%        
            }
            //select문장 통해서 모든 회원 목록 가져와서 한줄씩 
            //(레코드(record) or 로우(row))보여준다 끝
        } catch(SQLException ex) {
            out.println(ex.getMessage());
            ex.printStackTrace();
        } finally {
            // 6. 사용한 Statement 종료
            if (rs != null) try { rs.close(); } catch(SQLException ex) {}
            if (pstmt != null) try { pstmt.close(); } catch(SQLException ex) {}
            
            // 7. 커넥션 종료
            if (conn != null) try { conn.close(); } catch(SQLException ex) {}
        }
   %>    
    </table>
</body>
</html>
cs

회원리스트 화면


2. 회원정보 삭제처리(해당id값을 DB에서 삭제처리)


m_delete.jsp

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
31
32
33
34
35
36
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page import = "java.sql.DriverManager" %>
<%@ page import = "java.sql.Connection" %>
<%@ page import = "java.sql.PreparedStatement" %>
<%@ page import = "java.sql.SQLException" %>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>회원정보 삭제 처리</title>
</head>
<body>
<%
String send_id = request.getParameter("send_id");
System.out.println(send_id + "<-- send_id m_delete_pro.jsp");
request.setCharacterEncoding("utf-8");
Connection conn = null;
PreparedStatement pstmt = null;
Class.forName("com.mysql.jdbc.Driver");
try{
    String jdbcDriver = "jdbc:mysql://localhost:3306/doublesdb?" +
            "useUnicode=true&characterEncoding=euckr";
    String dbUser = "doublesid";
    String dbPass = "doublespw";
    conn = DriverManager.getConnection(jdbcDriver, dbUser, dbPass);
    pstmt = conn.prepareStatement(
            "DELETE FROM tb_member WHERE m_id=?");
    pstmt.setString(1, send_id);
    pstmt.executeUpdate();
}finally{
    if (pstmt != null) try { pstmt.close(); } catch(SQLException ex) {}
    if (conn != null) try { conn.close(); } catch(SQLException ex) {}
}
%>
</body>
</html>
cs

m_list.jsp 화면에서 id009라는 아이디를 가진 회원의 정보를 삭제하기 위해 삭제클릭 버튼 클릭


1. 삭제버튼 클릭전 m_list.jsp의 화면


2. 삭제버튼 클릭 후 m_list.jsp의 화면



이 글은 본 저작자 표시, 비영리, 변경 금지 규칙 하에 배포할 수 있습니다. 자세한 내용은 Creative Commons 라이선스를 확인하세요.

댓글을 사용할 수 없습니다.

티스토리툴바