像这样的sql一般都在mapper里通过@select注解来做吧，如下：
持久层：
@Select(“select * from role where role_code in(select role_code from user_role where username = #{username})”)
List getUserRoles(String username);
业务处理：
List list = userMapper.getUserRoles(username);
像这样的sql一般都在mapper里通过@select注解来做吧，如下：
持久层：
@Select(“select * from role where role_code in(select role_code from user_role where username = #{username})”)
List getUserRoles(String username);
业务处理：
List list = userMapper.getUserRoles(username);
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
