접기
package member.servlet;
import java.io.IOException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList;
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 member.dto.MemberDTO;
public class GetAllMemberInfoServlet 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; ServletContext ctx = getServletContext(); String url = ctx.getInitParameter("url"); String user = ctx.getInitParameter("user"); String password = ctx.getInitParameter("password"); ArrayList list = new ArrayList(); MemberDTO m = null; Connection conn = null; PreparedStatement pstmt = null; ResultSet rset =null; String sql = "select * from member"; try { conn = DriverManager.getConnection(url, user, password); pstmt = conn.prepareStatement(sql); rset = pstmt.executeQuery(); while(rset.next()) { String id = rset.getString(1); String pwd = rset.getString(2); String name = rset.getString(3); String regi_num = rset.getString(4); int mileage = rset.getInt(5); m = new MemberDTO(id, pwd, name, regi_num, mileage); list.add(m); } request.setAttribute("list", list); resUrl = "/res/member_list.jsp"; } catch (SQLException e) { e.printStackTrace(); resUrl = "/res/error.jsp"; } RequestDispatcher rdp = request.getRequestDispatcher(resUrl); rdp.forward(request, response); }
}
접기 접기
< %@page import="member.dto.MemberDTO"%> < %@page import="java.util.ArrayList"%> <%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" " http://www.w3.org/TR/html4/loose.dtd "> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Insert title here</title> </head> <body> 조회결과<br> <table border="1px" width="500"> <tr> <td align="center">ID</td> <td align="center">Password</td> <td align="center">이름</td> <td align="center">주민번호</td> <td align="center">마일리지</td> </tr> <% ArrayList list = (ArrayList)request.getAttribute("list"); for(int i=0; i<list.size(); i++) { MemberDTO dto = (MemberDTO)list.get(i); %> <tr> <td align="center"><%=dto.getId() %></td> <td align="center"><%=dto.getPassword() %></td> <td align="center"><%=dto.getName() %></td> <td align="center"><%=dto.getRegisterNumber() %></td> <td align="center"><%=dto.getMileage() %></td> </tr> <% } %> </table> </body> </html>
접기 
