package member.servlet;
import java.io.IOException;
import java.sql.SQLException;
import java.util.ArrayList;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import member.dto.MemberDTO;
import member.model.service.MemberManagerService;
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 {
MemberManagerService mms = MemberManagerService.getInstance();
String resUrl = null;
try {
ArrayList <MemberDTO>list = mms.getMemberList();
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);
}
}
package member.model.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import member.dto.MemberDTO;
import member.util.DatabaseUtility;
public class MemberDAO {
private static MemberDAO instance = new MemberDAO();
private DatabaseUtility dbUtil;
public static MemberDAO getInstance() {
return instance;
}
private MemberDAO() {
dbUtil = DatabaseUtility.getInstance();
}
public ArrayList<MemberDTO> selectAllMember() throws SQLException {
ArrayList<MemberDTO> list = new ArrayList<MemberDTO>();
MemberDTO mto =null;
String sql = "select id, password, name, register_Number1, register_Number2, mileage from member";
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rset = null;
try {
conn = dbUtil.getDataSource().getConnection();
pstmt = conn.prepareStatement(sql);
rset = pstmt.executeQuery();
while(rset.next()) {
mto = new MemberDTO(rset.getString(1), rset.getString(2), rset.getString(3), rset.getString(4), rset.getString(5), rset.getInt(6));
list.add(mto);
}
} finally {
dbUtil.close(rset, pstmt, conn);
}
return list;
}
package member.model.service;
import java.sql.SQLException;
import java.util.ArrayList;
import member.dto.MemberDTO;
import member.exception.DuplicatedIdException;
import member.exception.DuplicatedRegisterNumberException;
import member.model.dao.MemberDAO;
public class MemberManagerService {
private static MemberManagerService instance = new MemberManagerService();
private MemberDAO dao;
private MemberManagerService() {
dao = MemberDAO.getInstance();
}
public static MemberManagerService getInstance() {
return instance;
}
public ArrayList<MemberDTO> getMemberList() throws SQLException {
return dao.selectAllMember();
}
}
<%@page import="java.util.ArrayList"%>
<jsp:useBean id="mto" class="member.dto.MemberDTO" scope="request"/>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!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>
<jsp:include page="/menu.jsp"/>
조회결과<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>
<c:forEach items="${requestScope.list}" var="mto">
<tr>
<td align="center">${mto.id }</td>
<td align="center">${mto.password }</td>
<td align="center">${mto.name }</td>
<td align="center">${mto.registerNumber1 }-${mto.registerNumber2 }</td>
<td align="center">${mto.mileage }</td>
</tr>
</c:forEach>
</table>
</body>
</html>