注册 | 登录 忘记密码? 51cto首页 | 博客 | 论坛 | 招聘
热点文章 如何系统的学习linux?
 帮助

Hibernate 一对一外键双向关联


2007-08-22 17:07:23
 标签:Hibernate 一对一   [推送到技术圈]

版权声明:原创作品,如需转载,请与作者联系。否则将追究法律责任。
Hibernate 一对一外键双向关联
 
 
 
一、模型介绍
 
 
 
一个人(Person)对应一个地址(Address)。
 
 
 
二、实体(省略gettersetter方法)
 
 
 
public class Person11fk_sx {
 
    private int personid;
 
    private String name;
 
    private int age;
 
    private Address11fk_sx address11fk_sx;
 
 
 
public class Address11fk_sx {
 
    private int addressid;
 
    private String addressdetail;
 
    private Person11fk_sx person11fk_sx;
 
 
 
三、表模型
 
 
 
mysql> desc person_11fk_sx;
 
+----------+--------------+------+-----+---------+----------------+
 
| Field    | Type         | Null | Key | Default | Extra          |
 
+----------+--------------+------+-----+---------+----------------+
 
| personid | int(11)      | NO   | PRI | NULL    | auto_increment |
 
| name     | varchar(255) | YES  |     | NULL    |                |
 
| age      | int(11)      | YES  |     | NULL    |                |
 
+----------+--------------+------+-----+---------+----------------+
 
mysql> desc address_11fk_sx;
 
+---------------+--------------+------+-----+---------+----------------+
 
| Field         | Type         | Null | Key | Default | Extra          |
 
+---------------+--------------+------+-----+---------+----------------+
 
| addressid     | int(11)      | NO   | PRI | NULL    | auto_increment |
 
| addressdetail | varchar(255) | YES  |     | NULL    |                |
 
| person11fk_sx | int(11)      | YES  | UNI | NULL    |                |
 
+---------------+--------------+------+-----+---------+----------------+
 
 
 
四、生成的SQL脚本
 
 
 
/* Formatted on 2007/08/22 17:15 (QP5 v5.50) */
 
CREATE TABLE `address_11fk_sx` (
 
  `addressid` int(11) NOT NULL auto_increment,
 
  `addressdetail` varchar(255) default NULL,
 
  `person11fk_sx` int(11) default NULL,
 
  PRIMARY KEY  (`addressid`),
 
  UNIQUE KEY `person11fk_sx` (`person11fk_sx`),
 
  KEY `FKF05FC94AAD732F4` (`person11fk_sx`),
 
  CONSTRAINT `FKF05FC94AAD732F4` FOREIGN KEY (`person11fk_sx`) REFERENCES `person_11fk_sx` (`personid`)
 
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
 
 
 
/* Formatted on 2007/08/22 17:16 (QP5 v5.50) */
 
CREATE TABLE `person_11fk_sx` (
 
  `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;
 
 
 
五、映射方法
 
 
 
<hibernate-mapping>
 
    <class name="com.lavasoft.sx._1_1_fk.Person11fk_sx" table="PERSON_11fk_sx">
 
        <id name="personid">
 
            <generator class="identity"/>
 
        </id>
 
        <property name="name"/>
 
        <property name="age"/>
 
        <one-to-one name="address11fk_sx"
 
                    cascade="all"
 
                    property-ref="person11fk_sx"/>
 
    </class>
 
</hibernate-mapping>
 
 
 
<hibernate-mapping>
 
    <class name="com.lavasoft.sx._1_1_fk.Address11fk_sx" table="ADDRESS_11fk_sx">
 
        <id name="addressid">
 
            <generator class="identity"/>
 
        </id>
 
        <property name="addressdetail"/>
 
        <!--unique="true"表示本实体是"1"-->
 
        <many-to-one name="person11fk_sx" unique="true"/>
 
    </class>
 
</hibernate-mapping>
 
 
 
六、测试方法
 
 
 
public class Test_11fk_sx {
 
    public static void main(String[] args) {
 
        Address11fk_sx add = new Address11fk_sx();
 
        Person11fk_sx p = new Person11fk_sx();
 
 
 
        add.setAddressdetail("郑州市经三路");
 
        p.setAge(12);
 
        p.setName("wudalang");
 
 
 
        add.setPerson11fk_sx(p);
 
        p.setAddress11fk_sx(add);
 
 
 
        Session session = HibernateUtil.getCurrentSession();
 
        Transaction tx = session.beginTransaction();
 
        session.save(p);
 
        tx.commit();
 
        HibernateUtil.closeSession();
 
    }
 
}
 
 
 
七、测试结果
 
 
 
1) :正常保存.
 
        session.save(p);
 
 
 
Hibernate: insert into PERSON_11fk_sx (name, age) values (?, ?)
 
Hibernate: insert into ADDRESS_11fk_sx (addressdetail, person11fk_sx) values (?, ?)
 
 
 
 
 
 

本文出自 “熔 岩” 博客,转载请与作者联系!


附件下载:
  _1_1_fk




    文章评论
 
 

发表评论

昵   称:
验证码:  点击图片可刷新验证码  博客过2级,无需填写验证码
内   容: