posts - 165, comments - 198, trackbacks - 0, articles - 1
  BlogJava :: 首页 :: 新随笔 :: 联系 :: 聚合  :: 管理

hibernate 问题小结2 (inverse和cascade)

Posted on 2007-11-16 19:20 G_G 阅读(1707) 评论(2)  编辑  收藏 所属分类: hibernate
inverse 使用
说明约定-如:
1.表属性 :T1oo->id,name
          T2oo->id,avg,aid(
外键 ),version

2.代码过程是:Save->t1oo对象(T1oo 外键 T2oo)
        T1oo t1oo = new T1oo();
        t1oo.setName("xx");       
        t1oo.setT2ooSet(new HashSet());
        T2oo t2oo2 = new T2oo(24);
        //t2oo2.setT1oo(t1oo); (在下面的本用例表中的第3属性 )
        t1oo.getT2ooSet().add(t2oo2);
(在下面的本用例表中的第2属性 )
        session.save(t1oo);

3.本例表使用:
T1oo.hbm.xml ->
        <set name="t2ooSet" inverse="true" cascade = "all"  >
(在下面的本用例表中的第1,2属性 )
            <key column="aid"/>
            <one-to-many class="T2oo"/>
        </set>
T2oo.hbm.xml ->
        <many-to-one name="t1oo" column="aid"  class="T1oo" cascade="all" />
(在下面的本用例表中的第1,2属性 )
结合上面说明得表为:
+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | true  | all   |          |          |
+-------+-------+-------+  true    |  false   |
| t2oo  |       | all   |          |          |
+-------+-------+-------+----------+----------+


4.执行 Hibernate语句
    Hibernate: insert into t1oo (name, id) values (?, ?)
    Hibernate: insert into t2oo (version, avg, aid, id) values (?, ?, ?, ?)
5.结果为:
mysql> select * from t2oo;
+----+-----+------+---------+
| id | avg | aid  | version |
+----+-----+------+---------+
|  2 |  24 | NULL |       0 | //主要就是看 aid属性
+----+-----+------+---------+
1 row in set (0.00 sec)


mysql> select * from t1oo; //
因为 T1oo总是可以 Save 下面就不再提了
+----+------+
| id | name |
+----+------+
|  2 | xx   |
+----+------+
1 row in set (0.00 sec)

可改项:

+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | 可改4 | 可改2  |          |          |
+-------+-------+-------+           |   可改1  |
| t2oo  |       | 可改3 |           |          |
+-------+-------+-------+----------+----------+



主本:
+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | true  | all   |          |          |
+-------+-------+-------+  true    |  true    |
| t2oo  |       | all   |          |          |
+-------+-------+-------+----------+----------+
Hibernate: insert into t1oo (name, id) values (?, ?)
Hibernate: insert into t2oo (version, avg, aid, id) values (?, ?, ?, ?)
mysql> select * from t2oo;
+----+-----+------+---------+
| id | avg | aid  | version |
+----+-----+------+---------+
|  1 |  24 |    1 |       0 |
+----+-----+------+---------+
1 row in set (0.00 sec)


改1
+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | true  | all   |          |          |
+-------+-------+-------+  true    |  false   |
| t2oo  |       | all   |          |          |
+-------+-------+-------+----------+----------+
Hibernate: insert into t1oo (name, id) values (?, ?)
Hibernate: insert into t2oo (version, avg, aid, id) values (?, ?, ?, ?)
mysql> select * from t2oo;
+----+-----+------+---------+
| id | avg | aid  | version |
+----+-----+------+---------+
|  1 |  24 | NULL|       0 |
+----+-----+------+---------+
1 row in set (0.00 sec)

改2
+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | true  |       |          |          |
+-------+-------+-------+  true    |  true    |
| t2oo  |       | all   |          |          |
+-------+-------+-------+----------+----------+
Hibernate: insert into t1oo (name, id) values (?, ?)
Empty set (0.00 sec)

改2  改1
+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | true  |       |          |          |
+-------+-------+-------+  true    |  false   |
| t2oo  |       | all   |          |          |
+-------+-------+-------+----------+----------+
Hibernate: insert into t1oo (name, id) values (?, ?)
Empty set (0.00 sec)


改3
+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | true  | all   |          |          |
+-------+-------+-------+  true    |  true    |
| t2oo  |       |       |          |          |
+-------+-------+-------+----------+----------+
Hibernate: insert into t1oo (name, id) values (?, ?)
Hibernate: insert into t2oo (version, avg, aid, id) values (?, ?, ?, ?)
mysql> select * from t2oo;
+----+-----+------+---------+
| id | avg | aid  | version |
+----+-----+------+---------+
|  1 |  24 |    1 |       0 |
+----+-----+------+---------+
1 row in set (0.00 sec)

改3 改2
+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | true  |       |          |          |
+-------+-------+-------+  true    |  true    |
| t2oo  |       |       |          |          |
+-------+-------+-------+----------+----------+
Hibernate: insert into t1oo (name, id) values (?, ?)
Empty set (0.00 sec)


改3 改1
+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | true  | all   |          |          |
+-------+-------+-------+  true    |  false   |
| t2oo  |       |       |          |          |
+-------+-------+-------+----------+----------+
Hibernate: insert into t1oo (name, id) values (?, ?)
Hibernate: insert into t2oo (version, avg, aid, id) values (?, ?, ?, ?)
mysql> select * from t2oo;
+----+-----+------+---------+
| id | avg | aid  | version |
+----+-----+------+---------+
|  1 |  24 | NULL |       0 |
+----+-----+------+---------+
1 row in set (0.00 sec)

改3 改2 改1
+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | true  |       |          |          |
+-------+-------+-------+  true    |  false   |
| t2oo  |       |       |          |          |
+-------+-------+-------+----------+----------+
Hibernate: insert into t1oo (name, id) values (?, ?)
Empty set (0.00 sec)

改4
+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | false | all   |          |          |
+-------+-------+-------+  true    |  true    |
| t2oo  |       | all   |          |          |
+-------+-------+-------+----------+----------+
Hibernate: insert into t1oo (name, id) values (?, ?)
Hibernate: insert into t2oo (version, avg, aid, id) values (?, ?, ?, ?)
Hibernate: update t2oo set aid=? where id=?
mysql> select * from t2oo;
+----+-----+------+---------+
| id | avg | aid  | version |
+----+-----+------+---------+
|  1 |  24 |    1 |       0 |
+----+-----+------+---------+
1 row in set (0.02 sec)

改4 改1
+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | false | all   |          |          |
+-------+-------+-------+  true    |  false   |
| t2oo  |       | all   |          |          |
+-------+-------+-------+----------+----------+
Hibernate: insert into t1oo (name, id) values (?, ?)
Hibernate: insert into t2oo (version, avg, aid, id) values (?, ?, ?, ?)
Hibernate: update t2oo set aid=? where id=?
mysql> select * from t2oo;
+----+-----+------+---------+
| id | avg | aid  | version |
+----+-----+------+---------+
|  1 |  24 |    1 |       0 |
+----+-----+------+---------+
1 row in set (0.00 sec)

改4 改2
+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | false |       |          |          |
+-------+-------+-------+  true    |  true    |
| t2oo  |       | all   |          |          |
+-------+-------+-------+----------+----------+
Hibernate: insert into t1oo (name, id) values (?, ?)
Hibernate: update t2oo set aid=? where id=?
Empty set (0.00 sec)

改4 改3
+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | false | all   |          |          |
+-------+-------+-------+  true    |  true    |
| t2oo  |       |       |          |          |
+-------+-------+-------+----------+----------+
Hibernate: insert into t1oo (name, id) values (?, ?)
Hibernate: insert into t2oo (version, avg, aid, id) values (?, ?, ?, ?)
Hibernate: update t2oo set aid=? where id=?
mysql> select * from t2oo;
+----+-----+------+---------+
| id | avg | aid  | version |
+----+-----+------+---------+
|  1 |  24 |    1 |       0 |
+----+-----+------+---------+
1 row in set (0.00 sec)

改4 改3 改2

+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | false |       |          |          |
+-------+-------+-------+  true    |  true    |
| t2oo  |       |       |          |          |
+-------+-------+-------+----------+----------+
Hibernate: insert into t1oo (name, id) values (?, ?)
Hibernate: update t2oo set aid=? where id=?
Empty set (0.00 sec)

改4 改1 改2
+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | false |       |          |          |
+-------+-------+-------+  true    |  false   |
| t2oo  |       | all   |          |          |
+-------+-------+-------+----------+----------+
Hibernate: insert into t1oo (name, id) values (?, ?)
Hibernate: update t2oo set aid=? where id=?
Empty set (0.00 sec)


改4 改1 改3
+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | false |  all  |          |          |
+-------+-------+-------+  true    |  false   |
| t2oo  |       |       |          |          |
+-------+-------+-------+----------+----------+
Hibernate: insert into t1oo (name, id) values (?, ?)
Hibernate: insert into t2oo (version, avg, aid, id) values (?, ?, ?, ?)
Hibernate: update t2oo set aid=? where id=?
mysql> select * from t2oo;
+----+-----+------+---------+
| id | avg | aid  | version |
+----+-----+------+---------+
|  1 |  24 |    1 |       0 |
+----+-----+------+---------+
1 row in set (0.02 sec)

改4 改3 改2 改1
+-------+-------+-------+----------+----------+
|hbn.xml|inverse|cascade|t1oo->t2oo|t2oo->t1oo|
+-------+-------+-------+----------+----------+
| t1oo  | false |       |          |          |
+-------+-------+-------+  true    |  false   |
| t2oo  |       |       |          |          |
+-------+-------+-------+----------+----------+
Hibernate: insert into t1oo (name, id) values (?, ?)
Hibernate: update t2oo set aid=? where id=?
Empty set (0.00 sec)







评论

# re: hibernate 问题小结2 (inverse和cascade)  回复  更多评论   

2007-11-16 23:03 by 专注JAVA开源项目
有感...

# re: hibernate 问题小结2 (inverse和cascade)  回复  更多评论   

2007-11-18 01:16 by 快译站
不错,鼓励下原创


5D壁纸 http://5dwall.cn 想看壁纸,新鲜,经典,精美,你想的到的壁纸都有!

只有注册用户登录后才能发表评论。


网站导航: