package com.casic.dao; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.casic.model.User; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Select; import java.util.List; import java.util.Map; @Mapper public interface UserMapper extends BaseMapper<User> { //获取所有的角色 @Select(" SELECT id,name " + " FROM sys_role " + " where name like '达州%' ") List<Map<String, String>> getRolesByName(); }