$$config title: JSP 커뮤니티 기술서 keywords: - IT - JSP 커뮤니티 기술서 $$ # 개요 # 기능 ## 회원가입 ![이미지](https://i.imgur.com/MXaxe4z.png) ## 소스코드 ### doJoin ```java public class UserMemberController { .... @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.historyBackJsOnView("F-6", "email(을)를 입력해주세요."); } Member oldMember = memberService.getMemberByLoginId(loginId); if ( oldMember != null) { return rq.jshistoryBack("F-7", String.format("입력하신 로그인아이디(%s) (은)는 이미 사용중입니다.", loginId)); } // S-1 // 회원가입이 완료되었습니다. // Data 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); } } ``` ## 소스코드(상세) ### Join.jsp - Ajax ```java ``` ## 소스코드(상세) ### MemberService ```java public class MemberService { .... 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); } } ``` ## 소스코드(상세) ### MemberRepository ```java @Mapper public interface MemberRepository { @Insert(""" INSERT INTO `member` SET regDate = NOW(), updateDate = NOW(), loginId = #{loginId}, loginPw = #{loginPw}, `name` = #{name}, nickname = #{nickname}, cellphoneNo = #{cellphoneNo}, email = #{email} """) void join(@Param("loginId") String loginId, @Param("loginPw") String loginPw, @Param("name") String name, @Param("nickname") String nickname, @Param("cellphoneNo") String cellphoneNo, @Param("email") String email); ``` ## 가입 실패 ![이미지](https://i.imgur.com/zZuUY1i.png) --- 아이디는 Ajax를 통해 바로 확인할 수 있습니다. 중복확인은 아이디, 닉네임, 이메일이 돼 있으며, 알림 창에서 '확인' 클릭 시 이전 페이지로 돌아갑니다. ## 가입 성공 ![이미지](https://i.imgur.com/uPK4Cum.png) ![이미지](https://i.imgur.com/lpCCi2z.png) --- 중복된 것들이 없으면 정상적으로 회원가입이 완료되며, 알림창이 뜹니다. 알림 창에서 '확인' 버튼을 클릭 시 로그인 페이지로 넘어가게 됩니다. # 로그인/로그아웃 ## 로그인 ![이미지](https://i.imgur.com/1lSgail.png) ![이미지](https://i.imgur.com/IK10VEv.png) ![이미지](https://i.imgur.com/aG0h07K.png) --- 로그인 성공과 로그아웃 시 해당 사용자의 닉네임 표시와 함께 알림 창이 뜨도록 설정하였습니다. ## 소스코드 ### doLogin ```java public class UserMemberController { .... @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/doLogout") @ResponseBody public String doLogout(@RequestParam(defaultValue = "/") String afterLogoutUri) { rq.logout(); return rq.jsReplace("로그아웃 되었습니다.", afterLogoutUri); } } ``` ## 소스코드 ### MemberService ```java public Member getMemberByLoginId(String loginId) { return memberRepository.getMemberByLoginId(loginId); } ``` ## 소스코드 ### MemberRepository ```java @Select(""" SELECT * FROM `member` AS M WHERE M.loginId = #{loginId} """) Member getMemberByLoginId(@Param("loginId") String loginId); ``` ## 마이페이지/회원정보 수정 ![이미지](https://i.imgur.com/ibfW398.png) ![이미지](https://i.imgur.com/rL3UpEz.png) ![이미지](https://i.imgur.com/3PmL4XI.png) --- 회원정보 수정하기 전에 보안을 위해 비밀번호를 다시 한 번 더 입력해야 페이지 이동이 가능하게 하였습니다. 비밀번호를 입력 후 다음 페이지를 넘어가게 되면, URL에 authKey가 주어지게 됩니다. ![이미지](https://i.imgur.com/fRx3FF5.png) ## 소스코드 ### MemberController ```java @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(), "/"); } } ``` ## 소스코드 ### MemberService ```java public class MemberService { .... private Member getMemberByNameAndEmail(String name, String email) { return memberRepository.getMemberByNameAndEmail(name, email); } 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", "정상적인 코드입니다."); } } ``` ## 소스코드 ### MemberRepository ```java public interface MemberRepository { .... @Select(""" """) void modify(int id, String loginPw, String name, String nickname, String email, String cellphoneNo); } ``` ![이미지](https://i.imgur.com/k0xQsP0.png) --- 회원정보 수정이 완료됏다는 알림 창이 뜨면서 '확인' 클릭 시 이전 마이페이지로 이동합니다. 회원정보를 수정하지 않으면 기존 정보가 저장됩니다. ## 게시판 --- - 게시판은 공지사항게시판과 자유게시판 2개가 존재하며, 공지사항 게시판의 경우 관리자만 작성할 수 있게 작업예정입니다. - 게시판의 경우 본인이 작성한 글 이외엔 수정 및 삭제를 할 수 없습니다. - 게시물 작성 카테고리를 따로 만들어 두었고 작성에서 글을 게시할 게시판의 종류를 선택할 수 있습니다. - 또한 내용 작성 시 토스트 에디터를 통해 편리하게 글을 작성할 수 있게 했습니다. - 게시물 조회수인 hit 이라는 기능도 추가하였습니다. ![이미지](https://i.imgur.com/OtN1zNh.png) ![이미지](https://i.imgur.com/TFHH6IK.png) ![이미지](https://i.imgur.com/QFIb02h.png) ## 소스코드 ### doWrite, showList ```java public class UserArticleController { .... @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); } @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/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; } } ``` ## 소스코드 ### ArticleService ```java public class ArticleService { .... 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) { /* SELECT * FROM article WHERE boardId = 1 ORDER BY id DESC LIMIT 0, 10 */ 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; } } ``` ## 소스코드 ### ArticleRepository ```java public interface ArticleRepository { .... public void writeArticle(@Param("memberId") int memberId, @Param("boardId") int boardId, @Param("title") String title, @Param("body") String body); Select(""" """) public List

getForPrintArticles(int boardId, String searchKeywordTypeCode, String searchKeyword, int limitStart, int limitTake); @Select(""" """) public int getArticlesCount(int boardId, String searchKeywordTypeCode, String searchKeyword); } ``` ## 게시물 상세내용 ![이미지](https://i.imgur.com/aDuVbbi.png) --- 게시물 상세 내용에는 작성자와 작성날짜, 조회 수를 볼 수 있으며, 본인일 경우 수정/삭제가 가능하게 해놓았습니다. 게시물 맨 아래에는 로그인을 하면 댓글을 남길 수 있게 설정했습니다. ## 소스코드 ### detail ```java public class UserArticleController { .... @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; } } ``` ## 소스코드 ### ArticleService ```java public class ArticleService { .... public Article getForPrintArticle(int actorId, int id) { Article article = articleRepository.getForPrintArticle(id); updateForPrintData(actorId, article); return article; } } ``` ## 소스코드 ### ArticleRepository ```java public interface ArticleRepository { .... @Select(""" """) public Article getForPrintArticle(@Param("id") int id); @Update(""" """) public int increaseHitCount(int id); } ``` ## 게시물 삭제 ![이미지](https://i.imgur.com/x21Zdkr.png) ![이미지](https://i.imgur.com/xCFdzaw.png) --- 게시물을 삭제하기 전에 삭제 여부를 물어보며, '확인' 클릭 시 게시물이 삭제되었다는 알림이 뜨며 리스트로 돌아갑니다. 글을 작성하지 않은 작성자는 게시물을 삭제할 수 없으며, 로그인 되어있지 않은 상태에서 삭제하기 버튼을 누른다면 로그인 페이지로 돌아갑니다. ## 소스코드 ### doDelete ```java public class UserArticleController { .... @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"); } } ``` ## 소스코드 ### ArticleService ```java public class ArticleService { .... 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", "게시물 삭제가 가능합니다."); } } ``` ## 소스코드 ### ArticleRepository ```java public interface ArticleRepository { .... public void deleteArticle(@Param("id") int id); } ``` ## 게시물 수정 ![이미지](https://i.imgur.com/Fd50rOU.png) --- 게시물 수정은 작성할 때와 마찬가지로 토스트 에디터에서 이루어집니다. 수정 시 작성자만이 가능하며, 수정완료 후 리스트로 돌아갑니다. ## 소스코드 ### Modify, doModify ```java public class UserArticleController { .... @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(Model model) { return "usr/article/write"; } } ``` ## 소스코드 ### ArticleService ```java public class ArticleService { .... 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); } } ``` ## 소스코드 ### ArticleRepository ```java public interface ArticleRepository { .... public void modifyArticle(@Param("id") int id, @Param("title") String title, @Param("body") String body) } ``` ## 수정/삭제 권한체크 ## 소스코드 ### ArticleController ```java public class ArticleController { .... 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()); } } ``` ## 소스코드 ### ArticleService ```java public class ArticleService { .... 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 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", "게시물 삭제가 가능합니다."); } ``` --- 위 함수를 통해 본인 확인을 하여 수정/삭제할 수 있는지를 판단하여 JSP로 넘어가 if문을 통해 해당 함수를 사용하게 됩니다. 본인일 경우 수정/삭제 버튼이 보이고 본인이 아닐 경우 보이지 않게 했습니다. ## 댓글 ![이미지](https://i.imgur.com/grc3g48.png) --- 본인이 작성한 글 이외엔 수정 및 삭제할 수 없습니다. 댓글은 누구나 작성할 수 있으며, 로그인을 해야 댓글 작성이 가능합니다. 게시물 수정/삭제와 비슷한 방식으로 댓글 수정/삭제 코드도 작성했습니다. ## 소스코드 ### UserReplyController ```java public class UserReplyController { .... private ReplyService replyService; private ArticleService articleService; private Rq rq; public UserReplyController(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("relId(을)를 입력해주세요."); } 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 = (int) 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 doDelete(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); } } ``` ## 소스코드 ### ReplyService ```java 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 ResultData modifyReplyRd(int id, String body) { replyRepository.modifyReply(id, body); return ResultData.from("S-1", Ut.f("%d번 댓글을 수정하였습니다.", id)); } } ``` ## 소스코드 ### ReplyRepository ```java public interface ReplyRepository { .... @Insert(""" INSERT INTO reply SET regDate = NOW(), updateDate = NOW(), memberId = #{memberId}, relTypeCode = #{relTypeCode}, relId = #{relId}, body = #{body} """) void writeReply(int memberId, String relTypeCode, int relId, String body); @Select(""" SELECT LAST_INSERT_ID() """) int getLastInsertId(); @Select(""" SELECT R.*, M.nickname AS extra__writerName FROM reply AS R LEFT JOIN `member` AS M ON R.memberId = M.id WHERE R.relTypeCode = #{relTypeCode} AND R.relId = #{relId} ORDER BY R.id DESC """) List getForPrintReplies(String relTypeCode, int relId); @Select(""" SELECT R.*, M.nickname AS extra__writerName FROM reply AS R LEFT JOIN `member` AS M ON R.memberId = M.id WHERE R.id = #{id} """) Reply getForPrintReply(int id); @Delete(""" DELETE FROM reply WHERE id = #{id} """) void deleteReply(int id); @Update(""" UPDATE reply SET updateDate = NOW(), `body` = #{body} WHERE id = #{id} """) void modifyReply(int id, String body); } ``` ## 좋아요, 싫어요체크 ![이미지](https://i.imgur.com/u67DPsx.png) --- 게시물에 좋아요와 싫어요 버튼을 만들었으며, 좋아요와 싫어요는 동시에 누를 수 없고, 한 게시물에 둘 중 한가지를 선택해서 표시할 수 있습니다. 게시물에 적용한 방식으로 댓글에도 좋아요와 싫어요 적용 예정입니다. ## 소스코드 ### UserReactionPointController ```java public class UserReactionPointController { .... private ReactionPointService reactionPointService; private Rq rq; public UserReactionPointController(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 addGoodReactionPoint = reactionPointService.addGoodReactionPoint(rq.getLoginedMemberId(), relTypeCode, relId); return rq.jsReplace(addGoodReactionPoint.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); } } ``` ## 소스코드 ### ReactionPointService ```java 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", "싫어요가 취소처리 되었습니다"); } } ``` ## 소스코드 ### ReactionPointRepository ```java public interface ReactionPointRepository { .... @Select(""" SELECT IFNULL(SUM(RP.point), 0) AS s FROM reactionPoint AS RP WHERE RP.relTypeCode = #{relTypeCode} AND RP.relId = #{relId} AND RP.memberId = #{memberId} """) int getSumReactionPointByMemberId(String relTypeCode, int relId, int memberId); @Insert(""" INSERT INTO reactionPoint SET regDate = NOW(), updateDate = NOW(), relTypeCode = #{relTypeCode}, relId = #{relId}, memberId = #{memberId}, `point` = 1 """) void addGoodReactionPoint(int memberId, String relTypeCode, int relId); @Insert(""" INSERT INTO reactionPoint SET regDate = NOW(), updateDate = NOW(), relTypeCode = #{relTypeCode}, relId = #{relId}, memberId = #{memberId}, `point` = -1 """) void addBadReactionPoint(int memberId, String relTypeCode, int relId); @Delete(""" DELETE FROM reactionPoint WHERE relTypeCode = #{relTypeCode} AND relId = #{relId} AND memberId = #{memberId} """) void deleteReactionPoint(int memberId, String relTypeCode, int relId); } ``` --- 좋아요와 싫어요를 끝으로 포트폴리오를 마치겠습니다. 긴 글 읽어주셔서 감사합니다.