多对多关联.txt

来自「刚用java做的网上购物车 做毕业论文用的 有需要的朋友可以参考下」· 文本 代码 · 共 68 行

多对多关联:

drop table t_fruit_many2many;
drop table t_address_many2many;
drop table t_link_many2many;


create table t_fruit_many2many(

    fid integer primary key,	

    name varchar(20) not null,

    price integer not null
);

create table t_address_many2many(

    aid integer primary key,

    nation varchar(20) not null,

    postcode integer not null
);

create table t_link_many2many(

    fid integer references t_fruit_many2many(fid),

    aid integer references t_address_many2many(aid),

    constraint link_pk primary key(fid,aid)
);
----------------------------------------------
many2many.hbm.xml文件内容：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC 
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

    <hibernate-mapping package="hbm">
	
		<class name="Fruit" table="t_fruit_many2many">
            <id name="fid" column="fid">
                <generator class="increment"/>
            </id>
            <property name="name"></property>
            <property name="price"></property>
            <set name="addrs" table="t_link_many2many" cascade="save-update" inverse="true">
                 <key column="fid"></key>
                 <many-to-many class="hbm.Address" column="aid"/>
            </set>
         </class>

         <class name="Address" table="t_address_many2many">
            <id name="aid" column="aid">
              <generator class="increment"/>
            </id>
        <property name="nation" column="nation"></property>
        <property name="postcode" column="postcode"></property>
        <set name="fruits" table="t_link_many2many" cascade="save-update">
                 <key column="aid"></key>
                 <many-to-many class="hbm.Fruit" column="fid"/>
        </set>
    </class>
      
    </hibernate-mapping>