一对一关联用外键.txt

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

一对一关联:

drop table t_fruit_one2one_fk;

drop table t_address_one2one_fk;

create table t_address_one2one_fk(

    aid long primary key,
   
    nation varchar(20) not null, 
  
    province varchar(20) not null,
   
    postcode long not null
);

create table t_fruit_one2one_fk(

    fid long primary key,

    name varchar(20) not null,

    price long not null,

    aid long not null unique,

    constraint fruit_fk foreign key(aid)
	
        references t_address_one2one_fk(aid)
);
----------------------------------------------
one2oneFK.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_fk">
        <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_fk">
         <id name="fid" column="fid">
            <generator class="increment" />
         </id>
         <property name="name" column="name"></property>
         <property name="price" column="price"></property>
         <many-to-one name="addr" column="aid" unique="true" cascade="all">
</many-to-one>
    </class>
    </hibernate-mapping>