[Spring] 게시판만들기 : 조회수증가

1) BoardController.java

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

 

2) BoardService.java

    public void increaseReadCount(int board_no) {
        boardSQLMapper.increaseReadCount(board_no);
    }

 

3) BoardSQLMapper.java

    /* 조회수 증가 쿼리 */
    public void increaseReadCount(int no);

 

4) BoardSQLMapper.xml

    <update id="increaseReadCount">
        UPDATE EXAMPLE_BOARD 
        SET board_readcount = board_readcount + 1
        WHERE board_no = #{no}            
    </update>    

 

5) 실행화면