weblogic-cmp-rdbms-jar.xml

使用J2EE编写的网上商店系统

<?xml version="1.0" encoding="UTF-8"?>

<!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>Item</ejb-name>
      <data-source-name>PLEASE_MODIFY_THIS</data-source-name>
      <table-name>Items</table-name>
      <field-map>
         <cmp-field>itemID</cmp-field>
         <dbms-column>ItemID</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>supplierID</cmp-field>
         <dbms-column>SupplierID</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>description</cmp-field>
         <dbms-column>Description</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>quantity</cmp-field>
         <dbms-column>Quantity</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>price</cmp-field>
         <dbms-column>Price</dbms-column>
      </field-map>

      <weblogic-query>
         <query-method>
            <method-name>findAll</method-name>
            <method-params>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM mySchema as a]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findBySupplierID</method-name>
            <method-params>
               <method-param>java.lang.String</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(b) FROM mySchema b where b.supplierID=?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findByOutOfStock</method-name>
            <method-params>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(c) FROM mySchema c where c.quantity=0]]></weblogic-ql>
      </weblogic-query>

   </weblogic-rdbms-bean>
   <weblogic-rdbms-bean>
      <ejb-name>Supplier</ejb-name>
      <data-source-name>PLEASE_MODIFY_THIS</data-source-name>
      <table-name>supplier</table-name>
      <field-map>
         <cmp-field>supplierid</cmp-field>
         <dbms-column>supplierid</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>userid</cmp-field>
         <dbms-column>userid</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>firstname</cmp-field>
         <dbms-column>firstname</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>lastname</cmp-field>
         <dbms-column>lastname</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>address</cmp-field>
         <dbms-column>address</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>message</cmp-field>
         <dbms-column>message</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>credit_limit</cmp-field>
         <dbms-column>credit_limit</dbms-column>
      </field-map>

      <weblogic-query>
         <query-method>
            <method-name>findAll</method-name>
            <method-params>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM mySupplier as a]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findUserID</method-name>
            <method-params>
               <method-param>java.lang.String</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(b) from mySupplier as b where b.userid=?1]]></weblogic-ql>
      </weblogic-query>

   </weblogic-rdbms-bean>

   <create-default-dbms-tables>False</create-default-dbms-tables>

</weblogic-rdbms-jar>