mybatis级联查询

来源：互联网发布：网络攻击追踪溯源编辑：程序博客网时间：2024/05/23 18:08

http://www.cnblogs.com/dyllove98/p/3202906.html

1.定义四个实体。User Role Privilege Resource,他们之间的对于关系为

2.需求：我通过用户名username查找出该用户对应的角色以及角色对应的权限和资源

3.实体

public class User implements Serializable {private String id;private String username;private String password;private Set<Role> role = new HashSet<Role>();}public class Role implements Serializable {private String id;private String name;private String des;private Set<Privilege> privilege = new HashSet<Privilege>();}public class Privilege implements Serializable {  private String id;  private String name;  private String des;private Set<Resource> resource = new HashSet<Resource>(); private Privilege parent;private Set<Privilege> child = new HashSet<Privilege>();}public class Resource implements Serializable {private String id;private String uri;private String des;}

4.UserMapper.xml的查询方法为

<resultMap type="user" id="userResult"><id column="id" property="id"/><result column="username" property="username"/><collection property="role" javaType="java.util.Set" resultMap="roleResult"/></resultMap><resultMap type="role" id="roleResult"><id column="rid" property="id"/><result column="rname" property="name"/><result column="rdes" property="des"/><collection property="privilege" javaType="java.util.Set" resultMap="privilegeResult"/></resultMap><resultMap type="privilege" id="privilegeResult"><id column="pid" property="id"/><result column="pname" property="name"/><collection property="resource" javaType="java.util.Set" resultMap="resourceResult"/></resultMap><resultMap type="resource" id="resourceResult"><id column="resid" property="id"/><result column="resuri" property="uri"/></resultMap><select id="findUserByUserName" parameterType="string" resultMap="userResult">  select u.id,u.username,r.id as rid,r.name as rname,r.des as rdes,p.id as pid,p.name as pname,res.id as resid,res.uri as resuri  from tb_user u   left join user_role ur on ur.user_id=u.id  join tb_role r on r.id=ur.role_id  join role_privilege rp on rp.role_id=r.id  join tb_privilege p on p.id=rp.privilege_id  join tb_resource res on res.privilege_id=p.id  where u.username=#{username} </select>

5.UserMapper.java定义方法

@Componentpublic interface UserMapper {User findUserByUserName(@Param(value="username")String username);}

0 0