[JSP] JSP로 CRUD 게시판 만들기 (4) - 게시판 만들기

2024년 07월 16일

Song hyun
작성자
2024.07.16.:31

728x90

[JSP] JSP로 CRUD 게시판 만들기 (4) - 게시판 만들기

1. BoardController 만들기

package com.tenco.tboard.controller;

import jakarta.servlet.ServletException;
import jakarta.servlet.annotation.WebServlet;
import jakarta.servlet.http.HttpServlet;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;
import jakarta.servlet.http.HttpSession;

import java.io.IOException;
import java.util.List;

import com.tenco.tboard.model.Board;
import com.tenco.tboard.model.User;
import com.tenco.tboard.repository.interfaces.BoardRepository;
import com.tenco.tboard.repository.interfaces.BoardRepositoryImpl;
import com.tenco.tboard.repository.interfaces.UserRepository;

@WebServlet("/board/*")
public class BoardController extends HttpServlet {
	
	private static final long serialVersionUID = 1L;
    private BoardRepository boardRepository;
	
	@Override
	public void init() throws ServletException {
		boardRepository = new BoardRepositoryImpl();
	}
	
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String action = request.getPathInfo();
		// 세션 - 인증 처리
		HttpSession session=request.getSession(false);
		if(session==null || session.getAttribute("principal")==null) {
			response.sendRedirect(request.getContextPath()+"/user/signin");
			return;
		}
		
		
		switch (action) {
		case "/create":
			showCreateBoardForm(request,response,session);
			break;
		case "/list":
			handleListBoards(request, response,session);
			break;

		default:
			break;
		}
		
	}

	/**
	 * 게시글 생성 화면 이동
	 * @param request
	 * @param response
	 * @param session
	 * @throws IOException 
	 * @throws ServletException 
	 */
	private void showCreateBoardForm(HttpServletRequest request, HttpServletResponse response, HttpSession session) throws ServletException, IOException {
		request.getRequestDispatcher("/WEB-INF/views/board/create.jsp").forward(request, response);
	}

	/**
	 * 페이징 처리 하기 
	 * @param request
	 * @param response
	 * @throws IOException 
	 * @throws ServletException 
	 */
	private void handleListBoards(HttpServletRequest request, HttpServletResponse response, HttpSession session) throws ServletException, IOException {
		// 게시글 목록 조회 기능
		int page = 1; // 기본 페이지 번호 
		int pageSize = 3; // 한 페이지당 보여질 게시글에 수  
		
		try {
			 String pageStr = request.getParameter("page");
			 if(pageStr != null ) {
				 page = Integer.parseInt(pageStr);
			 }
		} catch (Exception e) {
			// 유효하지 않은 번호를 마음대로 보낼 경우 
			page = 1; 
		}
		// pageSize --> 3이다 
		// page 1, page 2, page 3 요청 동적으로 시작값을 계산하는 산수 공식 넣기 
		int offset = (page - 1) * pageSize; // 시작 위치 계산( offset 값 계산)

		// pageSize <-- 한 페이지당 보여줄 게시글 수 (limit 로 바라 볼 수 있다 ) 
 		List<Board> boardList =  boardRepository.getAllBoards(pageSize, offset);
		// 페이징 처리 1단계 (현재 페이지 번호, pageSize , offset) 
		////////////////////////////////////////////////////////////////
		
		// 전체 게시글 수 조회 
		int totalBoards = boardRepository.getTotalBoardCount();
		
		// 총 페이지 수 계산 -->  [1][2][3][...]
		int totalPages = (int) Math.ceil(totalBoards / pageSize);
		
		request.setAttribute("boardList", boardList);
		request.setAttribute("totalPages", totalPages);
		request.setAttribute("currentPage", page);
		
		// 현재 로그인한 사용자 ID 설정
		if(session!=null) {
			User user=(User)session.getAttribute("principal");
			if(user!=null) {
				request.setAttribute("userId", user.getId());
			}
		}
		request.getRequestDispatcher("/WEB-INF/views/board/list.jsp").forward(request, response);
	}

	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String action = request.getPathInfo();
		// 세션 - 인증 처리
		HttpSession session=request.getSession(false);
		if(session==null || session.getAttribute("principal")==null) {
			response.sendRedirect(request.getContextPath()+"/user/signin");
			return;
		}
		
		
		switch (action) {
		case "/create":
			handleCreateBoard(request,response,session);
			break;
		case "/edit":
			showCreateBoardForm(request,response,session);
			break;
		case "/addComment":
			showCreateBoardForm(request,response,session);
			break;
		default:
			response.sendError(HttpServletResponse.SC_NOT_FOUND);
			break;
		}
	}

	/**
	 * 게시글 생성 처리
	 * @param request
	 * @param response
	 * @param session
	 * @throws IOException 
	 */
	private void handleCreateBoard(HttpServletRequest request, HttpServletResponse response, HttpSession session) throws IOException {
		// 유효성 검사 생략
		String title=request.getParameter("title");
		String content=request.getParameter("content");
		User user=(User)session.getAttribute("principal");
		
		Board board= Board.builder()
				.userId(user.getId())
				.title(title)
				.content(content)
				.build();
		boardRepository.addBoard(board);
		response.sendRedirect(request.getContextPath()+"/board/list?page=1");
	}

}

2. BoardRepository (인터페이스) 만들기

-BoardRepository.java(인터페이스 형식): BoardDAO의 뼈대를 만들어주는 클래스.

어떤 변수를 받고, 어떤 자료형의 값을 return 할 것인지를 미리 설계해둔다. -> 추후 implements를 통해 구현!

package com.tenco.tboard.repository.interfaces;

import java.util.List;

import com.tenco.tboard.model.Board;

public interface BoardRepository {
	// CRUD
	void addBoard(Board board);
	void updateBoard(Board board,int principalId);
	void deleteBoard(int id);
	Board selectBoardById(int id);
	List<Board> getAllBoards(int limit,int offset);
	int getTotalBoardCount();
}

3. Board DTO 만들기

-Board.java: Board를 인스턴스화 할 때(=객체로 만들때) 필요한, 의미있는 자료형의 집합.

-SQL 상에서의 데이터 항목(=컬럼)과 동일하게 작성한다.

package com.tenco.tboard.model;

import java.sql.Timestamp;

import lombok.AllArgsConstructor;
import lombok.Builder;
import lombok.Data;
import lombok.NoArgsConstructor;
import lombok.ToString;

@Data
@ToString
@Builder
@AllArgsConstructor
@NoArgsConstructor
public class Board {
	private int id;
	private int userId;
	private String title;
	private String content;
	private Timestamp createdAt;
}

4. SQL 쿼리문

-오류 방지를 위해 MySQL에서 미리 쿼리를 작성, 체크 후에 DAO에 넣는다.

select * from board order by created_at desc limit ? offset ? ;

5. List.JSP

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt" %>
   
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>게시글 목록</title>
<link rel="stylesheet" type="text/css" href="${pageContext.request.contextPath}/resources/css/common.css">
<link rel="stylesheet" type="text/css" href="${pageContext.request.contextPath}/resources/css/list.css">
</head>
<body>
	<h2>게시글 목록</h2>
	<div class="action">
		<a class="btn btn-create" href="${pageContext.request.contextPath}/board/create" >새글 작성하기</a>
		<a class="btn btn-back" href="${pageContext.request.contextPath}/index.jsp" >홈 화면</a>
	</div>
	
	<c:forEach var="board"  items="${boardList}">
		<div class="board-item">
			<h3><a href="#">${board.title}</a></h3>
			<p>${board.content}</p>
			<p> <fmt:formatDate value="${board.createdAt}" pattern="yyyy-MM-dd HH:mm" /></p>
			<!-- 게시글에 작성자가 세션 유저와 동일하다면 수정, 삭제 버튼을 보여주자  -->
			<c:if test="${board.userId==userId }">
				<a class="btn btn-edit" href="#">수정</a>
				<a class="btn btn-delete" href="#">삭제</a>
			</c:if>
		</div>
	</c:forEach>
	
	<br>
	<div class="pagination">
		<!-- index for  -->
		<c:forEach begin="1" end="${totalPages}"  var="i" >
			<c:choose>
				<c:when test="${ i == currentPage }">
					<span class="current-page" >${i}</span>
				</c:when>
				<c:otherwise>
					<span><a href="${pageContext.request.contextPath}/board/list?page=${i}">${i}</a></span>	
				</c:otherwise>
			</c:choose>
		</c:forEach>
	</div>
	
</body>
</html>

6. CSS

(1) common.css

@charset "UTF-8";

body{
	font-family:Arial,Sans-serif;
	margin: 0;
	padding: 0;
	background-color: #f4f4f4;
	color: #333;
	
}

(2) list.css

@charset "UTF-8";
@import url("board.css");

.action{
	margin-bottom: 20px;
}
.action .btn{
	margin-right:10px;
}

.board-item{
	margin-bottom:20px;
	padding: 15px;
	border-bottom: 1px solid #ddd;
}
.board-item h3{
	margin: 0;
}

.board-item P{
	margin: 5px 0;
}

.btn-create{
	background-color: #28a745;
	color: white;
	text-align:center;
}

.btn-create:hover{
	background-color: #218838;
}

.btn-edit{
	background-color: #007bff;
	color: white;
	text-align:center;
}

.btn-edit:hover{
	background-color: #0056b3;
}
.btn-delete{
	background-color: #dc3545;
	color: white;
	text-align:center;
}

.btn-delete:hover{
	background-color: #c82333;
}

.btn-back{
	background-color: #6c757d;
	color: white;
}
.btn-back:hover{
	background-color: #5a6268;
}


.pagination{
	text-align:center;
	margin-top: 20px;
	margin-bottom: 40px;
}

.pagination a{
	display: inline-block;
	padding: 5px 10px;
	margin: 0 5px;
	border: 1px solid #ddd;
	text-decoration: none;
	color: #007bff;
}

.pagination a:hover{
	background-color: #007bff;
	color: white;
}

.current-page{
	display: inline-block;
	padding: 5px 10px;
	background-color: #007bff;
	border: 1px solid #007bff;
	border-radius: 4px;
	text-decoration: none;
	color: white;
}

(3) board.css

@charset "UTF-8";

h2{
	text-align: center;
	color: #007aba;
}

.btn {
	display: inline-block;
	padding: 10px 15px;
	margin-top: 10px;
	text-decoration: none;
	border-radius: 4px;
	
}

7. UserController

package com.tenco.tboard.controller;

import jakarta.servlet.ServletException;
import jakarta.servlet.annotation.WebServlet;
import jakarta.servlet.http.HttpServlet;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;
import jakarta.servlet.http.HttpSession;

import java.io.IOException;
import java.io.PrintWriter;

import com.tenco.tboard.model.User;
import com.tenco.tboard.repository.UserRepositoryImpl;
import com.tenco.tboard.repository.interfaces.UserRepository;


@WebServlet("/user/*")
public class UserController extends HttpServlet {
	private static final long serialVersionUID = 1L;
    
	private UserRepository userRepository;
	
	@Override
	public void init() throws ServletException {
		userRepository = new UserRepositoryImpl();
	}


	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		
		String action = request.getPathInfo();
		
		switch (action) {
		case "/signup": 
			request.getRequestDispatcher("/WEB-INF/views/user/signup.jsp").forward(request, response);
			break;
		case "/signin":
			request.getRequestDispatcher("/WEB-INF/views/user/signin.jsp").forward(request, response); 
			break;
		case "/logout":
			handleLogout(request, response);
			break;
		default:
			response.sendError(HttpServletResponse.SC_NOT_FOUND);
			break;
		}
		
	}
	
	/**
	 * 로그아웃 기능 처리 
	 * @throws IOException 
	 * http://localhost:8080/t-board/user/logout
	 */
	private void handleLogout(HttpServletRequest request, HttpServletResponse response) throws IOException {
		HttpSession session = request.getSession();
		session.invalidate();
		response.sendRedirect(request.getContextPath() + "/user/signin");
	}


	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String action = request.getPathInfo();
		switch (action) {
		case "/signup": 
			handleSignup(request, response);
			break;
		case "/signin":
			 handleSignin(request, response); 
			break;
		default:
			response.sendError(HttpServletResponse.SC_NOT_FOUND);
			break;
		}
		
	}


	private void handleSignin(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		
		String username = request.getParameter("username");
		String password = request.getParameter("password");
		User principal = userRepository.getUserByUsernameAndPassword(username, password);
		
		if(principal != null && principal.getPassword().equals(password)) {
			HttpSession session = request.getSession();
			session.setAttribute("principal", principal);
			response.sendRedirect(request.getContextPath() + "/board/list");
		} else {
			request.setAttribute("errorMessage", "잘못된 요청입니다.");
			request.getRequestDispatcher("/WEB-INF/views/user/signin.jsp").forward(request, response);
		}
	}


	private void handleSignup(HttpServletRequest request, HttpServletResponse response) throws IOException {
		// 데이터 추출 
		String username = request.getParameter("username") ; 
		String password = request.getParameter("password") ; 
		String email = request.getParameter("email");
		
		// 데이터 유효성 검사 생략 
		
		User user = User.builder()
					.username(username)
					.password(password)
					.email(email)
					.build();
		// TODO 삭제 예정 
		System.out.println(user);
		int result = userRepository.addUser(user);
		if(result != 0) {
			response.sendRedirect(request.getContextPath() + "/user/signin");
		} else {
			 response.setContentType("text/html; charset=UTF-8");
			 PrintWriter out = response.getWriter();
			 out.println("<script> alert('잘못된 요청입니다'); history.back();  </script>");
		}
	}
}

728x90

'JSP > CRUD 게시판 만들기' 카테고리의 다른 글

[JSP] JSP로 CRUD 게시판 만들기 (5) - 댓글창 만들기 (0)	2024.07.17
[JSP] JSP로 CRUD 게시판 만들기 (3) - JSP 파일 및 로그인 기능 만들기 (1)	2024.07.15
[JSP] JSP로 CRUD 게시판 만들기 (2) - DB 접근 기술 (0)	2024.07.15
[JSP] JSP로 CRUD 게시판 만들기 (1) - 패키지 및 DB 생성 (0)	2024.07.15

다음 글이 없습니다.

이전 글이 없습니다.

[JSP] JSP로 CRUD 게시판 만들기 (4) - 게시판 만들기

'JSP > CRUD 게시판 만들기' 카테고리의 다른 글

티스토리툴바