GDJ 24/06/03 (Spring MVC CRUD 실습)

kimuki·2024년 6월 3일
JavaMVCSpringSpring boot
post-thumbnail

Spring MVC CRUD 만들기

BoardController.java (Controller)

package com.gd.hr.controller;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestParam;

import com.gd.hr.dto.Board;
import com.gd.hr.service.BoardService;
import com.gd.hr.util.TeamColor;

import lombok.extern.slf4j.Slf4j;

@Slf4j
@Controller
public class BoardController {
	
	@Autowired
	BoardService boardService;
	
	// 입력 폼
	@GetMapping("/addBoard")
	public String addBoard() {
		
		return "addBoard";
	}
	
	// 입력 액션
	@PostMapping("/addBoard")
	public String addBoard(Board b) {
		
		log.debug(TeamColor.YELLOW + "request Board b : " + b.toString());
		
		int addBoardRow = boardService.addBoard(b);
		log.debug(TeamColor.YELLOW + "addBoardRow : " + addBoardRow);
		
		return "redirect:/boardList";
	}
	
	// 전체 리스트 출력
	@GetMapping("/boardList")
	public String boardList(Model model,
							@RequestParam(name = "currentPage", defaultValue = "1") int currentPage, 
							@RequestParam(name = "rowPerPage", defaultValue = "10") int rowPerPage){
		
		List<Board> list = boardService.getBoardList(currentPage, rowPerPage);
		log.debug(TeamColor.YELLOW  + "list : " + list.toString());
		int lastPage = boardService.getLastPage(rowPerPage);
		log.debug(TeamColor.YELLOW + "lastPage : " + lastPage);
		
		model.addAttribute("list", list);
		model.addAttribute("lastPage", lastPage);			// JSP에서 페이징 사용
		model.addAttribute("currentPage", currentPage);		// JSP에서 페이징 사용
		
		return "boardList";
	}
	
	// 게시물 상세
	@GetMapping("/boardOne")
	public String boardOne(Model model, int boardNo) {
		
		Board boardOne = boardService.boardOne(boardNo);
		log.debug(TeamColor.YELLOW + "boardOne : " + boardOne);
		
		model.addAttribute("boardOne", boardOne);
		
		return "boardOne";
	}
	
	// 게시물 삭제
	@GetMapping("/removeBoard")
	public String removeBoard(int boardNo) {
		
		int removeBoardRow = boardService.removeBoard(boardNo);
		log.debug(TeamColor.YELLOW + "removeBoardRow : " + removeBoardRow);
		
		return "redirect:/boardList";	// 삭제 후 BoardList Redirect
	}
	
	// 게시물 수정 폼
	@GetMapping("/modifyBoard")
	public String modifyBoard(Model model, int boardNo) {
		
		Board boardOne = boardService.boardOne(boardNo);
		log.debug(TeamColor.YELLOW + "boardOne : " + boardOne);
		
		model.addAttribute("boardOne", boardOne);
		
		return "modifyBoard";
	}
	
	// 게시물 수정 액션
	@PostMapping("/modifyBoard")
	public String modifyBoard(Board b) {
		
		log.debug(TeamColor.YELLOW + "board : " + b.toString());
		
		int modifyBoardRow = boardService.modifyBoard(b);
		log.debug(TeamColor.YELLOW + "modifyBoardRow : " + modifyBoardRow);
		
		return "redirect:/boardList";	// 수정 후 BoardList Redirect
	}	
}

BoardDTO.java (DTO)

package com.gd.hr.dto;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class Board {

	private int boardNo;
	private String boardTitle;
	private String boardContent;
	private String boardWriter;
	private String createdate;
	private String updatedate;
}

BoardService.java (Service)

package com.gd.hr.service;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import com.gd.hr.dto.Board;
import com.gd.hr.mapper.BoardMapper;
import com.gd.hr.util.TeamColor;

import lombok.extern.slf4j.Slf4j;

@Slf4j
@Service
@Transactional
public class BoardService {

	@Autowired
	BoardMapper boardMapper;
	
	public int addBoard(Board b) {
		
		int addBoardRow = boardMapper.insertBoard(b);
		
		return addBoardRow;
	}
	
	public int modifyBoard(Board b) {
		
		int modifyBoardRow = boardMapper.updateBoard(b);
		
		return modifyBoardRow;
	}
	
	public int removeBoard(int boardNo) {
		
		int removeBoardRow = boardMapper.deleteBoard(boardNo);
		
		return removeBoardRow;
	}
	
	public Board boardOne(int boardNo) {
		
		Board b = boardMapper.boardOne(boardNo);
		
		return b;
	}
	
	public List<Board> getBoardList(int currentPage, int rowPerPage){
		
		log.debug(TeamColor.YELLOW + "currentPage : " + currentPage);
		log.debug(TeamColor.YELLOW + "rowPerPage : " + rowPerPage);
		
		int startRow = (currentPage - 1) * rowPerPage;
		
		Map<String, Object> map = new HashMap<>();
		map.put("startRow", startRow);
		map.put("rowPerPage", rowPerPage);
		
		map.put("searchWord", null);	// boardList 검색어
		
		List<Board> list = boardMapper.boardList(map);
		
		return list;
	}
	
	public int getLastPage(int rowPerPage) {
		
		int boardCount = boardMapper.selectBoardCount();
		
		int lastPage = boardCount / rowPerPage;
		if(boardCount % rowPerPage != 0) {
			lastPage += 1;
		}
		
		return lastPage;
	}
}

BoardMapper.java (Interface)

package com.gd.hr.mapper;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Mapper;

import com.gd.hr.dto.Board;

@Mapper
public interface BoardMapper {
	
	public int insertBoard(Board b);
	
	public int updateBoard(Board b);
	
	public int deleteBoard(int boardNo);
	
	public Board boardOne(int boardNo);
	
	public List<Board> boardList(Map<String, Object> map);
	
	public int selectBoardCount();
}

BoardMapper.xml (Mapper XML)

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.gd.hr.mapper.BoardMapper">

	<insert id="insertBoard" parameterType="com.gd.hr.dto.Board">
		INSERT INTO board (
			board_title,
			board_content,
			board_writer,
			createdate,
			updatedate
		) VALUES (
			#{boardTitle},
			#{boardContent},
			#{boardWriter},
			NOW(),
			NOW()
		)
	</insert>
	
	<update id="updateBoard" parameterType="com.gd.hr.dto.Board">
		UPDATE
			board
		<set>	<!-- 수정 내용에 null 또는 공백이 들어올 경우 수정 롤백 -->
			<if test="boardTitle != null and boardTitle != ''">
				board_title = #{boardTitle},
			</if>
			<if test="boardContent != null and boardContent != ''">
				board_content = #{boardContent},
			</if>
			updatedate = NOW()
		</set>
		WHERE
			board_no = #{boardNo}
	</update>
	
	<delete id="deleteBoard" parameterType="int">
		DELETE FROM
			board
		WHERE
			board_no = #{boardNo}
	</delete>
	
	<select id="boardOne" parameterType="int" resultType="com.gd.hr.dto.Board">
		SELECT
			board_no boardNo,
			board_title boardTitle,
			board_content boardContent,
			board_writer boardWriter,
			createdate,
			updatedate
		FROM
			board
		WHERE
			board_no = #{boardNo}
	</select>
	
	<select id="boardList" parameterType="Map" resultType="com.gd.hr.dto.Board">
		SELECT
			board_no boardNo,
			board_title boardTitle
		FROM
			board
		<where>		<!-- Content 검색 기능 -->
			<if test="searchWord != null">
				board_title LIKE CONCAT('%',#{searchWord},'%')		
			</if>
		</where>
		ORDER BY
			board_no DESC
		LIMIT
			#{startRow}, #{rowPerPage}
	</select>
	
	<select id="selectBoardCount" resultType="int">
		SELECT
			COUNT(*)
		FROM
			board
	</select>
</mapper>

addBoard.jsp (View)

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions"%>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
	<h1>Board Form</h1>
	<form method="post" action="${pageContext.request.contextPath}/addBoard">
		<table>
			<tr>
				<th>Board Title</th>
				<td><input type="text" name="boardTitle"></td>
			</tr>
			<tr>
				<th>Board Content</th>
				<td><textarea name="boardContent" rows="5" cols="50"></textarea></td>
			</tr>
			<tr>
				<th>Board Writer</th>
				<td><input type="text" name="boardWriter"></td>
			</tr>
		</table>
		<button type="submit">입력</button>
	</form>
</body>
</html>

addBoard.jsp 출력결과

boardList.jsp(View)

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions"%>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
	<h1>Board List</h1>
	<table border=1>
		<tr>
			<th>boardNo</th>
			<th>boardTitle</th>
			<th>&nbsp;</th>
			<th>&nbsp;</th>
		</tr>
		<c:forEach var="b" items="${list}">
			<tr>
				<td>${b.boardNo}</td>
				<td>
					<a href="${pageContext.request.contextPath}/boardOne?boardNo=${b.boardNo}">${b.boardTitle}</a>
				</td>
				<td>
					<a href="${pageContext.request.contextPath}/modifyBoard?boardNo=${b.boardNo}">수정하기</a>
				</td>
				<td>
					<a href="${pageContext.request.contextPath}/removeBoard?boardNo=${b.boardNo}">삭제하기</a>
				</td>
			</tr>
		</c:forEach>
	</table>
	<c:if test="${currentPage > 1}">
		<a href="${pageContext.request.contextPath}/boardList?currentPage=${currentPage-1}">이전</a>
	</c:if>
	
	<c:if test="${currentPage < lastPage}">
		<a href="${pageContext.request.contextPath}/boardList?currentPage=${currentPage+1}">다음</a>
	</c:if>
</body>
</html>

boardList.jsp 출력결과

modifyBoard.jsp (View)

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
	<h1>Modify Board Form</h1>
	<form method="post" action="${pageContext.request.contextPath}/modifyBoard?boardNo=${boardOne.boardNo}">
		<table>
			<tr>
				<th>Board Title</th>
				<td><input type="text" name="boardTitle" value="${boardOne.boardTitle}"></td>
			</tr>
			<tr>
				<th>Board Content</th>
				<td><textarea name="boardContent" rows="5" cols="50">${boardOne.boardContent}</textarea></td>
			</tr>
		</table>
		<button type="submit">입력</button>
	</form>
</body>
</html>

modifyBoard.jsp 출력결과

+ logging color change code

TeamColor.java (로깅 코드 색상 변경)

package com.gd.hr.util;

public class TeamColor {
	
	public static String PSH = "\u001B[31m";
	public static String RESET = "\u001B[0m";
	public static String YELLOW = "\u001B[33m";
}

log.debug(TeamColor.YELLOW + "내용 : " + 내용) << 처럼 사용

로그 콘솔 색상

	public static final String ANSI_RESET = "\u001B[0m";
	public static final String ANSI_BLACK = "\u001B[30m";
	public static final String ANSI_RED = "\u001B[31m";
	public static final String ANSI_GREEN = "\u001B[32m";
	public static final String ANSI_YELLOW = "\u001B[33m";
	public static final String ANSI_BLUE = "\u001B[34m";
	public static final String ANSI_PURPLE = "\u001B[35m";
	public static final String ANSI_CYAN = "\u001B[36m";
	public static final String ANSI_WHITE = "\u001B[37m";
	public static final String ANSI_BLACK_BACKGROUND = "\u001B[40m";
	public static final String ANSI_RED_BACKGROUND = "\u001B[41m";
	public static final String ANSI_GREEN_BACKGROUND = "\u001B[42m";
	public static final String ANSI_YELLOW_BACKGROUND = "\u001B[43m";
	public static final String ANSI_BLUE_BACKGROUND = "\u001B[44m";
	public static final String ANSI_PURPLE_BACKGROUND = "\u001B[45m";
	public static final String ANSI_CYAN_BACKGROUND = "\u001B[46m";
	public static final String ANSI_WHITE_BACKGROUND = "\u001B[47m";
	
    출처: https://naucika.tistory.com/entry/로그-콘솔에-색상-출력하기 [naucika's ECM:티스토리]
profile
kimuki
Road OF Developer
이전 포스트

GDJ 24/05/31 (Lombok Annotaion, Interface)

다음 포스트

GDJ 24/06/04 (MyBatis 과제)

0개의 댓글