게시판 - webstudy-board - 게시판 글수정

1. SQL 

1) 수정시 boardDate를 수정시간으로 update

UPDATE board SET boardTitle = '제목변경 ', boardContent='내용변경 ', boardDate=now() WHERE boardNo=보드번호

 

2. View

1) WebContent - view - board - viewBoard.jsp 링크 추가

<a href="http://localhost:8080/webstudy-board/DispatcherServlet?command=updateBoardPage&boardNo=${boardInfo.boardDTO.boardNo}">수정</a>

2) WebContent - view - board - updateBoard.jsp 추가

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <div class="card"> <form method="post" action="DispatcherServlet"> <input type="hidden" name="command" value="updateBoard"> <input type="hidden" name="boardNo" value="${boardInfo.boardDTO.boardNo}"> <table> <tr> <td>글번호</td><td>${boardInfo.boardDTO.boardNo}"</td> <td>글제목</td><td><input type="text" name="boardTitle" value="${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"><textarea name="boardContent" cols="50" rows="13">${boardInfo.boardDTO.boardContent}</textarea></td> </tr> </table> <a href="http://localhost:8080/webstudy-board/DispatcherServlet?command=boardList">목록으로</a> <input type="submit" value="수정"> </form> </div>

 

3. Model

1) src - model.BoardDAO.java에 updateBoard 메소드 추가

//4. 글수정 public void updateBoard(int boardNo, String boardTitle, String boardContent) throws SQLException { Connection con=null; PreparedStatement pstmt=null; try { con=getConnection(); String sql="UPDATE board SET boardTitle = ?, boardContent=?, boardDate=now() WHERE boardNo=?"; pstmt=con.prepareStatement(sql); pstmt.setString(1, boardTitle); pstmt.setString(2, boardContent); pstmt.setInt(3, boardNo); pstmt.execute(); }finally { closeAll(pstmt, con); } }

2) test - test.TestUpdateBoard.java 추가

package test; import model.BoardDAO; public class TestUpdateBoard { public static void main(String[] args) { int boardNo=13; String boardTitle="수정테스트"; String boardContent="수정 테스트 되나여?"; try { BoardDAO.getInstance().updateBoard(boardNo, boardTitle, boardContent); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } }

 

4. Controller

1) src - controller.HandlerMapping.java에 updateBoardPage, updateBoard 추가 

else if(command.equals("updateBoardPage")) // 글수정 페이지 이동 c=new UpdateBoardPageController(); else if(command.equals("updateBoard")) // 글수정 처리 c=new UpdateBoardController();

2) src - controller.UpdateBoardPageController.java 추가

package controller; import java.util.HashMap; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import model.BoardDAO; public class UpdateBoardPageController 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")); HashMap<String, Object> boardInfo= BoardDAO.getInstance().viewBoard(boardNo); request.setAttribute("boardInfo", boardInfo); request.setAttribute("url", "/view/board/updateBoard.jsp"); return "/view/template/home.jsp"; } }

3) src - controller.UpdateBoardController 추가

package controller; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import model.BoardDAO; public class UpdateBoardController 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")); String boardTitle=request.getParameter("boardTitle"); String boardContent=request.getParameter("boardContent"); BoardDAO.getInstance().updateBoard(boardNo,boardTitle,boardContent); return "redirect:DispatcherServlet?command=viewBoard&boardNo="+boardNo; } }

 

[참고]

mysql 현재시간 update https://m.blog.naver.com/PostView.nhn?blogId=teastful&logNo=140110768553&proxyReferer=https%3A%2F%2Fwww.google.com%2F