자바, 스프링, JPA, C#, WPF, Xamarin, SQL, DB, Angular, AI, Block Chain을 사랑하는 풀스택개발자(mylife68@nate.com): H. [Spring 게시판, 답글/답변달기, reply]Spring Framework 게시판 만들기 (답변 달기) 1차 최종본 , 오라클자바커뮤니티 스프링게시판 답변글작성

2014년 8월 4일 월요일

H. [Spring 게시판, 답글/답변달기, reply]Spring Framework 게시판 만들기 (답변 달기) 1차 최종본 , 오라클자바커뮤니티 스프링게시판 답변글작성 - 유경석

1. 시작하기

- 이번에는 답변글 쓰기 기능을 추가하자.

- JSP쪽 /jsp/reply.jsp 파일이 추가된다.

- 답변글 쓰기 로직을 이해하려면 SpringBoardDAO.java에 설명되어 있는 reply, reply_level, reply_step의 의미에 대해 이해 하자.

2. [BoardDAO.java] , [BoardDAOImple.java]

package com.board.dao;

import java.util.List;

import java.util.Map;

import org.springframework.dao.DataAccessException;

import com.board.model.BoardDTO;

import com.board.model.CommentDTO;

public interface BoardDAO {

// 전체 게시글 수

public int boardCount(Map<String, Object>searchMap)throws DataAccessException;

// 게시판 리스트

public List<BoardDTO> boardList(Map<String, Object>searchMap) throws DataAccessException;

// 게시물 본문 미리보기

public String preView(String seq)throws DataAccessException;

// 게시글 조회수 1씩증가

public int updateReadCount(String seq)throws DataAccessException;

// 게시글 상세보기

public BoardDTO readContent(String seq)throws DataAccessException;

// 코멘트 저장

public int insertComment(CommentDTO commentDTO)throws DataAccessException;

// 코멘트 조회

public List<CommentDTO> ListComment(String seq)throws DataAccessException;

// 게시글 입력

public int insertBoard(BoardDTO boardDTO)throws DataAccessException;

// 글 수정

public int updateBoard(BoardDTO boardDTO)throws DataAccessException;

// 게시글 삭제

public int deleteBoard(BoardDTO boardDTO)throws DataAccessException;

// 코멘트 전체 삭제

public int AllDeleteComment(String seq)throws DataAccessException;

// 답글 달기

public int replyBoard(BoardDTO boardDTO)throws DataAccessException;

}

---------------------------------------------------------------------------------------------

package com.board.dao;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.List;

import java.util.Map;

import javax.sql.DataSource;

import org.springframework.dao.DataAccessException;

import org.springframework.jdbc.core.JdbcTemplate;

import org.springframework.jdbc.core.RowMapper;

import com.board.model.BoardDTO;

import com.board.model.CommentDTO;

public class BoardDAOImple implements BoardDAO {

private JdbcTemplate jdbaTemplate;

public void setDataSource(DataSource dataSource){

this.jdbaTemplate = new JdbcTemplate(dataSource);

}

// 게시글 수

public int boardCount(Map<String, Object>searchMap)throws DataAccessException{

int count = 0;

String sql = "";

if(searchMap.get("boardListSearchText") == null || searchMap.get("boardListSearchText").equals("")){

sql = "select count(*) from board02";

count = jdbaTemplate.queryForObject(sql,

Integer.class

);

}else{

String boardListSelect = (String) searchMap.get("boardListSelect");

String boardListSearchText = (String) searchMap.get("boardListSearchText");

sql = "select count(*) from board02 where "+boardListSelect+" like '%"+boardListSearchText+"%'";

count = jdbaTemplate.queryForObject(sql,Integer.class);

}

return count;

}

// 게시판 리스트

public List<BoardDTO> boardList(Map<String, Object>searchMap) throws DataAccessException {

List<BoardDTO> boardList = null;

String sql = "";

Object[] obj;

if(searchMap.get("boardListSearchText") == null || searchMap.get("boardListSearchText").equals("")){

sql = "select * from ("

+ " select ROWNUM r,seq ,name,title ,TO_CHAR(regdate,'YYYY/MM/DD')as regdate, readcount,"

+ " reply, reply_step, reply_level "

+ " from "

+ " (select * from board02 "

+ " order by reply desc, reply_step asc"

+ " )"

+ " where r BETWEEN ? AND ?";

obj = new Object[] {searchMap.get("startRow"),searchMap.get("endRow")};

}else{

String boardListSelect = (String) searchMap.get("boardListSelect");

String boardListSearchText = (String) searchMap.get("boardListSearchText");

sql = "select * from ("

+ " select ROWNUM r,seq ,name,title ,TO_CHAR(regdate,'YYYY/MM/DD')as regdate, readcount, "

+ " reply, reply_step, reply_level "

+ " from "

+ " (select * from board02 "

+ " where "

+ " "+boardListSelect+" like '%"+boardListSearchText+"%'"

+ " order by reply desc, reply_step asc"

+ " )"

+ " where r BETWEEN ? AND ?";

obj = new Object[] {searchMap.get("startRow"),searchMap.get("endRow")};

}

boardList = jdbaTemplate.query(sql,

obj,

new RowMapper<BoardDTO>(){

public BoardDTO mapRow(ResultSet rs, int rowNum)throws SQLException{

BoardDTO boardDTO = new BoardDTO(rs.getString("seq"),

rs.getString("name"),

rs.getString("title"),

rs.getString("regdate"),

rs.getInt("readcount"),

rs.getInt("reply_step"),

rs.getInt("reply_level")

);

return boardDTO;

}

});

return boardList;

}

// 게시물 본문내용 미리보기

public String preView(String seq) throws DataAccessException{

String sql = "select content from board02 where seq = ?";

String preContent = "";

Object obj[] = {seq};

preContent = jdbaTemplate.queryForObject(sql,obj,String.class);

return preContent;

}

// 게시글 조회수 1씩증가

public int updateReadCount(String seq)throws DataAccessException{

String sql = " update board02 set readcount = nvl(readcount,0)+1 where seq = ?";

Object[] obj = {seq};

return jdbaTemplate.update(sql,obj);

}

// 게시글 상세보기

public BoardDTO readContent(String seq)throws DataAccessException{

// 조회수 1증가 메소드 호출

this.updateReadCount(seq);

String sql = "select * from board02 where seq = ?";

Object[] obj = {seq};

BoardDTO boardDTO = jdbaTemplate.queryForObject(sql,

obj,

new RowMapper<BoardDTO>() {

public BoardDTO mapRow(ResultSet rs,int rowNum)throws SQLException {

BoardDTO boardDTO = new BoardDTO();

boardDTO.setSeq(rs.getString("seq"));

boardDTO.setName(rs.getString("name"));

boardDTO.setPasswd(rs.getString("passwd"));

boardDTO.setTitle(rs.getString("title"));

boardDTO.setContent(rs.getString("content"));

boardDTO.setFilename(rs.getString("filename"));

boardDTO.setRegdate(rs.getString("regdate"));

boardDTO.setReadcount(rs.getInt("readcount"));

boardDTO.setReply(rs.getString("reply"));

boardDTO.setReply_step(rs.getInt("reply_step"));

boardDTO.setReply_level(rs.getInt("reply_level"));

return boardDTO;

}

});

return boardDTO;

}

// 코멘트 저장

public int insertComment(CommentDTO commentDTO) throws DataAccessException {

String sql = "insert into comment_t02 values(sequence_comment_seq.nextval,?,?,?)";

Object[] obj = {commentDTO.getComment_name(),commentDTO.getComment_comm(),commentDTO.getSeq()};

return jdbaTemplate.update(sql, obj);

}

// 코멘트 조회

public List<CommentDTO> ListComment(String seq) throws DataAccessException {

String sql = "select * from comment_t02 where seq = ?";

Object[] obj = {seq};

List<CommentDTO> list = jdbaTemplate.query(sql,

obj,

new RowMapper<CommentDTO>(){

public CommentDTO mapRow(ResultSet rs,int rowNum)throws SQLException {

CommentDTO commentDTO = new CommentDTO();

commentDTO.setComment_seq(rs.getString("comment_seq"));

commentDTO.setComment_name(rs.getString("comment_name"));

commentDTO.setComment_comm(rs.getString("comment_comm"));

commentDTO.setSeq(rs.getString("seq"));

return commentDTO;

}

});

return list;

}

// 게시글 입력 public int insertBoard(BoardDTO boardDTO)throws DataAccessException{ String sql = "insert into board02 values(sequence_board_seq.nextval,?,?,?,?,?,sysdate,0,sequence_board_seq.currval,0,0)"; Object[] obj = {boardDTO.getName(), boardDTO.getPasswd(), boardDTO.getTitle(),boardDTO.getContent(), boardDTO.getFilename()}; return jdbaTemplate.update(sql, obj); }

// 글 수정 public int updateBoard(BoardDTO boardDTO)throws DataAccessException{ String sql = "update board02 set name = ? ,title = ?,content = ? where seq = ?"; Object[] obj = { boardDTO.getName(), boardDTO.getTitle(), boardDTO.getContent(), boardDTO.getSeq() }; return jdbaTemplate.update(sql,obj); }

// 게시글 삭제

public int deleteBoard(BoardDTO boardDTO)throws DataAccessException{

String sql = "";

// reply_revel이 0이면 본글 이고, 1이상이면 답변글

if(boardDTO.getReply_level() == 0){

sql = "delete from board02 where reply = ?";

}else{

sql = "delete from board02 where seq = ?";

}

Object[] obj = {boardDTO.getSeq()};

// 코멘트 전체 삭제

this.AllDeleteComment(boardDTO.getSeq());

return jdbaTemplate.update(sql,obj);

}

// 코멘트 전체 삭제

public int AllDeleteComment(String seq)throws DataAccessException{

String sql = "delete from comment_t02 where seq = ?";

Object[] obj = {seq};

return jdbaTemplate.update(sql,obj);

}

// 답글 달기

public int replyBoard(BoardDTO boardDTO)throws DataAccessException{

// 현재 답변을 단 게시물 보다 더 높은 스텝의 게시물이 있다면 스텝을 하나씩 상승시킴.

String sql1 ="update board02 set reply_step = reply_step + 1 "

+ "where reply = ? and reply_step > ?";

Object[] obj1 ={boardDTO.getReply(),boardDTO.getReply_step()};

jdbaTemplate.update(sql1, obj1);

// reply_step과 reply_level을 1씩 증가시킨 후 내용을 저장

String sql2 = "insert into board02 values(sequence_board_seq.nextval,?,?,?,?,?,sysdate,0,?,?,?)";

Object[] obj2 ={boardDTO.getName(),boardDTO.getPasswd(),boardDTO.getTitle(),boardDTO.getContent(),boardDTO.getFilename(),

boardDTO.getReply(),boardDTO.getReply_step()+1,boardDTO.getReply_level()+1};

return jdbaTemplate.update(sql2, obj2);

}

3. [BoardService.java] , [BoardServiceImple.java]

package com.board.service;

import java.util.List;

import java.util.Map;

import com.board.model.BoardDTO;

import com.board.model.CommentDTO;

public interface BoardService {

// 게시글 수

public int boardCount(Map<String, Object>searchMap)throws Exception;

// 게시판 리스트

public List<BoardDTO> boardList(Map<String, Object>searchMap)throws Exception;

//게시물 미리보기

public String preView(String seq)throws Exception;

// 게시글 상세보기

public BoardDTO readContent(String seq)throws Exception;

// 코멘트 저장

public int insertComment(CommentDTO commentDTO)throws Exception;

// 코멘트 조회

public List<CommentDTO> ListComment(String seq)throws Exception;

// 게시글 입력

public int insertBoard(BoardDTO boardDTO)throws Exception;

// 게시글 수정

public int updateBoard(BoardDTO boardDTO)throws Exception;

// 게시글 삭제

public int deleteBoard(BoardDTO boardDTO)throws Exception;

// 답글 등록

public int replyBoard(BoardDTO boardDTO)throws Exception;

}

--------------------------------------------------------------------------

package com.board.service;

import java.util.List;

import java.util.Map;

import com.board.dao.BoardDAO;

import com.board.model.BoardDTO;

import com.board.model.CommentDTO;

public class BoardServiceImple implements BoardService {

private BoardDAO boardDAO;

public void setBoardDAO(BoardDAO boardDAO){

this.boardDAO = boardDAO;

}

// 게시글 수

public int boardCount(Map<String, Object> searchMap) throws Exception {

return boardDAO.boardCount(searchMap);

}

// 게시판 리스트

public List<BoardDTO> boardList(Map<String, Object> searchMap) throws Exception {

return boardDAO.boardList(searchMap);

}

// 게시물 미리보기

public String preView(String seq){

return boardDAO.preView(seq);

}

// 게시글 상세보기

public BoardDTO readContent(String seq)throws Exception{

return boardDAO.readContent(seq);

}

// 코멘트 저장

public int insertComment(CommentDTO commentDTO) throws Exception {

return boardDAO.insertComment(commentDTO);

}

// 코멘트 조회

public List<CommentDTO> ListComment(String seq) throws Exception {

return boardDAO.ListComment(seq);

}

// 게시글 입력

public int insertBoard(BoardDTO boardDTO)throws Exception{

return boardDAO.insertBoard(boardDTO);

}

// 게시글 수정

public int updateBoard(BoardDTO boardDTO)throws Exception{

return boardDAO.updateBoard(boardDTO);

}

// 게시글 삭제

public int deleteBoard(BoardDTO boardDTO)throws Exception{

return boardDAO.deleteBoard(boardDTO);

}

// 답글 등록

public int replyBoard(BoardDTO boardDTO)throws Exception{

return boardDAO.replyBoard(boardDTO);

}

4. [BoardMultiController.java]

package com.onj.board;

import java.io.FileOutputStream;

import java.io.IOException;

import java.util.ArrayList;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import javax.servlet.http.HttpSession;

import org.springframework.web.multipart.MultipartFile;

import org.springframework.web.multipart.MultipartHttpServletRequest;

import org.springframework.web.servlet.ModelAndView;

import org.springframework.web.servlet.mvc.multiaction.MultiActionController;

import com.board.model.BoardDTO;

import com.board.model.CommentDTO;

import com.board.service.BoardService;

import com.board.util.EncodingHandler;

import com.board.util.PageHandler;

public class BoardMultiController extends MultiActionController{

private BoardService boardService;

private PageHandler pageHandler;

public void setBoardService(BoardService boardService){this.boardService = boardService;}

public void setPageHandler(PageHandler pageHandler){this.pageHandler = pageHandler;}

ModelAndView mav = null;

// 게시판 리스트

public ModelAndView list(HttpServletRequest request, HttpServletResponse response)throws Exception{

mav = new ModelAndView();

// 상세보기에서 사용한 session 지운다.

HttpSession session = request.getSession();

if(session.isNew() == false){session.invalidate();}

List<BoardDTO> list = null;

// 검색select , 검색Text

String boardListSelect = request.getParameter("boardListSelect");

String boardListSearchText = request.getParameter("boardListSearchText");

Map<String, Object> searchMap = new HashMap<String, Object>();

if(boardListSearchText != null){

searchMap.put("boardListSearchText", EncodingHandler.toKor(boardListSearchText));

searchMap.put("boardListSelect", boardListSelect);

mav.addObject("boardListSearchText", EncodingHandler.toKor(boardListSearchText));

mav.addObject("boardListSelect", boardListSelect);

}

String pageNumber = request.getParameter("pageNumber");

int pageNum = 1;

if(pageNumber != null){pageNum = Integer.parseInt(pageNumber);}

// 게시글 수

int totalCount = pageHandler.boardAllNumber(searchMap);

// 페이지 갯수

int totalPageCount = pageHandler.boardPageCount(searchMap);

// startPage , endPage

int startPage = pageHandler.boardStartPage(pageNum);

int endPage = pageHandler.boardEndPage(pageNum,searchMap);

// 처음, 마지막 rowNumber

List<Object> rowNumberList = new ArrayList<Object>();

rowNumberList = pageHandler.boardSetPageNumber(pageNum);

searchMap.put("startRow", rowNumberList.get(0));

searchMap.put("endRow", rowNumberList.get(1));

// 글 전체 출력

list = boardService.boardList(searchMap);

mav.addObject("pageNumber",pageNum);

mav.addObject("boardCount",totalCount);

mav.addObject("totalPageCount", totalPageCount);

mav.addObject("startPage", startPage);

mav.addObject("endPage", endPage);

mav.addObject("list", list);

mav.setViewName("list");

return mav;

}

// 게시글 상세보기

public ModelAndView read(HttpServletRequest request, HttpServletResponse response)throws Exception{

String seq = request.getParameter("seq");

BoardDTO boardDTO = boardService.readContent(seq);

// 상세글 내용 session에 담음

HttpSession session = request.getSession();

session.setAttribute("boardDTO", boardDTO);

mav.addObject("boardDto", boardDTO);

mav.addObject("comment", boardService.ListComment(seq));

mav.setViewName("read");

return mav;

}

// 코멘트 저장

public ModelAndView comment(HttpServletRequest request, HttpServletResponse response)throws Exception{

HttpSession session = request.getSession();

BoardDTO boardDTO = (BoardDTO) session.getAttribute("boardDTO");

mav = new ModelAndView("redirect:/read.html?seq="+boardDTO.getSeq());

CommentDTO commentDTO = new CommentDTO();

commentDTO.setComment_name(request.getParameter("comment_name"));

commentDTO.setComment_comm(request.getParameter("comment_comm"));

commentDTO.setSeq(boardDTO.getSeq());

boardService.insertComment(commentDTO);

return mav;

}

// 게시글 입력 화면

public ModelAndView write(HttpServletRequest request, HttpServletResponse response)throws Exception{

mav = new ModelAndView("write");

return mav;

}

// 입력된 글 저장

public ModelAndView writeOk(HttpServletRequest request ,HttpServletResponse response)throws Exception{

mav = new ModelAndView("redirect:/list.html");

MultipartHttpServletRequest mpRequest = (MultipartHttpServletRequest) request;

String name = request.getParameter("name");

String passwd = request.getParameter("passwd");

String title = request.getParameter("title");

String content = request.getParameter("content");

MultipartFile file = mpRequest.getFile("file");

// 파일이름

String fileName = file.getOriginalFilename();

BoardDTO boardDTO = new BoardDTO();

// 파일 저장 위치

String fileDir ="D:/upload/";

byte[] fileData;

FileOutputStream output = null;

if(!fileName.equals("")){

// 파일 저장

try{

fileData = file.getBytes();

output = new FileOutputStream(fileDir+fileName);

output.write(fileData);

}catch(IOException e){

e.printStackTrace();

}finally{output.close();

}

}else{fileName = " ";}

boardDTO.setName(name);

boardDTO.setPasswd(passwd);

boardDTO.setTitle(title);

boardDTO.setContent(content);

boardDTO.setFilename(fileName);

boardService.insertBoard(boardDTO);

return mav;

}

// 게시글 수정페이지 이동

public ModelAndView updatePageGo(HttpServletRequest request, HttpServletResponse response)throws Exception{

HttpSession session = request.getSession();

BoardDTO boardDTO = (BoardDTO) session.getAttribute("boardDTO");

mav = new ModelAndView("update", "boardDto",boardDTO);

return mav;

}

// 게시글 수정

public ModelAndView update(HttpServletRequest request, HttpServletResponse response)throws Exception{

HttpSession session = request.getSession();

BoardDTO boardDTO = (BoardDTO) session.getAttribute("boardDTO");

String name = request.getParameter("name");

String title = request.getParameter("title");

String content = request.getParameter("content");

String seq = boardDTO.getSeq();

boardDTO.setName(name);

boardDTO.setTitle(title);

boardDTO.setContent(content);

boardDTO.setSeq(seq);

boardService.updateBoard(boardDTO);

mav = new ModelAndView("redirect:/read.html?seq="+seq);

return mav;

}

// 게시글 삭제

public ModelAndView delete(HttpServletRequest request, HttpServletResponse response)throws Exception{

mav = new ModelAndView();

HttpSession session = request.getSession();

BoardDTO boardDTO = (BoardDTO) session.getAttribute("boardDTO");

// 게시글 비밀번호

String boardPassword = boardDTO.getPasswd();

// 입력한 비밀번호

String passwd = request.getParameter("passwd");

// 삭제 여부 메시지

String mas = "";

if(boardPassword.equals(passwd)){

boardService.deleteBoard(boardDTO);

mav.setViewName("redirect:/list.html");

}else{

mas="비밀번호가 일치하지 않습니다.";

mav.addObject("mas", mas);

mav.setViewName("redirect:/read.html?seq="+boardDTO.getSeq());

}

return mav;

}

// 답글 입력페이지

public ModelAndView reply(HttpServletRequest request, HttpServletResponse response)throws Exception{

HttpSession session = request.getSession();

BoardDTO boardDTO = (BoardDTO) session.getAttribute("boardDTO");

mav = new ModelAndView("reply","reply",boardDTO);

return mav;

}

// 답글 저장

public ModelAndView replyOk(HttpServletRequest request, HttpServletResponse response)throws Exception{

HttpSession session = request.getSession();

BoardDTO boardDTO = (BoardDTO) session.getAttribute("boardDTO");

boardDTO.setName(request.getParameter("name"));

boardDTO.setPasswd(request.getParameter("passwd"));

boardDTO.setTitle("re:"+request.getParameter("title"));

boardDTO.setContent(request.getParameter("content"));

boardDTO.setFilename(" ");

boardService.replyBoard(boardDTO);

mav = new ModelAndView("redirect:/list.html");

return mav;

}

5. [/WEB-INF/jsp/reply.jsp] , [/js/boardActionJs.js]

<%@ page language="java" contentType="text/html; charset=EUC-KR"

pageEncoding="EUC-KR"%>

<%@ 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>

<link rel="stylesheet" type="text/css" href="/board/css/boardCss.css">

<script type="text/javascript" src="/board/js/boardActionJs.js"></script>

<meta http-equiv="Content-Type" content="text/html; charset=EUC-KR">

<title>Board Read</title>

</head>

<body>

<input type="hidden" id="massage" value="${mas}">

<center>

<h1>오라클자바커뮤니티 프로그래밍 실무교육센터 스프링 게시판</h1><hr>

<form name="boardReplyForm" method="post">

<table id="readTable" border="1" cellpadding="0" cellspacing="0">

<tr>

<td>제목:</td>

<td class="readTD">

Re:<input type="text" id="title" name="title" size="68">

</td>

</tr>

<tr>

<td>작성자:</td>

<td class="readTD">

<input type="text" id="name" name="name" size="73">

</td>

</tr>

<tr>

<td>비밀번호:</td>

<td>

<input type="password" id="passwd" name="passwd" size="83" name="passwd">

</td>

</tr>

<tr>

<td>내용:</td>

<td><textarea rows="10" cols="75%" id="content" name="content"></textarea></td>

</tr>

</table>

<table class="readTable02">

<tr>

<td colspan="2" id="readButtonTD">

<input type="button" value="답변" onclick="replyOk();">

<input type="button" value="목록" onclick="location.href='/board/list.html'">

</td>

</tr>

</table>

</form>

</center>

</body>

</html>

-------------------------------------------------------------------

// 검색

function boardListSearchGo(){

document.listForm.action ="/board/list.html";

document.listForm.submit();

}

// 검색Text입력 후 바로 엔터 가능하게 하는 이벤트

function enterEvent(){

if(window.event.keyCode == 13){

boardListSearchGo();

}

// 미리보기(Ajax)

var xmlHttp = null;

var xmlDoc = null;

var message = null;

function createXMLHttpRequest(){

// 익스플로러이면 if 그외 브라우저이면 else

if(window.ActiveXObject){

try{

xmlHttp = new ActiveXObject("Msxml2.XMLHTTP"); // IE 5.0 이하 버전

}catch(e){

try{

xmlHttp = new ActiveXObject("Microsoft.XMLHTTP"); // IE 5.0 이상 버전

}catch(el){xmlHttp = null;}

}

}else if(window.XMLHttpRequest){

try{

xmlHttp = new XMLHttpRequest();

}catch(e){

xmlHttp = null;

}

if(xmlHttp == null){errorMessage();}

return xmlHttp;

}

function errorMessage(){alert("지원할 수 없는 브라우저 입니다.");}

function contentprev(seq){

var url = "ContentPreview?seq="+seq;

xmlHttp = createXMLHttpRequest();

xmlHttp.onreadystatechange = handleStateChange;

xmlHttp.open("get",url,true);

xmlHttp.send(null);

}

function handleStateChange(){

if(xmlHttp.readyState == 4){

if(xmlHttp.status == 200){

xmlDoc = xmlHttp.responseText;

document.getElementById("layer1").innerHTML = xmlDoc;

//화면에서 마우스가 움직일때 movetip()함수 발생

document.onmousemove = movetip;

showlayer();

}

// 게시판 글제목에서 마우스가 올라갔을 경우 발생

function showlayer(){

document.getElementById("layer1").style.visibility="visible";

}

// 게시판 글제목에 마우스가 떨어져 있을 경우 발생

function hidelayer(){

document.getElementById("layer1").style.visibility="hidden";

}

// 미리보기 위치

function movetip(){

document.getElementById("layer1").style.pixelTop = event.y+document.body.scrollTop+20;

document.getElementById("layer1").style.pixelLeft = event.x+document.body.scrollLeft+20;

}

// 코멘트 저장

function commentInput(){

var comment_name = document.getElementById("comment_name");

var comment_comm = document.getElementById("comment_comm");

if(comment_name.value == ""){

alert("코멘트 이름을 적으세요.");

comment_name.focus();

return false;

}

if(comment_comm.value == ""){

alert("코멘트 내용을 적으세요.");

comment_comm.focus();

return false;

}

boardReadForm.action="/board/comment.html";

boardReadForm.submit();

}

// 글입력

function writeGoGo(){

if(document.writeForm.title.value == ""){

alert("글 제목을 입력하세요.");

document.writeForm.title.focus();

return false;

}

if(document.writeForm.name.value == ""){

alert("작성자를 입력하세요.");

document.writeForm.name.focus();

return false;

}

if(document.writeForm.passwd.value == ""){

alert("비밀번호를 입력하세요.");

document.writeForm.passwd.focus();

return false;

}

if(document.writeForm.content.value == ""){

alert("글 내용을 입력하세요.");

document.writeForm.content.focus();

return false;

}

writeForm.action="/board/writeOk.html";

writeForm.submit();

}

// 수정

function updateButton(){

if(document.boardUpdateForm.title.value == ""){

alert("글 제목을 입력하세요.");

document.boardUpdateForm.title.focus();

return false;

}

if(document.boardUpdateForm.name.value == ""){

alert("작성자를 입력하세요.");

document.boardUpdateForm.name.focus();

return false;

}

if(document.boardUpdateForm.content.value == ""){

alert("글 내용을 입력하세요.");

document.boardUpdateForm.content.focus();

return false;

}

boardUpdateForm.action = "/board/update.html";

boardUpdateForm.submit();

}

// 글 삭제

function deleteGo(){

var passwd = prompt("비밀번호를 입력하세요.","");

if(passwd == null || passwd == ""){

return false;

}else{

boardReadForm.action = "/board/delete.html?passwd="+passwd;

boardReadForm.submit();

}

window.onload = function(){

var massage = document.getElementById("massage");

if(massage.value == '비밀번호가 일치하지 않습니다.'){

alert(massage.value);

}else{

return false;

}

};

//답글 저장

function replyOk(){

if(document.boardReplyForm.title.value == ""){

alert("글 제목을 입력하세요.");

document.boardReplyForm.title.focus();

return false;

}

if(document.boardReplyForm.name.value == ""){

alert("작성자를 입력하세요.");

document.boardReplyForm.name.focus();

return false;

}

if(document.boardReplyForm.passwd.value == ""){

alert("비밀번호를 입력하세요.");

document.boardReplyForm.passwd.focus();

return false;

}

if(document.boardReplyForm.content.value == ""){

alert("글 내용을 입력하세요.");

document.boardReplyForm.content.focus();

return false;

}

boardReplyForm.action = "/board/replyOk.html";

boardReplyForm.submit();

}

6. [/WEB-INF/Spring/appServlet/servlet-context.xml]

<?xml version="1.0" encoding="UTF-8"?>

<beans:beans xmlns="http://www.springframework.org/schema/mvc"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xmlns:beans="http://www.springframework.org/schema/beans"

xmlns:context="http://www.springframework.org/schema/context"

xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd

http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd

http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd

<annotation-driven />

<resources mapping="/resources/**" location="/resources/" />

<beans:bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">

<beans:property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>

<beans:property name="url" value="jdbc:oracle:thin:@localhost:1521:ex"/>

<beans:property name="username" value="study"/>

<beans:property name="password" value="study"/>

</beans:bean>

<beans:bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">

<beans:property name="prefix" value="/WEB-INF/jsp/"/>

<beans:property name="suffix" value=".jsp" />

</beans:bean>

<beans:bean id="userControllerMethodNameResolver" class="org.springframework.web.servlet.mvc.multiaction.PropertiesMethodNameResolver">

<beans:property name="mappings">

<beans:props>

<beans:prop key="/list.html">list</beans:prop>

<beans:prop key="/read.html">read</beans:prop>

<beans:prop key="/comment.html">comment</beans:prop>

<beans:prop key="/write.html">write</beans:prop>

<beans:prop key="/writeOk.html">writeOk</beans:prop>

<beans:prop key="/updatePage.html">updatePageGo</beans:prop>

<beans:prop key="/update.html">update</beans:prop>

<beans:prop key="/delete.html">delete</beans:prop>

<beans:prop key="/reply.html">reply</beans:prop>

<beans:prop key="/replyOk.html">replyOk</beans:prop>

</beans:props>

</beans:property>

</beans:bean>

<beans:bean name="/list.html /read.html /comment.html /write.html /writeOk.html /updatePage.html /update.html /delete.html /reply.html /replyOk.html" class="com.onj.board.BoardMultiController">

<beans:property name="methodNameResolver" ref="userControllerMethodNameResolver"/>

<beans:property name="boardService" ref="boardService"/>

<beans:property name="pageHandler" ref="pageHandler"/>

</beans:bean>

</beans:beans>

[출처] 오라클자바커뮤니티 - http://www.oraclejavacommunity.co.kr/bbs/board.php?bo_table=LecSpring&wr_id=352