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.글쓰기 기능
write.jsp
①webapp 에서 'New' - 'jsp' - Filename에 'write.jsp' 입력
②코드 작성
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.io.PrintWriter" %>
<!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");
}
%>
<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">
<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;">Board writing form</th>
</tr>
</thead>
<tbody>
<tr>
<td><input type="text" class="form-control" placeholder="Title" name="bbsTitle" maxlenth="50"></td>
</tr>
<tr>
<td><textarea class="form-control" placeholder="Content" name="bbsContent" maxlenth="2048" style="height: 350px;"></textarea></td>
</tr>
</tbody>
</table>
<input type="submit" class="btn btn-primary pull-right" value="Write">
</form>
</div>
</div>
<script src="https://code.jquery.com/jquery-3.1.1.min.js"></script>
<script src="js/bootstrap.js"></script>
</body>
</html>
③동작 확인
BbsDAO.java
DAO: Database Access Object의 약자, 실질적으로 데이터베이스와 소통하는 부분을 담당합니다.
①생성한 패키지에서 우클릭 - 'new' - 'Class'
②Name을 BbsDAO로 저장
③코드 작성
package bbs;
import java.sql.Connection;
import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.DriverManager;
public class BbsDAO {
private Connection conn;
private ResultSet rs;
public BbsDAO() {
try {
String URL = "jdbc:oracle:thin:@localhost:1521:xe";
String USER = "userj";
String PASSWORD = "pass1word";
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(URL, USER, PASSWORD);
} catch (Exception e) {
e.printStackTrace();
}
}
public Date getDate() { // Get the time the board was created
String SQL = "SELECT SYSDATE FROM DUAL";
try {
PreparedStatement pstmt = conn.prepareStatement(SQL);
rs = pstmt.executeQuery();
if (rs.next()) {
return rs.getDate(1);
}
} catch (Exception e) {
e.printStackTrace();
}
return null; // DB Error
}
public int getNext() {
String SQL = "SELECT bbsID FROM BBS ORDER BY bbsID DESC";
try {
PreparedStatement pstmt = conn.prepareStatement(SQL);
rs = pstmt.executeQuery();
if (rs.next()) {
return rs.getInt(1) + 1;
}
return 1; // If this board is first document.
} catch (Exception e) {
e.printStackTrace();
}
return -1; // DB Error
}
public int write(String bbsTitle, String userID, String bbsContent) {
String SQL = "INSERT INTO BBS(bbsID, bbsTitle, userID, bbsDate, bbsContent, bbsAvailable) VALUES (?, ?, ?, ?, ?, ?)";
try {
PreparedStatement pstmt = conn.prepareStatement(SQL);
pstmt.setInt(1, getNext());
pstmt.setString(2, bbsTitle);
pstmt.setString(3, userID);
pstmt.setDate(4, getDate());
pstmt.setString(5, bbsContent);
pstmt.setInt(6, 1);
return pstmt.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
}
return -1; // DB Error
}
}
writeAction.jsp
글 작성에 대한 처리를 수행하는 코드입니다.
①webapp 에서 'New' - 'jsp' - Filename에 'writeAction.jsp' 입력
②코드 작성
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ 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>
<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>");
} else {
// filtering that user input is null
if (bbs.getBbsTitle() == null || bbs.getBbsContent() == null) {
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.write(bbs.getBbsTitle(), userID, bbs.getBbsContent());
if (result == -1) { // -1 result means "that ID already exists.
PrintWriter script = response.getWriter();
script.println("<script>");
script.println("alert('Failed to write')");
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>③동작 확인
직접 데이터 베이스에 접근하여 조회해보면 쿼리가 잘 수행된 것을 알 수 있습니다.
굳이 문제점을 따지면 두 파트로 나뉘어 나온다는 것인데, 막상 WHERE 문을 이용하여 갈라진 두 구문의 값을 조회해보면 잘 조회가 됩니다.
'project > JSP+Oracle_DB+Apache_Tomcat' 카테고리의 다른 글
| [JSP/OracleDB/Tomcat/Eclipse]메인 페이지 꾸미기 (0) | 2025.03.17 |
|---|---|
| [JSP/OracleDB/Tomcat/Eclipse]게시판 데이터 연동 (0) | 2025.03.11 |
| [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 |
