게시판 - webstudy-board - 게시판 글삭제

1.SQL
1) 삭제할 게시글 deleteBoard를 Y로 변경
update board set deleteBoard = 'Y' where boardNo=1 2. View
1) WebContent - view - board - viewBoard.jsp
1-1) deleteBoard() 추가
function deleteBoard(){ if(confirm("글을 삭제하시겠습니까?")) location.href="http://localhost:8888/webstudy-board/DispatcherServlet?command=deleteBoard&boardNo=${boardInfo.boardDTO.boardNo}"; }
1-2) 삭제 버튼 링크 추가 <div class="card"> <table> <tr> <td>글번호</td><td>${boardInfo.boardDTO.boardNo}</td> <td>글제목</td><td>${boardInfo.boardDTO.boardTitle} </td> </tr> <tr> <td>글쓴이</td><td>${boardInfo.boardDTO.clientId}</td> <td>이메일</td><td>${boardInfo.clientDTO.clientEmail}</td> </tr> <tr> <td>작성일</td><td>${boardInfo.boardDTO.boardDate}</td> <td>조회수</td><td>${boardInfo.boardDTO.boardCount}</td> </tr> <tr> <td colspan="4">${boardInfo.boardDTO.boardContent}</td> </tr> </table> <a href="http://localhost:8888/webstudy-board/DispatcherServlet?command=boardList">목록으로</a> <c:if test="${sessionScope.clientDTO.clientId== boardInfo.boardDTO.clientId}"> <a href="#">수정</a> <a href="javascript:deleteBoard();">삭제</a> </c:if> </div>
3. Model
1) src - model.BoardDAO.java에 deleteBoard 메소드 추가
public void deleteBoard(int boardNo) throws SQLException { Connection con = null; PreparedStatement pstmt = null; try { con = getConnection(); String sql = "update board set deleteBoard = 'Y' where boardNo=" + boardNo; System.out.println(sql); pstmt = con.prepareStatement(sql); pstmt.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { closeAll(pstmt, con); } } 4.Controller
1) src - controller.HandlerMapping.java에 deleteBoard 추가
else if(command.equals("deleteBoard")) c = new DeleteBoardController();
2)src - controller.DeleteBoardController.java 추가
package controller; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import model.BoardDAO; public class DeleteBoardController implements Controller { @Override public String execute(HttpServletRequest request, HttpServletResponse response) throws Exception { HttpSession session = request.getSession(false); if (session == null || session.getAttribute("clientDTO") == null) { return "redirect:index.jsp"; } int boardNo = Integer.parseInt(request.getParameter("boardNo")); System.out.println("DeleteBoardController"); System.out.println(boardNo); BoardDAO.getInstance().deleteBoard(boardNo); return "redirect:DispatcherServlet?command=boardList"; } }