Recent Posts
Link
250x250
오늘보다 더 나은 내일의 나에게_
비전공자의 IoT 국비 교육 수강일지 Day_46 본문
728x90
회원관리페이지 출력
회원정보를 DB에서 가져와 페이지에 모두 출력(이메일, 번호, 주소)
selectMember.jsp => 회원관리 페이지
memberDAO_selectAll( ) => 모든회원 출력메서드
코드
더보기selectMember.jsp
<%@page import="com.VO.memberVO"%> <%@page import="java.util.ArrayList"%> <%@page import="com.DAO.memberDAO"%> <%@ page language="java" contentType="text/html; charset=EUC-KR" pageEncoding="EUC-KR"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <title>Forty by HTML5 UP</title> <meta charset="utf-8" /> <meta http-equiv="Content-Type" content="text/html; charset=EUC-KR"> <!--[if lte IE 8]><script src="assets/js/ie/html5shiv.js"></script><![endif]--> <link rel="stylesheet" href="assets/css/main.css" /> <!--[if lte IE 9]><link rel="stylesheet" href="assets/css/ie9.css" /><![endif]--> <!--[if lte IE 8]><link rel="stylesheet" href="assets/css/ie8.css" /><![endif]--> </head> <style> </style> <body style="text-align: center;"> <!-- 1. DAO 생성(memberDAO) 2. DAO - 메서드(selectAll) 생성 -> BoardDAO(getList()참고) 3. jsp 파일 -> board_list.jsp 참고 --> <% memberDAO dao = new memberDAO(); ArrayList<memberVO> al = dao.selectAll(); %> <!-- Wrapper --> <div id="wrapper"> <!-- Menu --> <nav id="Update"> <table> <caption><h2>회원관리페이지</h2></caption> <tr> <td>Email</td> <td>HP</td> <td>Addr</td> </tr> <% for(int i = 0;i < al.size();i++){ %> <tr> <td><%= al.get(i).getEmail()%></td> <td><%= al.get(i).getTel()%></td> <td><%= al.get(i).getAddress()%></td> </tr> <%} %> </table> </nav> </div> <!-- Scripts --> <script src="assets/js/jquery.min.js"></script> <script src="assets/js/jquery.scrolly.min.js"></script> <script src="assets/js/jquery.scrollex.min.js"></script> <script src="assets/js/skel.min.js"></script> <script src="assets/js/util.js"></script> <!--[if lte IE 8]><script src="assets/js/ie/respond.min.js"></script><![endif]--> <script src="assets/js/main.js"></script> </body> </html>
memberDAO
package com.DAO; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.ArrayList; import com.VO.memberVO; public class memberDAO { public ArrayList<memberVO> selectAll() { Connection conn = null; PreparedStatement psmt = null; ResultSet rs = null; ArrayList<memberVO> al = new ArrayList<memberVO>(); try { Class.forName("oracle.jdbc.driver.OracleDriver"); String url = "jdbc:oracle:thin:@127.0.0.1:1521:xe"; String dbid = "hr"; String dbpw = "hr"; conn = DriverManager.getConnection(url,dbid,dbpw); String sql = "select email, tel, address from message_member"; psmt = conn.prepareStatement(sql); rs = psmt.executeQuery(); while(rs.next()){ String getEmail = rs.getString(1); String getTel = rs.getString(2); String getAddress = rs.getString(3); memberVO vo = new memberVO(getEmail,getTel,getAddress); al.add(vo); }//end of while }catch(Exception e) { e.printStackTrace(); }finally { try { rs.close(); psmt.close(); conn.close(); } catch (Exception e2) { e2.printStackTrace(); } } return al; } }
회원삭제
삭제 누르면 선택된 회원정보를 DB에서 삭제
코드
더보기selectMember.jsp
=>삭제 버튼을 만들고 href속성에 DeleteCon 서블릿으로 이동하되 쿼리스트링으로 이메일 주소값을 넘겨준다!
DeleteCon
package com.member; import java.io.IOException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; @WebServlet("/DeleteCon") public class DeleteCon extends HttpServlet { protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String email = request.getParameter("email"); Connection conn = null; PreparedStatement psmt = null; try { Class.forName("oracle.jdbc.driver.OracleDriver"); String url = "jdbc:oracle:thin:@127.0.0.1:1521:xe"; String dbid = "hr"; String dbpw = "hr"; conn = DriverManager.getConnection(url,dbid,dbpw); //특정 이메일 가지고 있는 행 삭제 String sql = "delete from message_member where email = ?"; psmt = conn.prepareStatement(sql); psmt.setString(1, email); int cnt = psmt.executeUpdate(); if(cnt>0) { response.sendRedirect("selectMember.jsp"); }else { response.sendRedirect("selectMember.jsp"); } }catch(Exception e) { e.printStackTrace(); }finally { try { psmt.close(); conn.close(); } catch (Exception e2) { e2.printStackTrace(); } } }//end of service }
728x90
'비전공자의 코딩일지' 카테고리의 다른 글
비전공자의 IoT 국비 교육 수강일지 Day_50 (0) | 2022.02.28 |
---|---|
비전공자의 IoT 국비 교육 수강일지 Day_49 (0) | 2022.02.26 |
비전공자의 IoT 국비 교육 수강일지 Day_44 (0) | 2022.02.21 |
비전공자의 IoT 국비 교육 수강일지 Day_40 (0) | 2022.02.15 |
비전공자의 IoT 국비 교육 수강일지 Day_39 (0) | 2022.02.14 |
Comments