게시글 조회

게시글 조회 기능을 개발합니다.

화면

작업 순서

read.jsp

board.sql

Board.java

BoardDAO.java

BoardService.java

BoardServiceImpl.java

BoardServlet.java

코드

read.jsp

<%@ include file="/layout/jstl.jsp" %>
<%@ include file="/layout/common.jsp" %>
<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
	<title>project💻 - ALOHA CLASS🌴</title>
	<jsp:include page="/layout/meta.jsp" />
	<jsp:include page="/layout/link.jsp" />
</head>
<body>
	<jsp:include page="/layout/header.jsp" />
	<%-- [Contents] ######################################################### --%>
		
	<main>
		<div class="container mt-5">
			<h2 class="mb-4">게시글 조회</h2>
			<form action="">
				<input type="hidden" name="id" value="${board.id}" />
	
				<div class="mb-3">
					<label for="title" class="form-label">제목</label>
					<input type="text" class="form-control" id="title" name="title" value="${board.title}" required>
				</div>
	
				<div class="mb-3">
					<label for="username" class="form-label">작성자</label>
					<input type="text" class="form-control" id="username" name="username" value="${board.user.name}" readonly>
				</div>
	
				<div class="mb-3">
					<label for="content" class="form-label">내용</label>
					<textarea class="form-control" id="content" name="content" rows="6" required>${board.content}</textarea>
				</div>
	
				<div class="d-grid gap-2 mt-4">
					<a href="${ root }/board/update?id=${ board.id }" class="btn btn-primary">수정</a>
					<a href="${ root }/board/list" class="btn btn-secondary">목록</a>
				</div>
			</form>
		</div>
	</main>
	
	
	<%-- [Contents] ######################################################### --%>
	<jsp:include page="/layout/footer.jsp" />
	<jsp:include page="/layout/script.jsp" />
</body>
</html>
HTML
복사

board.sql

DROP TABLE IF EXISTS board;
CREATE TABLE board (
    no INT AUTO_INCREMENT PRIMARY KEY COMMENT 'PK',
    id VARCHAR(64) NOT NULL UNIQUE COMMENT 'UK',
    title VARCHAR(255) NOT NULL COMMENT '제목',
    user_no INT NOT NULL COMMENT '작성자 PK',
    content TEXT NOT NULL COMMENT '내용',
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '작성일',
    updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '수정일'
) COMMENT '게시판';

-- 샘플 데이터
TRUNCATE TABLE board;
INSERT INTO board(id, title, user_no, content)
VALUES 
(UUID(), '제목001', 1, '내용001'),
(UUID(), '제목002', 2, '내용002'),
(UUID(), '제목003', 3, '내용003'),
(UUID(), '제목004', 1, '내용004'),
(UUID(), '제목005', 2, '내용004'),
(UUID(), '제목003', 3, '내용003')
;
SQL
복사

Board.java

package board.DTO;

import java.util.Date;

import com.alohaclass.jdbc.annotation.Column;
import com.alohaclass.jdbc.annotation.Pk;
import com.alohaclass.jdbc.annotation.Table;

import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;

@Table("board")
@Data
@NoArgsConstructor
@AllArgsConstructor
@Builder
public class Board {
	@Pk
	private int no;
	private String id;
	private String title;
	private int userNo;
	private String content;
	private Date createdAt;
	private Date updatedAt;
	
	@Column(exist = false)
	private Users user;
}
Java
복사

BoardDAO.java

package board.DAO;

import com.alohaclass.jdbc.dao.BaseDAOImpl;

import board.DTO.Board;

public class BoardDAO extends BaseDAOImpl<Board> {

}
Java
복사

BoardService.java

package board.Service;

import java.util.List;

import board.DTO.Board;

public interface BoardService {
	// 게시글 목록
	List<Board> list();
	// 게시글 조회
	Board select(int no);
	Board selectById(String id);
	
}
Java
복사

BoardServiceImpl.java

package board.Service;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import board.DAO.BoardDAO;
import board.DAO.UserDAO;
import board.DTO.Board;
import board.DTO.Users;

public class BoardServiceImpl implements BoardService {
	
	private BoardDAO boardDAO = new BoardDAO();
	private UserDAO userDAO = new UserDAO();

	@Override
	public List<Board> list() {
		List<Board> list = null;
		try {
			list = boardDAO.list();
			for (Board board : list) {
				int userNo = board.getUserNo();
				Users user = userDAO.select(userNo);
				board.setUser(user);
			}
			
		} catch (Exception e) {
			e.printStackTrace();
		}
		return list;
	}
	
	@Override
	public Board select(int no) {
		Board board = null;
		try {
			board = boardDAO.select(no);
			int userNo = board.getUserNo();
			Users user = userDAO.select(userNo);
			board.setUser(user);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return board;
	}
	
	@Override
	public Board selectById(String id) {
		Board board = null;
		try {
			Map<String, Object> map = new HashMap<>();
			map.put("id", id);
			board = boardDAO.selectBy(map);
			int userNo = board.getUserNo();
			Users user = userDAO.select(userNo);
			board.setUser(user);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return board;
	}


}
Java
복사

BoardServlet.java

package board.servlet;

import java.io.IOException;
import java.util.List;
import java.util.UUID;

import board.DTO.Board;
import board.DTO.Users;
import board.Service.BoardService;
import board.Service.BoardServiceImpl;
import jakarta.servlet.RequestDispatcher;
import jakarta.servlet.ServletException;
import jakarta.servlet.annotation.WebServlet;
import jakarta.servlet.http.HttpServlet;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;

@WebServlet("/board/*")
public class BoardServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
     
	private BoardService boardService = new BoardServiceImpl();
	/**
	 * [GET]
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String path = request.getPathInfo();
		String page = "";
		
		// 게시글 목록
		if( path.equals("/list") || path.equals("/list.jsp") ) {
			List<Board> boardList = boardService.list();
			request.setAttribute("boardList", boardList);
			page = "/page/board/list.jsp";
			RequestDispatcher dispatcher = request.getRequestDispatcher(page);
			dispatcher.forward(request, response);
		}
		
		// 게시글 조회
		if( path.equals("/read") || path.equals("/read.jsp") ) {
			String id = request.getParameter("id");
			Board board = boardService.selectById(id);
			request.setAttribute("board", board);
			page = "/page/board/read.jsp";
			RequestDispatcher dispatcher = request.getRequestDispatcher(page);
			dispatcher.forward(request, response);
		}
		
	}

	/**
	 * [POST]
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		
	}

}
Java
복사

게시글 조회

게시글 조회

화면

작업 순서

코드

read.jsp

board.sql

Board.java

BoardDAO.java

BoardService.java

BoardServiceImpl.java

BoardServlet.java

JSP 게시판 프로젝트