Hibernate表配置学习

 

1、单主键、没有外键的Hibernate配置实例

<hibernate-mapping>

    <class name="com.pms.bean.base.BadCodeBean" table="tbNC">

       <id name="badCode" column="NC_ID">

           <generator class="assigned"/>

       </id>

    <property name="desc" type="string"column="NC_DESC"></property>

    </class>

</hibernate-mapping>

 

2、单主键、有外键的Hibernate配置实例

<hibernate-mapping>

    <class name="com.pms.bean.base.ProjectBean" table="tbProject">

       <id name="prjname" column="PRJ_NAME" type="string">

           <generator class="assigned"></generator>

       </id>

<many-to-one name=”customerCode” class=”com.pms.bean.base.CustomerBean” outer-join=”ture”

      not-null=”true”   lazy=”false”>

    <column name=”PRJ_CU_CODE”></column>

</many-to-one>

</hibernate-mapping>

 

3、双主键、没有外键的Hibernate配置实例

<hibernate-mapping>

    <class name="com.pms.bean.base.LocationBean" table="tbLocation">

       <composite-id>

           <key-property name="lgort" column="LO_LGORT" type="string">

           <key-property name="werks" column="LO_WERKS" type="string">

       </composite-id>

    </class>

</hibernate-mapping>

4、双主键、有外键的Hibernate配置实例

<hibernate-mapping>

    <class name="com.pms.bean.base.DepartNcBean" table="tbNCDept">

       <composite-id>

           <key-property name="ncBean" column="NCD_ID " lazy="false">

<key-property name="deptDialogBean" column="NCD_DeptID " lazy="false">

       </composite-id>

<many-to-one name=”badType” class=”com.pms.bean.base.BadTypeBean” outer-join=”ture”

      not-null=”true”   lazy=”false”>

    <column name=”NCD_BadTypeCode”></column>

</many-to-one>

    </class>

</hibernate-mapping>

 

5、双主键中的两个主键都被作为外键被调用的Hibernate配置实例

详细举例讲解：例如工厂和生产调度员组合成双主键，现在有一个表里面有两个外键分别是工厂和生产调度员。

<hibernate-mapping>

<class name="com.pms.bean.base.prd.MaterielBean" table="tbMateriel">

       <id name="matnr" column="MA_MATNR" type="string" length="18">

           <generator class="assigned"/>

       </id>

       <property name="color" column="MA_COLOR" length="50"/>

<property name="werks" type="string" column="MA_WERKS" length="4"  insert="false" update="false"/>

<many-to-one name="dispatcherBean" class="com.pms.bean.base.prd.DispatcherBean"

outer-join="true" not-null="true" lazy="false">    

           <column name="MA_FEVOR"/>

           <column name="MA_WERKS "/>

       </many-to-one>

    </class>

</hibernate-mapping>

 

6、hibernate里面设置id自动增加避免并发后果

PLSql增加如下代码：

create sequence SEQ_tbSChecking start with 100000 increment by 1

minvalue 1 nomaxvalue nocache nocycle noorder;

(hibernate)xml文件中更改为：

<id name="id" column="SC_ID" type="java.lang.Integer" >

    <generator class="sequence">

        <param name="sequence">SEQ_tbSChecking</param>

    </generator>

</id>

 

说明:

以上文章转自百度文库http://wenku.baidu.com/view/e9f4a020dd36a32d73758149.html;

相关文章见博友:http://blog.csdn.net/lipingqingqing/article/details/6502362