[Spring] 게시판 만들기 : 게시글 수정 및 삭제

1) readContentPage.jsp

                        <c:if test="${!empty sessionUser && sessionUser.user_no == data.boardVo.user_no}">
                            <a href="./deleteContentProcess?board_no=${data.boardVo.board_no }" class="btn btn-outline-dark" type="button">글삭제</a>
                            <a href="./updateContentPage?board_no=${data.boardVo.board_no }" class="btn btn-outline-dark" type="button">글수정</a>
                        </c:if>

 

2) BoardController.java

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

 

3) updateContentPage.jsp

                <div class="row mt-3">
                    <div class="col">
                        <form action="./updateContentProcess" method="post">
                            작성자 : ${data.userVo.user_nickname }<br>
                            제목 : <input type="text" class="form-control" value="${data.boardVo.board_title }"
                                name="board_title"><br>
                            내용 : <br>
                            <textarea class="form-control" rows="10" cols="40"
                                name="board_content">${data.boardVo.board_content }</textarea>
                            <br>
                            <input type="hidden" name="board_no" value="${data.boardVo.board_no }">
 
                            <input type="submit" class="btn btn-dark" value="수정완료">
                        </form>
                    </div>
                </div>

 

4) BoardController.java

    @RequestMapping("updateContentProcess")
    public String updateContentProcess(BoardVo param) {
 
        boardService.updateBoard(param);
 
        return "redirect:./mainPage";
    }

 

5) BoardService.java

    public void updateBoard(BoardVo param) {
        boardSQLMapper.updateBoard(param);
    }

 

6) BoardSQLMapper.java

    /* 게시글 수정 쿼리 */
    public void updateBoard(BoardVo param);

 

7) BoardSQLMapper.xml

    <update id="updateBoard">
        UPDATE EXAMPLE_BOARD SET board_title = #{board_title} , board_content = #{board_content} , board_updatewrite_date = SYSDATE
        WHERE board_no = #{board_no}
    </update>    

 

8) BoardController.java

@RequestMapping("deleteContentProcess")
    public String deleteContentProcess(int board_no) {
 
        boardService.deleteBoard(board_no);
 
        return "redirect:./mainPage";
    }

 

9) BoardService.java

j    public void deleteBoard(int board_no) {
        boardSQLMapper.deleteBoard(board_no);
    }

 

10) BoardSQLMapper.java

    /* 게시글 삭제 쿼리*/
    public void deleteBoard(int no);

 

11) BoardSQLMapper.xml

    <delete id="deleteBoard">
        DELETE FROM EXAMPLE_BOARD WHERE board_no = #{board_no}
    </delete>

 

12) 실행결과