//fetch=FetchType.EAGER 關(guān)閉懶加載 相當(dāng)于hibernate中的lazy=false
	//joinColumns 配置中間表的主列
	//inverseJoinColumns=@JoinColumn(name="t_roleId") 創(chuàng)建中間表的副列
	@ManyToMany(fetch=FetchType.EAGER)
	@JoinTable(name="t1_user_permission",joinColumns=@JoinColumn(name="t_userId"),
	inverseJoinColumns=@JoinColumn(name="t_perId"))
	private List<Permission> perList;
 
//mappedBy="roleList" 變成雙向
	//mappedBy="roleList" 把主權(quán)交給user 然后 role里面就不創(chuàng)建中間表了
	//表示聲明自己不是多對多的關(guān)系維護端，由對方來維護
	@ManyToMany(mappedBy="perList",fetch=FetchType.EAGER)
	private List<User> userList;

CREATE TABLE `mb_member_dept` (
?? ?`member_id` ?bigint(20) NOT NULL ,
?? ?`dept_id` ?bigint(20) NOT NULL ,
?? ?PRIMARY KEY (`member_id`, `dept_id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8mb4 COLLATE=utf8mb4_general_ci
ROW_FORMAT=DYNAMIC;

/**
* 用戶部門實體
* @author lizebin
* @version 1.0
* @date 2021/2/18 12:48 上午
*
**/
@Getter
@Setter
@Entity
@Table(name = "mb_member_dept")
public class MemberDeptPO implements Serializable{
  private static final long serialVersionUID = 1271571231859316736L;
  /**
  * 聯(lián)合主鍵用戶ID
  */
  @Column(name = "member_id", length = 20)
  private long memberId;
  /**
  * 聯(lián)合主鍵部門ID
  */
  @Column(name = "dept_id", length = 20)
  private long deptId;
}

/**
* 用戶部門關(guān)系聯(lián)合主鍵定義
* @author lizebin
* @version 1.0
* @date 2021/2/18 10:36 上午
*
**/
@Getter
@Setter
public class MemberDeptKey implements Serializable {
    private static final long serialVersionUID = -5482200454871393530L;
	/**聯(lián)合主鍵，字段名稱與MemberDeptPO 類中一致*/
    private long memberId;
	/**聯(lián)合主鍵，字段名稱與MemberDeptPO 類中一致*/
    private long deptId;
    public MemberDeptKey() { }
    public MemberDeptKey(long memberId, long deptId) {
        this.memberId = memberId;
        this.deptId = deptId;
    }
}

/**
* 用戶部門實體
* @author lizebin
* @version 1.0
* @date 2021/2/18 12:48 上午
*
**/
@Getter
@Setter
@Entity
@Table(name = "mb_member_dept")
@IdClass(value = MemberDeptKey.class) // 定義聯(lián)合主鍵類
public class MemberDeptPO implements Serializable{
  private static final long serialVersionUID = 1271571231859316736L;
  /**
  * 聯(lián)合主鍵用戶ID
  */
  @Id // 定義該字段為主鍵
  @Column(name = "member_id", length = 20)
  private long memberId;
  /**
  * 聯(lián)合主鍵部門ID
  */
  @Id // 定義該字段為主鍵
  @Column(name = "dept_id", length = 20)
  private long deptId;
}

@Repository
public interface IMemberDeptRepository extends JpaRepository<T, ID>, JpaSpecificationExecutor<T> {
}

@Repository
public interface IMemberDeptRepository extends JpaRepository<MemberDeptPO, MemberDeptKey>, JpaSpecificationExecutor<MemberDeptPO> {
?? ?/**通過ID獲取數(shù)據(jù)信息*/
? ? MemberDeptPO findById(MemberDeptKey id);
}

@Autowired
private IMemberDeptRepository memberDeptRepository;
MemberDeptPO memberDeptPO = memberDeptRepository.findById(new MemberDeptKey(1l, 0l));