PerTable策略

每個具體的類一個表的策略

舉例

這種映射策略每個類都會映射成一個單獨(dú)的表，類的所有屬性，包括繼承的屬性都會映射成表的列。
這種映射策略的缺點(diǎn)是：對多態(tài)關(guān)系的支持有限，當(dāng)查詢涉及到類繼承結(jié)構(gòu)時通常需要發(fā)起SQL UNION查詢。

配置

注解為：@Inheritance(strategy = InheritanceType.TABLE_PER_CLASS)

ddl語句

CREATE TABLE `hibernate_sequences` (
  `sequence_name` varchar(255) DEFAULT NULL,
  `sequence_next_hi_value` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `t_person` (
  `id` bigint(20) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `t_teacher` (
  `id` bigint(20) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `t_student` (
  `id` bigint(20) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `school` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Person

package com.jege.jpa.extend;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Inheritance;
import javax.persistence.InheritanceType;
import javax.persistence.Table;

/**
 * @author JE哥
 * @email 1272434821@qq.com
 * @description:父類
 */
@Entity
@Table(name = "t_person")
@Inheritance(strategy = InheritanceType.TABLE_PER_CLASS)
public class Person {
  @Id
  // 主鍵生成方式不能是IDENTITY
  @GeneratedValue(strategy = GenerationType.TABLE)
  private Long id;
  private String name;

  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;
  }

}

Teacher

package com.jege.jpa.extend;

import javax.persistence.Entity;
import javax.persistence.Table;

/**
 * @author JE哥
 * @email 1272434821@qq.com
 * @description:子類
 */
@Entity
@Table(name = "t_teacher")
public class Teacher extends Person {
  private String address;

  public String getAddress() {
    return address;
  }

  public void setAddress(String address) {
    this.address = address;
  }

}

Student

package com.jege.jpa.extend;

import javax.persistence.Entity;
import javax.persistence.Table;

/**
 * @author JE哥
 * @email 1272434821@qq.com
 * @description:父子類
 */
@Entity
@Table(name = "t_student")
public class Student extends Person {
  private String school;

  public String getSchool() {
    return school;
  }

  public void setSchool(String school) {
    this.school = school;
  }

}

MainTest

package com.jege.jpa.extend;

import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;

import org.junit.After;
import org.junit.AfterClass;
import org.junit.Before;
import org.junit.BeforeClass;
import org.junit.Test;

/**
 * @author JE哥
 * @email 1272434821@qq.com
 * @description:繼承測試
 */
public class MainTest {
  private static EntityManagerFactory entityManagerFactory = null;
  private EntityManager entityManager = null;

  @BeforeClass
  public static void setUpBeforeClass() throws Exception {
    entityManagerFactory = Persistence.createEntityManagerFactory("com.jege.jpa");
  }

  @Before
  public void setUp() throws Exception {
    entityManager = entityManagerFactory.createEntityManager();
  }

  @Test
  public void persist() {
    Person person = new Person();
    person.setName("jege");

    Teacher teacher = new Teacher();
    teacher.setName("倉老師");
    teacher.setAddress("北京");

    Student student = new Student();
    student.setName("機(jī)械師");
    student.setSchool("上海");

    entityManager.getTransaction().begin();
    entityManager.persist(student);
    entityManager.persist(teacher);
    entityManager.persist(person);
    entityManager.getTransaction().commit();
  }

  @Test
  public void find() {
    persist();
    
    entityManager.clear();
    Student student = entityManager.find(Student.class, 1L);
    System.out.println(student.getSchool());
  }

  @After
  public void tearDown() throws Exception {
    if (entityManager != null && entityManager.isOpen())
      entityManager.close();
  }

  @AfterClass
  public static void tearDownAfterClass() throws Exception {
    if (entityManagerFactory != null && entityManagerFactory.isOpen())
      entityManagerFactory.close();
  }
}

其他關(guān)聯(lián)項(xiàng)目

• JPA 菜鳥教程 15 繼承-一個表-SINGLE_TABLE
  http://blog.csdn.net/je_ge/article/details/53678422
• JPA 菜鳥教程 16 繼承-聯(lián)合子類-JOINED
  http://blog.csdn.net/je_ge/article/details/53678619

源碼地址

https://github.com/je-ge/jpa

如果覺得我的文章或者代碼對您有幫助,可以請我喝杯咖啡。
**您的支持將鼓勵我繼續(xù)創(chuàng)作!謝謝！ **

微信打賞

支付寶打賞