Blog-v3(리팩토링)

1. Board Package

1. BoardRepository(interface)

package org.example.springv3.board;

import org.example.springv3.user.User;

import jakarta.persistence.EntityManager;
import lombok.RequiredArgsConstructor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.data.repository.query.Param;

import java.util.List;
import java.util.Optional;

import java.util.Optional;

public interface BoardRepository extends JpaRepository<Board, Integer> {

    //join 쿼리
    //@Query(value = "select * from board_tb bt inner join user_tb on bt.user_id = ut.id wherebt.id =?", nativeQuery = true)
    @Query("select b from Board b join fetch b.user u where b.id=:id")
    //하나를 찾을 때는 Optional을 쓰는게 좋다.
    Optional<Board> mFindById(@Param("id") int id);

    @Query("select b from Board b order by b.id desc")
    List<Board> mFindAll();
}

• 코드설명

java코드 복사
public interface BoardRepository extends JpaRepository<Board, Integer> {

@Query("select b from Board b join fetch b.user u where b.id=:id")
Optional<Board> mFindById(@Param("id") int id);

@Query("select b from Board b order by b.id desc")
List<Board> mFindAll();

2. BoardService

   public List<Board> 게시글목록보기() {
        //Pageable pg = PageRequest.of(0, 3, Sort.Direction.DESC, "id");
        Sort sort = Sort.by(Sort.Direction.DESC, "id");
        List<Board> boardList = boardRepository.findAll(sort);
        return boardList;
    }
     @Transactional
    public void 게시글삭제하기(Integer id, User sessionUser) {
        Board board = boardRepository.findById(id)
                .orElseThrow(()-> new Exception404("게시글을 찾을 수 없습니다."));

        if (board.getUser().getId() != sessionUser.getId()) {
            throw new Exception403("작성자가 아닙니다.");
        }

        boardRepository.deleteById(id);
    }

public Board 게시글수정화면(int id, User sessionUser) {

        Board board = boardRepository.findById(id).orElseThrow(()-> new Exception404("게시글을 찾을 수 없습니다."));
        //위 코드랑 똑같은 코드다!
     //   Optional<Board> boardOP = boardRepository.findById(1);
      //  if(boardOP.isEmpty()){
       //     throw new Exception404("게시글을 찾을 수 없습니다");
        //}

        //Board board = boardOP.get();

        if (board.getUser().getId() != sessionUser.getId()) {
            throw new Exception403("게시글 수정 권한이 없습니다.");
        }
        return board;
    }
    @Transactional
    public void 게시글수정(int id, BoardRequest.UpdateDTO updateDTO, User sessionUser) {
        // 1. 게시글 조회 (없으면 404)
        Board board = boardRepository.findById(id)
                .orElseThrow(()-> new Exception404("게시글을 찾을 수 없습니다."));

        // 2. 권한체크
        if (board.getUser().getId() != sessionUser.getId()) {
            throw new Exception403("게시글을 수정할 권한이 없습니다");
        }
        // 3. 게시글 수정하기
        board.setTitle(updateDTO.getTitle());
        board.setContent(updateDTO.getContent());

    }
       public BoardResponse.DetailDTO 게시글상세보기(User sessionUser, Integer boardId){
        Board boardPS = boardRepository.findById(boardId)
                .orElseThrow(() -> new Exception404("게시글이 없습니다."));

        return new BoardResponse.DetailDTO(boardPS,sessionUser);
    }
}

• 코드 설명

Board board = boardRepository.findById(boardId)
                .orElseThrow(() -> new Exception404("게시글이 없습니다."));

2.core Package

1. config → WebConfig

package org.example.springv3.core.config;

import org.example.springv3.core.interceptor.LoginInterceptor;
import org.springframework.context.annotation.Configuration;
import org.springframework.web.servlet.config.annotation.InterceptorRegistry;
import org.springframework.web.servlet.config.annotation.WebMvcConfigurer;
// 인터셉터 작동안되게 주석처리 (호정)
//@Configuration // IoC에 저장됨
public class WebConfig implements WebMvcConfigurer {

    @Override
    public void addInterceptors(InterceptorRegistry registry) {
        registry.addInterceptor(new LoginInterceptor())
                .addPathPatterns("/api/**");
    }
}

• 코드설명

@Override
public void addInterceptors(InterceptorRegistry registry) {
    registry.addInterceptor(new LoginInterceptor())
            .addPathPatterns("/api/**");
}

2. interceptor → Loginlnterceptor

package org.example.springv3.core.interceptor;

import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;
import jakarta.servlet.http.HttpSession;
import org.example.springv3.core.error.ex.Exception401;
import org.example.springv3.user.User;
import org.springframework.web.servlet.HandlerInterceptor;

public class LoginInterceptor implements HandlerInterceptor {
    @Override
    public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) throws Exception {
        HttpSession session = request.getSession();
        User sessionUser = (User) session.getAttribute("sessionUser");

        if (sessionUser == null) {
            throw new Exception401("인증되지 않았어요");
        }

        return true; // false면 컨트롤러 진입안됨
    }

}

• 코드설명

3. user Package

1. UserRepository(interface)

ackage org.example.springv3.user;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import java.util.Optional;

public interface UserRepository extends JpaRepository<User, Integer> {

    @Query("select u from User u where u.username=:username")
    Optional<User> findByUsername(@Param("username") String username);

    @Query("select u from User u where u.username=:username and u.password=:password")
    Optional<User> findByUsernameAndPassword(@Param("username") String username, @Param("password") String password);
}

• 코드설명

4.application-dev.properties

# 6. Query Format
spring.jpa.properties.hibernate.format_sql=true
# 7. OpenInView
spring.jpa.open-in-view=false
# 8. Logging
logging.level.org.hibernate.orm.jdbc.bind=INFO
logging.level.org.example.springv3=DEBUG

• 코드설명

properties코드 복사
spring.jpa.properties.hibernate.format_sql=true

properties코드 복사
spring.jpa.open-in-view=false

properties코드 복사
logging.level.org.hibernate.orm.jdbc.bind=INFO
logging.level.org.example.springv3=DEBUG

properties코드 복사
logging.level.org.hibernate.orm.jdbc.bind=INFO

properties코드 복사
logging.level.org.example.springv3=DEBUG