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
网友评论