一 表结构:
Sql代码
- CREATE
TABLE `user` ( -
`userid` int(11) NOT NULL auto_increment, -
`username` varchar(255) NOT NULL default '', -
`age` int(2) default NULL, -
PRIMARY KEY (`userid`) - )
ENGINE=InnoDB DEFAULT CHARSET=gbk; -
-
- CREATE
TABLE `address` ( -
`aid` int(11) NOT NULL default '0', -
`address` varchar(255) NOT NULL default '', -
PRIMARY KEY (`aid`) - )
ENGINE=InnoDB DEFAULT CHARSET=gbk;
CREATE TABLE `user` ( `userid` int(11) NOT NULL auto_increment, `username` varchar(255) NOT NULL default '', `age` int(2) default NULL, PRIMARY KEY (`userid`) ) ENGINE=InnoDB DEFAULT CHARSET=gbk; CREATE TABLE `address` ( `aid` int(11) NOT NULL default '0', `address` varchar(255) NOT NULL default '', PRIMARY KEY (`aid`) ) ENGINE=InnoDB DEFAULT CHARSET=gbk;
二 POJO与映射文件:
Java代码
- public
clas User { -
private Integer userid; -
private String username; -
private Integer age; -
private Address address; - //getters
setters method... - }
-
- public
class Address { -
private Integer aid; -
private String address; -
private User user; - //getters
setters method... - }
public class User { private Integer userid; private String username; private Integer age; private Address address; //getters setters method... } public class Address { private Integer aid; private String address; private User user; //getters setters method... }
Java代码
- User.hbm.xml
-
- <hibernate-mapping>
-
<class name="com.pojo.User" table="user" dynamic-insert="true" -
dynamic-update="true"> -
<id name="userid" type="integer"> -
<column name="userid" sql-type="int" length="11"></column> -
<generator class="native"></generator> -
</id> -
<property name="username" type="string"> -
<column name="username" sql-type="varchar" length="255" -
not-null="true"> -
</column> -
</property> -
<property name="age" type="integer"> -
<column name="age" sql-type="int" length="2"></column> -
</property> -
<strong><one-to-one name="address" class="com.pojo.Address" -
cascade="all"> -
</one-to-one></strong> -
</class> - </hibernate-mapping>
User.hbm.xml <hibernate-mapping> <class name="com.pojo.User" table="user" dynamic-insert="true" dynamic-update="true"> <id name="userid" type="integer"> <column name="userid" sql-type="int" length="11"></column> <generator class="native"></generator> </id> <property name="username" type="string"> <column name="username" sql-type="varchar" length="255" not-null="true"> </column> </property> <property name="age" type="integer"> <column name="age" sql-type="int" length="2"></column> </property> <one-to-one name="address" class="com.pojo.Address" cascade="all"> </one-to-one> </class> </hibernate-mapping>
Java代码
- Address.hbm.xml
-
- <hibernate-mapping>
-
<class name="com.pojo.Address" table="address" dynamic-insert="true" dynamic-update="true"> -
<id name="aid" type="integer"> -
<column name="aid" sql-type="int" length="11"></column> -
<strong><generator class="foreign"> -
<param name="property">user</param> -
</generator></strong> -
</id> -
<property name="address" type="string"> -
<column name="address" sql-type="varchar" length="255"></column> -
</property> -
<strong><one-to-one name="user" class="com.pojo.User" -
constrained="true" cascade="all"> -
</one-to-one></strong> -
</class> - </hibernate-mapping>