์ด๋ฒ ์ฅ์์๋ ๊ธ์ฐ๊ธฐ ์์๊ณผ DB์ ์ ๋ฌํ๋ ์ฝ๋๋ฅผ ์์ฑํ๋ค.
1. ๊ธ์ฐ๊ธฐ ํผ ์์ฑ
* write.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.io.PrintWriter" %>
<!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">
<meta name="viewport" content="width=device-width", initial-scale="1" > <!-- ๋ฐ์ํ ์น์ ์ฌ์ฉํ๋ ๋ฉํํ๊ทธ -->
<link rel="stylesheet" href="css/bootstrap.css"> <!-- ์ฐธ์กฐ -->
<title>JSP ๊ฒ์ํ ์น ์ฌ์ดํธ</title>
</head>
<body>
<%
String userID = null;
if(session.getAttribute("userID") != null){
userID = (String) session.getAttribute("userID");
}
%>
<nav class ="navbar navbar-default">
<div class="navbar-header"> <!-- ํํ์ด์ง์ ๋ก๊ณ -->
<button type="button" class="navbar-toggle collapsed"
data-toggle="collapse" data-target="#bs-example-navbar-collapse-1"
aria-expand="false">
<span class ="icon-bar"></span> <!-- ์ค์์๋ ์์ ์ง๋๊ธฐ -->
<span class ="icon-bar"></span>
<span class ="icon-bar"></span>
</button>
<a class ="navbar-brand" href="main.jsp">JSP ๊ฒ์ํ ์น ์ฌ์ดํธ</a>
</div>
<div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
<ul class="nav navbar-nav">
<li ><a href="main.jsp">๋ฉ์ธ</a></li>
<li class="active"><a href="bbs.jsp">๊ฒ์ํ</a></li>
</ul>
<%
if(userID == null){
%>
<ul class="nav navbar-nav navbar-right">
<li class="dropdown">
<a href="#" class = "dropdown-toggle"
data-toggle="dropdown" role ="button"
aria-haspopup="true"
aria-expanded="false">์ ์ํ๊ธฐ<span class="caret"></span></a>
<ul class="dropdown-menu">
<li><a href="login.jsp">๋ก๊ทธ์ธ</a></li>
<li><a href="join.jsp">ํ์๊ฐ์
</a></li>
</ul>
</li>
</ul>
<%
} else {
%>
<ul class="nav navbar-nav navbar-right">
<li class="dropdown">
<a href="#" class = "dropdown-toggle"
data-toggle="dropdown" role ="button"
aria-haspopup="true"
aria-expanded="false">ํ์๊ด๋ฆฌ<span class="caret"></span></a>
<ul class="dropdown-menu">
<li><a href="logoutAction.jsp">๋ก๊ทธ์์</a></li>
</ul>
</li>
</ul>
<%
}
%>
</div>
</nav>
<div class="container">
<div class="row">
<form method="post" action="writeAction.jsp">
<table class="table table-striped" style="text-align:center; border:1px solid #dddddd">
<thead>
<tr>
<th colspan="2" style="background-color:#eeeeee; text-align:center;">๊ฒ์ํ ๊ธ์ฐ๊ธฐ ์์</th>
</tr>
</thead>
<tbody>
<tr>
<td><input type="text" class="form-control" placeholder="๊ธ ์ ๋ชฉ" name="bbsTitle" maxlength="50" ></td>
</tr>
<tr>
<td><textarea class="form-control" placeholder="๊ธ ๋ด์ฉ" name="bbsContent" maxlength="2048" style="height:350px" ></textarea></td>
</tr>
</tbody>
</table>
<input type="submit" class="btn btn-primary pull-right" value="๊ธ์ฐ๊ธฐ">
</form>
</div>
</div>
<script src="https://code.jquery.com/jquery-3.1.1.min.js"></script>
<script src="js/bootstrap.js"></script>
</body>
</html>
๊ธฐ์กด bbs.jsp ํ์ผ์ ๋ณต์ฌํด ํ๋จ ๋ถ๋ถ๋ง ์์ ํ์๋ค.
๊ฒฐ๊ณผ ํ๋ฉด
์ด์ ํด๋น ํ๋ฉด์ ๊ธ์ฐ๊ธฐ ์์์ ์์ฑํ ๋ด์ฉ์ DB์ ์ ๋ฌํ๋๋ก ํ ๊ฒ์ด๋ค.
2. ๊ธ์ฐ๊ธฐ ํผ ๋ด์ฉ DB์ ์ ๋ฌ
* writeAction.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="bbs.BbsDAO" %>
<%@ page import="java.io.PrintWriter" %>
<% request.setCharacterEncoding("UTF-8"); %>
<jsp:useBean id="bbs" class="bbs.Bbs" scope="page"/>
<jsp:setProperty name="bbs" property="bbsTitle"/>
<jsp:setProperty name="bbs" property="bbsContent" />
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>JSP ๊ฒ์ํ ์น ์ฌ์ดํธ</title>
</head>
<body>
<%
String userID = null;
if(session.getAttribute("userID")!=null){
userID=(String)session.getAttribute("userID");
}
if(userID==null){
PrintWriter script=response.getWriter();
script.println("<script>");
script.println("alert('๋ก๊ทธ์ธ์ ํ์ธ์.')");
script.println("location.href='login.jsp'");
script.println("</script>");
}
else{
if(bbs.getBbsTitle()==null||bbs.getBbsContent()==null){
PrintWriter script=response.getWriter();
script.println("<script>");
script.println("alert('์
๋ ฅ์ด ์ ๋ ์ฌํญ์ด ์์ต๋๋ค.')");
script.println("history.back()");
script.println("</script>");
}else{
BbsDAO bbsDAO=new BbsDAO();//ํ๋์ ์ธ์คํด์ค
int result=bbsDAO.write(bbs.getBbsTitle(),userID,bbs.getBbsContent());
if(result == -1){//๋ฐ์ดํฐ ๋ฒ ์ด์ค ์ค๋ฅ๊ฐ ๋ ๋
PrintWriter script=response.getWriter();
script.println("<script>");
script.println("alert('๊ธ์ฐ๊ธฐ์ ์คํจํ์ต๋๋ค.')");
script.println("history.back()");
script.println("</script>");
}
else{
PrintWriter script=response.getWriter();
script.println("<script>");
script.println("location.href='bbs.jsp'");
script.println("</script>");
}
}
}
%>
</body>
</html>ํ ์คํธ์ฉ ๊ฒ์๊ธ์ ๋ฑ๋กํ๋ฉด
์ ์์ ์ผ๋ก DB์ ์ ๋ฌ๋จ.
