Hello, sbb!

# 요구조건 1차 - 유저가 루트 url로 접속시에 게시글 리스트 페이지(http://주소:포트/article/list)가 나온다. - 리스트 페이지에서는 등록 버튼이 있고 버튼을 누르면 http://주소:포트/article/create 경로로 이동하고 등록 폼이 나온다. - 게시글 등록을 하면 http://주소:포트/article/create로 POST 요청을 보내어 DB에 해당 내용을 저장한다. - 게시글 등록이 되면 해당 게시글 리스트 페이지로 리다이렉트 된다. 페이지 URL 은 http://주소:포트/article/list 이다. - 리스트 페이지에서 해당 게시글을 클릭하면 상세페이지로 이동한다. 해당 경로는 http://주소:포트/article/detail/{id} 가 된다. - 게시글 상세 페이지에는 id에 맞는 게시글 데이터와 목록 버튼이 있다. 목록 버튼을 누르면 게시글 리스트 페이지로 이동하게 된다. # 요구조건 2차 - 모든 페이지 상단에 루트 디렉토리로 이동하는 버튼이 있다.(예: 로고) - 모든 페이지 상단에 로그인 상태 표시하는 버튼이 있다.(예: 로그인 / 로그아웃) - 게시글 상세페이지(http://주소:포트/article/detail/{id})에 수정 버튼이 있다. 수정 버튼을 누르면 게시글을 수정 할 수 있는 폼이나 오고 수정이 가능하다. - 게시글 상세페이지에 삭제 버튼이 있다. 삭제 버튼을 누르면 게시글이 삭제가 된다. 삭제 후 리스트 페이지로 리다이렉트 된다. - 로그인 버튼을 누르면 로그인 폼으로 이동한다. - 로그인 페이지는 사용자 이메일과 비밀번호를 입력하는 폼으로 구성되고 로그인 버튼을 누르면 데이터 검증 후 로그인이 된다. - 로그아웃 버튼을 누르면 로그아웃이 된다. - 모든 페이지 회원가입 버튼이 있다. 버튼을 누르면 회원가입 폼으로 이동한다. - 회원가입 폼은 이메일, 닉네임, 비빌번호, 비밀번호 확인으로 구성된다. 회원가입 버튼을 누르면 데이터 검증 후 회원가입이 된다. - 유저가 게시글 작성 및 수정 접근시 로그인 여부를 검사한다. - 본인 글에 대해서만 수정 / 삭제가 가능하다. - 메인페이지에 검색 기능이 구현되어야 한다. input 박스에 내용을 적고 검색 버튼을 누르면 해당 문자가 포함된 게시글이 리스트업 되어야 한다. # build.gradle ```java // spring boot starter web implementation 'org.springframework.boot:spring-boot-starter-web' // lombok testImplementation 'org.projectlombok:lombok:1.18.28' compileOnly 'org.projectlombok:lombok' annotationProcessor 'org.projectlombok:lombok' // spring boot dev tool developmentOnly 'org.springframework.boot:spring-boot-devtools' // spring boot starter test testImplementation 'org.springframework.boot:spring-boot-starter-test' // jpa implementation 'org.springframework.boot:spring-boot-starter-data-jpa' // mariadb implementation 'org.mariadb.jdbc:mariadb-java-client:3.3.0' // thymeleaf implementation 'org.springframework.boot:spring-boot-starter-thymeleaf' implementation 'nz.net.ultraq.thymeleaf:thymeleaf-layout-dialect' // Bootstrap implementation 'org.springframework.boot:spring-boot-starter-validation' // Spring Boot Validation implementation 'org.springframework.boot:spring-boot-starter-security' implementation 'org.thymeleaf.extras:thymeleaf-extras-springsecurity6:3.1.1.RELEASE' // markdown implementation 'org.commonmark:commonmark:0.21.0' ``` # application.properties ```java # CONSOLE spring.output.ansi.enabled=always # DATABASE spring.datasource.driverClassName=org.mariadb.jdbc.Driver spring.datasource.url=jdbc:mariadb://127.0.0.1:3306/sbb_dev?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul spring.datasource.username=root spring.datasource.password= # JPA spring.jpa.hibernate.ddl-auto=update spring.jpa.properties.hibernate.format_sql=true spring.jpa.properties.hibernate.show_sql=true # LOGGING logging.level.org.hibernate.orm.jdbc.bind=TRACE logging.level.org.hibernate.orm.jdbc.extract=TRACE ``` # Article ```java package com.article1.article.article; import com.article1.article.user.SiteUser; import jakarta.persistence.*; import lombok.Getter; import lombok.Setter; import java.time.LocalDateTime; @Entity @Getter @Setter public class Article { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Integer id; @Column(length = 200) private String subject; @Column(columnDefinition = "TEXT") private String content; private LocalDateTime createDate; private LocalDateTime modifyDate; @ManyToOne private SiteUser author; } ``` # ArticleController ```java package com.article1.article.article; import com.article1.article.user.SiteUser; import com.article1.article.user.UserService; import jakarta.validation.Valid; import lombok.RequiredArgsConstructor; import org.springframework.data.domain.Page; import org.springframework.http.HttpStatus; import org.springframework.security.access.prepost.PreAuthorize; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.validation.BindingResult; import org.springframework.web.bind.annotation.*; import org.springframework.web.server.ResponseStatusException; import java.security.Principal; import java.util.List; @Controller @RequiredArgsConstructor @RequestMapping("/article") public class ArticleController { private final ArticleService articleService; private final UserService userService; @GetMapping("/list") public String list(Model model, @RequestParam(value="page", defaultValue="0") int page, @RequestParam(value = "kw", defaultValue = "") String kw) { Page

paging = this.articleService.getList(page, kw); model.addAttribute("paging", paging); return "article_list"; } @GetMapping(value = "/detail/{id}") public String detail(Model model, @PathVariable("id") Integer id) { Article article = this.articleService.getArticle(id); model.addAttribute("article", article); return "article_detail"; } @PreAuthorize("isAuthenticated()") @GetMapping("/create") public String ArticleCreate(ArticleForm articleForm) { return "article_form"; } @PreAuthorize("isAuthenticated()") @PostMapping("/create") public String articleCreate(@Valid ArticleForm articleForm, BindingResult bindingResult, Principal principal) { if (bindingResult.hasErrors()) { return "article_form"; } SiteUser siteUser = this.userService.getUser(principal.getName()); this.articleService.create(articleForm.getSubject(), articleForm.getContent(), siteUser); return "redirect:/article/list"; } @PreAuthorize("isAuthenticated()") @GetMapping("/modify/{id}") public String articleModify(ArticleForm articleForm, @PathVariable("id") Integer id, Principal principal) { Article article = this.articleService.getArticle(id); if(!article.getAuthor().getUsername().equals(principal.getName())) { throw new ResponseStatusException(HttpStatus.BAD_REQUEST, "수정권한이 없습니다."); } articleForm.setSubject(article.getSubject()); articleForm.setContent(article.getContent()); return "article_form"; } @PreAuthorize("isAuthenticated()") @PostMapping("/modify/{id}") public String articleModify(@Valid ArticleForm articleForm, BindingResult bindingResult, Principal principal, @PathVariable("id") Integer id) { if (bindingResult.hasErrors()) { return "article_form"; } Article article = this.articleService.getArticle(id); if (!article.getAuthor().getUsername().equals(principal.getName())) { throw new ResponseStatusException(HttpStatus.BAD_REQUEST, "수정권한이 없습니다."); } this.articleService.modify(article, articleForm.getSubject(), articleForm.getContent()); return String.format("redirect:/article/detail/%s", id); } @PreAuthorize("isAuthenticated()") @GetMapping("/delete/{id}") public String articleDelete(Principal principal, @PathVariable("id") Integer id) { Article article = this.articleService.getArticle(id); if (!article.getAuthor().getUsername().equals(principal.getName())) { throw new ResponseStatusException(HttpStatus.BAD_REQUEST, "삭제권한이 없습니다."); } this.articleService.delete(article); return "redirect:/"; } @PreAuthorize("isAuthenticated()") @GetMapping("/vote/{id}") @ResponseBody public String articleVote(Principal principal, @PathVariable("id") Integer id) { Article article = this.articleService.getArticle(id); SiteUser siteUser = this.userService.getUser(principal.getName()); this.articleService.vote(article, siteUser); Article votedArticle = this.articleService.getArticle(id); Integer count = votedArticle.getVoter().size(); return count.toString(); } } ``` # ArcicleService ```java package com.article1.article.article; import com.article1.article.user.SiteUser; import jakarta.persistence.criteria.*; import lombok.RequiredArgsConstructor; import org.springframework.data.domain.Page; import org.springframework.data.domain.PageRequest; import org.springframework.data.domain.Pageable; import org.springframework.data.domain.Sort; import org.springframework.data.jpa.domain.Specification; import org.springframework.stereotype.Service; import java.time.LocalDateTime; import java.util.ArrayList; import java.util.List; import java.util.Optional; @Service @RequiredArgsConstructor public class ArticleService { private final ArticleRepository articleRepository; public void create(String subject, String content, SiteUser user) { Article article = new Article(); article.setSubject(subject); article.setContent(content); article.setCreateDate(LocalDateTime.now()); article.setAuthor(user); this.articleRepository.save(article); } 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)); Specification

spec = search(kw); 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 RuntimeException("article not found"); } } public void modify(Article article, String subject, String content) { article.setSubject(subject); article.setContent(content); article.setModifyDate(LocalDateTime.now()); this.articleRepository.save(article); } public void delete(Article article) { this.articleRepository.delete(article); } 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); Predicate mainPredicate = cb.or( cb.like(q.get("subject"), "%" + kw + "%"), // 제목 cb.like(q.get("content"), "%" + kw + "%"), // 내용 cb.like(u1.get("username"), "%" + kw + "%") // 질문 작성자 ); // 다른 검색 조건을 추가할 수 있음 return mainPredicate; } }; } } ``` # ArticleRepository ```java package com.article1.article.article; import org.springframework.data.domain.Page; import org.springframework.data.domain.Pageable; import org.springframework.data.jpa.domain.Specification; import org.springframework.data.jpa.repository.JpaRepository; import org.springframework.data.jpa.repository.Query; import org.springframework.data.repository.query.Param; import org.springframework.stereotype.Repository; @Repository public interface ArticleRepository extends JpaRepository { Page

findAll(Pageable pageable); Page

findAll(Specification

spec, Pageable pageable); @Query("select distinct q " + "from Article q " + "left outer join SiteUser u1 on q.author = u1 " + "where " + " q.subject like %:kw% " + " or q.content like %:kw% " + " or u1.username like %:kw% ") Page

findAllByKeyword(@Param("kw") String kw, Pageable pageable); } ``` # ArticleForm ```java package com.article1.article.article; import jakarta.validation.constraints.*; import lombok.Getter; import lombok.Setter; @Getter @Setter public class ArticleForm { @NotEmpty(message="제목은 필수항목입니다.") @Size(max=200) private String subject; @NotEmpty(message="내용은 필수항목입니다.") private String content; } ``` # SiteUser ```java package com.article1.article.user; import jakarta.persistence.*; import jakarta.persistence.GenerationType; import lombok.Getter; import lombok.Setter; @Getter @Setter @Entity public class SiteUser { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Long id; @Column(unique = true) private String username; private String password; @Column(unique = true) private String email; } ``` # UserController ```java package com.article1.article.user; import jakarta.validation.Valid; import lombok.RequiredArgsConstructor; import org.springframework.dao.DataIntegrityViolationException; import org.springframework.stereotype.Controller; import org.springframework.validation.BindingResult; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.PostMapping; import org.springframework.web.bind.annotation.RequestMapping; @RequiredArgsConstructor @Controller @RequestMapping("/user") public class UserController { private final UserService userService; @GetMapping("/signup") public String signup(UserCreateForm userCreateForm) { return "signup_form"; } @PostMapping("/signup") public String signup(@Valid UserCreateForm userCreateForm, BindingResult bindingResult) { if (bindingResult.hasErrors()) { return "signup_form"; } if (!userCreateForm.getPassword1().equals(userCreateForm.getPassword2())) { bindingResult.rejectValue("password2", "passwordInCorrect", "2개의 패스워드가 일치하지 않습니다."); return "signup_form"; } try { userService.create(userCreateForm.getUsername(), userCreateForm.getEmail(), userCreateForm.getPassword1()); }catch(DataIntegrityViolationException e) { e.printStackTrace(); bindingResult.reject("signupFailed", "이미 등록된 사용자입니다."); return "signup_form"; }catch(Exception e) { e.printStackTrace(); bindingResult.reject("signupFailed", e.getMessage()); return "signup_form"; } return "redirect:/"; } @GetMapping("/login") public String login() { return "login_form"; } } ``` # UserService ```java package com.article1.article.user; import lombok.RequiredArgsConstructor; import org.springframework.security.crypto.bcrypt.BCryptPasswordEncoder; import org.springframework.security.crypto.password.PasswordEncoder; import org.springframework.stereotype.Service; import java.util.Optional; @RequiredArgsConstructor @Service public class UserService { private final UserRepository userRepository; private final PasswordEncoder passwordEncoder; public SiteUser create(String username, String email, String password) { SiteUser user = new SiteUser(); user.setUsername(username); user.setEmail(email); user.setPassword(passwordEncoder.encode(password)); BCryptPasswordEncoder passwordEncoder = new BCryptPasswordEncoder(); user.setPassword(passwordEncoder.encode(password)); this.userRepository.save(user); return user; } public SiteUser getUser(String username) { Optional siteUser = this.userRepository.findByusername(username); if (siteUser.isPresent()) { return siteUser.get(); } else { throw new RuntimeException("siteuser not found"); } } } ``` # UserRepository ```java package com.article1.article.user; import org.springframework.data.jpa.repository.JpaRepository; import java.util.Optional; public interface UserRepository extends JpaRepository { Optional findByusername(String username); } ``` # UserCreateForm ```java package com.article1.article.user; import jakarta.validation.constraints.*; import lombok.Getter; import lombok.Setter; @Getter @Setter public class UserCreateForm { @Size(min = 3, max = 25) @NotEmpty(message = "사용자ID는 필수항목입니다.") private String username; @NotEmpty(message = "비밀번호는 필수항목입니다.") private String password1; @NotEmpty(message = "비밀번호 확인은 필수항목입니다.") private String password2; @NotEmpty(message = "이메일은 필수항목입니다.") @Email private String email; } ``` # UserRole ```java package com.article1.article.user; import lombok.Getter; @Getter public enum UserRole { ADMIN("ROLE_ADMIN"), USER("ROLE_USER"); UserRole(String value) { this.value = value; } private String value; } ``` # UserSecurityService ```java package com.article1.article.user; import lombok.RequiredArgsConstructor; import org.springframework.security.core.GrantedAuthority; import org.springframework.security.core.authority.SimpleGrantedAuthority; import org.springframework.security.core.userdetails.User; import org.springframework.security.core.userdetails.UserDetails; import org.springframework.security.core.userdetails.UserDetailsService; import org.springframework.security.core.userdetails.UsernameNotFoundException; import org.springframework.stereotype.Service; import java.util.ArrayList; import java.util.List; import java.util.Optional; @RequiredArgsConstructor @Service public class UserSecurityService implements UserDetailsService { private final UserRepository userRepository; @Override public UserDetails loadUserByUsername(String username) throws UsernameNotFoundException { Optional _siteUser = this.userRepository.findByusername(username); if (_siteUser.isEmpty()) { throw new UsernameNotFoundException("사용자를 찾을수 없습니다."); } SiteUser siteUser = _siteUser.get(); List authorities = new ArrayList<>(); if ("admin".equals(username)) { authorities.add(new SimpleGrantedAuthority(UserRole.ADMIN.getValue())); } else { authorities.add(new SimpleGrantedAuthority(UserRole.USER.getValue())); } return new User(siteUser.getUsername(), siteUser.getPassword(), authorities); } } ``` # SecurityConfig ```java package com.article1.article; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.Configuration; import org.springframework.security.authentication.AuthenticationManager; import org.springframework.security.config.annotation.authentication.configuration.AuthenticationConfiguration; import org.springframework.security.config.annotation.method.configuration.EnableMethodSecurity; import org.springframework.security.config.annotation.web.builders.HttpSecurity; import org.springframework.security.config.annotation.web.configuration.EnableWebSecurity; import org.springframework.security.crypto.bcrypt.BCryptPasswordEncoder; import org.springframework.security.crypto.password.PasswordEncoder; import org.springframework.security.web.SecurityFilterChain; import org.springframework.security.web.header.writers.frameoptions.XFrameOptionsHeaderWriter; import org.springframework.security.web.util.matcher.AntPathRequestMatcher; @Configuration @EnableWebSecurity @EnableMethodSecurity(prePostEnabled = true) public class SecurityConfig { @Bean SecurityFilterChain filterChain(HttpSecurity http) throws Exception { http .authorizeHttpRequests((authorizeHttpRequests) -> authorizeHttpRequests .requestMatchers(new AntPathRequestMatcher("/**")).permitAll()) .headers((headers) -> headers .addHeaderWriter(new XFrameOptionsHeaderWriter( XFrameOptionsHeaderWriter.XFrameOptionsMode.SAMEORIGIN))) .formLogin((formLogin) -> formLogin .loginPage("/user/login") .defaultSuccessUrl("/")) .logout((logout) -> logout .logoutRequestMatcher(new AntPathRequestMatcher("/user/logout")) .logoutSuccessUrl("/") .invalidateHttpSession(true)) ; return http.build(); } @Bean PasswordEncoder passwordEncoder() { return new BCryptPasswordEncoder(); } @Bean AuthenticationManager authenticationManager(AuthenticationConfiguration authenticationConfiguration) throws Exception { return authenticationConfiguration.getAuthenticationManager(); } } ``` # style.css ```css @font-face { font-family: 'Bazzi'; src: url('https://cdn.jsdelivr.net/gh/projectnoonnu/noonfonts_20-04@2.1/Bazzi.woff') format('woff'); font-weight: normal; font-style: normal; } * { font-family: "Bazzi"; text-underline-position: under; } h1 { margin-top : 20px; font-size : 5rem; color : #ffc0c0; } div, h5 { color : #ffc0c0; } li { list-style-type: none; } a, td { text-decoration-line: none; color: #ffc0c0; } a:hover { text-decoration-line: none; color: violet; } .table-dark { --bs-table-bg: #ffc0c0; --bs-table-border-color: ffc0c0; } .btn-primary { --bs-btn-bg: #ffc0c0; --bs-btn-border-color: #ffc0c0; --bs-btn-hover-bg: yellow; --bs-btn-hover-border-color: yellow; --bs-btn-active-bg: red; --bs-btn-active-border-color: red; } h5, form, label, .card-text { font-size: 2rem; } .alert-danger > div { color: #fff; } .first-btn { margin-right: 10px; } ``` # layout.html ```html Hello, sbb! ``` # nav.html ```html ``` # article_list.html ```html

질문 등록하기

번호	제목	글쓴이	작성일시

``` # article_detail.html ```html

목록보기

``` # article_form.html ```html

질문등록

``` # login_form.html ```html

``` # signup_form.html ```html

회원가입

``` # form_errors.html ```html

```