xyz.erupt.flow.repository

接口 EruptUserRepository

所有超级接口:

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

public interface EruptUserRepository
extends org.springframework.data.jpa.repository.JpaRepository<EruptUser,Long>

方法概要

限定符和类型	方法和说明
EruptUser	findByAccount(String userId) 根据账号查询
List<EruptUser>	findByAccountContainingOrNameContaining(String keywords, String keyword1) 模糊匹配
List<EruptUser>	findByAccountIn(Collection<String> accounts) 根据账号集合查询
List<EruptUser>	findByEruptOrgId(Long orgId) 根据上级机构id查询
List<EruptUser>	findByEruptOrgIdIsNull() 查询机构为空的人员
List<EruptUser>	findByIsAdmin(boolean b) 查询超管用户
List<EruptUser>	findByRoleIds(Collection<String> roleIds) 根据角色id查询数据

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

deleteAllByIdInBatch, deleteAllInBatch, deleteAllInBatch, deleteInBatch, findAll, findAll, findAll, findAll, findAllById, flush, getById, getOne, getReferenceById, 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

方法详细资料

findByEruptOrgIdIsNull

List<EruptUser> findByEruptOrgIdIsNull()

查询机构为空的人员

返回:

findByEruptOrgId

List<EruptUser> findByEruptOrgId(Long orgId)

根据上级机构id查询

参数:

orgId -

返回:

findByAccountContainingOrNameContaining

List<EruptUser> findByAccountContainingOrNameContaining(String keywords,
                                                        String keyword1)

模糊匹配

参数:

keywords -

返回:

findByRoleIds

@Query(value="from EruptUser where id in (select userId from EruptUserRole where roleId in (select id from EruptRole where code in :roleIds) ) ")
List<EruptUser> findByRoleIds(Collection<String> roleIds)

根据角色id查询数据

参数:

roleIds -

返回:

findByIsAdmin

List<EruptUser> findByIsAdmin(boolean b)

查询超管用户

参数:

b -

返回:

findByAccount

EruptUser findByAccount(String userId)

根据账号查询

参数:

userId -

返回:

findByAccountIn

List<EruptUser> findByAccountIn(Collection<String> accounts)

根据账号集合查询