<?xml version="1.0" encoding="GBK"?>

<!DOCTYPE hibernate-mapping

    PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"

    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping package="com.wolfgang.domain">

    <class    name="User"    table="t_user">

        <id    name="id" type="integer" column="id">

            <generator class="increment"/>

        </id>

        <property name="username" column="username"    type="string"

            not-null="true" length="255" unique="true"/>

        <property name="password" column="password"    type="string"

            not-null="true" length="255"/>

        <many-to-one name="group" column="groupid" class="Group" cascade="all"/>
         ##注意， name表示model中的名字，column表示字表外键的列名，class表示父表的model类, cascade 表示是否级联操作

    </class>

</hibernate-mapping>

<?xml version="1.0" encoding="GBK"?>

<!DOCTYPE hibernate-mapping

    PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"

    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping package="com.wolfgang.domain">

    <class    name="Group"    table="t_group">

        <id    name="id" type="integer" column="id">

            <generator class="increment"/>

        </id>

        <property name="groupName" column="groupName"    type="string"

            not-null="true" length="255" unique="true"/>

    </class>

</hibernate-mapping>

DROP TABLE IF EXISTS `t_user`;

CREATE TABLE `t_user` (

  `Id` int(11) NOT NULL AUTO_INCREMENT,

  `groupname` varchar(255) DEFAULT NULL,

  `groupid` int(11) DEFAULT NULL,

  `username` varchar(255) NOT NULL DEFAULT '',

  `password` varchar(255) NOT NULL DEFAULT '',

  PRIMARY KEY (`Id`),

  KEY `index_groupid` (`groupid`),

  CONSTRAINT `con_groupid` FOREIGN KEY (`groupid`) REFERENCES `t_group` (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `t_group`;

CREATE TABLE `t_group` (

  `id` int(11) NOT NULL DEFAULT '0',

  `groupName` varchar(255) DEFAULT NULL,

  PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;