hibernate中一对多双向关联的记录

在这里模拟一个业务场景记录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"?>
<!DOCTYPE hibernate-mapping PUBLIC 
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
	<class name="com.hibernate.entity.Order" table="t_hibernate_order">
		<id name="order_id" type="java.lang.Integer" column="order_id">
			<generator class="increment"></generator>
		</id>
		<property name="order_no" type="java.lang.String" column="order_no"></property>
		<!-- 上面就不介绍了，基本属性的配置 -->
		
		<!-- name属性为Order实体中订单项的属性名 -->
		<set name="orderItems">
			<!-- column 为订单项中外键的属性名 -->
			<key column="oid"></key>
			<!-- class为订单项的全限定名 -->
			<one-to-many class="com.hibernate.entity.OrderItem"/>
		</set>
	</class>
</hibernate-mapping>

 订单项

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"?>
<!DOCTYPE hibernate-mapping PUBLIC 
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
	<class name="com.hibernate.entity.OrderItem" table="t_hibernate_order_item">
		<id name="order_item_id" type="java.lang.Integer" column="order_item_id">
			<generator class="increment"></generator>
		</id>
		<property name="product_id" type="java.lang.Integer" column="product_id"></property>
		<property name="quantity" type="java.lang.Integer" column="quantity"></property>
		<property name="oid" type="java.lang.Integer" column="oid"></property>
		
		<!-- 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-mapping>

将订单于订单项的配置文件配置到hibernate的核心配置文件中：

<?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="connection.username">root</property>
		<property name="connection.password">123</property>	
		<property name="connection.url">jdbc:mysql://localhost:3306/test?useUnicode=true&amp;characterEncoding=UTF-8&amp;serverTimezone=GMT</property>
		<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
		<!-- 配置sql语句生成的规则，配置数据库方言 -->
		<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
		<!-- 配置本地事务 -->
		<property name="hibernate.current_session_context_class">thread</property>
		<!-- 配置开发调试所用的配置show_sql,format_sql -->
		<property name="show_sql">true</property>
		<property name="format_sql">true</property>
		<!-- 配置映射文件 -->
		<mapping resource="com/zking/hibernate/entity/Order.hbm.xml"/>
		<mapping resource="com/zking/hibernate/entity/OrderItem.hbm.xml"/>
	</session-factory>
</hibernate-configuration>