weblogic-cmp-rdbms-jar.xml

学生注册— 本模块允许新的学生创建和维护他们的帐户信息

<!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>UserEJB</ejb-name>
  <data-source-name>jdbc/styejbDB</data-source-name>
  <table-name>users</table-name>
  <field-map>
   <cmp-field>loginName</cmp-field>
   <dbms-column>login_name</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>StudentEJB</ejb-name>
  <data-source-name>jdbc/styejbDB</data-source-name>
  <table-name>students</table-name>
  <field-map>
   <cmp-field>studentId</cmp-field>
   <dbms-column>student_id</dbms-column>
  </field-map>
  <field-map>
   <cmp-field>firstName</cmp-field>
   <dbms-column>first_name</dbms-column>
  </field-map>
   <field-map>
   <cmp-field>lastName</cmp-field>
   <dbms-column>last_name</dbms-column>
  </field-map>
  <field-map>
   <cmp-field>address</cmp-field>
   <dbms-column>address</dbms-column>
  </field-map>
  <field-map>
   <cmp-field>emailAddress</cmp-field>
   <dbms-column>email_address</dbms-column>
  </field-map>
  </weblogic-rdbms-bean>

 <weblogic-rdbms-bean>
  <ejb-name>CourseEJB</ejb-name>
  <data-source-name>jdbc/styejbDB</data-source-name>
  <table-name>courses</table-name>
  <field-map>
   <cmp-field>courseId</cmp-field>
   <dbms-column>course_id</dbms-column>
  </field-map>
  <field-map>
   <cmp-field>name</cmp-field>
   <dbms-column>course_name</dbms-column>
  </field-map>
  <field-map>
   <cmp-field>fee</cmp-field>
   <dbms-column>fee</dbms-column>
  </field-map>   
 </weblogic-rdbms-bean>
 
 <weblogic-rdbms-bean>
  <ejb-name>OrderEJB</ejb-name>
  <data-source-name>jdbc/styejbDB</data-source-name>
  <table-name>orders</table-name>
  <field-map>
   <cmp-field>orderId</cmp-field>
   <dbms-column>order_id</dbms-column>
  </field-map>
  <field-map>
   <cmp-field>orderDate</cmp-field>
   <dbms-column>order_date</dbms-column>
  </field-map>
  <field-map>
   <cmp-field>status</cmp-field>
   <dbms-column>status</dbms-column>
  </field-map>
  <field-map>
   <cmp-field>amount</cmp-field>
   <dbms-column>amount</dbms-column>
  </field-map>   
 </weblogic-rdbms-bean>
 
 <weblogic-rdbms-bean>
  <ejb-name>OrderLineItemEJB</ejb-name>
  <data-source-name>jdbc/styejbDB</data-source-name>
  <table-name>order_line_items</table-name>
  <field-map>
   <cmp-field>orderLineItemId</cmp-field>
   <dbms-column>id</dbms-column>
  </field-map>   
  <field-map>
  <cmp-field>fee</cmp-field>
   <dbms-column>fee</dbms-column>
  </field-map>   
 </weblogic-rdbms-bean>

  <weblogic-rdbms-bean>
    <ejb-name>EnrollmentEJB</ejb-name>
    <data-source-name>jdbc/styejbDB</data-source-name>
    <table-name>enrollments</table-name>
    <field-map>
      <cmp-field>enrollmentId</cmp-field>
      <dbms-column>enrollment_id</dbms-column>
    </field-map>
  </weblogic-rdbms-bean>
  
 <weblogic-rdbms-relation>
    <relation-name>Student-Order</relation-name>
    <weblogic-relationship-role>
      <relationship-role-name>Orders-ArePlacedBy-Student</relationship-role-name>
        <column-map>
          <foreign-key-column>student_id</foreign-key-column>
          <key-column>student_id</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>order_id</foreign-key-column>
          <key-column>order_id</key-column>
        </column-map>
    </weblogic-relationship-role>
  </weblogic-rdbms-relation>

  
  <weblogic-rdbms-relation>
    <relation-name>LineItems-Course</relation-name>
    <weblogic-relationship-role>
      <relationship-role-name>LineItems-Use-Course</relationship-role-name>
        <column-map>
          <foreign-key-column>course_id</foreign-key-column>
          <key-column>course_id</key-column>
        </column-map>
    </weblogic-relationship-role>
  </weblogic-rdbms-relation>

  <weblogic-rdbms-relation>
    <relation-name>Student-Enrollments</relation-name>
      <weblogic-relationship-role>
        <relationship-role-name>
           Enrollment-of-student
        </relationship-role-name>
        <column-map>
            <foreign-key-column> student_id</foreign-key-column>
            <key-column> student_id </key-column>
        </column-map>
      </weblogic-relationship-role>
  </weblogic-rdbms-relation>

  <weblogic-rdbms-relation>
    <relation-name>Course-Enrollments</relation-name>
      <weblogic-relationship-role>
        <relationship-role-name>
           Enrollment-of-course
        </relationship-role-name>
        <column-map>
            <foreign-key-column>course_id</foreign-key-column>
            <key-column>course_id </key-column>
        </column-map>
      </weblogic-relationship-role>
  </weblogic-rdbms-relation>

</weblogic-rdbms-jar>