repository

BoardFileRepository

package capoeira.capoeiraweb.repository;

import capoeira.capoeiraweb.entity.BoardFileEntity;
import org.springframework.data.jpa.repository.JpaRepository;

public interface BoardFileRepository extends JpaRepository<BoardFileEntity, Long> {
}

BoardRepository

package capoeira.capoeiraweb.repository;

import capoeira.capoeiraweb.entity.BoardEntity;
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;

public interface BoardRepository extends JpaRepository<BoardEntity, Long> {
    // update board_table set board_hits=board_hits+1 where id=?
    @Modifying
    @Query(value = "update BoardEntity b set b.boardHits=b.boardHits+1 where b.id=:id")
    void updateHits(@Param("id") Long id);
}

CommentRepository

package capoeira.capoeiraweb.repository;

import capoeira.capoeiraweb.entity.BoardEntity;
import capoeira.capoeiraweb.entity.CommentEntity;
import org.springframework.data.jpa.repository.JpaRepository;

import java.util.List;

public interface CommentRepository extends JpaRepository<CommentEntity, Long> {
    // select * from comment_table where board_id=? order by id desc;

    List<CommentEntity> findAllByBoardEntityOrderByIdDesc(BoardEntity boardEntity);

}

MemberRepository

package capoeira.capoeiraweb.repository;

import capoeira.capoeiraweb.dto.MemberDTO;
import capoeira.capoeiraweb.entity.MemberEntity;
import org.springframework.data.jpa.repository.JpaRepository;

import java.util.Optional;

public interface MemberRepository extends JpaRepository<MemberEntity, Long> {
    //아이디로 회원 정보 조회 (select * from member_table where member_id=?)
    Optional<MemberEntity> findById(String id);
}