OWL ITS + 탐지시스템(인터넷 진흥원)
이민희
2022-01-07 ad7e60c5d5a090160c6b9be63c02a75a6c369b91
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
package kr.wisestone.owl.repository;
 
import kr.wisestone.owl.domain.ProjectRole;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
 
public interface ProjectRoleRepository extends JpaRepository<ProjectRole, Long> {
    ProjectRole findByProjectId(@Param("projectId") Long projectId);
 
    ProjectRole findByProjectIdAndRoleType(@Param("projectId") Long projectId, @Param("roleType") String roleType);
 
    @Query(name="ProjectRole.findByUserIdAndProjectId")
    ProjectRole findByUserIdAndProjectId(@Param("userId") Long userId, @Param("projectId") Long projectId);
}