Hibernate的继承策略

<!-- [if !mso]> <style> v\:* {behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape {behavior:url(#default#VML);} </style> <![endif]--><!-- [if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:DrawingGridVerticalSpacing>7.8 磅</w:DrawingGridVerticalSpacing> <w:DisplayHorizontalDrawingGridEvery>0</w:DisplayHorizontalDrawingGridEvery> <w:DisplayVerticalDrawingGridEvery>2</w:DisplayVerticalDrawingGridEvery> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:SpaceForUL/> <w:BalanceSingleByteDoubleByteWidth/> <w:DoNotLeaveBackslashAlone/> <w:ULTrailSpace/> <w:DoNotExpandShiftReturn/> <w:AdjustLineHeightInTable/> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:UseFELayout/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!-- [if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><!-- [if !mso]> <span class="mceItemObject" classid="clsid:38481807-CA0E-42D2-BF39-B33AF135CC4D" id=ieooui> </span> <style> st1\:*{behavior:url(#ieooui) } </style> <![endif]--> <!-- [if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]-->

<!-- [if !supportLists]-->节 1.01   <!-- [endif]-->每个带有联合的具体类一张表 – union-class

<!-- [if gte vml 1]><v:shapetype id="_x0000_t75" coordsize="21600,21600" o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f"> <v:stroke joinstyle="miter"/> <v:formulas> <v:f eqn="if lineDrawn pixelLineWidth 0"/> <v:f eqn="sum @0 1 0"/> <v:f eqn="sum 0 0 @1"/> <v:f eqn="prod @2 1 2"/> <v:f eqn="prod @3 21600 pixelWidth"/> <v:f eqn="prod @3 21600 pixelHeight"/> <v:f eqn="sum @0 0 1"/> <v:f eqn="prod @6 1 2"/> <v:f eqn="prod @7 21600 pixelWidth"/> <v:f eqn="sum @8 21600 0"/> <v:f eqn="prod @7 21600 pixelHeight"/> <v:f eqn="sum @10 21600 0"/> </v:formulas> <v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/> <o:lock v:ext="edit" aspectratio="t"/> </v:shapetype><v:shape id="_x0000_i1026" type="#_x0000_t75" style="width:401.25pt; height:129pt" mce_style="width:401.25pt; height:129pt"> <v:imagedata src="file:///C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\msohtml1\03\clip_image001.png" mce_src="file:///C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\msohtml1\03\clip_image001.png" o:title="3"/> </v:shape><![endif]--><!-- [if !vml]--><!-- [endif]-->

    <!-- 注：抽象的超类或者接口必须声明为 abstract ，否则超类实例需要一张单独表 -->

    < class name = "hibernate.hierarchical.BillingDetails" abstract = "true" >

< union-subclass name = "hibernate.hierarchical.CreditCard" table = "CREDIT_CARD" >

           < property name = "number" column = "NUMBER" />

           < property name = "expMonth" column = "EXP_MONTH" />

           < property name = "expYear" column = "EXP_YEAR" />

       </ union-subclass >

       < union-subclass name = "hibernate.hierarchical.BankAccount" table = "BANK_ACCOUNT" >

           < property name = "account" column = "ACCOUNT" />

           < property name = "bankname" column = "BANKNAME" />

           < property name = "swift" column = "SWIFT" />

       </ union-subclass >

    </ class >

public class BillingDetails { private Long id ; private String owner ;}

public class BankAccount extends BillingDetails {

private String account ; private String bankname ; private String swift ;}

public class CreditCard extends BillingDetails {

private String number ; private String expMonth ; private String expYear ;}

 

查询 BillingDetails 时生成的 SQL 如下：

Select BILLING_DETAIL_ID,OWNER… FROM

(

       Select BILLING_DETAIL_ID_OWNER,NUMBER,EXP_MONTH,EXMP_YEAR,null as ACCOUNT,null AS BANKNAME,null as SWIFT 1 as CLAZZ_

FROM CREDIT_CARD

       UNION

Select BILLING_DETAIL_ID_OWNER,null as NUMBER,null as EXP_MONTH,null as EXP_YEAR,ACCOUNT,BANKNAME,SWIFT,2 as CLAZZ_

       FROM BANK_ACCOUNT

)

这样使用的效率最高

<!-- [if !supportLists]-->节 1.02   <!-- [endif]-->每个类层次结构一张表 – SubClass

<!-- [if gte vml 1]><v:shape id="_x0000_i1027" type="#_x0000_t75" style="width:248.25pt;height:177.75pt" mce_style="width:248.25pt;height:177.75pt"> <v:imagedata src="file:///C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\msohtml1\03\clip_image003.png" mce_src="file:///C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\msohtml1\03\clip_image003.png" o:title="2"/> </v:shape><![endif]--><!-- [if !vml]--><!-- [endif]-->

注：

<!-- [if !supportLists]-->1、  <!-- [endif]-->在表设计时添加辨别标志 (BILLING_DETAILS_TYPE) 用于在持久化类之间区分不同对象。

<!-- [if !supportLists]-->2、  <!-- [endif]-->在列名称设计上需要加前缀（比如 CC/BA ）等，用于让 Hibernate 自动识别不同对象。

 

    < class name = "hibernate.hierarchical.BillingDetails" table = "Billing_Details" >

       < property name = "owner" column = "OWNER" type = "string" />

       <!-- 添加一个辨别标志以便在持久化类之间进行区分 -->

       < discriminator column = "BILLING_DETAILS_TYPE" type = "string" />

       < subclass name = "hibernate.hierarchical.CreditCard" discriminator-value = "CC" >

           < property name = "number" column = "CC_NUMBER" />

           < property name = "expMonth" column = "CC_EXP_MONTH" />

           < property name = "expYear" column = "CC_EXP_YEAR" />

       </ subclass >

       < subclass name = "hibernate.hierarchical.BankAccount" discriminator-value = "BA" >

           < property name = "account" column = "BA_ACCOUNT" />

           < property name = "bankname" column = "BA_BANKNAME" />

           < property name = "swift" column = "BA_SWIFT" />

       </ subclass >

    </ class >

public class BillingDetails { private Long id ; private String owner ;}

public class BankAccount extends BillingDetails {

private String account ; private String bankname ; private String swift ;}

public class CreditCard extends BillingDetails {

private String number ; private String expMonth ; private String expYear ;}

 

当查询父表 BillingDetails 时将 BILLING_DETAILS 表字段全部查询。

Select BILLING_DETAILS_ID,CC_NUMBER,CC_EXP_MONTH… FROM BILLING_DETAILS

当查询子表 BankAccount/CreditCard 表时通过标识字段进行限制。

Select BILLING_DETAILS_ID,CC_NUMBER,CC_EXP_MONTH FROM BILLING_DETAILS WHERE BILLING_DETAILS_TYPE=’CC’

注：当类继承关系比较多时，存在性能问题

 

<!-- [if !supportLists]-->节 1.03   <!-- [endif]-->每个子类一个表 – JoinSubClass

将一个表示逻辑的大表拆分成多个子表，每个子表通过主键 / 外键的关系同父表进行关联，从而形成继承关系。每个子表的主键同时时父表的外键

<!-- [if gte vml 1]><v:shape id="_x0000_i1025" type="#_x0000_t75" style="width:414.75pt;height:258pt" mce_style="width:414.75pt;height:258pt"> <v:imagedata src="file:///C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\msohtml1\03\clip_image005.png" mce_src="file:///C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\msohtml1\03\clip_image005.png" o:title="1"/> </v:shape><![endif]--><!-- [if !vml]--><!-- [endif]-->

< class name = "hibernate.hierarchical.BillingDetails" table = "BillingDetails" >

< joined-subclass name = "hibernate.hierarchical.CreditCard" table = "CREDIT_CARD" >

<!-- 通过 key 指定的字段将父表和子表关联。 CREDIT_CARD_ID 即使子表的主键同时也是父表的外键 -->

           < key column = "CREDIT_CARD_ID" />

           < property name = "number" column = "NUMBER" />

           < property name = "expMonth" column = "EXP_MONTH" />

           < property name = "expYear" column = "EXP_YEAR" />

       </ joined-subclass >

       < joined-subclass name = "hibernate.hierarchical.BankAccount" table = "BANK_ACCOUNT" >

           < key column = "BANK_ACCOUNT_ID" />

           <