jbosscmp-jdbc.xml

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

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE jbosscmp-jdbc PUBLIC "-//JBoss//DTD JBOSSCMP-JDBC 3.0//EN" "http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_3_0.dtd">

<jbosscmp-jdbc>
   <defaults>
     <datasource>java:/OracleDS</datasource>
     <datasource-mapping>Oracle8</datasource-mapping>
     <preferred-relation-mapping>foreign-key</preferred-relation-mapping>
   </defaults>

   <enterprise-beans>

     <!--
       To add beans that you have deployment descriptor info for, add
       a file to your XDoclet merge directory called jbosscmp-jdbc-beans.xml
       that contains the <entity></entity> markup for those beans.
     -->

      <entity>
         <ejb-name>Item</ejb-name>
         <table-name>Items</table-name>

         <cmp-field>
            <field-name>itemID</field-name>
            <column-name>ItemID</column-name>

        </cmp-field>
         <cmp-field>
            <field-name>supplierID</field-name>
            <column-name>SupplierID</column-name>

        </cmp-field>
         <cmp-field>
            <field-name>description</field-name>
            <column-name>Description</column-name>

        </cmp-field>
         <cmp-field>
            <field-name>quantity</field-name>
            <column-name>Quantity</column-name>

        </cmp-field>
         <cmp-field>
            <field-name>price</field-name>
            <column-name>Price</column-name>

        </cmp-field>

      </entity>

      <entity>
         <ejb-name>Supplier</ejb-name>
         <table-name>supplier</table-name>

         <cmp-field>
            <field-name>supplierid</field-name>
            <column-name>supplierid</column-name>

        </cmp-field>
         <cmp-field>
            <field-name>userid</field-name>
            <column-name>userid</column-name>

        </cmp-field>
         <cmp-field>
            <field-name>firstname</field-name>
            <column-name>firstname</column-name>

        </cmp-field>
         <cmp-field>
            <field-name>lastname</field-name>
            <column-name>lastname</column-name>

        </cmp-field>
         <cmp-field>
            <field-name>address</field-name>
            <column-name>address</column-name>

        </cmp-field>
         <cmp-field>
            <field-name>message</field-name>
            <column-name>message</column-name>

        </cmp-field>
         <cmp-field>
            <field-name>credit_limit</field-name>
            <column-name>credit_limit</column-name>

        </cmp-field>

      </entity>

   </enterprise-beans>

</jbosscmp-jdbc>