<%@page import="java.util.ArrayList"%>
<%@page import="dto.Member"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@ 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>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<h1>member 목록 출력하기</h1>
<table border="1">
<thead>
<tr>
<th>인덱스</th><th>id</th><th>name</th><th>email</th>
</tr>
</thead>
<tbody>
<c:forEach var="member" items="${list }" varStatus="status">
<tr>
<td>${status.count}</td>
<td>${member.id }</td>
<td>${member.name }</td>
<td>${member.email }</td>
</tr>
</c:forEach>
</tbody>
</table>
</body>
</html>
package servlets;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import dto.Member;
@WebServlet("/list")
public class MemberListServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
ArrayList<Member> list = new ArrayList<>();
try {
Class.forName("org.mariadb.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mariadb://localhost:3306/mydb","root","1234");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from member");
//int no = 1;
while(rs.next()){
String id = rs.getString("id");
String pw = rs.getString("pw");
String name = rs.getString("name");
String email = rs.getString("email");
Member member = new Member(id,pw,name,email);
list.add(member);
}
} catch (SQLException | ClassNotFoundException e) {
e.printStackTrace();
}
request.setAttribute("list", list);
request.getRequestDispatcher("MemberList.jsp").forward(request, response);
}
}
