hibernate双向关系共3种(1对N(N对1)、1对1、多对多 )。
1. 1对N(N对1)
例如 客户订单关系。一个客户有多个订单,一个订单属于一个客户。
开发步骤:
- Customer 类加上set订单集合。
- Order类添加customer属性。、
- Customer.hbm.xml配置文件one-to-many
- Order.hbm.xml配置文件many-to-one
public class Customer {
private Integer id;
private String name;
private String gender;
private Set<Order> orders = new HashSet<Order>();
public class Order {
private Integer id;
private String orderno;
private String productName;
//关联客户
private Customer customer;
Customer.hbm.xml
<hibernate-mapping>
<class name="com.zm.shuang.Customer" table="tb_customer">
<id name="id" type="java.lang.Integer">
<column name="ID" />
<generator class="native" />
</id>
<property name="name" type="java.lang.String">
<column name="NAME" />
</property>
<property name="gender" type="java.lang.String">
<column name="GENDER" />
</property>
<set name="orders" table="tb_order">
<key>
<column name="cust_id" />
</key>
<one-to-many class="com.zm.shuang.Order" />
</set>
</class>
</hibernate-mapping>
Order.hbm.xml
<hibernate-mapping>
<class name="com.zm.shuang.Order" table="tb_order">
<id name="id" type="java.lang.Integer">
<column name="ID" />
<generator class="native" />
</id>
<property name="orderno" type="java.lang.String">
<column name="ORDERNO" />
</property>
<property name="productName" type="java.lang.String">
<column name="PRODUCTNAME" />
</property>
<many-to-one name="customer" class="com.zm.shuang.Customer" fetch="join">
<column name="cust_id" />
</many-to-one>
</class>
</hibernate-mapping>
5.查看数据库表结构
CREATE TABLE `tb_customer` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`NAME` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`GENDER` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin
CREATE TABLE `tb_order` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`ORDERNO` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`PRODUCTNAME` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`cust_id` int(11) DEFAULT NULL,
PRIMARY KEY (`ID`),
KEY `FKg4q8dm6sldh5gvb4lhgr886wm` (`cust_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin
2. 1对1
例如:Person(人)-Card(身份证)
开发步骤:
- Person 类添加Card属性
- Card类添加Person属性
- Person.hbm.xml添加one-to-one
- Card.hbm.xml添加many-to-one
public class Person {
private Integer id;
private String name;
private Card card;
public class Card {
private Integer id;
private String name;
private Person person;
Person.hbm.xml
<hibernate-mapping>
<class name="com.zm.shuang.Person" table="tbu_person">
<id name="id" type="java.lang.Integer">
<column name="ID" />
<generator class="native" />
</id>
<property name="name" type="java.lang.String">
<column name="NAME" />
</property>
<one-to-one name="card" class="com.zm.shuang.Card"></one-to-one>
</class>
</hibernate-mapping>
Card.hbm.xml
<hibernate-mapping>
<class name="com.zm.shuang.Card" table="tbu_card">
<id name="id" type="java.lang.Integer">
<column name="ID" />
<generator class="native" />
</id>
<property name="name" type="java.lang.String">
<column name="NAME" />
</property>
<!-- 唯一外键(一对一) -->
<many-to-one name="person" class="com.zm.shuang.Person"
column="person_id" unique="true"/>
</class>
</hibernate-mapping>
5.查看数据库表结构
CREATE TABLE `tbu_person` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`NAME` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin
CREATE TABLE `tbu_card` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`NAME` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
`person_id` int(11) DEFAULT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `UK_skdmp9enx60ckwelehwfd7lx9` (`person_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin
3. 多对多
例如 User和Role关系。一个用户有多个角色,一个角色属于多个用户。
需要额外创建一张中间表。中间表保存2张表的主键对应关系。
开发步骤:
- User类中添加set role的集合属性
- Role类中添加set user的集合属性
- User.hbm.xml设置many-to-many
- Role.hbm.xml设置many-to-many
public class User {
private Integer id;
private String name;
//关联角色
private Set<Role> roles = new HashSet<Role>();
public class Role {
private Integer id;
private String name;
//关联用户
private Set<User> users = new HashSet<User>();
User.hbm.xml
<hibernate-mapping>
<class name="com.zm.shuang.User" table="tbu_user">
<id name="id" type="java.lang.Integer">
<column name="ID" />
<generator class="native" />
</id>
<property name="name" type="java.lang.String">
<column name="NAME" />
</property>
<set name="roles" table="t_user_role">
<key>
<!-- 当前方在中间表的外键 -->
<column name="userid" />
</key>
<!-- column:对方在中间表的外键 -->
<many-to-many class="com.zm.shuang.Role" column="roleid"/>
</set>
</class>
</hibernate-mapping>
Role.hbm.xml
<hibernate-mapping>
<class name="com.zm.shuang.Role" table="tbu_role">
<id name="id" type="java.lang.Integer">
<column name="ID" />
<generator class="native" />
</id>
<property name="name" type="java.lang.String">
<column name="NAME" />
</property>
<set name="users" table="t_user_role" inverse="true">
<key>
<!-- 当前方在中间表的外键 -->
<column name="roleid" />
</key>
<!-- column:对方在中间表的外键 -->
<many-to-many class="com.zm.shuang.User" column="userid"/>
</set>
</class>
</hibernate-mapping>
5.查看表结构
CREATE TABLE `tbu_user` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`NAME` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin
CREATE TABLE `tbu_role` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`NAME` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin
CREATE TABLE `t_user_role` (
`userid` int(11) NOT NULL,
`roleid` int(11) NOT NULL,
PRIMARY KEY (`userid`,`roleid`),
KEY `FKpivvyoiimrnf0hsfb110n1j2t` (`roleid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin