传String并返回List<String>
dao:
List<String> getCurUserPerUrls(String userName);
mappering.xml:
1
<select id="getCurUserPerUrls" parameterType="String" resultType="String">
SELECT
URL FROM SYS_MENU
WHERE
SYS_MENU_ID IN
(SELECT SYS_MENU_ID FROM SYS_ROLE_MENU WHERE SYS_ROLE_ID IN
(SELECT SYS_ROLE_ID FROM SYS_USER_ROLE WHERE SYS_USER_ID=
(SELECT SYS_USER_ID FROM SYS_USER WHERE USER_NAME=#{userName} )
)
)
</select>