[board] 게시글 수정, 삭제

1. mapper

 수정하기  
<update id="updateBoard">
UPDATE SPRING_BOARD 
SET 
	TITLE = #{title}
	, WRITER = #{writer}
	, CONTENT = #{content}
WHERE BOARD_NUM = #{boardNum}
</update>

 삭제 
<delete id="deleteBoard">
DELETE SPRING_BOARD
WHERE BOARD_NUM= #{boardNum}

</delete>

2. 인터페이스 serviceImpl

수정하기
void updateBoard(BoardVO board);
	
삭제하기
void deleteBoard(int boardNum);
	

수정하기
@Override
public void updateBoard(BoardVO board) {
	sqlSession.update("boardMapper.updateBoard", board);
}
	
삭제하기
@Override
public void deleteBoard(int boardNum) {
	sqlSession.delete("boardMapper.deleteBoard", boardNum);		
}

 

3. controller

수정하기 페이지 이동
@GetMapping("/modifyForm")
public String modifyForm(int boardNum, Model model) {
	boardService.boardDetail(boardNum);
	model.addAttribute("board", boardService.boardDetail(boardNum));
	return "board/board_modify";
}
	
수정하기
@PostMapping("/modify")
public String modifyBoard(BoardVO board) {
	boardService.updateBoard(board);
	
    requestParam에서 name="num"으로 넣어줬기 때문에 ?num으로 넘긴다
	
    return "redirect:/board/boardDetail?num="+ board.getBoardNum();
}


삭제하기
@GetMapping("/delete")
public String deleteBoard(int boardNum) {
	boardService.deleteBoard(boardNum);
		
	컨트롤러 곧바로 갈 때 사용법
	return "redirect:/board/list";
}