SysRole.java:
@TableField(exist = false)
private List<SysRole> roles;
UserMapper:
<collection property="roles" javaType="ArrayList"
column="{userId = user_id}"
select="com.zdl.system.mapper.Mapper.getListByUserId"/>
interface Mapper.java:
List<Role> getListByUserId(@Param("userId") Long userId);
SysRoleMapper:
<select id="getListByUserId" resultMap="SysRoleResult">
SELECT
sr.*
FROM
sys_user_role sur
LEFT JOIN sys_role sr ON sr.role_id = sur.role_id
WHERE
sr.status = 0
AND sur.user_id = #{userId}
</select>
mybatis 查询集合字段
最新推荐文章于 2024-05-31 14:04:00 发布