package com.example.springboot.mapper;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.example.springboot.entity.RolePermission;
|
|
|
import org.apache.ibatis.annotations.*;
|
import org.springframework.stereotype.Repository;
|
|
import java.util.List;
|
import java.util.Map;
|
|
@Mapper
|
@Repository
|
public interface RolePermissionMapper extends BaseMapper<RolePermission> {
|
List<RolePermission> selectByNameLike(@Param("name") String name);
|
@Select("SELECT rp.state,rp.permission_id,rp.role_id, p.* FROM role_permission AS rp JOIN permission AS p ON rp.permission_id = p.id WHERE rp.role_id = #{roleId}")
|
List<Map<String, Object>> selectquanxian(@Param("roleId") int roleId);
|
|
@Select("SELECT COUNT(*) FROM role_permission WHERE role_id = #{roleId} AND permission_id = #{permissionId}")
|
boolean checkExists(@Param("roleId") int roleId, @Param("permissionId") int permissionId);
|
|
|
@Update("UPDATE role_permission SET state = #{state} WHERE role_id = #{roleId} AND permission_id = #{permissionId}")
|
void updateState(@Param("roleId") int roleId, @Param("permissionId") int permissionId, @Param("state") int state);
|
|
@Insert("INSERT INTO role_permission (role_id, permission_id, state) VALUES (#{roleId}, #{permissionId}, #{state})")
|
void insert(@Param("roleId") int roleId, @Param("permissionId") int permissionId, @Param("state") int state);
|
|
}
|
