주먀

14. 게시판 전체 게시물 조회 본문

학원/Servlet

14. 게시판 전체 게시물 조회

주먀 2023. 5. 3. 17:38

구조

1. goBoardMainCon -> View 선택하기

// 3. View 선택

		return "boardMain";

 

 

2. BoardMapper -> sql문 작성하기

<!-- 전체 게시물 조회 -->
	<select id="list" resultType="kr.smhrd.entity.Board">
		select * from web_board
		order by
		b_date desc
	</select>

 

 

3. BoardDAO -> 메서드 작성하기

	public List<Board> list() {

		SqlSession session = factory.openSession(true);

		List<Board> list = session.selectList("list");

		session.close();

		return list;

	}

 

 

4. goBoardMainCon -> 기능구현하기

// 1. 데이터 수집

		// 2. 기능 구현
		BoardDAO dao = new BoardDAO();

		List<Board> list = dao.list();

		// 객체바인딩
		request.setAttribute("list", list);

 

 

5. boardMain.jsp -> 1. body태그 아래에 자바코드 작성 -> 2. 펼쳐줄 내용 아래에 자바코드 작성

5-1. 

<%
List<Board> list = (List<Board>)request.getAttribute("list");
%>

5-2.

<%
for (Board dto : list) {
%>
<tr>
<td><%=dto.getNum()%></td>
<td><%=dto.getTitle()%></td>
<td><%=dto.getWriter()%></td>
<td><%=dto.getB_date()%></td>
</tr>
<%
}
%>

5-3

<%@page import="java.util.List"%>
<%@page import="kr.smhrd.entity.Board"%>
<%@page import="java.util.ArrayList"%>
<%@ page language="java" contentType="text/html; charset=utf-8"
	pageEncoding="utf-8"%>
<%@taglib uri = "http://java.sun.com/jsp/jstl/core" prefix="c" %>
<!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=utf-8">
<!--[if lte IE 8]><script src="assets/js/ie/html5shiv.js"></script><![endif]-->
<link rel="stylesheet" href="assetsBoard/css/main.css" />
<link rel="stylesheet" href="assetsBoard/css/board.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>
<body>
	<%--
		1. EL
		2. JSTL
	 --%>

	<%
	List<Board> list = (List<Board>) request.getAttribute("list");
	%>

	<div id="board">
		<table id="list">
			<tr>
				<td>번호</td>
				<td>제목</td>
				<td>작성자</td>
				<td>시간</td>
			</tr>

			<c:forEach items="${dto}" var="list">
				<tr>
					<td>${dto.num}</td>
					<td><a href="viewBoard.do?num=${dto.num}">${dto.title}</a></td>
					<td>${dto.writer}</td>
					<td>${dto.b_date}</td>
				</tr>
			</c:forEach>


		</table>


		<a href="goMain.do"><button id="writer">홈으로가기</button></a> <a
			href="goWriterBoard.do"><button id="writer">작성하러가기</button></a>
	</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>

'학원 > Servlet' 카테고리의 다른 글

EL / JSTL  (0) 2023.05.04
if문 -> haspmap 변경  (0) 2023.05.04
13. WriterBoardCon.java / Board.java(DTO) / BoardMapper.xml / BoardDAO.java(DAO)  (0) 2023.05.03
12. goBoardMainCon/goWriterBoardCon.java  (0) 2023.05.03
11. UpdateCon.java  (0) 2023.05.03
'학원/Servlet' Related Articles more