[Spring] 게시판 만들기 : 상세보기

1) BoardController.java

    @RequestMapping("readContentPage")
    public String readContentPage(int board_no, Model model) {
        
        HashMap<String, Object> map = boardService.getBoard(board_no);
        model.addAttribute("data" , map);
        
        return "board/readContentPage";
    }

 

2) BoardService.java

    public HashMap<String, Object> getBoard(int board_no) {
 
        HashMap<String, Object> map = new HashMap<String, Object>();
 
        BoardVo boardVo = boardSQLMapper.getBoardByNo(board_no);
        int userNo = boardVo.getUser_no();
        UserVo memberVo = userSQLMapper.getUserByNo(userNo);
 
        map.put("userVo", memberVo);
        map.put("boardVo", boardVo);
 
        return map;
    }

 

3) BoardSQLMapper.java

    /*게시글 번호 출력*/
    public BoardVo getBoardByNo(int no);

 

4) BoardSQLMapper.xml

    <select id="getBoardByNo" resultType="com.spring.example.vo.BoardVo">
        SELECT * 
        FROM EXAMPLE_BOARD
        WHERE board_no = #{no}        
    </select>

 

5) 실행결과