广州北大青鸟计算机职业培训学校
互联网技术培训、软件技术培训、大数据培训、云计算培训、数据分析培训信息网
当前位置:网站首页 > 软件教程 > Java技术 > 正文

惠州什么是JPA多对多连接表?_北大青鸟IT学校

作者:邓华发布时间:2021-05-06分类:Java技术浏览:887


导读:你知道什么是JPA多对多连接表吗?下面惠州北大青鸟老师就给大家科普一下什么是JPA多对多连接表。

你知道什么是JPA多对多连接表吗?下面惠州北大青鸟老师就给大家科普一下什么是JPA多对多连接表。

以下代码显示如何为多对多映射设置连接表。

实例

下面的代码来自PersonDaoImpl.java。

package cn.w3cschool.common;

import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;

import org.springframework.transaction.annotation.Transactional;

@Transactionalpublic class PersonDaoImpl {  public void test(){
   Department d1 = new Department();
   d1.setName("Design");

   Department d2 = new Department();
   d2.setName("Testing");
   
   Person p1 = new Person("Tom");
   p1.getDepartments().add(d1);
   p1.getDepartments().add(d2);
   
   Person p2 = new Person("Jack");
   p2.getDepartments().add(d1);
   p2.getDepartments().add(d2);
   
   d1.getPersons().add(p1);
   d1.getPersons().add(p2);
   
   
   em.persist(p1);
   em.persist(p2);
   em.persist(d1);
   em.persist(d2);
 }
 @PersistenceContext  private EntityManager em;
}

下面的代码来自Person.java。

package cn.w3cschool.common;
import java.util.HashSet;
import java.util.Set;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.JoinTable;
import javax.persistence.ManyToMany;

@Entitypublic class Person {
 @Id
 @GeneratedValue(strategy=GenerationType.IDENTITY)  private long id;  
 private String name;
 
 @ManyToMany
 @JoinTable(name="PERSON_DEPT",
 joinColumns=@JoinColumn(name="PERSON_ID"),
 inverseJoinColumns=@JoinColumn(name="DEPT_ID"))  private Set<Department> departments = new HashSet<Department>();  
 public Person() {}  public Person(String name) {
   this.name = name;
 }
 public Set<Department> getDepartments() {
   return departments;
 }  public void setDepartments(Set<Department> departments) {
   this.departments = departments;
 }  public Long getId() {
   return id;
 }  public void setId(Long id) {
   this.id = id;
 }  public String getName() {
   return name;
 }  public void setName(String name) {
   this.name = name;
 }

 @Override  public String toString() {
   return "Person [id=" + id + ", name=" + name + ", departments="
       + departments + "]";
 }


}

下面的代码来自Department.java。

package cn.w3cschool.common;

import java.util.HashSet;
import java.util.Set;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.ManyToMany;

@Entitypublic class Department implements java.io.Serializable{
 @Id
 @GeneratedValue(strategy=GenerationType.IDENTITY)  private long id;  
 private String name;
 
 @ManyToMany  private Set<Person> persons = new HashSet<Person>();  
 public Set<Person> getPersons() {
   return persons;
 }  public void setPersons(Set<Person> persons) {
   this.persons = persons;
 }  public long getId() {
   return id;
 }  public void setId(long id) {
   this.id = id;
 }  public String getName() {
   return name;
 }  public void setName(String name) {
   this.name = name;
 }

 @Override  public String toString() {
   return "Department [id=" + id + ", name=" + name + ", persons=" + persons
       + "]";
 }

}

以下是数据库转储。

Table Name: DEPARTMENT
Row:
   Column Name: ID,
   Column Type: BIGINT:
   Column Value: 1

   Column Name: NAME,
   Column Type: VARCHAR:
   Column Value: Design

Row:
   Column Name: ID,
   Column Type: BIGINT:
   Column Value: 2

   Column Name: NAME,
   Column Type: VARCHAR:
   Column Value: Testing





Table Name: DEPARTMENT_PERSON
Row:
   Column Name: DEPARTMENT_ID,
   Column Type: BIGINT:
   Column Value: 1

   Column Name: PERSONS_ID,
   Column Type: BIGINT:
   Column Value: 1

Row:
   Column Name: DEPARTMENT_ID,
   Column Type: BIGINT:
   Column Value: 1

   Column Name: PERSONS_ID,
   Column Type: BIGINT:
   Column Value: 2





Table Name: PERSON
Row:
   Column Name: ID,
   Column Type: BIGINT:
   Column Value: 1

   Column Name: NAME,
   Column Type: VARCHAR:
   Column Value: Tom

Row:
   Column Name: ID,
   Column Type: BIGINT:
   Column Value: 2

   Column Name: NAME,
   Column Type: VARCHAR:
   Column Value: Jack





Table Name: PERSON_DEPT
Row:
   Column Name: PERSON_ID,
   Column Type: BIGINT:
   Column Value: 1

   Column Name: DEPT_ID,
   Column Type: BIGINT:
   Column Value: 1

Row:
   Column Name: PERSON_ID,
   Column Type: BIGINT:
   Column Value: 1

   Column Name: DEPT_ID,
   Column Type: BIGINT:
   Column Value: 2

Row:
   Column Name: PERSON_ID,
   Column Type: BIGINT:
   Column Value: 2

   Column Name: DEPT_ID,
   Column Type: BIGINT:
   Column Value: 1

Row:
   Column Name: PERSON_ID,
   Column Type: BIGINT:
   Column Value: 2

   Column Name: DEPT_ID,
   Column Type: BIGINT:
   Column Value: 2

什么是JPA多对多连接表?相信大家应该知道了吧!想了解更多关于JAVA的知识吗?可以来惠州北大青鸟新方舟校区了解一下。

Java12.jpg

Java

标签:惠州计算机JAVA软件开发惠州计算机Java软件开发惠州计算机JAVA培训惠州计算机JAVA软件开发学校惠州计算机Java软件开发培训JAVAJava软件开发北大青鸟IT计算机学校北大青鸟IT软件学校北大青鸟IT学校


Java技术排行
标签列表
网站分类
文章归档
最近发表