OWL ITS + 탐지시스템(인터넷 진흥원)
wyu
2021-11-22 6ee7dd9c3d8cc211ee5a01bbe481cabbb9c890eb
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);
}