Controller
package kr.or.ddit.controller.noticeboard.web;
import javax.inject.Inject;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import kr.or.ddit.controller.noticeboard.service.INoticeService;
import kr.or.ddit.vo.NoticeVO;
import lombok.extern.slf4j.Slf4j;
@Controller
@RequestMapping("/notice")
@Slf4j
public class NoticeRetrieveController {
@Inject
private INoticeService noticeService;
@RequestMapping(value="/list.do")
public String noticeList() {
log.info("noticeList() 실행...!");
// 해당경로는 tiles 에서 설정한 경로 이름
return "notice/list";
}
**//상세보기 메소드**
@RequestMapping(value="/detail.do")
public String noticeDetail(int boNo, Model model) {
NoticeVO noticeVO = noticeService.selectNotice(boNo);
model.addAttribute("notice", noticeVO);
return "notice/detail";
}
}
Service
package kr.or.ddit.controller.noticeboard.service;
import javax.inject.Inject;
import org.apache.commons.io.input.TaggedInputStream;
import org.springframework.stereotype.Service;
import kr.or.ddit.ServiceResult;
import kr.or.ddit.controller.noticeboard.web.TelegramSendController;
import kr.or.ddit.mapper.NoticeMapper;
import kr.or.ddit.vo.NoticeVO;
@Service
public class NoticeServiceImpl implements INoticeService {
@Inject
private NoticeMapper noticeMapper;
TelegramSendController tst = new TelegramSendController();
@Override
public ServiceResult insertNotice(NoticeVO noticeVO) {
ServiceResult result = null;
int status = noticeMapper.insertNotice(noticeVO);
if(status > 0) {
// 성공 했다는 메시지를 텔레그램 BOT API를 이용하여 알림!
try {
tst.sendGet("조성희", noticeVO.getBoTitle());
} catch (Exception e) {
e.printStackTrace();
}
result = ServiceResult.OK;
}else {
result = ServiceResult.FAILED;
}
return result;
}
**// 조회수 증가와 상세보기 서비스**
@Override
public NoticeVO selectNotice(int boNo) {
noticeMapper.incrementHit(boNo); //조회수 증가
return noticeMapper.selectNotice(boNo);
}
}
Mapper
package kr.or.ddit.mapper;
import kr.or.ddit.vo.NoticeVO;
public interface NoticeMapper {
public int insertNotice(NoticeVO noticeVO);
public int incrementHit(int boNo);
public NoticeVO selectNotice(int boNo);
}
NoticeMapper (SQL)
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"<https://mybatis.org/dtd/mybatis-3-mapper.dtd>">
<mapper namespace="kr.or.ddit.mapper.NoticeMapper">
<resultMap type="noticeVO" id="noticeMap">
<id property="boNo" column="bo_no"/>
<result property="boNo" column="bo_no"/>
<result property="boTitle" column="bo_title"/>
<result property="boContent" column="bo_content"/>
<result property="boWriter" column="bo_writer"/>
<result property="boDate" column="bo_date"/>
<result property="boHit" column="bo_hit"/>
<collection property="noticeFileList" resultMap="noticeFileMap"/>
</resultMap>
<resultMap type="noticeFileVO" id="noticeFileMap">
<id property="fileNo" column="file_no"/>
<result property="fileNo" column="file_no"/>
<result property="fileName" column="file_name"/>
<result property="fileSize" column="file_size"/>
<result property="fileFancysize" column="file_fancysize"/>
<result property="fileMime" column="file_mime"/>
<result property="fileSavepath" column="file_savepath"/>
<result property="fileDowncount" column="file_downcount"/>
</resultMap>
<!-- 공지사항 등록하는 쿼리 -->
<insert id="insertNotice" parameterType="noticeVO" useGeneratedKeys="true">
<selectKey keyProperty="boNo" resultType="int" order="BEFORE">
select seq_notice.nextval from dual
</selectKey>
insert into notice(
bo_no, bo_title, bo_content, bo_writer, bo_date
)values(
#{boNo}, #{boTitle}, #{boContent}, #{boWriter}, sysdate
)
</insert>
**<!-- 조회수 증가 쿼리 -->**
<update id="incrementHit" parameterType="int">
update notice
set
bo_hit = bo_hit + 1
where bo_no = #{boNo}
</update>
**<!-- 상세보기 쿼리 -->**
<select id="selectNotice" parameterType="int" resultMap="noticeMap">
select
n.bo_no, bo_title, bo_content, bo_writer,
to_char(bo_date, 'yy-mm-dd hh24:mi:ss') bo_date, bo_hit,
file_no, file_name, file_size, file_fancysize, file_mime, file_savepath, file_downcount
from notice n left outer join noticefile nf on(n.bo_no = nf.bo_no)
where n.bo_no = #{boNo}
</select>
</mapper>
JSP 페이지
<%@page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
<%@ taglib uri="<http://tiles.apache.org/tags-tiles>" prefix="tiles" %>
<%@ taglib uri="<http://java.sun.com/jsp/jstl/core>" prefix="c" %>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>AdminLTE 3 | Simple Tables</title>
<link rel="stylesheet" href="<https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700&display=fallback>">
<link rel="stylesheet" href="${pageContext.request.contextPath }/resources/plugins/fontawesome-free/css/all.min.css">
<link rel="stylesheet" href="${pageContext.request.contextPath }/resources/dist/css/adminlte.min.css">
<script src="${pageContext.request.contextPath }/resources/plugins/jquery/jquery.min.js"></script>
<script src="${pageContext.request.contextPath }/resources/ckeditor/ckeditor.js"></script>
</head>
<c:if test="${not empty message }">
<script type="text/javascript">
alert("${message}");
<c:remove var="message" scope="request"/>
<c:remove var="message" scope="session"/>
</script>
</c:if>
<body class="hold-transition sidebar-mini">
<div class="wrapper">
<!-- header 영역 -->
<tiles:insertAttribute name="header"/>
<div class="content-wrapper">
<!-- content 영역 -->
<tiles:insertAttribute name="content"/>
</div>
<!-- footer 영역 -->
<tiles:insertAttribute name="footer"/>
<aside class="control-sidebar control-sidebar-dark">
</aside>
</div>
<script src="${pageContext.request.contextPath }/resources/plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
<script src="${pageContext.request.contextPath }/resources/dist/js/adminlte.min.js"></script>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib uri="<http://java.sun.com/jsp/jstl/core>" prefix="c" %>
<!-- Content Header (Page header) -->
<section class="content-header">
<div class="container-fluid">
<div class="row mb-2">
<div class="col-sm-6">
<h1>공지사항 상세보기</h1>
</div>
<div class="col-sm-6">
<ol class="breadcrumb float-sm-right">
<li class="breadcrumb-item"><a href="#">DDIT HOME</a></li>
<li class="breadcrumb-item active">공지사항 상세보기</li>
</ol>
</div>
</div>
</div>
<!-- /.container-fluid -->
</section>
<!-- Main content -->
<section class="content">
<div class="container-fluid">
<div class="row">
<div class="col-md-12">
<div class="card card-primary">
<div class="card-header">
<h3 class="card-title">${notice.boTitle }</h3>
<div class="card-tools">${notice.boWriter } ${notice.boDate } ${notice.boHit }</div>
</div>
<form id="quickForm" novalidate="novalidate">
<div class="card-body">${notice.boContent }</div>
<div class="card-footer bg-white">
<ul class="mailbox-attachments d-flex align-items-stretch clearfix">
<c:if test="${not empty notice.noticeFileList }">
<c:forEach items="${notice.noticeFileList }" var="noticeFile" varStatus="vs">
<li>
<span class="mailbox-attachment-icon">
<i class="far fa-file-pdf"></i>
</span>
<div class="mailbox-attachment-info">
<a href="#" class="mailbox-attachment-name">
<i class="fas fa-paperclip"></i> ${noticeFile.fileName }
</a>
<span class="mailbox-attachment-size clearfix mt-1">
<span>${noticeFile.fileFancysize }</span>
<c:url value="/notice/download.do" var="downloadURL">
<c:param name="fileNo" value="${noticeFile.fileNo }"/>
</c:url>
<a href="${downloadURL }">
<span class="btn btn-default btn-sm float-right">
<i class="fas fa-download"></i>
</span>
</a>
</span>
</div>
</li>
</c:forEach>
</c:if>
</ul>
</div>
<div class="card-footer">
<button type="button" id="btnList" class="btn btn-primary">목록</button>
<button type="button" id="btnModify" class="btn btn-info">수정</button>
<button type="button" id="btnDelete" class="btn btn-danger">삭제</button>
</div>
</form>
</div>
</div>
<form action="/notice/delete.do" method="post" id="noticeForm">
<input type="hidden" name="boNo" value="${notice.boNo }">
</form>
<div class="col-md-6"></div>
</div>
</div>
</section>
<script>
$(function(){
var btnList = $("#btnList");
var btnModify = $("#btnModify");
var btnDelete = $("#btnDelete");
var noticeForm = $("#noticeForm");
// 목록 버튼 클릭 시 이벤트
btnList.on("click", function(){
location.href = "/notice/list.do"
});
// 수정 버튼 클릭 시 이벤트
btnModify.on("click", function(){
noticeForm.attr("method", "get");
noticeForm.attr("action", "/notice/update.do");
noticeForm.submit();
});
// 삭제 버튼 클릭 시 이벤트
btnDelete.on("click", function(){
if(confirm("정말 삭제하시겠습니까?")){
noticeForm.submit();
}
});
});
</script>
CKEDITOR 파일