hibernate映射吐血整理,附全部配置样板

      

一.一对多的情况:

 

1.1------ 一对多中多的一方 有表又有类(双向,单向不另外做例,只需要去掉对应的<set>元素即可)



 



 

有一个B类,数据库有B类的对应表,B类多对一A类,那么就在A类中定义B对象的set集合,并在A的配置文件中使用

 

 

Customer.hbm.xml:

 

<hibernate-mapping>
 
   <class name="mypack.Customer" table="CUSTOMERS">
       <id name="id" type="long" column="ID">
          <generator class="increment" />
       </id>
 
       <property name="name" type="string">
          <column name="NAME" length="15" />
       </property>
 
       <set name="orders" inverse="true" cascade="save-update">
          <key column="CUSTOMER_ID" />
          <one-to-many class="mypack.Order" />
       </set>
 
   </class>
</hibernate-mapping>
 

 

 

 

Order.hbm.xml:

 

<hibernate-mapping >
 
   <class name="mypack.Order" table="ORDERS">
    
      <id name="id" type="long" column="ID">
        <generator class="increment"/>
      </id>
  
      <property name="orderNumber" type="string" >
        <column name="ORDER_NUMBER" length="15" />
      </property>
     
      <many-to-one
        name="customer"
        column="CUSTOMER_ID"
        class="mypack.Customer"
        cascade="save-update"
       />
 
    </class>
 
</hibernate-mapping>
 

 

1.2----- 一对多中多的一方 有表没有类



 
<!--[endif]-->

如果上面的描述变为B类并不存在,B类的属性全部作为一个值类型放到A中,但是数据库里面是有这个不存在的B类的表的,也就是跟上面的表一样,不一样的只是上面的B类的属性完全融入到了A中,那又该怎么表示呢?要如此表示:

 

 

 

<hibernate-mapping >
  <class name="mypack.Customer" table="CUSTOMERS" >
    <id name="id" type="long" column="ID">
      <generator class="increment"/>
    </id>
 
    <property name="name" type="string" >
        <column name="NAME" length="15" />
    </property>
   <property name="age" type="int" >
        <column name="AGE" />
   </property>
 
   <set   name="images"   table="IMAGES"    lazy="true" >
        <key column="CUSTOMER_ID" />
        <element column="FILENAME" type="string"  not-null="true"/>
   </set>   
 
  </class>
</hibernate-mapping>
 

 

 

---- 一对多中多的一方 有类没有表:

这个叫组成关系:比如



 

这种做如下配置:

<hibernate-mapping >
 
  <class name="mypack.Customer" table="CUSTOMERS" >
    <id name="id" type="long" column="ID">
      <generator class="increment"/>
    </id>
 
    <property name="name" type="string" >
        <column name="NAME" length="15" />
    </property>
   
    <component name="homeAddress" class="mypack.Address">
            <parent name="customer" />
            <property name="province" type="string" column="HOME_PROVINCE"/>
            <property name="city" type="string" column="HOME_CITY"/>
            <property name="street" type="string" column="HOME_STREET"/>
            <property name="zipcode" type="string" column="HOME_ZIPCODE"/>
    </component>
       
    <component name="comAddress" class="mypack.Address">
           <parent name="customer" />
           <property name="province" type="string" column="COM_PROVINCE"/>
           <property name="city" type="string" column="COM_CITY"/>
           <property name="street" type="string" column="COM_STREET"/>
           <property name="zipcode" type="string" column="COM_ZIPCODE"/>
    </component>
  </class>
 
</hibernate-mapping>

 

 

 

 

二.一对一的情况

2.1-------外键映射:



 



 

Address.hbm.xml:

<hibernate-mapping >
 
  <class name="mypack.Address" table="ADDRESSES" >
    <id name="id" type="long" column="ID">
      <generator class="increment"/>
    </id>
 
    <property name="city" column="CITY" type="string" />
    <property name="province" column="PROVINCE" type="string" />
    <property name="street" column="STREET" type="string" />
    <property name="zipcode" column="ZIPCODE" type="string" />
       
    <one-to-one name="customer"
        class="mypack.Customer"
       property-ref="homeAddress"
    />
 
  </class>
</hibernate-mapping>

 

 

Customer.hbm.xml:

<hibernate-mapping >
 
  <class name="mypack.Customer" table="CUSTOMERS" >
    <id name="id" type="long" column="ID">
      <generator class="increment"/>
    </id>
 
    <property name="name" column="NAME" type="string" />
      
    <many-to-one name="homeAddress"
        class="mypack.Address"
        column="HOME_ADDRESS_ID"
        cascade="all"
        unique="true"
    />
 
    <many-to-one name="comAddress"
        class="mypack.Address"
        column="COM_ADDRESS_ID"
        cascade="all"
        unique="true"
    />
<!-- unique的属性为true,表明每个Customer对象都有唯一的的homeAddress和comAdrress对象 -->
 
  </class>
 </hibernate-mapping>

 

2.2--------主键映射:



 



 

Address.hbm.xml:

<hibernate-mapping >
 
  <class name="mypack.Address" table="ADDRESSES" >
    <id name="id" type="long" column="ID">
      <generator class="foreign">
        <param name="property">customer</param>
      </generator>
    </id>
 
    <property name="city" column="CITY" type="string" />
    <property name="province" column="PROVINCE" type="string" />
    <property name="street" column="STREET" type="string" />
    <property name="zipcode" column="ZIPCODE" type="string" />
       
    <one-to-one name="customer"
        class="mypack.Customer"
       constrained="true"
    />
<!--constrained 属性为true表明 ADDRESS 表的ID主键同时作为外键,参照CUSTOMERS表,同时必须还必须设置
<generator class="foreign">
        <param name="property">customer</param>
      </generator>
-->
  </class>
</hibernate-mapping>

 

 

 

Customer.hbm.xml:

 

<hibernate-mapping >
 
  <class name="mypack.Customer" table="CUSTOMERS" >
    <id name="id" type="long" column="ID">
      <generator class="increment"/>
    </id>
 
    <property name="name" column="NAME" type="string" />
      
    <one-to-one name="address"
        class="mypack.Address"
        cascade="all"
     />
  </class>
</hibernate-mapping>

 

 

三.多对多的情况(双向,单向的也不演示了):

 

3.1--------没有加入组件集合的情况下:



 




 

Category.hbm.xml:

<hibernate-mapping>
 
   <class name="mypack.Category" table="CATEGORIES">
      <id name="id" type="long" column="ID">
         <generator class="increment" />
      </id>
 
      <property name="name" column="NAME" type="string" />
 
      <set name="items" table="CATEGORY_ITEM" lazy="true" cascade="save-update">
         <key column="CATEGORY_ID" />
         <many-to-many class="mypack.Item" column="ITEM_ID" />
      </set>
   </class>
</hibernate-mapping>

 

 

Item.hbm.xml:

<hibernate-mapping>
 
   <class name="mypack.Item" table="ITEMS">
      <id name="id" type="long" column="ID">
         <generator class="increment" />
      </id>
 
      <property name="name" column="NAME" type="string" />
      <property name="basePrice" column="BASE_PRICE" type="double" />
 
      <set name="categories" table="CATEGORY_ITEM" lazy="true" inverse="true"
         cascade="save-update">
         <key column="ITEM_ID" />
         <many-to-many class="mypack.Category" column="CATEGORY_ID" />
      </set>
      <!--在双向多对多关联的两端,必须把其中一段的<set>元素的inverse属性设置为“true”,且这一端只能使用<set>元素- -->
   </class>
</hibernate-mapping>

 

 

 

3.2------------加入组件集合的情况下:



 



 

 

Order.hbm.xml:

<hibernate-mapping >
 
  <class name="mypack.Order" table="ORDERS" >
    <id name="id" type="long" column="ID">
      <generator class="increment"/>
    </id>
 
    <property name="orderNumber" column="ORDER_NUMBER" type="string" />
   
    <property name="price" formula=
        "(select  sum(line.BASE_PRICE*line.QUANTITY)  from LINEITEMS line where line.ORDER_ID=ID)" />
 
    <set name="lineItems" lazy="true" table="LINEITEMS" >
        <key column="ORDER_ID" />
        <composite-element class="mypack.LineItem" >
          <parent name="order" />
          <many-to-one name="item" class="mypack.Item" column="ITEM_ID" not-null="true"/>
          <property name="quantity" column="QUANTITY" type="int" not-null="true" />
          <property name="basePrice" column="BASE_PRICE" type="double" not-null="true" />
         </composite-element>
    </set>
     <!----<composite-element> 用于映射lineItems组件类,为什么这么设计?因为到时候我们可以直接通过多态使用 order.getLineItem().add(linmeItem1)的
   方法来加入组件类型。
---->
  </class>
 
</hibernate-mapping>

 

 

Item.hbm.xml:

<hibernate-mapping >
 
  <class name="mypack.Item" table="ITEMS" >
    <id name="id" type="long" column="ID">
      <generator class="increment"/>
    </id>
 
    <property name="name" column="NAME" type="string" />
    <property name="basePrice" column="BASE_PRICE" type="double" />
    
     <set name="lineItems" lazy="true" inverse="true" table="LINEITEMS" >
        <key column="ITEM_ID" />
        <composite-element class="mypack.LineItem" >
          <parent name="item" />
          <many-to-one name="order" class="mypack.Order" column="ORDER_ID" not-null="true"/>
          <property name="quantity" column="QUANTITY" type="int" not-null="true" />
          <property name="basePrice" column="BASE_PRICE" type="double" not-null="true" />
         </composite-element>
    </set>
 
  </class>
</hibernate-mapping>

 

 

3.3--------将多对多的情况分解成两个一对多:

 



 



 

Item.hbm.xml:

<hibernate-mapping >
 
  <class name="mypack.Item" table="ITEMS" >
    <id name="id" type="long" column="ID">
      <generator class="increment"/>
    </id>
 
    <property name="name" column="NAME" type="string" />
    <property name="basePrice" column="BASE_PRICE" type="double" />
   
     <set name="lineItems" lazy="true" inverse="true" cascade="save-update">
        <key column="ITEM_ID" />
        <one-to-many  class="mypack.LineItem" />
     </set>
 
  </class>
</hibernate-mapping>

 

 

 

LineItem.hbm.xml:

 

<hibernate-mapping >
 
  <class name="mypack.LineItem" table="LINEITEMS" >
    <id name="id" type="long" column="ID">
      <generator class="increment"/>
    </id>
 
    <property name="quantity" column="QUANTITY" type="int" />
    <property name="basePrice" column="BASE_PRICE" type="double" />
   
    <many-to-one name="order" column="ORDER_ID" class="mypack.Order" not-null="true" />
    <many-to-one name="item" column="ITEM_ID" class="mypack.Item" not-null="true" />
 
 
  </class>
</hibernate-mapping>

 

 

Order.hbm.xml:

 

<hibernate-mapping >
 
  <class name="mypack.Order" table="ORDERS" >
    <id name="id" type="long" column="ID">
      <generator class="increment"/>
    </id>
 
   <property name="orderNumber" column="ORDER_NUMBER" type="string" />
   
   <set name="lineItems" lazy="true" inverse="true" cascade="save-update">
        <key column="ORDER_ID" />
        <one-to-many  class="mypack.LineItem" />
   </set>
    
  </class>
 
</hibernate-mapping>

 

 

 

其实我觉得看那么多,眼都花了,最有用的还是一对多双向的情况,其他情况个人觉得实际应用并不多!折腾这么多干啥呀!

 

四.继承的情况(当然,肯定是类的继承,数据库的关系模型是不支持继承的):



 



 




 
 



 



 

 

ClassA.hbm.xml:

<hibernate-mapping >
 
   <class name="mypack.ClassA" table="TABLE_A" discriminator-value="A" >
      <id name="id" type="long" column="ID">
        <generator class="increment"/>
      </id>
      <discriminator column="A_TYPE" type="string"  /> 
      <property name="a1" type="string" column="A1" />
 
      <subclass name="mypack.ClassC" discriminator-value="C" >
         <property name="c1" column="C1" type="string" />
      </subclass>
 
      <subclass name="mypack.ClassD" discriminator-value="D" >
        <property name="d1" column="D1" type="string" />
 
        <subclass name="mypack.ClassG" discriminator-value="G" >
           <property name="g1" column="G1" type="string" />
        </subclass>
       
        <subclass name="mypack.ClassH" discriminator-value="H" >
           <property name="h1" column="H1" type="string" />
        </subclass>
 
      </subclass>
    </class>
</hibernate-mapping>

 

 

ClassB.hbm.xml:

<hibernate-mapping >
 
   <class name="mypack.ClassB" table="TABLE_B">
      <id name="id" type="long" column="ID">
        <generator class="increment"/>
      </id>
      <property name="b1" type="string" column="B1" />
 
      <joined-subclass name="mypack.ClassE"  table="TABLE_E">
         <key column="B_ID" />
         <property name="e1" column="E1" type="string" />
         <property name="e2" column="E2" type="string" />
         <property name="e3" column="E3" type="string" />
         <property name="e4" column="E4" type="string" />
         <property name="e5" column="E5" type="string" />
         <property name="e6" column="E6" type="string" />
      </joined-subclass >
 
      <joined-subclass name="mypack.ClassF"  table="TABLE_F">
         <key column="B_ID" />
         <property name="f1" column="F1" type="string" />
         <property name="f2" column="F2" type="string" />
         <property name="f3" column="F3" type="string" />
         <property name="f4" column="F4" type="string" />
         <property name="f5" column="F5" type="string" />
         <property name="f6" column="F6" type="string" />
      </joined-subclass >
    </class>
 
</hibernate-mapping>

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值