<!--通过username查询permission--><!--permission--><resultMapid="PermissionResultMap"type="com.cm.shiro.shirotest.model.Permission"><idcolumn="id"property="id"/><resultcolumn="name"property="name"/><resultcolumn="url"property="url"/></resultMap><selectid="selectUserPermissionsByUserName"parameterType="String"resultMap="PermissionResultMap">
select DISTINCT jd.* from test u
join t_role_user ru
on u.username = #{username} and u.id = ru.userid
join t_role r
on ru.roleid = r.id
join t_jd_role jr
on r.id = jr.roleid
join t_jd jd
on jr.jdid = jd.id
</select>