[Spring]게시판 수정/삭제 boardUpdate

1 ) 게시판 수정/삭제 Controller

    //게시판 게시글 삭제
    @RequestMapping(value = "/deleteBoard")
    @ResponseBody
    public BoardDto deleteBoard(HttpServletRequest request, HttpServletResponse response, BoardForm boardForm) throws Exception {
 
        MDC.put("TRANSACTION_ID", String.valueOf(boardForm.getBoard_seq()));
        
        BoardDto boardDto = boardService.deleteBoard(boardForm);
        
        MDC.remove("TRANSACTION_ID");
 
        return boardDto;
    }
 
    //게시판 게시글 수정
    @RequestMapping(value = "/boardUpdate")
    public String boardUpdate(HttpServletRequest request, HttpServletResponse response) throws Exception {
 
        return "board/boardUpdate";
    }
 
    
    @RequestMapping(value = "/updateBoard")
    @ResponseBody
    public BoardDto updateBoard(HttpServletRequest request, HttpServletResponse response, BoardForm boardForm) throws Exception {
 
        MDC.put("TRANSACTION_ID", String.valueOf(boardForm.getBoard_seq()));
        
        BoardDto boardDto = boardService.updateBoard(boardForm);
        
        MDC.remove("TRANSACTION_ID");
 
        return boardDto;
        
    
    }

DeleteBoard - 게시글 삭제

UpdateBoard - 게시글 수정

 

2 ) 게시판 수정/삭제 Dao

    public int deleteBoard(BoardForm boardForm) throws Exception {
 
        return sqlSession.delete(NAMESPACE + ".deleteBoard", boardForm);
    }
 
    
    public int updateBoard(BoardForm boardForm) throws Exception {
 
        return sqlSession.update(NAMESPACE + ".updateBoard", boardForm);
    }
    

 

3 ) 게시판 수정/삭제 Dto

    int board_seq; // 게시글 번호
    int board_re_ref; // 게시글 그룹 번호
    int board_re_lev; // 게시글 글의 깊이
    int board_re_seq; // 게시글 글의 순서
    String board_writer; // 작성자
    String board_subject; // 제목
    String board_content; // 내용
    int board_hits; // 조회수
    String del_yn; // 삭제유무
    String ins_user_id; // Insert 사용자 아이디
    String ins_date; // Insert 날짜
    String upd_user_id; // Update 사용자 아이디
    String upd_date; // Update 날짜
    String result;

 

4 ) 게시판 수정/삭제 Service

    /* 게시판 게시글 삭제 */
    public BoardDto deleteBoard(BoardForm boardForm) throws Exception {
        
        logger.debug("==================== deleteBoard START ====================");
 
        BoardDto boardDto = new BoardDto();
 
        int deleteCnt = boardDao.deleteBoard(boardForm);
 
        if (deleteCnt > 0) {
            boardDto.setResult("SUCCESS");
        } else {
            boardDto.setResult("FAIL");
        }
 
        logger.debug("==================== deleteBoard START ====================");
        
        return boardDto;
    }
 
    /* 게시판 게시글 수정 */
    public BoardDto updateBoard(BoardForm boardForm) throws Exception {
 
        logger.debug("==================== updateBoard START ====================");
        
        BoardDto boardDto = new BoardDto();
 
        int updateCnt = boardDao.updateBoard(boardForm);
 
        String deleteFile = boardForm.getDelete_file();
        if (!"".equals(deleteFile)) {
 
            String[] deleteFileInfo = deleteFile.split("!");
 
            int boardSeq = Integer.parseInt(deleteFileInfo[0]);
            int fileNo = Integer.parseInt(deleteFileInfo[1]);
 
            BoardFileForm deleteBoardFileForm = new BoardFileForm();
            deleteBoardFileForm.setBoard_seq(boardSeq);
            deleteBoardFileForm.setFile_no(fileNo);
 
            boardDao.deleteBoardFile(deleteBoardFileForm);
        }
 
        List<BoardFileForm> boardFileList = getBoardFileInfo(boardForm);
        for (BoardFileForm boardFileForm : boardFileList) {
            boardDao.insertBoardFile(boardFileForm);
        }
 
        if (updateCnt > 0) {
            boardDto.setResult("SUCCESS");
        } else {
            boardDto.setResult("FAIL");
        }
 
        logger.debug("==================== updateBoard START ====================");
        
        return boardDto;
    }

 

5 ) 게시판 수정/삭제 mapper

 

 

6 ) 게시판 수정/삭제 view boardUpdate

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %>  
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>게시판 수정</title>
<%    
    String boardSeq = request.getParameter("boardSeq");        
%>
 
<c:set var="boardSeq" value="<%=boardSeq%>"/> <!-- 게시글 번호 -->
 
<!-- 공통 CSS -->
<link rel="stylesheet" type="text/css" href="/css/common/common.css"/>
 
<!-- 공통 JavaScript -->
<script type="text/javascript" src="/js/common/jquery.js"></script>
<script type="text/javascript" src="/js/common/jquery.form.js"></script>
<script type="text/javascript">
    
    //자바스크립트의 onclick 가은 기능으로 html이 화면에 뿌려지고 ready안에 서술된 이벤트들이 동작 준비를 하는 것
    $(document).ready(function(){        
        getBoardDetail();        
    });
    
    /** 게시판 - 목록 페이지 이동 */
    function goBoardList(){                
        location.href = "/board/boardList";
    }
    
    /** 게시판 - 상세 조회  */
    function getBoardDetail(boardSeq){
        
        //양식의 값을 가져오거나 값을 설정하는 메소드
        var boardSeq = $("#board_seq").val();
 
        if(boardSeq != ""){
            
            $.ajax({    
                
                url        : "/board/getBoardDetail",
                //데이터를 보내기위해 form요소 집합을 문자열로 인코딩
                data    : $("#boardForm").serialize(),
                dataType: "JSON",
                cache   : false,
                async   : true,
                type    : "POST",    
                success : function(obj) {
                    getBoardDetailCallback(obj);                
                },           
                error     : function(xhr, status, error) {}
                
             });
            
        } else {
            alert("오류가 발생했습니다.\n관리자에게 문의하세요.");
        }    
    }
    
    /** 게시판 - 상세 조회  콜백 함수 */
    function getBoardDetailCallback(obj){
                
        if(obj != null){                                
                            
            var boardSeq        = obj.board_seq; 
            var boardReRef         = obj.board_re_ref; 
            var boardReLev         = obj.board_re_lev; 
            var boardReSeq         = obj.board_re_seq; 
            var boardWriter     = obj.board_writer; 
            var boardSubject     = obj.board_subject; 
            var boardContent     = obj.board_content; 
            var boardHits         = obj.board_hits;
            var delYn             = obj.del_yn; 
            var insUserId         = obj.ins_user_id;
            var insDate         = obj.ins_date; 
            var updUserId         = obj.upd_user_id;
            var updDate         = obj.upd_date;
            var files            = obj.files;        
            var filesLen        = files.length;
                                
            $("#board_subject").val(boardSubject);            
            $("#board_content").val(boardContent);
            $("#board_writer").text(boardWriter);
            
            var fileStr = "";
            
            if(filesLen > 0){
                
                for(var a=0; a<filesLen; a++){
                    
                    var boardSeq    = files[a].board_seq;
                    var fileNo         = files[a].file_no;
                    var fileNameKey = files[a].file_name_key;
                    var fileName     = files[a].file_name;
                    var filePath     = files[a].file_path;
                    var fileSize     = files[a].file_size;
                    var remark         = files[a].remark;
                    var delYn         = files[a].del_yn;
                    var insUserId     = files[a].ins_user_id;
                    var insDate     = files[a].ins_date;
                    var updUserId     = files[a].upd_user_id;
                    var updDate     = files[a].upd_date;
                    
                    fileStr += "<a href='/board/fileDownload?fileNameKey="+encodeURI(fileNameKey)+"&fileName="+encodeURI(fileName)+"&filePath="+encodeURI(filePath)+"'>" + fileName + "</a>";
                    fileStr += "<button type='button' class='btn black ml15' style='padding:3px 5px 6px 5px;' onclick='javascript:setDeleteFile("+ boardSeq +", "+ fileNo +")'>X</button>";
                }            
                                
            } else {
                
                fileStr = "<input type='file' id='files[0]' name='files[0]' value=''></td>";
            }
            
            $("#file_td").html(fileStr);
            
        } else {            
            alert("등록된 글이 존재하지 않습니다.");
            return;
        }        
    }
    
    /** 게시판 - 수정  */
    function updateBoard(){
 
        var boardSubject = $("#board_subject").val();
        var boardContent = $("#board_content").val();
            
        if (boardSubject == ""){            
            alert("제목을 입력해주세요.");
            $("#board_subject").focus();
            return;
        }
        
        if (boardContent == ""){            
            alert("내용을 입력해주세요.");
            $("#board_content").focus();
            return;
        }
        
        var yn = confirm("게시글을 수정하시겠습니까?");        
        if(yn){
                
            var filesChk = $("input[name='files[0]']").val();
            if(filesChk == ""){
                $("input[name='files[0]']").remove();
            }
            
            $("#boardForm").ajaxForm({
            
                url        : "/board/updateBoard",
                enctype    : "multipart/form-data",
                cache   : false,
                async   : true,
                type    : "POST",                         
                success : function(obj) {
                    updateBoardCallback(obj);                
                },           
                error     : function(xhr, status, error) {}
                
            }).submit();
        }
    }
    
    /** 게시판 - 수정 콜백 함수 */
    function updateBoardCallback(obj){
    
        if(obj != null){        
            
            var result = obj.result;
            
            if(result == "SUCCESS"){                
                alert("게시글 수정을 성공하였습니다.");                
                goBoardList();                 
            } else {                
                alert("게시글 수정을 실패하였습니다.");    
                return;
            }
        }
    }
    
    /** 게시판 - 삭제할 첨부파일 정보 */
    function setDeleteFile(boardSeq, fileSeq){
        
        var deleteFile = boardSeq + "!" + fileSeq;        
        $("#delete_file").val(deleteFile);
                
        var fileStr = "<input type='file' id='files[0]' name='files[0]' value=''>";        
        $("#file_td").html(fileStr);        
    }
        
</script>
</head>
<body>
<div id="wrap">
    <div id="container">
        <div class="inner">    
            <h2>게시글 상세</h2>
            <form id="boardForm" name="boardForm" action="/board/updateBoard" enctype="multipart/form-data" method="post" onsubmit="return false;">    
                <table width="100%" class="table02">
                <caption><strong><span class="t_red">*</span> 표시는 필수입력 항목입니다.</strong></caption>
                    <colgroup>
                         <col width="20%">
                        <col width="*">
                    </colgroup>
                    <tbody id="tbody">
                       <tr>
                            <th>제목<span class="t_red">*</span></th>
                            <td><input id="board_subject" name="board_subject" value="" class="tbox01"/></td>
                        </tr>
                         <tr>
                            <th>작성자</th>
                            <td id="board_writer"></td>
                        </tr>
                        <tr>
                            <th>내용<span class="t_red">*</span></th>
                            <td colspan="3"><textarea id="board_content" name="board_content" cols="50" rows="5" class="textarea01"></textarea></td>
                        </tr>
                        <tr>
                            <th>첨부파일</th>
                            <td colspan="3" id="file_td"><input type="file" id="files[0]" name="files[0]" value=""></td>
                        </tr>
                    </tbody>
                </table>    
                <input type="hidden" id="board_seq"        name="board_seq"    value="${boardSeq}"/> <!-- 게시글 번호 -->
                <input type="hidden" id="search_type"    name="search_type"    value="U"/> <!-- 조회 타입 - 상세(S)/수정(U) -->
                <input type="hidden" id="delete_file"    name="delete_file"    value=""/> <!-- 삭제할 첨부파일 -->
            </form>
            <div class="btn_right mt15">
                <button type="button" class="btn black mr5" onclick="javascript:goBoardList();">목록으로</button>
                <button type="button" class="btn black" onclick="javascript:updateBoard();">수정하기</button>
            </div>
        </div>
    </div>
</div>
</body>
</html>

 

 

7 ) 게시글 수정

 

8 ) 게시글 삭제

게시글 삭제시 팝업창을 띄어 한번 더 삭제할 것인지 아닌지 물어봄