Hibernate关联之一对多连接表双向关联

最新推荐文章于 2024-08-25 21:18:14 发布

刘承c

最新推荐文章于 2024-08-25 21:18:14 发布

阅读量559

点赞数

分类专栏： Hibernate关联文章标签： hibernate 一对多连接表双向关联

Hibernate关联专栏收录该内容

14 篇文章 0 订阅

订阅专栏

Hibernate 一对多连接表双向关联

一、模型介绍

一个人（Person）对应多个地址（Address）。

二、实体（省略getter、setter方法）

public class Person1ntabboth {

private int personid;

private String name;

private int age;

private Set addresses=new HashSet();

public class Address1ntabboth {

private int addressid;

private String addressdetail;

private Person1ntabboth person1ntabboth;

三、表模型

mysql> desc person_1ntabboth;

+----------+--------------+------+-----+---------+----------------+

+----------+--------------+------+-----+---------+----------------+

| personid | int(11) | NO | PRI | NULL | auto_increment |

| age | int(11) | YES | | NULL | |

+----------+--------------+------+-----+---------+----------------+

mysql> desc address_1ntabboth;

+---------------+--------------+------+-----+---------+----------------+

+---------------+--------------+------+-----+---------+----------------+

| addressid | int(11) | NO | PRI | NULL | auto_increment |

+---------------+--------------+------+-----+---------+----------------+

mysql> desc join_1ntabboth;

+-----------+---------+------+-----+---------+-------+

+-----------+---------+------+-----+---------+-------+

| addressid | int(11) | NO | PRI | | |

| personid | int(11) | NO | PRI | | |

+-----------+---------+------+-----+---------+-------+

四、生成的SQL脚本

/* Formatted on 2007/08/22 17:52 (QP5 v5.50) */

CREATE TABLE `address_1ntabboth` (

`addressid` int(11) NOT NULL auto_increment,

`addressdetail` varchar(255) default NULL,

PRIMARY KEY (`addressid`)

) ENGINE=InnoDB DEFAULT CHARSET=gbk;

/* Formatted on 2007/08/22 17:52 (QP5 v5.50) */

CREATE TABLE `person_1ntabboth` (

`personid` int(11) NOT NULL auto_increment,

`name` varchar(255) default NULL,

`age` int(11) default NULL,

PRIMARY KEY (`personid`)

) ENGINE=InnoDB DEFAULT CHARSET=gbk;

/* Formatted on 2007/08/22 17:52 (QP5 v5.50) */

CREATE TABLE `join_1ntabboth` (

`addressid` int(11) NOT NULL,

`personid` int(11) NOT NULL,

PRIMARY KEY (`personid`,`addressid`),

KEY `FK8F869F61F93DDD6` (`personid`),

KEY `FK8F869F61FC0F682A` (`addressid`),

CONSTRAINT `FK8F869F61FC0F682A` FOREIGN KEY (`addressid`) REFERENCES `address_1ntab_sx` (`addressid`),

CONSTRAINT `FK8F869F61F93DDD6` FOREIGN KEY (`personid`) REFERENCES `person_1ntab_sx` (`personid`)

) ENGINE=InnoDB DEFAULT CHARSET=gbk;

五、映射方法

OneToManyTabBothPerson.hbm.xml

<span style="color:#000000;"><hibernate-mapping>

    <class name="com.bean.Person1ntabboth" table="PERSON_1ntabboth">

        <id name="personid">

            <generator class="identity"/>

        </id>

        <property name="name"/>

        <property name="age"/>


<span style="color:#333333;">        <!--映射集合属性，关联到持久化类-->
        <!--table="join_1ntab_sx"指定了连接表的名字-->

</span>        <set name="addresses" 

             table="join_1ntab_sx" 

             cascade="all"> 

            <!--column="personid"指定连接表中关联当前实体类的列名-->
            <key column="personid" not-null="true"/>

            <!--unique="true"表示当前实体类是"1",不是"n"-->
            <many-to-many column="addressid" unique="true" class="com.bean.Address1ntabboth"/> 

        </set> 

    </class> 

</hibernate-mapping>
</span>

OneToManyTabBothAddress.hbm.xml

<hibernate-mapping>

    <class name="com.bean.Address1ntabboth" table="ADDRESS_1ntabboth"> 

        <id name="addressid"> 

            <generator class="identity"/> 

        </id> 

        <property name="addressdetail"/> 

        <!--映射关联属性，column属性指定外键列名-->
        <join   table="join_1ntabboth" inverse="true" optional="true"> 

            <key column="addressid"/> 

            <many-to-one name="person1ntabboth" 

                         column="personid" 

                         cascade="all" 

                         not-null="true"/> 

        </join> 

    </class> 

</hibernate-mapping>

六、测试

public class Test_1ntabboth {
	@Test
	public void test_1ntabboth(){

		Address1ntabboth add1 = new Address1ntabboth();
		Address1ntabboth add2 = new Address1ntabboth();

		Person1ntabboth p = new Person1ntabboth();

		add1.setAddressdetail("郑州市经三路");
		add2.setAddressdetail("合肥市宿州路");

		p.setName("wang");
		p.setAge(30);

		p.getAddresses().add(add1);
		p.getAddresses().add(add2);

		add1.setPerson1ntabboth(p);
		add2.setPerson1ntabboth(p);

		Session session = HibernateUtil.getCurrentSession();
		Transaction tx = session.beginTransaction();
		session.save(p);
		session.saveOrUpdate(add1);
		session.saveOrUpdate(add2);
		tx.commit();
		HibernateUtil.closeSession(); 

	}
	
}