Dev/JSP & Servlet

JSP 게시판(3) - JSP 페이지

창문닦이 2019. 2. 25. 16:44

게시판 작성 페이지(created.jsp)

created.jsp

<%@ page contentType="text/html; charset=UTF-8"%>

<%

request.setCharacterEncoding("UTF-8");

String cp = request.getContextPath();

%>

<!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>

<link rel="stylesheet" href="<%=cp %>/board/css/style.css" type="text/css" />

<link rel="stylesheet" href="<%=cp %>/board/css/created.css" type="text/css" />

<script type="text/javascript" src="<%=cp %>/board/js/util.js"></script>

<script type="text/javascript" >

function sendIt(){

f = document.myForm;

str = f.subject.value;

str = str.trim();//util.js에 있는 trim함수 호출

if(!str){

alert("\n제목을 입력하세요.");//공백제거후 내용이 없으면

f.subject.focus();

return;

}

f.subject.value = str;

str = f.name.value;

str = str.trim();

if(!str){

alert("\n이름을 입력하세요.");

f.name.focus();

return;

}

f.name.value = str;

//이름 한글검사

if(!isValidKorean(str)){

alert("\n이름을 정확히 입력하세요.");

f.name.focus();

return;

}

if(f.email.value){

if(!isValidEmail(f.email.value)){

alert("\n정상적인 E-mail을 입력하세요");

f.email.focus();

return;

}

}

str = f.content.value;

str = str.trim();

if(!str){

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

f.content.focus();

return;

}

f.content.value = str;

str = f.pwd.value;

str = str.trim();

if(!str){

alert("\n패스워드를 입력하세요.");

f.pwd.focus();

return;

}

f.pwd.value = str;

f.action = "<%=cp %>/board/created_ok.jsp";

f.submit();

}

</script>

</head>

<body>

<div id="bbs" >

<div id="bbs_title">

게 시 판(JSP)

</div>

<form action="" name="myForm" method="post">

<div id="bbsCreated">

<div class="bbsCreated_bottomLine">

<dl>

<dt>제&nbsp;&nbsp;&nbsp;&nbsp;목</dt>

<dd>

<input type="text" name="subject" size="74" maxlength="100" class="boxTF"/>

</dd>

</dl>

</div>

<div class="bbsCreated_bottomLine">

<dl>

<dt>작성자</dt>

<dd>

<input type="text" name="name" size="35" maxlength="20" class="boxTF"/>

</dd>

</dl>

</div>

<div class="bbsCreated_bottomLine">

<dl>

<dt>E-Mail</dt>

<dd>

<input type="text" name="email" size="35" maxlength="50" class="boxTF"/>

</dd>

</dl>

</div>

<div id="bbsCreated_content">

<dl>

<dt>내&nbsp;&nbsp;&nbsp;&nbsp;용</dt>

<dd>

<textarea rows="12" cols="63" name="content" class="boxTA"></textarea>

</dd>

</dl>

</div>

<div class="bbsCreated_noLine">

<dl>

<dt>패스워드</dt>

<dd>

<input type="password" name="pwd" size="35" maxlength="7" class="boxTF"/>

&nbsp;(게시물 수정 및 삭제시 필요)

</dd>

</dl>

</div>

</div>

<div id="bbsCreated_footer">

<input type="button" value="등록하기" class="btn2" onclick="sendIt()" />

<input type="reset" value="다시입력" class="btn2" onclick="document.myForm.subject.focus();" />

<input type="button" value="작성취소" class="btn2" onclick="javascript:location.href='<%=cp %>/board/list.jsp';"/>

</div>

</form>

</div>

</body>

</html>

게시판 작성 페이지_(DAO실행)(created_ok.jsp)

created_ok.jsp

<%@page import="com.board.BoardDAO"%>

<%@page import="com.util.DBConn"%>

<%@page import="java.sql.Connection"%>

<%@ page contentType="text/html; charset=UTF-8"%>

<%

request.setCharacterEncoding("UTF-8");

String cp = request.getContextPath();

%>

<jsp:useBean id="dto" class="com.board.BoardDTO" scope="page"></jsp:useBean>

<jsp:setProperty property="*" name="dto"/>

<%

Connection conn = DBConn.getConnection();

BoardDAO dao = new BoardDAO(conn);

int maxNum = dao.getMaxNum();

dto.setNum(maxNum+1);

dto.setIpAddr(request.getRemoteAddr());

dao.insertData(dto);

DBConn.close();

response.sendRedirect("list.jsp");

%>

게시판 삭제 페이지_(DAO실행)(deleted_ok.jsp)

deleted_ok.jsp

<%@page import="java.net.URLEncoder"%>

<%@page import="java.net.URLDecoder"%>

<%@page import="com.board.BoardDAO"%>

<%@page import="com.util.DBConn"%>

<%@page import="java.sql.Connection"%>

<%@ page contentType="text/html; charset=UTF-8"%>

<%

request.setCharacterEncoding("UTF-8");

String cp = request.getContextPath();

int num = Integer.parseInt(request.getParameter("num"));

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

Connection conn = DBConn.getConnection();

BoardDAO dao = new BoardDAO(conn);

dao.deleteData(num);

//검색키와 값

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

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

if(searchValue!=null){

if(request.getMethod().equalsIgnoreCase("GET")){

searchValue = URLDecoder.decode(searchValue,"UTF-8");

}

}else{

searchKey="subject";

searchValue = "";

}

String param = "";

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

param = "&searchKey="+searchKey;

param+= "&searchValue=" + URLEncoder.encode(searchValue, "UTF-8");

}

DBConn.close();

response.sendRedirect("list.jsp?pageNum="+pageNum+param);

%>

게시판 수정 페이지(update.jsp)

update.jsp

<%@page import="java.net.URLEncoder"%>

<%@page import="java.net.URLDecoder"%>

<%@page import="com.board.BoardDTO"%>

<%@page import="com.board.BoardDAO"%>

<%@page import="com.util.DBConn"%>

<%@page import="java.sql.Connection"%>

<%@ page contentType="text/html; charset=UTF-8"%>

<%

request.setCharacterEncoding("UTF-8");

String cp = request.getContextPath();

//수정취소 선택시 보고있던 리스트 페이지로 호출하기위해서 pageNum이 필요

int num = Integer.parseInt(request.getParameter("num"));

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

Connection conn = DBConn.getConnection();

BoardDAO dao = new BoardDAO(conn);

BoardDTO dto = dao.getReadData(num);

//검색키와 값

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

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

if(searchValue!=null){

if(request.getMethod().equalsIgnoreCase("GET")){

searchValue = URLDecoder.decode(searchValue,"UTF-8");

}

}else{

searchKey="subject";

searchValue = "";

}

String param = "";

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

param = "&searchKey="+searchKey;

param+= "&searchValue=" + URLEncoder.encode(searchValue, "UTF-8");

}

DBConn.close();

//검증

if(dto==null)

response.sendRedirect("list.jsp");

%>

<!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>

<link rel="stylesheet" href="<%=cp %>/board/css/style.css" type="text/css" />

<link rel="stylesheet" href="<%=cp %>/board/css/created.css" type="text/css" />

<script type="text/javascript" src="<%=cp %>/board/js/util.js"></script>

<script type="text/javascript" >

function sendIt(){

f = document.myForm;

str = f.subject.value;

str = str.trim();//util.js에 있는 trim함수 호출

if(!str){

alert("\n제목을 입력하세요.");//공백제거후 내용이 없으면

f.subject.focus();

return;

}

f.subject.value = str;

str = f.name.value;

str = str.trim();

if(!str){

alert("\n이름을 입력하세요.");

f.name.focus();

return;

}

f.name.value = str;

//이름 한글검사

if(!isValidKorean(str)){

alert("\n이름을 정확히 입력하세요.");

f.name.focus();

return;

}

if(f.email.value){

if(!isValidEmail(f.email.value)){

alert("\n정상적인 E-mail을 입력하세요");

f.email.focus();

return;

}

}

str = f.content.value;

str = str.trim();

if(!str){

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

f.content.focus();

return;

}

f.content.value = str;

str = f.pwd.value;

str = str.trim();

if(!str){

alert("\n패스워드를 입력하세요.");

f.pwd.focus();

return;

}

f.pwd.value = str;

var temp = '<%=dto.getPwd() %>';

if(str!=temp){

alert("\n패스워드가 일치하지 않습니다.");

f.pwd.focus();

return;

}

f.action = "<%=cp %>/board/updated_ok.jsp";

f.submit();

}

</script>

</head>

<body>

<div id="bbs" >

<div id="bbs_title">

게 시 판(JSP)

</div>

<form action="" name="myForm" method="post">

<div id="bbsCreated">

<div class="bbsCreated_bottomLine">

<dl>

<dt>제&nbsp;&nbsp;&nbsp;&nbsp;목</dt>

<dd>

<input type="text" name="subject" value="<%=dto.getSubject() %>" size="74" maxlength="100"

class="boxTF"/>

</dd>

</dl>

</div>

<div class="bbsCreated_bottomLine">

<dl>

<dt>작성자</dt>

<dd>

<input ty pe="text" name="name" value="<%=dto.getName() %>" size="35" maxlength="20"

class="boxTF"/>

</dd>

</dl>

</div>

<div class="bbsCreated_bottomLine">

<dl>

<dt>E-Mail</dt>

<dd><input type="text" name="email" value="<%=dto.getEmail()==null?"":dto.getEmail()%>" size="35"

maxlength="50" class="boxTF"/>

</dd>

</dl>

</div>

<div id="bbsCreated_content">

<dl>

<dt>내&nbsp;&nbsp;&nbsp;&nbsp;용</dt>

<dd>

<textarea rows="12" cols="63" name="content" class="boxTA"><%=dto.getContent() %></textarea>

</dd>

</dl>

</div>

<div class="bbsCreated_noLine">

<dl>

<dt>패스워드</dt>

<dd>

<input type="password" name="pwd" size="35" maxlength="7" class="boxTF"/>

&nbsp;(게시물 수정 및 삭제시 필요)

</dd>

</dl>

</div>

</div>

<div id="bbsCreated_footer">

<input type="hidden" name="num" value="<%=dto.getNum()%>" />

<input type="hidden" name="pageNum" value="<%=pageNum %>" />

<input type="hidden" name="searchKey" value="<%=searchKey %>"/>

<input type="hidden" name="searchValue" value="<%=searchValue %>"/>

<input type="button" value="수정하기" class="btn2"

onclick="sendIt()" />

<input type="button" value="수정취소" class="btn2"

onclick="javascript:location.href='<%=cp %>/board/list.jsp?pageNum=<%=pageNum %><%=param %>';"/>

</div>

</form>

</div>

</body>

</html>

게시판 수정 페이지_(DAO실행)(updated_ok.jsp)

updated_ok.jsp

<%@page import="java.net.URLEncoder"%>

<%@page import="java.net.URLDecoder"%>

<%@page import="com.board.BoardDAO"%>

<%@page import="com.util.DBConn"%>

<%@page import="java.sql.Connection"%>

<%@ page contentType="text/html; charset=UTF-8"%>

<%

request.setCharacterEncoding("UTF-8");

String cp = request.getContextPath();

%>

<jsp:useBean id="dto" class="com.board.BoardDTO" scope="page"/>

<jsp:setProperty property="*" name="dto"/>

<%

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

Connection conn = DBConn.getConnection();

BoardDAO dao = new BoardDAO(conn);

dao.updateData(dto);

//검색키와 값

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

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

if(searchValue!=null){

if(request.getMethod().equalsIgnoreCase("GET")){

searchValue = URLDecoder.decode(searchValue,"UTF-8");

}

}else{

searchKey="subject";

searchValue = "";

}

String param = "";

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

param = "&searchKey="+searchKey;

param+= "&searchValue=" + URLEncoder.encode(searchValue, "UTF-8");

}

DBConn.close();

response.sendRedirect("list.jsp?pageNum="+pageNum+param);

%>

게시글 조회 페이지_(DAO실행)(article.jsp)

article.jsp

<%@page import="java.net.URLEncoder"%>

<%@page import="java.net.URLDecoder"%>

<%@page import="com.board.BoardDTO"%>

<%@page import="com.board.BoardDAO"%>

<%@page import="com.util.DBConn"%>

<%@page import="java.sql.Connection"%>

<%@ page contentType="text/html; charset=UTF-8"%>

<%

request.setCharacterEncoding("UTF-8");

String cp = request.getContextPath();

int num = Integer.parseInt(request.getParameter("num"));

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

//검색키와 값

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

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

if(searchValue!=null){

if(request.getMethod().equalsIgnoreCase("GET")){

searchValue = URLDecoder.decode(searchValue,"UTF-8");

}

}else{

searchKey="subject";

searchValue = "";

}

Connection conn = DBConn.getConnection();

BoardDAO dao = new BoardDAO(conn);

//조회수 증가

dao.updateHitCount(num);

//글가져오기

BoardDTO dto = dao.getReadData(num);

if(dto==null){

response.sendRedirect("list.jsp");

}

//글 라인 수

int lineSu = dto.getContent().split("\n").length;

//글 내용의 엔터를 <br/>로 변경

dto.setContent(dto.getContent().replaceAll("\n", "<br/>"));

String param = "";

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

param = "&searchKey="+searchKey;

param+= "&searchValue=" + URLEncoder.encode(searchValue, "UTF-8");

}

DBConn.close();

%>

<!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>

<link rel="stylesheet" href="<%=cp %>/board/css/style.css" type="text/css" />

<link rel="stylesheet" href="<%=cp %>/board/css/article.css" type="text/css" />

</head>

<body>

<div id="bbs">

<div id="bbs_title">

게 시 판

</div>

<div id="bbsArticle">

<div id="bbsArticle_header">

<%=dto.getSubject() %>

</div>

<div class="bbsArticle_bottomLine">

<dl>

<dt>작성자</dt>

<dd><%=dto.getName() %></dd>

<dt>줄수</dt>

<dd><%=lineSu %></dd>

</dl>

</div>

<div class="bbsArticle_bottomLine">

<dl>

<dt>등록일</dt>

<dd><%=dto.getCreated() %></dd>

<dt>조회수</dt>

<dd><%=dto.getHitCount() %></dd>

</dl>

</div>

<div id="bbsArticle_content">

<table width="600" border="0">

<tr>

<td style="padding: 20px 80px 20px 62px;" valign="top" height="200">

<%=dto.getContent() %>

</td>

</tr>

</table>

</div>

</div>

<div class="bbsArticle_noLine" style="text-align: right;">

from <%=dto.getIpAddr() %>

</div>

<div id="bbsArticle_footer">

<div id="leftFooter">

<input type="button" value=" 수정 " class="btn2" onclick="javascript:location.href='<%=cp %>/board/update.jsp?num=<%=dto.getNum() %>&pageNum=<%=pageNum %><%=param %>';" />

<input type="button" value=" 삭제 " class="btn2" onclick="javascript:location.href='<%=cp %>/board/deleted_ok.jsp?num=<%=dto.getNum() %>&pageNum=<%=pageNum %><%=param %>';" />

</div>

<div id="rightFooter">

<input type="button" value=" 리스트 " class="btn2" onclick="javascript:location.href='<%=cp %>/board/list.jsp?pageNum=<%=pageNum %><%=param %>';" />

</div>

</div>

</div>

</body>

</html>


저작자표시 비영리 변경금지

'Dev > JSP & Servlet' 카테고리의 다른 글

Servlet - 게시판 만들기  (0) 2019.02.26
Servlet - 서블릿 구조, EL, JSTL, DBCP  (0) 2019.02.25
JSP 게시판(2) - DTO, DAO 생성  (0) 2019.02.25
JSP 게시판 (1) - 페이징, 리스트페이지  (0) 2019.02.21
JSP - 성적처리 페이지 만들기  (0) 2019.02.19

'Dev/JSP & Servlet'의 다른글

  • 현재글JSP 게시판(3) - JSP 페이지

관련글

댓글

티스토리툴바