这个代码是实现person表与idcard表的双向关联,两个表的主键名称相同(或不相同),但对应记录的两个主键的取值是一样的(由一方产生主键值,然后提供给另一方的主键值,即共享主键)
数据库配置文件Hibernate.cfg.xml
这个配置文件在其他工程里使用的好好的,在这个工程里一直自动建表失败,后来把这句话里的update改成create就可以自动建表了
改之前
<property name="hibernate.hbm2ddl.auto">update</property>
改之后
<property name="hibernate.hbm2ddl.auto">create</property>
但是这样也存在一个bug,就是每次运行都会把原来的表删掉然后重新建表,这个还需要有空的时候再研究一下,不然就需要第一次运行时用create,之后运行一直update,不太方便。
源代码
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="hibernate.connection.driver_class">com.mysql.cj.jdbc.Driver</property>
<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/card?useSSL=false&serverTimezone=UTC</property>
<property name="hibernate.connection.username">root</property>
<property name="hibernate.connection.password">123456</property>
<!-- 设置方言************************* -->
<property name="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</property>
<!-- 自动建表 -->
<property name="hibernate.hbm2ddl.auto">create</property>
<!-- 显示SQL -->
<property name="hibernate.show_sql">true</property>
<!-- 格式化SQL -->
<property name="hibernate.format_sql">true</property>
<property name="hibernate.connection.provider_class">
org.hibernate.service.jdbc.connections.internal.C3P0ConnectionProvider</property>
<property name="hibernate.c3p0.min_size">2</property>
<property name="hibernate.c3p0.max_size">5</property>
<property name="hibernate.c3p0.timeout">300</property>
<property name="hibernate.c3p0.max_statements">100</property>
<property name="hibernate.c3p0.idle_test_period">3000</property>
<!-- 格式化SQL -->
<property name="hibernate.format_sql">true</property>
<!--指定关联的 。hbm。xml文件 -->
<mapping resource="com/edu/entity/two/one2one_pk/IdCard.hbm.xml"></mapping>
<mapping resource="com/edu/entity/two/one2one_pk/Person.hbm.xml"></mapping>
</session-factory>
</hibernate-configuration>
HibernateUtil.java
package com.edu.db_util;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
import org.hibernate.cfg.Configuration;
import org.hibernate.service.ServiceRegistry;
public final class HibernateUtil {
private static SessionFactory sessionFactory;
private static ThreadLocal session =new ThreadLocal();
private HibernateUtil(){}
static{
Configuration configuration=new Configuration().configure();
StandardServiceRegistryBuilder regbuilder=new StandardServiceRegistryBuilder().applySettings(configuration.getProperties());
ServiceRegistry serviceRegistry=regbuilder.build();
sessionFactory=configuration.buildSessionFactory(serviceRegistry);
}
public static Session getThreadLocalSession(){//获取session对象的方法
Session s=(Session)session.get();
if(s==null){
s=sessionFactory.openSession();
session.set(s);
}
return s;
}
public static void clossSession(){
Session s=(Session)session.get();
if(s!=null){s.close();session.set(null);}
}
}
Person类
package com.edu.entity.two.one2one_pk;
public class Person {
private int id;
private String name;
private IdCard idCard;
public Person(int id, String name, IdCard idCard) {
super();
this.id = id;
this.name = name;
this.idCard = idCard;
}
public Person() {
super();
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public IdCard getIdCard() {
return idCard;
}
public void setIdCard(IdCard idCard) {
this.idCard = idCard;
}
}
IdCard类
package com.edu.entity.two.one2one_pk;
public class IdCard {
private int id;
private String cardNo;
private Person person;
public IdCard(int id, String cardNo, Person person) {
super();
this.id = id;
this.cardNo = cardNo;
this.person = person;
}
public IdCard() {
super();
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getCardNo() {
return cardNo;
}
public void setCardNo(String cardNo) {
this.cardNo = cardNo;
}
public Person getPerson() {
return person;
}
public void setPerson(Person person) {
this.person = person;
}
}
IdCard映射文件
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 2021-11-19 8:11:21 by Hibernate Tools 3.4.0.CR1 -->
<hibernate-mapping>
<class name="com.edu.entity.two.one2one_pk.IdCard" table="IDCARD" lazy="true">
<id name="id" type="int">
<column name="ID" />
<generator class="foreign" >
<param name="property">person</param>
</generator>
</id>
<property name="cardNo" type="java.lang.String">
<column name="CARDNO" />
</property>
<one-to-one name="person" class="com.edu.entity.two.one2one_pk.Person" constrained="true"></one-to-one>
</class>
</hibernate-mapping>
Person映射文件
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 2021-11-19 8:11:21 by Hibernate Tools 3.4.0.CR1 -->
<hibernate-mapping>
<class name="com.edu.entity.two.one2one_pk.Person" table="PERSON" lazy="true">
<id name="id" type="int">
<column name="ID" />
<generator class="native" />
</id>
<property name="name" type="java.lang.String">
<column name="NAME" />
</property>
<one-to-one name="idCard" class="com.edu.entity.two.one2one_pk.IdCard" fetch="join" cascade="all"></one-to-one>
</class>
</hibernate-mapping>
补充:若为基于外键的一对一双向关联,如本例中person为主动方,idCard为被动方时,需要在被动方给出外键与主动方主键的对应关系。
即把idCard映射文件中 < one-to-one > 标签更改为如下内容
<many-to-one name="person" class="com.edu.entity.two.one2one_fk.IdCard"
column="person_id" unique="true" />
测试代码InsertMain
package com.edu.entity.two.one2one_pk;
import org.hibernate.Session;
import org.hibernate.Transaction;
import com.edu.db_util.HibernateUtil;
public class InsertMain {
public static void main(String[] args) {
// TODO Auto-generated method stub
Person person=new Person();
person.setName("张三");
IdCard idCard=new IdCard();
idCard.setCardNo("123123");
idCard.setPerson(person);
Session session=HibernateUtil.getThreadLocalSession();
Transaction tx=session.beginTransaction();
session.save(person);
session.save(idCard);
tx.commit();
HibernateUtil.clossSession();
}
}