一对多关联.txt

刚用java做的网上购物车 做毕业论文用的 有需要的朋友可以参考下

一对多关联:

drop table t_fruit_one2many;

drop table t_address_one2many;

create table t_fruit_one2many(

    fid integer primary key,

    name varchar(20) not null,

    price integer not null
);

create table t_address_one2many(
    
    aid integer primary key,	
   
    nation varchar(20) not null,

    postcode integer not null,	    
    
    fid integer not null 
        references t_fruit_one2many(fid)
);


----------------------------------------------
one2many.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_one2many">
            <id name="fid" column="fid">
                <generator class="increment"/>
            </id>
            <property name="name"></property>
            <property name="price"></property>
            <set name="addrs" cascade="save-update" inverse="true">
                 <key column="fid"></key>
                 <one-to-many class="hbm.Address"/>
            </set>
         </class>

         <class name="Address" table="t_address_one2many">
            <id name="aid" column="aid">
              <generator class="increment"/>
            </id>
        <property name="nation" column="nation"></property>
        <property name="postcode" column="postcode"></property>
        <many-to-one name="fruit" column="fid" cascade="save-update"></many-to-one>
	</class>
    
      
    </hibernate-mapping>