헤엄쳐 해파리

protected void doPost(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

request.setCharacterEncoding("UTF-8");

response.setContentType("text/html; charset=UTF-8");

<div class="container">

<div class="jumbotron">

<div class="container">

<h1>웹사이트 소개</h1>

<p>이 웹 사이트는 부트스트랩으로 만든 JSP 웹 사이트입니다. 최소한의 간단한 로직만을 이용해서 개발했습니다.</p>

<p><a class="btn btn-primary btn-pull" href="#" role="button">자세히 알아보기</a>

</div>

</div>

</div>

<div>

package bbs;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.util.ArrayList;

public class BbsDAO {

private Connection conn;

private ResultSet rs;

public BbsDAO() { //데이터 접근 객체

try {

String dbURL = "jdbc:mysql://localhost:3306/BBS";

String dbID ="root";

String dbPassword = "1234";

Class.forName("com.mysql.jdbc.Driver");

conn = DriverManager.getConnection(dbURL, dbID, dbPassword );

} catch (Exception e) {

e.printStackTrace();

}

}

public String getDate() {

String SQL = "SELECT NOW()";

try {

PreparedStatement pstmt = conn.prepareStatement(SQL);

rs = pstmt.executeQuery();

if(rs.next()) {

return rs.getString(1);

}

} catch (Exception e) {

e.printStackTrace();

}

return ""; //데이터베이스 오류

}

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; //첫 버째 게시물인 경우

} catch (Exception e) {

e.printStackTrace();

}

return -1; //데이터베이스 오류

}

public int write(String bbsTitle, String userID, String bbsContent) {

String SQL = "INSERT INTO BBS VALUES(?, ?, ?, ?, ?, ?)";

try {

PreparedStatement pstmt = conn.prepareStatement(SQL);

pstmt.setInt(1, getNext());

pstmt.setString(2, bbsTitle);

pstmt.setString(3, userID);

pstmt.setString(4, getDate());

pstmt.setString(5, bbsContent);

pstmt.setInt(6, 1);

return pstmt.executeUpdate();

} catch (Exception e) {

e.printStackTrace();

}

return -1; //데이터베이스 오류

}

public ArrayList<Bbs> getList(int pageNumber){

String SQL = "SELECT * FROM BBS WHERE bbsID < ? AND bbsAvailable = 1 ORDER BY bbsID DESC LIMIT 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;

}

public boolean nextPage(int pageNumber) {

String SQL = "SELECT * FROM BBS WHERE bbsID < ? AND bbsAvailable = 1 ORDER BY bbsID DESC LIMIT 10";

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;

}

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;

}

//여기부터 추가(수정/삭제)

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; //데이터베이스 오류

}

public int delete(int bbsID) {

String SQL = "UPDATE BBS SET bbsAvailable = 0 WHERE bbsID = ?"; 

//글을 삭제하더라도 글에 대한 정보가 남아 있을 수 있도록 bbsAvailable 값만 0으로 바꾸는 걸로 delete함수 구현

// 뭔 말인지 모르겠음 다시 찾아서 정보 추가

try {

PreparedStatement pstmt = conn.prepareStatement(SQL);

pstmt.setInt(1, bbsID);

return pstmt.executeUpdate();

} catch (Exception e) {

e.printStackTrace();

}

return -1; //데이터베이스 오류

}

}

<%@ 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">

<link rel="stylesheet" href="css/custom.css">

<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>");

}

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('유효하지 않은 글입니다.')");

script.println("location.href = 'bbs.jsp'");

script.println("</script>");

}

Bbs bbs = new BbsDAO().getBbs(bbsID);

if(!userID.equals(bbs.getUserID())){

PrintWriter script = response.getWriter();

script.println("<script>");

script.println("alert('권한이 없습니다. ')");

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

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

<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="contatiner">

<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;">게시판 글수정 양식</th>

</tr>

</thead>

<tbody>

<tr>

<td><input type="text" class="form-control" placeholder="글 제목" name="bbsTitle" maxlength="50" value="<%= bbs.getBbsTitle() %>"></td>   //수정 전 제목을 볼 수 있게 해줌

</tr>

<tr>

<td><textarea class="form-control" placeholder="글 내용" name="bbsContent" maxlength="2048" style="height:350px;"><%= bbs.getBbsContent()%></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>

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

<%@ page import = "bbs.BbsDAO" %>

<%@ page import = "bbs.Bbs" %>

<%@ page import = "java.io.PrintWriter" %>

<% request.setCharacterEncoding("UTF-8"); %>

<!DOCTYPE html>

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; 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>");

}

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('유효하지 않은 글입니다.')");

script.println("location.href = 'bbs.jsp'");

script.println("</script>");

}

Bbs bbs = new BbsDAO().getBbs(bbsID);

if(!userID.equals(bbs.getUserID())){

PrintWriter script = response.getWriter();

script.println("<script>");

script.println("alert('권한이 없습니다. ')");

script.println("location.href = 'bbs.jsp'");

script.println("</script>");

} else{

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('입력되지 않은 항목이 있습니다.')");

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){

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>

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

<%@ page import = "bbs.BbsDAO" %>

<%@ page import = "bbs.Bbs" %>

<%@ page import = "java.io.PrintWriter" %>

<% request.setCharacterEncoding("UTF-8"); %>

<!DOCTYPE html>

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; 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>");

}

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('유효하지 않은 글입니다.')");

script.println("location.href = 'bbs.jsp'");

script.println("</script>");

}

Bbs bbs = new BbsDAO().getBbs(bbsID);

if(!userID.equals(bbs.getUserID())){

PrintWriter script = response.getWriter();

script.println("<script>");

script.println("alert('권한이 없습니다. ')");

script.println("location.href = 'bbs.jsp'");

script.println("</script>");

} else{

BbsDAO bbsDAO = new BbsDAO();

int result = bbsDAO.delete(bbsID);

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>

"return confirm('정말로 삭제하시겠습니까?')"

추가