@风亦语
[pre]
<select id="getUserResourceList" resultType="io.renren.entity.SysResourceEntity">
select t3.resource_url, t3.resource_method from sys_role_user t1
left join sys_role_menu t2 on t1.role_id = t2.role_id
inner join sys_resource t3 on cast(t2.menu_id as varchar) = t3.resource_code
where t1.user_id = #{userId}
</select>
[/pre]
