31. 게시글 수정 화면을 위한 JSP 페이지
WebContent/board/boardUpdate.jsp
<%@ 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>
<link rel="stylesheet" type="text/css" href="css/shopping.css">
<script type="text/javascript" src="script/board.js"></script>
</head>
<body>
<div id="wrap" align="center">
<h1>게시글 수정</h1>
<form name="frm" method="post" action="BoardServlet">
<input type="hidden" name="command" value="board_update"> <input
type="hidden" name="num" value="${board.num}">
<table>
<tr>
<th>작성자</th>
<td><input type="text" size="12" name="name"
value="${board.name}"> * 필수</td>
</tr>
<tr>
<th>비밀번호</th>
<td><input type="password" size="12" name="pass"> *
필수 (게시물 수정 삭제시 필요합니다.)</td>
</tr>
<tr>
<th>이메일</th>
<td><input type="text" size="40" maxlength="50" name="email"
value="${board.email}"></td>
</tr>
<tr>
<th>제목</th>
<td><input type="text" size="70" name="title"
value="${board.title}"></td>
</tr>
<tr>
<th>내용</th>
<td><textarea cols="70" rows="15" name="content">${board.content}</textarea></td>
</tr>
</table>
<br>
<br> <input type="submit" value="등록"
onclick="return boardCheck()"> <input type="reset"
value="다시 작성"> <input type="button" value="목록"
onclick="location.href='BoardServlet?command=board_list'">
</form>
</div>
</body>
</html>32. ActionFactory 전체 (수정하기 - BoardUpdateFormAction())
package com.saeyan.controller;
import com.saeyan.controller.action.Action;
import com.saeyan.controller.action.BoardCheckPassAction;
import com.saeyan.controller.action.BoardCheckPassFormAction;
import com.saeyan.controller.action.BoardDeleteAction;
import com.saeyan.controller.action.BoardListAction;
import com.saeyan.controller.action.BoardUpdateAction;
import com.saeyan.controller.action.BoardUpdateFormAction;
import com.saeyan.controller.action.BoardViewAction;
import com.saeyan.controller.action.BoardWriteAction;
import com.saeyan.controller.action.BoardWriteFormAction;
public class ActionFactory {
private static ActionFactory instance = new ActionFactory();
private ActionFactory() {
super();
}
public static ActionFactory getInstance() {
return instance;
}
public Action getAction(String command) {
Action action = null;
System.out.println("ActionFactory :" + command);
/* 추가된 부분 */
if (command.equals("board_list")) {
action = new BoardListAction();
} else if (command.equals("board_write_form")) {
action = new BoardWriteFormAction();
} else if (command.equals("board_write")) {
action = new BoardWriteAction();
} else if (command.equals("board_view")) {
action = new BoardViewAction();
} else if (command.equals("board_check_pass_form")) {
action = new BoardCheckPassFormAction();
} else if (command.equals("board_check_pass")) {
action = new BoardCheckPassAction();
} else if (command.equals("board_update_form")) {
action = new BoardUpdateFormAction();
} else if (command.equals("board_update")) {
action = new BoardUpdateAction();
} else if (command.equals("board_delete")) {
action = new BoardDeleteAction();
}
return action;
}
}
33. com.sw.controller.action/BoardUpdateAction.java
package com.saeyan.controller.action;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.saeyan.dao.BoardDAO;
import com.saeyan.dto.BoardVO;
public class BoardUpdateAction implements Action {
@Override
public void execute(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
BoardVO bVo = new BoardVO();
bVo.setNum(Integer.parseInt(request.getParameter("num")));
bVo.setName(request.getParameter("name"));
bVo.setPass(request.getParameter("pass"));
bVo.setEmail(request.getParameter("email"));
bVo.setTitle(request.getParameter("title"));
bVo.setContent(request.getParameter("content"));
BoardDAO bDao = BoardDAO.getInstance();
bDao.updateBoard(bVo);
new BoardListAction().execute(request, response);
}
}
34. ActionFactory 수정하기 (BoardUpdateAction())
35. com.sw.controller.action/BoardDeleteAction.java
package com.saeyan.controller.action;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.saeyan.dao.BoardDAO;
import com.saeyan.dto.BoardVO;
public class BoardDeleteAction implements Action {
@Override
public void execute(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String num=request.getParameter("num");
BoardDAO bDao=BoardDAO.getInstance();
bDao.deleteBoard(num);
new BoardListAction().execute(request, response);
}
}
36. ActionFactory 수정하기 (BoardDeleteAction())
36. DAO에 추가할 메소드
public void updateBoard(BoardVO bVo) {
String sql = "update board set name=?, email=?, pass=?, "
+ "title=?, content=? where num=?";
Connection conn = null;
PreparedStatement pstmt = null;
try {
conn = DBManager.getConnection();
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, bVo.getName());
pstmt.setString(2, bVo.getEmail());
pstmt.setString(3, bVo.getPass());
pstmt.setString(4, bVo.getTitle());
pstmt.setString(5, bVo.getContent());
pstmt.setInt(6, bVo.getNum());
pstmt.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
} finally {
DBManager.close(conn, pstmt);
}
}
public BoardVO checkPassWord(String pass, String num) {
String sql = "select * from board where pass=? and num=?";
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
BoardVO bVo = null;
try {
conn = DBManager.getConnection();
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, pass);
pstmt.setString(2, num);
rs = pstmt.executeQuery();
if (rs.next()) {
bVo = new BoardVO();
bVo.setNum(rs.getInt("num"));
bVo.setName(rs.getString("name"));
bVo.setEmail(rs.getString("email"));
bVo.setPass(rs.getString("pass"));
bVo.setTitle(rs.getString("title"));
bVo.setContent(rs.getString("content"));
bVo.setReadcount(rs.getInt("readcount"));
bVo.setWritedate(rs.getTimestamp("writedate"));
}
} catch (SQLException e) {
e.printStackTrace();
}
return bVo;
}
public void deleteBoard(String num) {
String sql = "delete board where num=?";
Connection conn = null;
PreparedStatement pstmt = null;
try {
conn = DBManager.getConnection();
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, num);
pstmt.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
}