<rt id="bn8ez"></rt>
<label id="bn8ez"></label>
  • 

    • <span id="bn8ez"></span>
    

    <label id="bn8ez"><meter id="bn8ez"></meter></label>
    

    
    

    




    







												


        




    
	
		
    
			
    
	

    


    
	
					


    
	
	一對(duì)多數(shù)據(jù)關(guān)聯(lián)

    一.單向一對(duì)多數(shù)據(jù)關(guān)聯(lián)
    一個(gè)用戶有多個(gè)地址，在用戶類TUser中包含地址類TAddress集合。

    1.數(shù)據(jù)模型

    2.表定義sql
    use?sample;

    DROP?TABLE?T_Address;
    DROP?TABLE?T_User;

    CREATE?TABLE?T_User?(
    ???????id?    INT?NOT?NULL?AUTO_INCREMENT
    ?????,?name?    VARCHAR(50)
    ?????,?age?    INT
    ?????,?    PRIMARY?KEY?(id)
    );

    CREATE?TABLE?T_Address?(
    ???????id?    INT?NOT?NULL?AUTO_INCREMENT
    ?????,?address?    VARCHAR(200)
    ?????,?zipcode?    VARCHAR(10)
    ?????,?tel?    VARCHAR(20)
    ?????,?type?    VARCHAR(20)
    ?????,?    user_id?INT?NOT?NULL
    ?????,?idx?    INT
    ?????,?    PRIMARY?KEY?(id)
    ?????,?    INDEX?(user_id)
    ?????,?    CONSTRAINT?FK_T_Address_1?FOREIGN?KEY?(user_id)
    ??????????????????    REFERENCES?T_User?(id)
    );


    3.POJO類
    TUser.java
    package?cn.blogjava.start;

    import?java.util.Set;

    public?class?TUser??implements?java.io.Serializable?{
    ????    //?Fields????
    ?????private?Integer?id;
    ?????    private?Integer?age;
    ?????    private?String?name;
    ?????    private?Set?address;


    ????    //?Constructors

    ????    public?Integer?getAge()?{
    ????????    return?age;
    ????}

    ????    public?void?setAge(Integer?age)?{
    ????????    this.age?=?age;
    ????}


    ????    public?Set?getAddress()?{
    ????????    return?address;
    ????}

    ????    public?void?setAddress(Set?address)?{
    ????????    this.address?=?address;
    ????}

    ????    /**?default?constructor?*/
    ????    public?TUser()?{
    ????}
    ????
    ????    /**?constructor?with?id?*/
    ????    public?TUser(Integer?id)?{
    ????????    this.id?=?id;
    ????}

    ????    //?Property?accessors

    ????    public?Integer?getId()?{
    ????????    return?this.id;
    ????}
    ????
    ????    public?void?setId(Integer?id)?{
    ????????    this.id?=?id;
    ????}

    ????    public?String?getName()?{
    ????????    return?this.name;
    ????}
    ????
    ????    public?void?setName(String?name)?{
    ????????    this.name?=?name;
    ????}
    }

    TAddress.java
    package?cn.blogjava.start;

    import?java.io.Serializable;

    public?class?TAddress?implements?Serializable?{
    ????
    ????    private?Integer?id;
    ????    private?String?address;
    ????    private?String?zipcode;
    ????    private?String?tel;
    ????    private?String?type;
    ????    private?Integer?userId;
    ????    private?Integer?idx;
    ????
    ????    public?Integer?getId()?{
    ????????    return?id;
    ????}
    ????    public?void?setId(Integer?id)?{
    ????????    this.id?=?id;
    ????}
    ????    public?String?getAddress()?{
    ????????    return?address;
    ????}
    ????    public?void?setAddress(String?address)?{
    ????????    this.address?=?address;
    ????}
    ????    public?Integer?getIdx()?{
    ????????    return?idx;
    ????}
    ????    public?void?setIdx(Integer?idx)?{
    ????????    this.idx?=?idx;
    ????}
    ????    public?String?getTel()?{
    ????????    return?tel;
    ????}
    ????    public?void?setTel(String?tel)?{
    ????????    this.tel?=?tel;
    ????}
    ????    public?String?getType()?{
    ????????    return?type;
    ????}
    ????    public?void?setType(String?type)?{
    ????????    this.type?=?type;
    ????}
    ????    public?Integer?getUserId()?{
    ????????    return?userId;
    ????}
    ????    public?void?setUserId(Integer?userId)?{
    ????????    this.userId?=?userId;
    ????}
    ????    public?String?getZipcode()?{
    ????????    return?zipcode;
    ????}
    ????    public?void?setZipcode(String?zipcode)?{
    ????????    this.zipcode?=?zipcode;
    ????}

    }

    3.配置文件
    TUser.hbm.xml
    <?xml?version="1.0"?>
    <!DOCTYPE?hibernate-mapping?PUBLIC?"-//Hibernate/Hibernate?Mapping?DTD?3.0//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"    >
    <hibernate-mapping>
    ????    <class?name="cn.blogjava.start.TUser"?table="T_User"?catalog="sample"
    ?????dynamic-update    ="true"?dynamic-insert="true"
    ????    >
    ????????    <id?name="id"?type="integer">
    ????????????    <column?name="id"?/>
    ????????????    <generator?class="native"?/>
    ????????    </id>
    ????????    <property?name="name"?type="string"?column="name"?/>
    ????????    <property?name="age"?type="java.lang.Integer"?column="age"?/>

    ????????    <set?name="address"?table="t_address"?cascade="all"?order-by="zipcode?asc">
    ????????????    <key?column="user_id">
    ????????????    </key>
    ????????????    <one-to-many?class="cn.blogjava.start.TAddress"?/>
    ????????    </set>
    ????    </class>
    </hibernate-mapping>

    TAddress.hbm.xml
    注意：沒(méi)有配置user_id字段。
    <?xml?version="1.0"?>
    <!DOCTYPE?hibernate-mapping?PUBLIC?"-//Hibernate/Hibernate?Mapping?DTD?3.0//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"    >
    <hibernate-mapping>
    ????    <class?name="cn.blogjava.start.TAddress"?table="T_Address"?catalog="sample">
    ????????    <id?name="id"?type="integer">
    ????????????    <column?name="id"?/>
    ????????????    <generator?class="native"?/>
    ????????    </id>
    ????????    <property?name="address"?type="string"?column="address"?/>
    ????????    <property?name="zipcode"?type="string"?column="zipcode"?/>
    ????????    <property?name="tel"?type="string"?column="tel"?/>
    ????????    <property?name="type"?type="string"?column="type"?/>
    ????????    <property?name="idx"?type="java.lang.Integer"?column="idx"?/>
    ????    </class>
    </hibernate-mapping>
    4.測(cè)試代碼
    package?cn.blogjava.start;

    import?java.util.HashSet;
    import?java.util.Iterator;
    import?java.util.List;

    import?junit.framework.Assert;
    import?junit.framework.TestCase;

    import?org.hibernate.HibernateException;
    import?org.hibernate.Session;
    import?org.hibernate.SessionFactory;
    import?org.hibernate.Transaction;
    import?org.hibernate.cfg.Configuration;


    public?class?HibernateTest?extends?TestCase?{
    ????
    ????Session?session?    =?null;

    ????    protected?void?setUp()?{
    ????????    try?{
    ????????????Configuration?config?    =?new?Configuration().configure();
    ????????????SessionFactory?sessionFactory?    =?config.buildSessionFactory();
    ????????????session?    =?sessionFactory.openSession();
    ????????????
    ????????}?    catch?(HibernateException?e)?{
    ????????????e.printStackTrace();
    ????????}????????
    ????}

    ????    protected?void?tearDown()?{
    ????????    try?{
    ????????????session.close();????????
    ????????}?    catch?(HibernateException?e)?{
    ????????????e.printStackTrace();
    ????????}????????
    ????}????
    ????
    ????    /**
    ?????*?對(duì)象持久化測(cè)試(Insert方法)
    ?????    */????????
    ????    public?void?testInsert()?{
    ????????Transaction?tran?    =?null;
    ????????    try?{
    ????????
    ????????????TUser?user?    =?new?TUser();
    ????????????user.setName(    "byf");
    ????????????user.setAge(    new?Integer(26));
    ????????????
    ????????????TAddress?addr?    =?new?TAddress();
    ????????????addr.setTel(    "1123");
    ????????????addr.setZipcode(    "233123");
    ????????????addr.setAddress(    "HongKong");
    ????????????
    ????????????TAddress?addr2?    =?new?TAddress();
    ????????????addr2.setTel(    "139");
    ????????????addr2.setZipcode(    "116001");
    ????????????addr2.setAddress(    "dalian");????????????

    ????????????TAddress?addr3?    =?new?TAddress();
    ????????????addr3.setTel(    "136");
    ????????????addr3.setZipcode(    "100080");
    ????????????addr3.setAddress(    "beijing");
    ????????????
    ????????????    //設(shè)置關(guān)聯(lián)
    ????????????HashSet?set?=?new?HashSet();
    ????????????set.add(addr);
    ????????????set.add(addr2);
    ????????????set.add(addr3);
    ????????????user.setAddress(set);
    ???????????????????????????????????
    ????????????tran?    =?session.beginTransaction();????????????????????????????????
    ????????????    //插入user信息
    ????????????session.save(user);
    ????????????session.flush();
    ????????????tran.commit();
    ????????????Assert.assertEquals(user.getId().intValue()    >0?,true);
    ????????}?    catch?(HibernateException?e)?{
    ????????????e.printStackTrace();
    ????????????Assert.fail(e.getMessage());
    ????????????    if(tran?!=?null)?{
    ????????????????    try?{
    ????????????????????tran.rollback();
    ????????????????}?    catch?(Exception?e1)?{
    ????????????????????e1.printStackTrace();
    ????????????????}
    ????????????}
    ????????}
    ????}
    ????
    ????    /**
    ?????*?對(duì)象讀取測(cè)試(Select方法)
    ?????    */????????????
    ????    public?void?testSelect(){
    ????????String?hql?    =?"?from?TUser?where?name='byf'";
    ????????    try?{
    ????????????List?userList?    =?session.createQuery(hql).list();
    ????????????TUser?user?    =?(TUser)userList.get(0);
    ????????????System.out.println(    "user?name?is?"?+?user.getName());
    ????????????
    ????????????    for?(Iterator?iter?=?user.getAddress().iterator();?iter.hasNext();)?{
    ????????????????TAddress?addr?    =?(TAddress)?iter.next();
    ????????????????System.out.println(    "user?address?is?"?+?addr.getAddress());????????????????
    ????????????}
    ????????????Assert.assertEquals(user.getName(),?    "byf");
    ????????}?    catch?(Exception?e)?{
    ????????????e.printStackTrace();
    ????????????Assert.fail(e.getMessage());
    ????????}
    ????}
    }

    說(shuō)明:
    一個(gè)問(wèn)題，由于是單向關(guān)聯(lián)，為了保持關(guān)聯(lián)關(guān)系，我們只能通過(guò)主控方對(duì)被動(dòng)方進(jìn)行級(jí)聯(lián)更新。如果被關(guān)聯(lián)方的字段為NOT NULL屬性，當(dāng)Hibernate創(chuàng)建或者更新關(guān)聯(lián)關(guān)系時(shí)，可能出現(xiàn)約束違例。
    例子中T_Address表中的user_id 為NOT NULL，如果在TAddress.hbm.xml映射了全部字段時(shí)。創(chuàng)建一個(gè)用戶并賦予她地址信息，對(duì)于T_Address表而言，hibernate會(huì)執(zhí)行兩條sql語(yǔ)句來(lái)保存地址信息。

    要執(zhí)行兩條SQL語(yǔ)句，是因?yàn)殛P(guān)聯(lián)是單向的，就是說(shuō)對(duì)于TAddress對(duì)象而言，并不知道自己應(yīng)該與那一個(gè)TUser對(duì)象關(guān)聯(lián)，只能先將user_id設(shè)為一個(gè)空值。
    之后，根據(jù)配置文件
    ????????<set?name="address"?table="t_address"?cascade="all"?order-by="zipcode?asc">
    ????????????    <key?column="user_id">
    ????????????    </key>
    ????????????    <one-to-many?class="cn.blogjava.start.TAddress"?/>
    ????????    </set>
    由TUser對(duì)象將自身的id賦給addr.user_id，這樣導(dǎo)致addr屬性值變動(dòng)，在事物提交的時(shí)候，會(huì)進(jìn)行update。

    1)當(dāng)save該用戶的時(shí)候，
    insert into t_address? (user_id, address, zipcode, tel) value (null, "HongKong", "233123", "1123")

    2)當(dāng)tx.commit()時(shí)：
    update t_address user_id="1", address="HongKong", zipcode="233123",tel="1123" where id=2;

    這樣，在save user時(shí)，就會(huì)出現(xiàn)約束違例。

    調(diào)整方法：
    可以在定義數(shù)據(jù)表字段時(shí)候，不加NOT NULL約束。或者在開(kāi)始為user_id隨意賦一個(gè)非空值(因?yàn)檫€要update，不正確也沒(méi)關(guān)系)，或者將user_id字段從TAddress.hbm.xml中刪除(本例就是這樣實(shí)現(xiàn))。

    但是這些都是權(quán)宜之計(jì)，用兩條SQL語(yǔ)句完成一次數(shù)據(jù)庫(kù)操作，性能低下。
    而雙向一對(duì)多解決了這個(gè)問(wèn)題。
    下面來(lái)實(shí)現(xiàn)雙向關(guān)聯(lián)：
    修改配置文件
    TUser.hbm.xml
    <?xml?version="1.0"?>
    <!DOCTYPE?hibernate-mapping?PUBLIC?"-//Hibernate/Hibernate?Mapping?DTD?3.0//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"    >
    <hibernate-mapping>
    ????    <class?name="cn.blogjava.start.TUser"?table="T_User"?catalog="sample"
    ?????dynamic-update    ="true"?dynamic-insert="true"
    ????    >
    ????????    <id?name="id"?type="integer">
    ????????????    <column?name="id"?/>
    ????????????    <generator?class="native"?/>
    ????????    </id>
    ????????    <property?name="name"?type="string"?column="name"?/>
    ????????    <property?name="age"?type="java.lang.Integer"?column="age"?/>

    ????????    <set?
    ????????????    name="address"?
    ????????????table    ="t_address"?
    ????????????inverse    ="true"
    ????????????cascade    ="all"?
    ????????????order-by    ="zipcode?asc"
    ????????????    >
    ????????????    <key?column="user_id">
    ????????????    </key>
    ????????????    <one-to-many?class="cn.blogjava.start.TAddress"?/>
    ????????    </set>
    ????    </class>
    </hibernate-mapping>

    設(shè)定inverse="true",表明將TUser類作為被動(dòng)類，將數(shù)據(jù)關(guān)聯(lián)的維護(hù)工作交給關(guān)聯(lián)對(duì)象TAddress來(lái)管理。
    在one-to-many模型中，將many一方設(shè)為主控方有助于性能的改善。(讓總理記住每個(gè)人困難，但是每個(gè)人記住總理方便)

    TAddress.hbm.xml
    <?xml?version="1.0"?>
    <!DOCTYPE?hibernate-mapping?PUBLIC?"-//Hibernate/Hibernate?Mapping?DTD?3.0//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"    >
    <hibernate-mapping>
    ????    <class?name="cn.blogjava.start.TAddress"?table="T_Address"?catalog="sample">
    ????????    <id?name="id"?type="integer">
    ????????????    <column?name="id"?/>
    ????????????    <generator?class="native"?/>
    ????????    </id>
    ????????    <property?name="address"?type="string"?column="address"?/>
    ????????    <property?name="zipcode"?type="string"?column="zipcode"?/>
    ????????    <property?name="tel"?type="string"?column="tel"?/>
    ????????    <property?name="type"?type="string"?column="type"?/>
    ????????    <property?name="idx"?type="java.lang.Integer"?column="idx"?/>
    ????????    <many-to-one
    ??????????????????    name="user"?
    ??????????????????class    ="cn.blogjava.start.TUser"
    ??????????????????cascade    ="none"
    ??????????????????outer-join    ="auto"
    ??????????????????update    ="true"??????????????????
    ??????????????????insert    ="true"
    ??????????????????access    ="property"
    ??????????????????column    ="user_id"
    ??????????????????not-null    ="true"
    ????????    />
    ????    </class>
    </hibernate-mapping>

    2.對(duì)TAddress.java做如下改造：
    去掉user_id字段，增加user字段，和getter,setter方法。
    package?cn.blogjava.start;

    import?java.io.Serializable;

    public?class?TAddress?implements?Serializable?{
    ????
    ????    private?Integer?id;
    ????    private?String?address;
    ????    private?String?zipcode;
    ????    private?String?tel;
    ????    private?String?type;
    ????    private?Integer?idx;
    ????    private?TUser?user;
    ????
    ????    public?TUser?getUser()?{
    ????????    return?user;
    ????}
    ????    public?void?setUser(TUser?user)?{
    ????????    this.user?=?user;
    ????}
    ????    public?Integer?getId()?{
    ????????    return?id;
    ????}
    ????    public?void?setId(Integer?id)?{
    ????????    this.id?=?id;
    ????}
    ????    public?String?getAddress()?{
    ????????    return?address;
    ????}
    ????    public?void?setAddress(String?address)?{
    ????????    this.address?=?address;
    ????}
    ????    public?Integer?getIdx()?{
    ????????    return?idx;
    ????}
    ????    public?void?setIdx(Integer?idx)?{
    ????????    this.idx?=?idx;
    ????}
    ????    public?String?getTel()?{
    ????????    return?tel;
    ????}
    ????    public?void?setTel(String?tel)?{
    ????????    this.tel?=?tel;
    ????}
    ????    public?String?getType()?{
    ????????    return?type;
    ????}
    ????    public?void?setType(String?type)?{
    ????????    this.type?=?type;
    ????}
    ????    public?String?getZipcode()?{
    ????????    return?zipcode;
    ????}
    ????    public?void?setZipcode(String?zipcode)?{
    ????????    this.zipcode?=?zipcode;
    ????}

    }

    4.測(cè)試代碼
    既然TUser不維護(hù)關(guān)聯(lián)關(guān)系，需要TAddress需要自己來(lái)維護(hù)TUser，所以需要addr.setUser(user);
    package?cn.blogjava.start;

    import?java.util.HashSet;
    import?java.util.Iterator;
    import?java.util.List;

    import?junit.framework.Assert;
    import?junit.framework.TestCase;

    import?org.hibernate.HibernateException;
    import?org.hibernate.Session;
    import?org.hibernate.SessionFactory;
    import?org.hibernate.Transaction;
    import?org.hibernate.cfg.Configuration;


    public?class?HibernateTest?extends?TestCase?{
    ????
    ????Session?session?    =?null;

    ????    protected?void?setUp()?{
    ????????    try?{
    ????????????Configuration?config?    =?new?Configuration().configure();
    ????????????SessionFactory?sessionFactory?    =?config.buildSessionFactory();
    ????????????session?    =?sessionFactory.openSession();
    ????????????
    ????????}    ?catch?(HibernateException?e)?{
    ????????????e.printStackTrace();
    ????????}    ????????
    ????}

    ????    protected?void?tearDown()?{
    ????????    try?{
    ????????????session.close();????????
    ????????}    ?catch?(HibernateException?e)?{
    ????????????e.printStackTrace();
    ????????}    ????????
    ????}    ????
    ????
    ????    /**
    ?????*?對(duì)象持久化測(cè)試(Insert方法)
    ?????    */    ????????
    ????    public?void?testInsert()?{
    ????????Transaction?tran?    =?null;
    ????????    try?{
    ????????
    ????????????TUser?user?    =?new?TUser();
    ????????????user.setName(    "byf");
    ????????????user.setAge(    new?Integer(26));
    ????????????
    ????????????TAddress?addr?    =?new?TAddress();
    ????????????addr.setTel(    "1123");
    ????????????addr.setZipcode(    "233123");
    ????????????addr.setAddress(    "HongKong");
    ????????????addr.setUser(user);
    ????????????
    ????????????TAddress?addr2?    =?new?TAddress();
    ????????????addr2.setTel(    "139");
    ????????????addr2.setZipcode(    "116001");
    ????????????addr2.setAddress(    "dalian");???????
    ????????????addr2.setUser(user);

    ????????????TAddress?addr3?    =?new?TAddress();
    ????????????addr3.setTel(    "136");
    ????????????addr3.setZipcode(    "100080");
    ????????????addr3.setAddress(    "beijing");
    ????????????addr3.setUser(user);
    ????????????
    ????????????    //設(shè)置關(guān)聯(lián)
    ????????????HashSet?set?=?new?HashSet();
    ????????????set.add(addr);
    ????????????set.add(addr2);
    ????????????set.add(addr3);
    ????????????user.setAddress(set);
    ???????????????????????????????????
    ????????????tran?    =?session.beginTransaction();????????????????????????????????
    ????????????    //插入user信息
    ????????????session.save(user);
    ????????????session.flush();
    ????????????tran.commit();
    ????????????Assert.assertEquals(user.getId().intValue()    >0?,true);
    ????????}    ?catch?(HibernateException?e)?{
    ????????????e.printStackTrace();
    ????????????Assert.fail(e.getMessage());
    ????????????    if(tran?!=?null)?{
    ????????????????    try?{
    ????????????????????tran.rollback();
    ????????????????}    ?catch?(Exception?e1)?{
    ????????????????????e1.printStackTrace();
    ????????????????}
    ????????????}
    ????????}
    ????}
    ????
    ????    /**
    ?????*?對(duì)象讀取測(cè)試(Select方法)
    ?????    */    ????????????
    ????    public?void?testSelect(){
    ????????String?hql?    =?"?from?TUser?where?name='byf'";
    ????????    try?{
    ????????????List?userList?    =?session.createQuery(hql).list();
    ????????????TUser?user?    =?(TUser)userList.get(0);
    ????????????System.out.println(    "user?name?is?"?+?user.getName());
    ????????????
    ????????????    for?(Iterator?iter?=?user.getAddress().iterator();?iter.hasNext();)?{
    ????????????????TAddress?addr?    =?(TAddress)?iter.next();
    ????????????????System.out.println(    "user?address?is?"?+?addr.getAddress());????????????????
    ????????????}
    ????????????Assert.assertEquals(user.getName(),?    "byf");
    ????????}    ?catch?(Exception?e)?{
    ????????????e.printStackTrace();
    ????????????Assert.fail(e.getMessage());
    ????????}
    ????}
    }
    
	
    posted on 2006-07-05 15:13 knowhow 閱讀(556) 評(píng)論(1)  編輯  收藏  所屬分類: ORM：Hibernate及其他 
    

    







    
	    
    










    








    

				

    





    







    
        
	



主站蜘蛛池模板：
免费又黄又硬又爽大片|
亚洲人成无码网WWW|
亚洲免费无码在线|
亚洲爱情岛论坛永久|
亚洲国产精品嫩草影院|
a级毛片在线免费|
免费无码AV电影在线观看|
国产中文字幕在线免费观看|
啦啦啦完整版免费视频在线观看|
免费a级毛片18以上观看精品|
亚洲精品国产成人专区|
美女一级毛片免费观看|
99久久99久久精品免费观看|
在线观看免费中文视频|
国产一级淫片a免费播放口之|
亚洲日韩图片专区第1页|
国产精品亚洲综合|
5g影院5g天天爽永久免费影院|
亚洲色婷婷综合开心网|
亚洲无人区码一二三码区别图片|
日韩免费高清播放器|
国产特级淫片免费看|
亚洲一区二区影院|
一级做性色a爰片久久毛片免费|
精品国产免费人成网站|
天天摸天天碰成人免费视频|
四虎在线播放免费永久视频|
亚洲精品在线电影|
亚洲精品无码专区在线播放|
久爱免费观看在线网站|
亚洲国产香蕉人人爽成AV片久久
|
激情内射亚洲一区二区三区爱妻|
久久er国产精品免费观看8|
午夜dj免费在线观看|
亚洲成a人不卡在线观看|
日批视频网址免费观看|
免费一级毛片在线播放|
99亚偷拍自图区亚洲|
国产h视频在线观看网站免费|
亚洲精品无码高潮喷水在线|
猫咪免费观看人成网站在线|