$$config title: New Title keywords: - IT - ... $$ ## 조건 - 스프링부트 사용금지 - 스프링사용금지 - MySQL와 MySQL 드라이버만 사용 - ORM 사용금지 - SQL MAPPER 사용금지 - MyMap 이라는 라이브러리 직접개발 - Gradle 사용 - 인텔리제이 사용 - 톰캣 10 사용 - 게시판을 구현해주세요. ```java package com.ll.spring; import com.ll.spring.article.entity.Article; import com.ll.spring.article.service.ArticleService; import com.ll.spring.mymap.MyMap; import org.junit.jupiter.api.BeforeAll; import org.junit.jupiter.api.BeforeEach; import org.junit.jupiter.api.Test; import org.junit.jupiter.api.TestInstance; import java.time.LocalDateTime; import java.time.temporal.ChronoUnit; import java.util.List; import java.util.stream.IntStream; import static org.assertj.core.api.Assertions.assertThat; @TestInstance(TestInstance.Lifecycle.PER_CLASS) public class ArticleServiceTest { private MyMap myMap; private ArticleService articleService; private static final int TEST_DATA_SIZE = 100; public ArticleServiceTest() { myMap = Container.getObj(MyMap.class); articleService = Container.getObj(ArticleService.class); } // @BeforeAll 붙인 아래 메서드는 @BeforeAll public void BeforeAll() { // 모든 DB 처리시에, 처리되는 SQL을 콘솔에 출력 myMap.setDevMode(true); } // @BeforeEach를 붙인 아래 메서드는 // @Test가 달려있는 메서드가 실행되기 전에 자동으로 실행이 된다. // 주로 테스트 환경을 깔끔하게 정리하는 역할을 한다. // 즉 각각의 테스트케이스가 독립적인 환경에서 실행될 수 있도록 하는 역할을 한다. @BeforeEach public void beforeEach() { // 게시물 테이블을 깔끔하게 삭제한다. // DELETE FROM article; // 보다 TRUNCATE article; 로 삭제하는게 더 깔끔하고 흔적이 남지 않는다. truncateArticleTable(); // 게시물 3개를 만든다. // 테스트에 필요한 샘플데이터를 만든다고 보면 된다. makeArticleTestData(); } private void makeArticleTestData() { IntStream.rangeClosed(1, TEST_DATA_SIZE).forEach(no -> { boolean isBlind = no >= 11 && no <= 20; String title = "제목%d".formatted(no); String body = "내용%d".formatted(no); myMap.run(""" INSERT INTO article SET createdDate = NOW(), modifiedDate = NOW(), title = ?, `body` = ?, isBlind = ? """, title, body, isBlind); }); } private void truncateArticleTable() { // 테이블을 깔끔하게 지워준다. myMap.run("TRUNCATE article"); } @Test public void 존재한다() { assertThat(articleService).isNotNull(); } @Test public void getArticles() { List

articleDtoList = articleService.getArticles(); assertThat(articleDtoList.size()).isEqualTo(TEST_DATA_SIZE); } @Test public void getArticleById() { Article articleDto = articleService.getArticleById(1); assertThat(articleDto.getId()).isEqualTo(1L); assertThat(articleDto.getTitle()).isEqualTo("제목1"); assertThat(articleDto.getBody()).isEqualTo("내용1"); assertThat(articleDto.getCreatedDate()).isNotNull(); assertThat(articleDto.getModifiedDate()).isNotNull(); assertThat(articleDto.isBlind()).isFalse(); } @Test public void getArticlesCount() { long articlesCount = articleService.getArticlesCount(); assertThat(articlesCount).isEqualTo(TEST_DATA_SIZE); } @Test public void write() { long newArticleId = articleService.write("제목 new", "내용 new", false); Article articleDto = articleService.getArticleById(newArticleId); assertThat(articleDto.getId()).isEqualTo(newArticleId); assertThat(articleDto.getTitle()).isEqualTo("제목 new"); assertThat(articleDto.getBody()).isEqualTo("내용 new"); assertThat(articleDto.getCreatedDate()).isNotNull(); assertThat(articleDto.getModifiedDate()).isNotNull(); assertThat(articleDto.isBlind()).isEqualTo(false); } @Test public void modify() { //Ut.sleep(5000); articleService.modify(1, "제목 new", "내용 new", true); Article articleDto = articleService.getArticleById(1); assertThat(articleDto.getId()).isEqualTo(1); assertThat(articleDto.getTitle()).isEqualTo("제목 new"); assertThat(articleDto.getBody()).isEqualTo("내용 new"); assertThat(articleDto.isBlind()).isEqualTo(true); // DB에서 받아온 게시물 수정날짜와 자바에서 계산한 현재 날짜를 비교하여(초단위) // 그것이 1초 이하로 차이가 난다면 // 수정날짜가 갱신되었다 라고 볼 수 있음 long diffSeconds = ChronoUnit.SECONDS.between(articleDto.getModifiedDate(), LocalDateTime.now()); assertThat(diffSeconds).isLessThanOrEqualTo(1L); } @Test public void delete() { articleService.delete(1); Article articleDto = articleService.getArticleById(1); assertThat(articleDto).isNull(); } @Test public void _2번글의_이전글은_1번글_이다() { Article id2Article = articleService.getArticleById(2); Article id1Article = articleService.getPrevArticle(id2Article); assertThat(id1Article.getId()).isEqualTo(1); } @Test public void _1번글의_이전글은_없다() { Article id1Article = articleService.getArticleById(1); Article nullArticle = articleService.getPrevArticle(id1Article); assertThat(nullArticle).isNull(); } @Test public void _2번글의_다음글은_3번글_이다() { Article id3Article = articleService.getNextArticle(2); assertThat(id3Article.getId()).isEqualTo(3); } @Test public void 마지막글의_다음글은_없다() { long lastArticleId = TEST_DATA_SIZE; Article nullArticle = articleService.getNextArticle(lastArticleId); assertThat(nullArticle).isNull(); } @Test public void _10번글의_다음글은_21번글_이다_왜냐하면_11번글부터_20번글까지는_블라인드라서() { Article nextArticle = articleService.getNextArticle(10); assertThat(nextArticle.getId()).isEqualTo(21); } } ``` ```java package com.ll.spring; import com.ll.spring.util.Ut; import jakarta.servlet.RequestDispatcher; import jakarta.servlet.ServletException; import jakarta.servlet.http.HttpServletRequest; import jakarta.servlet.http.HttpServletResponse; import lombok.Getter; import lombok.Setter; import java.io.IOException; import java.io.UnsupportedEncodingException; public class Rq { private final HttpServletRequest req; private final HttpServletResponse resp; @Setter @Getter private RouteInfo routeInfo; public Rq(HttpServletRequest req, HttpServletResponse resp) { this.req = req; this.resp = resp; try { req.setCharacterEncoding("UTF-8"); } catch (UnsupportedEncodingException e) { throw new RuntimeException(e); } resp.setCharacterEncoding("UTF-8"); resp.setContentType("text/html; charset=utf-8"); } public String getPathParam(String paramName, String defaultValue) { if ( routeInfo == null ) { return defaultValue; } String path = routeInfo.getPath(); String[] pathBits = path.split("/"); int index = -1; for ( int i = 0; i < pathBits.length; i++ ) { String pathBit = pathBits[i]; if ( pathBit.equals("{" + paramName + "}") ) { index = i - 4; break; } } if ( index != -1 ) { return getPathValueByIndex(index, defaultValue); } return defaultValue; } public String getParam(String paramName, String defaultValue) { String value = req.getParameter(paramName); if ( value == null ) { value = getPathParam(paramName, null); } if (value == null || value.trim().length() == 0) { return defaultValue; } return value; } public long getLongParam(String paramName, long defaultValue) { String value = getParam(paramName, null); if (value == null) { return defaultValue; } try { return Long.parseLong(value); } catch (NumberFormatException e) { return defaultValue; } } public int getIntParam(String paramName, int defaultValue) { String value = getParam(paramName, null); if (value == null) { return defaultValue; } try { return Integer.parseInt(value); } catch (NumberFormatException e) { return defaultValue; } } public void print(String str) { try { resp.getWriter().append(str); } catch (IOException e) { throw new RuntimeException(e); } } public void println(String str) { print(str + "\n"); } public void setAttr(String name, Object value) { req.setAttribute(name, value); } public void view(String path) { // gugudan2.jsp 에게 나머지 작업을 토스 RequestDispatcher requestDispatcher = req.getRequestDispatcher("/jsp/" + path + ".jsp"); try { requestDispatcher.forward(req, resp); } catch (ServletException e) { throw new RuntimeException(e); } catch (IOException e) { throw new RuntimeException(e); } } public String getPath() { return req.getRequestURI(); } public String getActionPath() { String[] bits = req.getRequestURI().split("/"); return "/%s/%s/%s".formatted(bits[1], bits[2], bits[3]); } public String getRouteMethod() { String method = getParam("_method", ""); if (method.length() > 0) { return method.toUpperCase(); } return req.getMethod(); } public long getLongPathValueByIndex(int index, long defaultValue) { String value = getPathValueByIndex(index, null); if (value == null) { return defaultValue; } try { return Long.parseLong(value); } catch (NumberFormatException e) { return defaultValue; } } public String getPathValueByIndex(int index, String defaultValue) { String[] bits = req.getRequestURI().split("/"); try { return bits[4 + index]; } catch (ArrayIndexOutOfBoundsException e) { return defaultValue; } } public void replace(String uri, String msg) { if (msg != null && msg.trim().length() > 0) { println(""" """.formatted(msg)); } println(""" """.formatted(uri)); } public void historyBack(String msg) { if (msg != null && msg.trim().length() > 0) { println(""" """.formatted(msg)); } println(""" """); } public void json(Object resultData) { resp.setContentType("application/json; charset=utf-8"); String jsonStr = Ut.json.toStr(resultData, ""); println(jsonStr); } public void json(Object data, String resultCode, String msg) { json(new ResultData(resultCode, msg, data)); } public void successJson(Object data) { json(data, "S-1", "성공"); } public void failJson(Object data) { json(data, "F-1", "실패"); } } ``` ```java package com.ll.spring; public class App { public static final String BASE_PACKAGE_PATH = "com.ll.spring"; public static String DB_HOST = "localhost"; public static int DB_PORT = 3306; public static String DB_ID = "lldj"; public static String DB_PASSWORD = "lldj1234"; public static String DB_NAME = "blog"; public static boolean isProd = false; static { String profilesActive = System.getenv("SPRING_PROFILES_ACTIVE"); if (profilesActive != null && profilesActive.equals("production")) { isProd = true; } if (isProd) { // 운영DB 정보 DB_HOST = "172.17.0.1"; DB_PORT = 3306; DB_ID = "lldjlocal"; DB_PASSWORD = "1234"; DB_NAME = "site1"; } } } ``` ```java package com.ll.spring; import jakarta.servlet.annotation.WebServlet; import jakarta.servlet.http.HttpServlet; import jakarta.servlet.http.HttpServletRequest; import jakarta.servlet.http.HttpServletResponse; @WebServlet("/usr/*") public class DispatchServlet extends HttpServlet { // 조회 @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) { ControllerManager.runAction(req, resp); } // 등록 @Override protected void doPost(HttpServletRequest req, HttpServletResponse resp) { doGet(req, resp); } // 삭제 @Override protected void doDelete(HttpServletRequest req, HttpServletResponse resp) { doGet(req, resp); } // 수정 @Override protected void doPut(HttpServletRequest req, HttpServletResponse resp) { doGet(req, resp); } } ``` ```java package com.ll.spring.article.controller; import com.ll.spring.Rq; import com.ll.spring.annotation.*; import com.ll.spring.article.entity.Article; import com.ll.spring.article.service.ArticleService; import java.util.List; // ArticleController 가 컨트롤러 이다. // 아래 ArticleController 클래스는 Controller 이다. @Controller public class ArticleController { @Autowired private ArticleService articleService; @GetMapping("/usr/article/list") public void showList(Rq rq) { List

articles = articleService.getArticles(); rq.setAttr("articles", articles); rq.view("usr/article/list"); // src/main/webapp/jsp/usr/article/list.jsp 실행 } @GetMapping("/usr/article/write") public void showWrite(Rq rq) { rq.view("usr/article/write"); } @PostMapping("/usr/article/write") public void write(Rq rq) { String title = rq.getParam("title", ""); String body = rq.getParam("body", ""); if (title.length() == 0) { rq.historyBack("제목을 입력해주세요."); return; } if (body.length() == 0) { rq.historyBack("내용을 입력해주세요."); return; } long id = articleService.write(title, body); rq.replace("/usr/article/%d".formatted(id), "%d번 게시물이 생성 되었습니다.".formatted(id)); } @GetMapping("/usr/article/{id}") public void showDetail(Rq rq) { long id = rq.getLongParam("id", 0); if (id == 0) { rq.historyBack("번호를 입력해주세요."); return; } Article article = articleService.getArticleById(id); if (article == null) { rq.historyBack("해당 글이 존재하지 않습니다."); return; } Article prevArticle = articleService.getPrevArticle(article.getId()); Article nextArticle = articleService.getNextArticle(article.getId()); rq.setAttr("prevArticle", prevArticle); rq.setAttr("nextArticle", nextArticle); List

articles = articleService.getArticles(); rq.setAttr("articles", articles); rq.setAttr("article", article); rq.view("usr/article/detail"); } @PutMapping("/usr/article/modify/{id}") public void modify(Rq rq) { long id = rq.getLongParam("id", 0); if (id == 0) { rq.historyBack("번호를 입력해주세요."); return; } Article article = articleService.getArticleById(id); if (article == null) { rq.historyBack("해당 글이 존재하지 않습니다."); return; } String title = rq.getParam("title", ""); String body = rq.getParam("body", ""); if (title.length() == 0) { rq.historyBack("제목을 입력해주세요."); return; } if (body.length() == 0) { rq.historyBack("내용을 입력해주세요."); return; } articleService.modify(id, title, body); rq.replace("/usr/article/%d".formatted(id), "%d번 게시물이 수정 되었습니다.".formatted(id)); } @GetMapping("/usr/article/modify/{id}") public void showModify(Rq rq) { long id = rq.getLongParam("id", 0); if (id == 0) { rq.historyBack("번호를 입력해주세요."); return; } Article article = articleService.getArticleById(id); if (article == null) { rq.historyBack("해당 글이 존재하지 않습니다."); return; } String articleBody = article.getBody(); // 토스트UI 에디터 특성상 script를 t-script 로 치환해야 함 // 나중에 처리 rq.setAttr("articleBody", articleBody); rq.setAttr("article", article); rq.view("usr/article/modify"); } @DeleteMapping("/usr/article/delete/{id}") public void delete(Rq rq) { long id = rq.getLongParam("id", 0); if (id == 0) { rq.historyBack("번호를 입력해주세요."); return; } Article article = articleService.getArticleById(id); if (article == null) { rq.historyBack("해당 글이 존재하지 않습니다."); return; } articleService.delete(id); rq.replace("/usr/article/list", "%d번 게시물이 삭제 되었습니다.".formatted(id)); } } ``` ```java package com.ll.spring.article.service; import com.ll.spring.annotation.Autowired; import com.ll.spring.annotation.Service; import com.ll.spring.article.entity.Article; import com.ll.spring.article.repository.ArticleRepository; import java.util.List; @Service public class ArticleService { @Autowired private ArticleRepository articleRepository; public List

getArticles() { return articleRepository.getArticles(); } public Article getArticleById(long id) { return articleRepository.getArticleById(id); } public long getArticlesCount() { return articleRepository.getArticlesCount(); } public long write(String title, String body) { return write(title, body, false); } public long write(String title, String body, boolean isBlind) { return articleRepository.write(title, body, isBlind); } public void modify(long id, String title, String body) { modify(id, title, body, false); } public void modify(long id, String title, String body, boolean isBlind) { articleRepository.modify(id, title, body, isBlind); } public void delete(long id) { articleRepository.delete(id); } public Article getPrevArticle(Article article) { return getPrevArticle(article.getId()); } public Article getPrevArticle(long id) { return articleRepository.getPrevArticle(id); } public Article getNextArticle(long id) { return articleRepository.getNextArticle(id); } } ``` ```java import java.util.List; @Repository public class ArticleRepository { @Autowired private MyMap myMap; public List

getArticles() { SecSql sql = myMap.genSecSql(); sql .append("SELECT *") .append("FROM article") .append("ORDER BY id DESC"); return sql.selectRows(Article.class); } public Article getArticleById(long id) { SecSql sql = myMap.genSecSql(); sql .append("SELECT *") .append("FROM article") .append("WHERE id = ?", id); return sql.selectRow(Article.class); } public long getArticlesCount() { SecSql sql = myMap.genSecSql(); sql .append("SELECT COUNT(*)") .append("FROM article"); return sql.selectLong(); } public long write(String title, String body, boolean isBlind) { SecSql sql = myMap.genSecSql(); sql .append("INSERT INTO article") .append("SET createdDate = NOW()") .append(", modifiedDate = NOW()") .append(", title = ?", title) .append(", body = ?", body) .append(", isBlind = ?", isBlind); return sql.insert(); } public void modify(long id, String title, String body, boolean isBlind) { SecSql sql = myMap.genSecSql(); sql .append("UPDATE article") .append("SET modifiedDate = NOW()") .append(", title = ?", title) .append(", body = ?", body) .append(", isBlind = ?", isBlind) .append("WHERE id = ?", id); sql.update(); } public void delete(long id) { SecSql sql = myMap.genSecSql(); sql .append("DELETE FROM article") .append("WHERE id = ?", id); sql.update(); } public Article getPrevArticle(long id) { SecSql sql = myMap.genSecSql(); sql .append("SELECT *") .append("FROM article") .append("WHERE id < ?", id) .append("AND isBlind = 0") .append("ORDER BY id DESC") .append("LIMIT 1"); return sql.selectRow(Article.class); } public Article getNextArticle(long id) { SecSql sql = myMap.genSecSql(); sql .append("SELECT *") .append("FROM article") .append("WHERE id > ?", id) .append("AND isBlind = 0") .append("ORDER BY id ASC") .append("LIMIT 1"); return sql.selectRow(Article.class); } } ``` ```java package com.ll.spring.article.entity; import lombok.Data; import java.time.LocalDateTime; @Data public class Article { private long id; private LocalDateTime createdDate; private LocalDateTime modifiedDate; private String title; private String body; private boolean isBlind; } ``` ```java package com.ll.spring.mymap; import com.fasterxml.jackson.annotation.JsonAutoDetect; import com.fasterxml.jackson.annotation.PropertyAccessor; import com.fasterxml.jackson.databind.ObjectMapper; import com.fasterxml.jackson.databind.SerializationFeature; import com.fasterxml.jackson.datatype.jsr310.JavaTimeModule; import java.sql.*; import java.time.LocalDateTime; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import java.util.stream.Collectors; import java.util.stream.IntStream; public class SecSql { private final boolean isDevMode; private StringBuilder sqlBits; private List