게시판 만들기 2 - 게시글 삭제 처리

 

 

게시글 삭제하기 

boardMapper.xml

	<delete id="deleteBoard" parameterType="Integer">
		DELETE FROM board
		WHERE board_idx = #{board_idx}
	</delete>

 

 

 

BoardDAO

	//게시글 삭제하기 
	public void deleteContent(int board_idx) {
		sqlTemplate.delete("board.deleteBoard",board_idx);
	}

 

 

 

BoardService

 

	//게시글 삭제하기
	public void deleteContent(int board_idx) {
		boardDAO.deleteContent(board_idx);
	}

 

 

 

BoardController

	//게시글 삭제 처리
	@GetMapping("/delete")
	public String delete(
			@RequestParam("info_idx") int info_idx,
			@RequestParam("board_idx") int board_idx ,Model model) {
		model.addAttribute("info_idx", info_idx);
		boardService.deleteContent(board_idx);
		return "board/delete";
	}

 

 

delete.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<c:set var="root" value="${pageContext.request.contextPath}"/>
<script>
	alert('삭제되었습니다')
	location.href='${root}/board/main?info_idx=${info_idx}'
</script>

 

테스트하기

 

 

 

MySQL 에서 DB확인함 

60번 인덱스만 사라진거 확인