SELECT * FROM portal_sys_role_auth WHERE ROLE_ALIAS_=#{roleAlias} SELECT MENU_ALIAS_ FROM portal_sys_role_auth WHERE ROLE_ALIAS_=#{roleAlias} SELECT METHOD_ALIAS_ FROM portal_sys_role_auth WHERE ROLE_ALIAS_=#{roleAlias} SELECT METHOD_ALIAS_ FROM portal_sys_role_auth WHERE METHOD_ALIAS_ is not null and ROLE_ALIAS_ IN #{role} DELETE FROM portal_sys_role_auth WHERE ROLE_ALIAS_=#{roleAlias} AND ISNULL(method_alias_) AND ISNULL(data_permission_) DELETE FROM portal_sys_role_auth WHERE ROLE_ALIAS_=#{roleAlias} and METHOD_ALIAS_ IN #{item} SELECT b.*, a.request_url_ "methodRequestUrl" FROM portal_sys_role_auth b LEFT JOIN portal_sys_method a on a.ALIAS_ = b.METHOD_ALIAS_ WHERE b.METHOD_ALIAS_ is not null and b.ROLE_ALIAS_ is not null