三个实体简略代码如下:
package com.jinxiu.tour.pojos;
import java.util.HashSet;
import java.util.Set;
/**
* @author dengjinxiu
*
*/
public class Trade implements java.io.Serializable {
private Long tradecode;
private String tradename;
private Set<Shop> shops=new HashSet<Shop>(0);
......(略)
}
package com.jinxiu.tour.pojos;
/**
* @author dengjinxiu
*
*/
public class Shop implements java.io.Serializable {
private String shopname;//店名
private String shopcode;//店编号
private Trade trade;//类型
......(略)
}
package com.jinxiu.tour.pojos;
import java.io.Serializable;
import java.util.Date;
/**
* @author dengjinxiu
*
*/
public class Tour implements Serializable {
private Long tuserId;
private String tuserName;
private String tsex;
private Date tborn;
private String isMarry;
private String tadd;
private String interself;
private String career;
private String blood;
private String occu;
private String forte;
private String tnature;
private String hobby;
private String email;
private String phone;
private Integer qq;
private String address;
private Integer addcode;//邮编
private String realname;
private String shopadd;
......(略)
}
实体的MappingResources如下:
shop.hbm.xml:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!--
Mapping file autogenerated by MyEclipse - Hibernate Tools
-->
<hibernate-mapping>
<class name="com.jinxiu.tour.pojos.Shop" table="shop" schema="dbo" lazy="false">
<id name="shopcode" type="java.lang.String">
<column name="shopcode" length="25"/>
<generator class="com.jinxiu.tour.utils.IdGenerator">
<param name="table">idstore</param>
<param name="id_column_name">idName</param>
<param name="value_column_name">nextId</param>
<param name="id_name">shopcode</param>
<param name="rule">*SHOP,-,#5</param>
</generator>
</id>
<many-to-one name="trade" class="com.jinxiu.tour.pojos.Trade" fetch="select">
<column name="tradecode"/>
</many-to-one>
<property name="shopname" type="java.lang.String">
<column name="shopname" length="25"/>
</property>
<property name="shopadd" type="java.lang.String">
<column name="shopadd" length="50"/>
</property>
</class>
</hibernate-mapping>
Tour.hbm.xml:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!--
Mapping file autogenerated by MyEclipse - Hibernate Tools
-->
<hibernate-mapping>
<class name="com.jinxiu.tour.pojos.Tour" table="tour" lazy="false" schema="dbo" catalog="tour">
<id name="tuserId" type="java.lang.Long">
<column name="tuserId"/>
<generator class="identity"/>
</id>
<property name="tuserName" type="java.lang.String">
<column name="tuserName" length="25"/>
</property>
<property name="tsex" type="java.lang.String">
<column name="tsex" length="2"/>
</property>
<property name="tborn" type="timestamp">
<column name="tborn"/>
</property>
<property name="isMarry" type="java.lang.String">
<column name="isMarry" length="2"/>
</property>
<property name="tadd" type="java.lang.String">
<column name="tadd" length="50"/>
</property>
<property name="interself" type="java.lang.String">
<column name="interself" length="200"/>
</property>
<property name="career" type="java.lang.String">
<column name="career" length="25"/>
</property>
<property name="blood" type="java.lang.String">
<column name="blood" length="6"/>
</property>
<property name="occu" type="java.lang.String">
<column name="occu" length="20"/>
</property>
<property name="forte" type="java.lang.String">
<column name="forte" length="20"/>
</property>
<property name="tnature" type="java.lang.String">
<column name="tnature" length="20"/>
</property>
<property name="hobby" type="java.lang.String">
<column name="hobby" length="20"/>
</property>
<property name="email" type="java.lang.String">
<column name="email" length="25"/>
</property>
<property name="phone" type="java.lang.String">
<column name="phone" length="20"/>
</property>
<property name="qq" type="java.lang.Integer">
<column name="QQ"/>
</property>
<property name="address" type="java.lang.String">
<column name="address" length="50"/>
</property>
<property name="addcode" type="java.lang.Integer">
<column name="addcode"/>
</property>
<property name="realname" type="java.lang.String">
<column name="realname" length="25"/>
</property>
</class>
</hibernate-mapping>
Trade.hbm.xml:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!--
Mapping file autogenerated by MyEclipse - Hibernate Tools
-->
<hibernate-mapping>
<class name="com.jinxiu.tour.pojos.Trade" table="trade" lazy="false" schema="dbo" catalog="tour">
<id name="tradecode" type="java.lang.Long">
<column name="tradecode"/>
<generator class="native"/>
</id>
<set name="shops" inverse="false" cascade="all" lazy="false">
<key>
<column name="tradecode"/>
</key>
<one-to-many class="com.jinxiu.tour.pojos.Shop"/>
</set>
<property name="tradename" type="java.lang.String">
<column name="tradename" length="25"/>
</property>
</class>
</hibernate-mapping>
package com.jinxiu.tour.pojos;
import java.util.HashSet;
import java.util.Set;
/**
* @author dengjinxiu
*
*/
public class Trade implements java.io.Serializable {
private Long tradecode;
private String tradename;
private Set<Shop> shops=new HashSet<Shop>(0);
......(略)
}
package com.jinxiu.tour.pojos;
/**
* @author dengjinxiu
*
*/
public class Shop implements java.io.Serializable {
private String shopname;//店名
private String shopcode;//店编号
private Trade trade;//类型
......(略)
}
package com.jinxiu.tour.pojos;
import java.io.Serializable;
import java.util.Date;
/**
* @author dengjinxiu
*
*/
public class Tour implements Serializable {
private Long tuserId;
private String tuserName;
private String tsex;
private Date tborn;
private String isMarry;
private String tadd;
private String interself;
private String career;
private String blood;
private String occu;
private String forte;
private String tnature;
private String hobby;
private String email;
private String phone;
private Integer qq;
private String address;
private Integer addcode;//邮编
private String realname;
private String shopadd;
......(略)
}
实体的MappingResources如下:
shop.hbm.xml:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!--
Mapping file autogenerated by MyEclipse - Hibernate Tools
-->
<hibernate-mapping>
<class name="com.jinxiu.tour.pojos.Shop" table="shop" schema="dbo" lazy="false">
<id name="shopcode" type="java.lang.String">
<column name="shopcode" length="25"/>
<generator class="com.jinxiu.tour.utils.IdGenerator">
<param name="table">idstore</param>
<param name="id_column_name">idName</param>
<param name="value_column_name">nextId</param>
<param name="id_name">shopcode</param>
<param name="rule">*SHOP,-,#5</param>
</generator>
</id>
<many-to-one name="trade" class="com.jinxiu.tour.pojos.Trade" fetch="select">
<column name="tradecode"/>
</many-to-one>
<property name="shopname" type="java.lang.String">
<column name="shopname" length="25"/>
</property>
<property name="shopadd" type="java.lang.String">
<column name="shopadd" length="50"/>
</property>
</class>
</hibernate-mapping>
Tour.hbm.xml:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!--
Mapping file autogenerated by MyEclipse - Hibernate Tools
-->
<hibernate-mapping>
<class name="com.jinxiu.tour.pojos.Tour" table="tour" lazy="false" schema="dbo" catalog="tour">
<id name="tuserId" type="java.lang.Long">
<column name="tuserId"/>
<generator class="identity"/>
</id>
<property name="tuserName" type="java.lang.String">
<column name="tuserName" length="25"/>
</property>
<property name="tsex" type="java.lang.String">
<column name="tsex" length="2"/>
</property>
<property name="tborn" type="timestamp">
<column name="tborn"/>
</property>
<property name="isMarry" type="java.lang.String">
<column name="isMarry" length="2"/>
</property>
<property name="tadd" type="java.lang.String">
<column name="tadd" length="50"/>
</property>
<property name="interself" type="java.lang.String">
<column name="interself" length="200"/>
</property>
<property name="career" type="java.lang.String">
<column name="career" length="25"/>
</property>
<property name="blood" type="java.lang.String">
<column name="blood" length="6"/>
</property>
<property name="occu" type="java.lang.String">
<column name="occu" length="20"/>
</property>
<property name="forte" type="java.lang.String">
<column name="forte" length="20"/>
</property>
<property name="tnature" type="java.lang.String">
<column name="tnature" length="20"/>
</property>
<property name="hobby" type="java.lang.String">
<column name="hobby" length="20"/>
</property>
<property name="email" type="java.lang.String">
<column name="email" length="25"/>
</property>
<property name="phone" type="java.lang.String">
<column name="phone" length="20"/>
</property>
<property name="qq" type="java.lang.Integer">
<column name="QQ"/>
</property>
<property name="address" type="java.lang.String">
<column name="address" length="50"/>
</property>
<property name="addcode" type="java.lang.Integer">
<column name="addcode"/>
</property>
<property name="realname" type="java.lang.String">
<column name="realname" length="25"/>
</property>
</class>
</hibernate-mapping>
Trade.hbm.xml:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!--
Mapping file autogenerated by MyEclipse - Hibernate Tools
-->
<hibernate-mapping>
<class name="com.jinxiu.tour.pojos.Trade" table="trade" lazy="false" schema="dbo" catalog="tour">
<id name="tradecode" type="java.lang.Long">
<column name="tradecode"/>
<generator class="native"/>
</id>
<set name="shops" inverse="false" cascade="all" lazy="false">
<key>
<column name="tradecode"/>
</key>
<one-to-many class="com.jinxiu.tour.pojos.Shop"/>
</set>
<property name="tradename" type="java.lang.String">
<column name="tradename" length="25"/>
</property>
</class>
</hibernate-mapping>