版权声明: 原创作品,如需转载,请与作者联系。否则将追究法律责任。
Hibernate
一对一连接表双向关联
|
|
一、模型介绍
|
|
一个人(Person )对应一个地址(Address )。
|
|
二、实体(省略getter 、setter 方法)
|
三、表模型
| |||||||
| |||||||
mysql> desc person_11tab_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_11tab_sx;
| |||||||
+---------------+--------------+------+-----+---------+----------------+
| |||||||
| Field | Type | Null | Key | Default | Extra |
| |||||||
+---------------+--------------+------+-----+---------+----------------+
| |||||||
| addressid | int(11) | NO | PRI | NULL | auto_increment |
| |||||||
| addressdetail | varchar(255) | YES | | NULL | |
| |||||||
+---------------+--------------+------+-----+---------+----------------+
| |||||||
| |||||||
四、生成的SQL 脚本
| |||||||
| |||||||
/* Formatted on 2007/08/22 17:35 (QP5 v5.50) */
| |||||||
CREATE TABLE `person_11tab_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;
| |||||||
| |||||||
/* Formatted on 2007/08/22 17:34 (QP5 v5.50) */
| |||||||
CREATE TABLE `address_11tab_sx` (
| |||||||
`addressid` int(11) NOT NULL auto_increment,
| |||||||
`addressdetail` varchar(255) default NULL,
| |||||||
PRIMARY KEY (`addressid`)
| |||||||
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
/* Formatted on 2007/08/22 18:35 (QP5 v5.50) */
CREATE TABLE `join_11tab_sx` ( `addressid` int(11) NOT NULL, `personid` int(11) NOT NULL, PRIMARY KEY (`personid`), UNIQUE KEY `addressid` (`addressid`), UNIQUE KEY `personid` (`personid`), KEY `FKF4AA80E44327AAB6` (`personid`), KEY `FKF4AA80E460C0C9F0` (`addressid`), CONSTRAINT `FKF4AA80E460C0C9F0` FOREIGN KEY (`addressid`) REFERENCES `address_11tab_sx` (`addressid`), CONSTRAINT `FKF4AA80E44327AAB6` FOREIGN KEY (`personid`) REFERENCES `person_11tab_sx` (`personid`) ) ENGINE=InnoDB DEFAULT CHARSET=gbk; |