美文网首页
MyBatis注解查询多对多@Results @Many

MyBatis注解查询多对多@Results @Many

作者: 何佳阳 | 来源:发表于2020-07-29 01:02 被阅读0次
@Select("select * from user")
@Results({
    @Result(propery = "id", column = "id"),
    @Result(propery = "username", column = "username"),
    @Result(propery = "roleList", column = "id", javaType = List.class,
        many = @Many(select = "roleMapper.findRoleByUid"))
})
public List<User> findAllUserAndRole();

//roleMapper 内
@Select("select * from sys_role r, sys_user_role ur where r.id = ur.roleid and ur.userid = #{uid}")
public List<Role> findRoleByUid(Integer uid);

相关文章

网友评论

      本文标题:MyBatis注解查询多对多@Results @Many

      本文链接:https://www.haomeiwen.com/subject/nbycrktx.html