公共属性:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.derong.auction.model.TGoodsCommon" table="T_GOODS_COMMON" schema="HELLO" dynamic-update="true">
<comment>ÉÌÆ·¹«¹²ÊôÐÔ±í</comment>
<id name="goodId" type="string">
<column name="GOOD_ID" length="32" />
<generator class="uuid" />
</id>
<many-to-one name="TMember" class="com.derong.auction.model.TMember" fetch="join" cascade="none">
<column name="MEM_ID" length="32" />
</many-to-one>
<property name="initprice" type="java.lang.Float">
<column name="INITPRICE" precision="126" scale="0" />
</property>
<property name="dealprice" type="java.lang.Float">
<column name="DEALPRICE" precision="126" scale="0" />
</property>
<property name="starttime" type="string">
<column name="STARTTIME" length="20" />
</property>
<property name="overtime" type="string">
<column name="OVERTIME" length="20" />
</property>
<property name="status" type="string">
<column name="STATUS" length="10" />
</property>
<property name="scantime" type="int">
<column name="SCANTIME" />
</property>
<one-to-one name="TLand" class="com.derong.auction.model.TLand" cascade="none"></one-to-one>
<one-to-one name="TChinaware" class="com.derong.auction.model.TChinaware" cascade="none"></one-to-one>
<set name="TPictrues" table="T_PICTRUE" inverse="false" lazy="true" fetch="join" cascade="none">
<key>
<column name="GOOD_ID" length="32" />
</key>
<one-to-many class="com.derong.auction.model.TPictrue" />
</set>
<set name="TEstimates" table="T_ESTIMATE" inverse="false" lazy="true" fetch="join" cascade="none">
<key>
<column name="GOOD_ID" length="32" />
</key>
<one-to-many class="com.derong.auction.model.TEstimate" />
</set>
<set name="TCollections" table="T_COLLECTION" inverse="false" lazy="true" fetch="join" cascade="none">
<key>
<column name="GOOD_ID" length="32" />
</key>
<one-to-many class="com.derong.auction.model.TCollection" />
</set>
<one-to-one name="TPainting" class="com.derong.auction.model.TPainting"></one-to-one>
<set name="TBidRecords" table="T_BID_RECORD" inverse="false" lazy="true" fetch="join" cascade="none">
<key>
<column name="GOOD_ID" length="32" />
</key>
<one-to-many class="com.derong.auction.model.TBidRecord" />
</set>
<one-to-one name="TAgeAmount" class="com.derong.auction.model.TAgeAmount" cascade="none"></one-to-one>
</class>
</hibernate-mapping>
会员:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.derong.auction.model.TMember" table="T_MEMBER" schema="HELLO" dynamic-update="true">
<comment>»áÔ±±í</comment>
<id name="memId" type="string">
<column name="MEM_ID" length="32" />
<generator class="uuid" />
</id>
<property name="name" type="string">
<column name="NAME" length="50" />
</property>
<property name="password" type="string">
<column name="PASSWORD" length="16" />
</property>
<property name="found" type="java.lang.Float">
<column name="FOUND" precision="126" scale="0" />
</property>
<property name="email" type="string">
<column name="EMAIL" length="50" />
</property>
<property name="sex" type="string">
<column name="SEX" length="10" />
</property>
<property name="age" type="int">
<column name="AGE" />
</property>
<property name="phone" type="string">
<column name="PHONE" />
</property>
<property name="education" type="string">
<column name="EDUCATION" length="12" />
</property>
<property name="hobby" type="string">
<column name="HOBBY" length="300" />
</property>
<set name="TCollections" table="T_COLLECTION" inverse="false" lazy="true" fetch="join" cascade="none">
<key>
<column name="MEM_ID" length="32" not-null="true" />
</key>
<one-to-many class="com.derong.auction.model.TCollection" />
</set>
<set name="TGoodsCommons" table="T_GOODS_COMMON" inverse="false" lazy="true" fetch="join" cascade="none">
<key>
<column name="MEM_ID" length="32" />
</key>
<one-to-many class="com.derong.auction.model.TGoodsCommon" />
</set>
<set name="TBidRecords" table="T_BID_RECORD" inverse="false" lazy="true" fetch="join" cascade="none">
<key>
<column name="MEM_ID" length="32" />
</key>
<one-to-many class="com.derong.auction.model.TBidRecord" />
</set>
<set name="TEstimates" table="T_ESTIMATE" inverse="false" lazy="true" fetch="join" cascade="none">
<key>
<column name="MEM_ID" length="32" not-null="true" />
</key>
<one-to-many class="com.derong.auction.model.TEstimate" />
</set>
</class>
</hibernate-mapping>
记录:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.derong.auction.model.TBidRecord" table="T_BID_RECORD" schema="HELLO" dynamic-update="true">
<comment>ÅÄÂô¼Ç¼±í</comment>
<id name="bidRecordId" type="string">
<column name="BID_RECORD_ID" length="32" />
<generator class="uuid" />
</id>
<many-to-one name="TMember" class="com.derong.auction.model.TMember" fetch="join" cascade="none">
<column name="MEM_ID" length="32" />
</many-to-one>
<many-to-one name="TGoodsCommon" class="com.derong.auction.model.TGoodsCommon" fetch="join" cascade="none">
<column name="GOOD_ID" length="32" />
</many-to-one>
<property name="bidtime" type="string">
<column name="BIDTIME" length="20" />
</property>
<property name="bidprice" type="java.lang.Float">
<column name="BIDPRICE" precision="126" scale="0" />
</property>
</class>
</hibernate-mapping>
图片:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 2012-3-29 9:20:05 by Hibernate Tools 3.3.0.GA -->
<hibernate-mapping>
<class name="com.derong.auction.model.TPictrue" table="T_PICTRUE" schema="HELLO" dynamic-update="true" lazy="true">
<comment>ͼƬ±í</comment>
<id name="pictrueId" type="string">
<column name="PICTRUE_ID" length="32" />
<generator class="uuid" />
</id>
<many-to-one name="TGoodsCommon" class="com.derong.auction.model.TGoodsCommon" fetch="join" cascade="none" lazy="false">
<column name="GOOD_ID" length="32" />
</many-to-one>
<property name="directory" type="string">
<column name="DIRECTORY" length="100" not-null="true" />
</property>
</class>
</hibernate-mapping>
年龄统计:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.derong.auction.model.TAgeAmount" table="T_AGE_AMOUNT" schema="HELLO" dynamic-update="true">
<id name="goodId" type="string">
<column name="GOOD_ID" length="32" />
<generator class="foreign">
<param name="property">TGoodsCommon</param>
</generator>
</id>
<one-to-one name="TGoodsCommon" class="com.derong.auction.model.TGoodsCommon" constrained="true" cascade="none"></one-to-one>
<property name="under15" type="int">
<column name="UNDER15" />
</property>
<property name="under25" type="int">
<column name="UNDER25" />
</property>
<property name="under35" type="int">
<column name="UNDER35" />
</property>
<property name="under45" type="int">
<column name="UNDER45" />
</property>
<property name="under55" type="int">
<column name="UNDER55" />
</property>
<property name="under65" type="int">
<column name="UNDER65" />
</property>
<property name="over66" type="int">
<column name="OVER66" />
</property>
</class>
</hibernate-mapping>
书画:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.derong.auction.model.TPainting" table="T_PAINTING" schema="HELLO" dynamic-update="true">
<comment>Êé»­±í</comment>
<!-- <subselect>
select goodId , max(tbr.bidprice) myLastPrice, count(*) myBidNum from TBidRecord tbr where tbr.TMember.memId = ? group by tbr.TGoodsCommon.goodId
</subselect>
<synchronize table="TBidRecord"/> -->
<id name="goodId" type="string">
<column name="GOOD_ID" length="32" />
<generator class="foreign">
<param name="property">TGoodsCommon</param>
</generator>
</id>
<one-to-one name="TGoodsCommon" class="com.derong.auction.model.TGoodsCommon" constrained="true" cascade="none"></one-to-one>
<property name="title" type="string">
<column name="TITLE" length="100" />
</property>
<property name="author" type="string">
<column name="AUTHOR" length="50" />
</property>
<property name="years" type="string">
<column name="YEARS" length="50" />
</property>
<property name="istrue" type="string">
<column name="ISTRUE" length="10" />
</property>
<property name="intact" type="string">
<column name="INTACT" length="10" />
</property>
<property name="dimensions" type="string">
<column name="DIMENSIONS" length="50" />
</property>
<property name="material" type="string">
<column name="MATERIAL" length="300" />
</property>
<property name="authorinfo" type="text">
<column name="AUTHORINFO" />
</property>
<property name="description" type="text">
<column name="DESCRIPTION" />
</property>
</class>
</hibernate-mapping>