一对一关联用主键.txt

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

一对一关联:

drop table t_fruit_one2one_pk;

drop table t_address_one2one_pk;

create table t_address_one2one_pk(

    aid integer primary key,

    nation varchar(20) not null,

    province varchar(20) not null,

    postcode integer not null
);

create table t_fruit_one2one_pk(
 
    fid integer primary key,

    name varchar(20) not null,

    price integer not null,

    constraint fruit_pk foreign key(fid)

        references t_address_one2one_pk(aid)
);
----------------------------------------------
one2onePK.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="Address" table="t_address_one2one_pk">
        <id name="aid" column="aid">
           <generator class="increment"/>
        </id>
        <property name="nation" column="nation"></property>
        <property name="province" column="province"></property>
        <property name="postcode" column="postcode"></property>
    </class>

    <class name="Fruit" table="t_fruit_one2one_pk">
         <id name="fid" column="fid">
            <generator class="foreign">
               <param name="property">addr</param>
           </generator>
         </id>
         <property name="name" column="name"></property>
         <property name="price" column="price"></property>
         <one-to-one name="addr"  cascade="all" constrained="true">
	</one-to-one>
    </class>
    </hibernate-mapping>