Spring Security 게시판 읽기

2. 게시판 읽기(Read)

게시글 상세보기

post.jsp

<main class="mt-5 pt-5">
        <div class="container px-4">
            <!-- 제목 -->
            <!-- insert된 article_Board_type이 '공지사항'이면  -->
            <c:if test="${boardDto.article_Board_type eq '공지사항'}">
                <!-- 제목 : 공지사항 -->
                <!-- 게시판 목록이동 a태그 사용 -->
                <h2 class="writing-header mb-3"><a id="noticeList">공지사항</a></h2>
            </c:if>
            <!-- insert된 article_Board_type이 '이벤트'이면  -->
            <c:if test="${boardDto.article_Board_type eq '이벤트'}">
                <!-- 제목 : 이벤트/행사-->
                <h2 class="writing-header mb-3"><a id="eventList">이벤트/행사</a></h2>
            </c:if>

            <form id="form" class="frm" action="ycc/board/post" method="post">
                <div class="card mb-4">
                    <div class="card-body">
                        <!-- 게시글 정보 -->
                        <input type="hidden" name="article_id" value="${boardDto.article_id }">
                        <h4 class="title" >${boardDto.article_title }</h4>
                        <p class="writingInfo">작성자 : ${boardDto.user_id} |
                            게시일 : <fmt:formatDate value="${boardDto.article_date }" pattern="yyyy-MM-dd" type="date"/> 
                            | 조회수 : ${boardDto.article_viewcnt }
                        </p>
                        <hr>
                        <!-- 내용 -->
                        <p class="content" >${boardDto.article_contents }</p>                           
                    </div>
                </div>              

                <div class="row pb-5" style="float:right">
                    <div class="col-auto px-1" >
                        <a id="listBtn" class="btn btn-outline-secondary" ><i class="bi bi-justify"></i>목록</a>  
                    </div>
                    <!-- 본인이 쓴 게시글에만 수정, 삭제 가능 -->
                    <!-- 세션 아이디와 boardDto에 저장되 아이디가 같으면 수정, 삭제 버튼 활성화 -->
                    <sec:authorize access="isAuthenticated()">
                    <sec:authentication property="principal" var="pinfo"/>
                        <c:if test="${pinfo.member.user_id eq boardDto.user_id}">
                            <div class="col-auto px-1">
                                <button type="button" class="btn btn-outline-success" id="modifyBtn"><i class="bi bi-pen"></i>수정</button>
                            </div>
                            <div class="col-auto px-1">
                                <button type="button" class="btn btn-outline-danger" id="deleteBtn"><i class="bi bi-trash3"></i>삭제</button>
                            </div>
                        </c:if>
                    </sec:authorize>
                <input type="hidden" name="${_csrf.parameterName}" value="${_csrf.token}">
               </div>
           </form>

               <!-- 이전글, 다음글  -->
               <div class="prevNext">
                    <table class="table table-bordered table-hover" style="border-radius:5px;">
                        <colgroup>
                            <col width="120px;">
                            <col width="auto;">
                        </colgroup>
                            <tbody>
                                <tr>
                                    <th scope="row" class="text-center table-primary"  >이전글<i class="bi bi-caret-up-fill"></i></th>
                                        <td class="pre" id="preTitle"> 
                                            <c:if test ="${preView.preId != 9999}">
                                                <a style="text-decoration: none; color: black;"
                                                 href="<c:url value="/board/post?article_id=${preView.preId  }"/>">  
                                                ${preView.preTitle}</a>
                                            </c:if>
                                            <c:if test = "${preView.preId == 9999}">
                                                <div class="fs-6" style="font-size: bold;">이전글이 없습니다.</div>
                                            </c:if>
                                        </td>
                                </tr>
                                <tr>
                                    <th scope="row" class="text-center table-primary">다음글<i class="bi bi-caret-down-fill"></i></th>
                                        <td  class="next" id="nextTitle">
                                            <c:if test ="${nextView.nextId != 9999}" >
                                                <a style="text-decoration: none; color: black; "
                                                 href="<c:url value="/board/post?article_id=${nextView.nextId  }"/>">
                                                ${nextView.nextTitle}</a>
                                            </c:if>
                                            <c:if test ="${nextView.nextId == 9999}">
                                                <div class="fs-6" style="font-size: bold;">다음글이 없습니다.</div>
                                            </c:if>
                                        </td>
                                </tr>
                            </tbody>
                    </table>
                </div>
                </div>
        </main>

post.jsp


<script>

$(document).ready(function(){

    //공지사항 클릭시 공지사항 첫 페이지로 이동 
    $("#noticeList").on("click", function() {
        location.href ="<c:url value='/board/notice'/>";
    })

    //이벤트/행사 클릭시 이벤트/행사 첫 페이지로 이동
    $("#eventList").on("click", function() {
    location.href ="<c:url value='/board/event'/>";
    })

    //목록버튼 클릭 시 해당url로 이동
    $("#listBtn").on("click", function() {
        location.href ="<c:url value='/board/notice${searchItem.queryString}' />";
    })


- 게시글 읽기 로직
- BoardController.java
```jsx
//게시글 상세 보기 
@GetMapping("/post")
public String postSelect(SearchItem sc, Integer article_id, Model m) {

    try {
        BoardDto boardDto = boardService.postSelect(article_id);
        m.addAttribute("boardDto", boardDto);

        //이전글: article_id를 boardService의 movePage를 model에 담음 
        m.addAttribute("preView", boardService.movePage(article_id));
        //다음글: article_id를 boardService의 movePage를 model에 담음
        m.addAttribute("nextView", boardService.movePage(article_id));

    } catch(Exception e) {
        e.printStackTrace();
        //예외 발생시 게시판 페이지로 이동 요청 
        return "redirect:/board/notice";
    }

    return "board/post";
}

BoardServicceImpl.java


//상세보기 
@Override
public BoardDto postSelect(Integer article_id) throws Exception {
//조회수 증가 로직 추가 
boardDao.PlusViewCnt(article_id);
// 게시글      
BoardDto boardDto = boardDao.postSelect(article_id);

return boardDto;
}

//상세보기 : 이전글, 다음글 @Override public BoardDto movePage(Integer article_id) throws Exception { return boardDao.movePage(article_id); }


- BoardDaoImpl.java
```java
//상세보기 
@Override
public BoardDto postSelect(Integer article_id) throws Exception {
    return session.selectOne(namespace + "postSelect", article_id );
}
//상세보기 : 이전글, 다음글 
@Override
public BoardDto movePage(Integer article_id) throws Exception {
    return session.selectOne(namespace + "movePage", article_id);
}
//조회수증가
@Override
public int PlusViewCnt(Integer article_id) throws Exception {
    return session.update(namespace + "PlusViewCnt" , article_id);
}

boardMapper.xml


<sql id="selectFromBoard">
SELECT article_id, article_date, article_Board_type, user_id,
            article_title, article_contents, article_viewcnt
FROM article
</sql>

update article set article_viewcnt = article_viewcnt + 1 where article_id = #{article_id}



> **조회수 증가!**
>

Berry-G / YoungCultureCenter

Spring Security 게시판 읽기 #124

2. 게시판 읽기(Read)