게시판 - webstudy-board - 게시판 글상세

1. sql

1) Inner join으로 게시글과 사용자 정보 join

select b.boardNo,b.boardTitle,b.boardContent,b.clientId,b.boardDate,b.boardCount,c.clientName,c.clientEmail from board as b join client as c on b.clientId = c.clientId where boardNo='1'

 

2. View 

1) WebContent - view - board- boardList.jsp 링크 수정

<td><a href="DispatcherServlet?command=viewBoard&boardNo=${boardDTO.boardNo}">${boardDTO.boardTitle}</a></td>

2) WebContent - view - board- viewBoard.jsp 추가

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <div class="card"> <table> <tr> <td>글번호</td><td>${boardInfo.boardDTO.boardNo}</td> <td>글제목</td><td>${boardInfo.boardDTO.boardTitle} </td> </tr> <tr> <td>글쓴이</td><td>${boardInfo.boardDTO.clientId}</td> <td>이메일</td><td>${boardInfo.clientDTO.clientEmail}</td> </tr> <tr> <td>작성일</td><td>${boardInfo.boardDTO.boardDate}</td> <td>조회수</td><td>${boardInfo.boardDTO.boardCount}</td> </tr> <tr> <td colspan="4">${boardInfo.boardDTO.boardContent}</td> </tr> </table> <a href="http://localhost:8080/webstudy-board/DispatcherServlet?command=boardList">목록으로</a> <c:if test="${sessionScope.clientDTO.clientId== boardInfo.boardDTO.clientId}"> <a href="#">수정</a> <a href="#">삭제</a> </c:if> </div>

 

2. Model

1) src - model.BoardDAO.java에 viewBoard 메소드 추가

//2. 글상세 public HashMap<String, Object> viewBoard(int boardNo) throws SQLException { HashMap<String, Object> boardInfo=new HashMap<>(); Connection con=null; PreparedStatement pstmt=null; ResultSet rs=null; try { con=getConnection(); StringBuilder sql = new StringBuilder(); sql.append("select b.boardNo,b.boardTitle,b.boardContent,b.clientId,b.boardDate,b.boardCount,c.clientEmail "); sql.append("from board as b "); sql.append("join client as c "); sql.append("on b.clientId = c.clientId "); sql.append("where boardNo=?"); pstmt=con.prepareStatement(sql.toString()); pstmt.setInt(1, boardNo); rs=pstmt.executeQuery(); while(rs.next()) { BoardDTO boardDTO=new BoardDTO(rs.getInt(1),rs.getString(2),rs.getString(3),rs.getString(4),rs.getString(5),rs.getInt(6)); boardInfo.put("boardDTO", boardDTO); ClientDTO clientDTO=new ClientDTO(rs.getString(4), null,null, rs.getString(7), null, null); boardInfo.put("clientDTO", clientDTO); } }finally { closeAll(rs, pstmt, con); } return boardInfo; }

 

3. Controller

1) src - controller.HandlerMapping.java에 viewBoard 추가

else if(command.equals("viewBoard")) // 글상세 페이지 이동 c=new ViewBoardController();

2) src - controller.ViewBoardController.java 추가

package controller; import java.util.HashMap; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import model.BoardDAO; public class ViewBoardController implements Controller { @Override public String execute(HttpServletRequest request, HttpServletResponse response) throws Exception { HttpSession session = request.getSession(false); if(session==null||session.getAttribute("clientDTO")==null){ return "redirect:index.jsp"; } int boardNo=Integer.parseInt(request.getParameter("boardNo")); HashMap<String, Object> boardInfo= BoardDAO.getInstance().viewBoard(boardNo); request.setAttribute("boardInfo", boardInfo); request.setAttribute("url", "/view/board/viewBoard.jsp"); return "/view/template/home.jsp"; } }

 

[참고] 

Inner Join https://futurists.tistory.com/17