xyz.shodown.boot.upms.repository

接口 ShodownPermissionRepository

所有超级接口:

org.springframework.data.repository.CrudRepository<ShodownPermission,Long>, org.springframework.data.jpa.repository.JpaRepository<ShodownPermission,Long>, org.springframework.data.repository.PagingAndSortingRepository<ShodownPermission,Long>, org.springframework.data.repository.query.QueryByExampleExecutor<ShodownPermission>, org.springframework.data.repository.Repository<ShodownPermission,Long>

@Repository
public interface ShodownPermissionRepository
extends org.springframework.data.jpa.repository.JpaRepository<ShodownPermission,Long>

方法概要

限定符和类型	方法和说明
List<ShodownPermission>	findAllByRolesInAndTypeAndMark(List<String> roles, Integer type, Integer mark) 根据角色、权限类别、有效标识查询权限信息
ShodownPermission	findByRouteAndTypeAndMark(String route, Integer type, Integer mark) 根据Url地址查询接口权限

从接口继承的方法 org.springframework.data.jpa.repository.JpaRepository

deleteAllByIdInBatch, deleteAllInBatch, deleteAllInBatch, deleteInBatch, findAll, findAll, findAll, findAll, findAllById, flush, getById, getOne, saveAll, saveAllAndFlush, saveAndFlush

从接口继承的方法 org.springframework.data.repository.PagingAndSortingRepository

findAll

从接口继承的方法 org.springframework.data.repository.CrudRepository

count, delete, deleteAll, deleteAll, deleteAllById, deleteById, existsById, findById, save

从接口继承的方法 org.springframework.data.repository.query.QueryByExampleExecutor

count, exists, findAll, findBy, findOne

方法详细资料

findAllByRolesInAndTypeAndMark

@Query(value="select p from ShodownPermission p inner join p.roles r where r.roleId in(?1) and p.type=?2 and p.mark=?3")
List<ShodownPermission> findAllByRolesInAndTypeAndMark(List<String> roles,
                                                                                                                                                                                Integer type,
                                                                                                                                                                                Integer mark)

根据角色、权限类别、有效标识查询权限信息

参数:

roles - 角色列表

type - 权限类别

mark - 有效标识 0无效 1有效

返回:

权限信息

findByRouteAndTypeAndMark

@Query(value="select s from ShodownPermission s where s.route=?1 and s.type=?2 and s.mark=?3")
ShodownPermission findByRouteAndTypeAndMark(String route,
                                                                                                                                           Integer type,
                                                                                                                                           Integer mark)

根据Url地址查询接口权限

参数:

route - URL接口地址

type - 权限类别

mark - 有效标识 0无效 1有效

返回:

权限信息