글 등록 DAO
//글 등록
public void insertBoard(BoardVO board)throws Exception{
Connection conn = null;
PreparedStatement pstmt = null;
String sql = null;
try {
//커넥션풀로부터 커넥션 할당
conn = DBUtil.getConnection();
//SQL문 작성
sql = "INSERT INTO zboard (board_num,title,content,"
+ "filename,ip,mem_num) VALUES (zboard_seq.nextval,"
+ "?,?,?,?,?)";
//PreparedStatement 객체 생성
pstmt = conn.prepareStatement(sql);
//?에 데이터 바인딩
pstmt.setString(1, board.getTitle());
pstmt.setString(2, board.getContent());
pstmt.setString(3, board.getFilename());
pstmt.setString(4, board.getIp());
pstmt.setInt(5, board.getMem_num());
//SQL문 실행
pstmt.executeUpdate();
}catch(Exception e) {
throw new Exception(e);
}finally {
DBUtil.executeClose(null, pstmt, conn);
}
}글 등록 폼 Action
package kr.board.action;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import kr.controller.Action;
public class WriteFormAction implements Action{
@Override
public String execute(HttpServletRequest request, HttpServletResponse response) throws Exception {
HttpSession session = request.getSession();
Integer user_num =
(Integer)session.getAttribute("user_num");
if(user_num == null) {//로그인이 되지 않은 경우
return "redirect:/member/loginForm.do";
}
//로그인 된 경우
return "/WEB-INF/views/board/writeForm.jsp";
}
}글 등록 폼 View
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>게시판 글쓰기</title>
<link rel="stylesheet" href="${pageContext.request.contextPath}/css/style.css" type="text/css">
<script type="text/javascript">
window.onload=function(){
const myForm = document.getElementById('write_form');
//이벤트 연결
myForm.onsubmit=function(){
const title = document.getElementById('title');
if(title.value.trim()==''){
alert('제목을 입력하세요');
title.value = '';
title.focus();
return false;
}
const content = document.getElementById('content');
if(content.value.trim()==''){
alert('내용을 입력하세요');
content.value = '';
content.focus();
return false;
}
};
};
</script>
</head>
<body>
<div class="page-main">
<jsp:include page="/WEB-INF/views/common/header.jsp"/>
<div class="content-main">
<h2>글쓰기</h2>
<form id="write_form" action="write.do" method="post"
enctype="multipart/form-data">
<ul>
<li>
<label for="title">제목</label>
<input type="text" name="title" id="title"
maxlength="50">
</li>
<li>
<label for="content">내용</label>
<textarea rows="5" cols="40"
name="content" id="content"></textarea>
</li>
<li>
<label for="filename">이미지</label>
<input type="file" name="filename"
id="filename" accept="image/gif,image/png,image/jpeg">
</li>
</ul>
<div class="align-center">
<input type="submit" value="등록">
<input type="button" value="목록"
onclick="location.href='list.do'">
</div>
</form>
</div>
</div>
</body>
</html>글 등록 Action
package kr.board.action;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import kr.board.dao.BoardDAO;
import kr.board.vo.BoardVO;
import kr.controller.Action;
import kr.util.FileUtil;
public class WriteAction implements Action{
@Override
public String execute(HttpServletRequest request, HttpServletResponse response) throws Exception {
HttpSession session = request.getSession();
Integer user_num =
(Integer)session.getAttribute("user_num");
if(user_num == null) {//로그인이 되지 않은 경우
return "redirect:/member/loginForm.do";
}
//로그인 된 경우
//전송된 데이터 인코딩 타입 지정
request.setCharacterEncoding("utf-8");
//자바빈(VO)를 생성한 후 전송된 데이터를 저장
BoardVO board = new BoardVO();
board.setTitle(request.getParameter("title"));
board.setContent(request.getParameter("content"));
board.setIp(request.getRemoteAddr());
board.setFilename(
FileUtil.createFile(request, "filename"));
board.setMem_num(user_num);//작성자 회원번호
BoardDAO dao = BoardDAO.getInstance();
dao.insertBoard(board);
request.setAttribute("notice_msg", "글쓰기 완료");
request.setAttribute("notice_url",
request.getContextPath()+"/board/list.do");
//JSP 경로 반환
return "/WEB-INF/views/common/alert_view.jsp";
}
}글 개수 DAO
//총 글의 개수,검색 개수
public int getBoardCount(String keyfield, String keyword)
throws Exception{
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
String sql = null;
String sub_sql = "";
int count = 0;
try {
//커넥션풀로부터 커넥션 할당
conn = DBUtil.getConnection();
if(keyword!=null && !"".equals(keyword)) {
//검색 처리
if(keyfield.equals("1")) sub_sql += "WHERE title LIKE '%' || ? || '%'";
else if(keyfield.equals("2")) sub_sql += "WHERE id LIKE '%' || ? || '%'";
else if(keyfield.equals("3")) sub_sql += "WHERE content LIKE '%' || ? || '%'";
}
//SQL문 작성
sql = "SELECT COUNT(*) FROM zboard JOIN zmember USING(mem_num) " + sub_sql;
//PreparedStatement 객체 생성
pstmt = conn.prepareStatement(sql);
if(keyword!=null && !"".equals(keyword)) {
pstmt.setString(1, keyword);
}
//SQL문 실행
rs = pstmt.executeQuery();
if(rs.next()) {
count = rs.getInt(1);
}
}catch(Exception e) {
throw new Exception(e);
}finally {
DBUtil.executeClose(rs, pstmt, conn);
}
return count;
}글 목록 DAO
//글 목록, 검색 글 목록
public List<BoardVO> getListBoard(int start, int end,
String keyfield,String keyword)
throws Exception{
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
List<BoardVO> list = null;
String sql = null;
String sub_sql = "";
int cnt = 0;
try {
//커넥션풀로부터 커넥션 할당
conn = DBUtil.getConnection();
if(keyword!=null && !"".equals(keyword)) {
//검색 처리
if(keyfield.equals("1")) sub_sql += "WHERE title LIKE '%' || ? || '%'";
else if(keyfield.equals("2")) sub_sql += "WHERE id LIKE '%' || ? || '%'";
else if(keyfield.equals("3")) sub_sql += "WHERE content LIKE '%' || ? || '%'";
}
//SQL문 작성
sql = "SELECT * FROM (SELECT a.*, rownum rnum FROM "
+ "(SELECT * FROM zboard JOIN zmember USING(mem_num) " + sub_sql
+ " ORDER BY board_num DESC)a) WHERE rnum >= ? AND rnum <= ?";
//PreparedStatement 객체 생성
pstmt = conn.prepareStatement(sql);
if(keyword!=null && !"".equals(keyword)) {
pstmt.setString(++cnt, keyword);
}
pstmt.setInt(++cnt, start);
pstmt.setInt(++cnt, end);
//SQL문 실행
rs = pstmt.executeQuery();
list = new ArrayList<BoardVO>();
while(rs.next()) {
BoardVO board = new BoardVO();
board.setBoard_num(rs.getInt("board_num"));
board.setTitle(StringUtil.useNoHTML(rs.getString("title")));//HTML 태그를 허용하지 않음
board.setHit(rs.getInt("hit"));
board.setReg_date(rs.getDate("reg_date"));
board.setId(rs.getString("id"));//작성자의 아이디
list.add(board);
}
}catch(Exception e) {
throw new Exception(e);
}finally {
DBUtil.executeClose(rs, pstmt, conn);
}
return list;
}글 목록 Action
package kr.board.action;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import kr.board.dao.BoardDAO;
import kr.board.vo.BoardVO;
import kr.controller.Action;
import kr.util.PagingUtil;
public class ListAction implements Action{
@Override
public String execute(HttpServletRequest request, HttpServletResponse response) throws Exception {
String pageNum = request.getParameter("pageNum");
if(pageNum == null) pageNum = "1";
String keyfield = request.getParameter("keyfield");
String keyword = request.getParameter("keyword");
BoardDAO dao = BoardDAO.getInstance();
int count = dao.getBoardCount(keyfield, keyword);
//페이지 처리
PagingUtil page = new PagingUtil(keyfield,keyword,
Integer.parseInt(pageNum),
count,20,10,"list.do");
List<BoardVO> list = null;
if(count > 0) {
list = dao.getListBoard(page.getStartRow(),
page.getEndRow(),keyfield,keyword);
}
request.setAttribute("count", count);
request.setAttribute("list", list);
request.setAttribute("page", page.getPage());
//JSP 경로 반환
return "/WEB-INF/views/board/list.jsp";
}
}글 목록 View
<%@ 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>
<html>
<head>
<meta charset="UTF-8">
<title>게시판 목록</title>
<link rel="stylesheet" href="${pageContext.request.contextPath}/css/style.css" type="text/css">
<script type="text/javascript">
window.onload=function(){
const myForm = document.getElementById('search_form');
//이벤트 연결
myForm.onsubmit=function(){
const keyword = document.getElementById('keyword');
if(keyword.value.trim()==''){
alert('검색어를 입력하세요');
keyword.value = '';
keyword.focus();
return false;
}
};
};
</script>
</head>
<body>
<div class="page-main">
<jsp:include page="/WEB-INF/views/common/header.jsp"/>
<div class="content-main">
<h2>게시판 목록</h2>
<form id="search_form" action="list.do" method="get">
<ul class="search">
<li>
<select name="keyfield">
<option value="1" <c:if test="${param.keyfield == 1}">selected</c:if>>제목</option>
<option value="2" <c:if test="${param.keyfield == 2}">selected</c:if>>작성자</option>
<option value="3" <c:if test="${param.keyfield == 3}">selected</c:if>>내용</option>
</select>
</li>
<li>
<input type="search" size="16" name="keyword"
id="keyword" value="${param.keyword}">
</li>
<li>
<input type="submit" value="검색">
</li>
</ul>
</form>
<div class="list-space align-right">
<input type="button" value="글쓰기"
onclick="location.href='writeForm.do'"
<c:if test="${empty user_num}">disabled="disabled"</c:if>
>
<input type="button" value="목록"
onclick="location.href='list.do'">
<input type="button" value="홈으로"
onclick="location.href='${pageContext.request.contextPath}/main/main.do'">
</div>
<c:if test="${count == 0}">
<div class="result-display">
표시할 게시물이 없습니다.
</div>
</c:if>
<c:if test="${count > 0}">
<table>
<tr>
<th>글번호</th>
<th>제목</th>
<th>작성자</th>
<th>작성일</th>
<th>조회</th>
</tr>
<c:forEach var="board" items="${list}">
<tr>
<td>${board.board_num}</td>
<td><a href="detail.do?board_num=${board.board_num}">${board.title}</a></td>
<td>${board.id}</td>
<td>${board.reg_date}</td>
<td>${board.hit}</td>
</tr>
</c:forEach>
</table>
<div class="align-center">${page}</div>
</c:if>
</div>
</div>
</body>
</html>글 세부 DAO
//글상세
public BoardVO getBoard(int board_num)throws Exception{
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
BoardVO board = null;
String sql = null;
try {
//커넥션풀로부터 커넥션 할당
conn = DBUtil.getConnection();
//SQL문 작성
//(주의)회원 탈퇴하면 zmember_detail의 레코드를 지우기 때문에
//조인시 데이터 누락 방지를 위해 OUTER JOIN을 사용함
sql = "SELECT * FROM zboard JOIN zmember USING(mem_num) "
+ "LEFT OUTER JOIN zmember_detail USING(mem_num) "
+ "WHERE board_num=?";
//PreparedStatement 객체 생성
pstmt = conn.prepareStatement(sql);
//?에 데이터 바인딩
pstmt.setInt(1, board_num);
//SQL문 실행
rs = pstmt.executeQuery();
if(rs.next()) {
board = new BoardVO();
board.setBoard_num(rs.getInt("board_num"));
//수정폼에서도 동일 코드를 사용하기 때문에 StringUtil를 명시하지 않음
board.setTitle(rs.getString("title"));
//수정폼에서도 동일 코드를 사용하기 때문에 StringUtil를 명시하지 않음
board.setContent(rs.getString("content"));
board.setHit(rs.getInt("hit"));
board.setReg_date(rs.getDate("reg_date"));
board.setModify_date(rs.getDate("modify_date"));
board.setFilename(rs.getString("filename"));
//로그인한 회원번호와 조건 체크를 해야 하기 때문에 mem_num이 필요함
board.setMem_num(rs.getInt("mem_num"));
board.setId(rs.getString("id"));
board.setPhoto(rs.getString("photo"));
}
}catch(Exception e) {
throw new Exception(e);
}finally {
DBUtil.executeClose(rs, pstmt, conn);
}
return board;
}String Util
package kr.util;
public class StringUtil {
//HTML 태그를 허용하면서 줄바꿈
public static String useBrHtml(String str) {
if(str == null) return null;
return str.replaceAll("\r\n", "<br>")
.replaceAll("\r", "<br>")
.replaceAll("\n", "<br>");
}
//HTML 태그를 허용하지 않으면서 줄바꿈
public static String useBrNoHTML(String str) {
if(str == null) return null;
return str.replaceAll("<", "<")
.replaceAll(">", ">")
.replaceAll("\r\n", "<br>")
.replaceAll("\r", "<br>")
.replaceAll("\n", "<br>");
}
//HTML를 허용하지 않음
public static String useNoHTML(String str) {
if(str == null) return null;
return str.replaceAll("<", "<").replaceAll(">", ">");
}
}
글 세부 Action
package kr.board.action;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import kr.board.dao.BoardDAO;
import kr.board.vo.BoardVO;
import kr.controller.Action;
import kr.util.StringUtil;
public class DetailAction implements Action{
@Override
public String execute(HttpServletRequest request, HttpServletResponse response) throws Exception {
//글번호 반환
int board_num = Integer.parseInt(
request.getParameter("board_num"));
BoardDAO dao = BoardDAO.getInstance();
//조회수 증가
dao.updateReadcount(board_num);
BoardVO board = dao.getBoard(board_num);
//HTML를 허용하지 않음
board.setTitle(StringUtil.useNoHTML(board.getTitle()));
//HTML를 허용하지 않으면서 줄바꿈
board.setContent(StringUtil.useBrNoHTML(board.getContent()));
request.setAttribute("board", board);
return "/WEB-INF/views/board/detail.jsp";
}
}글 세부 View
<%@ 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>
<html>
<head>
<meta charset="UTF-8">
<title>글상세</title>
<link rel="stylesheet" href="${pageContext.request.contextPath}/css/style.css" type="text/css">
</head>
<body>
<div class="page-main">
<jsp:include page="/WEB-INF/views/common/header.jsp"/>
<div class="content-main">
<h2>${board.title}</h2>
<ul class="detail-info">
<li>
<c:if test="${!empty board.photo}">
<img src="${pageContext.request.contextPath}/upload/${board.photo}"
width="40" height="40" class="my-photo">
</c:if>
<c:if test="${empty board.photo}">
<img src="${pageContext.request.contextPath}/images/face.png"
width="40" height="40" class="my-photo">
</c:if>
</li>
<li>
${board.id}<br>
조회 : ${board.hit}
</li>
</ul>
<hr size="1" noshade="noshade" width="100%">
<c:if test="${!empty board.filename}">
<div class="align-center">
<img src="${pageContext.request.contextPath}/upload/${board.filename}" class="detail-img">
</div>
</c:if>
<p>
${board.content}
</p>
<hr size="1" noshade="noshade" width="100%">
<ul class="detail-sub">
<li>
<%-- 좋아요 --%>
<img>
좋아요
<span id="output_fcount"></span>
</li>
<li>
<c:if test="${!empty board.modify_date}">
최근 수정일 : ${board.modify_date}
</c:if>
작성일 : ${board.reg_date}
<%-- 로그인한 회원번호와 작성자 회원번호가 일치해야 수정,삭제 가능 --%>
<c:if test="${user_num == board.mem_num}">
<input type="button" value="수정"
onclick="location.href='updateForm.do?board_num=${board.board_num}'">
<input type="button" value="삭제" id="delete_btn">
<script type="text/javascript">
const delete_btn = document.getElementById('delete_btn');
//이벤트 연결
delete_btn.onclick=function(){
let choice = confirm('삭제하시겠습니까?');
if(choice){
location.replace('delete.do?board_num=${board.board_num}');
}
};
</script>
</c:if>
</li>
</ul>
</div>
</div>
</body>
</html>조회수 증가 DAO
//조회수 증가
public void updateReadcount(int board_num)
throws Exception{
Connection conn = null;
PreparedStatement pstmt = null;
String sql = null;
try {
//커넥션풀로부터 커넥션 할당
conn = DBUtil.getConnection();
//SQL문 작성
sql = "UPDATE zboard SET hit=hit+1 WHERE board_num=?";
//PreparedStatement 객체 생성
pstmt = conn.prepareStatement(sql);
//?에 데이터 바인딩
pstmt.setInt(1, board_num);
//SQL문 실행
pstmt.executeUpdate();
}catch(Exception e) {
throw new Exception(e);
}finally {
DBUtil.executeClose(null, pstmt, conn);
}
}Properties - Board
/board/writeForm.do=kr.board.action.WriteFormAction
/board/write.do=kr.board.action.WriteAction
/board/detail.do=kr.board.action.DetailAction
Lucky Things🍀