$$config title: 영화리뷰사이트 볼까말까 기술서 keywords: - IT - 기술서 - 스프링부트 $$ # ?영화리뷰사이트 볼까말까 ## ? 개요 - 사이트 : [볼까말까](https://site9.public.0fy.site/) - GITHUB : [git](https://github.com/fmfu51/sb_c_2022_2nd) - 공지사항으로 공지 전달 - 영화리뷰 게시판으로 리뷰 작성 ***
## ? 사용된 기술 ### • 버전 관리 ``` - GitHub ``` *** ### • 배포 환경 ``` - Tomcat - Docker ``` *** ### • 개발 환경 ``` ?️ - SpringBoot - SQLyog - Chrome - Tomcat - JSP - MariaDB - Windows 11 ``` *** ### • 서비스 환경 ``` ?️ - Nginx - MariaDB - Docker ``` *** ### • 기술 스택 ``` ?️ - STS(spring tool suite) - MariaDB - HTML, CSS, JS - Jquery - Tailwindcss - DaisyUI - JSP ``` ***
## ⚙️ 설계 패턴 - SpringBoot MVC 설계구조 ![https://ifh.cc/g/SfAx5O.jpg](https://ifh.cc/g/SfAx5O.jpg) ***
## ? 요구사항 분석 | RQ-ID | 화면명 | 요구사항명| 요구| 날짜 | 작성자 | 진행사항 | | --- | -- | --- | --- | --- | -- | --- | | RQ-0001 | 메인 | 상단 메뉴 구성 | 왼쪽상단 메인로고 클릭시 메인페이지로 이동 및 홈 버튼 따로 구성 | 02.16 | 박지은 | 반영 | | RQ-0002 | 공지사항 | 상단 메뉴 영역 | 유저들에게 공지사항을 전달하기 위한 기능 | 02.16 | 박지은 | 반영 | | RQ-0003 | 자유게시판 | 상단 메뉴 영역 | 유저들의 자유롭게 글작성가능하도록 구현 | 02.17 | 박지은 | 반영 | | RQ-0004 | 회원가입 | 상단 메뉴 영역 | 로그인을 하기위해선 회원가입은 필수 구축 | 02.18 | 박지은 | 반영 | | RQ-0005 | 로그인 | 상단 메뉴 영역 | 모든 글을 작성하기위해 로그인은 필수이기에 구축 | 02.21 | 박지은 | 반영 | | RQ-0006 | 검색 | 중간 영역 | 궁금한점을 검색하거나, 찾아보기 위해 검색 기능 구현 | 02.23 | 박지은 | 반영 | | RQ-0007 | 게시물 개수 | 상단 영역 | 게시물 개수 구현 | 03.20 | 박지은 | 반영 | | RQ-0008 | 댓글 | 하단 영역 | 질문의 답변을 하기위해 구현 | 04.03 | 박지은 | 반영 | | RQ-0009 | 좋아요, 싫어요 | 중간 영역 | 글의대한 평가를 위해 구현 | 04.18 | 박지은 | 반영 | | RQ-0010 | 조회수 | 중간 영역 | 몇명의 사용자가 보았는지 구분하기위해 구현 | 04.18 | 박지은 | 반영 | | RQ-0011 | 댓글 | 하단 영역 | 글에 대한 감상을 작성하기 위해 구현 | 08.19 | 박지은 | 반영 | | RQ-0012 | 회원가입 | 상단 메뉴 영역 | 개인의 회원가입을 위해 구현 | 04.18 | 박지은 | 반영 | | RQ-0013 | 마이페이지 | 상단 메뉴 영역 | 회원이 자신의 정보를 확인할 수 있도록 구현 | 08.20 | 박지은 | 반영 | | RQ-0014 | 회원정보수정 | 중간 영역 | 회원이 정보를 수정할 수 있도록 구현 | 08.20 | 박지은 | 반영 | | RQ-0015 | 로그인 후 페이지 이동 | 중간 영역 | 로그인 후 기존 페이지로 이동할 수 있도록 구현 | 08.21 | 박지은 | 반영 | | RQ-0016 | 아이디 중복 체크 | 중간 영역 | 로그인 및 가입 시 ajax로 아이디 중복 확인 | 08.22 | 박지은 | 반영 | | RQ-0017 | 다크모드 적용 | 상단 메뉴 영역 | 다크모드 및 라이트모드 기능 추가 | 08.23 | 박지은 | 반영 | | RQ-0013 | 배포 | 전체 | 메이븐 톰캣 원격배포 플러그인 적용 | 08.23 | 박지은 | 반영 | ***
## ? 주요 폴더 및 파일 ``` - UsrArticleController : 메뉴 리스트 - UsrHomeController : 실행 - UsrMemberController : 회원 - application.yml : 설정 - Ut.java : 메세지 - ResultData.java : 데이터 메세지 - Rq.java : HttpServletRequest, HttpServletResponse, Ajax ``` ***
## ?️기능현황 표 | 구분 | 기능 | 구현 | 테스트 | 배포 | --- | --- | --- | --- | --- | | 사용자 |회원가입|✔️|✔️|✔️| | 사용자 | 로그인 |✔️|✔️| ✔️| | 사용자 | 로그아웃 |✔️|✔️|✔️| | 영화리뷰 | 리스트 |✔️|✔️|✔️| | 공지사항 | 리스트 |✔️|✔️|✔️| | 전체메뉴 | 댓글 |✔️|✔️|✔️| | 전체메뉴 | 수정 |✔️|✔️|✔️| | 전체메뉴 | 삭제 |✔️|✔️|✔️| | 전체검색 | 검색 |✔️|✔️|✔️| | 기능 | 추천 |✔️|✔️|✔️| | 기능 | 조회수 |✔️|✔️|✔️| | 기능 | 마이페이지 |✔️|✔️|✔️| | 기능 | 다크모드 |✔️|✔️|✔️| ***
## 모델링 ### • ERD $$uml @startuml entity Member { ** 회원 테이블 ** ** 소프트딜리트 테이블 ** --- * id 번호, PK * regDate 등록날짜 * updateDate 갱신날짜 --- * delStatus 삭제여부(0=미삭제,1=삭제) delDate 삭제날짜 --- * loginId 로그인아이디 * loginPw 로그인비밀번호 * name 이름 * nickname 별명 * cellphoneNo 휴대전화번호 * email 이메일 --- * authLevel 권한레벨(권한레벨 : 3=일반,7=관리자) } entity Article{ ** 게시물 테이블 ** --- * id 번호, PK * regDate 등록날짜 * updateDate 갱신날짜 --- * memberId 회원번호, FK * boardId 게시판번호, FK --- * title 제목 * body 내용 * goodReactionPoint 좋아요수 * hitCount 조회수 } entity Reply{ ** 댓글 테이블 ** ** 모프테이블 ** --- * id 번호 * regDate 등록날짜 * updateDate 갱신날짜 --- * memberId 회원번호, FK * relTypeCode 관련데이터종류코드, MORPH_FK_TYPE * relId 관련데이터번호, MORPH_FK --- * body 내용 --- * value TEXT expireDate DATETIME } entity Board{ ** 게시판 테이블 ** --- * id 번호, PK * regDate 등록날짜 * updateDate 갱신날짜 --- * code 코드(유니크) * name 이름(유니크) --- * value TEXT expireDate DATETIME } entity ReactionPoint { ** 반응점수 테이블 ** ** 모프테이블 ** --- * id 번호 * regDate 등록날짜 * updateDate 갱신날짜 --- * memberId 회원번호, FK * relTypeCode 관련데이터종류코드, MORPH_FK_TYPE * relId 관련데이터번호, MORPH_FK --- * point 반응점수 } entity Attr{ ** 다용도 영속변수 테이블 ** ** 모프테이블 ** --- * id 번호, PK * regDate 등록날짜 * updateDate 갱신날짜 --- * relTypeCode 관련데이터종류코드, MORPH_FK_TYPE * relId 관련데이터번호, MORPH_FK * typeCode 변수종류타입 * type2Code 변수종류타입2 --- * value TEXT expireDate DATETIME } Attr }o..|| Member Reply }o..|| Article Article }o..|| Member Reply }o..|| Member ReactionPoint }o..|| Member Article }o..|| Board ReactionPoint }o..|| Reply ReactionPoint }o..|| Article @enduml $$ ***
## ? UI/UX 및 소스코드 ### • 메인 페이지 ![image](https://i.postimg.cc/8c1FCVZC/image.png)
### • 다크모드 ![image](https://i.postimg.cc/dQmrc551/image.png)
### • 로그인 ![image](https://i.postimg.cc/50Wgn62k/image.jpg)
### • 글쓰기 ![image](https://i.postimg.cc/rsQ9VjCv/image.png)
### • 공지사항 게시판 ![image](https://i.postimg.cc/pL7q50bv/image.jpg)
### • 영화리뷰 게시판 ![image](https://i.postimg.cc/hGdML9cd/image.jpg)
### • 상세페이지 및 댓글, 좋아요/싫어요 ![image](https://i.postimg.cc/G3fFQXhS/1.png)![image](https://i.postimg.cc/MKjyr1nZ/2.png)
### • 마이페이지 ![image](https://i.postimg.cc/761VcwCP/image.jpg)
### • 회원정보수정 ![image](https://i.postimg.cc/Fz9ZX8cy/image.jpg) ***
## 주요소스코드 ### 게시물 컨트롤러 ```java package com.pje.exam.demo.controller; import java.util.List; import javax.servlet.http.HttpServletRequest; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.ResponseBody; import com.pje.exam.demo.service.ArticleService; import com.pje.exam.demo.service.BoardService; import com.pje.exam.demo.service.ReactionPointService; import com.pje.exam.demo.service.ReplyService; import com.pje.exam.demo.util.Ut; import com.pje.exam.demo.vo.Article; import com.pje.exam.demo.vo.Board; import com.pje.exam.demo.vo.Reply; import com.pje.exam.demo.vo.ResultData; import com.pje.exam.demo.vo.Rq; @Controller public class UsrArticleController { private ArticleService articleService; private BoardService boardService; private ReactionPointService reactionPointService; private ReplyService replyService; private Rq rq; public UsrArticleController(ArticleService articleService, BoardService boardService, ReactionPointService reactionPointService, ReplyService replyService, Rq rq) { this.articleService = articleService; this.boardService = boardService; this.replyService = replyService; this.reactionPointService = reactionPointService; this.rq = rq; } @RequestMapping("/usr/article/list") public String showList(Model model, @RequestParam(defaultValue = "1") int boardId, @RequestParam(defaultValue = "title,body") String searchKeywordTypeCode, @RequestParam(defaultValue = "") String searchKeyword, @RequestParam(defaultValue = "1") int page) { Board board = boardService.getBoardById(boardId); if (board == null) { return rq.historyBackJsOnView(Ut.f("%d번 게시판은 존재하지 않습니다.", boardId)); } int articlesCount = articleService.getArticlesCount(boardId, searchKeywordTypeCode, searchKeyword); int itemsCountInAPage = 10; int pagesCount = (int) Math.ceil((double) articlesCount / itemsCountInAPage); List

articles = articleService.getForPrintArticles(rq.getLoginedMemberId(), boardId, searchKeywordTypeCode, searchKeyword, itemsCountInAPage, page); model.addAttribute("boardId", boardId); model.addAttribute("page", page); model.addAttribute("board", board); model.addAttribute("pagesCount", pagesCount); model.addAttribute("articlesCount", articlesCount); model.addAttribute("articles", articles); return "usr/article/list"; } @RequestMapping("/usr/article/detail") public String showDetail(Model model, int id) { Article article = articleService.getForPrintArticle(rq.getLoginedMemberId(), id); model.addAttribute("article", article); List replies = replyService.getForPrintReplies(rq.getLoginedMember(), "article", id); int repliesCount = replies.size(); model.addAttribute("replies", replies); ResultData actorCanMakeReactionPointRd = reactionPointService.actorCanMakeReactionPoint(rq.getLoginedMemberId(), "article", id); model.addAttribute("actorCanMakeReaction", actorCanMakeReactionPointRd.isSuccess()); if (actorCanMakeReactionPointRd.getResultCode().equals("F-2")) { int sumReactionPointByMemberId = (int) actorCanMakeReactionPointRd.getData1(); if (sumReactionPointByMemberId > 0) { model.addAttribute("actorCanCancelGoodReaction", true); } else { model.addAttribute("actorCanCancelBadReaction", true); } } return "usr/article/detail"; } @RequestMapping("/usr/article/doIncreaseHitCountRd") @ResponseBody public ResultData doIncreaseHitCountRd(int id) { ResultData increaseHitCountRd = articleService.increaseHitCount(id); if (increaseHitCountRd.isFail()) { return increaseHitCountRd; } ResultData rd = ResultData.newData(increaseHitCountRd, "hitCount", articleService.getArticleHitCount(id)); rd.setData2("id", id); return rd; } @RequestMapping("/usr/article/getArticle") @ResponseBody public ResultData

getArticle(int id) { Article article = articleService.getForPrintArticle(rq.getLoginedMemberId(), id); if (article == null) { return ResultData.from("F-1", Ut.f("%d번 게시물이 존재하지 않습니다.", id)); } return ResultData.from("S-1", Ut.f("%d번 게시물입니다.", id), "article", article); } @RequestMapping("/usr/article/doDelete") @ResponseBody public String doDelete(int id) { Article article = articleService.getForPrintArticle(rq.getLoginedMemberId(), id); if (article == null) { rq.jsHistoryBack(Ut.f("%d번 게시물이 존재하지 않습니다.", id)); } if (article.getMemberId() != rq.getLoginedMemberId()) { return rq.jsHistoryBack("권한이 없습니다."); } articleService.deleteArticle(id); return rq.jsReplace(Ut.f("%d번 게시물을 삭제하였습니다.", id), "../article/list"); } @RequestMapping("/usr/article/modify") public String showModify(Model model, int id) { Article article = articleService.getForPrintArticle(rq.getLoginedMemberId(), id); if (article == null) { return rq.historyBackJsOnView(Ut.f("%d번 게시물이 존재하지 않습니다.", id)); } ResultData actorCanModifyRd = articleService.actorCanModify(rq.getLoginedMemberId(), article); if (actorCanModifyRd.isFail()) { return rq.historyBackJsOnView(actorCanModifyRd.getMsg()); } model.addAttribute("article", article); return "usr/article/modify"; } @RequestMapping("/usr/article/doModify") @ResponseBody public String doModify(int id, String title, String body) { Article article = articleService.getForPrintArticle(rq.getLoginedMemberId(), id); if (article == null) { return rq.jsHistoryBack(Ut.f("%d번 게시물이 존재하지 않습니다.", id)); } ResultData actorCanModifyRd = articleService.actorCanModify(rq.getLoginedMemberId(), article); if (actorCanModifyRd.isFail()) { return rq.jsHistoryBack(actorCanModifyRd.getMsg()); } articleService.modifyArticle(id, title, body); return rq.jsReplace(Ut.f("%d번 글이 수정되었습니다.", id), Ut.f("../article/detail?id=%d", id)); } @RequestMapping("/usr/article/write") public String showWrite(HttpServletRequest req, Model model) { return "usr/article/write"; } @RequestMapping("/usr/article/doWrite") @ResponseBody public String doWrite(int boardId, String title, String body, String replaceUri) { if (Ut.empty(title)) { return rq.jsHistoryBack("title(을)를 입력해주세요."); } if (Ut.empty(body)) { return rq.jsHistoryBack("body(을)를 입력해주세요."); } ResultData writeArticleRd = articleService.writeArticle(rq.getLoginedMemberId(), boardId, title, body); int id = writeArticleRd.getData1(); if (Ut.empty(replaceUri)) { replaceUri = Ut.f("../article/detail?id=%d", id); } return rq.jsReplace(Ut.f("%d번 글이 생성되었습니다.", id), replaceUri); } } ```
### 게시물 서비스 ```java package com.pje.exam.demo.service; import java.util.List; import org.springframework.stereotype.Service; import com.pje.exam.demo.repository.ArticleRepository; import com.pje.exam.demo.util.Ut; import com.pje.exam.demo.vo.Article; import com.pje.exam.demo.vo.ResultData; @Service public class ArticleService { private ArticleRepository articleRepository; public ArticleService(ArticleRepository articleRepository) { this.articleRepository = articleRepository; } public ResultData writeArticle(int memberId, int boardId, String title, String body) { articleRepository.writeArticle(memberId, boardId, title, body); int id = articleRepository.getLastInsertId(); return ResultData.from("S-1", Ut.f("%d번 게시물이 생성되었습니다.", id), "id", id); } public List

getForPrintArticles(int actorId, int boardId, String searchKeywordTypeCode, String searchKeyword, int itemsCountInAPage, int page) { int limitStart = (page - 1) * itemsCountInAPage; int limitTake = itemsCountInAPage; List

articles = articleRepository.getForPrintArticles(boardId, searchKeywordTypeCode, searchKeyword, limitStart, limitTake); for (Article article : articles) { updateForPrintData(actorId, article); } return articles; } public Article getForPrintArticle(int actorId, int id) { Article article = articleRepository.getForPrintArticle(id); updateForPrintData(actorId, article); return article; } private void updateForPrintData(int actorId, Article article) { if (article == null) { return; } ResultData actorCanDeleteRd = actorCanDelete(actorId, article); article.setExtra__actorCanDelete(actorCanDeleteRd.isSuccess()); ResultData actorCanModifyRd = actorCanModify(actorId, article); article.setExtra__actorCanModify(actorCanModifyRd.isSuccess()); } public void deleteArticle(int id) { articleRepository.deleteArticle(id); } public ResultData

modifyArticle(int id, String title, String body) { articleRepository.modifyArticle(id, title, body); Article article = getForPrintArticle(0, id); return ResultData.from("S-1", Ut.f("%d번 게시물이 수정되었습니다.", id), "article", article); } public ResultData actorCanModify(int actorId, Article article) { if (article == null) { return ResultData.from("F-1", "게시물이 존재하지 않습니다."); } if (article.getMemberId() != actorId) { return ResultData.from("F-2", "권한이 없습니다."); } return ResultData.from("S-1", "게시물 수정이 가능합니다."); } public ResultData actorCanDelete(int actorId, Article article) { if (article == null) { return ResultData.from("F-1", "게시물이 존재하지 않습니다."); } if (article.getMemberId() != actorId) { return ResultData.from("F-2", "권한이 없습니다."); } return ResultData.from("S-1", "게시물 삭제가 가능합니다."); } public int getArticlesCount(int boardId, String searchKeywordTypeCode, String searchKeyword) { return articleRepository.getArticlesCount(boardId, searchKeywordTypeCode, searchKeyword); } public ResultData increaseHitCount(int id) { int affectedRowsCount = articleRepository.increaseHitCount(id); if (affectedRowsCount == 0) { return ResultData.from("F-1", "해당 게시물이 존재하지 않습니다.", "affectedRowsCount", affectedRowsCount); } return ResultData.from("S-1", "조회수가 증가되었습니다.", "affectedRowsCount", affectedRowsCount); } public int getArticleHitCount(int id) { return articleRepository.getArticleHitCount(id); } public ResultData increaseGoodReactionPoint(int relId) { int affectedRowsCount = articleRepository.increaseGoodReactionPoint(relId); if (affectedRowsCount == 0) { return ResultData.from("F-1", "해당 게시물이 존재하지 않습니다.", "affectedRowsCount", affectedRowsCount); } return ResultData.from("S-1", "좋아요 수가 증가되었습니다.", "affectedRowsCount", affectedRowsCount); } public ResultData increaseBadReactionPoint(int relId) { int affectedRowsCount = articleRepository.increaseBadReactionPoint(relId); if (affectedRowsCount == 0) { return ResultData.from("F-1", "해당 게시물이 존재하지 않습니다.", "affectedRowsCount", affectedRowsCount); } return ResultData.from("S-1", "싫어요 수가 증가되었습니다.", "affectedRowsCount", affectedRowsCount); } public ResultData decreaseGoodReactionPoint(int relId) { int affectedRowsCount = articleRepository.decreaseGoodReactionPoint(relId); if (affectedRowsCount == 0) { return ResultData.from("F-1", "해당 게시물이 존재하지 않습니다.", "affectedRowsCount", affectedRowsCount); } return ResultData.from("S-1", "좋아요d 수가 감소되었습니다.", "affectedRowsCount", affectedRowsCount); } public ResultData decreaseBadReactionPoint(int relId) { int affectedRowsCount = articleRepository.decreaseBadReactionPoint(relId); if (affectedRowsCount == 0) { return ResultData.from("F-1", "해당 게시물이 존재하지 않습니다.", "affectedRowsCount", affectedRowsCount); } return ResultData.from("S-1", "싫어요 수가 감소되었습니다.", "affectedRowsCount", affectedRowsCount); } public Article getArticle(int id) { return articleRepository.getArticle(id); } } ```
### 멤버 컨트롤러 ```java package com.pje.exam.demo.controller; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.ResponseBody; import com.pje.exam.demo.service.MemberService; import com.pje.exam.demo.util.Ut; import com.pje.exam.demo.vo.Member; import com.pje.exam.demo.vo.ResultData; import com.pje.exam.demo.vo.Rq; @Controller public class UsrMemberController { private MemberService memberService; private Rq rq; public UsrMemberController(MemberService memberService, Rq rq) { this.memberService = memberService; this.rq = rq; } @RequestMapping("/usr/member/getLoginIdDup") @ResponseBody public ResultData getLoginIdDup(String loginId) { if (Ut.empty(loginId)) { return ResultData.from("F-A1", "loginId를 입력해주세요."); } Member oldMember = memberService.getMemberByLoginId(loginId); if (oldMember != null) { return ResultData.from("F-A2", "해당 로그인아이디는 이미 사용중입니다.", "loginId", loginId); } return ResultData.from("S-1", "사용가능한 로그인아이디 입니다.", "loginId", loginId); } @RequestMapping("/usr/member/doJoin") @ResponseBody public String doJoin(String loginId, String loginPw, String name, String nickname, String cellphoneNo, String email, @RequestParam(defaultValue = "/") String afterLoginUri) { if (Ut.empty(loginId)) { return rq.jsHistoryBack("F-1", "loginId(을)를 입력해주세요."); } if (Ut.empty(loginPw)) { return rq.jsHistoryBack("F-2", "loginPw(을)를 입력해주세요."); } if (Ut.empty(name)) { return rq.jsHistoryBack("F-3", "name(을)를 입력해주세요."); } if (Ut.empty(nickname)) { return rq.jsHistoryBack("F-4", "nickname(을)를 입력해주세요."); } if (Ut.empty(cellphoneNo)) { return rq.jsHistoryBack("F-5", "cellphoneNo(을)를 입력해주세요."); } if (Ut.empty(email)) { return rq.jsHistoryBack("F-6", "email(을)를 입력해주세요."); } ResultData joinRd = memberService.join(loginId, loginPw, name, nickname, cellphoneNo, email); if (joinRd.isFail()) { return rq.jsHistoryBack(joinRd.getResultCode(), joinRd.getMsg()); } String afterJoinUri = "../member/login?afterLoginUri=" + Ut.getUriEncoded(afterLoginUri); return rq.jsReplace("회원가입이 완료되었습니다. 로그인 후 이용해주세요.", afterJoinUri); } @RequestMapping("/usr/member/doLogout") @ResponseBody public String doLogout(@RequestParam(defaultValue = "/") String afterLogoutUri) { rq.logout(); return rq.jsReplace("로그아웃 되었습니다.", afterLogoutUri); } @RequestMapping("/usr/member/login") public String showLogin() { return "usr/member/login"; } @RequestMapping("/usr/member/join") public String showJoin() { return "usr/member/join"; } @RequestMapping("/usr/member/doLogin") @ResponseBody public String doLogin(String loginId, String loginPw, @RequestParam(defaultValue = "/") String afterLoginUri) { if (Ut.empty(loginId)) { return rq.jsHistoryBack("loginId(을)를 입력해주세요."); } if (Ut.empty(loginPw)) { return rq.jsHistoryBack("loginPw(을)를 입력해주세요."); } Member member = memberService.getMemberByLoginId(loginId); if (member == null) { return rq.jsHistoryBack("존재하지 않은 로그인아이디 입니다."); } if (member.getLoginPw().equals(loginPw) == false) { return rq.jsHistoryBack("비밀번호가 일치하지 않습니다."); } rq.login(member); return rq.jsReplace(Ut.f("%s님 환영합니다.", member.getNickname()), afterLoginUri); } @RequestMapping("/usr/member/myPage") public String showMyPage() { return "usr/member/myPage"; } @RequestMapping("/usr/member/checkPassword") public String showCheckPassword() { return "usr/member/checkPassword"; } @RequestMapping("/usr/member/doCheckPassword") @ResponseBody public String doCheckPassword(String loginPw, String replaceUri) { if (Ut.empty(loginPw)) { return rq.jsHistoryBack("loginPw(을)를 입력해주세요."); } if (rq.getLoginedMember().getLoginPw().equals(loginPw) == false) { return rq.jsHistoryBack("비밀번호가 일치하지 않습니다."); } if (replaceUri.equals("../member/modify")) { String memberModifyAuthKey = memberService.genMemberModifyAuthKey(rq.getLoginedMemberId()); replaceUri += "?memberModifyAuthKey=" + memberModifyAuthKey; } return rq.jsReplace("", replaceUri); } @RequestMapping("/usr/member/modify") public String showModify(String memberModifyAuthKey) { if (Ut.empty(memberModifyAuthKey)) { return rq.historyBackJsOnView("memberModifyAuthKey(이)가 필요합니다."); } ResultData checkMemberModifyAuthKeyRd = memberService.checkMemberModifyAuthKey(rq.getLoginedMemberId(), memberModifyAuthKey); if (checkMemberModifyAuthKeyRd.isFail()) { return rq.historyBackJsOnView(checkMemberModifyAuthKeyRd.getMsg()); } return "usr/member/modify"; } @RequestMapping("/usr/member/doModify") @ResponseBody public String doModify(String memberModifyAuthKey, String loginPw, String name, String nickname, String email, String cellphoneNo) { if (Ut.empty(memberModifyAuthKey)) { return rq.jsHistoryBack("memberModifyAuthKey(이)가 필요합니다."); } ResultData checkMemberModifyAuthKeyRd = memberService.checkMemberModifyAuthKey(rq.getLoginedMemberId(), memberModifyAuthKey); if (checkMemberModifyAuthKeyRd.isFail()) { return rq.jsHistoryBack(checkMemberModifyAuthKeyRd.getMsg()); } if (Ut.empty(loginPw)) { loginPw = null; } if (Ut.empty(name)) { return rq.jsHistoryBack("name(을)를 입력해주세요."); } if (Ut.empty(nickname)) { return rq.jsHistoryBack("nickname(을)를 입력해주세요."); } if (Ut.empty(email)) { return rq.jsHistoryBack("email(을)를 입력해주세요."); } if (Ut.empty(cellphoneNo)) { return rq.jsHistoryBack("cellphoneNo(을)를 입력해주세요."); } ResultData modifyRd = memberService.modify(rq.getLoginedMemberId(), loginPw, name, nickname, email, cellphoneNo); return rq.jsReplace(modifyRd.getMsg(), "/"); } } ```
### 멤버 서비스 ```java package com.pje.exam.demo.service; import org.springframework.stereotype.Service; import com.pje.exam.demo.repository.MemberRepository; import com.pje.exam.demo.util.Ut; import com.pje.exam.demo.vo.Member; import com.pje.exam.demo.vo.ResultData; @Service public class MemberService { private MemberRepository memberRepository; private AttrService attrService; public MemberService(AttrService attrService, MemberRepository memberRepository) { this.attrService = attrService; this.memberRepository = memberRepository; } public ResultData join(String loginId, String loginPw, String name, String nickname, String cellphoneNo, String email) { // 로그인아이디 중복체크 Member oldMember = getMemberByLoginId(loginId); if (oldMember != null) { return ResultData.from("F-7", Ut.f("해당 로그인아이디(%s)는 이미 사용중입니다.", loginId)); } // 이름+이메일 중복체크 oldMember = getMemberByNameAndEmail(name, email); if (oldMember != null) { return ResultData.from("F-8", Ut.f("해당 이름(%s)과 이메일(%s)은 이미 사용중입니다.", name, email)); } memberRepository.join(loginId, loginPw, name, nickname, cellphoneNo, email); int id = memberRepository.getLastInsertId(); return ResultData.from("S-1", "회원가입이 완료되었습니다.", "id", id); } private Member getMemberByNameAndEmail(String name, String email) { return memberRepository.getMemberByNameAndEmail(name, email); } public Member getMemberByLoginId(String loginId) { return memberRepository.getMemberByLoginId(loginId); } public Member getMemberById(int id) { return memberRepository.getMemberById(id); } public ResultData modify(int id, String loginPw, String name, String nickname, String email, String cellphoneNo) { memberRepository.modify(id, loginPw, name, nickname, email, cellphoneNo); return ResultData.from("S-1", "회원정보가 수정되었습니다."); } public String genMemberModifyAuthKey(int actorId) { String memberModifyAuthKey = Ut.getTempPassword(10); attrService.setValue("member", actorId, "extra", "memberModifyAuthKey", memberModifyAuthKey, Ut.getDateStrLater(60 * 5)); return memberModifyAuthKey; } public ResultData checkMemberModifyAuthKey(int actorId, String memberModifyAuthKey) { String saved = attrService.getValue("member", actorId, "extra", "memberModifyAuthKey"); if ( !saved.equals(memberModifyAuthKey) ) { return ResultData.from("F-1", "일치하지 않거나 만료되었습니다."); } return ResultData.from("S-1", "정상적인 코드입니다."); } } ```

### 좋아요, 싫어요 컨트롤러 ```java package com.pje.exam.demo.controller; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.ResponseBody; import com.pje.exam.demo.service.ReactionPointService; import com.pje.exam.demo.vo.ResultData; import com.pje.exam.demo.vo.Rq; @Controller public class UsrReactionPointController { private ReactionPointService reactionPointService; private Rq rq; public UsrReactionPointController(ReactionPointService reactionPointService, Rq rq) { this.reactionPointService = reactionPointService; this.rq = rq; } @RequestMapping("/usr/reactionPoint/doGoodReaction") @ResponseBody String doGoodReaction(String relTypeCode, int relId, String replaceUri) { ResultData actorCanMakeReactionPointRd = reactionPointService.actorCanMakeReactionPoint(rq.getLoginedMemberId(), relTypeCode, relId); if (actorCanMakeReactionPointRd.isFail()) { return rq.jsHistoryBack(actorCanMakeReactionPointRd.getMsg()); } ResultData addGoodReactionPointRd = reactionPointService.addGoodReactionPoint(rq.getLoginedMemberId(), relTypeCode, relId); return rq.jsReplace(addGoodReactionPointRd.getMsg(), replaceUri); } @RequestMapping("/usr/reactionPoint/doBadReaction") @ResponseBody String doBadReaction(String relTypeCode, int relId, String replaceUri) { ResultData actorCanMakeReactionPointRd = reactionPointService.actorCanMakeReactionPoint(rq.getLoginedMemberId(), relTypeCode, relId); if (actorCanMakeReactionPointRd.isFail()) { return rq.jsHistoryBack(actorCanMakeReactionPointRd.getMsg()); } ResultData addBadReactionPointRd = reactionPointService.addBadReactionPoint(rq.getLoginedMemberId(), relTypeCode, relId); return rq.jsReplace(addBadReactionPointRd.getMsg(), replaceUri); } @RequestMapping("/usr/reactionPoint/doCancelGoodReaction") @ResponseBody String doCancelGoodReaction(String relTypeCode, int relId, String replaceUri) { ResultData actorCanMakeReactionPointRd = reactionPointService.actorCanMakeReactionPoint(rq.getLoginedMemberId(), relTypeCode, relId); if (actorCanMakeReactionPointRd.isSuccess()) { return rq.jsHistoryBack("이미 취소되었습니다."); } ResultData deleteGoodReactionPointRd = reactionPointService.deleteGoodReactionPoint(rq.getLoginedMemberId(), relTypeCode, relId); return rq.jsReplace(deleteGoodReactionPointRd.getMsg(), replaceUri); } @RequestMapping("/usr/reactionPoint/doCancelBadReaction") @ResponseBody String doCancelBadReaction(String relTypeCode, int relId, String replaceUri) { ResultData actorCanMakeReactionPointRd = reactionPointService.actorCanMakeReactionPoint(rq.getLoginedMemberId(), relTypeCode, relId); if (actorCanMakeReactionPointRd.isSuccess()) { return rq.jsHistoryBack("이미 취소되었습니다."); } ResultData deleteBadReactionPointRd = reactionPointService.deleteBadReactionPoint(rq.getLoginedMemberId(), relTypeCode, relId); return rq.jsReplace(deleteBadReactionPointRd.getMsg(), replaceUri); } } ```
### 좋아요, 싫어요 서비스 ```java package com.pje.exam.demo.service; import org.springframework.stereotype.Service; import com.pje.exam.demo.repository.ReactionPointRepository; import com.pje.exam.demo.vo.ResultData; @Service public class ReactionPointService { private ReactionPointRepository reactionPointRepository; private ArticleService articleService; public ReactionPointService(ReactionPointRepository reactionPointRepository, ArticleService articleService) { this.reactionPointRepository = reactionPointRepository; this.articleService = articleService; } public ResultData actorCanMakeReactionPoint(int actorId, String relTypeCode, int relId) { if (actorId == 0) { return ResultData.from("F-1", "로그인 후 이용해주세요."); } int sumReactionPointByMemberId = reactionPointRepository.getSumReactionPointByMemberId(relTypeCode, relId, actorId); if (sumReactionPointByMemberId != 0) { return ResultData.from("F-2", "리액션이 불가능합니다.", "sumReactionPointByMemberId", sumReactionPointByMemberId); } return ResultData.from("S-1", "리액션이 가능합니다.", "sumReactionPointByMemberId", sumReactionPointByMemberId); } public ResultData addGoodReactionPoint(int actorId, String relTypeCode, int relId) { reactionPointRepository.addGoodReactionPoint(actorId, relTypeCode, relId); switch (relTypeCode) { case "article": articleService.increaseGoodReactionPoint(relId); break; } return ResultData.from("S-1", "좋아요 처리 되었습니다"); } public ResultData addBadReactionPoint(int actorId, String relTypeCode, int relId) { reactionPointRepository.addBadReactionPoint(actorId, relTypeCode, relId); switch (relTypeCode) { case "article": articleService.increaseBadReactionPoint(relId); break; } return ResultData.from("S-1", "싫어요 처리 되었습니다"); } public ResultData deleteGoodReactionPoint(int actorId, String relTypeCode, int relId) { reactionPointRepository.deleteReactionPoint(actorId, relTypeCode, relId); switch (relTypeCode) { case "article": articleService.decreaseGoodReactionPoint(relId); break; } return ResultData.from("S-1", "좋아요가 취소처리 되었습니다"); } public ResultData deleteBadReactionPoint(int actorId, String relTypeCode, int relId) { reactionPointRepository.deleteReactionPoint(actorId, relTypeCode, relId); switch (relTypeCode) { case "article": articleService.decreaseBadReactionPoint(relId); break; } return ResultData.from("S-1", "싫어요 취소처리 되었습니다"); } } ```
### 댓글 컨트롤러 ```java package com.pje.exam.demo.controller; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.ResponseBody; import com.pje.exam.demo.service.ArticleService; import com.pje.exam.demo.service.ReplyService; import com.pje.exam.demo.util.Ut; import com.pje.exam.demo.vo.Article; import com.pje.exam.demo.vo.Reply; import com.pje.exam.demo.vo.ResultData; import com.pje.exam.demo.vo.Rq; @Controller public class UsrReplyController { private ReplyService replyService; private ArticleService articleService; private Rq rq; public UsrReplyController(ReplyService replyService, ArticleService articleService, Rq rq) { this.replyService = replyService; this.articleService = articleService; this.rq = rq; } @RequestMapping("/usr/reply/modify") public String modify(int id, String replaceUri, Model model) { if (Ut.empty(id)) { return rq.jsHistoryBack("id(을)를 입력해주세요."); } Reply reply = replyService.getForPrintReply(rq.getLoginedMember(), id); if (reply == null) { return rq.historyBackJsOnView(Ut.f("%d번 댓글은 존재하지 않습니다.", id)); } if (reply.isExtra__actorCanModify() == false) { return rq.historyBackJsOnView(Ut.f("%d번 댓글을 수정할 권한이 없습니다.", id)); } String relDataTitle = null; switch (reply.getRelTypeCode()) { case "article": Article article = articleService.getArticle(reply.getRelId()); relDataTitle = article.getTitle(); } model.addAttribute("relDataTitle", relDataTitle); model.addAttribute("reply", reply); return "usr/reply/modify"; } @RequestMapping("/usr/reply/doModify") @ResponseBody public String doModify(int id, String body, String replaceUri) { if (Ut.empty(id)) { return rq.jsHistoryBack("id(을)를 입력해주세요."); } Reply reply = replyService.getForPrintReply(rq.getLoginedMember(), id); if (reply == null) { return rq.historyBackJsOnView(Ut.f("%d번 댓글은 존재하지 않습니다.", id)); } if (reply.isExtra__actorCanModify() == false) { return rq.historyBackJsOnView(Ut.f("%d번 댓글을 수정할 권한이 없습니다.", id)); } if (Ut.empty(body)) { return rq.jsHistoryBack("body(을)를 입력해주세요."); } ResultData modifyReplyRd = replyService.modifyReplyRd(id, body); if (Ut.empty(replaceUri)) { switch (reply.getRelTypeCode()) { case "article": replaceUri = Ut.f("../article/detail?id=%d", reply.getRelId()); break; } } return rq.jsReplace(modifyReplyRd.getMsg(), replaceUri); } @RequestMapping("/usr/reply/doWrite") @ResponseBody public String doWrite(String relTypeCode, int relId, String body, String replaceUri) { if (Ut.empty(relTypeCode)) { return rq.jsHistoryBack("relTypeCode(을)를 입력해주세요."); } if (Ut.empty(relId)) { return rq.jsHistoryBack("relId(을)를 입력해주세요."); } if (Ut.empty(body)) { return rq.jsHistoryBack("body(을)를 입력해주세요."); } ResultData writeReplyRd = replyService.writeReply(rq.getLoginedMemberId(), relTypeCode, relId, body); int id = writeReplyRd.getData1(); if (Ut.empty(replaceUri)) { switch (relTypeCode) { case "article": replaceUri = Ut.f("../article/detail?id=%d", relId); break; } } return rq.jsReplace(writeReplyRd.getMsg(), replaceUri); } @RequestMapping("/usr/reply/doDelete") @ResponseBody public String doWrite(int id, String replaceUri) { if (Ut.empty(id)) { return rq.jsHistoryBack("id(을)를 입력해주세요."); } Reply reply = replyService.getForPrintReply(rq.getLoginedMember(), id); if (reply == null) { return rq.jsHistoryBack(Ut.f("%d번 댓글은 존재하지 않습니다.", id)); } if (reply.isExtra__actorCanDelete() == false) { return rq.jsHistoryBack(Ut.f("%d번 댓글을 삭제할 권한이 없습니다.", id)); } ResultData deleteReplyRd = replyService.deleteReply(id); if (Ut.empty(replaceUri)) { switch (reply.getRelTypeCode()) { case "article": replaceUri = Ut.f("../article/detail?id=%d", reply.getRelId()); break; } } return rq.jsReplace(deleteReplyRd.getMsg(), replaceUri); } } ```
### 댓글 서비스 ```java package com.pje.exam.demo.service; import java.util.List; import org.springframework.stereotype.Service; import com.pje.exam.demo.repository.ReplyRepository; import com.pje.exam.demo.util.Ut; import com.pje.exam.demo.vo.Member; import com.pje.exam.demo.vo.Reply; import com.pje.exam.demo.vo.ResultData; @Service public class ReplyService { private ReplyRepository replyRepository; public ReplyService(ReplyRepository replyRepository) { this.replyRepository = replyRepository; } public ResultData writeReply(int actorId, String relTypeCode, int relId, String body) { replyRepository.writeReply(actorId, relTypeCode, relId, body); int id = replyRepository.getLastInsertId(); return ResultData.from("S-1", Ut.f("%d번 댓글이 생성되었습니다.", id), "id", id); } public List getForPrintReplies(Member actor, String relTypeCode, int relId) { List replies = replyRepository.getForPrintReplies(relTypeCode, relId); for (Reply reply : replies) { updateForPrintData(actor, reply); } return replies; } private void updateForPrintData(Member actor, Reply reply) { if (reply == null) { return; } ResultData actorCanDeleteRd = actorCanDelete(actor, reply); reply.setExtra__actorCanDelete(actorCanDeleteRd.isSuccess()); ResultData actorCanModifyRd = actorCanModify(actor, reply); reply.setExtra__actorCanModify(actorCanModifyRd.isSuccess()); } private ResultData actorCanModify(Member actor, Reply reply) { if (actor == null) { return ResultData.from("F-1", "댓글이 존재하지 않습니다."); } if (reply.getMemberId() != actor.getId()) { return ResultData.from("F-2", "권한이 없습니다."); } return ResultData.from("S-1", "댓글 삭제가 가능합니다."); } private ResultData actorCanDelete(Member actor, Reply reply) { if (actor == null) { return ResultData.from("F-1", "댓글이 존재하지 않습니다."); } if (reply.getMemberId() != actor.getId()) { return ResultData.from("F-2", "권한이 없습니다."); } return ResultData.from("S-1", "댓글 수정이 가능합니다."); } public Reply getForPrintReply(Member actor, int id) { Reply reply = replyRepository.getForPrintReply(id); updateForPrintData(actor, reply); return reply; } public ResultData deleteReply(int id) { replyRepository.deleteReply(id); return ResultData.from("S-1", Ut.f("%d번 댓글을 삭제하였습니다.", id)); } public Reply getReply(int id) { return replyRepository.getReply(id); } public ResultData modifyReplyRd(int id, String body) { replyRepository.modifyReply(id, body); return ResultData.from("S-1", Ut.f("%d번 댓글을 수정하였습니다.", id)); } } ```

게시글 상세