xyz.shodown.upms.dao.sys

接口 SysRoleMapper

所有超级接口:

com.baomidou.mybatisplus.core.mapper.BaseMapper<SysRole>, com.baomidou.mybatisplus.core.mapper.Mapper<SysRole>

@Mapper
public interface SysRoleMapper
extends com.baomidou.mybatisplus.core.mapper.BaseMapper<SysRole>

从以下版本开始:

2021-09-17

版本:

${version}

作者:

wangxiang

方法概要

限定符和类型	方法和说明
int	delById(Long id)
List<SysRole>	queryIntfRoles(List<String> intfUrls)
List<SysRole>	queryUserRoles(Long userId)

从接口继承的方法 com.baomidou.mybatisplus.core.mapper.BaseMapper

delete, deleteBatchIds, deleteById, deleteByMap, insert, selectBatchIds, selectById, selectByMap, selectCount, selectList, selectMaps, selectMapsPage, selectObjs, selectOne, selectPage, update, updateById

方法详细资料

delById

int delById(@Param(value="id")
            Long id)

queryUserRoles

@Select(value="select sr.* \nfrom sys_user_role sur \ninner join sys_role sr on sur.role_id = sr.id \nwhere sur.user_id = #{userId}")
List<SysRole> queryUserRoles(@Param(value="userId")
                                                                                                                                                                    Long userId)

queryIntfRoles

@Select(value="select\n\tsr.* \nfrom\n\tsys_role sr\ninner join sys_role_permission srp on sr.id = srp.role_id \ninner join sys_permission sp on sp.id = srp.permission_id and sp.mark = 1 and sp.uri in <foreach collection=\'intfUrls\' item=\'item\' open=\'(\' separator=\',\' close=\')\'>#{item}</foreach>\nwhere\n\tsr.mark = 1 ")
List<SysRole> queryIntfRoles(@Param(value="intfUrls")
                                                                                                                                                                                                                                                                                                                                                                        List<String> intfUrls)