231121_SPRING 1 (5-3) - 공지사항 게시판 과제

[NoticeVO.java]

package kr.or.ddit.vo;

import lombok.Data;

@Data
public class NoticeVO {

	private int noticeNo;
	private String noticeTitle;
	private String noticeContent;
	private String noticeWriter;
	private String noticeDate;
	private int noticeHit;
	
}

[mybatisAlias.xml]

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
  PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  "https://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>

	<settings>
		<setting name="mapUnderscoreToCamelCase" value="true" />
	</settings>
	
	<typeAliases>
		<typeAlias type="kr.or.ddit.vo.BoardVO" alias="boardVO" />
		<typeAlias type="kr.or.ddit.vo.PaginationInfoVO" alias="pagingVO" />
		<typeAlias type="kr.or.ddit.vo.FreeVO" alias="freeVO" />
		<typeAlias type="kr.or.ddit.vo.NoticeVO" alias="noticeVO" />
	</typeAliases>

</configuration>

[INoticeService.java]

package kr.or.ddit.notice.service;

import java.util.List;

import kr.or.ddit.ServiceResult;
import kr.or.ddit.vo.NoticeVO;
import kr.or.ddit.vo.PaginationInfoVO;

public interface INoticeService {

	public ServiceResult insertNotice(NoticeVO noticeVO);
	public NoticeVO selectNotice(int noticeNo);
	public ServiceResult updateNotice(NoticeVO noticeVO);
	public ServiceResult deleteNotice(int noticeNo);
	public int selectNoticeCount(PaginationInfoVO<NoticeVO> pagingVO);
	public List<NoticeVO> selectNoticeList(PaginationInfoVO<NoticeVO> pagingVO);
	public List<NoticeVO> selectNoticeList_();
	
}

[NoticeServiceImpl.java]

package kr.or.ddit.notice.service;

import java.util.List;

import javax.inject.Inject;

import org.springframework.stereotype.Service;

import kr.or.ddit.ServiceResult;
import kr.or.ddit.notice.dao.INoticeDAO;
import kr.or.ddit.vo.NoticeVO;
import kr.or.ddit.vo.PaginationInfoVO;

@Service
public class NoticeServiceImpl implements INoticeService {

	@Inject
	private INoticeDAO noticeDao;
	
	@Override
	public ServiceResult insertNotice(NoticeVO noticeVO) {
		ServiceResult result = null;
		int status = noticeDao.insertNotice(noticeVO);
		if(status > 0) { // 성공
			result = ServiceResult.OK;
		}else { // 실패
			result = ServiceResult.FAILED;
		}
		return result;
	}
	
	@Override
	public NoticeVO selectNotice(int noticeNo) {
		// 조회수 증가
		noticeDao.incrementHit(noticeNo);
		return noticeDao.selectNotice(noticeNo);
	}
	
	@Override
	public ServiceResult updateNotice(NoticeVO noticeVO) {
		ServiceResult result = null;
		int status = noticeDao.updateNotice(noticeVO);
		if(status > 0) { // 성공
			result = ServiceResult.OK;
		}else { // 실패
			result = ServiceResult.FAILED;
		}
		return result;
	}
	
	@Override
	public ServiceResult deleteNotice(int noticeNo) {
		ServiceResult result = null;
		int status = noticeDao.deleteNotice(noticeNo);
		if(status > 0) { // 성공
			result = ServiceResult.OK;
		}else { // 실패
			result = ServiceResult.FAILED;
		}
		return result;
	}
	
	@Override
	public int selectNoticeCount(PaginationInfoVO<NoticeVO> pagingVO) {
		return noticeDao.selectNoticeCount(pagingVO);
	}
	
	@Override
	public List<NoticeVO> selectNoticeList(PaginationInfoVO<NoticeVO> pagingVO) {
		return noticeDao.selectNoticeList(pagingVO);
	}
	
	@Override
	public List<NoticeVO> selectNoticeList_() {
		return noticeDao.selectNoticeList_();
	}
	
}

[INoticeDAO.java]

package kr.or.ddit.notice.dao;

import java.util.List;

import kr.or.ddit.vo.NoticeVO;
import kr.or.ddit.vo.PaginationInfoVO;

public interface INoticeDAO {

	public int insertNotice(NoticeVO noticeVO);
	public void incrementHit(int noticeNo);
	public NoticeVO selectNotice(int noticeNo);
	public int updateNotice(NoticeVO noticeVO);
	public int deleteNotice(int noticeNo);
	public int selectNoticeCount(PaginationInfoVO<NoticeVO> pagingVO);
	public List<NoticeVO> selectNoticeList(PaginationInfoVO<NoticeVO> pagingVO);
	public List<NoticeVO> selectNoticeList_();
	
}

[NoticeDAOImpl.java]

package kr.or.ddit.notice.dao;

import java.util.List;

import javax.inject.Inject;

import org.mybatis.spring.SqlSessionTemplate;
import org.springframework.stereotype.Repository;

import kr.or.ddit.vo.NoticeVO;
import kr.or.ddit.vo.PaginationInfoVO;

@Repository
public class NoticeDAOImpl implements INoticeDAO {

	@Inject
	private SqlSessionTemplate sqlSession;
	
	@Override
	public int insertNotice(NoticeVO noticeVO) {
		return sqlSession.insert("Notice.insertNotice", noticeVO);
	}
	
	@Override
	public void incrementHit(int noticeNo) {
		sqlSession.update("Notice.incrementHit", noticeNo);
	}
	
	@Override
	public NoticeVO selectNotice(int noticeNo) {
		return sqlSession.selectOne("Notice.selectNotice", noticeNo);
	}
	
	@Override
	public int updateNotice(NoticeVO noticeVO) {
		return sqlSession.update("Notice.updateNotice", noticeVO);
	}
	
	@Override
	public int deleteNotice(int noticeNo) {
		return sqlSession.delete("Notice.deleteNotice", noticeNo);
	}
	
	@Override
	public int selectNoticeCount(PaginationInfoVO<NoticeVO> pagingVO) {
		return sqlSession.selectOne("Notice.selectNoticeCount", pagingVO);
	}
	
	@Override
	public List<NoticeVO> selectNoticeList(PaginationInfoVO<NoticeVO> pagingVO) {
		return sqlSession.selectList("Notice.selectNoticeList", pagingVO);
	}
	
	@Override
	public List<NoticeVO> selectNoticeList_() {
		return sqlSession.selectList("Notice.selectNoticeList_");
	}
	
}

[notice_SQL.xml]

<?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="Notice">

	<sql id="noticeSearch">
		<if test="searchType != null and searchType == 'title'">
			and (notice_title like '%' || #{searchWord} || '%')
		</if>
		<if test="searchType != null and searchType == 'writer'">
			and (notice_writer like '%' || #{searchWord} || '%')
		</if>
	</sql>

	<insert id="insertNotice" parameterType="noticeVO" useGeneratedKeys="true">
		<selectKey keyProperty="noticeNo" resultType="int" order="BEFORE">
			select seq_notice.nextval from dual
		</selectKey>
		insert into notice(
			notice_no, notice_title, notice_content, notice_writer, notice_date
		)values(
			#{noticeNo}, #{noticeTitle}, #{noticeContent}, #{noticeWriter}, sysdate
		)
	</insert>
	
	<update id="incrementHit" parameterType="int">
		update notice 
		set 
			notice_hit = notice_hit + 1 
		where notice_no = #{noticeNo}
	</update>
	
	<select id="selectNotice" parameterType="int" resultType="noticeVO">
		select 
			notice_no, notice_title, notice_content, notice_writer, notice_date, notice_hit 
		from notice 
		where notice_no = #{noticeNo}
	</select>
	
	<update id="updateNotice" parameterType="noticeVO">
		update notice 
		set 
			notice_title = #{noticeTitle}, 
			notice_content = #{noticeContent}, 
			notice_date = sysdate 
		where notice_no = #{noticeNo}
	</update>
	
	<delete id="deleteNotice" parameterType="int">
		delete from notice 
		where notice_no = #{noticeNo}
	</delete>
	
	<select id="selectNoticeCount" parameterType="pagingVO" resultType="int">
		select count(notice_no) from notice 
		where 1=1 
		<include refid="noticeSearch" /> 
	</select>
	
	<select id="selectNoticeList" parameterType="pagingVO" resultType="noticeVO">
		select b.*
		from (
			select
				a.*, row_number() over (order by a.notice_no desc) rnum
			from (
				select 
					notice_no, notice_title, notice_content, notice_writer, notice_date, notice_hit 
				from notice 
				where 1=1 
				<include refid="noticeSearch" /> 
				order by notice_no desc
			) a
		) b
		<![CDATA[
			where b.rnum >= #{startRow} and b.rnum <= #{endRow}
		]]>
	</select>
	
	<select id="selectNoticeList_" resultType="noticeVO">
		<![CDATA[
		select *
		  from (
		     select 
					notice_no, notice_title, notice_content, notice_writer, notice_date, notice_hit 
				from notice 
		     order by notice_no desc
		  )
		where rownum <= 5
		]]>
	</select>

</mapper>

[NoticeRetreiveController.java]

package kr.or.ddit.notice.web;

import java.util.List;

import javax.inject.Inject;

import org.apache.commons.lang3.StringUtils;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;

import kr.or.ddit.notice.service.INoticeService;
import kr.or.ddit.vo.NoticeVO;
import kr.or.ddit.vo.PaginationInfoVO;

@Controller
@RequestMapping("/notice")
public class NoticeRetreiveController {

	@Inject
	private INoticeService noticeService;
	
	@RequestMapping(value = "/list.do")
	public String noticeList(
				@RequestParam(name="page", required = false, defaultValue = "1") int currentPage, 
				@RequestParam(required = false, defaultValue = "title") String searchType, 
				@RequestParam(required = false) String searchWord,
				Model model) {
		
		PaginationInfoVO<NoticeVO> pagingVO = new PaginationInfoVO<NoticeVO>();
		
		// 검색 키워드가 있으면 검색을 한 것으로 기준을 잡는다.
		if(StringUtils.isNotBlank(searchWord)) {
			pagingVO.setSearchType(searchType);
			pagingVO.setSearchWord(searchWord);
			model.addAttribute("searchType", searchType);
			model.addAttribute("searchWord", searchWord);
		}
		
		pagingVO.setCurrentPage(currentPage);
		int totalRecord = noticeService.selectNoticeCount(pagingVO);
		pagingVO.setTotalRecord(totalRecord);
		List<NoticeVO> dataList = noticeService.selectNoticeList(pagingVO);
		pagingVO.setDataList(dataList);
		
		model.addAttribute("pagingVO", pagingVO);
		
		return "notice/list";
	}
	
	@RequestMapping(value = "/detail.do", method = RequestMethod.GET)
	public String noticeDetail(int noticeNo, Model model) {
		NoticeVO noticeVO = noticeService.selectNotice(noticeNo);
		model.addAttribute("notice", noticeVO);
		return "notice/view";
	}
	
}

[NoticeModifyController.java]

package kr.or.ddit.notice.web;

import javax.inject.Inject;

import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;

import kr.or.ddit.ServiceResult;
import kr.or.ddit.notice.service.INoticeService;
import kr.or.ddit.vo.FreeVO;
import kr.or.ddit.vo.NoticeVO;

@Controller
@RequestMapping("/notice")
public class NoticeModifyController {

	@Inject
	private INoticeService noticeService;
	
	@RequestMapping(value = "/update.do", method = RequestMethod.GET)
	public String noticeUpdateForm(int noticeNo, Model model) {
		NoticeVO noticeVO = noticeService.selectNotice(noticeNo);
		model.addAttribute("notice", noticeVO);
		model.addAttribute("status", "u");
		return "notice/form";
	}
	
	@RequestMapping(value = "/update.do", method = RequestMethod.POST)
	public String noticeUpdate(NoticeVO noticeVO, Model model) {
		String goPage = "";
		
		ServiceResult result = noticeService.updateNotice(noticeVO);
		if(result.equals(ServiceResult.OK)) { // 수정 성공
			goPage = "redirect:/notice/detail.do?noticeNo=" + noticeVO.getNoticeNo();
		}else { // 수정 실패
			model.addAttribute("notice", noticeVO);
			model.addAttribute("status", "u");
			goPage = "notice/form";
		}
		
		return goPage;
	}
	
	@RequestMapping(value = "/delete.do", method = RequestMethod.POST)
	public String deleteNotice(int noticeNo, Model model) {
		String goPage = "";
		
		ServiceResult result = noticeService.deleteNotice(noticeNo);
		if(result.equals(ServiceResult.OK)) { // 삭제 성공
			goPage = "redirect:/notice/list.do";
		}else {
			goPage = "redirect:/notice/detail.do?noticeNo=" + noticeNo;
		}
		
		return goPage;
	}
	
}

[NoticeInsertController.java]

package kr.or.ddit.notice.web;

import java.util.HashMap;
import java.util.Map;

import javax.inject.Inject;

import org.apache.commons.lang3.StringUtils;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;

import kr.or.ddit.ServiceResult;
import kr.or.ddit.notice.service.INoticeService;
import kr.or.ddit.vo.NoticeVO;

@Controller
@RequestMapping("/notice")
public class NoticeInsertController {

	@Inject
	private INoticeService noticeService;
	
	@RequestMapping(value = "/form.do", method = RequestMethod.GET)
	public String noticeForm() {
		return "notice/form";
	}
	
	@RequestMapping(value = "/insert.do", method = RequestMethod.POST)
	public String noticeInsert(NoticeVO noticeVO, Model model) {
		String goPage = "";
		
		Map<String, String> errors = new HashMap<String, String>();
		if(StringUtils.isBlank(noticeVO.getNoticeTitle())) {
			errors.put("noticeTitle", "제목을 입력해 주세요!");
		}
		if(StringUtils.isBlank(noticeVO.getNoticeContent())) {
			errors.put("noticeContent", "내용을 입력해 주세요!");
		}
		
		if(errors.size() > 0) { // 에러가 있음
			model.addAttribute("notice", noticeVO);
			model.addAttribute("errors", errors);
			goPage = "notice/form"; // 포워딩
		}else { // 에러가 없는 정상적인 데이터 입력
			noticeVO.setNoticeWriter("c001");
			ServiceResult result = noticeService.insertNotice(noticeVO);
			if(result.equals(ServiceResult.OK)) {
				goPage = "redirect:/notice/detail.do?noticeNo=" + noticeVO.getNoticeNo();
			}else {
				model.addAttribute("notice", noticeVO);
				model.addAttribute("message", "서버 에러, 다시 시도해 주세요!");
				goPage = "notice/form"; // 포워딩
			}
		}
		
		return goPage;
	}
	
}

[form.jsp]

<%@ page contentType="text/html; charset=utf-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ page contentType="text/html; charset=utf-8"%>
<html>

<head>
    <link href="${pageContext.request.contextPath }/resources/css/bootstrap.min.css" rel="stylesheet">
    <link rel="stylesheet" href="${pageContext.request.contextPath }/resources/css/headers.css">
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.7.1/jquery.min.js"></script>
    <script type="text/javascript" src="${pageContext.request.contextPath }/resources/ckeditor/ckeditor.js"></script>
    <title>공지사항게시판 등록/수정</title>
</head>
<style>
    .bi {
        vertical-align: -.125em;
        fill: currentColor;
    }
</style>

<body>

	<c:set value="등록" var="name" />
	<c:if test="${status eq 'u' }">
		<c:set value="수정" var="name" />
	</c:if>

    <svg xmlns="http://www.w3.org/2000/svg" style="display: none;">
        <symbol id="bootstrap" viewBox="0 0 118 94">
            <title>Bootstrap</title>
            <path fill-rule="evenodd" clip-rule="evenodd" d="M24.509 0c-6.733 0-11.715 5.893-11.492 12.284.214 6.14-.064 14.092-2.066 20.577C8.943 39.365 5.547 43.485 0 44.014v5.972c5.547.529 8.943 4.649 10.951 11.153 2.002 6.485 2.28 14.437 2.066 20.577C12.794 88.106 17.776 94 24.51 94H93.5c6.733 0 11.714-5.893 11.491-12.284-.214-6.14.064-14.092 2.066-20.577 2.009-6.504 5.396-10.624 10.943-11.153v-5.972c-5.547-.529-8.934-4.649-10.943-11.153-2.002-6.484-2.28-14.437-2.066-20.577C105.214 5.894 100.233 0 93.5 0H24.508zM80 57.863C80 66.663 73.436 72 62.543 72H44a2 2 0 01-2-2V24a2 2 0 012-2h18.437c9.083 0 15.044 4.92 15.044 12.474 0 5.302-4.01 10.049-9.119 10.88v.277C75.317 46.394 80 51.21 80 57.863zM60.521 28.34H49.948v14.934h8.905c6.884 0 10.68-2.772 10.68-7.727 0-4.643-3.264-7.207-9.012-7.207zM49.948 49.2v16.458H60.91c7.167 0 10.964-2.876 10.964-8.281 0-5.406-3.903-8.178-11.425-8.178H49.948z"></path>
        </symbol>
        <symbol id="home" viewBox="0 0 16 16">
            <path d="M8.354 1.146a.5.5 0 0 0-.708 0l-6 6A.5.5 0 0 0 1.5 7.5v7a.5.5 0 0 0 .5.5h4.5a.5.5 0 0 0 .5-.5v-4h2v4a.5.5 0 0 0 .5.5H14a.5.5 0 0 0 .5-.5v-7a.5.5 0 0 0-.146-.354L13 5.793V2.5a.5.5 0 0 0-.5-.5h-1a.5.5 0 0 0-.5.5v1.293L8.354 1.146zM2.5 14V7.707l5.5-5.5 5.5 5.5V14H10v-4a.5.5 0 0 0-.5-.5h-3a.5.5 0 0 0-.5.5v4H2.5z" />
        </symbol>
        <symbol id="grid" viewBox="0 0 16 16">
            <path d="M1 2.5A1.5 1.5 0 0 1 2.5 1h3A1.5 1.5 0 0 1 7 2.5v3A1.5 1.5 0 0 1 5.5 7h-3A1.5 1.5 0 0 1 1 5.5v-3zM2.5 2a.5.5 0 0 0-.5.5v3a.5.5 0 0 0 .5.5h3a.5.5 0 0 0 .5-.5v-3a.5.5 0 0 0-.5-.5h-3zm6.5.5A1.5 1.5 0 0 1 10.5 1h3A1.5 1.5 0 0 1 15 2.5v3A1.5 1.5 0 0 1 13.5 7h-3A1.5 1.5 0 0 1 9 5.5v-3zm1.5-.5a.5.5 0 0 0-.5.5v3a.5.5 0 0 0 .5.5h3a.5.5 0 0 0 .5-.5v-3a.5.5 0 0 0-.5-.5h-3zM1 10.5A1.5 1.5 0 0 1 2.5 9h3A1.5 1.5 0 0 1 7 10.5v3A1.5 1.5 0 0 1 5.5 15h-3A1.5 1.5 0 0 1 1 13.5v-3zm1.5-.5a.5.5 0 0 0-.5.5v3a.5.5 0 0 0 .5.5h3a.5.5 0 0 0 .5-.5v-3a.5.5 0 0 0-.5-.5h-3zm6.5.5A1.5 1.5 0 0 1 10.5 9h3a1.5 1.5 0 0 1 1.5 1.5v3a1.5 1.5 0 0 1-1.5 1.5h-3A1.5 1.5 0 0 1 9 13.5v-3zm1.5-.5a.5.5 0 0 0-.5.5v3a.5.5 0 0 0 .5.5h3a.5.5 0 0 0 .5-.5v-3a.5.5 0 0 0-.5-.5h-3z" />
        </symbol>
    </svg>
    <main>
        <header>
            <div class="px-3 py-2 text-bg-dark">
                <div class="container">
                    <div class="d-flex flex-wrap align-items-center justify-content-center justify-content-lg-start">
                        <a href="/" class="d-flex align-items-center my-2 my-lg-0 me-lg-auto text-white text-decoration-none">
                            <svg class="bi me-2" width="40" height="32" role="img" aria-label="Bootstrap">
                                <use xlink:href="#bootstrap" />
                            </svg>
                        </a>
                        <ul class="nav col-12 col-lg-auto my-2 justify-content-center my-md-0 text-small">
                            <li>
                                <a href="/main.do" class="nav-link text-white">
                                    <svg class="bi d-block mx-auto mb-1" width="24" height="24">
                                        <use xlink:href="#home" />
                                    </svg> Home
                                </a>
                            </li>
                            <li>
                                <a href="/board/list.do" class="nav-link text-white">
                                    <svg class="bi d-block mx-auto mb-1" width="24" height="24">
                                        <use xlink:href="#grid" />
                                    </svg> 일반게시판
                                </a>
                            </li>
                            <li>
                                <a href="/notice/list.do" class="nav-link text-white">
                                    <svg class="bi d-block mx-auto mb-1" width="24" height="24">
                                        <use xlink:href="#grid" />
                                    </svg> 공지사항게시판
                                </a>
                            </li>
                            <li>
                                <a href="/free/list.do" class="nav-link text-white">
                                    <svg class="bi d-block mx-auto mb-1" width="24" height="24">
                                        <use xlink:href="#grid" />
                                    </svg> 자유게시판
                                </a>
                            </li>
                        </ul>
                    </div>
                </div>
            </div>
        </header>

        <div class="position-relative overflow-hidden p-3 p-md-8 m-md-8 text-center bg-white">
            <div class="col-md-8 p-lg-8 mx-auto my-5">
                <h4 class="display-4 fw-normal">공지사항게시판</h4>
                <p class="lead fw-normal">공지사항게시판 CRUD를 작성해주세요.</p>
            </div>
            <div class="product-device shadow-sm d-none d-md-block"></div>
            <div class="product-device product-device-2 shadow-sm d-none d-md-block"></div>
        </div>

        <div class="container">
            <div class="row">
                <div class="col-md-12">
                    <div class="">
                        <div class="card-body">
                            <form method="post" action="/notice/insert.do" id="boardForm" name="boardForm" class="form-horizontal">
                                
                                <c:if test="${status eq 'u' }">
	                            	<input type="hidden" name="noticeNo" value="${notice.noticeNo }" />
                            	</c:if>
                                
                                <div class="form-group row">
                                    <label class="col-sm-2 control-label">제목</label>
                                    <div class="col-sm-10">
                                        <input id="noticeTitle" name="noticeTitle" type="text" class="form-control" value="${notice.noticeTitle }" placeholder="subject">
                                    </div>
                                    <font color="red" style="font-size: 12px;">${errors.noticeTitle }</font>
                                </div>
                                <div class="form-group row mt-4">
                                    <label class="col-sm-2 control-label">내용</label>
                                    <div class="col-sm-10">
                                        <textarea id="noticeContent" name="noticeContent" cols="50" rows="5" class="form-control" placeholder="content">${notice.noticeContent }</textarea>
                                    </div>
                                    <font color="red" style="font-size: 12px;">${errors.noticeContent }</font>
                                </div>
                                <div class="form-group row mt-4">
                                    <div class="col-sm-offset-2 col-sm-12 ">
                                        
                                        <input type="button" value="${name }" class="btn btn-primary float-right" id="addBtn">
                                        
                                        <c:if test="${status eq 'u' }">
                                        	<input type="button" value="취소" class="btn btn-danger float-right" id="cancelBtn">
                                        </c:if>
                                        
                                        <c:if test="${status ne 'u' }">
                                        	<input type="button" value="목록" class="btn btn-success float-right" id="listBtn">
                                    	</c:if>
                                    
                                    </div>
                                </div>
                            </form>
                        </div>
                    </div>
                </div>
                <div class="col-md-12"><br /><br /><br /></div>
            </div>
        </div>
    </main>
</body>
<script type="text/javascript">
	$(function(){
		CKEDITOR.replace("noticeContent"); // CKEDITOR를 textarea에 등록
		
		var addBtn = $("#addBtn"); // 등록 버튼
		var cancelBtn = $("#cancelBtn"); // 취소 버튼
		var listBtn = $("#listBtn"); // 목록 버튼
		var noticeTitle = $("#noticeTitle");
		var noticeContent = $("#noticeContent");
		var boardForm = $("#boardForm"); // 등록 form
		
		// 등록 버튼 이벤트
		addBtn.on("click", function(){
			var title = noticeTitle.val(); // 제목 데이터
			
			// CKEDITOR를 사용해서 데이터를 가져와야 할 때 사용하는 방법(editor 사용 시)
			var content = CKEDITOR.instances.noticeContent.getData(); // 내용 데이터
			
			// 제목을 입력하지 않았을 때 발생할 이벤트
			if(!title) {
				alert("제목을 입력해주세요!");
				noticeTitle.focus();
				return false;
			}
			
			// 내용을 입력하지 않았을 때 발생할 이벤트
			if(!content) {
				alert("내용을 입력해주세요!");
				noticeContent.focus();
				return false;
			}
			
			// 수정일 때, 경로를 변경한다. (기존은 등록 경로로 설정되어 있음)
			if($(this).val() == "수정"){
				boardForm.attr("action", "/notice/update.do");
			}
			
			boardForm.submit();
		});
		
		// 취소 버튼 이벤트
		cancelBtn.on("click", function(){
			location.href = "/notice/detail.do?noticeNo=${notice.noticeNo}";
		});
		
		// 목록 버튼 이벤트
		listBtn.on("click", function(){
			location.href = "/notice/list.do";
		});
	});
</script>
</html>

[list.jsp]

<%@ page contentType="text/html; charset=utf-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<html>

<head>
    <link href="${pageContext.request.contextPath }/resources/css/bootstrap.min.css" rel="stylesheet">
    <link rel="stylesheet" href="${pageContext.request.contextPath }/resources/css/headers.css">
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.7.1/jquery.min.js"></script>
    <title>공지사항게시판</title>
</head>
<style>
    .bi {
        vertical-align: -.125em;
        fill: currentColor;
    }
</style>

<body>
    <svg xmlns="http://www.w3.org/2000/svg" style="display: none;">
        <symbol id="bootstrap" viewBox="0 0 118 94">
            <title>Bootstrap</title>
            <path fill-rule="evenodd" clip-rule="evenodd" d="M24.509 0c-6.733 0-11.715 5.893-11.492 12.284.214 6.14-.064 14.092-2.066 20.577C8.943 39.365 5.547 43.485 0 44.014v5.972c5.547.529 8.943 4.649 10.951 11.153 2.002 6.485 2.28 14.437 2.066 20.577C12.794 88.106 17.776 94 24.51 94H93.5c6.733 0 11.714-5.893 11.491-12.284-.214-6.14.064-14.092 2.066-20.577 2.009-6.504 5.396-10.624 10.943-11.153v-5.972c-5.547-.529-8.934-4.649-10.943-11.153-2.002-6.484-2.28-14.437-2.066-20.577C105.214 5.894 100.233 0 93.5 0H24.508zM80 57.863C80 66.663 73.436 72 62.543 72H44a2 2 0 01-2-2V24a2 2 0 012-2h18.437c9.083 0 15.044 4.92 15.044 12.474 0 5.302-4.01 10.049-9.119 10.88v.277C75.317 46.394 80 51.21 80 57.863zM60.521 28.34H49.948v14.934h8.905c6.884 0 10.68-2.772 10.68-7.727 0-4.643-3.264-7.207-9.012-7.207zM49.948 49.2v16.458H60.91c7.167 0 10.964-2.876 10.964-8.281 0-5.406-3.903-8.178-11.425-8.178H49.948z"></path>
        </symbol>
        <symbol id="home" viewBox="0 0 16 16">
            <path d="M8.354 1.146a.5.5 0 0 0-.708 0l-6 6A.5.5 0 0 0 1.5 7.5v7a.5.5 0 0 0 .5.5h4.5a.5.5 0 0 0 .5-.5v-4h2v4a.5.5 0 0 0 .5.5H14a.5.5 0 0 0 .5-.5v-7a.5.5 0 0 0-.146-.354L13 5.793V2.5a.5.5 0 0 0-.5-.5h-1a.5.5 0 0 0-.5.5v1.293L8.354 1.146zM2.5 14V7.707l5.5-5.5 5.5 5.5V14H10v-4a.5.5 0 0 0-.5-.5h-3a.5.5 0 0 0-.5.5v4H2.5z" />
        </symbol>
        <symbol id="grid" viewBox="0 0 16 16">
            <path d="M1 2.5A1.5 1.5 0 0 1 2.5 1h3A1.5 1.5 0 0 1 7 2.5v3A1.5 1.5 0 0 1 5.5 7h-3A1.5 1.5 0 0 1 1 5.5v-3zM2.5 2a.5.5 0 0 0-.5.5v3a.5.5 0 0 0 .5.5h3a.5.5 0 0 0 .5-.5v-3a.5.5 0 0 0-.5-.5h-3zm6.5.5A1.5 1.5 0 0 1 10.5 1h3A1.5 1.5 0 0 1 15 2.5v3A1.5 1.5 0 0 1 13.5 7h-3A1.5 1.5 0 0 1 9 5.5v-3zm1.5-.5a.5.5 0 0 0-.5.5v3a.5.5 0 0 0 .5.5h3a.5.5 0 0 0 .5-.5v-3a.5.5 0 0 0-.5-.5h-3zM1 10.5A1.5 1.5 0 0 1 2.5 9h3A1.5 1.5 0 0 1 7 10.5v3A1.5 1.5 0 0 1 5.5 15h-3A1.5 1.5 0 0 1 1 13.5v-3zm1.5-.5a.5.5 0 0 0-.5.5v3a.5.5 0 0 0 .5.5h3a.5.5 0 0 0 .5-.5v-3a.5.5 0 0 0-.5-.5h-3zm6.5.5A1.5 1.5 0 0 1 10.5 9h3a1.5 1.5 0 0 1 1.5 1.5v3a1.5 1.5 0 0 1-1.5 1.5h-3A1.5 1.5 0 0 1 9 13.5v-3zm1.5-.5a.5.5 0 0 0-.5.5v3a.5.5 0 0 0 .5.5h3a.5.5 0 0 0 .5-.5v-3a.5.5 0 0 0-.5-.5h-3z" />
        </symbol>
    </svg>
    <main>
        <header>
            <div class="px-3 py-2 text-bg-dark">
                <div class="container">
                    <div class="d-flex flex-wrap align-items-center justify-content-center justify-content-lg-start">
                        <a href="/" class="d-flex align-items-center my-2 my-lg-0 me-lg-auto text-white text-decoration-none">
                            <svg class="bi me-2" width="40" height="32" role="img" aria-label="Bootstrap">
                                <use xlink:href="#bootstrap" />
                            </svg>
                        </a>
                        <ul class="nav col-12 col-lg-auto my-2 justify-content-center my-md-0 text-small">
                            <li>
                                <a href="/main.do" class="nav-link text-white">
                                    <svg class="bi d-block mx-auto mb-1" width="24" height="24">
                                        <use xlink:href="#home" />
                                    </svg> Home
                                </a>
                            </li>
                            <li>
                                <a href="/board/list.do" class="nav-link text-white">
                                    <svg class="bi d-block mx-auto mb-1" width="24" height="24">
                                        <use xlink:href="#grid" />
                                    </svg> 일반게시판
                                </a>
                            </li>
                            <li>
                                <a href="/notice/list.do" class="nav-link text-white">
                                    <svg class="bi d-block mx-auto mb-1" width="24" height="24">
                                        <use xlink:href="#grid" />
                                    </svg> 공지사항게시판
                                </a>
                            </li>
                            <li>
                                <a href="/free/list.do" class="nav-link text-white">
                                    <svg class="bi d-block mx-auto mb-1" width="24" height="24">
                                        <use xlink:href="#grid" />
                                    </svg> 자유게시판
                                </a>
                            </li>
                        </ul>
                    </div>
                </div>
            </div>
        </header>

        <div class="position-relative overflow-hidden p-3 p-md-8 m-md-8 text-center bg-white">
            <div class="col-md-8 p-lg-8 mx-auto my-5">
                <h4 class="display-4 fw-normal">공지사항게시판</h4>
                <p class="lead fw-normal">공지사항게시판 CRUD를 작성해주세요.</p>
            </div>
            <div class="product-device shadow-sm d-none d-md-block"></div>
            <div class="product-device product-device-2 shadow-sm d-none d-md-block"></div>
        </div>

        <div class="container">
            <div class="row">
                <div class="col-md-12">
                    <div class="">
                        <div class="card-header">
                            <div class="card-tools">
                            </div>
                            <h3 class="card-title">공지사항게시판</h3>
                            <div align="right">
                                <span class="badge bg-dark-subtle border border-dark-subtle text-dark-emphasis rounded-pill">전체 ${pagingVO.totalRecord }건</span>
                            </div>
                        </div>
                        <div class="card-body mt-3">
                            <div align="right">
                                <form class="input-group input-group-sm" method="post" id="searchForm" style="width: 440px;">
                                    
                                    <input type="hidden" name="page" id="page" />
                                    
                                    <select class="form-control" name="searchType">
                                        <option value="title">제목</option>
                                        <option value="writer">작성자</option>
                                    </select>
                                    <input type="text" name="searchWord" class="form-control float-right" value="" placeholder="Search">
                                    <div class="input-group-append">
                                        <button type="submit" class="btn btn-default">
                                            <i class="fas fa-search"></i>검색
                                        </button>
                                    </div>
                                </form>
                            </div>
                            <div class="mt-2">
                                <table class="table">
                                    <thead class="table-dark">
                                        <tr>
                                            <th style="width: 6%">#</th>
                                            <th style="width: px">제목</th>
                                            <th style="width: 12%">작성자</th>
                                            <th style="width: 12%">작성일</th>
                                            <th style="width: 10%">조회수</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                    	<c:set value="${pagingVO.dataList }" var="noticeList" />
                                        <c:choose>
                                        	<c:when test="${empty noticeList }">
                                        		<tr>
													<td colspan="5">조회하신 게시글이 존재하지 않습니다.</td>
												</tr>
                                        	</c:when>
                                        	<c:otherwise>
                                        		<c:forEach items="${noticeList }" var="notice">
                                        			<tr>
														<td>${notice.noticeNo }</td>
														<td>
															<a href="/notice/detail.do?noticeNo=${notice.noticeNo }">${notice.noticeTitle }</a>
														</td>
														<td>${notice.noticeWriter }</td>
														<td>${notice.noticeDate }</td>
														<td>${notice.noticeHit }</td>
													</tr>
                                        		</c:forEach>
                                        	</c:otherwise>
                                        </c:choose>
                                    </tbody>
                                </table>
                            </div>
                            <div align="left">
                                <a href="/notice/form.do" class="btn btn-primary">등록</a>
                            </div>
                        </div>
                        <div class="card-footer clearfix mt-4" id="pagingArea">
                        	${pagingVO.pagingHTML }
                        </div>
                    </div>
                </div>
                <div class="col-md-12"><br /><br /><br /></div>
            </div>
        </div>
    </main>
</body>
<script type="text/javascript">
	$(function(){
		var pagingArea = $("#pagingArea");
		var searchForm = $("#searchForm");
		
		pagingArea.on("click", "a", function(event){
			event.preventDefault();
			var pageNo = $(this).data("page");
			searchForm.find("#page").val(pageNo);
			searchForm.submit();
		});
	});
</script>
</html>

[view.jsp]

<%@ page contentType="text/html; charset=utf-8"%>
<html>

<head>
    <link href="${pageContext.request.contextPath }/resources/css/bootstrap.min.css" rel="stylesheet">
    <link rel="stylesheet" href="${pageContext.request.contextPath }/resources/css/headers.css">
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.7.1/jquery.min.js"></script>
    <title>공지사항게시판 등록/수정</title>
</head>
<style>
    .bi {
        vertical-align: -.125em;
        fill: currentColor;
    }
</style>

<body>
    <svg xmlns="http://www.w3.org/2000/svg" style="display: none;">
        <symbol id="bootstrap" viewBox="0 0 118 94">
            <title>Bootstrap</title>
            <path fill-rule="evenodd" clip-rule="evenodd" d="M24.509 0c-6.733 0-11.715 5.893-11.492 12.284.214 6.14-.064 14.092-2.066 20.577C8.943 39.365 5.547 43.485 0 44.014v5.972c5.547.529 8.943 4.649 10.951 11.153 2.002 6.485 2.28 14.437 2.066 20.577C12.794 88.106 17.776 94 24.51 94H93.5c6.733 0 11.714-5.893 11.491-12.284-.214-6.14.064-14.092 2.066-20.577 2.009-6.504 5.396-10.624 10.943-11.153v-5.972c-5.547-.529-8.934-4.649-10.943-11.153-2.002-6.484-2.28-14.437-2.066-20.577C105.214 5.894 100.233 0 93.5 0H24.508zM80 57.863C80 66.663 73.436 72 62.543 72H44a2 2 0 01-2-2V24a2 2 0 012-2h18.437c9.083 0 15.044 4.92 15.044 12.474 0 5.302-4.01 10.049-9.119 10.88v.277C75.317 46.394 80 51.21 80 57.863zM60.521 28.34H49.948v14.934h8.905c6.884 0 10.68-2.772 10.68-7.727 0-4.643-3.264-7.207-9.012-7.207zM49.948 49.2v16.458H60.91c7.167 0 10.964-2.876 10.964-8.281 0-5.406-3.903-8.178-11.425-8.178H49.948z"></path>
        </symbol>
        <symbol id="home" viewBox="0 0 16 16">
            <path d="M8.354 1.146a.5.5 0 0 0-.708 0l-6 6A.5.5 0 0 0 1.5 7.5v7a.5.5 0 0 0 .5.5h4.5a.5.5 0 0 0 .5-.5v-4h2v4a.5.5 0 0 0 .5.5H14a.5.5 0 0 0 .5-.5v-7a.5.5 0 0 0-.146-.354L13 5.793V2.5a.5.5 0 0 0-.5-.5h-1a.5.5 0 0 0-.5.5v1.293L8.354 1.146zM2.5 14V7.707l5.5-5.5 5.5 5.5V14H10v-4a.5.5 0 0 0-.5-.5h-3a.5.5 0 0 0-.5.5v4H2.5z" />
        </symbol>
        <symbol id="grid" viewBox="0 0 16 16">
            <path d="M1 2.5A1.5 1.5 0 0 1 2.5 1h3A1.5 1.5 0 0 1 7 2.5v3A1.5 1.5 0 0 1 5.5 7h-3A1.5 1.5 0 0 1 1 5.5v-3zM2.5 2a.5.5 0 0 0-.5.5v3a.5.5 0 0 0 .5.5h3a.5.5 0 0 0 .5-.5v-3a.5.5 0 0 0-.5-.5h-3zm6.5.5A1.5 1.5 0 0 1 10.5 1h3A1.5 1.5 0 0 1 15 2.5v3A1.5 1.5 0 0 1 13.5 7h-3A1.5 1.5 0 0 1 9 5.5v-3zm1.5-.5a.5.5 0 0 0-.5.5v3a.5.5 0 0 0 .5.5h3a.5.5 0 0 0 .5-.5v-3a.5.5 0 0 0-.5-.5h-3zM1 10.5A1.5 1.5 0 0 1 2.5 9h3A1.5 1.5 0 0 1 7 10.5v3A1.5 1.5 0 0 1 5.5 15h-3A1.5 1.5 0 0 1 1 13.5v-3zm1.5-.5a.5.5 0 0 0-.5.5v3a.5.5 0 0 0 .5.5h3a.5.5 0 0 0 .5-.5v-3a.5.5 0 0 0-.5-.5h-3zm6.5.5A1.5 1.5 0 0 1 10.5 9h3a1.5 1.5 0 0 1 1.5 1.5v3a1.5 1.5 0 0 1-1.5 1.5h-3A1.5 1.5 0 0 1 9 13.5v-3zm1.5-.5a.5.5 0 0 0-.5.5v3a.5.5 0 0 0 .5.5h3a.5.5 0 0 0 .5-.5v-3a.5.5 0 0 0-.5-.5h-3z" />
        </symbol>
    </svg>
    <main>
        <header>
            <div class="px-3 py-2 text-bg-dark">
                <div class="container">
                    <div class="d-flex flex-wrap align-items-center justify-content-center justify-content-lg-start">
                        <a href="/" class="d-flex align-items-center my-2 my-lg-0 me-lg-auto text-white text-decoration-none">
                            <svg class="bi me-2" width="40" height="32" role="img" aria-label="Bootstrap">
                                <use xlink:href="#bootstrap" />
                            </svg>
                        </a>
                        <ul class="nav col-12 col-lg-auto my-2 justify-content-center my-md-0 text-small">
                            <li>
                                <a href="/main.do" class="nav-link text-white">
                                    <svg class="bi d-block mx-auto mb-1" width="24" height="24">
                                        <use xlink:href="#home" />
                                    </svg> Home
                                </a>
                            </li>
                            <li>
                                <a href="/board/list.do" class="nav-link text-white">
                                    <svg class="bi d-block mx-auto mb-1" width="24" height="24">
                                        <use xlink:href="#grid" />
                                    </svg> 일반게시판
                                </a>
                            </li>
                            <li>
                                <a href="/notice/list.do" class="nav-link text-white">
                                    <svg class="bi d-block mx-auto mb-1" width="24" height="24">
                                        <use xlink:href="#grid" />
                                    </svg> 공지사항게시판
                                </a>
                            </li>
                            <li>
                                <a href="/free/list.do" class="nav-link text-white">
                                    <svg class="bi d-block mx-auto mb-1" width="24" height="24">
                                        <use xlink:href="#grid" />
                                    </svg> 자유게시판
                                </a>
                            </li>
                        </ul>
                    </div>
                </div>
            </div>
        </header>

        <div class="position-relative overflow-hidden p-3 p-md-8 m-md-8 text-center bg-white">
            <div class="col-md-8 p-lg-8 mx-auto my-5">
                <h4 class="display-4 fw-normal">공지사항게시판</h4>
                <p class="lead fw-normal">공지사항게시판 CRUD를 작성해주세요.</p>
            </div>
            <div class="product-device shadow-sm d-none d-md-block"></div>
            <div class="product-device product-device-2 shadow-sm d-none d-md-block"></div>
        </div>

        <div class="container">
            <div class="row">
                <div class="col-md-12">
                    <div class="">
                        <div class="card-header">
                            <h3 class="card-title">${notice.noticeTitle }</h3>
                            <div class="card-tools mt-1">
								${notice.noticeWriter } ${notice.noticeDate } ${notice.noticeHit }
                            </div>
                        </div>
                        <div class="card-body">
                            <div class="form-group row mt-1">
                                <div class="col-sm-12">${notice.noticeContent }</div>
                            </div>
                        </div>
                        <div class="card-footer">
                            <button type="button" class="btn btn-primary" id="listBtn">목록</button>
                            <button type="button" class="btn btn-info" id="modifyBtn">수정</button>
                            <button type="button" class="btn btn-danger" id="delBtn">삭제</button>
                        </div>
                        <form action="/notice/update.do" method="get" id="boardForm" name="boardForm">
							<input type="hidden" name="noticeNo" value="${notice.noticeNo }" />
						</form>
                    </div>
                </div>
                <div class="col-md-12"><br /><br /><br /></div>
            </div>
        </div>
    </main>
</body>
<script type="text/javascript">
	$(function(){
		var boardForm = $("#boardForm");
		var listBtn = $("#listBtn");
		var modifyBtn = $("#modifyBtn");
		var delBtn = $("#delBtn");
		
		// 목록 버튼 이벤트
		listBtn.on("click", function(){
			location.href = "/notice/list.do"
		});
		
		// 수정 버튼 이벤트
		modifyBtn.on("click", function(){
			boardForm.submit();
		});
		
		// 삭제 버튼 이벤트
		delBtn.on("click", function(){
			if(confirm("정말로 삭제하시겠습니까?")){
				boardForm.attr("action", "/notice/delete.do");
				boardForm.attr("method", "post");
				boardForm.submit();
			}
		});
	});
</script>
</html>

insert into notice values (seq_notice.nextval, '제목11', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목12', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목13', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목14', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목15', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목16', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목17', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목18', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목19', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목21', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목22', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목23', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목24', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목25', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목26', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목27', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목28', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목29', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목30', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목31', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목32', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목33', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목34', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목35', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목36', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목37', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목38', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목39', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목40', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목41', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목42', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목43', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목44', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목45', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목46', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목47', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목48', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목49', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목50', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목51', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목52', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목53', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목54', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목55', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목56', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목57', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목58', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목59', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목60', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목61', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목62', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목63', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목64', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목65', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목66', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목67', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목68', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목69', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목70', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목71', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목72', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목73', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목74', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목75', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목76', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목77', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목78', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목79', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목80', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목11', '내용', 'a002', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목12', '내용', 'a002', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목13', '내용', 'a002', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목14', '내용', 'a002', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목15', '내용', 'a002', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목16', '내용', 'a002', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목17', '내용', 'a002', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목18', '내용', 'a002', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목19', '내용', 'a002', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목21', '내용', 'a002', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목22', '내용', 'a002', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목23', '내용', 'a002', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목24', '내용', 'a002', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목25', '내용', 'a002', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목26', '내용', 'a002', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목27', '내용', 'a002', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목28', '내용', 'a002', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목29', '내용', 'a002', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목30', '내용', 'a002', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목31', '내용', 'a002', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목32', '내용', 'a002', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목33', '내용', 'a002', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목34', '내용', 'a002', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목35', '내용', 'a002', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목36', '내용', 'a002', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목37', '내용', 'a002', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목38', '내용', 'a002', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목39', '내용', 'a002', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목40', '내용', 'a002', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목41', '내용', 'a003', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목42', '내용', 'a003', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목43', '내용', 'a003', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목44', '내용', 'a003', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목45', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목46', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목47', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목48', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목49', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목50', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목51', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목52', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목53', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목54', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목55', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목56', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목57', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목58', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목59', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목60', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목61', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목62', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목63', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목64', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목65', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목66', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목67', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목68', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목69', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목70', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목71', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목72', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목73', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목74', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목75', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목76', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목77', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목78', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목79', '내용', 'c001', sysdate, 0);
	insert into notice values (seq_notice.nextval, '제목80', '내용', 'c001', sysdate, 0);

[MainController.java]

package kr.or.ddit.main.web;

import java.util.List;

import javax.inject.Inject;

import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;

import kr.or.ddit.board.service.IBoardService;
import kr.or.ddit.free.service.IFreeService;
import kr.or.ddit.notice.service.INoticeService;
import kr.or.ddit.vo.BoardVO;
import kr.or.ddit.vo.FreeVO;
import kr.or.ddit.vo.NoticeVO;
import kr.or.ddit.vo.PaginationInfoVO;

@Controller
public class MainController {
	
	@Inject
	private IBoardService boardService;
	
	@Inject
	private IFreeService freeService;
	
	@Inject
	private INoticeService noticeService;

	@RequestMapping(value = { "/", "/main.do" }, method = RequestMethod.GET)
	public String main(Model model) {
		
		PaginationInfoVO<BoardVO> boardPagingVO = new PaginationInfoVO<BoardVO>();
		List<BoardVO> boardList5 = boardService.selectBoardList_();
		int boardTotalRecord = boardService.selectBoardCount(boardPagingVO);
		model.addAttribute("boardList5", boardList5);
		model.addAttribute("boardTotalRecord", boardTotalRecord);	
		
		PaginationInfoVO<FreeVO> freePagingVO = new PaginationInfoVO<FreeVO>();
		List<FreeVO> freeList5 = freeService.selectFreeList_();
		int freeTotalRecord = freeService.selectFreeCount(freePagingVO);
		model.addAttribute("freeList5", freeList5);
		model.addAttribute("freeTotalRecord", freeTotalRecord);
		
		PaginationInfoVO<NoticeVO> noticePagingVO = new PaginationInfoVO<NoticeVO>();
		List<NoticeVO> noticeList5 = noticeService.selectNoticeList_();
		int noticeTotalRecord = noticeService.selectNoticeCount(noticePagingVO);
		model.addAttribute("noticeList5", noticeList5);
		model.addAttribute("noticeTotalRecord", noticeTotalRecord);
		
		return "main";
		
	}
	
}

[main.jsp]

<%@ page contentType="text/html; charset=utf-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@ page import="java.util.*"%>
<html>

<head>
    <link href="${pageContext.request.contextPath }/resources/css/bootstrap.min.css" rel="stylesheet">
    <link rel="stylesheet" href="${pageContext.request.contextPath }/resources/css/headers.css">
    <title>메인화면</title>
</head>
<style>
    .bi {
        vertical-align: -.125em;
        fill: currentColor;
    }
</style>

<body>
    <svg xmlns="http://www.w3.org/2000/svg" style="display: none;">
        <symbol id="bootstrap" viewBox="0 0 118 94">
            <title>Bootstrap</title>
            <path fill-rule="evenodd" clip-rule="evenodd" d="M24.509 0c-6.733 0-11.715 5.893-11.492 12.284.214 6.14-.064 14.092-2.066 20.577C8.943 39.365 5.547 43.485 0 44.014v5.972c5.547.529 8.943 4.649 10.951 11.153 2.002 6.485 2.28 14.437 2.066 20.577C12.794 88.106 17.776 94 24.51 94H93.5c6.733 0 11.714-5.893 11.491-12.284-.214-6.14.064-14.092 2.066-20.577 2.009-6.504 5.396-10.624 10.943-11.153v-5.972c-5.547-.529-8.934-4.649-10.943-11.153-2.002-6.484-2.28-14.437-2.066-20.577C105.214 5.894 100.233 0 93.5 0H24.508zM80 57.863C80 66.663 73.436 72 62.543 72H44a2 2 0 01-2-2V24a2 2 0 012-2h18.437c9.083 0 15.044 4.92 15.044 12.474 0 5.302-4.01 10.049-9.119 10.88v.277C75.317 46.394 80 51.21 80 57.863zM60.521 28.34H49.948v14.934h8.905c6.884 0 10.68-2.772 10.68-7.727 0-4.643-3.264-7.207-9.012-7.207zM49.948 49.2v16.458H60.91c7.167 0 10.964-2.876 10.964-8.281 0-5.406-3.903-8.178-11.425-8.178H49.948z"></path>
        </symbol>
        <symbol id="home" viewBox="0 0 16 16">
            <path d="M8.354 1.146a.5.5 0 0 0-.708 0l-6 6A.5.5 0 0 0 1.5 7.5v7a.5.5 0 0 0 .5.5h4.5a.5.5 0 0 0 .5-.5v-4h2v4a.5.5 0 0 0 .5.5H14a.5.5 0 0 0 .5-.5v-7a.5.5 0 0 0-.146-.354L13 5.793V2.5a.5.5 0 0 0-.5-.5h-1a.5.5 0 0 0-.5.5v1.293L8.354 1.146zM2.5 14V7.707l5.5-5.5 5.5 5.5V14H10v-4a.5.5 0 0 0-.5-.5h-3a.5.5 0 0 0-.5.5v4H2.5z" />
        </symbol>
        <symbol id="grid" viewBox="0 0 16 16">
            <path d="M1 2.5A1.5 1.5 0 0 1 2.5 1h3A1.5 1.5 0 0 1 7 2.5v3A1.5 1.5 0 0 1 5.5 7h-3A1.5 1.5 0 0 1 1 5.5v-3zM2.5 2a.5.5 0 0 0-.5.5v3a.5.5 0 0 0 .5.5h3a.5.5 0 0 0 .5-.5v-3a.5.5 0 0 0-.5-.5h-3zm6.5.5A1.5 1.5 0 0 1 10.5 1h3A1.5 1.5 0 0 1 15 2.5v3A1.5 1.5 0 0 1 13.5 7h-3A1.5 1.5 0 0 1 9 5.5v-3zm1.5-.5a.5.5 0 0 0-.5.5v3a.5.5 0 0 0 .5.5h3a.5.5 0 0 0 .5-.5v-3a.5.5 0 0 0-.5-.5h-3zM1 10.5A1.5 1.5 0 0 1 2.5 9h3A1.5 1.5 0 0 1 7 10.5v3A1.5 1.5 0 0 1 5.5 15h-3A1.5 1.5 0 0 1 1 13.5v-3zm1.5-.5a.5.5 0 0 0-.5.5v3a.5.5 0 0 0 .5.5h3a.5.5 0 0 0 .5-.5v-3a.5.5 0 0 0-.5-.5h-3zm6.5.5A1.5 1.5 0 0 1 10.5 9h3a1.5 1.5 0 0 1 1.5 1.5v3a1.5 1.5 0 0 1-1.5 1.5h-3A1.5 1.5 0 0 1 9 13.5v-3zm1.5-.5a.5.5 0 0 0-.5.5v3a.5.5 0 0 0 .5.5h3a.5.5 0 0 0 .5-.5v-3a.5.5 0 0 0-.5-.5h-3z" />
        </symbol>
    </svg>
    <main>
        <header>
            <div class="px-3 py-2 text-bg-dark">
                <div class="container">
                    <div class="d-flex flex-wrap align-items-center justify-content-center justify-content-lg-start">
                        <a href="/" class="d-flex align-items-center my-2 my-lg-0 me-lg-auto text-white text-decoration-none">
                            <svg class="bi me-2" width="40" height="32" role="img" aria-label="Bootstrap">
                                <use xlink:href="#bootstrap" />
                            </svg>
                        </a>
                        <ul class="nav col-12 col-lg-auto my-2 justify-content-center my-md-0 text-small">
                            <li>
                                <a href="/main.do" class="nav-link text-white">
                                    <svg class="bi d-block mx-auto mb-1" width="24" height="24">
                                        <use xlink:href="#home" />
                                    </svg> Home
                                </a>
                            </li>
                            <li>
                                <a href="/board/list.do" class="nav-link text-white">
                                    <svg class="bi d-block mx-auto mb-1" width="24" height="24">
                                        <use xlink:href="#grid" />
                                    </svg> 일반게시판
                                </a>
                            </li>
                            <li>
                                <a href="/notice/list.do" class="nav-link text-white">
                                    <svg class="bi d-block mx-auto mb-1" width="24" height="24">
                                        <use xlink:href="#grid" />
                                    </svg> 공지사항게시판
                                </a>
                            </li>
                            <li>
                                <a href="/free/list.do" class="nav-link text-white">
                                    <svg class="bi d-block mx-auto mb-1" width="24" height="24">
                                        <use xlink:href="#grid" />
                                    </svg> 자유게시판
                                </a>
                            </li>
                        </ul>
                    </div>
                </div>
            </div>
        </header>

        <div class="position-relative overflow-hidden p-3 p-md-8 m-md-8 text-center bg-white">
            <div class="col-md-8 p-lg-8 mx-auto my-5">
                <h1 class="display-4 fw-normal">게시판 작성 연습</h1>
                <p class="lead fw-normal">Spring framework를 이용한 게시판 CRUD Example</p>
            </div>
            <div class="product-device shadow-sm d-none d-md-block"></div>
            <div class="product-device product-device-2 shadow-sm d-none d-md-block"></div>
        </div>

        <div class="container">
            <div class="row">
                <div class="col-md-6">
                    <div align="left">
                        <h5>일반 게시판</h5>
                    </div>
                    <div align="right">
                        <span class="badge bg-dark-subtle border border-dark-subtle text-dark-emphasis rounded-pill">전체 ${boardTotalRecord }건</span>
                    </div>
                    <form action="" method="post">
                        <div style="padding-top: 50px">
                            <table class="table">
                                <tr class="table-dark">
                                    <th>번호</th>
                                    <th>제목</th>
                                    <th>작성일</th>
                                </tr>
                                <c:choose>
                                	<c:when test="${empty boardList5 }">
		                                <tr>
		                                    <td colspan="3">조회하신 게시글이 존재하지 않습니다.</td>
		                                </tr>
                                	</c:when>
                                	<c:otherwise>
                                		<c:forEach items="${boardList5 }" var="board">
			                                <tr>
			                                    <td>${board.boNo }</td>
			                                    <td>
			                                    	<a href="/board/detail.do?boNo=${board.boNo }">${board.boTitle }</a>
			                                    </td>
			                                    <td>${board.boDate }</td>
			                                </tr>
                                		</c:forEach>
                                	</c:otherwise>
                                </c:choose>
                            </table>
                        </div>
                    </form>
                    <a href="/board/list.do" class="btn btn-outline-primary">&laquo;더보기</a>
                </div>
                <div class="col-md-6">
                    <div align="left">
                        <h5>공지사항</h5>
                    </div>
                    <div align="right">
                        <span class="badge bg-dark-subtle border border-dark-subtle text-dark-emphasis rounded-pill">전체 ${noticeTotalRecord }건</span>
                    </div>
                    <form action="" method="post">
                        <div style="padding-top: 50px">
                            <table class="table">
                                <tr class="table-dark">
                                    <th>번호</th>
                                    <th>제목</th>
                                    <th>작성일</th>
                                </tr>
                                <c:choose>
                                	<c:when test="${empty noticeList5 }">
		                                <tr>
		                                    <td colspan="3">조회하신 게시글이 존재하지 않습니다.</td>
		                                </tr>
                                	</c:when>
                                	<c:otherwise>
                                		<c:forEach items="${noticeList5 }" var="notice">
			                                <tr>
			                                    <td>${notice.noticeNo }</td>
			                                    <td>
			                                    	<a href="/notice/detail.do?noticeNo=${notice.noticeNo }">${notice.noticeTitle }</a>
			                                    </td>
			                                    <td>${notice.noticeDate }</td>
			                                </tr>
                                		</c:forEach>
                                	</c:otherwise>
                                </c:choose>
                            </table>
                        </div>
                    </form>
                    <a href="/notice/list.do" class="btn btn-outline-primary">&laquo;더보기</a>
                </div>
            </div>
            <br />
            <div class="row">
                <div class="col-md-6">
                    <div align="left">
                        <h5>자유 게시판</h5>
                    </div>
                    <div align="right">
                        <span class="badge bg-dark-subtle border border-dark-subtle text-dark-emphasis rounded-pill">전체 ${freeTotalRecord }건</span>
                    </div>
                    <form action="" method="post">
                        <div style="padding-top: 50px">
                            <table class="table">
                                <tr class="table-dark">
                                    <th>번호</th>
                                    <th>제목</th>
                                    <th>작성일</th>
                                </tr>
                                <c:choose>
                                	<c:when test="${empty freeList5 }">
		                                <tr>
		                                    <td colspan="3">조회하신 게시글이 존재하지 않습니다.</td>
		                                </tr>
                                	</c:when>
                                	<c:otherwise>
                                		<c:forEach items="${freeList5 }" var="free">
			                                <tr>
			                                    <td>${free.freeNo }</td>
			                                    <td>
			                                    	<a href="/free/detail.do?freeNo=${free.freeNo }">${free.freeTitle }</a>
			                                    </td>
			                                    <td>${free.freeDate }</td>
			                                </tr>
                                		</c:forEach>
                                	</c:otherwise>
                                </c:choose>
                            </table>
                        </div>
                    </form>
                    <a href="/free/list.do" class="btn btn-outline-primary">&laquo;더보기</a>
                </div>
                <div class="col-md-6"></div>
            </div>
            <br />
        </div>
    </main>
</body>

</html>

- http://localhost/main.do