시작 : show_content.jsp 삭제링크 클릭. cmd : delete_content
Ctr : DeleteContentController.execute()
BoardService : deleteContentByNO(int no) : void
BoardDTO : deleteContentByNO(int no)
응답 : list_all.jsp
<%@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;
}
}
* 결과보기
'프로그래밍 > JSP Programming' 카테고리의 다른 글
| 게시판 소스 (0) | 2012.05.18 |
|---|---|
| 2012-5-18 답변폼 조회 (0) | 2012.05.18 |
| 2012-5-17 게시판 글수정하기 (0) | 2012.05.17 |
| 2012-5-17 게시판 글번호로 조회 (0) | 2012.05.17 |
| 2012-5-17 전체 글목록 조회(no paging) (0) | 2012.05.17 |
