MyBatis的多对多映射(十)上

package com.yjl.pojo;
import java.util.List;
/**
 @author:yuejl
 @date: 2019年6月15日 上午11:11:02
 @Description Mybatis 使用的基本类 User
*/
public class User {
  /**
   * @param id id编号，自增
   * @param name 姓名
   * @param age 年龄
   * @param sex 性别
   * @param description 描述
   */
  private Integer id;
  private String name;
  private Integer age;
  private String sex;
  private String description;
  //引入角色的多个对象集合。。
  private List<Role> roles;
  public User(){
  }
  public Integer getId() {
    return id;
  }
  public void setId(Integer id) {
    this.id = id;
  }
  public String getName() {
    return name;
  }
  public void setName(String name) {
    this.name = name;
  }
  public Integer getAge() {
    return age;
  }
  public void setAge(Integer age) {
    this.age = age;
  }
  public String getSex() {
    return sex;
  }
  public void setSex(String sex) {
    this.sex = sex;
  }
  public String getDescription() {
    return description;
  }
  public void setDescription(String description) {
    this.description = description;
  }
  public List<Role> getRoles() {
    return roles;
  }
  public void setRoles(List<Role> roles) {
    this.roles = roles;
  }
  @Override
  public String toString() {
    return "User [id=" + id + ", name=" + name + ", age=" + age + ", sex=" + sex + ", description=" + description
        + "]";
  }
}

package com.yjl.pojo;
import java.util.List;
/**
 @author:两个蝴蝶飞
 @date: 2019年3月2日 下午6:18:51
 @Description 角色组
*/
public class Role {
  /**
   * @param id 角色编号
   * @param name 用户的名称
   */
  private Integer id;
  private String name;
  public Role() {
  }
  public Role(String name) {
    this.name = name;
  }
  /**
   * @param users 用户   是一对多的关系
   */
  private List<User> users;
  public Integer getId() {
    return id;
  }
  public void setId(Integer id) {
    this.id = id;
  }
  public String getName() {
    return name;
  }
  public void setName(String name) {
    this.name = name;
  }
  public List<User> getUsers() {
    return users;
  }
  public void setUsers(List<User> users) {
    this.users = users;
  }
  @Override
  public String toString() {
    return "Role [id=" + id + ", name=" + name + "]";
  }
}

public Role findByIdWithSelect(int id);

public List<User> findUserByRoleId(@Param(value="roleId") int roleId);

<!--角色查询员工的一对多-->
<resultMap type="role" id="roleResultMapWithSelect">
    <id property="id" column="id"/>
    <result property="name" column="name"/>
    <collection property="users" ofType="user" column="id"
    select="com.yjl.mapper.UserMapper.findUserByRoleId"></collection>
  </resultMap>
<select id="findByIdWithSelect" parameterType="int" resultMap="roleResultMapWithSelect">
    select * from role t where t.id=#{id}
</select>

<resultMap type="user" id="userResultMap">
    <id property="id" column="id"/>
    <result property="name" column="name"/>
    <result property="sex" column="sex"/>
    <result property="age" column="age"/>
    <result property="description" column="description"/>
  </resultMap>
<select id="findUserByRoleId" parameterType="int" resultMap="userResultMap">
    select u.* from user_role t,user u where t.userId=u.id and t.roleId=#{roleId}
  </select>

@Test
  public void findByIdWithSelectTest(){
    SqlSession sqlSession=SqlSessionFactoryUtils.getSession();
    RoleMapper roleMapper=sqlSession.getMapper(RoleMapper.class);
    //具有超级管理员角色的用户
    Role role=roleMapper.findByIdWithSelect(1);
    System.out.println(role);
    List<User> userList=role.getUsers();
    userList.forEach(n ->System.out.println(n));
  }