對(duì)應(yīng)生成的DDL drop table PARENT; 代碼: drop table CHILD; create table PARENT (ID INTEGER not null generated by default as identity, PRimary key (ID)); create table CHILD (ID INTEGER not null generated by default as identity, PARENTID INTEGER, primary key (ID)); alter table CHILD add constraint FK3D1FCFC74B18345 foreign key (PARENTID) references PARENT;
代碼: drop table PARENT; drop table CHILD; create table PARENT (ID INTEGER not null generated by default as identity, primary key (ID)); create table CHILD (ID INTEGER not null generated by default as identity, PARENTID INTEGER, primary key (ID)); alter table CHILD add constraint FK3D1FCFC74B18345 foreign key (PARENTID) references PARENT;
代碼: ITxMgr tx = null; tx = HibernateTxMgr.beginTrans("Add a new relationships..."); session = (Session) tx.getSession(); parent = new ParentPO(); ChildPO child = new ChildPO(parent); ChildPO child2 = new ChildPO(parent); List list = new ArrayList(); list.add(child); list.add(child2); parent.setChildren(list); session.save(parent); session.flush(); System.out.println("dddddddddddddddddddddddddddddddddddddddddddddddddddddd") ; ChildPO child3 = new ChildPO(); child3.setParent(parent); session.save(child3); session.flush(); System.out.println("eeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee") ; tx.endTrans();
hibernate 生成的sql Hibernate: insert into PARENT (ID) values (default)
代碼: Hibernate: insert into CHILD (PARENTID, ID) values (?, default)
Hibernate: insert into CHILD (PARENTID, ID) values (?, default)
Hibernate: update CHILD set PARENTID=? where ID=? dddddddddddddddddddddddddddddddddddddddddddddddddddddd Hibernate: insert into CHILD (PARENTID, ID) values (?, default) Hibernate: values IDENTITY_VAL_LOCAL()
結(jié)果 C:/Myapp/SQLLIB/BIN>db2 select * from parent
代碼: ID ----------- 46 ID PARENTID ----------- ----------- 77 46 78 46 79 46
明顯比原來(lái)多了一句Hibernate: update CHILD set PARENTID=? where ID=?針對(duì)每一個(gè)孩子都去更新父親的id明顯速度很慢,因?yàn)楦赣H有個(gè)孩子的集合,他無(wú)法知道哪個(gè)孩子的父親id已經(jīng)指向自己了,所以對(duì)于每一個(gè)孩子,都要更新父親使他只想自己,而這個(gè)關(guān)系由孩子維護(hù)就好多了,每個(gè)孩子只有一個(gè)父親,只有設(shè)置過(guò)的才需要更新,所以顯然,這個(gè)父子關(guān)系由孩子來(lái)維護(hù)比較省力.減輕了數(shù)據(jù)庫(kù)的負(fù)擔(dān)
*現(xiàn)在我們?cè)賮?lái)看看在沒(méi)有 inverse=true 的條件下 ChildPO child = new ChildPO(parent)---〉ChildPO child = new ChildPO(),
代碼: ITxMgr tx = null; tx = HibernateTxMgr.beginTrans("Add a new relationships..."); session = (Session) tx.getS