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 startwith 100000 incrementby 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