2014년 1월 21일 화요일

G. Spring Framework 게시판 만들기 (게시글 삭제, 스프링게시판소스)

G. Spring Framework 게시판 만들기 (게시글 삭제, 스프링게시판소스)


1.     시작하기<?XML:NAMESPACE PREFIX = O />
 
-       이번에는 게시글 삭제 기능을 구현하자.

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(String seq)throws DataAccessException;
// 코멘트 전체 삭제
public int AllDeleteComment(String seq)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);
}
}

3. [BoardServie.java] , [BoardServieImple.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(String seq)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(String seq)throws Exception{
return boardDAO.deleteBoard(seq);
}

}

4. [BoardMulitController.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.getSeq());
mav.setViewName("redirect:/list.html");
}else{
mas="비밀번호가 일치하지 않습니다.";
mav.addObject("mas", mas);
mav.setViewName("redirect:/read.html?seq="+boardDTO.getSeq());
}
return mav;
}
}

5.  [/WEB-INF/jsp/read.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="boardReadForm" method="post">
 
<table id="readTable" border="1" cellpadding="0" cellspacing="0">
<tr>
<td>제목:</td>  
<td class="readTD">${boardDto.title}</td>
</tr>
<tr>
<td>작성자:</td>
<td class="readTD">${boardDto.name}</td>
</tr> 
<tr>  
<td>내용:</td> 
<td><textarea rows="10" cols="77%" readonly="readonly">${boardDto.content}</textarea></td>
</tr>
<tr>
<td>파일:</td>
<td class="readTD">
<c:choose>
<c:when test="${boardDto.filename != ' '}">
${boardDto.filename}  
</c:when>
<c:when test="${boardDto.filename == ' '}">
파일이 없습니다.
</c:when>
</c:choose>
</td>
</tr>
</table>

<table class="readTable02">
<tr>
<td colspan="2" id="readButtonTD">
<input type="button" value="답변" onclick="location.href='/board/reply.html'">
<input type="button" value="수정" onclick="location.href='/board/updatePage.html'">
<input type="button" value="삭제" onclick="deleteGo();">
<input type="button" value="목록" onclick="location.href='/board/list.html'">
</td> 
</tr>
</table>
<br>
 
<!-- 코멘트 -->
<table class="readTable02">
<tr> 
<td>이름 : <input type="text" name="comment_name" id="comment_name"></td>
<td>코멘트 : <input type="text" name="comment_comm" id="comment_comm"></td>
<td>  
<input type="button" value="코멘트입력" onclick="commentInput();">
</td>
</tr>
</table>
<br>
<table class="readTable02" border="1" cellpadding="0" cellspacing="0">
<tr>
<td>코멘트 작성자</td>
<td>코멘트 내용</td>
</tr>
</table> 
<table class="readTable02">
<c:forEach var="comment" items="${comment}">
<tr>

<td>${comment.comment_name}</td>
<td>${comment.comment_comm}</td>
</tr> 
</c:forEach> 
</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 == ""){
alert("글 제목을 입력하세요.");
document.boardUpdateForm.title.focus();
return false;
}
if(document.boardUpdateForm.name == ""){
alert("작성자를 입력하세요.");
document.boardUpdateForm.name.focus();
return false;
}
if(document.boardUpdateForm.content == ""){
alert("글 내용을 입력하세요.");
document.boardUpdateForm.content.focus();
return false;
}
boardUpdateForm.action = "/board/update.html";
boardUpdateForm.submit();
}

// 글 삭제
function deleteGo(){
var deletePasswd= prompt("비밀번호를 입력하세요.","");
if(deletePasswd== null || deletePasswd== ""){
return false;
}else{
boardReadForm.action = "/board/delete.html? deletePasswd="+deletePasswd;
boardReadForm.submit(); 
}
}

window.onload = function(){
var massage = document.getElementById("massage");
if(massage != null){
if(massage.value == '비밀번호가 일치하지 않습니다.'){
alert(massage.value);
}else{
return false;
}  
}
};

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

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

<!-- DispatcherServlet Context: defines this servlet's request-processing infrastructure -->
<!-- <context:component-scan base-package="com.onj.board" /> -->
<!-- Enables the Spring MVC @Controller programming model -->
<annotation-driven />

<!-- Handles HTTP GET requests for /resources/** by efficiently serving up static resources in the ${webappRoot}/resources directory -->
<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>
<!-- Resolves views selected for rendering by @Controllers to .jsp resources in the /WEB-INF/views directory -->
<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>
 
<!-- 넘어오는 URL에 따라 컨트롤러에서 실행될 메소드 매핑 -->
<!-- PropertiesMethodNameResolver는 prop key로 넘어오는 url에 대해 실행할 컨트롤러의 메소드 정의 -->
<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:props>
</beans:property>
</beans:bean> 
<!-- controller mapping -->
<beans:bean name="/list.html /read.html /comment.html /write.html /writeOk.html /updatePage.html /update.html /delete.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>
[기업100%환급]Spring ,MyBatis,Hibernate실무과정 총 5일 40시간   01-27
[기업100%환급]자바기초에서 JDBC, Servlet/JSP까지 총 5일 40시간   02-05
자바기초에서JSP,Ajax,jQuery,Spring3.2,MyBatis까지 총 24일 72시간   01-24
Spring3.X, MyBatis, Hibernate실무과정 총 12일 36시간   02-03
Spring3.X, MyBatis, Hibernate실무과정 총 5일 35시간   02-15
자바기초에서JSP,Ajax,jQuery,Spring3.2,MyBatis까지 총 10일 70시간   02-15
JAVA&WEB프레임워크실무과정 총 14일 98시간   03-08

작성자: 시간:

댓글 없음:

댓글 쓰기

피드 구독하기: 댓글 (Atom)