은성이의 프로그램X파일

 package board.dto;

import board.util.Utilities;
//totalContent -> 게시물수 - 201
//currentPage -> 보려는 page - 5
//contentPerPage -> page에 보여줄 컨텐츠 수 - 10
//pagePerPageGroup -> page내 page 수 - 5
/**
 * 페이징 처리위한 bean <br>
 * page : 게시물 묶음
 * page group : page 묶음
 * @author kgmyh
 *
 */
public class PagingDTO {
 /**
  * 총 데이터(게시물)의 개수
  */
 private int totalContent;
 /**
  * 현재 페이지
  */
 private int currentPage;
 /**
  * 한 페이지에 보여질 데이터(게시물)개수
  */
 private int contentsPerPage = Utilities.CONTENT_PER_PAGE; //5
 /**
  * Page Group 내 Page 수.  페이지 그룹에 들어갈 페이지 개수
  */
 private int pagePerPagegroup = Utilities.PAGE_PER_PAGEGROUP; //10
 
 /**
  * 총 데이터(게시물) 개수, 현재 페이지를 받아 member variable에 할당
  * @param totalContent
  * @param currentPage
  */
 public PagingDTO(int totalContent, int nowPage){
  this.totalContent = totalContent;
  this.currentPage = nowPage;
 }
 /**
  * 현재 페이지 return
  * @return
  */
 public int getCurrentPage() {
  return currentPage;
 }
 /**
  * 현재 페이지 setting
  * @param nowPage
  */
 public void setCurrentPage(int nowPage) {
  this.currentPage = nowPage;
 }

/***************************************************************************
* 아래 메소드들을 구현하시오.
****************************************************************************/

 /**
  * 총 페이지 수를 return한다.<br>
  * 1. 전체 데이터(게시물) % 한 페이지에 보여줄 데이터 개수 => 0 이면 둘을 /  값이 총 페이지 수<br>
  * 2. 전체 데이터(게시물) % 한 페이지에 보여줄 데이터 개수 => 0보다 크면 둘을 /  값에 +1을 한 값이 총 페이지 수
  * @return
  */
 private int getTotalPage(){
  int totalPage = 0;
  
  if((this.totalContent%this.contentsPerPage)==0){
   totalPage = this.totalContent / this.contentsPerPage;
  }else if((this.totalContent%this.contentsPerPage)>0){
   totalPage = this.totalContent / this.contentsPerPage +1;
  }
  return totalPage;
 }
 /**
  * 총 페이지 그룹의 수를 return한다.<br>
  * 1. 총 페이지수 %  Page Group 내 Page 수.  => 0 이면 둘을 /  값이 총 페이지 수<br>
  * 2. 총 페이지수 %  Page Group 내 Page 수.  => 0보다 크면 둘을 /  값에 +1을 한 값이 총 페이지 수
  * @return
  */
 private int getTotalPageGroup(){
  
  int totalPageGoup = 0;
  if((this.getTotalPage()%this.pagePerPagegroup)==0){
   totalPageGoup = this.getTotalPage() / this.pagePerPagegroup;
  }else if((this.getTotalPage()%this.pagePerPagegroup)>0){
   totalPageGoup = this.getTotalPage() / this.pagePerPagegroup +1;
  }
  return totalPageGoup;
 }
 /**
  * 현재 페이지가 속한 페이지 그룹 번호(몇 번째 페이지 그룹인지) 을 return 하는 메소드
  * 1. 현재 페이지 %  Page Group 내 Page 수 => 0 이면 둘을 / 값이 현재 페이지 그룹.
  * 2. 현재 페이지 %  Page Group 내 Page 수 => 0 크면 둘을 /  값에 +1을 한 값이 현재 페이지 그룹
  * @return
  */
 private int getCurrentPageGroup(){
  
  int currentPageGroup = 0;
  if((this.currentPage%this.pagePerPagegroup)==0){
   currentPageGroup = this.currentPage / this.pagePerPagegroup;
  }else if((this.currentPage%this.pagePerPagegroup)>0){
   currentPageGroup = this.currentPage / this.pagePerPagegroup +1;
  }
  return currentPageGroup;
 }
 /**
  * 현재 페이지가 속한 페이지 그룹의 시작 페이지 번호를 return 한다.<br>
  * 1. Page Group 내 Page 수*(현재 페이지 그룹 -1) + 1을 한 값이 첫 페이지이다.(페이지 그룹*페이지 그룹 개수 이 그 그룹의 마지막 번호이므로)
  * 2. 위의 계산 결과가 0인 경우는 첫페이지 이므로 1을 return 한다.
  * @return
  */
 public int getStartPageOfPageGroup(){
  int startPageNo = 0;
  int currentPageGroup = this.getCurrentPageGroup();
  startPageNo = pagePerPagegroup*(currentPageGroup-1)+1;
  if(startPageNo==0){
   startPageNo = 1;
  }
   
  
  return startPageNo;
 }
 /**
  * 현재 페이지가 속한 페이지 그룹의 마지막 페이지 번호를 return 한다.<br>
  * 1. 현재 페이지 그룹 * 페이지 그룹내 페이지 수 가 마지막 번호이다.
  * 2. 그 그룹의 마지막 페이지 번호가 전체 페이지의 마지막 페이지 번호보다 큰 경우는 전체 페이지의 마지막 번호를 return 한다.
  * @return
  */
 public int getEndPageOfPageGroup(){
  int endPageNo = this.getCurrentPageGroup() * pagePerPagegroup;
  if(endPageNo>getTotalPage()){ //마지막 page가 총 page수 보다 크다면
   endPageNo = getTotalPage();
  }
  return endPageNo;
 }
 /**
  * 이전 페이지 그룹이 있는지 체크
  * 현재 페이지가 속한 페이지 그룹이 1보다 크면 true
  * @return
  */
 public boolean isPreviousPageGroup(){  
  boolean flag = false;
  if(this.getCurrentPageGroup()!=1){//현재 pagegroup이 1이 아니면
   flag = true;
  }
  return flag;
 }
 /**
  * 다음 페이지 그룹이 있는지 체크
  * 현재 페이지 그룹이 마지막 페이지 그룹(마지막 페이지 그룹 == 총 페이지 그룹 수) 보다 작으면 true
  * @return
  */
 public boolean isNextPageGroup(){  
  boolean flag = false;
  if(this.getCurrentPageGroup()<this.getTotalPageGroup()){
   flag = true;
  }
  return flag;
 }
 /*
 테스트 용 메인 메소드
 */
 public static void main(String[] args) {
  PagingDTO d = new PagingDTO(201, 5);//총 201개 게시물, 현재page : 5
  //page내 게시물수 - 5
  //page그룹내 page수 - 10
  System.out.println("총 page 수 : "+d.getTotalPage()); //41
  System.out.println("총 page그룹 : "+d.getTotalPageGroup());//5
  System.out.println("현 페이지 그룹 : "+d.getCurrentPageGroup());//1
  System.out.println("첫 page : "+d.getStartPageOfPageGroup());//1
  System.out.println("마지막 page : "+d.getEndPageOfPageGroup());//10
  System.out.println("이전 page그룹 존재 ? : "+d.isPreviousPageGroup());//false
  System.out.println("다음 page그룹 존재 ? : "+d.isNextPageGroup());//true
  
 }
}

 package board.dto;

import java.util.ArrayList;

public class ListDTO {
 private ArrayList<BoardDTO> list;
 private PagingDTO pagingDTO;
 
 public ListDTO() {
  super();
  // TODO Auto-generated constructor stub
 }
 public ListDTO(ArrayList<BoardDTO> list, PagingDTO pagingDTO) {
  super();
  this.list = list;
  this.pagingDTO = pagingDTO;
 }
 public ArrayList<BoardDTO> getList() {
  return list;
 }
 public void setList(ArrayList<BoardDTO> list) {
  this.list = list;
 }
 public PagingDTO getPagingDTO() {
  return pagingDTO;
 }
 public void setPagingDTO(PagingDTO pagingDTO) {
  this.pagingDTO = pagingDTO;
 }
 @Override
 public String toString() {
  return "ListDTO [list=" + list + ", pagingDTO=" + pagingDTO + "]";
 }
 
}

<%@page import="board.dto.BoardDTO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
 pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!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>
<style type="text/css">
div{
 width:600px;
 border:1px solid gray;
 padding : 5px;
}
#title{
 font-weight: bold;
 background-color: yellow;
}
#info{
 font-size:13px;
}
#content{
 min-height:300px;
 height:auto;
}
</style>
</head>
<body>
 <h1>글목록</h1>
 <p>
<div id="title">${requestScope.board.no}.${requestScope.board.title }</div>
<div id="info">작성자 : ${requestScope.board.writer } | 조회수 : ${requestScope.board.viewcount } 작성일시 : ${requestScope.board.writedate }</div>
<div id="content">${requestScope.board.content }</div>
 <p>
  <a href="/${initParam.context_root }/write_form.jsp">글쓰기</a>
  <a href="/${initParam.context_root }/boardController?command=list_all">전체 글목록</a>
  <a href="/${initParam.context_root }/boardController?command=list&page=${param.page }">글목록(페이징)</a>
  <a href="/${initParam.context_root }/boardController?command=modify_form&no=${requestScope.board.no}">글수정</a>
  <a href="/${initParam.context_root }/boardController?command=delete_content&no=${requestScope.board.no}">글삭제</a>
  <a href="/${initParam.context_root }/boardController?command=reply_form&no=${requestScope.board.no}">답변</a>
</body>
</html>

package board.controller;

import java.io.IOException;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import board.dto.ForwardDTO;

public class BoardFrontController extends HttpServlet {
 private static final long serialVersionUID = 1L;

    public BoardFrontController() {
        super();
    
    }

 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  doPost(request, response);
 }

 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  //1. 공통 사전 작업 - 한글처리
  request.setCharacterEncoding("utf-8");
  //2. Controller 로직 처리 - Controller객체.execute()호출
  String command = request.getParameter("command");
  Controller ctr = ControllerCommandMapping.getController(command);
  ForwardDTO fdto = ctr.execute(request, response);
  //3. 공통 사후 작업
  if(fdto.isRedirect()){
   response.sendRedirect(fdto.getUrl());
  }else{
   RequestDispatcher rdp = request.getRequestDispatcher(fdto.getUrl());
   rdp.forward(request, response);
  }
 }

}

package board.controller;

public class ControllerCommandMapping {

 public static Controller getController(String command){
  Controller ctr = null;
  if(command.equals("write_content")){
   ctr = new WriteContentController();
  }else if(command.equals("list_all")){
   ctr = new BoardAllListController();
  }else if(command.equals("get_content")){
   ctr = new GetContentController();
  }else if(command.equals("modify_form")){
   ctr = new ModifyFormController();
  }else if(command.equals("modify_content")){
   ctr = new ModifyContentController();
  }else if(command.equals("delete_content")){
   ctr = new DeleteContentController();
  }else if(command.equals("reply_form")){
   ctr = new ReplyFormController();
  }else if(command.equals("reply_content")){
   ctr = new ReplyContentController();
  }else if(command.equals("list")){
   ctr = new BoardListController();
  }
  return ctr;
 }

}

package board.controller;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import board.dto.BoardDTO;
import board.dto.ForwardDTO;
import board.dto.ListDTO;
import board.model.service.BoardService;

public class BoardListController implements Controller {

 @Override
 public ForwardDTO execute(HttpServletRequest request,
   HttpServletResponse response) throws ServletException, IOException {
  //글번로를 받아 글의 벙보를 조회하는 컨트롤러
  
  ForwardDTO forwardDTO = null;
  int page = 1;
  try{
   page = Integer.parseInt(request.getParameter("page"));
  }catch(Exception e){}
  
  //2. 비지니스 로직 호출->model
  BoardService boardService = BoardService.getInstance();
  try{
  
   ListDTO ldto = boardService.getBoardListByPage(page);
   //응답
   request.setAttribute("ldto", ldto);
   
   forwardDTO = new ForwardDTO("/list.jsp",false);
  } catch(Exception e){
   e.printStackTrace();
   request.setAttribute("error_message", e.getMessage());
   forwardDTO = new ForwardDTO("/error.jsp",false);
  }
  return forwardDTO;
 }

}

package board.model.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import org.apache.tomcat.dbcp.dbcp.BasicDataSource;

import board.dto.BoardDTO;
import board.util.DBUtil;
import board.util.Utilities;

public class BoardDAO {
 private static BoardDAO instance = new BoardDAO();
 private DBUtil dbUtil;

 private BoardDAO() {
  dbUtil = DBUtil.getInstance();
 }

 public static BoardDAO getInstance() {
  return instance;
 }

 public int selectBoardNo() throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select board_no_seq.nextval from dual";
  int no = 0;
  try {
   BasicDataSource ds = dbUtil.getDataSource();
   conn = ds.getConnection();
   pstmt = conn.prepareStatement(sql);
   rset = pstmt.executeQuery();
   if (rset.next()) {
    no = rset.getInt(1);
   }
  } finally {
   dbUtil.close(conn, pstmt, rset);
  }
  return no;
 }

 public void insertContent(BoardDTO bto) throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;

  String sql = "insert into board (no, title, writer, content, writedate, viewcount, refamily, restep, relevel)  values(?,?,?,?,?,0,?,?,?)";
  try {
   BasicDataSource ds = dbUtil.getDataSource();
   conn = ds.getConnection();
   pstmt = conn.prepareStatement(sql);
   pstmt.setInt(1, bto.getNo());
   pstmt.setString(2, bto.getTitle());
   pstmt.setString(3, bto.getWriter());
   pstmt.setString(4, bto.getContent());
   pstmt.setString(5, bto.getWritedate());
   //viewcount값은 처음 등록하면 무조건 0이라서 쿼리에서 부터 그냥 값을 넣어줬다
//   pstmt.setInt(6, bto.getViewcount());
   pstmt.setInt(6, bto.getRefamily());
   pstmt.setInt(7, bto.getRestep());
   pstmt.setInt(8, bto.getRelevel());
   int cnt = pstmt.executeUpdate();
   System.out.println(cnt + "개의 행이 삽입되었습니다.");

  } finally {
   dbUtil.close(conn, pstmt);
  }
 }

 public ArrayList<BoardDTO> selectBoardAllList() throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select no, title, writer, content, writedate, viewcount, refamily, restep, relevel from board order by refamily desc, restep asc";
  ArrayList<BoardDTO> list_all = new ArrayList<BoardDTO>();
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  rset = pstmt.executeQuery();
   while(rset.next()){
    list_all.add(new BoardDTO(rset.getInt(1), rset.getString(2), rset.getString(3), rset.getString(4), rset.getString(5), rset.getInt(6), rset.getInt(7), rset.getInt(8), rset.getInt(9)));
   }
  }finally{
   dbUtil.close(conn, pstmt, rset);
  }
  return list_all;
 }

 public BoardDTO selectContentByNO(int no) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select no, title, writer, content, writedate, viewcount, refamily, restep, relevel from board where no=?";
  BoardDTO bto = null;
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, no);
  rset = pstmt.executeQuery();
  if(rset.next()){
   bto = new BoardDTO(rset.getInt(1), rset.getString(2), rset.getString(3), rset.getString(4), rset.getString(5), rset.getInt(6), rset.getInt(7), rset.getInt(8), rset.getInt(9));
  }
  }finally{
   dbUtil.close(conn, pstmt, rset);
  }
  return bto;
 }

 public void updateViewCount(int no) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  String sql = "update board set viewcount=viewcount+1 where no=?";
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, no);
  int cnt = pstmt.executeUpdate();
  System.out.println(cnt+"개의 행이 수정되었습니다.");
  }finally{
   dbUtil.close(conn, pstmt);
  }
 }

 public void updateContent(BoardDTO dto) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  String sql = "update board set title=?, writer=?, content=?, writedate=? where no=?";
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setString(1, dto.getTitle());
  pstmt.setString(2, dto.getWriter());
  pstmt.setString(3, dto.getContent());
  pstmt.setString(4, dto.getWritedate());
  pstmt.setInt(5, dto.getNo());
  int cnt = pstmt.executeUpdate();
  System.out.println(cnt+"개의 행이 수정되었습니다.");
  }finally{
   dbUtil.close(conn, pstmt);
  }
  
 }

 public void deleteContentByNO(int no) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  String sql = "delete from board where no=?";
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, no);
  int cnt = pstmt.executeUpdate();
  System.out.println(cnt+"개의 행이 삭제되었습니다.");
  }finally{
   dbUtil.close(conn, pstmt);
  }
  
 }

 public void updateRestep(int refamily, int restep) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  String sql = "update board set restep=restep+1 where refamily=? and restep>?";
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, refamily);
  pstmt.setInt(2, restep);
  
  int cnt = pstmt.executeUpdate();
  System.out.println(cnt+"개의 행이 수정되었습니다.");
  }finally{
   dbUtil.close(conn, pstmt);
  }
  
 }

 public ArrayList<BoardDTO> selectBoardListByPage(int page) throws SQLException{
  
  System.out.println("Utilities.CONTENT_PER_PAGE : "+Utilities.CONTENT_PER_PAGE);
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select no, title, writer, content, writedate, viewcount, refamily, restep, relevel from(select ceil(rownum/?) page, no, title, writer, content, writedate, viewcount, refamily, restep, relevel from (select no, title, writer, content, writedate, viewcount, refamily, restep, relevel from board order by refamily desc, restep asc)) where page=?";
  //String sql = "select no, title, writer, content, writedate, viewcount, refamily, restep, relevel from board where no=?";
  ArrayList<BoardDTO> list = new ArrayList<BoardDTO>();
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, Utilities.CONTENT_PER_PAGE);
  pstmt.setInt(2, page);
  rset = pstmt.executeQuery();
  while(rset.next()){
   list.add(new BoardDTO(rset.getInt(1), rset.getString(2), rset.getString(3), rset.getString(4), rset.getString(5), rset.getInt(6), rset.getInt(7), rset.getInt(8), rset.getInt(9)));
  
  }
  }finally{
   dbUtil.close(conn, pstmt, rset);
  }
  return list;
 }

 public int selectTotalContent() throws SQLException{
  
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql ="SELECT COUNT(no) FROM board";
 
  int totalContent = 0;
  try {
   BasicDataSource ds = dbUtil.getDataSource();
   conn = ds.getConnection();
   pstmt = conn.prepareStatement(sql);
   rset = pstmt.executeQuery();
   if (rset.next()) {
    totalContent = rset.getInt(1);
   }
  } finally {
   dbUtil.close(conn, pstmt, rset);
  }
  return totalContent;
 
 }
}

package board.model.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import org.apache.tomcat.dbcp.dbcp.BasicDataSource;

import board.dto.BoardDTO;
import board.util.DBUtil;
import board.util.Utilities;

public class BoardDAO {
 private static BoardDAO instance = new BoardDAO();
 private DBUtil dbUtil;

 private BoardDAO() {
  dbUtil = DBUtil.getInstance();
 }

 public static BoardDAO getInstance() {
  return instance;
 }

 public int selectBoardNo() throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select board_no_seq.nextval from dual";
  int no = 0;
  try {
   BasicDataSource ds = dbUtil.getDataSource();
   conn = ds.getConnection();
   pstmt = conn.prepareStatement(sql);
   rset = pstmt.executeQuery();
   if (rset.next()) {
    no = rset.getInt(1);
   }
  } finally {
   dbUtil.close(conn, pstmt, rset);
  }
  return no;
 }

 public void insertContent(BoardDTO bto) throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;

  String sql = "insert into board (no, title, writer, content, writedate, viewcount, refamily, restep, relevel)  values(?,?,?,?,?,0,?,?,?)";
  try {
   BasicDataSource ds = dbUtil.getDataSource();
   conn = ds.getConnection();
   pstmt = conn.prepareStatement(sql);
   pstmt.setInt(1, bto.getNo());
   pstmt.setString(2, bto.getTitle());
   pstmt.setString(3, bto.getWriter());
   pstmt.setString(4, bto.getContent());
   pstmt.setString(5, bto.getWritedate());
   //viewcount값은 처음 등록하면 무조건 0이라서 쿼리에서 부터 그냥 값을 넣어줬다
//   pstmt.setInt(6, bto.getViewcount());
   pstmt.setInt(6, bto.getRefamily());
   pstmt.setInt(7, bto.getRestep());
   pstmt.setInt(8, bto.getRelevel());
   int cnt = pstmt.executeUpdate();
   System.out.println(cnt + "개의 행이 삽입되었습니다.");

  } finally {
   dbUtil.close(conn, pstmt);
  }
 }

 public ArrayList<BoardDTO> selectBoardAllList() throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select no, title, writer, content, writedate, viewcount, refamily, restep, relevel from board order by refamily desc, restep asc";
  ArrayList<BoardDTO> list_all = new ArrayList<BoardDTO>();
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  rset = pstmt.executeQuery();
   while(rset.next()){
    list_all.add(new BoardDTO(rset.getInt(1), rset.getString(2), rset.getString(3), rset.getString(4), rset.getString(5), rset.getInt(6), rset.getInt(7), rset.getInt(8), rset.getInt(9)));
   }
  }finally{
   dbUtil.close(conn, pstmt, rset);
  }
  return list_all;
 }

 public BoardDTO selectContentByNO(int no) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select no, title, writer, content, writedate, viewcount, refamily, restep, relevel from board where no=?";
  BoardDTO bto = null;
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, no);
  rset = pstmt.executeQuery();
  if(rset.next()){
   bto = new BoardDTO(rset.getInt(1), rset.getString(2), rset.getString(3), rset.getString(4), rset.getString(5), rset.getInt(6), rset.getInt(7), rset.getInt(8), rset.getInt(9));
  }
  }finally{
   dbUtil.close(conn, pstmt, rset);
  }
  return bto;
 }

 public void updateViewCount(int no) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  String sql = "update board set viewcount=viewcount+1 where no=?";
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, no);
  int cnt = pstmt.executeUpdate();
  System.out.println(cnt+"개의 행이 수정되었습니다.");
  }finally{
   dbUtil.close(conn, pstmt);
  }
 }

 public void updateContent(BoardDTO dto) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  String sql = "update board set title=?, writer=?, content=?, writedate=? where no=?";
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setString(1, dto.getTitle());
  pstmt.setString(2, dto.getWriter());
  pstmt.setString(3, dto.getContent());
  pstmt.setString(4, dto.getWritedate());
  pstmt.setInt(5, dto.getNo());
  int cnt = pstmt.executeUpdate();
  System.out.println(cnt+"개의 행이 수정되었습니다.");
  }finally{
   dbUtil.close(conn, pstmt);
  }
  
 }

 public void deleteContentByNO(int no) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  String sql = "delete from board where no=?";
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, no);
  int cnt = pstmt.executeUpdate();
  System.out.println(cnt+"개의 행이 삭제되었습니다.");
  }finally{
   dbUtil.close(conn, pstmt);
  }
  
 }

 public void updateRestep(int refamily, int restep) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  String sql = "update board set restep=restep+1 where refamily=? and restep>?";
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, refamily);
  pstmt.setInt(2, restep);
  
  int cnt = pstmt.executeUpdate();
  System.out.println(cnt+"개의 행이 수정되었습니다.");
  }finally{
   dbUtil.close(conn, pstmt);
  }
  
 }

 public ArrayList<BoardDTO> selectBoardListByPage(int page) throws SQLException{
  
  System.out.println("Utilities.CONTENT_PER_PAGE : "+Utilities.CONTENT_PER_PAGE);
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select no, title, writer, content, writedate, viewcount, refamily, restep, relevel from(select ceil(rownum/?) page, no, title, writer, content, writedate, viewcount, refamily, restep, relevel from (select no, title, writer, content, writedate, viewcount, refamily, restep, relevel from board order by refamily desc, restep asc)) where page=?";
  //String sql = "select no, title, writer, content, writedate, viewcount, refamily, restep, relevel from board where no=?";
  ArrayList<BoardDTO> list = new ArrayList<BoardDTO>();
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, Utilities.CONTENT_PER_PAGE);
  pstmt.setInt(2, page);
  rset = pstmt.executeQuery();
  while(rset.next()){
   list.add(new BoardDTO(rset.getInt(1), rset.getString(2), rset.getString(3), rset.getString(4), rset.getString(5), rset.getInt(6), rset.getInt(7), rset.getInt(8), rset.getInt(9)));
  
  }
  }finally{
   dbUtil.close(conn, pstmt, rset);
  }
  return list;
 }

 public int selectTotalContent() throws SQLException{
  
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql ="SELECT COUNT(no) FROM board";
 
  int totalContent = 0;
  try {
   BasicDataSource ds = dbUtil.getDataSource();
   conn = ds.getConnection();
   pstmt = conn.prepareStatement(sql);
   rset = pstmt.executeQuery();
   if (rset.next()) {
    totalContent = rset.getInt(1);
   }
  } finally {
   dbUtil.close(conn, pstmt, rset);
  }
  return totalContent;
 
 }
}

<%@ page language="java" contentType="text/html; charset=UTF-8"
 pageEncoding="UTF-8"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!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>
</head>
<style type="text/css">
table{
 width : 650px;
 border-collapse: collapse;
}
td{
 padding: 5px;
}

</style>
<body>
 <h2>글목록</h2>
 <p>
 <table border="1"  width="800">
  <tr align="center" style="font-weight: bold" bgcolor="yellow">
   <td width="65px">글번호</td>
   <td width="300">제목</td>
   <td width="80px">작성자</td>
   <td width="60">작성일</td>
   <td width="60">조회수</td>
  </tr>
  <c:forEach items="${requestScope.ldto.list }" var="bdto">
   <tr>
    <td>${bdto.no }</td>
    <td>
    <c:if test="${bdto.relevel!=0 }">
     <c:forEach begin="1" end="${bdto.relevel }" step="1">
     &nbsp;&nbsp;&nbsp;
     </c:forEach>
     ㄴ
    </c:if>
    <a href="/${initParam.context_root }/boardController?command=get_content&no=${bdto.no}&page=${requestScope.ldto.pagingDTO.currentPage }">${bdto.title }</a></td>
    <td>${bdto.writer }</td>
    <td>${bdto.writedate }</td>
    <td>${bdto.viewcount }</td>
   </tr>
  </c:forEach>

 </table>
 <table>
 <tr>
 <td>
  
 <c:choose>
  <c:when test="${requestScope.ldto.pagingDTO.previousPageGroup }">
   <a href="/${initParam.context_root }/boardController?command=list&page=${requestScope.ldto.pagingDTO.startPageOfPageGroup-1 }">◀ </a>
  </c:when>
  <c:otherwise>◀ </c:otherwise>
  
 </c:choose>
  
  <c:forEach begin="${requestScope.ldto.pagingDTO.startPageOfPageGroup }" end="${requestScope.ldto.pagingDTO.endPageOfPageGroup }" step="1" var="cnt" >
  <c:choose>
  <c:when test="${cnt==requestScope.ldto.pagingDTO.currentPage }">${cnt }</c:when>
  <c:otherwise>
  <a href="/${initParam.context_root }/boardController?command=list&page=${cnt }">${cnt }</a>
  </c:otherwise>
  </c:choose>
  </c:forEach>
  
   <c:choose>
  <c:when test="${requestScope.ldto.pagingDTO.nextPageGroup }">
   <a href="/${initParam.context_root }/boardController?command=list&page=${requestScope.ldto.pagingDTO.endPageOfPageGroup+1 }">▶ </a>
  </c:when>
  <c:otherwise>▶ </c:otherwise>
  </c:choose>
  
  </td>
 </tr>
 </table>
</body>
</html>

package board.dto;

public class BoardDTO {
 private int no;
 private String title;
 private String writer;
 private String content;
 private String writedate;
 private int viewcount;
 private int refamily;
 private int restep;
 private int relevel;
 public BoardDTO() {
  super();
 }
 
 public BoardDTO(String title, String writer, String content) {
  super();
  this.title = title;
  this.writer = writer;
  this.content = content;
 }

 public BoardDTO(int no, String title, String writer, String content,
   String writedate, int viewcount, int refamily, int restep,
   int relevel) {
  super();
  this.no = no;
  this.title = title;
  this.writer = writer;
  this.content = content;
  this.writedate = writedate;
  this.viewcount = viewcount;
  this.refamily = refamily;
  this.restep = restep;
  this.relevel = relevel;
 }

 public BoardDTO(int no, String title, String writer, String content,
   String writedate, int viewcount) {
  super();
  this.no = no;
  this.title = title;
  this.writer = writer;
  this.content = content;
  this.writedate = writedate;
  this.viewcount = viewcount;
 }

 public int getNo() {
  return no;
 }
 public void setNo(int no) {
  this.no = no;
 }
 public String getTitle() {
  return title;
 }
 public void setTitle(String title) {
  this.title = title;
 }
 public String getWriter() {
  return writer;
 }
 public void setWriter(String writer) {
  this.writer = writer;
 }
 public String getContent() {
  return content;
 }
 public void setContent(String content) {
  this.content = content;
 }
 public String getWritedate() {
  return writedate;
 }
 public void setWritedate(String writedate) {
  this.writedate = writedate;
 }
 public int getViewcount() {
  return viewcount;
 }
 public void setViewcount(int viewcount) {
  this.viewcount = viewcount;
 }
 public int getRefamily() {
  return refamily;
 }
 public void setRefamily(int refamily) {
  this.refamily = refamily;
 }
 public int getRestep() {
  return restep;
 }
 public void setRestep(int restep) {
  this.restep = restep;
 }
 public int getRelevel() {
  return relevel;
 }
 public void setRelevel(int relevel) {
  this.relevel = relevel;
 }
 @Override
 public String toString() {
  return "BoardDTO [no=" + no + ", title=" + title + ", writer=" + writer
    + ", content=" + content + ", writedate=" + writedate
    + ", viewcount=" + viewcount + ", refamily=" + refamily
    + ", restep=" + restep + ", relevel=" + relevel + "]";
 }
 @Override
 public int hashCode() {
  final int prime = 31;
  int result = 1;
  result = prime * result + ((content == null) ? 0 : content.hashCode());
  result = prime * result + no;
  result = prime * result + refamily;
  result = prime * result + relevel;
  result = prime * result + restep;
  result = prime * result + ((title == null) ? 0 : title.hashCode());
  result = prime * result + viewcount;
  result = prime * result
    + ((writedate == null) ? 0 : writedate.hashCode());
  result = prime * result + ((writer == null) ? 0 : writer.hashCode());
  return result;
 }
 @Override
 public boolean equals(Object obj) {
  if (this == obj)
   return true;
  if (obj == null)
   return false;
  if (getClass() != obj.getClass())
   return false;
  BoardDTO other = (BoardDTO) obj;
  if (content == null) {
   if (other.content != null)
    return false;
  } else if (!content.equals(other.content))
   return false;
  if (no != other.no)
   return false;
  if (refamily != other.refamily)
   return false;
  if (relevel != other.relevel)
   return false;
  if (restep != other.restep)
   return false;
  if (title == null) {
   if (other.title != null)
    return false;
  } else if (!title.equals(other.title))
   return false;
  if (viewcount != other.viewcount)
   return false;
  if (writedate == null) {
   if (other.writedate != null)
    return false;
  } else if (!writedate.equals(other.writedate))
   return false;
  if (writer == null) {
   if (other.writer != null)
    return false;
  } else if (!writer.equals(other.writer))
   return false;
  return true;
 }
 

 
}

package board.dto;

public class BoardDTO {
 private int no;
 private String title;
 private String writer;
 private String content;
 private String writedate;
 private int viewcount;
 private int refamily;
 private int restep;
 private int relevel;
 public BoardDTO() {
  super();
 }
 
 public BoardDTO(String title, String writer, String content) {
  super();
  this.title = title;
  this.writer = writer;
  this.content = content;
 }

 public BoardDTO(int no, String title, String writer, String content,
   String writedate, int viewcount, int refamily, int restep,
   int relevel) {
  super();
  this.no = no;
  this.title = title;
  this.writer = writer;
  this.content = content;
  this.writedate = writedate;
  this.viewcount = viewcount;
  this.refamily = refamily;
  this.restep = restep;
  this.relevel = relevel;
 }

 public BoardDTO(int no, String title, String writer, String content,
   String writedate, int viewcount) {
  super();
  this.no = no;
  this.title = title;
  this.writer = writer;
  this.content = content;
  this.writedate = writedate;
  this.viewcount = viewcount;
 }

 public int getNo() {
  return no;
 }
 public void setNo(int no) {
  this.no = no;
 }
 public String getTitle() {
  return title;
 }
 public void setTitle(String title) {
  this.title = title;
 }
 public String getWriter() {
  return writer;
 }
 public void setWriter(String writer) {
  this.writer = writer;
 }
 public String getContent() {
  return content;
 }
 public void setContent(String content) {
  this.content = content;
 }
 public String getWritedate() {
  return writedate;
 }
 public void setWritedate(String writedate) {
  this.writedate = writedate;
 }
 public int getViewcount() {
  return viewcount;
 }
 public void setViewcount(int viewcount) {
  this.viewcount = viewcount;
 }
 public int getRefamily() {
  return refamily;
 }
 public void setRefamily(int refamily) {
  this.refamily = refamily;
 }
 public int getRestep() {
  return restep;
 }
 public void setRestep(int restep) {
  this.restep = restep;
 }
 public int getRelevel() {
  return relevel;
 }
 public void setRelevel(int relevel) {
  this.relevel = relevel;
 }
 @Override
 public String toString() {
  return "BoardDTO [no=" + no + ", title=" + title + ", writer=" + writer
    + ", content=" + content + ", writedate=" + writedate
    + ", viewcount=" + viewcount + ", refamily=" + refamily
    + ", restep=" + restep + ", relevel=" + relevel + "]";
 }
 @Override
 public int hashCode() {
  final int prime = 31;
  int result = 1;
  result = prime * result + ((content == null) ? 0 : content.hashCode());
  result = prime * result + no;
  result = prime * result + refamily;
  result = prime * result + relevel;
  result = prime * result + restep;
  result = prime * result + ((title == null) ? 0 : title.hashCode());
  result = prime * result + viewcount;
  result = prime * result
    + ((writedate == null) ? 0 : writedate.hashCode());
  result = prime * result + ((writer == null) ? 0 : writer.hashCode());
  return result;
 }
 @Override
 public boolean equals(Object obj) {
  if (this == obj)
   return true;
  if (obj == null)
   return false;
  if (getClass() != obj.getClass())
   return false;
  BoardDTO other = (BoardDTO) obj;
  if (content == null) {
   if (other.content != null)
    return false;
  } else if (!content.equals(other.content))
   return false;
  if (no != other.no)
   return false;
  if (refamily != other.refamily)
   return false;
  if (relevel != other.relevel)
   return false;
  if (restep != other.restep)
   return false;
  if (title == null) {
   if (other.title != null)
    return false;
  } else if (!title.equals(other.title))
   return false;
  if (viewcount != other.viewcount)
   return false;
  if (writedate == null) {
   if (other.writedate != null)
    return false;
  } else if (!writedate.equals(other.writedate))
   return false;
  if (writer == null) {
   if (other.writer != null)
    return false;
  } else if (!writer.equals(other.writer))
   return false;
  return true;
 }
 

 
}

package board.util;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import org.apache.tomcat.dbcp.dbcp.BasicDataSource;
//싱글톤 패턴
public class DBUtil {
 private BasicDataSource dataSource;//객체 생성 -> 생성자
 private static DBUtil instance = new DBUtil();
 private DBUtil(){
  dataSource = new BasicDataSource();
  //프라퍼티 설정
  //1. 연결할 DB와 관련된 설정
  dataSource.setDriverClassName("oracle.jdbc.driver.OracleDriver");//BasicDataSource를 사용하면 따로 드라이버 로딩을 해줄 필요가 없다. 바로 처리가능
  dataSource.setUrl("jdbc:oracle:thin:@127.0.0.1:1521:XE");
  dataSource.setUsername("scott");
  dataSource.setPassword("tiger");
 }
 public static DBUtil getInstance(){
  return instance;
 }
 public BasicDataSource getDataSource(){
  return dataSource;
 }
 public void close(Connection conn, PreparedStatement pstmt)throws SQLException{
  if(pstmt!=null){
   pstmt.close();
  }
  if(conn!=null){
   conn.close();
  }
 }
 public void close(Connection conn, PreparedStatement pstmt, ResultSet rset)throws SQLException{
  if(rset!=null){
   rset.close();
  }
  if(pstmt!=null){
   pstmt.close();
  }
  if(conn!=null){
   conn.close();
  }
 }
}

package board.util;

 
import java.text.SimpleDateFormat;
import java.util.Date;
 

public class Utilities {
 //글목록에서 한페이지에 보여질 게시물의 개수
 public static final int CONTENT_PER_PAGE = 10;
 //한 페이지 그룹으로 묶을 페이지의 개수
 public static final int PAGE_PER_PAGEGROUP = 10;
 //생성자( Utilities객체의 메소드가 전부 static이어서 객체를 생성할 필요가 없어서 생성자를 private로 막았다. )
 private Utilities(){
  
 }
 /**
  * 호출된 시점의 일시를 14자리 String 값으로 만들어 return
  *  예) 20120512100524 (yyyyMMddHHmmss)
  * @return
  */
 public static String getNow(){
  
  Date date = new Date();
  SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyyMMddHHmmss");//new SimpleDateFormat("yyyy.MM.dd HH:mm:ss");
  
  return simpleDateFormat.format(date);
 }
 /**
  * 인수로 14자리 형태 일시를 받아 날짜만 yyyy.MM.dd 형태의 String으로 만들어 return
  * - 목록에서 작성일시를 보여줄때 사용할 메소드
  * 예) 20120512100524 -> 2012.05.12
  * @param dateTime
  * @return
  */
 public static String changeDayFormat(String dateTime){
 
  return dateTime.substring(0, 4)+"."+dateTime.substring(4, 6)+"."+dateTime.substring(6, 8);
//  SimpleDateFormat sf = new SimpleDateFormat("yyyy.MM.dd");
//  String changeDay = sf.format(dateTime); //이렇게 하면 넘어오는 dateTime이 String값이어서 실행시점에 에러가 난다. sf.format(dateTime)의 dateTime은 Date객체가 들어가야 한다.
//
//  return changeDay;
 }
 /**
  * 인수로 14자리 형태의 일시를 받아 yyyy.MM.dd HH:mm:ss 형태의 String으로 만들어 return
  * - 글 상세보기에서 사용할 메소드
  * 예)20120512100524 -> 2012.05.12 10:05:24
  * @param dateTime
  * @return
  */
 public static String changeDayTimeFormat(String dateTime){
 
  return dateTime.substring(0, 4)+"."+dateTime.substring(4, 6)+"."+dateTime.substring(6, 8)+" "+dateTime.substring(8, 10)+":"+dateTime.substring(10, 12)+":"+ dateTime.substring(12, 14);
 }
 /**
  * TextArea에서 입력 받은 글 내용을 HTML로 출력 될 때에 맞는 형식으로 변경하는 메소드
  * 새글등록, 답변글등록, 글 수정시 사용
  * > - &gt;
  * < - &lt;
  * \n - <br>
  * 공백 - &nbsp;
  */
 public static String changeContentForDB(String content){
  //변환 시 순서가 중요
  String newContent =  content.replaceAll(">", "&gt;");
  newContent = newContent.replaceAll("<","&lt;");
  newContent = newContent.replaceAll(" ","&nbsp;");
  newContent = newContent.replaceAll("\n","<br>");
  
  return newContent;
 }
 /**
  * DB 에 저장된 content를 TextArea에 출력할 형식으로 변경
  * 글수정 폼, 답글 폼 출력시 사용
  * <br> - \n
  * &gt; ->
  * &lt; - <
  * &nbsp; - 공백
  */
 public static String changeContentForTextArea(String content){
  String newContent = content.replaceAll("<br>","\n");
  newContent = newContent.replaceAll("&gt;",">");
  newContent = newContent.replaceAll("&lt;","<");
  newContent = newContent.replaceAll("&nbsp;"," ");
 
  return newContent;
 }

 
}

package board.model.service;

import java.sql.SQLException;
import java.util.ArrayList;

import board.dto.BoardDTO;
import board.model.dao.BoardDAO;

import board.util.Utilities;

public class BoardService {
 private static BoardService instance = new BoardService();
 private  BoardDAO dao;
 private BoardService(){
  dao = BoardDAO.getInstance();
 }
 public static BoardService getInstance(){
  return instance;
 }
}

package board.controller;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import board.dto.ForwardDTO;

public interface Controller {
 public ForwardDTO execute(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException;
}

package board.controller;

public class ControllerCommandMapping {

 public static Controller getController(String command){
  Controller ctr = null;

  return ctr;
 }

}

package board.controller;

import java.io.IOException;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import board.dto.ForwardDTO;

public class BoardFrontController extends HttpServlet {
 private static final long serialVersionUID = 1L;

    public BoardFrontController() {
        super();
    
    }

 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  doPost(request, response);
 }

 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  //1. 공통 사전 작업 - 한글처리
  request.setCharacterEncoding("utf-8");
  //2. Controller 로직 처리 - Controller객체.execute()호출
  String command = request.getParameter("command");
  Controller ctr = ControllerCommandMapping.getController(command);
  ForwardDTO fdto = ctr.execute(request, response);
  //3. 공통 사후 작업
  if(fdto.isRedirect()){
   response.sendRedirect(fdto.getUrl());
  }else{
   RequestDispatcher rdp = request.getRequestDispatcher(fdto.getUrl());
   rdp.forward(request, response);
  }
 }

}

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="2.5">
  <display-name>board_fc_test</display-name>
  <welcome-file-list>
    <welcome-file>index.html</welcome-file>
    <welcome-file>index.htm</welcome-file>
    <welcome-file>index.jsp</welcome-file>
    <welcome-file>default.html</welcome-file>
    <welcome-file>default.htm</welcome-file>
    <welcome-file>default.jsp</welcome-file>
  </welcome-file-list>
  <context-param>
   <param-name>context_root</param-name>
   <param-value>board_fc_test</param-value>
  </context-param>
  <servlet>
    <description></description>
    <display-name>BoardFrontController</display-name>
    <servlet-name>BoardFrontController</servlet-name>
    <servlet-class>board.controller.BoardFrontController</servlet-class>
  </servlet>
  <servlet-mapping>
    <servlet-name>BoardFrontController</servlet-name>
    <url-pattern>/boardController</url-pattern>
  </servlet-mapping>
</web-app>

<%@ page language="java" contentType="text/html; charset=UTF-8"
 pageEncoding="UTF-8"%>
<!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>Insert title here</title>
</head>
<body>
 <h1>write.jsp</h1>
 <p>
 <h3>글쓰기</h3>
 <p>
 <form action="/${initParam.context_root }/boardController" method="post">
 
 <input type="hidden" name="command" value="write_content">
  <table>
   <tr>
    <td width="100px">제목</td>
    <td><input type="text" name="title" size="50"></td>
   </tr>
   <tr>
    <td>작성자</td>
    <td><input type="text" name="writer" size="10" maxlength="10"></td>
   </tr>
   <tr>
    <td colspan="2"><textarea cols="50" rows="10" name="content"></textarea></td>
   </tr>
   <tr>
    <td colspan="2" align="center">
     <input type="submit" value="등록">
     <input type="reset" value="초기화">
    </td>
   </tr>
  </table>
 </form>
</body>
</html>

package board.controller;

public class ControllerCommandMapping {

 public static Controller getController(String command){
  Controller ctr = null;
  if(command.equals("write_content")){
   ctr = new WriteContentController();
  } 
  return ctr;
 }

}

package board.controller;

import java.io.IOException;
import java.sql.SQLException;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import board.dto.BoardDTO;
import board.dto.ForwardDTO;

import board.model.service.BoardService;
 

public class WriteContentController implements Controller{

 //controller에서는 클라이언트가 보낸 값을 읽어서 비지니스 로직단에 넘겨주고, 비지니스 서비스 쪽에서 DB에서 값을 얻어오고 초기 값을 설정해 준다.
 @Override
 public ForwardDTO execute(HttpServletRequest request,
   HttpServletResponse response) throws ServletException, IOException {
  //1, client가 보낸 요청 파라미터 조회
  String title = request.getParameter("title");
  String writer = request.getParameter("writer");
  String content = request.getParameter("content");
  BoardDTO bto = new BoardDTO(title, writer, content);
  //2. 비지니스 로직 - Model(Business Service)로 요청
  BoardService boardService = BoardService.getInstance();
  ForwardDTO forwardDTO = null;
  try {
   boardService.writeContent(bto);
   request.setAttribute("board",bto);
   forwardDTO = new ForwardDTO("/show_content.jsp",false);
  } catch (SQLException e) {
   e.printStackTrace();
   request.setAttribute("error_message", e.getMessage());
   forwardDTO = new ForwardDTO("/error.jsp",false);
  }
 
  return forwardDTO;
 }
 
}

package board.model.service;

import java.sql.SQLException;
import java.util.ArrayList;

import board.dto.BoardDTO;
import board.model.dao.BoardDAO;

import board.util.Utilities;

public class BoardService {
 private static BoardService instance = new BoardService();
 private  BoardDAO dao;
 private BoardService(){
  dao = BoardDAO.getInstance();
 }
 public static BoardService getInstance(){
  return instance;
 }
 public void writeContent(BoardDTO bto)throws SQLException{
  /*
   * 1. bto에 property 설정 - no, writedate, content
   *   no - sequence의 값 - dao.selectBoardNO();
   *   writedate - Utilities.getNow();
   *   content를 DB에 넣는 용으로 변경 Utilities.changeContentForDB();
   *   bdto의 refamily에 no 값을 설정
   * 2. dao.insertContent(bto);
   * 3. 날짜 형태를 년.월.일 시:분:초 형태로 변경 - bto의 property 변경
   *   Utilities.changeDayTimeFormat();
   */
  //1
  int no = dao.selectBoardNo();
  String writedate = Utilities.getNow();
  bto.setNo(no);
  bto.setWritedate(writedate);
  bto.setContent(Utilities.changeContentForDB(bto.getContent()));
  bto.setRefamily(no);
  //2
  dao.insertContent(bto);
  //3
  bto.setWritedate(Utilities.changeDayTimeFormat(writedate));
 }

 }

package board.model.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import org.apache.tomcat.dbcp.dbcp.BasicDataSource;

import board.dto.BoardDTO;
import board.util.DBUtil;

public class BoardDAO {
 private static BoardDAO instance = new BoardDAO();
 private DBUtil dbUtil;

 private BoardDAO() {
  dbUtil = DBUtil.getInstance();
 }

 public static BoardDAO getInstance() {
  return instance;
 }

 public int selectBoardNo() throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select board_no_seq.nextval from dual";
  int no = 0;
  try {
   BasicDataSource ds = dbUtil.getDataSource();
   conn = ds.getConnection();
   pstmt = conn.prepareStatement(sql);
   rset = pstmt.executeQuery();
   if (rset.next()) {
    no = rset.getInt(1);
   }
  } finally {
   dbUtil.close(conn, pstmt, rset);
  }
  return no;
 }

 public void insertContent(BoardDTO bto) throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;

  String sql = "insert into board (no, title, writer, content, writedate, viewcount, refamily, restep, relevel)  values(?,?,?,?,?,0,?,?,?)";
  try {
   BasicDataSource ds = dbUtil.getDataSource();
   conn = ds.getConnection();
   pstmt = conn.prepareStatement(sql);
   pstmt.setInt(1, bto.getNo());
   pstmt.setString(2, bto.getTitle());
   pstmt.setString(3, bto.getWriter());
   pstmt.setString(4, bto.getContent());
   pstmt.setString(5, bto.getWritedate());
   //viewcount값은 처음 등록하면 무조건 0이라서 쿼리에서 부터 그냥 값을 넣어줬다
//   pstmt.setInt(6, bto.getViewcount());
   pstmt.setInt(6, bto.getRefamily());
   pstmt.setInt(7, bto.getRestep());
   pstmt.setInt(8, bto.getRelevel());
   int cnt = pstmt.executeUpdate();
   System.out.println(cnt + "개의 행이 삽입되었습니다.");

  } finally {
   dbUtil.close(conn, pstmt);
  }
 }
 
}

<%@page import="board.dto.BoardDTO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
 pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!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>
<style type="text/css">
div{
 width:600px;
 border:1px solid gray;
 padding : 5px;
}
#title{
 font-weight: bold;
 background-color: yellow;
}
#info{
 font-size:13px;
}
#content{
 min-height:300px;
 height:auto;
}
</style>
</head>
<body>
 <h1>글목록</h1>
 <p>
<div id="title">${requestScope.board.no}.${requestScope.board.title }</div>
<div id="info">작성자 : ${requestScope.board.writer } | 조회수 : ${requestScope.board.viewcount } 작성일시 : ${requestScope.board.writedate }</div>
<div id="content">${requestScope.board.content }</div>
 <p>
  <a href="/${initParam.context_root }/write_form.jsp">글쓰기</a>
  <a href="/${initParam.context_root }/boardController?command=list_all">전체 글목록</a>
  <a href="">글목록(페이징)</a>
  <a href="/${initParam.context_root }/boardController?command=modify_form&no=${requestScope.board.no}">글수정</a>
  <a href="/${initParam.context_root }/boardController?command=delete_content&no=${requestScope.board.no}">글삭제</a>
  <a href="/${initParam.context_root }/boardController?command=reply_form&no=${requestScope.board.no}">답변</a>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!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>Insert title here</title>
</head>
<body>

<c:if test="${requestScope.error_message!=null }">
실행 도중 오류가 발생했습니다.<br>
오류 내용 ${error_message }
</c:if>
<a href='/${initParam.context_root }/show_content.jsp'>메인페이지로 이동</a>
</body>
</html>

<%@page import="board.dto.BoardDTO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
 pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!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>
<style type="text/css">
div{
 width:600px;
 border:1px solid gray;
 padding : 5px;
}
#title{
 font-weight: bold;
 background-color: yellow;
}
#info{
 font-size:13px;
}
#content{
 min-height:300px;
 height:auto;
}
</style>
</head>
<body>
 <h1>글목록</h1>
 <p>
<div id="title">${requestScope.board.no}.${requestScope.board.title }</div>
<div id="info">작성자 : ${requestScope.board.writer } | 조회수 : ${requestScope.board.viewcount } 작성일시 : ${requestScope.board.writedate }</div>
<div id="content">${requestScope.board.content }</div>
 <p>
  <a href="/${initParam.context_root }/write_form.jsp">글쓰기</a> 
  <a href="/${initParam.context_root }/boardController?command=list_all">전체 글목록</a> 
  <a href="">글목록(페이징)</a>
  <a href="/${initParam.context_root }/boardController?command=modify_form&no=${requestScope.board.no}">글수정</a>
  <a href="/${initParam.context_root }/boardController?command=delete_content&no=${requestScope.board.no}">글삭제</a>
  <a href="/${initParam.context_root }/boardController?command=reply_form&no=${requestScope.board.no}">답변</a>
</body>
</html>

package board.controller;

public class ControllerCommandMapping {

 public static Controller getController(String command){
  Controller ctr = null;
  if(command.equals("write_content")){
   ctr = new WriteContentController();
  }else if(command.equals("list_all")){
   ctr = new BoardAllListController();
  }
  return ctr;
 }

}

package board.controller;

import java.io.IOException;
import java.sql.SQLException;
import java.util.ArrayList;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import board.dto.BoardDTO;
import board.dto.ForwardDTO;
import board.model.service.BoardService;

public class BoardAllListController implements Controller {

 @Override
 public ForwardDTO execute(HttpServletRequest request,
   HttpServletResponse response) throws ServletException, IOException {
  //1. 비지니스 로직 - Model(Business Service)로 요청
  BoardService boardService = BoardService.getInstance();
  ForwardDTO forwardDTO = null;
  try {
   ArrayList<BoardDTO> list_all = boardService.getBoardAllList();
   
   request.setAttribute("list_all",list_all);
   forwardDTO = new ForwardDTO("/list_all.jsp",false);
  } catch (SQLException e) {
   e.printStackTrace();
   request.setAttribute("error_message", e.getMessage());
   forwardDTO = new ForwardDTO("/error.jsp",false);
  }
 
  return forwardDTO;
 
 }

}

package board.model.service;

import java.sql.SQLException;
import java.util.ArrayList;

import board.dto.BoardDTO;
import board.model.dao.BoardDAO;

import board.util.Utilities;

public class BoardService {
 private static BoardService instance = new BoardService();
 private  BoardDAO dao;
 private BoardService(){
  dao = BoardDAO.getInstance();
 }
 public static BoardService getInstance(){
  return instance;
 }
 public void writeContent(BoardDTO bto)throws SQLException{
  /*
   * 1. bto에 property 설정 - no, writedate, content
   *   no - sequence의 값 - dao.selectBoardNO();
   *   writedate - Utilities.getNow();
   *   content를 DB에 넣는 용으로 변경 Utilities.changeContentForDB();
   *   bdto의 refamily에 no 값을 설정
   * 2. dao.insertContent(bto);
   * 3. 날짜 형태를 년.월.일 시:분:초 형태로 변경 - bto의 property 변경
   *   Utilities.changeDayTimeFormat();
   */
  //1
  int no = dao.selectBoardNo();
  String writedate = Utilities.getNow();
  bto.setNo(no);
  bto.setWritedate(writedate);
  bto.setContent(Utilities.changeContentForDB(bto.getContent()));
  bto.setRefamily(no);
  //2
  dao.insertContent(bto);
  //3
  bto.setWritedate(Utilities.changeDayTimeFormat(writedate));
 }
 //글목록
 public ArrayList<BoardDTO> getBoardAllList() throws SQLException{
  //1. dao로 부터 전체 글내용을 ArrayList로 조회
  ArrayList<BoardDTO> list_all = dao.selectBoardAllList();
  //2. list내의 BoardDTO객체들의 wrtiedate를 변경
 
  for(int i=0;i<list_all.size();i++){
   list_all.get(i).setWritedate(Utilities.changeDayFormat(list_all.get(i).getWritedate()));
  }

  return list_all;
 }

}

package board.model.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import org.apache.tomcat.dbcp.dbcp.BasicDataSource;

import board.dto.BoardDTO;
import board.util.DBUtil;

public class BoardDAO {
 private static BoardDAO instance = new BoardDAO();
 private DBUtil dbUtil;

 private BoardDAO() {
  dbUtil = DBUtil.getInstance();
 }

 public static BoardDAO getInstance() {
  return instance;
 }

 public int selectBoardNo() throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select board_no_seq.nextval from dual";
  int no = 0;
  try {
   BasicDataSource ds = dbUtil.getDataSource();
   conn = ds.getConnection();
   pstmt = conn.prepareStatement(sql);
   rset = pstmt.executeQuery();
   if (rset.next()) {
    no = rset.getInt(1);
   }
  } finally {
   dbUtil.close(conn, pstmt, rset);
  }
  return no;
 }

 public void insertContent(BoardDTO bto) throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;

  String sql = "insert into board (no, title, writer, content, writedate, viewcount, refamily, restep, relevel)  values(?,?,?,?,?,0,?,?,?)";
  try {
   BasicDataSource ds = dbUtil.getDataSource();
   conn = ds.getConnection();
   pstmt = conn.prepareStatement(sql);
   pstmt.setInt(1, bto.getNo());
   pstmt.setString(2, bto.getTitle());
   pstmt.setString(3, bto.getWriter());
   pstmt.setString(4, bto.getContent());
   pstmt.setString(5, bto.getWritedate());
   //viewcount값은 처음 등록하면 무조건 0이라서 쿼리에서 부터 그냥 값을 넣어줬다
//   pstmt.setInt(6, bto.getViewcount());
   pstmt.setInt(6, bto.getRefamily());
   pstmt.setInt(7, bto.getRestep());
   pstmt.setInt(8, bto.getRelevel());
   int cnt = pstmt.executeUpdate();
   System.out.println(cnt + "개의 행이 삽입되었습니다.");

  } finally {
   dbUtil.close(conn, pstmt);
  }
 }

 public ArrayList<BoardDTO> selectBoardAllList() throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select no, title, writer, content, writedate, viewcount, refamily, restep, relevel from board order by refamily desc, restep asc";
  ArrayList<BoardDTO> list_all = new ArrayList<BoardDTO>();
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  rset = pstmt.executeQuery();
   while(rset.next()){
    list_all.add(new BoardDTO(rset.getInt(1), rset.getString(2), rset.getString(3), rset.getString(4), rset.getString(5), rset.getInt(6), rset.getInt(7), rset.getInt(8), rset.getInt(9)));
   }
  }finally{
   dbUtil.close(conn, pstmt, rset);
  }
  return list_all;
 }

}

<%@ page language="java" contentType="text/html; charset=UTF-8"
 pageEncoding="UTF-8"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!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>
</head>
<style type="text/css">
table{
 width : 650px;
 border-collapse: collapse;
}
td{
 padding: 5px;
}

</style>
<body>
 <h2>글목록</h2>
 <p>
 <table border="1"  width="800">
  <tr align="center" style="font-weight: bold" bgcolor="yellow">
   <td width="65px">글번호</td>
   <td width="300">제목</td>
   <td width="80px">작성자</td>
   <td width="60">작성일</td>
   <td width="60">조회수</td>
  </tr>
  <c:forEach items="${requestScope.list_all }" var="list_all">
   <tr>
    <td>${list_all.no }</td>
    <td>
    <c:if test="${list_all.relevel!=0 }">
     <c:forEach begin="1" end="${list_all.relevel }" step="1">
     &nbsp;&nbsp;&nbsp;
     </c:forEach>
     ㄴ
    </c:if>
    <a href="/${initParam.context_root }/boardController?command=get_content&no=${list_all.no}">${list_all.title }</a></td>
    <td>${list_all.writer }</td>
    <td>${list_all.writedate }</td>
    <td>${list_all.viewcount }</td>
   </tr>
  </c:forEach>
 </table>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
 pageEncoding="UTF-8"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!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>
</head>
<style type="text/css">
table{
 width : 650px;
 border-collapse: collapse;
}
td{
 padding: 5px;
}

</style>
<body>
 <h2>글목록</h2>
 <p>
 <table border="1"  width="800">
  <tr align="center" style="font-weight: bold" bgcolor="yellow">
   <td width="65px">글번호</td>
   <td width="300">제목</td>
   <td width="80px">작성자</td>
   <td width="60">작성일</td>
   <td width="60">조회수</td>
  </tr>
  <c:forEach items="${requestScope.list_all }" var="list_all">
   <tr>
    <td>${list_all.no }</td>
    <td>
    <c:if test="${list_all.relevel!=0 }">
     <c:forEach begin="1" end="${list_all.relevel }" step="1">
     &nbsp;&nbsp;&nbsp;
     </c:forEach>
     ㄴ
    </c:if>
    <a href="/${initParam.context_root }/boardController?command=get_content&no=${list_all.no}">${list_all.title }</a></td>
    <td>${list_all.writer }</td>
    <td>${list_all.writedate }</td>
    <td>${list_all.viewcount }</td>
   </tr>
  </c:forEach>
 </table>
</body>
</html>

package board.controller;

import java.io.IOException;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import board.dto.ForwardDTO;

public class BoardFrontController extends HttpServlet {
 private static final long serialVersionUID = 1L;

    public BoardFrontController() {
        super();
    
    }

 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  doPost(request, response);
 }

 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  //1. 공통 사전 작업 - 한글처리
  request.setCharacterEncoding("utf-8");
  //2. Controller 로직 처리 - Controller객체.execute()호출
  String command = request.getParameter("command");
  Controller ctr = ControllerCommandMapping.getController(command);
  ForwardDTO fdto = ctr.execute(request, response);
  //3. 공통 사후 작업
  if(fdto.isRedirect()){
   response.sendRedirect(fdto.getUrl());
  }else{
   RequestDispatcher rdp = request.getRequestDispatcher(fdto.getUrl());
   rdp.forward(request, response);
  }
 }

}

package board.controller;

public class ControllerCommandMapping {

 public static Controller getController(String command){
  Controller ctr = null;
  if(command.equals("write_content")){
   ctr = new WriteContentController();
  }else if(command.equals("list_all")){
   ctr = new BoardAllListController();
  }else if(command.equals("get_content")){
   ctr = new GetContentController();
  } 
  return ctr;
 }

}

package board.controller;

import java.io.IOException;
 
 

 
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import board.dto.BoardDTO;
import board.dto.ForwardDTO;
import board.model.service.BoardService;

public class GetContentController implements Controller {

 @Override
 public ForwardDTO execute(HttpServletRequest request,
   HttpServletResponse response) throws ServletException, IOException {
  //글번로를 받아 글의 벙보를 조회하는 컨트롤러
  BoardService boardService = BoardService.getInstance();
  ForwardDTO forwardDTO = null;
  int no = Integer.parseInt(request.getParameter("no"));
  try{
   BoardDTO get_content = boardService.getContentByNO(no);
   request.setAttribute("board", get_content);
   forwardDTO = new ForwardDTO("/show_content.jsp",false);
  } catch(Exception e){
   e.printStackTrace();
   request.setAttribute("error_message", e.getMessage());
   forwardDTO = new ForwardDTO("/error.jsp",false);
  }
  return forwardDTO;
 }

}

package board.model.service;

import java.sql.SQLException;
import java.util.ArrayList;

import board.dto.BoardDTO;
import board.model.dao.BoardDAO;

import board.util.Utilities;

public class BoardService {
 private static BoardService instance = new BoardService();
 private  BoardDAO dao;
 private BoardService(){
  dao = BoardDAO.getInstance();
 }
 public static BoardService getInstance(){
  return instance;
 }
 public void writeContent(BoardDTO bto)throws SQLException{
  /*
   * 1. bto에 property 설정 - no, writedate, content
   *   no - sequence의 값 - dao.selectBoardNO();
   *   writedate - Utilities.getNow();
   *   content를 DB에 넣는 용으로 변경 Utilities.changeContentForDB();
   *   bdto의 refamily에 no 값을 설정
   * 2. dao.insertContent(bto);
   * 3. 날짜 형태를 년.월.일 시:분:초 형태로 변경 - bto의 property 변경
   *   Utilities.changeDayTimeFormat();
   */
  //1
  int no = dao.selectBoardNo();
  String writedate = Utilities.getNow();
  bto.setNo(no);
  bto.setWritedate(writedate);
  bto.setContent(Utilities.changeContentForDB(bto.getContent()));
  bto.setRefamily(no);
  //2
  dao.insertContent(bto);
  //3
  bto.setWritedate(Utilities.changeDayTimeFormat(writedate));
 }
 //글목록
 public ArrayList<BoardDTO> getBoardAllList() throws SQLException{
  //1. dao로 부터 전체 글내용을 ArrayList로 조회
  ArrayList<BoardDTO> list_all = dao.selectBoardAllList();
  //2. list내의 BoardDTO객체들의 wrtiedate를 변경
 
  for(int i=0;i<list_all.size();i++){
   list_all.get(i).setWritedate(Utilities.changeDayFormat(list_all.get(i).getWritedate()));
  }

  return list_all;
 }
 public BoardDTO getContentByNO(int no) throws SQLException{
  
  //1.조회수 증가
  dao.updateViewCount(no);
  //2. no로 글 정보 조회
  BoardDTO bto = dao.selectContentByNO(no);
  //2-1 writedate를 yyy.MM.dd HH:mm:ss 형식으로 변경
  bto.setWritedate(Utilities.changeDayTimeFormat(bto.getWritedate()));
  
  return bto;
 }
 
}

package board.model.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import org.apache.tomcat.dbcp.dbcp.BasicDataSource;

import board.dto.BoardDTO;
import board.util.DBUtil;

public class BoardDAO {
 private static BoardDAO instance = new BoardDAO();
 private DBUtil dbUtil;

 private BoardDAO() {
  dbUtil = DBUtil.getInstance();
 }

 public static BoardDAO getInstance() {
  return instance;
 }

 public int selectBoardNo() throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select board_no_seq.nextval from dual";
  int no = 0;
  try {
   BasicDataSource ds = dbUtil.getDataSource();
   conn = ds.getConnection();
   pstmt = conn.prepareStatement(sql);
   rset = pstmt.executeQuery();
   if (rset.next()) {
    no = rset.getInt(1);
   }
  } finally {
   dbUtil.close(conn, pstmt, rset);
  }
  return no;
 }

 public void insertContent(BoardDTO bto) throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;

  String sql = "insert into board (no, title, writer, content, writedate, viewcount, refamily, restep, relevel)  values(?,?,?,?,?,0,?,?,?)";
  try {
   BasicDataSource ds = dbUtil.getDataSource();
   conn = ds.getConnection();
   pstmt = conn.prepareStatement(sql);
   pstmt.setInt(1, bto.getNo());
   pstmt.setString(2, bto.getTitle());
   pstmt.setString(3, bto.getWriter());
   pstmt.setString(4, bto.getContent());
   pstmt.setString(5, bto.getWritedate());
   //viewcount값은 처음 등록하면 무조건 0이라서 쿼리에서 부터 그냥 값을 넣어줬다
//   pstmt.setInt(6, bto.getViewcount());
   pstmt.setInt(6, bto.getRefamily());
   pstmt.setInt(7, bto.getRestep());
   pstmt.setInt(8, bto.getRelevel());
   int cnt = pstmt.executeUpdate();
   System.out.println(cnt + "개의 행이 삽입되었습니다.");

  } finally {
   dbUtil.close(conn, pstmt);
  }
 }

 public ArrayList<BoardDTO> selectBoardAllList() throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select no, title, writer, content, writedate, viewcount, refamily, restep, relevel from board order by refamily desc, restep asc";
  ArrayList<BoardDTO> list_all = new ArrayList<BoardDTO>();
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  rset = pstmt.executeQuery();
   while(rset.next()){
    list_all.add(new BoardDTO(rset.getInt(1), rset.getString(2), rset.getString(3), rset.getString(4), rset.getString(5), rset.getInt(6), rset.getInt(7), rset.getInt(8), rset.getInt(9)));
   }
  }finally{
   dbUtil.close(conn, pstmt, rset);
  }
  return list_all;
 }

 public BoardDTO selectContentByNO(int no) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select no, title, writer, content, writedate, viewcount, refamily, restep, relevel from board where no=?";
  BoardDTO bto = null;
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, no);
  rset = pstmt.executeQuery();
  if(rset.next()){
   bto = new BoardDTO(rset.getInt(1), rset.getString(2), rset.getString(3), rset.getString(4), rset.getString(5), rset.getInt(6), rset.getInt(7), rset.getInt(8), rset.getInt(9));
  }
  }finally{
   dbUtil.close(conn, pstmt, rset);
  }
  return bto;
 }
 
}

<%@page import="board.dto.BoardDTO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
 pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!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>
<style type="text/css">
div{
 width:600px;
 border:1px solid gray;
 padding : 5px;
}
#title{
 font-weight: bold;
 background-color: yellow;
}
#info{
 font-size:13px;
}
#content{
 min-height:300px;
 height:auto;
}
</style>
</head>
<body>
 <h1>글목록</h1>
 <p>
<div id="title">${requestScope.board.no}.${requestScope.board.title }</div>
<div id="info">작성자 : ${requestScope.board.writer } | 조회수 : ${requestScope.board.viewcount } 작성일시 : ${requestScope.board.writedate }</div>
<div id="content">${requestScope.board.content }</div>
 <p>
  <a href="/${initParam.context_root }/write_form.jsp">글쓰기</a>
  <a href="/${initParam.context_root }/boardController?command=list_all">전체 글목록</a>
  <a href="">글목록(페이징)</a>
  <a href="/${initParam.context_root }/boardController?command=modify_form&no=${requestScope.board.no}">글수정</a>
  <a href="/${initParam.context_root }/boardController?command=delete_content&no=${requestScope.board.no}">글삭제</a>
  <a href="/${initParam.context_root }/boardController?command=reply_form&no=${requestScope.board.no}">답변</a>
</body>
</html>

<%@page import="board.dto.BoardDTO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
 pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!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>
<style type="text/css">
div{
 width:600px;
 border:1px solid gray;
 padding : 5px;
}
#title{
 font-weight: bold;
 background-color: yellow;
}
#info{
 font-size:13px;
}
#content{
 min-height:300px;
 height:auto;
}
</style>
</head>
<body>
 <h1>글목록</h1>
 <p>
<div id="title">${requestScope.board.no}.${requestScope.board.title }</div>
<div id="info">작성자 : ${requestScope.board.writer } | 조회수 : ${requestScope.board.viewcount } 작성일시 : ${requestScope.board.writedate }</div>
<div id="content">${requestScope.board.content }</div>
 <p>
  <a href="/${initParam.context_root }/write_form.jsp">글쓰기</a>
  <a href="/${initParam.context_root }/boardController?command=list_all">전체 글목록</a>
  <a href="">글목록(페이징)</a>
  <a href="/${initParam.context_root }/boardController?command=modify_form&no=${requestScope.board.no}">글수정</a>
  <a href="/${initParam.context_root }/boardController?command=delete_content&no=${requestScope.board.no}">글삭제</a>
  <a href="/${initParam.context_root }/boardController?command=reply_form&no=${requestScope.board.no}">답변</a>
</body>
</html>

package board.controller;

import java.io.IOException;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import board.dto.ForwardDTO;

public class BoardFrontController extends HttpServlet {
 private static final long serialVersionUID = 1L;

    public BoardFrontController() {
        super();
    
    }

 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  doPost(request, response);
 }

 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  //1. 공통 사전 작업 - 한글처리
  request.setCharacterEncoding("utf-8");
  //2. Controller 로직 처리 - Controller객체.execute()호출
  String command = request.getParameter("command");
  Controller ctr = ControllerCommandMapping.getController(command);
  ForwardDTO fdto = ctr.execute(request, response);
  //3. 공통 사후 작업
  if(fdto.isRedirect()){
   response.sendRedirect(fdto.getUrl());
  }else{
   RequestDispatcher rdp = request.getRequestDispatcher(fdto.getUrl());
   rdp.forward(request, response);
  }
 }

}

package board.controller;

public class ControllerCommandMapping {

 public static Controller getController(String command){
  Controller ctr = null;
  if(command.equals("write_content")){
   ctr = new WriteContentController();
  }else if(command.equals("list_all")){
   ctr = new BoardAllListController();
  }else if(command.equals("get_content")){
   ctr = new GetContentController();
  }else if(command.equals("modify_form")){
   ctr = new ModifyFormController();
  }
  return ctr;
 }

}

package board.controller;

import java.io.IOException;
import java.sql.SQLException;
 

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import board.dto.BoardDTO;
import board.dto.ForwardDTO;
import board.model.service.BoardService;

public class ModifyFormController implements Controller {

 @Override
 public ForwardDTO execute(HttpServletRequest request,
   HttpServletResponse response) throws ServletException, IOException {
  int no = Integer.parseInt(request.getParameter("no"));
  BoardService boardService = BoardService.getInstance();
  ForwardDTO forwardDTO = null;
  try {
   BoardDTO dto = boardService.getContentByNOForForm(no);
   
   request.setAttribute("dto",dto);
   forwardDTO = new ForwardDTO("/modify_form.jsp",false);
  } catch (SQLException e) {
   e.printStackTrace();
   request.setAttribute("error_message", e.getMessage());
   forwardDTO = new ForwardDTO("/error.jsp",false);
  }
 
  return forwardDTO;
 }

}

package board.model.service;

import java.sql.SQLException;
import java.util.ArrayList;

import board.dto.BoardDTO;
import board.model.dao.BoardDAO;

import board.util.Utilities;

public class BoardService {
 private static BoardService instance = new BoardService();
 private  BoardDAO dao;
 private BoardService(){
  dao = BoardDAO.getInstance();
 }
 public static BoardService getInstance(){
  return instance;
 }
 public void writeContent(BoardDTO bto)throws SQLException{
  /*
   * 1. bto에 property 설정 - no, writedate, content
   *   no - sequence의 값 - dao.selectBoardNO();
   *   writedate - Utilities.getNow();
   *   content를 DB에 넣는 용으로 변경 Utilities.changeContentForDB();
   *   bdto의 refamily에 no 값을 설정
   * 2. dao.insertContent(bto);
   * 3. 날짜 형태를 년.월.일 시:분:초 형태로 변경 - bto의 property 변경
   *   Utilities.changeDayTimeFormat();
   */
  //1
  int no = dao.selectBoardNo();
  String writedate = Utilities.getNow();
  bto.setNo(no);
  bto.setWritedate(writedate);
  bto.setContent(Utilities.changeContentForDB(bto.getContent()));
  bto.setRefamily(no);
  //2
  dao.insertContent(bto);
  //3
  bto.setWritedate(Utilities.changeDayTimeFormat(writedate));
 }
 //글목록
 public ArrayList<BoardDTO> getBoardAllList() throws SQLException{
  //1. dao로 부터 전체 글내용을 ArrayList로 조회
  ArrayList<BoardDTO> list_all = dao.selectBoardAllList();
  //2. list내의 BoardDTO객체들의 wrtiedate를 변경
 
  for(int i=0;i<list_all.size();i++){
   list_all.get(i).setWritedate(Utilities.changeDayFormat(list_all.get(i).getWritedate()));
  }

  return list_all;
 }
 public BoardDTO getContentByNO(int no) throws SQLException{
  
  //1.조회수 증가
  dao.updateViewCount(no);
  //2. no로 글 정보 조회
  BoardDTO bto = dao.selectContentByNO(no);
  //2-1 writedate를 yyy.MM.dd HH:mm:ss 형식으로 변경
  bto.setWritedate(Utilities.changeDayTimeFormat(bto.getWritedate()));
  
  return bto;
 }
 public BoardDTO getContentByNOForForm(int no)throws SQLException{
  //1. no값으로 글 조회
  BoardDTO bto = dao.selectContentByNO(no);
  //2. content를 textarea용으로 변경(DB용으로 바뀌어 있는 것을 HTML용으로 변경)
  bto.setContent(Utilities.changeContentForTextArea(bto.getContent()));
  System.out.println("가져올때-----------\n"+bto.getContent());
  return bto;
 }
 
}

package board.model.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import org.apache.tomcat.dbcp.dbcp.BasicDataSource;

import board.dto.BoardDTO;
import board.util.DBUtil;

public class BoardDAO {
 private static BoardDAO instance = new BoardDAO();
 private DBUtil dbUtil;

 private BoardDAO() {
  dbUtil = DBUtil.getInstance();
 }

 public static BoardDAO getInstance() {
  return instance;
 }

 public int selectBoardNo() throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select board_no_seq.nextval from dual";
  int no = 0;
  try {
   BasicDataSource ds = dbUtil.getDataSource();
   conn = ds.getConnection();
   pstmt = conn.prepareStatement(sql);
   rset = pstmt.executeQuery();
   if (rset.next()) {
    no = rset.getInt(1);
   }
  } finally {
   dbUtil.close(conn, pstmt, rset);
  }
  return no;
 }

 public void insertContent(BoardDTO bto) throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;

  String sql = "insert into board (no, title, writer, content, writedate, viewcount, refamily, restep, relevel)  values(?,?,?,?,?,0,?,?,?)";
  try {
   BasicDataSource ds = dbUtil.getDataSource();
   conn = ds.getConnection();
   pstmt = conn.prepareStatement(sql);
   pstmt.setInt(1, bto.getNo());
   pstmt.setString(2, bto.getTitle());
   pstmt.setString(3, bto.getWriter());
   pstmt.setString(4, bto.getContent());
   pstmt.setString(5, bto.getWritedate());
   //viewcount값은 처음 등록하면 무조건 0이라서 쿼리에서 부터 그냥 값을 넣어줬다
//   pstmt.setInt(6, bto.getViewcount());
   pstmt.setInt(6, bto.getRefamily());
   pstmt.setInt(7, bto.getRestep());
   pstmt.setInt(8, bto.getRelevel());
   int cnt = pstmt.executeUpdate();
   System.out.println(cnt + "개의 행이 삽입되었습니다.");

  } finally {
   dbUtil.close(conn, pstmt);
  }
 }

 public ArrayList<BoardDTO> selectBoardAllList() throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select no, title, writer, content, writedate, viewcount, refamily, restep, relevel from board order by refamily desc, restep asc";
  ArrayList<BoardDTO> list_all = new ArrayList<BoardDTO>();
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  rset = pstmt.executeQuery();
   while(rset.next()){
    list_all.add(new BoardDTO(rset.getInt(1), rset.getString(2), rset.getString(3), rset.getString(4), rset.getString(5), rset.getInt(6), rset.getInt(7), rset.getInt(8), rset.getInt(9)));
   }
  }finally{
   dbUtil.close(conn, pstmt, rset);
  }
  return list_all;
 }

 public BoardDTO selectContentByNO(int no) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select no, title, writer, content, writedate, viewcount, refamily, restep, relevel from board where no=?";
  BoardDTO bto = null;
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, no);
  rset = pstmt.executeQuery();
  if(rset.next()){
   bto = new BoardDTO(rset.getInt(1), rset.getString(2), rset.getString(3), rset.getString(4), rset.getString(5), rset.getInt(6), rset.getInt(7), rset.getInt(8), rset.getInt(9));
  }
  }finally{
   dbUtil.close(conn, pstmt, rset);
  }
  return bto;
 }

 
}

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!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>
</head>
<body>
<h2>글 수정 폼</h2><p>
${requestScope.dto.no }번 글 수정
<form action="/${initParam.context_root }/boardController" method="post">
<input type="hidden" name="no" value="${requestScope.dto.no }">
<input type="hidden" name="viewcount" value="${requestScope.dto.viewcount }">
<input type="hidden" name="command" value="modify_content">
<table width="500px">
 <tr>
  <td width="100px">제목</td><td><input type="text" name="title" size="50" value="${requestScope.dto.title }"></td>
 </tr>
 <tr>
  <td>작성자</td><td><input type="text" name="writer" size="10" maxlength="10" value="${requestScope.dto.writer }"></td>
 </tr>
 <tr>
  <td colspan="2"><textarea cols="50" rows="10" name="content">
${requestScope.dto.content }</textarea></td>
   </tr>
   <tr>
    <td colspan="2" align="center">
     <input type="submit" value="수정">
     <input type="reset" value="초기화">
    </td>
   </tr>
</table>
</form>

</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!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>
</head>
<body>
<h2>글 수정 폼</h2><p>
${requestScope.dto.no }번 글 수정
<form action="/${initParam.context_root }/boardController" method="post">
<input type="hidden" name="no" value="${requestScope.dto.no }">
<input type="hidden" name="viewcount" value="${requestScope.dto.viewcount }">
<input type="hidden" name="command" value="modify_content">
<table width="500px">
 <tr>
  <td width="100px">제목</td><td><input type="text" name="title" size="50" value="${requestScope.dto.title }"></td>
 </tr>
 <tr>
  <td>작성자</td><td><input type="text" name="writer" size="10" maxlength="10" value="${requestScope.dto.writer }"></td>
 </tr>
 <tr>
  <td colspan="2"><textarea cols="50" rows="10" name="content">
${requestScope.dto.content }</textarea></td>
   </tr>
   <tr>
    <td colspan="2" align="center">
     <input type="submit" value="수정">
     <input type="reset" value="초기화">
    </td>
   </tr>
</table>
</form>

</body>
</html>

package board.controller;

import java.io.IOException;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import board.dto.ForwardDTO;

public class BoardFrontController extends HttpServlet {
 private static final long serialVersionUID = 1L;

    public BoardFrontController() {
        super();
    
    }

 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  doPost(request, response);
 }

 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  //1. 공통 사전 작업 - 한글처리
  request.setCharacterEncoding("utf-8");
  //2. Controller 로직 처리 - Controller객체.execute()호출
  String command = request.getParameter("command");
  Controller ctr = ControllerCommandMapping.getController(command);
  ForwardDTO fdto = ctr.execute(request, response);
  //3. 공통 사후 작업
  if(fdto.isRedirect()){
   response.sendRedirect(fdto.getUrl());
  }else{
   RequestDispatcher rdp = request.getRequestDispatcher(fdto.getUrl());
   rdp.forward(request, response);
  }
 }

}

package board.controller;

public class ControllerCommandMapping {

 public static Controller getController(String command){
  Controller ctr = null;
  if(command.equals("write_content")){
   ctr = new WriteContentController();
  }else if(command.equals("list_all")){
   ctr = new BoardAllListController();
  }else if(command.equals("get_content")){
   ctr = new GetContentController();
  }else if(command.equals("modify_form")){
   ctr = new ModifyFormController();
  }else if(command.equals("modify_content")){
   ctr = new ModifyContentController();
  }
  return ctr;
 }

}

package board.controller;

import java.io.IOException;
 

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import board.dto.BoardDTO;
import board.dto.ForwardDTO;
import board.model.service.BoardService;

public class ModifyContentController implements Controller {
 ForwardDTO forwardDTO = null;
 @Override
 public ForwardDTO execute(HttpServletRequest request,
   HttpServletResponse response) throws ServletException, IOException {
  //요청파라미터 조회
  try {
   int no = Integer.parseInt(request.getParameter("no"));
   String title = request.getParameter("title");
   String writer = request.getParameter("writer");
   String content = request.getParameter("content");
   int viewcount = Integer.parseInt(request.getParameter("viewcount"));
   //2.비지니스 로직 처리
   BoardService boardService = BoardService.getInstance();
   
   BoardDTO dto = new BoardDTO(no,title, writer, content,null,viewcount);
  
   boardService.modifyContent(dto);
   
   request.setAttribute("board",dto);
   forwardDTO = new ForwardDTO("/show_content.jsp",false);
  } catch (Exception e) {
   e.printStackTrace();
   request.setAttribute("error_message", e.getMessage());
   forwardDTO = new ForwardDTO("/error.jsp",false);
  }
 
  return forwardDTO;
 }

}

package board.model.service;

import java.sql.SQLException;
import java.util.ArrayList;

import board.dto.BoardDTO;
import board.model.dao.BoardDAO;

import board.util.Utilities;

public class BoardService {
 private static BoardService instance = new BoardService();
 private  BoardDAO dao;
 private BoardService(){
  dao = BoardDAO.getInstance();
 }
 public static BoardService getInstance(){
  return instance;
 }
 public void writeContent(BoardDTO bto)throws SQLException{
  /*
   * 1. bto에 property 설정 - no, writedate, content
   *   no - sequence의 값 - dao.selectBoardNO();
   *   writedate - Utilities.getNow();
   *   content를 DB에 넣는 용으로 변경 Utilities.changeContentForDB();
   *   bdto의 refamily에 no 값을 설정
   * 2. dao.insertContent(bto);
   * 3. 날짜 형태를 년.월.일 시:분:초 형태로 변경 - bto의 property 변경
   *   Utilities.changeDayTimeFormat();
   */
  //1
  int no = dao.selectBoardNo();
  String writedate = Utilities.getNow();
  bto.setNo(no);
  bto.setWritedate(writedate);
  bto.setContent(Utilities.changeContentForDB(bto.getContent()));
  bto.setRefamily(no);
  //2
  dao.insertContent(bto);
  //3
  bto.setWritedate(Utilities.changeDayTimeFormat(writedate));
 }
 //글목록
 public ArrayList<BoardDTO> getBoardAllList() throws SQLException{
  //1. dao로 부터 전체 글내용을 ArrayList로 조회
  ArrayList<BoardDTO> list_all = dao.selectBoardAllList();
  //2. list내의 BoardDTO객체들의 wrtiedate를 변경
 
  for(int i=0;i<list_all.size();i++){
   list_all.get(i).setWritedate(Utilities.changeDayFormat(list_all.get(i).getWritedate()));
  }

  return list_all;
 }
 public BoardDTO getContentByNO(int no) throws SQLException{
  
  //1.조회수 증가
  dao.updateViewCount(no);
  //2. no로 글 정보 조회
  BoardDTO bto = dao.selectContentByNO(no);
  //2-1 writedate를 yyy.MM.dd HH:mm:ss 형식으로 변경
  bto.setWritedate(Utilities.changeDayTimeFormat(bto.getWritedate()));
  
  return bto;
 }
 public BoardDTO getContentByNOForForm(int no)throws SQLException{
  //1. no값으로 글 조회
  BoardDTO bto = dao.selectContentByNO(no);
  //2. content를 textarea용으로 변경(DB용으로 바뀌어 있는 것을 HTML용으로 변경)
  bto.setContent(Utilities.changeContentForTextArea(bto.getContent()));
  System.out.println("가져올때-----------\n"+bto.getContent());
  return bto;
 }
 public void modifyContent(BoardDTO bto)throws SQLException {
  //1. property변경 - content, writedate
  bto.setWritedate(Utilities.getNow());
  bto.setContent(Utilities.changeContentForDB(bto.getContent()));
  //2. 수정처리
  dao.updateContent(bto);
  //3. 날짜 포멧 변경
  bto.setWritedate(Utilities.changeDayTimeFormat(Utilities.getNow()));
 
  
 }
 
}

package board.model.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import org.apache.tomcat.dbcp.dbcp.BasicDataSource;

import board.dto.BoardDTO;
import board.util.DBUtil;

public class BoardDAO {
 private static BoardDAO instance = new BoardDAO();
 private DBUtil dbUtil;

 private BoardDAO() {
  dbUtil = DBUtil.getInstance();
 }

 public static BoardDAO getInstance() {
  return instance;
 }

 public int selectBoardNo() throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select board_no_seq.nextval from dual";
  int no = 0;
  try {
   BasicDataSource ds = dbUtil.getDataSource();
   conn = ds.getConnection();
   pstmt = conn.prepareStatement(sql);
   rset = pstmt.executeQuery();
   if (rset.next()) {
    no = rset.getInt(1);
   }
  } finally {
   dbUtil.close(conn, pstmt, rset);
  }
  return no;
 }

 public void insertContent(BoardDTO bto) throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;

  String sql = "insert into board (no, title, writer, content, writedate, viewcount, refamily, restep, relevel)  values(?,?,?,?,?,0,?,?,?)";
  try {
   BasicDataSource ds = dbUtil.getDataSource();
   conn = ds.getConnection();
   pstmt = conn.prepareStatement(sql);
   pstmt.setInt(1, bto.getNo());
   pstmt.setString(2, bto.getTitle());
   pstmt.setString(3, bto.getWriter());
   pstmt.setString(4, bto.getContent());
   pstmt.setString(5, bto.getWritedate());
   //viewcount값은 처음 등록하면 무조건 0이라서 쿼리에서 부터 그냥 값을 넣어줬다
//   pstmt.setInt(6, bto.getViewcount());
   pstmt.setInt(6, bto.getRefamily());
   pstmt.setInt(7, bto.getRestep());
   pstmt.setInt(8, bto.getRelevel());
   int cnt = pstmt.executeUpdate();
   System.out.println(cnt + "개의 행이 삽입되었습니다.");

  } finally {
   dbUtil.close(conn, pstmt);
  }
 }

 public ArrayList<BoardDTO> selectBoardAllList() throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select no, title, writer, content, writedate, viewcount, refamily, restep, relevel from board order by refamily desc, restep asc";
  ArrayList<BoardDTO> list_all = new ArrayList<BoardDTO>();
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  rset = pstmt.executeQuery();
   while(rset.next()){
    list_all.add(new BoardDTO(rset.getInt(1), rset.getString(2), rset.getString(3), rset.getString(4), rset.getString(5), rset.getInt(6), rset.getInt(7), rset.getInt(8), rset.getInt(9)));
   }
  }finally{
   dbUtil.close(conn, pstmt, rset);
  }
  return list_all;
 }

 public BoardDTO selectContentByNO(int no) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select no, title, writer, content, writedate, viewcount, refamily, restep, relevel from board where no=?";
  BoardDTO bto = null;
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, no);
  rset = pstmt.executeQuery();
  if(rset.next()){
   bto = new BoardDTO(rset.getInt(1), rset.getString(2), rset.getString(3), rset.getString(4), rset.getString(5), rset.getInt(6), rset.getInt(7), rset.getInt(8), rset.getInt(9));
  }
  }finally{
   dbUtil.close(conn, pstmt, rset);
  }
  return bto;
 }

 public void updateViewCount(int no) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  String sql = "update board set viewcount=viewcount+1 where no=?";
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, no);
  int cnt = pstmt.executeUpdate();
  System.out.println(cnt+"개의 행이 수정되었습니다.");
  }finally{
   dbUtil.close(conn, pstmt);
  }
 }

 public void updateContent(BoardDTO dto) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  String sql = "update board set title=?, writer=?, content=?, writedate=? where no=?";
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setString(1, dto.getTitle());
  pstmt.setString(2, dto.getWriter());
  pstmt.setString(3, dto.getContent());
  pstmt.setString(4, dto.getWritedate());
  pstmt.setInt(5, dto.getNo());
  int cnt = pstmt.executeUpdate();
  System.out.println(cnt+"개의 행이 수정되었습니다.");
  }finally{
   dbUtil.close(conn, pstmt);
  }
  
 }

}

<%@page import="board.dto.BoardDTO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
 pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!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>
<style type="text/css">
div{
 width:600px;
 border:1px solid gray;
 padding : 5px;
}
#title{
 font-weight: bold;
 background-color: yellow;
}
#info{
 font-size:13px;
}
#content{
 min-height:300px;
 height:auto;
}
</style>
</head>
<body>
 <h1>글목록</h1>
 <p>
<div id="title">${requestScope.board.no}.${requestScope.board.title }</div>
<div id="info">작성자 : ${requestScope.board.writer } | 조회수 : ${requestScope.board.viewcount } 작성일시 : ${requestScope.board.writedate }</div>
<div id="content">${requestScope.board.content }</div>
 <p>
  <a href="/${initParam.context_root }/write_form.jsp">글쓰기</a>
  <a href="/${initParam.context_root }/boardController?command=list_all">전체 글목록</a>
  <a href="">글목록(페이징)</a>
  <a href="/${initParam.context_root }/boardController?command=modify_form&no=${requestScope.board.no}">글수정</a>
  <a href="/${initParam.context_root }/boardController?command=delete_content&no=${requestScope.board.no}">글삭제</a>
  <a href="/${initParam.context_root }/boardController?command=reply_form&no=${requestScope.board.no}">답변</a>
</body>
</html>

 <%@page import="board.dto.BoardDTO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
 pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!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>
<style type="text/css">
div{
 width:600px;
 border:1px solid gray;
 padding : 5px;
}
#title{
 font-weight: bold;
 background-color: yellow;
}
#info{
 font-size:13px;
}
#content{
 min-height:300px;
 height:auto;
}
</style>
</head>
<body>
 <h1>글목록</h1>
 <p>
<div id="title">${requestScope.board.no}.${requestScope.board.title }</div>
<div id="info">작성자 : ${requestScope.board.writer } | 조회수 : ${requestScope.board.viewcount } 작성일시 : ${requestScope.board.writedate }</div>
<div id="content">${requestScope.board.content }</div>
 <p>
  <a href="/${initParam.context_root }/write_form.jsp">글쓰기</a>
  <a href="/${initParam.context_root }/boardController?command=list_all">전체 글목록</a>
  <a href="">글목록(페이징)</a>
  <a href="/${initParam.context_root }/boardController?command=modify_form&no=${requestScope.board.no}">글수정</a>
  <a href="/${initParam.context_root }/boardController?command=delete_content&no=${requestScope.board.no}">글삭제</a>
  <a href="">글답변</a>
</body>
</html>

 package board.controller;

import java.io.IOException;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import board.dto.ForwardDTO;

public class BoardFrontController extends HttpServlet {
 private static final long serialVersionUID = 1L;

    public BoardFrontController() {
        super();
    
    }

 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  doPost(request, response);
 }

 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  //1. 공통 사전 작업 - 한글처리
  request.setCharacterEncoding("utf-8");
  //2. Controller 로직 처리 - Controller객체.execute()호출
  String command = request.getParameter("command");
  Controller ctr = ControllerCommandMapping.getController(command);
  ForwardDTO fdto = ctr.execute(request, response);
  //3. 공통 사후 작업
  if(fdto.isRedirect()){
   response.sendRedirect(fdto.getUrl());
  }else{
   RequestDispatcher rdp = request.getRequestDispatcher(fdto.getUrl());
   rdp.forward(request, response);
  }
 }

}

 package board.controller;

public class ControllerCommandMapping {

 public static Controller getController(String command){
  Controller ctr = null;
  if(command.equals("write_content")){
   ctr = new WriteContentController();
  }else if(command.equals("list_all")){
   ctr = new BoardAllListController();
  }else if(command.equals("get_content")){
   ctr = new GetContentController();
  }else if(command.equals("modify_form")){
   ctr = new ModifyFormController();
  }else if(command.equals("modify_content")){
   ctr = new ModifyContentController();
  }else if(command.equals("delete_content")){
   ctr = new DeleteContentController();
  }
  return ctr;
 }

}

 package board.controller;

import java.io.IOException;
 

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import board.dto.ForwardDTO;
import board.model.service.BoardService;

public class DeleteContentController implements Controller {

 @Override
 public ForwardDTO execute(HttpServletRequest request,
   HttpServletResponse response) throws ServletException, IOException {
  ForwardDTO forwardDTO = null;
  try {
  int no = Integer.parseInt(request.getParameter("no"));
  BoardService boardService = BoardService.getInstance();
  
  
   boardService.deleteContentByNO(no);
   
  
   forwardDTO = new ForwardDTO("/boardController?command=list_all",false);
  } catch (Exception e) {
   e.printStackTrace();
   request.setAttribute("error_message", e.getMessage());
   forwardDTO = new ForwardDTO("/error.jsp",false);
  }
 
  return forwardDTO;
 }

}

 package board.model.service;

import java.sql.SQLException;
import java.util.ArrayList;

import board.dto.BoardDTO;
import board.model.dao.BoardDAO;

import board.util.Utilities;

public class BoardService {
 private static BoardService instance = new BoardService();
 private  BoardDAO dao;
 private BoardService(){
  dao = BoardDAO.getInstance();
 }
 public static BoardService getInstance(){
  return instance;
 }
 public void writeContent(BoardDTO bto)throws SQLException{
  /*
   * 1. bto에 property 설정 - no, writedate, content
   *   no - sequence의 값 - dao.selectBoardNO();
   *   writedate - Utilities.getNow();
   *   content를 DB에 넣는 용으로 변경 Utilities.changeContentForDB();
   *   bdto의 refamily에 no 값을 설정
   * 2. dao.insertContent(bto);
   * 3. 날짜 형태를 년.월.일 시:분:초 형태로 변경 - bto의 property 변경
   *   Utilities.changeDayTimeFormat();
   */
  //1
  int no = dao.selectBoardNo();
  String writedate = Utilities.getNow();
  bto.setNo(no);
  bto.setWritedate(writedate);
  bto.setContent(Utilities.changeContentForDB(bto.getContent()));
  bto.setRefamily(no);
  //2
  dao.insertContent(bto);
  //3
  bto.setWritedate(Utilities.changeDayTimeFormat(writedate));
 }
 //글목록
 public ArrayList<BoardDTO> getBoardAllList() throws SQLException{
  //1. dao로 부터 전체 글내용을 ArrayList로 조회
  ArrayList<BoardDTO> list_all = dao.selectBoardAllList();
  //2. list내의 BoardDTO객체들의 wrtiedate를 변경
  for(int i=0;i<list_all.size();i++){
   list_all.get(i).setWritedate(Utilities.changeDayFormat(list_all.get(i).getWritedate()));
  }
  return list_all;
 }
 public BoardDTO getContentByNO(int no) throws SQLException{
  
  //1.조회수 증가
  dao.updateViewCount(no);
  //2. no로 글 정보 조회
  BoardDTO bto = dao.selectContentByNO(no);
  //2-1 writedate를 yyy.MM.dd HH:mm:ss 형식으로 변경
  bto.setWritedate(Utilities.changeDayTimeFormat(bto.getWritedate()));
  
  return bto;
 }
 public BoardDTO getContentByNOForForm(int no)throws SQLException{
  //1. no값으로 글 조회
  BoardDTO bto = dao.selectContentByNO(no);
  //2. content를 textarea용으로 변경(DB용으로 바뀌어 있는 것을 HTML용으로 변경)
  bto.setContent(Utilities.changeContentForTextArea(bto.getContent()));
  System.out.println("가져올때-----------\n"+bto.getContent());
  return bto;
 }
 public void modifyContent(BoardDTO bto)throws SQLException {
  //1. property변경 - content, writedate
  bto.setWritedate(Utilities.getNow());
  bto.setContent(Utilities.changeContentForDB(bto.getContent()));
  //2. 수정처리
  dao.updateContent(bto);
  //3. 날짜 포멧 변경
  bto.setWritedate(Utilities.changeDayTimeFormat(Utilities.getNow()));
 
  
 }
 
 public void deleteContentByNO(int no)throws SQLException{
  dao.deleteContentByNO(no);
  
 }
}

 package board.model.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import org.apache.tomcat.dbcp.dbcp.BasicDataSource;

import board.dto.BoardDTO;
import board.util.DBUtil;

public class BoardDAO {
 private static BoardDAO instance = new BoardDAO();
 private DBUtil dbUtil;

 private BoardDAO() {
  dbUtil = DBUtil.getInstance();
 }

 public static BoardDAO getInstance() {
  return instance;
 }

 public int selectBoardNo() throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select board_no_seq.nextval from dual";
  int no = 0;
  try {
   BasicDataSource ds = dbUtil.getDataSource();
   conn = ds.getConnection();
   pstmt = conn.prepareStatement(sql);
   rset = pstmt.executeQuery();
   if (rset.next()) {
    no = rset.getInt(1);
   }
  } finally {
   dbUtil.close(conn, pstmt, rset);
  }
  return no;
 }

 public void insertContent(BoardDTO bto) throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;

  String sql = "insert into board (no, title, writer, content, writedate, viewcount, refamily, restep, relevel)  values(?,?,?,?,?,0,?,?,?)";
  try {
   BasicDataSource ds = dbUtil.getDataSource();
   conn = ds.getConnection();
   pstmt = conn.prepareStatement(sql);
   pstmt.setInt(1, bto.getNo());
   pstmt.setString(2, bto.getTitle());
   pstmt.setString(3, bto.getWriter());
   pstmt.setString(4, bto.getContent());
   pstmt.setString(5, bto.getWritedate());
   //viewcount값은 처음 등록하면 무조건 0이라서 쿼리에서 부터 그냥 값을 넣어줬다
//   pstmt.setInt(6, bto.getViewcount());
   pstmt.setInt(6, bto.getRefamily());
   pstmt.setInt(7, bto.getRestep());
   pstmt.setInt(8, bto.getRelevel());
   int cnt = pstmt.executeUpdate();
   System.out.println(cnt + "개의 행이 삽입되었습니다.");

  } finally {
   dbUtil.close(conn, pstmt);
  }
 }

 public ArrayList<BoardDTO> selectBoardAllList() throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select no, title, writer, content, writedate, viewcount, refamily, restep, relevel from board order by refamily desc";
  ArrayList<BoardDTO> list_all = new ArrayList<BoardDTO>();
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  rset = pstmt.executeQuery();
   while(rset.next()){
    list_all.add(new BoardDTO(rset.getInt(1), rset.getString(2), rset.getString(3), rset.getString(4), rset.getString(5), rset.getInt(6), rset.getInt(7), rset.getInt(8), rset.getInt(9)));
   }
  }finally{
   dbUtil.close(conn, pstmt, rset);
  }
  return list_all;
 }

 public BoardDTO selectContentByNO(int no) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select no, title, writer, content, writedate, viewcount, refamily, restep, relevel from board where no=?";
  BoardDTO bto = null;
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, no);
  rset = pstmt.executeQuery();
  if(rset.next()){
   bto = new BoardDTO(rset.getInt(1), rset.getString(2), rset.getString(3), rset.getString(4), rset.getString(5), rset.getInt(6), rset.getInt(7), rset.getInt(8), rset.getInt(9));
  }
  }finally{
   dbUtil.close(conn, pstmt, rset);
  }
  return bto;
 }

 public void updateViewCount(int no) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  String sql = "update board set viewcount=viewcount+1 where no=?";
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, no);
  int cnt = pstmt.executeUpdate();
  System.out.println(cnt+"개의 행이 수정되었습니다.");
  }finally{
   dbUtil.close(conn, pstmt);
  }
 }

 public void updateContent(BoardDTO dto) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  String sql = "update board set title=?, writer=?, content=?, writedate=? where no=?";
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setString(1, dto.getTitle());
  pstmt.setString(2, dto.getWriter());
  pstmt.setString(3, dto.getContent());
  pstmt.setString(4, dto.getWritedate());
  pstmt.setInt(5, dto.getNo());
  int cnt = pstmt.executeUpdate();
  System.out.println(cnt+"개의 행이 수정되었습니다.");
  }finally{
   dbUtil.close(conn, pstmt);
  }
  
 }

 public void deleteContentByNO(int no) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  String sql = "delete from board where no=?";
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, no);
  int cnt = pstmt.executeUpdate();
  System.out.println(cnt+"개의 행이 삭제되었습니다.");
  }finally{
   dbUtil.close(conn, pstmt);
  }
  
 }
}

 package board.controller;

import java.io.IOException;
import java.sql.SQLException;
import java.util.ArrayList;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import board.dto.BoardDTO;
import board.dto.ForwardDTO;
import board.model.service.BoardService;

public class BoardAllListController implements Controller {

 @Override
 public ForwardDTO execute(HttpServletRequest request,
   HttpServletResponse response) throws ServletException, IOException {
  //1. 비지니스 로직 - Model(Business Service)로 요청
  BoardService boardService = BoardService.getInstance();
  ForwardDTO forwardDTO = null;
  try {
   ArrayList<BoardDTO> list_all = boardService.getBoardAllList();
   
   request.setAttribute("list_all",list_all);
   forwardDTO = new ForwardDTO("/list_all.jsp",false);
  } catch (SQLException e) {
   e.printStackTrace();
   request.setAttribute("error_message", e.getMessage());
   forwardDTO = new ForwardDTO("/error.jsp",false);
  }
 
  return forwardDTO;
 
 }

}

<%@page import="board.dto.BoardDTO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
 pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!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>
<style type="text/css">
div{
 width:600px;
 border:1px solid gray;
 padding : 5px;
}
#title{
 font-weight: bold;
 background-color: yellow;
}
#info{
 font-size:13px;
}
#content{
 min-height:300px;
 height:auto;
}
</style>
</head>
<body>
 <h1>글목록</h1>
 <p>
<div id="title">${requestScope.board.no}.${requestScope.board.title }</div>
<div id="info">작성자 : ${requestScope.board.writer } | 조회수 : ${requestScope.board.viewcount } 작성일시 : ${requestScope.board.writedate }</div>
<div id="content">${requestScope.board.content }</div>
 <p>
  <a href="/${initParam.context_root }/write_form.jsp">글쓰기</a>
  <a href="/${initParam.context_root }/boardController?command=list_all">전체 글목록</a>
  <a href="">글목록(페이징)</a>
  <a href="/${initParam.context_root }/boardController?command=modify_form&no=${requestScope.board.no}">글수정</a>
  <a href="/${initParam.context_root }/boardController?command=delete_content&no=${requestScope.board.no}">글삭제</a>
  <a href="/${initParam.context_root }/boardController?command=reply_form&no=${requestScope.board.no}">답변</a>
</body>
</html>

 package board.controller;

import java.io.IOException;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import board.dto.ForwardDTO;

public class BoardFrontController extends HttpServlet {
 private static final long serialVersionUID = 1L;

    public BoardFrontController() {
        super();
    
    }

 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  doPost(request, response);
 }

 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  //1. 공통 사전 작업 - 한글처리
  request.setCharacterEncoding("utf-8");
  //2. Controller 로직 처리 - Controller객체.execute()호출
  String command = request.getParameter("command");
  Controller ctr = ControllerCommandMapping.getController(command);
  ForwardDTO fdto = ctr.execute(request, response);
  //3. 공통 사후 작업
  if(fdto.isRedirect()){
   response.sendRedirect(fdto.getUrl());
  }else{
   RequestDispatcher rdp = request.getRequestDispatcher(fdto.getUrl());
   rdp.forward(request, response);
  }
 }

}

package board.controller;

public class ControllerCommandMapping {

 public static Controller getController(String command){
  Controller ctr = null;
  if(command.equals("write_content")){
   ctr = new WriteContentController();
  }else if(command.equals("list_all")){
   ctr = new BoardAllListController();
  }else if(command.equals("get_content")){
   ctr = new GetContentController();
  }else if(command.equals("modify_form")){
   ctr = new ModifyFormController();
  }else if(command.equals("modify_content")){
   ctr = new ModifyContentController();
  }else if(command.equals("delete_content")){
   ctr = new DeleteContentController();
  }else if(command.equals("reply_form")){
   ctr = new ReplyFormController();
  }
  return ctr;
 }

}

package board.controller;

import java.io.IOException;
 

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import board.dto.BoardDTO;
import board.dto.ForwardDTO;
import board.model.service.BoardService;

public class ReplyFormController implements Controller {

 @Override
 public ForwardDTO execute(HttpServletRequest request,
   HttpServletResponse response) throws ServletException, IOException {
  ForwardDTO forwardDTO = null;
  
  try {
  int no = Integer.parseInt(request.getParameter("no"));
  BoardService boardService = BoardService.getInstance();
 
   BoardDTO dto = boardService.getContentByNOForForm(no);

   request.setAttribute("dto",dto);
   forwardDTO = new ForwardDTO("/reply_form.jsp",false);
  } catch (Exception e) {
   e.printStackTrace();
   request.setAttribute("error_message", e.getMessage());
   forwardDTO = new ForwardDTO("/error.jsp",false);
  }
 
  return forwardDTO;
 }

}

package board.model.service;

import java.sql.SQLException;
import java.util.ArrayList;

import board.dto.BoardDTO;
import board.model.dao.BoardDAO;

import board.util.Utilities;

public class BoardService {
 private static BoardService instance = new BoardService();
 private  BoardDAO dao;
 private BoardService(){
  dao = BoardDAO.getInstance();
 }
 public static BoardService getInstance(){
  return instance;
 }
 public void writeContent(BoardDTO bto)throws SQLException{
  /*
   * 1. bto에 property 설정 - no, writedate, content
   *   no - sequence의 값 - dao.selectBoardNO();
   *   writedate - Utilities.getNow();
   *   content를 DB에 넣는 용으로 변경 Utilities.changeContentForDB();
   *   bdto의 refamily에 no 값을 설정
   * 2. dao.insertContent(bto);
   * 3. 날짜 형태를 년.월.일 시:분:초 형태로 변경 - bto의 property 변경
   *   Utilities.changeDayTimeFormat();
   */
  //1
  int no = dao.selectBoardNo();
  String writedate = Utilities.getNow();
  bto.setNo(no);
  bto.setWritedate(writedate);
  bto.setContent(Utilities.changeContentForDB(bto.getContent()));
  bto.setRefamily(no);
  //2
  dao.insertContent(bto);
  //3
  bto.setWritedate(Utilities.changeDayTimeFormat(writedate));
 }
 //글목록
 public ArrayList<BoardDTO> getBoardAllList() throws SQLException{
  //1. dao로 부터 전체 글내용을 ArrayList로 조회
  ArrayList<BoardDTO> list_all = dao.selectBoardAllList();
  //2. list내의 BoardDTO객체들의 wrtiedate를 변경
 
  for(int i=0;i<list_all.size();i++){
   list_all.get(i).setWritedate(Utilities.changeDayFormat(list_all.get(i).getWritedate()));
  }

  return list_all;
 }
 public BoardDTO getContentByNO(int no) throws SQLException{
  
  //1.조회수 증가
  dao.updateViewCount(no);
  //2. no로 글 정보 조회
  BoardDTO bto = dao.selectContentByNO(no);
  //2-1 writedate를 yyy.MM.dd HH:mm:ss 형식으로 변경
  bto.setWritedate(Utilities.changeDayTimeFormat(bto.getWritedate()));
  
  return bto;
 }
 public BoardDTO getContentByNOForForm(int no)throws SQLException{
  //1. no값으로 글 조회
  BoardDTO bto = dao.selectContentByNO(no);
  //2. content를 textarea용으로 변경(DB용으로 바뀌어 있는 것을 HTML용으로 변경)
  bto.setContent(Utilities.changeContentForTextArea(bto.getContent()));
  System.out.println("가져올때-----------\n"+bto.getContent());
  return bto;
 }
 public void modifyContent(BoardDTO bto)throws SQLException {
  //1. property변경 - content, writedate
  bto.setWritedate(Utilities.getNow());
  bto.setContent(Utilities.changeContentForDB(bto.getContent()));
  //2. 수정처리
  dao.updateContent(bto);
  //3. 날짜 포멧 변경
  bto.setWritedate(Utilities.changeDayTimeFormat(Utilities.getNow()));
 
  
 }
 
 public void deleteContentByNO(int no)throws SQLException{
  dao.deleteContentByNO(no);
  
 }
 }

package board.model.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import org.apache.tomcat.dbcp.dbcp.BasicDataSource;

import board.dto.BoardDTO;
import board.util.DBUtil;

public class BoardDAO {
 private static BoardDAO instance = new BoardDAO();
 private DBUtil dbUtil;

 private BoardDAO() {
  dbUtil = DBUtil.getInstance();
 }

 public static BoardDAO getInstance() {
  return instance;
 }

 public int selectBoardNo() throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select board_no_seq.nextval from dual";
  int no = 0;
  try {
   BasicDataSource ds = dbUtil.getDataSource();
   conn = ds.getConnection();
   pstmt = conn.prepareStatement(sql);
   rset = pstmt.executeQuery();
   if (rset.next()) {
    no = rset.getInt(1);
   }
  } finally {
   dbUtil.close(conn, pstmt, rset);
  }
  return no;
 }

 public void insertContent(BoardDTO bto) throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;

  String sql = "insert into board (no, title, writer, content, writedate, viewcount, refamily, restep, relevel)  values(?,?,?,?,?,0,?,?,?)";
  try {
   BasicDataSource ds = dbUtil.getDataSource();
   conn = ds.getConnection();
   pstmt = conn.prepareStatement(sql);
   pstmt.setInt(1, bto.getNo());
   pstmt.setString(2, bto.getTitle());
   pstmt.setString(3, bto.getWriter());
   pstmt.setString(4, bto.getContent());
   pstmt.setString(5, bto.getWritedate());
   //viewcount값은 처음 등록하면 무조건 0이라서 쿼리에서 부터 그냥 값을 넣어줬다
//   pstmt.setInt(6, bto.getViewcount());
   pstmt.setInt(6, bto.getRefamily());
   pstmt.setInt(7, bto.getRestep());
   pstmt.setInt(8, bto.getRelevel());
   int cnt = pstmt.executeUpdate();
   System.out.println(cnt + "개의 행이 삽입되었습니다.");

  } finally {
   dbUtil.close(conn, pstmt);
  }
 }

 public ArrayList<BoardDTO> selectBoardAllList() throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select no, title, writer, content, writedate, viewcount, refamily, restep, relevel from board order by refamily desc, restep asc";
  ArrayList<BoardDTO> list_all = new ArrayList<BoardDTO>();
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  rset = pstmt.executeQuery();
   while(rset.next()){
    list_all.add(new BoardDTO(rset.getInt(1), rset.getString(2), rset.getString(3), rset.getString(4), rset.getString(5), rset.getInt(6), rset.getInt(7), rset.getInt(8), rset.getInt(9)));
   }
  }finally{
   dbUtil.close(conn, pstmt, rset);
  }
  return list_all;
 }

 public BoardDTO selectContentByNO(int no) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select no, title, writer, content, writedate, viewcount, refamily, restep, relevel from board where no=?";
  BoardDTO bto = null;
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, no);
  rset = pstmt.executeQuery();
  if(rset.next()){
   bto = new BoardDTO(rset.getInt(1), rset.getString(2), rset.getString(3), rset.getString(4), rset.getString(5), rset.getInt(6), rset.getInt(7), rset.getInt(8), rset.getInt(9));
  }
  }finally{
   dbUtil.close(conn, pstmt, rset);
  }
  return bto;
 }

 public void updateViewCount(int no) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  String sql = "update board set viewcount=viewcount+1 where no=?";
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, no);
  int cnt = pstmt.executeUpdate();
  System.out.println(cnt+"개의 행이 수정되었습니다.");
  }finally{
   dbUtil.close(conn, pstmt);
  }
 }

 public void updateContent(BoardDTO dto) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  String sql = "update board set title=?, writer=?, content=?, writedate=? where no=?";
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setString(1, dto.getTitle());
  pstmt.setString(2, dto.getWriter());
  pstmt.setString(3, dto.getContent());
  pstmt.setString(4, dto.getWritedate());
  pstmt.setInt(5, dto.getNo());
  int cnt = pstmt.executeUpdate();
  System.out.println(cnt+"개의 행이 수정되었습니다.");
  }finally{
   dbUtil.close(conn, pstmt);
  }
  
 }

 public void deleteContentByNO(int no) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  String sql = "delete from board where no=?";
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, no);
  int cnt = pstmt.executeUpdate();
  System.out.println(cnt+"개의 행이 삭제되었습니다.");
  }finally{
   dbUtil.close(conn, pstmt);
  }
  
 }

 public void updateRestep(int refamily, int restep) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  String sql = "update board set restep=restep+1 where refamily=? and restep>?";
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, refamily);
  pstmt.setInt(2, restep);
  
  int cnt = pstmt.executeUpdate();
  System.out.println(cnt+"개의 행이 수정되었습니다.");
  }finally{
   dbUtil.close(conn, pstmt);
  }
  
 }
}

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!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>
</head>
<body>
<h2>글 답변 폼</h2><p>
${requestScope.dto.no }번 답변글
<form action="/${initParam.context_root }/boardController" method="post">
<input type="hidden" name="refamily" value="${requestScope.dto.refamily }">
<input type="hidden" name="restep" value="${requestScope.dto.restep }">
<input type="hidden" name="relevel" value="${requestScope.dto.relevel }">
<input type="hidden" name="command" value="reply_content">
<table width="500px">
 <tr>
  <td width="100px">제목</td><td><input type="text" name="title" size="50" value="RE : ${requestScope.dto.title }"></td>
 </tr>
 <tr>
  <td>작성자</td><td><input type="text" name="writer" size="10" maxlength="10" value="${requestScope.dto.writer }"></td>
 </tr>
 <tr>
  <td colspan="2"><textarea cols="50" rows="10" name="content">
${requestScope.dto.content }
----------------답변-----------------
</textarea>
</td>
   </tr>
   <tr>
    <td colspan="2" align="center">
     <input type="submit" value="답변">
     <input type="reset" value="초기화">
    </td>
   </tr>
</table>
</form>

</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!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>
</head>
<body>
<h2>글 답변 폼</h2><p>
${requestScope.dto.no }번 답변글
<form action="/${initParam.context_root }/boardController" method="post">
<input type="hidden" name="refamily" value="${requestScope.dto.refamily }">
<input type="hidden" name="restep" value="${requestScope.dto.restep }">
<input type="hidden" name="relevel" value="${requestScope.dto.relevel }">
<input type="hidden" name="command" value="reply_content">
<table width="500px">
 <tr>
  <td width="100px">제목</td><td><input type="text" name="title" size="50" value="RE : ${requestScope.dto.title }"></td>
 </tr>
 <tr>
  <td>작성자</td><td><input type="text" name="writer" size="10" maxlength="10" value="${requestScope.dto.writer }"></td>
 </tr>
 <tr>
  <td colspan="2"><textarea cols="50" rows="10" name="content">
${requestScope.dto.content }
----------------답변-----------------
</textarea>
</td>
   </tr>
   <tr>
    <td colspan="2" align="center">
     <input type="submit" value="답변">
     <input type="reset" value="초기화">
    </td>
   </tr>
</table>
</form>

</body>
</html>

package board.controller;

import java.io.IOException;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import board.dto.ForwardDTO;

public class BoardFrontController extends HttpServlet {
 private static final long serialVersionUID = 1L;

    public BoardFrontController() {
        super();
    
    }

 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  doPost(request, response);
 }

 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  //1. 공통 사전 작업 - 한글처리
  request.setCharacterEncoding("utf-8");
  //2. Controller 로직 처리 - Controller객체.execute()호출
  String command = request.getParameter("command");
  Controller ctr = ControllerCommandMapping.getController(command);
  ForwardDTO fdto = ctr.execute(request, response);
  //3. 공통 사후 작업
  if(fdto.isRedirect()){
   response.sendRedirect(fdto.getUrl());
  }else{
   RequestDispatcher rdp = request.getRequestDispatcher(fdto.getUrl());
   rdp.forward(request, response);
  }
 }

}

package board.controller;

public class ControllerCommandMapping {

 public static Controller getController(String command){
  Controller ctr = null;
  if(command.equals("write_content")){
   ctr = new WriteContentController();
  }else if(command.equals("list_all")){
   ctr = new BoardAllListController();
  }else if(command.equals("get_content")){
   ctr = new GetContentController();
  }else if(command.equals("modify_form")){
   ctr = new ModifyFormController();
  }else if(command.equals("modify_content")){
   ctr = new ModifyContentController();
  }else if(command.equals("delete_content")){
   ctr = new DeleteContentController();
  }else if(command.equals("reply_form")){
   ctr = new ReplyFormController();
  }else if(command.equals("reply_content")){
   ctr = new ReplyContentController();
  }
  return ctr;
 }

}

package board.controller;

import java.io.IOException;
 

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import board.dto.BoardDTO;
import board.dto.ForwardDTO;
import board.model.service.BoardService;

public class ReplyContentController implements Controller {

 @Override
 public ForwardDTO execute(HttpServletRequest request,
   HttpServletResponse response) throws ServletException, IOException {
  ForwardDTO forwardDTO = null;
  try {
  //1, client가 보낸 요청 파라미터 조회

  String title = request.getParameter("title");
  String writer = request.getParameter("writer");
  String content = request.getParameter("content");
  int refamily = Integer.parseInt(request.getParameter("refamily"));
  int restep = Integer.parseInt(request.getParameter("restep"));
  int relevel = Integer.parseInt(request.getParameter("relevel"));
 
  //글쓴일자하고  no,와 viewcount는 서비스에서 다시 생성할것이기 때문에 디폴트 값을 넣었다.
  BoardDTO bto = new BoardDTO(0,title, writer, content,null,0,refamily,restep,relevel);
 
  //2. 비지니스 로직 - Model(Business Service)로 요청
  BoardService boardService = BoardService.getInstance();
 
  
   boardService.replyContent(bto);
   request.setAttribute("board",bto);
   forwardDTO = new ForwardDTO("/show_content.jsp",false);
  } catch (Exception e) {
   e.printStackTrace();
   request.setAttribute("error_message", e.getMessage());
   forwardDTO = new ForwardDTO("/error.jsp",false);
  }
 
  return forwardDTO;
 }

}

package board.model.service;

import java.sql.SQLException;
import java.util.ArrayList;

import board.dto.BoardDTO;
import board.model.dao.BoardDAO;

import board.util.Utilities;

public class BoardService {
 private static BoardService instance = new BoardService();
 private  BoardDAO dao;
 private BoardService(){
  dao = BoardDAO.getInstance();
 }
 public static BoardService getInstance(){
  return instance;
 }
 public void writeContent(BoardDTO bto)throws SQLException{
  /*
   * 1. bto에 property 설정 - no, writedate, content
   *   no - sequence의 값 - dao.selectBoardNO();
   *   writedate - Utilities.getNow();
   *   content를 DB에 넣는 용으로 변경 Utilities.changeContentForDB();
   *   bdto의 refamily에 no 값을 설정
   * 2. dao.insertContent(bto);
   * 3. 날짜 형태를 년.월.일 시:분:초 형태로 변경 - bto의 property 변경
   *   Utilities.changeDayTimeFormat();
   */
  //1
  int no = dao.selectBoardNo();
  String writedate = Utilities.getNow();
  bto.setNo(no);
  bto.setWritedate(writedate);
  bto.setContent(Utilities.changeContentForDB(bto.getContent()));
  bto.setRefamily(no);
  //2
  dao.insertContent(bto);
  //3
  bto.setWritedate(Utilities.changeDayTimeFormat(writedate));
 }
 //글목록
 public ArrayList<BoardDTO> getBoardAllList() throws SQLException{
  //1. dao로 부터 전체 글내용을 ArrayList로 조회
  ArrayList<BoardDTO> list_all = dao.selectBoardAllList();
  //2. list내의 BoardDTO객체들의 wrtiedate를 변경
 
  for(int i=0;i<list_all.size();i++){
   list_all.get(i).setWritedate(Utilities.changeDayFormat(list_all.get(i).getWritedate()));
  }

  return list_all;
 }
 public BoardDTO getContentByNO(int no) throws SQLException{
  
  //1.조회수 증가
  dao.updateViewCount(no);
  //2. no로 글 정보 조회
  BoardDTO bto = dao.selectContentByNO(no);
  //2-1 writedate를 yyy.MM.dd HH:mm:ss 형식으로 변경
  bto.setWritedate(Utilities.changeDayTimeFormat(bto.getWritedate()));
  
  return bto;
 }
 public BoardDTO getContentByNOForForm(int no)throws SQLException{
  //1. no값으로 글 조회
  BoardDTO bto = dao.selectContentByNO(no);
  //2. content를 textarea용으로 변경(DB용으로 바뀌어 있는 것을 HTML용으로 변경)
  bto.setContent(Utilities.changeContentForTextArea(bto.getContent()));
  System.out.println("가져올때-----------\n"+bto.getContent());
  return bto;
 }
 public void modifyContent(BoardDTO bto)throws SQLException {
  //1. property변경 - content, writedate
  bto.setWritedate(Utilities.getNow());
  bto.setContent(Utilities.changeContentForDB(bto.getContent()));
  //2. 수정처리
  dao.updateContent(bto);
  //3. 날짜 포멧 변경
  bto.setWritedate(Utilities.changeDayTimeFormat(Utilities.getNow()));
 
  
 }
 
 public void deleteContentByNO(int no)throws SQLException{
  dao.deleteContentByNO(no);
  
 }
 public void replyContent(BoardDTO bto)throws SQLException {
  //1. DB에 같은 refamily의 restep들을 1씩 증가 시킨다.
  dao.updateRestep(bto.getRefamily(),bto.getRestep());
  //2. bdto의 restep, relevel을 1 증가 시킨다.
  bto.setRestep(bto.getRestep()+1);
  bto.setRelevel(bto.getRelevel()+1);
  //3. insert할 글 번호를 가져온뒤 bto에 넣는다.
  int no = dao.selectBoardNo();
  //4. BoardDTO에 no, writeDate와 content는 DB 저장용으로 변경한다.
  bto.setNo(no);
  bto.setWritedate(Utilities.getNow());
  bto.setContent(Utilities.changeContentForDB(bto.getContent()));
  //5. 새글 등록 - dao.insertContent()이용
  dao.insertContent(bto);
  //6. 날짜 형태 show_content.jsp에서 보여주도록 년.월.일 시:분:초 로 변경
  bto.setWritedate(Utilities.changeDayTimeFormat(Utilities.getNow()));

 }
}

package board.model.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import org.apache.tomcat.dbcp.dbcp.BasicDataSource;

import board.dto.BoardDTO;
import board.util.DBUtil;

public class BoardDAO {
 private static BoardDAO instance = new BoardDAO();
 private DBUtil dbUtil;

 private BoardDAO() {
  dbUtil = DBUtil.getInstance();
 }

 public static BoardDAO getInstance() {
  return instance;
 }

 public int selectBoardNo() throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select board_no_seq.nextval from dual";
  int no = 0;
  try {
   BasicDataSource ds = dbUtil.getDataSource();
   conn = ds.getConnection();
   pstmt = conn.prepareStatement(sql);
   rset = pstmt.executeQuery();
   if (rset.next()) {
    no = rset.getInt(1);
   }
  } finally {
   dbUtil.close(conn, pstmt, rset);
  }
  return no;
 }

 public void insertContent(BoardDTO bto) throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;

  String sql = "insert into board (no, title, writer, content, writedate, viewcount, refamily, restep, relevel)  values(?,?,?,?,?,0,?,?,?)";
  try {
   BasicDataSource ds = dbUtil.getDataSource();
   conn = ds.getConnection();
   pstmt = conn.prepareStatement(sql);
   pstmt.setInt(1, bto.getNo());
   pstmt.setString(2, bto.getTitle());
   pstmt.setString(3, bto.getWriter());
   pstmt.setString(4, bto.getContent());
   pstmt.setString(5, bto.getWritedate());
   //viewcount값은 처음 등록하면 무조건 0이라서 쿼리에서 부터 그냥 값을 넣어줬다
//   pstmt.setInt(6, bto.getViewcount());
   pstmt.setInt(6, bto.getRefamily());
   pstmt.setInt(7, bto.getRestep());
   pstmt.setInt(8, bto.getRelevel());
   int cnt = pstmt.executeUpdate();
   System.out.println(cnt + "개의 행이 삽입되었습니다.");

  } finally {
   dbUtil.close(conn, pstmt);
  }
 }

 public ArrayList<BoardDTO> selectBoardAllList() throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select no, title, writer, content, writedate, viewcount, refamily, restep, relevel from board order by refamily desc, restep asc";
  ArrayList<BoardDTO> list_all = new ArrayList<BoardDTO>();
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  rset = pstmt.executeQuery();
   while(rset.next()){
    list_all.add(new BoardDTO(rset.getInt(1), rset.getString(2), rset.getString(3), rset.getString(4), rset.getString(5), rset.getInt(6), rset.getInt(7), rset.getInt(8), rset.getInt(9)));
   }
  }finally{
   dbUtil.close(conn, pstmt, rset);
  }
  return list_all;
 }

 public BoardDTO selectContentByNO(int no) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select no, title, writer, content, writedate, viewcount, refamily, restep, relevel from board where no=?";
  BoardDTO bto = null;
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, no);
  rset = pstmt.executeQuery();
  if(rset.next()){
   bto = new BoardDTO(rset.getInt(1), rset.getString(2), rset.getString(3), rset.getString(4), rset.getString(5), rset.getInt(6), rset.getInt(7), rset.getInt(8), rset.getInt(9));
  }
  }finally{
   dbUtil.close(conn, pstmt, rset);
  }
  return bto;
 }

 public void updateViewCount(int no) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  String sql = "update board set viewcount=viewcount+1 where no=?";
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, no);
  int cnt = pstmt.executeUpdate();
  System.out.println(cnt+"개의 행이 수정되었습니다.");
  }finally{
   dbUtil.close(conn, pstmt);
  }
 }

 public void updateContent(BoardDTO dto) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  String sql = "update board set title=?, writer=?, content=?, writedate=? where no=?";
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setString(1, dto.getTitle());
  pstmt.setString(2, dto.getWriter());
  pstmt.setString(3, dto.getContent());
  pstmt.setString(4, dto.getWritedate());
  pstmt.setInt(5, dto.getNo());
  int cnt = pstmt.executeUpdate();
  System.out.println(cnt+"개의 행이 수정되었습니다.");
  }finally{
   dbUtil.close(conn, pstmt);
  }
  
 }

 public void deleteContentByNO(int no) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  String sql = "delete from board where no=?";
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, no);
  int cnt = pstmt.executeUpdate();
  System.out.println(cnt+"개의 행이 삭제되었습니다.");
  }finally{
   dbUtil.close(conn, pstmt);
  }
  
 }

 public void updateRestep(int refamily, int restep) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  String sql = "update board set restep=restep+1 where refamily=? and restep>?";
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, refamily);
  pstmt.setInt(2, restep);
  
  int cnt = pstmt.executeUpdate();
  System.out.println(cnt+"개의 행이 수정되었습니다.");
  }finally{
   dbUtil.close(conn, pstmt);
  }
  
 }
}

<%@page import="board.dto.BoardDTO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
 pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!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>
<style type="text/css">
div{
 width:600px;
 border:1px solid gray;
 padding : 5px;
}
#title{
 font-weight: bold;
 background-color: yellow;
}
#info{
 font-size:13px;
}
#content{
 min-height:300px;
 height:auto;
}
</style>
</head>
<body>
 <h1>글목록</h1>
 <p>
<div id="title">${requestScope.board.no}.${requestScope.board.title }</div>
<div id="info">작성자 : ${requestScope.board.writer } | 조회수 : ${requestScope.board.viewcount } 작성일시 : ${requestScope.board.writedate }</div>
<div id="content">${requestScope.board.content }</div>
 <p>
  <a href="/${initParam.context_root }/write_form.jsp">글쓰기</a>
  <a href="/${initParam.context_root }/boardController?command=list_all">전체 글목록</a>
  <a href="">글목록(페이징)</a>
  <a href="/${initParam.context_root }/boardController?command=modify_form&no=${requestScope.board.no}">글수정</a>
  <a href="/${initParam.context_root }/boardController?command=delete_content&no=${requestScope.board.no}">글삭제</a>
  <a href="/${initParam.context_root }/boardController?command=reply_form&no=${requestScope.board.no}">답변</a>
</body>
</html>

<%@page import="board.dto.BoardDTO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
 pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!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>
<style type="text/css">
div{
 width:600px;
 border:1px solid gray;
 padding : 5px;
}
#title{
 font-weight: bold;
 background-color: yellow;
}
#info{
 font-size:13px;
}
#content{
 min-height:300px;
 height:auto;
}
</style>
</head>
<body>
 <h1>글목록</h1>
 <p>
<div id="title">${requestScope.board.no}.${requestScope.board.title }</div>
<div id="info">작성자 : ${requestScope.board.writer } | 조회수 : ${requestScope.board.viewcount } 작성일시 : ${requestScope.board.writedate }</div>
<div id="content">${requestScope.board.content }</div>
 <p>
  <a href="/${initParam.context_root }/write_form.jsp">글쓰기</a>
  <a href="/${initParam.context_root }/boardController?command=list_all">전체 글목록</a>
  <a href="">글목록(페이징)</a>
  <a href="/${initParam.context_root }/boardController?command=modify_form&no=${requestScope.board.no}">글수정</a>
  <a href="/${initParam.context_root }/boardController?command=delete_content&no=${requestScope.board.no}">글삭제</a>
  <a href="/${initParam.context_root }/boardController?command=reply_form&no=${requestScope.board.no}">답변</a>
</body>
</html>

 package board.controller;

import java.io.IOException;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import board.dto.ForwardDTO;

public class BoardFrontController extends HttpServlet {
 private static final long serialVersionUID = 1L;

    public BoardFrontController() {
        super();
    
    }

 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  doPost(request, response);
 }

 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  //1. 공통 사전 작업 - 한글처리
  request.setCharacterEncoding("utf-8");
  //2. Controller 로직 처리 - Controller객체.execute()호출
  String command = request.getParameter("command");
  Controller ctr = ControllerCommandMapping.getController(command);
  ForwardDTO fdto = ctr.execute(request, response);
  //3. 공통 사후 작업
  if(fdto.isRedirect()){
   response.sendRedirect(fdto.getUrl());
  }else{
   RequestDispatcher rdp = request.getRequestDispatcher(fdto.getUrl());
   rdp.forward(request, response);
  }
 }

}

package board.controller;

public class ControllerCommandMapping {

 public static Controller getController(String command){
  Controller ctr = null;
  if(command.equals("write_content")){
   ctr = new WriteContentController();
  }else if(command.equals("list_all")){
   ctr = new BoardAllListController();
  }else if(command.equals("get_content")){
   ctr = new GetContentController();
  }else if(command.equals("modify_form")){
   ctr = new ModifyFormController();
  }else if(command.equals("modify_content")){
   ctr = new ModifyContentController();
  }else if(command.equals("delete_content")){
   ctr = new DeleteContentController();
  }else if(command.equals("reply_form")){
   ctr = new ReplyFormController();
  }
  return ctr;
 }

}

package board.controller;

import java.io.IOException;
 

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import board.dto.BoardDTO;
import board.dto.ForwardDTO;
import board.model.service.BoardService;

public class ReplyFormController implements Controller {

 @Override
 public ForwardDTO execute(HttpServletRequest request,
   HttpServletResponse response) throws ServletException, IOException {
  ForwardDTO forwardDTO = null;
  
  try {
  int no = Integer.parseInt(request.getParameter("no"));
  BoardService boardService = BoardService.getInstance();
 
   BoardDTO dto = boardService.getContentByNOForForm(no);

   request.setAttribute("dto",dto);
   forwardDTO = new ForwardDTO("/reply_form.jsp",false);
  } catch (Exception e) {
   e.printStackTrace();
   request.setAttribute("error_message", e.getMessage());
   forwardDTO = new ForwardDTO("/error.jsp",false);
  }
 
  return forwardDTO;
 }

}

package board.model.service;

import java.sql.SQLException;
import java.util.ArrayList;

import board.dto.BoardDTO;
import board.model.dao.BoardDAO;

import board.util.Utilities;

public class BoardService {
 private static BoardService instance = new BoardService();
 private  BoardDAO dao;
 private BoardService(){
  dao = BoardDAO.getInstance();
 }
 public static BoardService getInstance(){
  return instance;
 }
 public void writeContent(BoardDTO bto)throws SQLException{
  /*
   * 1. bto에 property 설정 - no, writedate, content
   *   no - sequence의 값 - dao.selectBoardNO();
   *   writedate - Utilities.getNow();
   *   content를 DB에 넣는 용으로 변경 Utilities.changeContentForDB();
   *   bdto의 refamily에 no 값을 설정
   * 2. dao.insertContent(bto);
   * 3. 날짜 형태를 년.월.일 시:분:초 형태로 변경 - bto의 property 변경
   *   Utilities.changeDayTimeFormat();
   */
  //1
  int no = dao.selectBoardNo();
  String writedate = Utilities.getNow();
  bto.setNo(no);
  bto.setWritedate(writedate);
  bto.setContent(Utilities.changeContentForDB(bto.getContent()));
  bto.setRefamily(no);
  //2
  dao.insertContent(bto);
  //3
  bto.setWritedate(Utilities.changeDayTimeFormat(writedate));
 }
 //글목록
 public ArrayList<BoardDTO> getBoardAllList() throws SQLException{
  //1. dao로 부터 전체 글내용을 ArrayList로 조회
  ArrayList<BoardDTO> list_all = dao.selectBoardAllList();
  //2. list내의 BoardDTO객체들의 wrtiedate를 변경
 
  for(int i=0;i<list_all.size();i++){
   list_all.get(i).setWritedate(Utilities.changeDayFormat(list_all.get(i).getWritedate()));
  }

  return list_all;
 }
 public BoardDTO getContentByNO(int no) throws SQLException{
  
  //1.조회수 증가
  dao.updateViewCount(no);
  //2. no로 글 정보 조회
  BoardDTO bto = dao.selectContentByNO(no);
  //2-1 writedate를 yyy.MM.dd HH:mm:ss 형식으로 변경
  bto.setWritedate(Utilities.changeDayTimeFormat(bto.getWritedate()));
  
  return bto;
 }
 public BoardDTO getContentByNOForForm(int no)throws SQLException{
  //1. no값으로 글 조회
  BoardDTO bto = dao.selectContentByNO(no);
  //2. content를 textarea용으로 변경(DB용으로 바뀌어 있는 것을 HTML용으로 변경)
  bto.setContent(Utilities.changeContentForTextArea(bto.getContent()));
  System.out.println("가져올때-----------\n"+bto.getContent());
  return bto;
 }
 public void modifyContent(BoardDTO bto)throws SQLException {
  //1. property변경 - content, writedate
  bto.setWritedate(Utilities.getNow());
  bto.setContent(Utilities.changeContentForDB(bto.getContent()));
  //2. 수정처리
  dao.updateContent(bto);
  //3. 날짜 포멧 변경
  bto.setWritedate(Utilities.changeDayTimeFormat(Utilities.getNow()));
 
  
 }
 
 public void deleteContentByNO(int no)throws SQLException{
  dao.deleteContentByNO(no);
  
 }
 }

package board.model.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import org.apache.tomcat.dbcp.dbcp.BasicDataSource;

import board.dto.BoardDTO;
import board.util.DBUtil;

public class BoardDAO {
 private static BoardDAO instance = new BoardDAO();
 private DBUtil dbUtil;

 private BoardDAO() {
  dbUtil = DBUtil.getInstance();
 }

 public static BoardDAO getInstance() {
  return instance;
 }

 public int selectBoardNo() throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select board_no_seq.nextval from dual";
  int no = 0;
  try {
   BasicDataSource ds = dbUtil.getDataSource();
   conn = ds.getConnection();
   pstmt = conn.prepareStatement(sql);
   rset = pstmt.executeQuery();
   if (rset.next()) {
    no = rset.getInt(1);
   }
  } finally {
   dbUtil.close(conn, pstmt, rset);
  }
  return no;
 }

 public void insertContent(BoardDTO bto) throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;

  String sql = "insert into board (no, title, writer, content, writedate, viewcount, refamily, restep, relevel)  values(?,?,?,?,?,0,?,?,?)";
  try {
   BasicDataSource ds = dbUtil.getDataSource();
   conn = ds.getConnection();
   pstmt = conn.prepareStatement(sql);
   pstmt.setInt(1, bto.getNo());
   pstmt.setString(2, bto.getTitle());
   pstmt.setString(3, bto.getWriter());
   pstmt.setString(4, bto.getContent());
   pstmt.setString(5, bto.getWritedate());
   //viewcount값은 처음 등록하면 무조건 0이라서 쿼리에서 부터 그냥 값을 넣어줬다
//   pstmt.setInt(6, bto.getViewcount());
   pstmt.setInt(6, bto.getRefamily());
   pstmt.setInt(7, bto.getRestep());
   pstmt.setInt(8, bto.getRelevel());
   int cnt = pstmt.executeUpdate();
   System.out.println(cnt + "개의 행이 삽입되었습니다.");

  } finally {
   dbUtil.close(conn, pstmt);
  }
 }

 public ArrayList<BoardDTO> selectBoardAllList() throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select no, title, writer, content, writedate, viewcount, refamily, restep, relevel from board order by refamily desc, restep asc";
  ArrayList<BoardDTO> list_all = new ArrayList<BoardDTO>();
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  rset = pstmt.executeQuery();
   while(rset.next()){
    list_all.add(new BoardDTO(rset.getInt(1), rset.getString(2), rset.getString(3), rset.getString(4), rset.getString(5), rset.getInt(6), rset.getInt(7), rset.getInt(8), rset.getInt(9)));
   }
  }finally{
   dbUtil.close(conn, pstmt, rset);
  }
  return list_all;
 }

 public BoardDTO selectContentByNO(int no) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select no, title, writer, content, writedate, viewcount, refamily, restep, relevel from board where no=?";
  BoardDTO bto = null;
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, no);
  rset = pstmt.executeQuery();
  if(rset.next()){
   bto = new BoardDTO(rset.getInt(1), rset.getString(2), rset.getString(3), rset.getString(4), rset.getString(5), rset.getInt(6), rset.getInt(7), rset.getInt(8), rset.getInt(9));
  }
  }finally{
   dbUtil.close(conn, pstmt, rset);
  }
  return bto;
 }

 public void updateViewCount(int no) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  String sql = "update board set viewcount=viewcount+1 where no=?";
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, no);
  int cnt = pstmt.executeUpdate();
  System.out.println(cnt+"개의 행이 수정되었습니다.");
  }finally{
   dbUtil.close(conn, pstmt);
  }
 }

 public void updateContent(BoardDTO dto) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  String sql = "update board set title=?, writer=?, content=?, writedate=? where no=?";
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setString(1, dto.getTitle());
  pstmt.setString(2, dto.getWriter());
  pstmt.setString(3, dto.getContent());
  pstmt.setString(4, dto.getWritedate());
  pstmt.setInt(5, dto.getNo());
  int cnt = pstmt.executeUpdate();
  System.out.println(cnt+"개의 행이 수정되었습니다.");
  }finally{
   dbUtil.close(conn, pstmt);
  }
  
 }

 public void deleteContentByNO(int no) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  String sql = "delete from board where no=?";
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, no);
  int cnt = pstmt.executeUpdate();
  System.out.println(cnt+"개의 행이 삭제되었습니다.");
  }finally{
   dbUtil.close(conn, pstmt);
  }
  
 }

 public void updateRestep(int refamily, int restep) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  String sql = "update board set restep=restep+1 where refamily=? and restep>?";
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, refamily);
  pstmt.setInt(2, restep);
  
  int cnt = pstmt.executeUpdate();
  System.out.println(cnt+"개의 행이 수정되었습니다.");
  }finally{
   dbUtil.close(conn, pstmt);
  }
  
 }
}

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!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>
</head>
<body>
<h2>글 답변 폼</h2><p>
${requestScope.dto.no }번 답변글
<form action="/${initParam.context_root }/boardController" method="post">
<input type="hidden" name="refamily" value="${requestScope.dto.refamily }">
<input type="hidden" name="restep" value="${requestScope.dto.restep }">
<input type="hidden" name="relevel" value="${requestScope.dto.relevel }">
<input type="hidden" name="command" value="reply_content">
<table width="500px">
 <tr>
  <td width="100px">제목</td><td><input type="text" name="title" size="50" value="RE : ${requestScope.dto.title }"></td>
 </tr>
 <tr>
  <td>작성자</td><td><input type="text" name="writer" size="10" maxlength="10" value="${requestScope.dto.writer }"></td>
 </tr>
 <tr>
  <td colspan="2"><textarea cols="50" rows="10" name="content">
${requestScope.dto.content }
----------------답변-----------------
</textarea>
</td>
   </tr>
   <tr>
    <td colspan="2" align="center">
     <input type="submit" value="답변">
     <input type="reset" value="초기화">
    </td>
   </tr>
</table>
</form>

</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!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>
</head>
<body>
<h2>글 답변 폼</h2><p>
${requestScope.dto.no }번 답변글
<form action="/${initParam.context_root }/boardController" method="post">
<input type="hidden" name="refamily" value="${requestScope.dto.refamily }">
<input type="hidden" name="restep" value="${requestScope.dto.restep }">
<input type="hidden" name="relevel" value="${requestScope.dto.relevel }">
<input type="hidden" name="command" value="reply_content">
<table width="500px">
 <tr>
  <td width="100px">제목</td><td><input type="text" name="title" size="50" value="RE : ${requestScope.dto.title }"></td>
 </tr>
 <tr>
  <td>작성자</td><td><input type="text" name="writer" size="10" maxlength="10" value="${requestScope.dto.writer }"></td>
 </tr>
 <tr>
  <td colspan="2"><textarea cols="50" rows="10" name="content">
${requestScope.dto.content }
----------------답변-----------------
</textarea>
</td>
   </tr>
   <tr>
    <td colspan="2" align="center">
     <input type="submit" value="답변">
     <input type="reset" value="초기화">
    </td>
   </tr>
</table>
</form>

</body>
</html>

package board.controller;

import java.io.IOException;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import board.dto.ForwardDTO;

public class BoardFrontController extends HttpServlet {
 private static final long serialVersionUID = 1L;

    public BoardFrontController() {
        super();
    
    }

 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  doPost(request, response);
 }

 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  //1. 공통 사전 작업 - 한글처리
  request.setCharacterEncoding("utf-8");
  //2. Controller 로직 처리 - Controller객체.execute()호출
  String command = request.getParameter("command");
  Controller ctr = ControllerCommandMapping.getController(command);
  ForwardDTO fdto = ctr.execute(request, response);
  //3. 공통 사후 작업
  if(fdto.isRedirect()){
   response.sendRedirect(fdto.getUrl());
  }else{
   RequestDispatcher rdp = request.getRequestDispatcher(fdto.getUrl());
   rdp.forward(request, response);
  }
 }

}

package board.controller;

public class ControllerCommandMapping {

 public static Controller getController(String command){
  Controller ctr = null;
  if(command.equals("write_content")){
   ctr = new WriteContentController();
  }else if(command.equals("list_all")){
   ctr = new BoardAllListController();
  }else if(command.equals("get_content")){
   ctr = new GetContentController();
  }else if(command.equals("modify_form")){
   ctr = new ModifyFormController();
  }else if(command.equals("modify_content")){
   ctr = new ModifyContentController();
  }else if(command.equals("delete_content")){
   ctr = new DeleteContentController();
  }else if(command.equals("reply_form")){
   ctr = new ReplyFormController();
  }else if(command.equals("reply_content")){
   ctr = new ReplyContentController();
  }
  return ctr;
 }

}

package board.controller;

import java.io.IOException;
 

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import board.dto.BoardDTO;
import board.dto.ForwardDTO;
import board.model.service.BoardService;

public class ReplyContentController implements Controller {

 @Override
 public ForwardDTO execute(HttpServletRequest request,
   HttpServletResponse response) throws ServletException, IOException {
  ForwardDTO forwardDTO = null;
  try {
  //1, client가 보낸 요청 파라미터 조회

  String title = request.getParameter("title");
  String writer = request.getParameter("writer");
  String content = request.getParameter("content");
  int refamily = Integer.parseInt(request.getParameter("refamily"));
  int restep = Integer.parseInt(request.getParameter("restep"));
  int relevel = Integer.parseInt(request.getParameter("relevel"));
 
  //글쓴일자하고  no,와 viewcount는 서비스에서 다시 생성할것이기 때문에 디폴트 값을 넣었다.
  BoardDTO bto = new BoardDTO(0,title, writer, content,null,0,refamily,restep,relevel);
 
  //2. 비지니스 로직 - Model(Business Service)로 요청
  BoardService boardService = BoardService.getInstance();
 
  
   boardService.replyContent(bto);
   request.setAttribute("board",bto);
   forwardDTO = new ForwardDTO("/show_content.jsp",false);
  } catch (Exception e) {
   e.printStackTrace();
   request.setAttribute("error_message", e.getMessage());
   forwardDTO = new ForwardDTO("/error.jsp",false);
  }
 
  return forwardDTO;
 }

}

package board.model.service;

import java.sql.SQLException;
import java.util.ArrayList;

import board.dto.BoardDTO;
import board.model.dao.BoardDAO;

import board.util.Utilities;

public class BoardService {
 private static BoardService instance = new BoardService();
 private  BoardDAO dao;
 private BoardService(){
  dao = BoardDAO.getInstance();
 }
 public static BoardService getInstance(){
  return instance;
 }
 public void writeContent(BoardDTO bto)throws SQLException{
  /*
   * 1. bto에 property 설정 - no, writedate, content
   *   no - sequence의 값 - dao.selectBoardNO();
   *   writedate - Utilities.getNow();
   *   content를 DB에 넣는 용으로 변경 Utilities.changeContentForDB();
   *   bdto의 refamily에 no 값을 설정
   * 2. dao.insertContent(bto);
   * 3. 날짜 형태를 년.월.일 시:분:초 형태로 변경 - bto의 property 변경
   *   Utilities.changeDayTimeFormat();
   */
  //1
  int no = dao.selectBoardNo();
  String writedate = Utilities.getNow();
  bto.setNo(no);
  bto.setWritedate(writedate);
  bto.setContent(Utilities.changeContentForDB(bto.getContent()));
  bto.setRefamily(no);
  //2
  dao.insertContent(bto);
  //3
  bto.setWritedate(Utilities.changeDayTimeFormat(writedate));
 }
 //글목록
 public ArrayList<BoardDTO> getBoardAllList() throws SQLException{
  //1. dao로 부터 전체 글내용을 ArrayList로 조회
  ArrayList<BoardDTO> list_all = dao.selectBoardAllList();
  //2. list내의 BoardDTO객체들의 wrtiedate를 변경
 
  for(int i=0;i<list_all.size();i++){
   list_all.get(i).setWritedate(Utilities.changeDayFormat(list_all.get(i).getWritedate()));
  }

  return list_all;
 }
 public BoardDTO getContentByNO(int no) throws SQLException{
  
  //1.조회수 증가
  dao.updateViewCount(no);
  //2. no로 글 정보 조회
  BoardDTO bto = dao.selectContentByNO(no);
  //2-1 writedate를 yyy.MM.dd HH:mm:ss 형식으로 변경
  bto.setWritedate(Utilities.changeDayTimeFormat(bto.getWritedate()));
  
  return bto;
 }
 public BoardDTO getContentByNOForForm(int no)throws SQLException{
  //1. no값으로 글 조회
  BoardDTO bto = dao.selectContentByNO(no);
  //2. content를 textarea용으로 변경(DB용으로 바뀌어 있는 것을 HTML용으로 변경)
  bto.setContent(Utilities.changeContentForTextArea(bto.getContent()));
  System.out.println("가져올때-----------\n"+bto.getContent());
  return bto;
 }
 public void modifyContent(BoardDTO bto)throws SQLException {
  //1. property변경 - content, writedate
  bto.setWritedate(Utilities.getNow());
  bto.setContent(Utilities.changeContentForDB(bto.getContent()));
  //2. 수정처리
  dao.updateContent(bto);
  //3. 날짜 포멧 변경
  bto.setWritedate(Utilities.changeDayTimeFormat(Utilities.getNow()));
 
  
 }
 
 public void deleteContentByNO(int no)throws SQLException{
  dao.deleteContentByNO(no);
  
 }
 public void replyContent(BoardDTO bto)throws SQLException {
  //1. DB에 같은 refamily의 restep들을 1씩 증가 시킨다.
  dao.updateRestep(bto.getRefamily(),bto.getRestep());
  //2. bdto의 restep, relevel을 1 증가 시킨다.
  bto.setRestep(bto.getRestep()+1);
  bto.setRelevel(bto.getRelevel()+1);
  //3. insert할 글 번호를 가져온뒤 bto에 넣는다.
  int no = dao.selectBoardNo();
  //4. BoardDTO에 no, writeDate와 content는 DB 저장용으로 변경한다.
  bto.setNo(no);
  bto.setWritedate(Utilities.getNow());
  bto.setContent(Utilities.changeContentForDB(bto.getContent()));
  //5. 새글 등록 - dao.insertContent()이용
  dao.insertContent(bto);
  //6. 날짜 형태 show_content.jsp에서 보여주도록 년.월.일 시:분:초 로 변경
  bto.setWritedate(Utilities.changeDayTimeFormat(Utilities.getNow()));

 }
}

package board.model.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import org.apache.tomcat.dbcp.dbcp.BasicDataSource;

import board.dto.BoardDTO;
import board.util.DBUtil;

public class BoardDAO {
 private static BoardDAO instance = new BoardDAO();
 private DBUtil dbUtil;

 private BoardDAO() {
  dbUtil = DBUtil.getInstance();
 }

 public static BoardDAO getInstance() {
  return instance;
 }

 public int selectBoardNo() throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select board_no_seq.nextval from dual";
  int no = 0;
  try {
   BasicDataSource ds = dbUtil.getDataSource();
   conn = ds.getConnection();
   pstmt = conn.prepareStatement(sql);
   rset = pstmt.executeQuery();
   if (rset.next()) {
    no = rset.getInt(1);
   }
  } finally {
   dbUtil.close(conn, pstmt, rset);
  }
  return no;
 }

 public void insertContent(BoardDTO bto) throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;

  String sql = "insert into board (no, title, writer, content, writedate, viewcount, refamily, restep, relevel)  values(?,?,?,?,?,0,?,?,?)";
  try {
   BasicDataSource ds = dbUtil.getDataSource();
   conn = ds.getConnection();
   pstmt = conn.prepareStatement(sql);
   pstmt.setInt(1, bto.getNo());
   pstmt.setString(2, bto.getTitle());
   pstmt.setString(3, bto.getWriter());
   pstmt.setString(4, bto.getContent());
   pstmt.setString(5, bto.getWritedate());
   //viewcount값은 처음 등록하면 무조건 0이라서 쿼리에서 부터 그냥 값을 넣어줬다
//   pstmt.setInt(6, bto.getViewcount());
   pstmt.setInt(6, bto.getRefamily());
   pstmt.setInt(7, bto.getRestep());
   pstmt.setInt(8, bto.getRelevel());
   int cnt = pstmt.executeUpdate();
   System.out.println(cnt + "개의 행이 삽입되었습니다.");

  } finally {
   dbUtil.close(conn, pstmt);
  }
 }

 public ArrayList<BoardDTO> selectBoardAllList() throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select no, title, writer, content, writedate, viewcount, refamily, restep, relevel from board order by refamily desc, restep asc";
  ArrayList<BoardDTO> list_all = new ArrayList<BoardDTO>();
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  rset = pstmt.executeQuery();
   while(rset.next()){
    list_all.add(new BoardDTO(rset.getInt(1), rset.getString(2), rset.getString(3), rset.getString(4), rset.getString(5), rset.getInt(6), rset.getInt(7), rset.getInt(8), rset.getInt(9)));
   }
  }finally{
   dbUtil.close(conn, pstmt, rset);
  }
  return list_all;
 }

 public BoardDTO selectContentByNO(int no) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select no, title, writer, content, writedate, viewcount, refamily, restep, relevel from board where no=?";
  BoardDTO bto = null;
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, no);
  rset = pstmt.executeQuery();
  if(rset.next()){
   bto = new BoardDTO(rset.getInt(1), rset.getString(2), rset.getString(3), rset.getString(4), rset.getString(5), rset.getInt(6), rset.getInt(7), rset.getInt(8), rset.getInt(9));
  }
  }finally{
   dbUtil.close(conn, pstmt, rset);
  }
  return bto;
 }

 public void updateViewCount(int no) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  String sql = "update board set viewcount=viewcount+1 where no=?";
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, no);
  int cnt = pstmt.executeUpdate();
  System.out.println(cnt+"개의 행이 수정되었습니다.");
  }finally{
   dbUtil.close(conn, pstmt);
  }
 }

 public void updateContent(BoardDTO dto) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  String sql = "update board set title=?, writer=?, content=?, writedate=? where no=?";
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setString(1, dto.getTitle());
  pstmt.setString(2, dto.getWriter());
  pstmt.setString(3, dto.getContent());
  pstmt.setString(4, dto.getWritedate());
  pstmt.setInt(5, dto.getNo());
  int cnt = pstmt.executeUpdate();
  System.out.println(cnt+"개의 행이 수정되었습니다.");
  }finally{
   dbUtil.close(conn, pstmt);
  }
  
 }

 public void deleteContentByNO(int no) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  String sql = "delete from board where no=?";
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, no);
  int cnt = pstmt.executeUpdate();
  System.out.println(cnt+"개의 행이 삭제되었습니다.");
  }finally{
   dbUtil.close(conn, pstmt);
  }
  
 }

 public void updateRestep(int refamily, int restep) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  String sql = "update board set restep=restep+1 where refamily=? and restep>?";
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, refamily);
  pstmt.setInt(2, restep);
  
  int cnt = pstmt.executeUpdate();
  System.out.println(cnt+"개의 행이 수정되었습니다.");
  }finally{
   dbUtil.close(conn, pstmt);
  }
  
 }
}

<%@page import="board.dto.BoardDTO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
 pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!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>
<style type="text/css">
div{
 width:600px;
 border:1px solid gray;
 padding : 5px;
}
#title{
 font-weight: bold;
 background-color: yellow;
}
#info{
 font-size:13px;
}
#content{
 min-height:300px;
 height:auto;
}
</style>
</head>
<body>
 <h1>글목록</h1>
 <p>
<div id="title">${requestScope.board.no}.${requestScope.board.title }</div>
<div id="info">작성자 : ${requestScope.board.writer } | 조회수 : ${requestScope.board.viewcount } 작성일시 : ${requestScope.board.writedate }</div>
<div id="content">${requestScope.board.content }</div>
 <p>
  <a href="/${initParam.context_root }/write_form.jsp">글쓰기</a>
  <a href="/${initParam.context_root }/boardController?command=list_all">전체 글목록</a>
  <a href="">글목록(페이징)</a>
  <a href="/${initParam.context_root }/boardController?command=modify_form&no=${requestScope.board.no}">글수정</a>
  <a href="/${initParam.context_root }/boardController?command=delete_content&no=${requestScope.board.no}">글삭제</a>
  <a href="/${initParam.context_root }/boardController?command=reply_form&no=${requestScope.board.no}">답변</a>
</body>
</html>

 <%@page import="board.dto.BoardDTO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
 pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!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>
<style type="text/css">
div{
 width:600px;
 border:1px solid gray;
 padding : 5px;
}
#title{
 font-weight: bold;
 background-color: yellow;
}
#info{
 font-size:13px;
}
#content{
 min-height:300px;
 height:auto;
}
</style>
</head>
<body>
 <h1>글목록</h1>
 <p>
<div id="title">${requestScope.board.no}.${requestScope.board.title }</div>
<div id="info">작성자 : ${requestScope.board.writer } | 조회수 : ${requestScope.board.viewcount } 작성일시 : ${requestScope.board.writedate }</div>
<div id="content">${requestScope.board.content }</div>
 <p>
  <a href="/${initParam.context_root }/write_form.jsp">글쓰기</a>
  <a href="/${initParam.context_root }/boardController?command=list_all">전체 글목록</a>
  <a href="">글목록(페이징)</a>
  <a href="/${initParam.context_root }/boardController?command=modify_form&no=${requestScope.board.no}">글수정</a>
  <a href="/${initParam.context_root }/boardController?command=delete_content&no=${requestScope.board.no}">글삭제</a>
  <a href="">글답변</a>
</body>
</html>

 package board.controller;

import java.io.IOException;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import board.dto.ForwardDTO;

public class BoardFrontController extends HttpServlet {
 private static final long serialVersionUID = 1L;

    public BoardFrontController() {
        super();
    
    }

 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  doPost(request, response);
 }

 protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  //1. 공통 사전 작업 - 한글처리
  request.setCharacterEncoding("utf-8");
  //2. Controller 로직 처리 - Controller객체.execute()호출
  String command = request.getParameter("command");
  Controller ctr = ControllerCommandMapping.getController(command);
  ForwardDTO fdto = ctr.execute(request, response);
  //3. 공통 사후 작업
  if(fdto.isRedirect()){
   response.sendRedirect(fdto.getUrl());
  }else{
   RequestDispatcher rdp = request.getRequestDispatcher(fdto.getUrl());
   rdp.forward(request, response);
  }
 }

}

 package board.controller;

public class ControllerCommandMapping {

 public static Controller getController(String command){
  Controller ctr = null;
  if(command.equals("write_content")){
   ctr = new WriteContentController();
  }else if(command.equals("list_all")){
   ctr = new BoardAllListController();
  }else if(command.equals("get_content")){
   ctr = new GetContentController();
  }else if(command.equals("modify_form")){
   ctr = new ModifyFormController();
  }else if(command.equals("modify_content")){
   ctr = new ModifyContentController();
  }else if(command.equals("delete_content")){
   ctr = new DeleteContentController();
  }
  return ctr;
 }

}

 package board.controller;

import java.io.IOException;
 

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import board.dto.ForwardDTO;
import board.model.service.BoardService;

public class DeleteContentController implements Controller {

 @Override
 public ForwardDTO execute(HttpServletRequest request,
   HttpServletResponse response) throws ServletException, IOException {
  ForwardDTO forwardDTO = null;
  try {
  int no = Integer.parseInt(request.getParameter("no"));
  BoardService boardService = BoardService.getInstance();
  
  
   boardService.deleteContentByNO(no);
   
  
   forwardDTO = new ForwardDTO("/boardController?command=list_all",false);
  } catch (Exception e) {
   e.printStackTrace();
   request.setAttribute("error_message", e.getMessage());
   forwardDTO = new ForwardDTO("/error.jsp",false);
  }
 
  return forwardDTO;
 }

}

 package board.model.service;

import java.sql.SQLException;
import java.util.ArrayList;

import board.dto.BoardDTO;
import board.model.dao.BoardDAO;

import board.util.Utilities;

public class BoardService {
 private static BoardService instance = new BoardService();
 private  BoardDAO dao;
 private BoardService(){
  dao = BoardDAO.getInstance();
 }
 public static BoardService getInstance(){
  return instance;
 }
 public void writeContent(BoardDTO bto)throws SQLException{
  /*
   * 1. bto에 property 설정 - no, writedate, content
   *   no - sequence의 값 - dao.selectBoardNO();
   *   writedate - Utilities.getNow();
   *   content를 DB에 넣는 용으로 변경 Utilities.changeContentForDB();
   *   bdto의 refamily에 no 값을 설정
   * 2. dao.insertContent(bto);
   * 3. 날짜 형태를 년.월.일 시:분:초 형태로 변경 - bto의 property 변경
   *   Utilities.changeDayTimeFormat();
   */
  //1
  int no = dao.selectBoardNo();
  String writedate = Utilities.getNow();
  bto.setNo(no);
  bto.setWritedate(writedate);
  bto.setContent(Utilities.changeContentForDB(bto.getContent()));
  bto.setRefamily(no);
  //2
  dao.insertContent(bto);
  //3
  bto.setWritedate(Utilities.changeDayTimeFormat(writedate));
 }
 //글목록
 public ArrayList<BoardDTO> getBoardAllList() throws SQLException{
  //1. dao로 부터 전체 글내용을 ArrayList로 조회
  ArrayList<BoardDTO> list_all = dao.selectBoardAllList();
  //2. list내의 BoardDTO객체들의 wrtiedate를 변경
  for(int i=0;i<list_all.size();i++){
   list_all.get(i).setWritedate(Utilities.changeDayFormat(list_all.get(i).getWritedate()));
  }
  return list_all;
 }
 public BoardDTO getContentByNO(int no) throws SQLException{
  
  //1.조회수 증가
  dao.updateViewCount(no);
  //2. no로 글 정보 조회
  BoardDTO bto = dao.selectContentByNO(no);
  //2-1 writedate를 yyy.MM.dd HH:mm:ss 형식으로 변경
  bto.setWritedate(Utilities.changeDayTimeFormat(bto.getWritedate()));
  
  return bto;
 }
 public BoardDTO getContentByNOForForm(int no)throws SQLException{
  //1. no값으로 글 조회
  BoardDTO bto = dao.selectContentByNO(no);
  //2. content를 textarea용으로 변경(DB용으로 바뀌어 있는 것을 HTML용으로 변경)
  bto.setContent(Utilities.changeContentForTextArea(bto.getContent()));
  System.out.println("가져올때-----------\n"+bto.getContent());
  return bto;
 }
 public void modifyContent(BoardDTO bto)throws SQLException {
  //1. property변경 - content, writedate
  bto.setWritedate(Utilities.getNow());
  bto.setContent(Utilities.changeContentForDB(bto.getContent()));
  //2. 수정처리
  dao.updateContent(bto);
  //3. 날짜 포멧 변경
  bto.setWritedate(Utilities.changeDayTimeFormat(Utilities.getNow()));
 
  
 }
 
 public void deleteContentByNO(int no)throws SQLException{
  dao.deleteContentByNO(no);
  
 }
}

 package board.model.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;

import org.apache.tomcat.dbcp.dbcp.BasicDataSource;

import board.dto.BoardDTO;
import board.util.DBUtil;

public class BoardDAO {
 private static BoardDAO instance = new BoardDAO();
 private DBUtil dbUtil;

 private BoardDAO() {
  dbUtil = DBUtil.getInstance();
 }

 public static BoardDAO getInstance() {
  return instance;
 }

 public int selectBoardNo() throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select board_no_seq.nextval from dual";
  int no = 0;
  try {
   BasicDataSource ds = dbUtil.getDataSource();
   conn = ds.getConnection();
   pstmt = conn.prepareStatement(sql);
   rset = pstmt.executeQuery();
   if (rset.next()) {
    no = rset.getInt(1);
   }
  } finally {
   dbUtil.close(conn, pstmt, rset);
  }
  return no;
 }

 public void insertContent(BoardDTO bto) throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;

  String sql = "insert into board (no, title, writer, content, writedate, viewcount, refamily, restep, relevel)  values(?,?,?,?,?,0,?,?,?)";
  try {
   BasicDataSource ds = dbUtil.getDataSource();
   conn = ds.getConnection();
   pstmt = conn.prepareStatement(sql);
   pstmt.setInt(1, bto.getNo());
   pstmt.setString(2, bto.getTitle());
   pstmt.setString(3, bto.getWriter());
   pstmt.setString(4, bto.getContent());
   pstmt.setString(5, bto.getWritedate());
   //viewcount값은 처음 등록하면 무조건 0이라서 쿼리에서 부터 그냥 값을 넣어줬다
//   pstmt.setInt(6, bto.getViewcount());
   pstmt.setInt(6, bto.getRefamily());
   pstmt.setInt(7, bto.getRestep());
   pstmt.setInt(8, bto.getRelevel());
   int cnt = pstmt.executeUpdate();
   System.out.println(cnt + "개의 행이 삽입되었습니다.");

  } finally {
   dbUtil.close(conn, pstmt);
  }
 }

 public ArrayList<BoardDTO> selectBoardAllList() throws SQLException {
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select no, title, writer, content, writedate, viewcount, refamily, restep, relevel from board order by refamily desc";
  ArrayList<BoardDTO> list_all = new ArrayList<BoardDTO>();
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  rset = pstmt.executeQuery();
   while(rset.next()){
    list_all.add(new BoardDTO(rset.getInt(1), rset.getString(2), rset.getString(3), rset.getString(4), rset.getString(5), rset.getInt(6), rset.getInt(7), rset.getInt(8), rset.getInt(9)));
   }
  }finally{
   dbUtil.close(conn, pstmt, rset);
  }
  return list_all;
 }

 public BoardDTO selectContentByNO(int no) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  ResultSet rset = null;
  String sql = "select no, title, writer, content, writedate, viewcount, refamily, restep, relevel from board where no=?";
  BoardDTO bto = null;
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, no);
  rset = pstmt.executeQuery();
  if(rset.next()){
   bto = new BoardDTO(rset.getInt(1), rset.getString(2), rset.getString(3), rset.getString(4), rset.getString(5), rset.getInt(6), rset.getInt(7), rset.getInt(8), rset.getInt(9));
  }
  }finally{
   dbUtil.close(conn, pstmt, rset);
  }
  return bto;
 }

 public void updateViewCount(int no) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  String sql = "update board set viewcount=viewcount+1 where no=?";
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, no);
  int cnt = pstmt.executeUpdate();
  System.out.println(cnt+"개의 행이 수정되었습니다.");
  }finally{
   dbUtil.close(conn, pstmt);
  }
 }

 public void updateContent(BoardDTO dto) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  String sql = "update board set title=?, writer=?, content=?, writedate=? where no=?";
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setString(1, dto.getTitle());
  pstmt.setString(2, dto.getWriter());
  pstmt.setString(3, dto.getContent());
  pstmt.setString(4, dto.getWritedate());
  pstmt.setInt(5, dto.getNo());
  int cnt = pstmt.executeUpdate();
  System.out.println(cnt+"개의 행이 수정되었습니다.");
  }finally{
   dbUtil.close(conn, pstmt);
  }
  
 }

 public void deleteContentByNO(int no) throws SQLException{
  Connection conn = null;
  PreparedStatement pstmt = null;
  String sql = "delete from board where no=?";
  try{
  BasicDataSource dataSource = dbUtil.getDataSource();
  
  conn = dataSource.getConnection();
  pstmt = conn.prepareStatement(sql);
  pstmt.setInt(1, no);
  int cnt = pstmt.executeUpdate();
  System.out.println(cnt+"개의 행이 삭제되었습니다.");
  }finally{
   dbUtil.close(conn, pstmt);
  }
  
 }
}

 package board.controller;

import java.io.IOException;
import java.sql.SQLException;
import java.util.ArrayList;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import board.dto.BoardDTO;
import board.dto.ForwardDTO;
import board.model.service.BoardService;

public class BoardAllListController implements Controller {

 @Override
 public ForwardDTO execute(HttpServletRequest request,
   HttpServletResponse response) throws ServletException, IOException {
  //1. 비지니스 로직 - Model(Business Service)로 요청
  BoardService boardService = BoardService.getInstance();
  ForwardDTO forwardDTO = null;
  try {
   ArrayList<BoardDTO> list_all = boardService.getBoardAllList();
   
   request.setAttribute("list_all",list_all);
   forwardDTO = new ForwardDTO("/list_all.jsp",false);
  } catch (SQLException e) {
   e.printStackTrace();
   request.setAttribute("error_message", e.getMessage());
   forwardDTO = new ForwardDTO("/error.jsp",false);
  }
 
  return forwardDTO;
 
 }

}

 <%@page import="board.dto.BoardDTO"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
 pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!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>
<style type="text/css">
div{
 width:600px;
 border:1px solid gray;
 padding : 5px;
}
#title{
 font-weight: bold;
 background-color: yellow;
}
#info{
 font-size:13px;
}
#content{
 min-height:300px;
 height:auto;
}
</style>
</head>
<body>
 <h1>글목록</h1>
 <p>

<div id="title">${requestScope.board.no}.${requestScope.board.title }</div>
<div id="info">작성자 : ${requestScope.board.writer } | 조회수 : ${requestScope.board.viewcount } 작성일시 : ${requestScope.board.writedate }</div>
<div id="content">${requestScope.board.content }</div>
 <p>

  <a href="/${initParam.context_root }/write_form.jsp">글쓰기</a>
  <a href="/${initParam.context_root }/boardController?command=list_all">전체 글목록</a>
  <a href="">글목록(페이징)</a>
  <a href="/${initParam.context_root }/boardController?command=modify_form&no=${requestScope.board.no}">글수정</a>
  <a href="">글답변</a>
 
</body>
</html>

 package board.controller;

import java.io.IOException;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import board.dto.ForwardDTO;

public class BoardFrontController extends HttpServlet {
 private static final long serialVersionUID = 1L;

    public BoardFrontController() {
        super();
    
    }

 protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  doPost(request, response);
 }