商品拍卖系统关键属性与会员功能-优快云博客

公共属性：

<?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>&#197;&#196;&#194;&#244;&#188;&#199;&#194;&#188;&#177;&#237;</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>&#205;&#188;&#198;&#172;&#177;&#237;</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>&#202;&#233;&#187;&#173;&#177;&#237;</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>

*.hbm.xml