weblogic-cmp-rdbms-jar.xml

《Master EJB 第二版》

<!DOCTYPE weblogic-rdbms-jar PUBLIC 
 '-//BEA Systems, Inc.//DTD WebLogic 6.0.0 EJB RDBMS Persistence//EN'
 'http://www.bea.com/servers/wls600/dtd/weblogic-rdbms20-persistence-600.dtd'>

<weblogic-rdbms-jar>
<weblogic-rdbms-bean>
  <ejb-name>Customer</ejb-name>
  <data-source-name>ejbPool</data-source-name>
  <table-name>Customers</table-name>
  <field-map>
   <cmp-field>name</cmp-field>
   <dbms-column>name</dbms-column>
  </field-map>
  <field-map>
   <cmp-field>customerID</cmp-field>
   <dbms-column>customerId</dbms-column>
  </field-map>
  <field-map>
   <cmp-field>address</cmp-field>
   <dbms-column>address</dbms-column>
  </field-map>
  <field-map>
   <cmp-field>password</cmp-field>
   <dbms-column>password</dbms-column>
  </field-map>   
 </weblogic-rdbms-bean>
 

 <weblogic-rdbms-bean>
  <ejb-name>Product</ejb-name>
  <data-source-name>ejbPool</data-source-name>
  <table-name>Products</table-name>
  <field-map>
   <cmp-field>name</cmp-field>
   <dbms-column>name</dbms-column>
  </field-map>
  <field-map>
   <cmp-field>productID</cmp-field>
   <dbms-column>productId</dbms-column>
  </field-map>
  <field-map>
   <cmp-field>description</cmp-field>
   <dbms-column>description</dbms-column>
  </field-map>
  <field-map>
   <cmp-field>basePrice</cmp-field>
   <dbms-column>basePrice</dbms-column>
  </field-map>   
 </weblogic-rdbms-bean>
 
 <weblogic-rdbms-bean>
  <ejb-name>Order</ejb-name>
  <data-source-name>ejbPool</data-source-name>
  <table-name>Orders</table-name>
  <field-map>
   <cmp-field>orderID</cmp-field>
   <dbms-column>orderId</dbms-column>
  </field-map>
  <field-map>
   <cmp-field>orderDate</cmp-field>
   <dbms-column>orderDate</dbms-column>
  </field-map>
  <field-map>
   <cmp-field>status</cmp-field>
   <dbms-column>status</dbms-column>
  </field-map>
  <field-map>
   <cmp-field>subTotal</cmp-field>
   <dbms-column>orderSubTotal</dbms-column>
  </field-map>   
  <field-map>
   <cmp-field>taxes</cmp-field>
   <dbms-column>OrderTaxes</dbms-column>
  </field-map>      
 </weblogic-rdbms-bean>
 
 <weblogic-rdbms-bean>
  <ejb-name>OrderLineItem</ejb-name>
  <data-source-name>ejbPool</data-source-name>
  <table-name>OrderLineItems</table-name>
  <field-map>
   <cmp-field>orderLineItemID</cmp-field>
   <dbms-column>id</dbms-column>
  </field-map>   
  <field-map>
   <cmp-field>quantity</cmp-field>
   <dbms-column>quantity</dbms-column>
  </field-map>

  <field-map>
  <cmp-field>discount</cmp-field>
   <dbms-column>discount</dbms-column>
  </field-map>   
 </weblogic-rdbms-bean>
  
 <weblogic-rdbms-relation>
    <relation-name>Customer-Order</relation-name>
    <weblogic-relationship-role>
      <relationship-role-name>Orders-ArePlacedBy-Customer</relationship-role-name>
        <column-map>
          <foreign-key-column>customerId</foreign-key-column>
          <key-column>customerId</key-column>
        </column-map>
    </weblogic-relationship-role>
  </weblogic-rdbms-relation>
  
  <weblogic-rdbms-relation>
    <relation-name>Order-LineItems</relation-name>
    <weblogic-relationship-role>
      <relationship-role-name>LineItems-BelongTo-Order</relationship-role-name>
        <column-map>
          <foreign-key-column>orderId</foreign-key-column>
          <key-column>orderId</key-column>
        </column-map>
    </weblogic-relationship-role>
  </weblogic-rdbms-relation>

  
  <weblogic-rdbms-relation>
    <relation-name>LineItems-Product</relation-name>
    <weblogic-relationship-role>
      <relationship-role-name>LineItems-Use-Product</relationship-role-name>
        <column-map>
          <foreign-key-column>productId</foreign-key-column>
          <key-column>productId</key-column>
        </column-map>
    </weblogic-relationship-role>
  </weblogic-rdbms-relation>
</weblogic-rdbms-jar>