在这里模拟一个业务场景记录hibernate中一对多双向关联的配置及使用:
当我们在手机上购物付款之后,是会生成订单的。一个订单中会存在着多个订单项,订单与订单项之间就存在着一对多的关系;一个订单中可以有多个订单项,而多个订单项又组成为一个订单。所以这里以订单与订单项为例进行记录:
数据库脚本建表:
– 订单表(主表)
create table t_hibernate_order
(
order_id int primary key auto_increment,
order_no varchar(50) not null
);
– 订单项表(从表)
create table t_hibernate_order_item
(
order_item_id int primary key auto_increment,
product_id int not null,
quantity int not null,
oid int not null,
foreign key(oid) references t_hibernate_order(order_id)
);
实体的创建以及配置就不多说了,直接贴代码:
订单
package com.hibernate.entity;
import java.util.HashSet;
import java.util.Set;
/**
订单实体
@author lenovo
*/
public class Order {
private Integer order_id;
private String order_no;
/*
* 一个订单中对应的多个订单项
*/
private Set<OrderItem> orderItems=new HashSet<>();
public Set<OrderItem> getOrderItems() {
return orderItems;
}
public void setOrderItems(Set<OrderItem> orderItems) {
this.orderItems = orderItems;
}
public Integer getOrder_id() {
return order_id;
}
public void setOrder_id(Integer order_id) {
this.order_id = order_id;
}
public String getOrder_no() {
return order_no;
}
public void setOrder_no(String order_no) {
this.order_no = order_no;
}
@Override
public String toString() {
return "Order [order_id=" + order_id + ", order_no=" + order_no + "]";
}
}
订单实体的映射配置文件
<?xml version="1.0" encoding="UTF-8"?>
<!-- name属性为Order实体中订单项的属性名 -->
<set name="orderItems">
<!-- column 为订单项中外键的属性名 -->
<key column="oid"></key>
<!-- class为订单项的全限定名 -->
<one-to-many class="com.hibernate.entity.OrderItem"/>
</set>
</class>
订单项
package com.hibernate.entity;
/**
订单项实体
@author lenovo
*/
public class OrderItem {
private Integer order_item_id;
private Integer product_id;
private Integer quantity;
//数据库中设置的外键,与订单中的订单id关联
private Integer oid;
/**
* 订单项所对应的订单
*/
private Order order;
public Integer getOrder_item_id() {
return order_item_id;
}
public void setOrder_item_id(Integer order_item_id) {
this.order_item_id = order_item_id;
}
public Integer getProduct_id() {
return product_id;
}
public void setProduct_id(Integer product_id) {
this.product_id = product_id;
}
public Integer getQuantity() {
return quantity;
}
public void setQuantity(Integer quantity) {
this.quantity = quantity;
}
public Integer getOid() {
return oid;
}
public void setOid(Integer oid) {
this.oid = oid;
}
public Order getOrder() {
return order;
}
public void setOrder(Order order) {
this.order = order;
}
@Override
public String toString() {
return "OrderItem [order_item_id=" + order_item_id + ", product_id=" + product_id + ", quantity=" + quantity
+ ", oid=" + oid + "]";
}
}
订单项实体的映射配置文件
<?xml version="1.0" encoding="UTF-8"?>
<!-- name为实体类中订单的属性名 , class为订单的全限定名 , column 为外键的属性名 -->
<many-to-one name="order" class="com.hibernate.entity.Order" column="oid" insert="false" update="false"></many-to-one>
<!-- 当配置的属性属性中 column有存在同名的情况时,需设置insert="false" update="false" 否则会报错 -->
</class>
将订单于订单项的配置文件配置到hibernate的核心配置文件中:
<?xml version="1.0" encoding="UTF-8"?> root 123 jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT com.mysql.jdbc.Driver org.hibernate.dialect.MySQLDialect thread true true