$$config title: ToolTool 프로젝트 기술서 keywords: - 캠핑용품 리뷰 및 판매글 커뮤니티 - ToolTool $$ # ⚜ 개요 ## 가. 소개 - 사이트 소개 : ToolTool - 캠핑용품 리뷰 및 판매글 커뮤니티 - 타임리프를 사용한 템플릿 적용 - NCP, Nginx , Docker와 Jenkins 를 사용한 배포 및 자동화 //아직보류 ## 나. 사이트 - [ToolTool]() - [발표](https://www.youtube.com/watch?v=P9SFWvBgfn4) $$youtube tIPkSyGhpj0 $$ # ? 환경 ## 가. 형상관리 - [깃허브 형상관리 : ](https://github.com/kael0595/ToolTool2.git) ## 나. 사용기술 ## 다. 협업 툴 트렐로 보드를 이용한 협업 공유 ![트렐로](https://i.postimg.cc/J7500MVN/2023-08-07-9-22-15.png) ### 1-1 기술스택 ``` ⚓ - Spring Boot - HTML5 / CSS5 / JS - jQuery - MariaDB - Java ``` ### 1-2 개발환경 ``` ⚓ - SQL yog - DBeaver - Chrome - Intellij - Windows 10 - Windows 11 ``` ### 1-3 배포 ``` ⚓ - GITHUB - Docker - Jenkins CI / CD ``` ### 1-4 서비스 환경 ``` ⚓ - NGINX - MariaDB - Docker - CentOS7 - NCP ``` ### 1-5 ERD ![ERD](https://i.imgur.com/DXLdVNy.png) # ? 요구사항과 기능구현 여부 |목록|요구사항|이용대상|기능종류|구현여부|비고 | --- | --- | --- | --- |---|---| |RQ-001-C|리뷰게시판에 게시글을 작성할 수 있다|회원,관리자|등록|✅| |RQ-002-R|리뷰게시판 게시글 검색이 가능하다 |회원,관리자|검색|✅| |RQ-003-R|리뷰게시판 특정 단어 포함한 게시글 검색어 가능하다|회원,관리자|검색|✅| |RQ-004-C-R-U-D|리뷰게시글 댓글 등록이 가능하다|회원,관리자|등록|✅| |RQ-005-C-D|리뷰게시글 게시글 추천 등록이 가능하다|회원,관리자|등록|✅| |RQ-006-C-D|리뷰게시글 댓글 추천 등록이 가능하다|회원,관리자|등록|✅| |RQ-007-R|리뷰게시글 작성 날짜순으로 출력되어 나와야한다|회원,관리자|출력|✅| |RQ-008-R|리뷰게시글 작성 날짜가 출력되어 나와야한다|회원,관리자|출력|✅| |RQ-009-R|리뷰게시글 수정 날짜가 출력되어 나와야한다|회원,관리자|출력|✅| |RQ-010-R|댓글 작성 날짜가 출력되어 나와야한다|회원,관리자|출력|✅| |RQ-011-R|댓글 수정 날짜가 출력되어 나와야한다|회원,관리자|출력|✅| |RQ-012-C|판매게시판에 게시글을 작성할 수 있다|회원,관리자|등록|✅| |RQ-013-R|판매게시판 게시글 검색이 가능하다 |회원,관리자|검색|✅| |RQ-014-R|판매게시판 특정 단어 포함한 게시글 검색어 가능하다|회원,관리자|검색|✅| |RQ-015-C-R-U-D|판매게시글 댓글 등록이 가능하다|회원,관리자|등록|✅| |RQ-016-C-D|판매게시글 게시글 추천 등록이 가능하다|회원,관리자|등록|✅| |RQ-017-C-D|판매게시글 댓글 추천 등록이 가능하다|회원,관리자|등록|✅| |RQ-018-R|판매게시글 작성 날짜순으로 출력되어 나와야한다|회원,관리자|출력|✅| |RQ-019-R|판매게시글 작성 날짜가 출력되어 나와야한다|회원,관리자|출력|✅| |RQ-020-R|판매게시글 수정 날짜가 출력되어 나와야한다|회원,관리자|출력|✅| |RQ-021-R|게시판의 페이지가 1페이지부터 출력되어 나와야한다.|회원,관리자|출력|✅| |RQ-022-R|각 게시판에 카테고리 선택시 내용이 출력되어야한다.|회원,관리자|출력|✅| |RQ-023-R|마이페이지 프로필사진,내가 쓴 리뷰 횟수,내가 쓴 판매 글 횟수가 출력되어 나와야한다|회원|출력|✅| |RQ-024-R|마이페이지 내정보,내가 쓴 리뷰,내가 쓴 판매 글,내가 찜한 목록이 출력되어 나와야한다|회원|출력|✅| |RQ-025-R|마이페이지 내가 쓴 리뷰가 출력되어 나와야한다|회원|출력|✅| |RQ-026-R|마이페이지 내가 쓴 판매글이 출력되어 나와야한다|회원|출력|✅| |RQ-027-R|마이페이지 내가 찜한 목록이 출력되어 나와야한다|회원|출력|✅| |RQ-028-C-R-U-D|관리자페이지 공지사항을 관리한다|관리자|출력,등록|✅| |RQ-029-R-D|관리자페이지 리뷰 글 삭제 관리한다|관리자|출력|✅| |RQ-030-R-D|관리자페이지 판매 글 삭제 관리한다|관리자|출력|✅| |RQ-031-R-D|관리자페이지 회원 정보 및 삭제 관리한다|관리자|출력|✅| |RQ-032-R-D|관리자페이지 관리자 정보 및 삭제 관리한다|관리자|출력,등록|✅| |RQ-033-C|회원가입 이용약관 선택이 가능하다|회원,관리자|등록|✅| |RQ-034-C|회원가입이 가능하다|회원,관리자|등록|✅| |RQ-035-C|로그인이 가능하다|회원,관리자|로그인|✅| |RQ-036-C|로그인,비밀번호 찾기가 가능하다|회원,관리자|로그인|✅| # ? 기능 ``` - 회원가입 - 로그인 및 로그아웃(이메일인증) - 관리자페이지 - 관리자(글관리, 마켓글관리, 회원관리, 관리자관리) - 게시글 작성 - 게시글 수정 및 삭제 - 게시글 추천 - 게시글 댓글 작성 - 게시글 댓글 수정 및 삭제 - 게시글 댓글 추천 - 판매글 작성 - 판매글 수정 및 삭제 - 판매글 찜 - 판매글 댓글 작성 - 판매글 댓글 수정 및 삭제 - 판매글 댓글 추천 - 마이페이지(프로필 변경, 내 정보 변경 , 내가 쓴 리뷰, 내가 쓴 판매글, 내가 쓴 찜목록) ``` # ? 기술설명 ## ?서버 구조 ![https://user-images.githubusercontent.com/85653591/156701224-e71ab1b5-c4a9-4cbf-9c2c-e02a2fb1c92c.png](https://user-images.githubusercontent.com/85653591/156701224-e71ab1b5-c4a9-4cbf-9c2c-e02a2fb1c92c.png) $$uml !theme mars frame 작업자PC { frame Windows10 { frame Chrome { } } } frame 운영서버머신 { frame CentOS7(tooltool．devp．kr,_172．17．0．1) { circle 172．17．0．1――8010 circle 172．17．0．1――443 circle 172．17．0．1――3306 frame Docker { frame Nginx――1 { circle Nginx――1――443 } frame Mariadb――1 { circle Mariadb――1――3306 } frame 서버 { circle 서버――8010 } frame 서버――test { } } } } Chrome --> "172．17．0．1――443":1． https://tooltool．devp．kr 로 접속 "172．17．0．1――443" --> "Nginx――1――443" : 2． 외부 443 => Nginx 내부 443 "Nginx――1――443" --> "172．17．0．1――8010" : 3． Nginx Proxy Manager 에 의해 => 외부 8010 "172．17．0．1――8010" --> "서버――8010" : 4． 외부 8010 => 서버 내부 8010 "서버――8010" -[#green]-* "172．17．0．1――3306" : 5． DB 쿼리, 내부 8010 => 외부 3306 "172．17．0．1――3306" -[#green]-* "Mariadb――1――3306" : 6． 외부 3306 => Mariadb__1 내부 3306 $$ ## ?Termius ![Termius](https://i.imgur.com/6NyhOB3.png) ## ? Nginx ![Nginx](https://i.imgur.com/CmM7leo.png) ## ? Jenkins ![Jenkins](https://i.imgur.com/4JbJeIK.png) ## ? Jenkins pipeline ``` js pipeline { agent any environment { timestamp = "${System.currentTimeMillis() / 1000L}" } stages { stage('Prepare') { steps { script { // Get the ID of the tooltool:latest image def oldImageId = sh(script: "docker images tooltool:latest -q", returnStdout: true).trim() env.oldImageId = oldImageId } git branch: 'main', url: 'https://github.com/kael0595/ToolTool2' } post { success { sh 'echo "Successfully Cloned Repository"' } failure { sh 'echo "Fail Cloned Repository"' } } } stage('Build Gradle') { steps { dir('.') { sh """ chmod +x gradlew """ } dir('.') { sh """ ./gradlew clean build -x test """ } } post { success { sh 'echo "Successfully Build Gradle Test"' } failure { sh 'echo "Fail Build Gradle Test"' } } } stage('Build Docker Image') { steps { script { sh "docker build -t tooltool:${timestamp} ." } } } stage('Run Docker Container') { steps { script { // Check if the container is already running def isRunning = sh(script: "docker ps -q -f name=tooltool", returnStdout: true).trim() if (isRunning) { sh "docker rm -f tooltool_1" } // Run the new container try { sh """ docker run \ --name=tooltool_1 \ -p 8010:8010 \ -v /docker_projects/tooltool_1/volumes/gen:/gen \ --restart unless-stopped \ -e TZ=Asia/Seoul \ -d \ tooltool:${timestamp} """ } catch (Exception e) { // If the container failed to run, remove it and the image isRunning = sh(script: "docker ps -q -f name=tooltool_1", returnStdout: true).trim() if (isRunning) { sh "docker rm -f tooltool_1" } def imageExists = sh(script: "docker images -q tooltool:${timestamp}", returnStdout: true).trim() if (imageExists) { sh "docker rmi tooltool:${timestamp}" } error("Failed to run the Docker container.") } // If there's an existing 'latest' image, remove it def latestExists = sh(script: "docker images -q tooltool:latest", returnStdout: true).trim() if (latestExists) { sh "docker rmi tooltool:latest" if(!oldImageId.isEmpty()) { sh "docker rmi ${oldImageId}" } } // Tag the new image as 'latest' sh "docker tag tooltool:${env.timestamp} tooltool:latest" } } } } } ``` ## ?젠킨스 배포순서, 테스트 실패시 $$uml !theme toy autonumber box "작업PC" actor 개발자 entity 작업PC end box entity Github_Repository box "서버" entity Jenkins entity 테스트용_서버컨테이너 entity 실서버용_서버컨테이너 end box 개발자 -> 작업PC : Commit! 작업PC -> Github_Repository : Push! Github_Repository -> Jenkins : Webhook에 의해서 Commit Signal 전송 Jenkins -> 테스트용_서버컨테이너 : 재배포 스크립트 실행 테스트용_서버컨테이너 -> Jenkins : 테스트가 실패했습니다... Jenkins -> Jenkins : 이번 빌드는 실패로 처리하고, 작업을 종료합니다. 개발자 -> Jenkins : 해당 빌드의 콘솔기록을 확인하여 테스트가 왜 실패했는지 분석 $$ ## ?젠킨스 배포순서, 테스트 성공시 $$uml !theme toy autonumber box "작업PC" actor 개발자 entity 작업PC end box entity Github_Repository box "서버" entity Jenkins entity 테스트용_서버컨테이너 entity 실서버용_서버컨테이너 end box 개발자 -> 작업PC : Commit! 작업PC -> Github_Repository : Push! Github_Repository -> Jenkins : Webhook에 의해서 Commit Signal 전송 Jenkins -> 테스트용_서버컨테이너 : 재배포 스크립트 실행 테스트용_서버컨테이너 -> Jenkins : All Clear Jenkins -> 실서버용_서버컨테이너 : 리빌드 후 다시 실행하세요! 개발자 -> 실서버용_서버컨테이너 : Web Brouser로 Build 되었는지 확인 $$ ## ♻ 페이지설명 ### ✔ 메인페이지 ![메인페이지](https://i.imgur.com/Shy9Nfv.png) --- ### ✔ 로그인 ![로그인](https://i.imgur.com/yO214mt.png) --- ### ✔ 회원가입약관 및 회원가입 ![회원가입약관](https://i.imgur.com/QYvPkhZ.png) ![회원가입](https://i.imgur.com/E3HxQCt.png) ```java @Service @RequiredArgsConstructor public class UserService { private final UserRepository userRepository; private final PasswordEncoder passwordEncoder; @Transactional public SiteUser create(String username, String password, String email, String nickname, int mailKey, UserRole role) { SiteUser user = new SiteUser(); user.setUsername(username); user.setEmail(email); user.setNickname(nickname); user.setMailKey(mailKey); user.setPassword(passwordEncoder.encode(password)); user.setCreateDate(LocalDate.now()); this.userRepository.save(user); return user; } public void updateMailKey(int mailKey, String email, Long id) { userRepository.updateMailKey(mailKey, email, id); } public void updateMailAuth(String email, int mailKey) { int updatedRows = userRepository.updateMailAuth(email, mailKey); if (updatedRows > 0) { System.out.println("Mail auth updated successfully."); } else { System.out.println("Failed to update mail auth."); } } public long countByEmailAndMailAuth(String email) { return userRepository.countByEmailAndMailAuth(email, true); } public SiteUser getUser(String username) { Optional siteUser = this.userRepository.findByusername(username); if (siteUser.isPresent()) { return siteUser.get(); } else { throw new DataNotFoundException("siteuser not found"); } } public boolean authenticateUser(String username, String password) { Optional siteUserOptional = userRepository.findByusername(username); if (siteUserOptional.isPresent()) { SiteUser siteUser = siteUserOptional.get(); return passwordEncoder.matches(password, siteUser.getPassword()); } return false; } public SiteUser getUserByEmail(String email) { Optional siteUserOptional = this.userRepository.findByEmail(email); if (siteUserOptional.isPresent()) { return siteUserOptional.get(); } else { throw new DataNotFoundException("siteuser not found"); } } public SiteUser getUserByEmailAndUsername(String email, String username) { Optional siteUserOptional = userRepository.findByEmailAndUsername(email, username); if (siteUserOptional.isPresent()) { return siteUserOptional.get(); } else { throw new DataNotFoundException("siteuser not found"); } } public String generateTempPassword() { String characters = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ"; StringBuilder sb = new StringBuilder(); Random random = new Random(); for (int i = 0; i < 10; i++) { int index = random.nextInt(characters.length()); sb.append(characters.charAt(index)); } return sb.toString(); } public boolean userEmailCheck(String userEmail, String userName) { SiteUser user = userRepository.findUserById(userEmail); if (user != null && user.getUsername().equals(userName)) { return true; } else { return false; } } public void updatePassword(String str, String userEmail) { String pw = passwordEncoder.encode(str); int id = userRepository.findUserById(userEmail).getId(); userRepository.updateUserPassword(id, pw); } public SiteUser getUserByUsername(String username) { Optional optionalUser = this.userRepository.findByUsername(username); return optionalUser.orElseThrow(() -> new DataNotFoundException("User not found")); } public SiteUser saveUser(SiteUser user) { return userRepository.save(user); } public SiteUser getUserById(int id) { return userRepository.findById(id); } public List getAll() { return this.userRepository.findAll(); } public List getUserByUserRole(UserRole admin) { return this.userRepository.findUserByUserRole(UserRole.ADMIN); } public void changePhoto(SiteUser user, MultipartFile file) throws IOException { String projectPath = System.getProperty("user.dir") + File.separator + "src" + File.separator + "main" + File.separator + "resources" + File.separator + "static" + File.separator + "files"; UUID uuid = UUID.randomUUID(); // 랜덤으로 이름을 만들어줄 수 있음 // uuid는 파일에 붙일 랜덤이름을 생성 String fileName = uuid + "_" + file.getOriginalFilename(); // 랜덤이름(uuid)을 앞에다 붙이고 그 다음에 언더바(_) 하고 파일이름을 뒤에 붙여서 저장될 파일 이름을 생성해줌 String filePath = "/files/" + fileName; File saveFile = new File(projectPath, fileName); file.transferTo(saveFile); user.setFilepath(filePath); user.setFilename(fileName); this.userRepository.save(user); } public void emailConfirm(String email, int mailKey) throws Exception { SiteUser user = this.getUserByEmail(email); if (user != null && user.getMailKey() == mailKey) { updateMailAuth(email, mailKey); } else { throw new Exception("유효하지 않은 이메일 또는 메일 키입니다."); } } } ``` --- ### ✔ 리뷰페이지 ![리뷰페이지](https://i.imgur.com/Y4L5BKa.png) --- ### ✔ 리뷰글작성 ![리뷰글작성](https://i.imgur.com/nqW4SwC.png) ```java @Service @RequiredArgsConstructor public class ArticleService { private final ArticleRepository articleRepository; private Specification

search(String kw) { return new Specification<>() { private static final long serialVersionUID = 1L; @Override public Predicate toPredicate(Root

q, CriteriaQuery query, CriteriaBuilder cb) { query.distinct(true); // 중복을 제거 Join u1 = q.join("author", JoinType.LEFT); Join a = q.join("answerList", JoinType.LEFT); Join u2 = a.join("author", JoinType.LEFT); return cb.or(cb.like(q.get("subject"), "%" + kw + "%"), // 제목 cb.like(q.get("content"), "%" + kw + "%"), // 내용 cb.like(u1.get("username"), "%" + kw + "%"), // 질문 작성자 cb.like(a.get("content"), "%" + kw + "%"), // 답변 내용 cb.like(u2.get("username"), "%" + kw + "%")); // 답변 작성자 } }; } public Page

getList(int page, String kw) { List sorts = new ArrayList<>(); sorts.add(Sort.Order.desc("createDate")); Pageable pageable = PageRequest.of(page, 9, Sort.by(sorts)); Specification

spec = search(kw); return this.articleRepository.findAll(spec, pageable); } public Page

getMainList(int page) { List sorts = new ArrayList<>(); sorts.add(Sort.Order.desc("createDate")); Pageable pageable = PageRequest.of(page, 3, Sort.by(sorts)); return this.articleRepository.findAll(pageable); } public Page

getHigtList(int page, String kw, String sortKey) { List sorts = new ArrayList<>(); sorts.add(Sort.Order.desc(sortKey)); Pageable pageable = PageRequest.of(page, 9, Sort.by(sorts)); Specification

spec = search(kw); return this.articleRepository.findAll(spec, pageable); } public Page

getRowList(int page, String kw, String sortKey) { List sorts = new ArrayList<>(); sorts.add(Sort.Order.asc(sortKey)); Pageable pageable = PageRequest.of(page, 9, Sort.by(sorts)); Specification

spec = search(kw); return this.articleRepository.findAll(spec, pageable); } public Page

getUserList(int page, String kw, String user) { List sorts = new ArrayList<>(); sorts.add(Sort.Order.desc("createDate")); Pageable pageable = PageRequest.of(page, 9, Sort.by(sorts)); Specification

spec = searchUser(user); return this.articleRepository.findAll(spec, pageable); } private Specification

searchUser(String user) { return (root, query, builder) -> { List predicates = new ArrayList<>(); // Add a condition to check for equality between the username field and the provided user value predicates.add(builder.equal(root.get("author").get("username"), user)); // Add any other search conditions if needed // ... return builder.and(predicates.toArray(new Predicate[0])); }; } public Page

getSeasonList(int page, String kw, String season) { List sorts = new ArrayList<>(); sorts.add(Sort.Order.desc("createDate")); Pageable pageable = PageRequest.of(page, 9, Sort.by(sorts)); Specification

spec = searchSeason(season); return this.articleRepository.findAll(spec, pageable); } public Page

getSeasonHighList(int page, String kw, String season, String sortKey) { List sorts = new ArrayList<>(); sorts.add(Sort.Order.desc(sortKey)); Pageable pageable = PageRequest.of(page, 9, Sort.by(sorts)); Specification

spec = searchSeason(season); return this.articleRepository.findAll(spec, pageable); } public Page

getSeasonRowList(int page, String kw, String season, String sortKey) { List sorts = new ArrayList<>(); sorts.add(Sort.Order.asc(sortKey)); Pageable pageable = PageRequest.of(page, 9, Sort.by(sorts)); Specification

spec = searchSeason(season); return this.articleRepository.findAll(spec, pageable); } public Specification

searchSeason(String sea) { return (root, query, criteriaBuilder) -> { List predicates = new ArrayList<>(); // Season 컬럼을 기준으로 검색 조건 생성 if (sea != null) { Path seasonPath = root.get("season"); Predicate seasonPredicate = criteriaBuilder.equal(seasonPath, sea); predicates.add(seasonPredicate); } // 다른 조건들을 추가하고 싶다면 여기에 추가 // 검색 조건들을 조합하여 최종 검색 조건 생성 return criteriaBuilder.and(predicates.toArray(new Predicate[0])); }; } public Page

getTypeList(int page, String kw, String type) { List sorts = new ArrayList<>(); sorts.add(Sort.Order.desc("createDate")); Pageable pageable = PageRequest.of(page, 9, Sort.by(sorts)); Specification

spec = searchType(type); return this.articleRepository.findAll(spec, pageable); } public Page

getTypeHighList(int page, String kw, String type, String sortKey) { List sorts = new ArrayList<>(); sorts.add(Sort.Order.desc(sortKey)); Pageable pageable = PageRequest.of(page, 9, Sort.by(sorts)); Specification

spec = searchType(type); return this.articleRepository.findAll(spec, pageable); } public Page

getTypeRowList(int page, String kw, String type, String sortKey) { List sorts = new ArrayList<>(); sorts.add(Sort.Order.asc(sortKey)); Pageable pageable = PageRequest.of(page, 9, Sort.by(sorts)); Specification

spec = searchType(type); return this.articleRepository.findAll(spec, pageable); } public Specification

searchType(String sea) { return (root, query, criteriaBuilder) -> { List predicates = new ArrayList<>(); // Season 컬럼을 기준으로 검색 조건 생성 if (sea != null) { Path typePath = root.get("type"); Predicate typePredicate = criteriaBuilder.equal(typePath, sea); predicates.add(typePredicate); } // 다른 조건들을 추가하고 싶다면 여기에 추가 // 검색 조건들을 조합하여 최종 검색 조건 생성 return criteriaBuilder.and(predicates.toArray(new Predicate[0])); }; } public Page

getPriceList(int page, String kw, int min, int max) { List sorts = new ArrayList<>(); sorts.add(Sort.Order.desc("createDate")); Pageable pageable = PageRequest.of(page, 9, Sort.by(sorts)); Specification

spec = (root, query, builder) -> { return builder.between(root.get("price"), min, max); }; // 비트윈으로 미니멈, 맥시멈값 지정후 spec변수에 담고 해당변수값의 아티클만 파인드올로 불러옴 // return this.articleRepository.findAll(spec, pageable); } public Page

getPriceHigtList(int page, String kw, int min, int max, String sortKey) { Specification

spec = (root, query, builder) -> { return builder.between(root.get("price"), min, max); }; // 비트윈으로 미니멈, 맥시멈값 지정후 spec변수에 담고 해당변수값의 아티클만 파인드올로 불러옴 // List sorts = new ArrayList<>(); sorts.add(Sort.Order.desc(sortKey)); Pageable pageable = PageRequest.of(page, 9, Sort.by(sorts)); return this.articleRepository.findAll(spec, pageable); } public Page

getPriceRowList(int page, String kw, int min, int max, String sortKey) { Specification

spec = (root, query, builder) -> { return builder.between(root.get("price"), min, max); }; // 비트윈으로 미니멈, 맥시멈값 지정후 spec변수에 담고 해당변수값의 아티클만 파인드올로 불러옴 // List sorts = new ArrayList<>(); sorts.add(Sort.Order.asc(sortKey)); Pageable pageable = PageRequest.of(page, 9, Sort.by(sorts)); return this.articleRepository.findAll(spec, pageable); } public Article getArticle(Integer id) { Optional

article = this.articleRepository.findById(id); if (article.isPresent()) { return article.get(); } else { throw new DataNotFoundException("article not found"); } } public void create(ArticleForm articleForm, SiteUser user, MultipartFile[] files) throws IOException { String projectPath = System.getProperty("user.dir") + File.separator + "src" + File.separator + "main" + File.separator + "resources" + File.separator + "static" + File.separator + "files"; List filenames = new ArrayList<>(); List filepaths = new ArrayList<>(); for (MultipartFile file : files) { UUID uuid = UUID.randomUUID(); String fileName = uuid + "_" + file.getOriginalFilename(); String filePath = "/files/" + fileName; File saveFile = new File(projectPath, fileName); file.transferTo(saveFile); filenames.add(fileName); filepaths.add(filePath); } Article article = new Article(); article.setSubject(articleForm.getSubject()); article.setContent(articleForm.getContent()); article.setCreateDate(LocalDateTime.now()); article.setAuthor(user); article.setPrice(articleForm.getPrice()); article.setStarScore(articleForm.getStarScore()); article.setSeason(articleForm.getSeason()); article.setType(articleForm.getType()); article.setFilenames(filenames); article.setFilepaths(filepaths); this.articleRepository.save(article); } public List

getAll() { return this.articleRepository.findAll(); } public List

getByType(String type) { return this.articleRepository.findByType(type); } public List

getBySeason(String season) { return this.articleRepository.findBySeason(season); } public List

getAuthor(SiteUser siteUser) { return this.articleRepository.findByAuthor(siteUser); } public void modify(Article article, String subject, String content, String type, String season, int price, int starscore) { article.setSubject(subject); article.setContent(content); article.setPrice(price); article.setSeason(season); article.setType(type); article.setStarScore(starscore); article.setModifyDate(LocalDateTime.now()); this.articleRepository.save(article); } public void delete(Article article) { this.articleRepository.delete(article); } public void vote(Article article, SiteUser siteUser) { article.getVoter().add(siteUser); this.articleRepository.save(article); } public List

getByPrice(int min, int max) { return this.articleRepository.findByPriceBetween(min, max); // 비트윈을 사용하면 인트값의 범위를 지정하여 불러올 수 있다. (프라이스가 int값으로 지정되어있음 ) } public void delVote(Article article, SiteUser siteUser) { article.getVoter().remove(siteUser); this.articleRepository.save(article); } public void viewCountUp(Article article) { article.setViewCount(article.getViewCount() + 1); this.articleRepository.save(article); } } ``` --- ### ✔ 리뷰글상세페이지 ![리뷰글상세페이지](https://i.imgur.com/inqY4ly.png) ```java @RequiredArgsConstructor @Service public class AnswerService { private final AnswerRepository answerRepository; public void create(Article article, String content, SiteUser author) { Answer answer = new Answer(); answer.setContent(content); answer.setCreateDate(LocalDateTime.now()); answer.setArticle(article); answer.setAuthor(author); this.answerRepository.save(answer); } public Answer getAnswer(Integer id) { Optional answer = this.answerRepository.findById(id); if (answer.isPresent()) { return answer.get(); } else { throw new DataNotFoundException("answer not found"); } } public void modify(Answer answer, String content) { answer.setContent(content); answer.setModifyDate(LocalDateTime.now()); this.answerRepository.save(answer); } public void delete(Answer answer) { this.answerRepository.delete(answer); } } ``` --- ### ✔ 판매페이지 ![마켓페이지](https://i.imgur.com/uFRBzRt.png) --- ### ✔ 판매글작성 ![판매글작성](https://i.imgur.com/NpP9VD0.png) ```java @RequiredArgsConstructor @Service public class MarketService { private final MarketRepository marketRepository; private Specification search(String kw) { return new Specification<>() { private static final long serialVersionUID = 1L; @Override public Predicate toPredicate(Root q, CriteriaQuery query, CriteriaBuilder cb) { query.distinct(true); // 중복을 제거 Join u1 = q.join("author", JoinType.LEFT); Join a = q.join("marketAnswerList", JoinType.LEFT); Join u2 = a.join("author", JoinType.LEFT); return cb.or(cb.like(q.get("subject"), "%" + kw + "%"), // 제목 cb.like(q.get("content"), "%" + kw + "%"), // 내용 cb.like(u1.get("username"), "%" + kw + "%"), // 질문 작성자 cb.like(a.get("content"), "%" + kw + "%"), // 답변 내용 cb.like(u2.get("username"), "%" + kw + "%")); // 답변 작성자 } }; } public Page getList(int page, String kw) { List sorts = new ArrayList<>(); sorts.add(Sort.Order.desc("createDate")); Pageable pageable = PageRequest.of(page, 9, Sort.by(sorts)); Specification spec = search(kw); return this.marketRepository.findAll(spec, pageable); } public Page getMainList(int page) { List sorts = new ArrayList<>(); sorts.add(Sort.Order.desc("createDate")); Pageable pageable = PageRequest.of(page, 3, Sort.by(sorts)); return this.marketRepository.findAll(pageable); } public Page getUserList(int page, String kw, String user) { List sorts = new ArrayList<>(); sorts.add(Sort.Order.desc("createDate")); Pageable pageable = PageRequest.of(page, 9, Sort.by(sorts)); Specification spec = searchUser(user); return this.marketRepository.findAll(spec, pageable); } private Specification searchUser(String user) { return (root, query, builder) -> { List predicates = new ArrayList<>(); // Add a condition to check for equality between the username field and the provided user value predicates.add(builder.equal(root.get("author").get("username"), user)); // Add any other search conditions if needed // ... return builder.and(predicates.toArray(new Predicate[0])); }; } public Market getMarket(Integer id) { Optional Market = this.marketRepository.findById(id); if (Market.isPresent()) { return Market.get(); } else { throw new DataNotFoundException("market not found"); } } public void create(MarketForm marketForm, SiteUser user, MultipartFile[] files) throws IOException { String projectPath = System.getProperty("user.dir") + File.separator + "src" + File.separator + "main" + File.separator + "resources" + File.separator + "static" + File.separator + "files"; List filenames = new ArrayList<>(); List filepaths = new ArrayList<>(); for (MultipartFile file : files) { UUID uuid = UUID.randomUUID(); String fileName = uuid + "_" + file.getOriginalFilename(); String filePath = "/files/" + fileName; File saveFile = new File(projectPath, fileName); file.transferTo(saveFile); filenames.add(fileName); filepaths.add(filePath); } Market market = new Market(); market.setSubject(marketForm.getSubject()); market.setContent(marketForm.getContent()); market.setCreateDate(LocalDateTime.now()); market.setPrice(marketForm.getPrice()); market.setBrand(marketForm.getBrand()); market.setType(marketForm.getType()); market.setSeason(marketForm.getSeason()); market.setAuthor(user); market.setFilenames(filenames); market.setFilepaths(filepaths); this.marketRepository.save(market); } public List findByType(String type) { return this.marketRepository.findByType(type); } public List getAll() { return this.marketRepository.findAll(); } public List findBySeason(String season) { return this.marketRepository.findBySeason(season); } public List getAuthor(SiteUser siteUser) { return this.marketRepository.findByAuthor(siteUser); } //////////////////////////0618 추가 public Page getPriceList(int page, String kw, int min, int max) { List sorts = new ArrayList<>(); sorts.add(Sort.Order.desc("createDate")); Pageable pageable = PageRequest.of(page, 9, Sort.by(sorts)); Specification spec = (root, query, builder) -> { return builder.between(root.get("price"), min, max); }; // 비트윈으로 미니멈, 맥시멈값 지정후 spec변수에 담고 해당변수값의 아티클만 파인드올로 불러옴 // return this.marketRepository.findAll(spec, pageable); } public List getByPrice(int min, int max) { return this.marketRepository.findByPriceBetween(min, max); // 비트윈을 사용하면 인트값의 범위를 지정하여 불러올 수 있다. (프라이스가 int값으로 지정되어있음 ) } public Page getSeasonList(int page, String kw, String season) { List sorts = new ArrayList<>(); sorts.add(Sort.Order.desc("createDate")); Pageable pageable = PageRequest.of(page, 9, Sort.by(sorts)); Specification spec = searchSeason(season); return this.marketRepository.findAll(spec, pageable); } public Specification searchSeason(String sea) { return (root, query, criteriaBuilder) -> { List predicates = new ArrayList<>(); // Season 컬럼을 기준으로 검색 조건 생성 if (sea != null) { Path seasonPath = root.get("season"); Predicate seasonPredicate = criteriaBuilder.equal(seasonPath, sea); predicates.add(seasonPredicate); } // 다른 조건들을 추가하고 싶다면 여기에 추가 // 검색 조건들을 조합하여 최종 검색 조건 생성 return criteriaBuilder.and(predicates.toArray(new Predicate[0])); }; } public List getBySeason(String season) { return this.marketRepository.findBySeason(season); } public List getByType(String type) { return this.marketRepository.findByType(type); } public Page getTypeList(int page, String kw, String type) { List sorts = new ArrayList<>(); sorts.add(Sort.Order.desc("createDate")); Pageable pageable = PageRequest.of(page, 9, Sort.by(sorts)); Specification spec = searchType(type); return this.marketRepository.findAll(spec, pageable); } public Specification searchType(String sea) { return (root, query, criteriaBuilder) -> { List predicates = new ArrayList<>(); // Season 컬럼을 기준으로 검색 조건 생성 if (sea != null) { Path typePath = root.get("type"); Predicate typePredicate = criteriaBuilder.equal(typePath, sea); predicates.add(typePredicate); } // 다른 조건들을 추가하고 싶다면 여기에 추가 // 검색 조건들을 조합하여 최종 검색 조건 생성 return criteriaBuilder.and(predicates.toArray(new Predicate[0])); }; } public void modify(Market market, String subject, String content, Integer price, String brand, String season, String type) { market.setSubject(subject); market.setContent(content); market.setPrice(price); market.setBrand(brand); market.setSeason(season); market.setType(type); market.setModifyDate(LocalDateTime.now()); this.marketRepository.save(market); } public void vote(Market market, SiteUser siteUser) { market.getVoter().add(siteUser); this.marketRepository.save(market); } public void delete(Market market) { this.marketRepository.delete(market); } public void delVote(Market market, SiteUser siteUser) { market.getVoter().remove(siteUser); this.marketRepository.save(market); } // 카테고리 ///////////////////////////// public Page getHigtList(int page, String kw, String sortKey) { List sorts = new ArrayList<>(); sorts.add(Sort.Order.desc(sortKey)); Pageable pageable = PageRequest.of(page, 9, Sort.by(sorts)); Specification spec = search(kw); return this.marketRepository.findAll(spec, pageable); } public Page getRowList(int page, String kw, String sortKey) { List sorts = new ArrayList<>(); sorts.add(Sort.Order.asc(sortKey)); Pageable pageable = PageRequest.of(page, 9, Sort.by(sorts)); Specification spec = search(kw); return this.marketRepository.findAll(spec, pageable); } public Page getPriceHigtList(int page, String kw, int min, int max, String sortKey) { Specification spec = (root, query, builder) -> { return builder.between(root.get("price"), min, max); }; // 비트윈으로 미니멈, 맥시멈값 지정후 spec변수에 담고 해당변수값의 아티클만 파인드올로 불러옴 // List sorts = new ArrayList<>(); sorts.add(Sort.Order.desc(sortKey)); Pageable pageable = PageRequest.of(page, 9, Sort.by(sorts)); return this.marketRepository.findAll(spec, pageable); } public Page getPriceRowList(int page, String kw, int min, int max, String sortKey) { Specification spec = (root, query, builder) -> { return builder.between(root.get("price"), min, max); }; // 비트윈으로 미니멈, 맥시멈값 지정후 spec변수에 담고 해당변수값의 아티클만 파인드올로 불러옴 // List sorts = new ArrayList<>(); sorts.add(Sort.Order.asc(sortKey)); Pageable pageable = PageRequest.of(page, 9, Sort.by(sorts)); return this.marketRepository.findAll(spec, pageable); } public Page getSeasonHighList(int page, String kw, String season, String sortKey) { List sorts = new ArrayList<>(); sorts.add(Sort.Order.desc(sortKey)); Pageable pageable = PageRequest.of(page, 9, Sort.by(sorts)); Specification spec = searchSeason(season); return this.marketRepository.findAll(spec, pageable); } public Page getSeasonRowList(int page, String kw, String season, String sortKey) { List sorts = new ArrayList<>(); sorts.add(Sort.Order.asc(sortKey)); Pageable pageable = PageRequest.of(page, 9, Sort.by(sorts)); Specification spec = searchSeason(season); return this.marketRepository.findAll(spec, pageable); } public Page getTypeHighList(int page, String kw, String type, String sortKey) { List sorts = new ArrayList<>(); sorts.add(Sort.Order.desc(sortKey)); Pageable pageable = PageRequest.of(page, 9, Sort.by(sorts)); Specification spec = searchType(type); return this.marketRepository.findAll(spec, pageable); } public Page getTypeRowList(int page, String kw, String type, String sortKey) { List sorts = new ArrayList<>(); sorts.add(Sort.Order.asc(sortKey)); Pageable pageable = PageRequest.of(page, 9, Sort.by(sorts)); Specification spec = searchType(type); return this.marketRepository.findAll(spec, pageable); } public void viewCountUp(Market market) { market.setViewCount(market.getViewCount() + 1); this.marketRepository.save(market); } public Page getUserVoterList(int page, String kw, String user) { List sorts = new ArrayList<>(); sorts.add(Sort.Order.desc("createDate")); Pageable pageable = PageRequest.of(page, 9, Sort.by(sorts)); Specification spec = searchVoteUser(user); return this.marketRepository.findAll(spec, pageable); } private Specification searchVoteUser(String user) { return (root, query, builder) -> { List predicates = new ArrayList<>(); // Add a condition to check for equality between the username field and the provided user value predicates.add(builder.equal(root.get("voter").get("username"), user)); // Add any other search conditions if needed // ... return builder.and(predicates.toArray(new Predicate[0])); }; } } ``` --- ### ✔ 판매글상세페이지 ![판매글상세페이지](https://i.imgur.com/teND7pY.png) ```java @RequiredArgsConstructor @Service public class MarketAnswerService { private final MarketAnswerRepository marketAnswerRepository; public void create(Market market, String content, SiteUser author) { MarketAnswer m = new MarketAnswer(); m.setContent(content); m.setCreateDate(LocalDateTime.now()); m.setMarket(market); m.setAuthor(author); this.marketAnswerRepository.save(m); } public void delete(MarketAnswer marketAnswer) { this.marketAnswerRepository.delete(marketAnswer); } public MarketAnswer getMarketAnswer(Integer id) { Optional answer = this.marketAnswerRepository.findById(id); if (answer.isPresent()) { return answer.get(); } else { throw new DataNotFoundException("answer not found"); } } public void modify(MarketAnswer marketAnswer, String content) { marketAnswer.setContent(content); marketAnswer.setModifyDate(LocalDateTime.now()); this.marketAnswerRepository.save(marketAnswer); } } ``` --- ### ✔ 공지사항 ![공지사항](https://i.imgur.com/pUnN1aA.png) ```java @Service @RequiredArgsConstructor public class NoticeService { private final NoticeRepository noticeRepository; public List getList() { return this.noticeRepository.findAll(); } public Page getList(int page, String kw) { List sorts = new ArrayList<>(); sorts.add(Sort.Order.desc("createDate")); Pageable pageable = PageRequest.of(page, 10, Sort.by(sorts)); return this.noticeRepository.findAll(pageable); } public Notice getNotice(Integer id) { Optional Notice = this.noticeRepository.findById(id); if (Notice.isPresent()) { return Notice.get(); } else { throw new DataNotFoundException("notice not found"); } } public void create(String subject, String content) { Notice q = new Notice(); q.setSubject(subject); q.setContent(content); q.setCreateDate(LocalDateTime.now()); this.noticeRepository.save(q); } public List getAll() { return this.noticeRepository.findAll(); } public void modify(String subject, String content) { Notice q = new Notice(); q.setSubject(subject); q.setContent(content); q.getModifyDate(); this.noticeRepository.save(q); } public void delete(Notice notice) { this.noticeRepository.delete(notice); } public void viewCountUp(Notice notice) { notice.setViewCount(notice.getViewCount() + 1); this.noticeRepository.save(notice); } } ``` --- ### ✔ 마이페이지 ![마이페이지](https://i.imgur.com/OizeKOs.png) ![내가 쓴 리뷰](https://i.imgur.com/bDD0US4.png) ![내가 쓴 판매글](https://i.imgur.com/XtW2p22.png) ![내가 쓴 찜목록](https://i.imgur.com/hWl7ROd.png) ```java @GetMapping("/mypage") private String mypage(Model model, @RequestParam(value = "page", defaultValue = "0") int page, @RequestParam(value = "kw", defaultValue = "") String kw, Principal principal) { SiteUser siteUser = this.userService.getUser(principal.getName()); Page

articlePaging = this.articleService.getUserList(page, kw, siteUser.getUsername()); Page marketPaging = this.marketService.getUserList(page, kw, siteUser.getUsername()); Page marketVoterPaging = this.marketService.getUserVoterList(page, kw, siteUser.getUsername()); List

articles = this.articleService.getAuthor(siteUser); List markets = this.marketService.getAuthor(siteUser); int articleCount = articles.size(); int marketCount = markets.size(); model.addAttribute("markets", markets); model.addAttribute("marketCount", marketCount); model.addAttribute("articles", articles); model.addAttribute("articleCount", articleCount); model.addAttribute("articlePaging", articlePaging); model.addAttribute("marketPaging", marketPaging); model.addAttribute("marketVoterPaging", marketVoterPaging); model.addAttribute("kw", kw); model.addAttribute("user", siteUser); return "mypage"; } @GetMapping("/mypage/article") @ResponseBody private Model mypageArticlePaging(Model model, @RequestParam(value = "page", defaultValue = "0") int page, @RequestParam(value = "kw", defaultValue = "") String kw, Principal principal) { SiteUser siteUser = this.userService.getUser(principal.getName()); Page

articlePaging = this.articleService.getUserList(page, kw, siteUser.getUsername()); List

articles = this.articleService.getAuthor(siteUser); int articleCount = articles.size(); model.addAttribute("articlePaging", articlePaging); model.addAttribute("articles", articles); model.addAttribute("articleCount", articleCount); return model; } @GetMapping("/mypage/market") @ResponseBody private Model mypageMarketPaging(Model model, @RequestParam(value = "page", defaultValue = "0") int page, @RequestParam(value = "kw", defaultValue = "") String kw, Principal principal) { SiteUser siteUser = this.userService.getUser(principal.getName()); Page marketPaging = this.marketService.getUserList(page, kw, siteUser.getUsername()); List markets = this.marketService.getAuthor(siteUser); int marketCount = markets.size(); model.addAttribute("marketPaging", marketPaging); model.addAttribute("markets", markets); model.addAttribute("marketCount", marketCount); return model; } @GetMapping("/user/find") public String find() { return "UserSearch"; } @PostMapping("/user/findId") @ResponseBody public String findId(@RequestParam("email") String email) { SiteUser user = userService.getUserByEmail(email); if (user != null) { mailController.sendEmailForId(email, user.getUsername()); return "true"; } else { return "redirect:/user/find"; } } @PostMapping("/user/findPw") @ResponseBody public String findPw(@RequestParam("userEmail") String userEmail, @RequestParam("userName") String userName) { SiteUser user = userService.getUserByEmailAndUsername(userEmail, userName); if (user != null) { mailController.sendEmailForPw(userEmail, user.getUsername()); return "true"; } else { return "redirect:/user/find"; } } @PostMapping("/mypage/changePassword") @ResponseBody public String changePassword(@RequestParam("newpassword") String newpw, @RequestParam("newpasswordcf") String newpwcf) { Authentication authentication = SecurityContextHolder.getContext().getAuthentication(); String username = authentication.getName(); SiteUser user = userService.getUserByUsername(username); if (!newpw.equals(newpwcf)) { return "변경할 비밀번호와 확인 비밀번호가 일치하지 않습니다."; } user.setPassword(passwordEncoder.encode(newpw)); userService.saveUser(user); return "/mypage"; } @PostMapping("/mypage/changeNickname") @ResponseBody public String changeNickname(@RequestParam("newnickname") String newnickname) { Authentication authentication = SecurityContextHolder.getContext().getAuthentication(); String username = authentication.getName(); SiteUser user = userService.getUserByUsername(username); user.setNickname(newnickname); userService.saveUser(user); return "/mypage"; } @PostMapping("/mypage/changeEmail") @ResponseBody public String changeEmail(@RequestParam("newemail") String newemail) { Authentication authentication = SecurityContextHolder.getContext().getAuthentication(); String username = authentication.getName(); SiteUser user = userService.getUserByUsername(username); user.setEmail(newemail); return "/mypage"; } @PostMapping("/mypage/changePhoto") @ResponseBody public String changePhoto(@RequestParam("file") MultipartFile file) throws Exception { Authentication authentication = SecurityContextHolder.getContext().getAuthentication(); String username = authentication.getName(); SiteUser user = userService.getUserByUsername(username); userService.changePhoto(user, file); return "redirect:/mypage"; } } ``` --- ### ✔ 관리자페이지 ![관리자페이지](https://i.imgur.com/XSoev29.png) ```java @Controller @RequiredArgsConstructor @RequestMapping("/admin") public class AdminController { private final ArticleService articleService; private final MarketService marketService; private final UserService userService; private final NoticeService noticeService; @GetMapping("/") public String adminroot(Model model, @RequestParam(value = "page", defaultValue = "0") int page) { List noticeList = this.noticeService.getAll(); List userList = this.userService.getAll(); List adminList = this.userService.getUserByUserRole(UserRole.ADMIN); List

articleList = this.articleService.getAll(); List marketList = this.marketService.getAll(); model.addAttribute("noticeList", noticeList); model.addAttribute("articleList", articleList); model.addAttribute("marketList", marketList); model.addAttribute("userList", userList); model.addAttribute("adminList", adminList); return "AdminPage"; } @GetMapping("/notice/delete/{id}") public String noticeDelete(@PathVariable("id") Integer id) { Notice notice = this.noticeService.getNotice(id); this.noticeService.delete(notice); return "redirect:/admin/"; } @PostMapping("/addAdminRole") public String addAdminRole(@RequestParam("id") int id) { // 관리자 권한을 부여할 유저를 조회합니다. SiteUser user = userService.getUserById(id); if (user == null) { return "redirect:/admin/user"; } user.setUserRole(UserRole.ADMIN); userService.saveUser(user); return "redirect:/admin/user"; } @PostMapping("/minusAdminRole") public String minusAdminRole(@RequestParam("id") int id) { SiteUser user = userService.getUserById(id); if (user == null) { return "redirect:/admin/user"; } user.setUserRole(UserRole.USER); userService.saveUser(user); return "redirect:/admin/user"; } @GetMapping("/review") private String admin_review(Model model) { List

articleList = this.articleService.getAll(); model.addAttribute("articleList", articleList); return "/admin_review"; } @GetMapping("/review/delete/{id}") public String reviewDelete(@PathVariable("id") Integer id) { Article article = this.articleService.getArticle(id); this.articleService.delete(article); return "redirect:/admin/review"; } @GetMapping("/market") private String admin_market(Model model) { List marketList = this.marketService.getAll(); model.addAttribute("marketList", marketList); return "/admin_market"; } @GetMapping("/market/delete/{id}") public String marketDelete(@PathVariable("id") Integer id) { Market market = this.marketService.getMarket(id); this.marketService.delete(market); return "redirect:/admin/market"; } @GetMapping("/user") private String admin_user(Model model) { List userList = this.userService.getAll(); model.addAttribute("userList", userList); return "/admin_user"; } @GetMapping("/admin") private String admin(Model model) { List adminList = this.userService.getUserByUserRole(UserRole.ADMIN); List userList = this.userService.getAll(); model.addAttribute("adminList", adminList); model.addAttribute("userList", userList); return "/admin"; } } ``` ---