單向N-1
情景: 合租泌射，假設(shè)你要租房子粘姜，多個人住同一個地方，對于你來說熔酷，你只需要關(guān)心我今天晚上要住到哪里孤紧，而不需要關(guān)心。某一個地址住了哪些人拒秘，（其實還是應該關(guān)心一下的）号显。
表結(jié)構(gòu)如下
| Field | Type | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+-------+
| id | varchar(50) | NO | PRI | NULL | |
| location | varchar(100) | NO | | NULL | |
+----------+--------------+------+-----+---------+-------+
+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| id | varchar(50) | NO | PRI | NULL | |
| name | varchar(50) | NO | | NULL | |
| age | int(5) | YES | | NULL | |
| address_id | varchar(50) | YES | MUL | NULL | |
+------------+-------------+------+-----+---------+-------+
無鏈接表的單向N-1
- 在N一端的實體增加@ManyToOne 修飾的 關(guān)聯(lián)實體
- 在N一端增加外鍵列，實體類中用@JoinColumn修飾關(guān)聯(lián)實體躺酒。
@Entity
@Table(name="tb_person")
public class Person extends AbstractEntity{
// id 我在AbstractEntity中聲明了
// 需要將AbstractEntity 添加@MappedSuperclass
@Column(name="name")
private String name;
@Column(name="age")
private Integer age;
//用CasecadeType=All 主要方便的是在 Person 更新押蚤，刪除，添加的時候自動把address持久化
@ManyToOne(cascade=CascadeType.ALL)
@JoinColumn(name="address_id")
private Address address;
//省略set.get方法
}
因為不需要從address獲取person 所以 address 只需要自己本身的屬性就行羹应。
@Entity
@Table(name="tb_address")
public class Address extends AbstractEntity{
@Column(name="location")
private String addressDetail;
public String getAddressDetail() {
return addressDetail;
}
public void setAddressDetail(String addressDetail) {
this.addressDetail = addressDetail;
}
}
測試用例
@Test
@Transactional
@Rollback(value=false)
public void testEntity(){
Session session = sessionFactory.getCurrentSession();
Person p = new Person();
Address address = new Address();
address.setAddressDetail("ZheJiang");
p.setName("WhosYourdaddy");
p.setAge(89);
p.setAddress(address);
session.save(p);
}
測試結(jié)果
+--------------------+----------+
| id | location |
+--------------------+----------+
| 170413181716030431 | ZheJiang |
+--------------------+----------+
+--------------------+---------------+------+--------------------+
| id | name | age | address_id |
+--------------------+---------------+------+--------------------+
| 170413181716014566 | WhosYourdaddy | 89 | 170413181716030431 |
+--------------------+---------------+------+--------------------+
我們再來看一下sql輸出揽碘，
第一條
/* get current state com.statestr.verify.entity.Address */
select address_.id, address_.location as location2_0_ from tb_address address_ where address_.id=?
HibernateLog --> 18:17:16 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [170413181716030431]
第二條
/* insert com.statestr.verify.entity.Address*/
insert into tb_address (location, id) values (?, ?)
HibernateLog --> 18:17:16 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [ZheJiang]
HibernateLog --> 18:17:16 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [170413181716030431]
第三條
insert com.statestr.verify.entity.Person*/ insert into tb_person (address_id, age, name, id) values (?, ?, ?, ?)
HibernateLog --> 18:17:16 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [170413181716030431]
HibernateLog --> 18:17:16 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [INTEGER] - [89]
HibernateLog --> 18:17:16 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [VARCHAR] - [WhosYourdaddy]
HibernateLog --> 18:17:16 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [4] as [VARCHAR] - [170413181716014566]
總共執(zhí)行了3條語句。第一條是查詢是否數(shù)據(jù)庫已經(jīng)有了identity 相等的address园匹。如果沒有那就需要insert address.
那么如果數(shù)據(jù)庫已經(jīng)存在該條數(shù)據(jù)庫呢雳刺？
Address address = (Address)session.get(Address.class, "170413181716030431");
// 替換
Address address = new Address();
address.setAddressDetail("ZheJiang");
第一條
select address0_.id as id1_0_0_, address0_.location as location2_0_0_ from tb_address address0_ where address0_.id=?
HibernateLog --> 19:08:43 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [170413181716030431]
第二條
/* insert com.statestr.verify.entity.Person*/
insert into tb_person (address_id, age, name, id) values (?, ?, ?, ?)
HibernateLog --> 19:08:43 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [170413181716030431]
HibernateLog --> 19:08:43 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [INTEGER] - [89]
HibernateLog --> 19:08:43 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [VARCHAR] - [WhosYourdaddy]
HibernateLog --> 19:08:43 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [4] as [VARCHAR] - [170413190843156966]
只執(zhí)行了2條語句，因為它判斷addres已經(jīng)在數(shù)據(jù)庫里面裸违，而且沒有改變其內(nèi)容掖桦。hibernate 會跟蹤每個持久化狀態(tài)對象的改動。（可以參閱 http://www.bbsmax.com/A/amd03O6X5g/ 供汛，我發(fā)現(xiàn)在我這個4.3.11.Final枪汪，其實所有持久化對象都存儲在Session的 persistenceContext凛俱，變量中。持久化對象發(fā)生改變時料饥，他下面的確改變了，但是沒有找到保存之前狀態(tài)的地方朱监。）這里它發(fā)現(xiàn)對象并沒有被改變岸啡。那如果對象發(fā)生改變了呢？
Address address = (Address)session.get(Address.class, "170413181716030431");
address.setAddressDetail("QingDao");
// 替換
Address address = (Address)session.get(Address.class, "170413181716030431");
// 第一條 查找數(shù)據(jù)庫
select address0_.id as id1_0_0_, address0_.location as location2_0_0_ from tb_address address0_ where address0_.id=?
HibernateLog --> 19:22:02 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [170413181716030431]
// 第二條 添加person到數(shù)據(jù)庫
/* insert com.statestr.verify.entity.Person*/ insert into tb_person (address_id, age, name, id) values (?, ?, ?, ?)
HibernateLog --> 19:30:50 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [170413181716030431]
HibernateLog --> 19:30:50 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [INTEGER] - [89]
HibernateLog --> 19:30:50 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [VARCHAR] - [WhosYourdaddy]
HibernateLog --> 19:30:50 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [4] as [VARCHAR] - [170413192101018079]
//第三條 更新address赫编，hibernate session 檢測到持久類已經(jīng)發(fā)生改變
update com.statestr.verify.entity.Address */ update tb_address set location=? where id=?
HibernateLog --> 19:30:50 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [QingDao]
HibernateLog --> 19:30:50 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [170413181716030431]
還要注意一下調(diào)用的順序巡蘸，稍微有點偏題了...
有鏈接表的單向N-1
絕大多數(shù)單向N-1，都是用基于外鍵的擂送。但hibernate 也支持了有連接表的N-1關(guān)系悦荒。（不常用，留個印象就行）
有連接表的單向N-1就需要用到@JoinTable嘹吨，他主要用來映射底層數(shù)據(jù)庫中間表搬味。主要屬性有
| 屬性 | 是否必須 | 說明 |
|---|---|---|
| name | 否 | （重要）中間表的表名 |
| catalog | 否 | 設(shè)置中間表放入制定的catalog |
| schema | 否 | 設(shè)置中間表放入制定的schema |
| targetEntity | 否 | 設(shè)定關(guān)聯(lián)實體的類名。一般不需要設(shè)置蟀拷，hibernate自動會獲取 |
| indexes | 否 | 為連接表設(shè)置多個索引 |
| joinColumns | 否 | （重要）接收JoinColumn碰纬，這邊設(shè)置的是JoinTable表對應當前實體的外鍵列 |
| inverseJoinColumns | 否 | （重要）接收JoinColumn，這邊設(shè)置的是JoinTable表對應關(guān)聯(lián)實體的外鍵列 |
| uniqueConstraints | 否 | 增加唯一性約束 |
（安利一個好的網(wǎng)站 table Generate,可以生成markdow的表格）
好接下來我們來看例子:
表結(jié)構(gòu)
mysql> describe tb_person_addr_map;
+------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+-------------+------+-----+---------+-------+
| person_id | varchar(50) | NO | MUL | NULL | |
| address_id | varchar(50) | NO | MUL | NULL | |
+------------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
mysql> describe tb_person;
+-------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| id | varchar(50) | NO | PRI | NULL | |
| name | varchar(50) | NO | | NULL | |
| age | int(5) | YES | | NULL | |
+-------+-------------+------+-----+---------+-------+
3 rows in set (0.02 sec)
mysql> describe tb_address;
+----------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+-------+
| id | varchar(50) | NO | PRI | NULL | |
| location | varchar(100) | NO | | NULL | |
+----------+--------------+------+-----+---------+-------+
2 rows in set (0.00 sec)
這邊只需要該Person實體
@Entity
@Table(name="tb_person")
public class Person extends AbstractEntity{
@Column(name="name")
private String name;
@Column(name="age")
private Integer age;
@ManyToOne(cascade=CascadeType.ALL)
@JoinTable(name="tb_person_addr_map",joinColumns=@JoinColumn(name="person_id",unique=true),
inverseJoinColumns=@JoinColumn(name="address_id"))
private Address address;
// 省略set问芬、get 方法
}
因為是N-1關(guān)聯(lián)悦析，那么Person只能有一個Address，所以添加了unique=true
我們來看sql輸出:
/* get current state com.statestr.verify.entity.Address */
select address_.id, address_.location as location2_0_ from tb_address address_ where address_.id=?
HibernateLog --> 16:50:50 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [170414165050149527]
/* insert com.statestr.verify.entity.Address*/
insert into tb_address (location, id) values (?, ?)
HibernateLog --> 16:50:50 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [ZheJiang]
HibernateLog --> 16:50:50 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [170414165050149527]
/* insert com.statestr.verify.entity.Person*/
insert into tb_person (age, name, id) values (?, ?, ?)
HibernateLog --> 16:50:50 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [INTEGER] - [89]
HibernateLog --> 16:50:50 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [WhosYourdaddy]
HibernateLog --> 16:50:50 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [3] as [VARCHAR] - [170414165050149349]
/* insert com.statestr.verify.entity.Person*/
insert into tb_person_addr_map (address_id, person_id) values (?, ?)
HibernateLog --> 16:50:50 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - [170414165050149527]
HibernateLog --> 16:50:50 TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - [170414165050149349]
一共執(zhí)行了4條語句此衅∏看鳎可以看到這邊最后才插入到中間表中。
