0.파일 구조
/src
├── Libraries
│ └── user
│ └── User.java
│ └── UserDAO.java
│ └── bbs
│ └── Bbs.java
│ └── BbsDAO.java
/src/main/webapp
├── META-INF
│ └── MANIFEST.MF
├── WEB-INF
│ └── web.xml
│ └── lib
├── css/
├── fonts/
├── js/
├── bbs.jsp
├── main.jsp
├── index.jsp
├── login.jsp
├── loginAction.jsp
├── logoutAction.jsp
├── join.jsp
├── joinAction.jsp
├── write.jsp
├── writeAction.jsp
└── index.jsp1.글 목록 리스트로 가져오기
BbsDAO.java 기능 추가 구현
DAO: Database Access Object의 약자, 실질적으로 데이터베이스와 소통하는 부분을 담당합니다.
DAO를 통해 데이터베이스에 접근하여 INSERT 구문을 통해 회원가입 쿼리를 수행하고, 결과를 반환하는 코드를 추가할 것입니다.
①추가할 코드1: getList
저장된 글 목록(BbsID, BbsTitle, UserID, BbsDate, BbsContent, BbsAvailable)을 가져오는 코드입니다.
...
public ArrayList<Bbs> getList(int pageNumber) {
String SQL = "SELECT * FROM (SELECT * FROM BBS WHERE bbsID < ? AND bbsAvailable = 1 ORDER BY bbsID DESC) WHERE ROWNUM <= 10";
ArrayList<Bbs> list = new ArrayList<Bbs>();
try {
PreparedStatement pstmt = conn.prepareStatement(SQL);
pstmt.setInt(1, getNext() - (pageNumber - 1) * 10);
rs = pstmt.executeQuery();
while (rs.next()) {
Bbs bbs = new Bbs();
bbs.setBbsID(rs.getInt(1));
bbs.setBbsTitle(rs.getString(2));;
bbs.setUserID(rs.getString(3));
bbs.setBbsDate(rs.getString(4));
bbs.setBbsContent(rs.getString(5));
bbs.setBbsAvailable(rs.getInt(6));
list.add(bbs);
}
} catch (Exception e) {
e.printStackTrace();
}
return list;
}
...
②추가할 코드2: nextPage
한 페이지에 10개의 게시물 목록을 출력할 것이므로, 이를 조정하기 위한 코드입니다.
만약 현재 인덱스 이후 게시물이 존재하지 않는다면 False를 반환하도록 하였습니다.
...
public boolean nextPage(int pageNumber) {
String SQL = "SELECT * FROM BBS WHERE bbsID < ? AND bbsAvailable = 1";
try {
PreparedStatement pstmt = conn.prepareStatement(SQL);
pstmt.setInt(1, getNext() - (pageNumber - 1) * 10);
rs = pstmt.executeQuery();
if (rs.next()) {
return true;
}
} catch (Exception e) {
e.printStackTrace();
}
return false;
}
}
...
bbs.jsp 기능 추가 구현
위 BbsDAO에서 추가로 구현한 두 가지 기능에서 처리한 데이터를 가져와야 하므로, 몇 가지 코드를 추가해야 합니다.
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.io.PrintWriter" %>
<%@ page import="bbs.BbsDAO" %>
<%@ page import="bbs.Bbs" %>
<%@ page import="java.util.ArrayList" %>
<!DOCTYPE html>
<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 Board</title>
</head>
<style type="text/css">
a, a:hover {
color: #000000;
text-decoration: none;
}
</style>
<body>
<%
String userID = null;
if (session.getAttribute("userID") != null) {
userID = (String) session.getAttribute("userID");
}
int pageNumber = 1;
if (request.getParameter("pageNumber") != null){
pageNumber = Integer.parseInt(request.getParameter("pageNumber"));
}
%>
<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-expanded="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 Board</a>
</div>
<div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
<ul class="nav navbar-nav">
<li><a href="main.jsp">Main</a>
<li class="active"><a href="bbs.jsp">Board</a>
</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">Access<span class="caret"></span></a>
<ul class="dropdown-menu">
<li><a href="login.jsp">Login</a></li>
<li><a href="join.jsp">Sign up</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">My page<span class="caret"></span></a>
<ul class="dropdown-menu">
<li><a href="logoutAction.jsp">Logout</a></li>
</ul>
</li>
</ul>
<%
}
%>
</div>
</nav>
<div class="container">
<div class="row">
<table class="table table-striped" style="text-align: center; border: 1px solid #dddddd">
<thead>
<tr>
<th style="background-color: #eeeeee; text-align: center;">No</th>
<th style="background-color: #eeeeee; text-align: center;">Title</th>
<th style="background-color: #eeeeee; text-align: center;">Author</th>
<th style="background-color: #eeeeee; text-align: center;">Date</th>
</tr>
</thead>
<tbody>
<%
BbsDAO bbsDAO = new BbsDAO();
ArrayList<Bbs> list = bbsDAO.getList(pageNumber);
for(int i=0; i<list.size(); i++) {
%>
<tr>
<td><%= list.get(i).getBbsID() %></td>
<td><a href="view.jsp?bbsID=<%= list.get(i).getBbsID() %>"><%= list.get(i).getBbsTitle() %></td>
<td><%= list.get(i).getUserID() %></td>
<td><%= list.get(i).getBbsDate().substring(0,11) + list.get(i).getBbsDate().substring(11,13) + ":" + list.get(i).getBbsDate().substring(14,16) %></td>
</tr>
<%
}
%>
</tbody>
</table>
<%
if(pageNumber != 1) {
%>
<a href="bbs.jsp?pageNumber=<%=pageNumber - 1%>" class="btn btn-success btn-arraw-left">Back</a>
<%
} if(bbsDAO.nextPage(pageNumber+1)) {
%>
<a href="bbs.jsp?pageNumber=<%=pageNumber + 1%>" class="btn btn-success btn-arraw-left">Next</a>
<%
}
%>
<a href="write.jsp" class="btn btn-primary pull-right">Write</a>
</div>
</div>
<script src="https://code.jquery.com/jquery-3.1.1.min.js"></script>
<script src="js/bootstrap.js"></script>
</body>
</html>pageNumber를 기본적으로 1로 설정하고, Get parameter "pageNumber" 값이 존재하는 경우 값을 업데이터하여 pageNumber 변수에 삽입합니다.
pageNumber 변수는 가져올 글 목록을 처리하는 bbsDAO.getList의 인수 "pageNumber"와 인덱싱 기능 bbsDAO.nextPage의 인수 "pageNumber" 두 가지로 사용됩니다.
동작을 확인하면 아래와 같이 글 목록을 볼 수 있으며, 'Next'와 'Back'을 통해 다음/이전 페이지로 이동할 수 있음을 알 수 있습니다.
2.글 보기
BbsDAO.java 기능 추가 구현
DAO: Database Access Object의 약자, 실질적으로 데이터베이스와 소통하는 부분을 담당합니다.
①추가할 코드1: getBbs
저장된 글 목록(BbsID, BbsTitle, UserID, BbsDate, BbsContent, BbsAvailable)을 가져와 각각의 글 페이지에서 출력하는 기능을 담당합니다.
...
public Bbs getBbs(int bbsID) {
String SQL = "SELECT * FROM BBS WHERE bbsID = ?";
try {
PreparedStatement pstmt = conn.prepareStatement(SQL);
pstmt.setInt(1, bbsID);
rs = pstmt.executeQuery();
if (rs.next()) {
Bbs bbs = new Bbs();
bbs.setBbsID(rs.getInt(1));
bbs.setBbsTitle(rs.getString(2));;
bbs.setUserID(rs.getString(3));
bbs.setBbsDate(rs.getString(4));
bbs.setBbsContent(rs.getString(5));
bbs.setBbsAvailable(rs.getInt(6));
return bbs;
}
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
...
view.jsp
①webapp 에서 'New' - 'jsp' - Filename에 'view.jsp' 입력
②코드 구성
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.io.PrintWriter" %>
<%@ page import="bbs.Bbs" %>
<%@ page import="bbs.BbsDAO" %>
<!DOCTYPE html>
<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 Board</title>
</head>
<body>
<%
String userID = null;
if (session.getAttribute("userID") != null) {
userID = (String) session.getAttribute("userID");
}
int bbsID = 0;
if (request.getParameter("bbsID") != null) {
bbsID = Integer.parseInt(request.getParameter("bbsID"));
}
if (bbsID == 0) {
PrintWriter script = response.getWriter();
script.println("<script>");
script.println("alert('Invalid page.')");
script.println("location.href='bbs.jsp'");
script.println("</script>");
}
Bbs bbs = new BbsDAO().getBbs(bbsID);
%>
<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-expanded="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 Board</a>
</div>
<div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
<ul class="nav navbar-nav">
<li><a href="main.jsp">Main</a>
<li class="active"><a href="bbs.jsp">Board</a>
</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">Access<span class="caret"></span></a>
<ul class="dropdown-menu">
<li><a href="login.jsp">Login</a></li>
<li><a href="join.jsp">Sign up</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">My page<span class="caret"></span></a>
<ul class="dropdown-menu">
<li><a href="logoutAction.jsp">Logout</a></li>
</ul>
</li>
</ul>
<%
}
%>
</div>
</nav>
<div class="container">
<div class="row">
<table class="table table-striped" style="text-align: center; border: 1px solid #dddddd">
<thead>
<tr>
<th colspan="3" style="background-color: #eeeeee; text-align: center;">Read Board</th>
</tr>
</thead>
<tbody>
<tr>
<td style="width: 20%;">Title</td>
<td colspan="2"><%= bbs.getBbsTitle() %></td>
</tr>
<tr>
<td>Author</td>
<td colspan="2"><%= bbs.getUserID() %></td>
</tr>
<tr>
<td>Date</td>
<td colspan="2"><%= bbs.getBbsDate().substring(0,11) + bbs.getBbsDate().substring(11,13) + ":" + bbs.getBbsDate().substring(14,16) %></td>
</tr>
<tr>
<td>Content</td>
<td colspan="2" style="min-height: 200px; text-align: left;"><%= bbs.getBbsContent().replaceAll(" ", " ").replaceAll("<", "<").replaceAll(">", ">").replaceAll("\n", "<br>") %></td>
</tr>
</tbody>
</table>
<a href="bbs.jsp" class="btn btn-primary">list</a>
<%
if(userID != null && userID.equals(bbs.getUserID())) {
%>
<a href="update.jsp?bbsID=<%= bbsID %>" class="btn btn-primary">Modify</a>
<a onclick="return confirm('Do you want delete?')" href="deleteAction.jsp?bbsID=<%= bbsID %>" class="btn btn-primary">Delete</a>
<%
}
%>
</div>
</div>
<script src="https://code.jquery.com/jquery-3.1.1.min.js"></script>
<script src="js/bootstrap.js"></script>
</body>
</html>
3.글 수정
BbsDAO.java 기능 추가 구현
DAO: Database Access Object의 약자, 실질적으로 데이터베이스와 소통하는 부분을 담당합니다.
①추가할 코드1: update
저장된 글 제목, 내용을 가져와 bbsID로 식별한 후 제목/내용을 업데이트하는 기능입니다.
...
public int update(int bbsID, String bbsTitle, String bbsContent) {
String SQL = "UPDATE BBS SET bbsTitle = ?, bbsContent = ? WHERE bbsID= ?";
try {
PreparedStatement pstmt = conn.prepareStatement(SQL);
pstmt.setString(1, bbsTitle);
pstmt.setString(2, bbsContent);
pstmt.setInt(3, bbsID);
return pstmt.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
}
return -1; // DB Error
}
...
update.jsp
①webapp 에서 'New' - 'jsp' - Filename에 'update.jsp' 입력
②코드 구성
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.io.PrintWriter" %>
<%@ page import="bbs.Bbs" %>
<%@ page import="bbs.BbsDAO" %>
<!DOCTYPE html>
<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 Board</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('Please log in')");
script.println("location.href='login.jsp'");
script.println("</script>");
}
int bbsID = 0;
if (request.getParameter("bbsID") != null) { // Check bbsID is exist.
bbsID = Integer.parseInt(request.getParameter("bbsID"));
}
if (bbsID == 0) { // Check bbsID is valid.
PrintWriter script = response.getWriter();
script.println("<script>");
script.println("alert('Invalid page.')");
script.println("location.href='bbs.jsp'");
script.println("</script>");
}
Bbs bbs = new BbsDAO().getBbs(bbsID);
if (!userID.equals(bbs.getUserID())) { // Check board author is equal requested user.
PrintWriter script = response.getWriter();
script.println("<script>");
script.println("alert('Permission denied')");
script.println("location.href='bbs.jsp'");
script.println("</script>");
}
%>
<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-expanded="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 Board</a>
</div>
<div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
<ul class="nav navbar-nav">
<li><a href="main.jsp">Main</a>
<li class="active"><a href="bbs.jsp">Board</a>
</ul>
<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">My page<span class="caret"></span></a>
<ul class="dropdown-menu">
<li><a href="logoutAction.jsp">Logout</a></li>
</ul>
</li>
</ul>
</div>
</nav>
<div class="container">
<div class="row">
<form method="post" action="updateAction.jsp?bbsID=<%= bbsID %>">
<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;">Board modifying form</th>
</tr>
</thead>
<tbody>
<tr>
<td><input type="text" class="form-control" placeholder="Title" name="bbsTitle" maxlenth="50" value="<%= bbs.getBbsTitle() %>"></td>
</tr>
<tr>
<td><textarea class="form-control" placeholder="Content" name="bbsContent" maxlenth="2048" style="height: 350px;"><%= bbs.getBbsContent() %></textarea></td>
</tr>
</tbody>
</table>
<input type="submit" class="btn btn-primary pull-right" value="Modify">
</form>
</div>
</div>
<script src="https://code.jquery.com/jquery-3.1.1.min.js"></script>
<script src="js/bootstrap.js"></script>
</body>
</html>
updateAction.jsp
①webapp 에서 'New' - 'jsp' - Filename에 'updateAction.jsp' 입력
②코드 구성
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ page import="bbs.BbsDAO" %>
<%@ page import="java.io.PrintWriter" %>
<%@ page import="bbs.Bbs" %>
<%@ page import="bbs.BbsDAO" %>
<% request.setCharacterEncoding("UTF-8"); %>
<!DOCTYPE html>
<html>
<head>
<link rel="stylesheet" href="css/bootstrap.css">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="viewport" content="width=device-width", initial-scale=1.0">
<title>Searcher</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('Please log in.')");
script.println("location.href='login.jsp'");
script.println("</script>");
}
int bbsID = 0;
if (request.getParameter("bbsID") != null) { // Check bbsID is exist.
bbsID = Integer.parseInt(request.getParameter("bbsID"));
}
if (bbsID == 0) { // Check bbsID is valid.
PrintWriter script = response.getWriter();
script.println("<script>");
script.println("alert('Invalid page.')");
script.println("location.href='bbs.jsp'");
script.println("</script>");
}
Bbs bbs = new BbsDAO().getBbs(bbsID);
if (!userID.equals(bbs.getUserID())) { // Check board author is equal requested user.
PrintWriter script = response.getWriter();
script.println("<script>");
script.println("alert('Permission denied')");
script.println("location.href='bbs.jsp'");
script.println("</script>");
} else {
// filtering that user input is null
if (request.getParameter("bbsTitle") == null || request.getParameter("bbsContent") == null || request.getParameter("bbsTitle").equals("")
|| request.getParameter("bbsContent").equals("")) {
PrintWriter script = response.getWriter();
script.println("<script>");
script.println("alert('Please enter all your input.')");
script.println("history.back()");
script.println("</script>");
} else {
BbsDAO bbsDAO = new BbsDAO();
int result = bbsDAO.update(bbsID, request.getParameter("bbsTitle"), request.getParameter("bbsContent"));
if (result == -1) { // Failed to modify
PrintWriter script = response.getWriter();
script.println("<script>");
script.println("alert('Failed to modify')");
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>③동작 확인
4.글 삭제
BbsDAO.java 기능 추가 구현
DAO: Database Access Object의 약자, 실질적으로 데이터베이스와 소통하는 부분을 담당합니다.
①추가할 코드1: delete
bbsAvailable(게시글 사용 가능 여부, 0이면 사용 불가(삭제), 1이면 사용 가능) 값을 0으로 변경합니다.
...
public int delete(int bbsID) {
String SQL = "UPDATE BBS SET bbsAvailable = 0 WHERE bbsID= ?";
try {
PreparedStatement pstmt = conn.prepareStatement(SQL);
pstmt.setInt(1, bbsID);
return pstmt.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
}
return -1; // DB Error
}
}
...
deleteAction.jsp
①webapp 에서 'New' - 'jsp' - Filename에 'deleteAction.jsp' 입력
②코드 구성
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ page import="bbs.BbsDAO" %>
<%@ page import="java.io.PrintWriter" %>
<%@ page import="bbs.Bbs" %>
<%@ page import="bbs.BbsDAO" %>
<% request.setCharacterEncoding("UTF-8"); %>
<!DOCTYPE html>
<html>
<head>
<link rel="stylesheet" href="css/bootstrap.css">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="viewport" content="width=device-width", initial-scale=1.0">
<title>Searcher</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('Please log in.')");
script.println("location.href='login.jsp'");
script.println("</script>");
}
int bbsID = 0;
if (request.getParameter("bbsID") != null) { // Check bbsID is exist.
bbsID = Integer.parseInt(request.getParameter("bbsID"));
}
if (bbsID == 0) { // Check bbsID is valid.
PrintWriter script = response.getWriter();
script.println("<script>");
script.println("alert('Invalid page.')");
script.println("location.href='bbs.jsp'");
script.println("</script>");
}
Bbs bbs = new BbsDAO().getBbs(bbsID);
if (!userID.equals(bbs.getUserID())) { // Check board author is equal requested user.
PrintWriter script = response.getWriter();
script.println("<script>");
script.println("alert('Permission denied')");
script.println("location.href='bbs.jsp'");
script.println("</script>");
} else {
BbsDAO bbsDAO = new BbsDAO();
int result = bbsDAO.delete(bbsID);
if (result == -1) { // Failed to delete
PrintWriter script = response.getWriter();
script.println("<script>");
script.println("alert('Failed to delete')");
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>③동작 확인
'project > JSP+Oracle_DB+Apache_Tomcat' 카테고리의 다른 글
| [JSP/OracleDB/Tomcat/Eclipse]메인 페이지 꾸미기 (0) | 2025.03.17 |
|---|---|
| [JSP/OracleDB/Tomcat/Eclipse]글쓰기 기능 (0) | 2025.03.09 |
| [JSP/OracleDB/Tomcat/Eclipse]게시판 기능 (0) | 2025.03.05 |
| [JSP/OracleDB/Tomcat/Eclipse]세션 관리 (0) | 2025.03.04 |
| [JSP/OracleDB/Tomcat/Eclipse]Sign up 기능 (0) | 2025.02.28 |
