JSP/DB (3)
view_all
GAWON
2023. 6. 1. 09:21
<%@page import="org.joonzis.ex.GreenDao"%>
<%@page import="org.joonzis.ex.GreenDto"%>
<%@page import="java.util.List"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%
List<GreenDto> list = GreenDao.getInstance().getAllList();
pageContext.setAttribute("list", list);
%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<jsp:include page="index.jsp"/>
<br><hr><br>
<h1>green 테이블의 전체 데이터</h1>
<table>
<thead>
<tr>
<th>회원 번호</th>
<th>아이디</th>
<th>비밀번호</th>
<th>이름</th>
<th>나이</th>
<th>주소</th>
<th>가입일</th>
</tr>
</thead>
<tbody>
<c:choose>
<c:when test="${not empty list }">
<c:forEach var="dto" items="${list }">
<tr>
<td>${dto.idx }</td>
<td>${dto.id }</td>
<td>${dto.pw }</td>
<td>${dto.name }</td>
<td>${dto.age }</td>
<td>${dto.addr }</td>
<td>${dto.reg_date }</td>
</tr>
</c:forEach>
</c:when>
<c:otherwise>
<tr>
<td colspan="7">member가 없습니다.</td>
</tr>
</c:otherwise>
</c:choose>
</tbody>
</table>
</body>
</html>