jbosscmp-jdbc.xml

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

<?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:/DefaultDS</datasource>
      <datasource-mapping>Hypersonic SQL</datasource-mapping>
      <create-table>false</create-table>
      <remove-table>false</remove-table>
      <pk-constraint>true</pk-constraint>
      <preferred-relation-mapping>foreign-key</preferred-relation-mapping>
   </defaults>

   <enterprise-beans>

      <entity>
         <ejb-name>UserEJB</ejb-name>
         <table-name>users</table-name>
         <cmp-field>
            <field-name>loginName</field-name>
            <column-name>login_name</column-name>
         </cmp-field>
         <cmp-field>
            <field-name>password</field-name>
            <column-name>password</column-name>
         </cmp-field>
      </entity>

      <entity>
         <ejb-name>StudentEJB</ejb-name>
         <table-name>students</table-name>
         <cmp-field>
            <field-name>studentId</field-name>
            <column-name>student_id</column-name>
         </cmp-field>
         <cmp-field>
            <field-name>firstName</field-name>
            <column-name>first_name</column-name>
         </cmp-field>
         <cmp-field>
            <field-name>lastName</field-name>
            <column-name>last_name</column-name>
         </cmp-field>
         <cmp-field>
            <field-name>address</field-name>
            <column-name>address</column-name>
         </cmp-field>
         <cmp-field>
            <field-name>emailAddress</field-name>
            <column-name>email_address</column-name>
         </cmp-field>
      </entity>

      <entity>
         <ejb-name>CourseEJB</ejb-name>
         <table-name>courses</table-name>
         <cmp-field>
            <field-name>courseId</field-name>
            <column-name>course_id</column-name>
         </cmp-field>
         <cmp-field>
            <field-name>name</field-name>
            <column-name>course_name</column-name>
         </cmp-field>
         <cmp-field>
            <field-name>fee</field-name>
            <column-name>fee</column-name>
         </cmp-field>
      </entity>

      <entity>
         <ejb-name>OrderEJB</ejb-name>
         <table-name>orders</table-name>
         <cmp-field>
            <field-name>orderId</field-name>
            <column-name>order_id</column-name>
         </cmp-field>
         <cmp-field>
            <field-name>orderDate</field-name>
            <column-name>order_date</column-name>
         </cmp-field>
         <cmp-field>
            <field-name>status</field-name>
            <column-name>status</column-name>
         </cmp-field>
         <cmp-field>
            <field-name>amount</field-name>
            <column-name>amount</column-name>
         </cmp-field>
      </entity>

      <entity>
         <ejb-name>OrderLineItemEJB</ejb-name>
         <table-name>order_line_items</table-name>
         <cmp-field>
            <field-name>orderLineItemId</field-name>
            <column-name>id</column-name>
         </cmp-field>
         <cmp-field>
            <field-name>fee</field-name>
            <column-name>fee</column-name>
         </cmp-field>
      </entity>

      <entity>
         <ejb-name>EnrollmentEJB</ejb-name>
         <table-name>enrollments</table-name>
         <cmp-field>
            <field-name>enrollmentId</field-name>
            <column-name>enrollment_id</column-name>
         </cmp-field>
      </entity>

   </enterprise-beans>

   <relationships>

      <ejb-relation>
         <ejb-relation-name>Student-Order</ejb-relation-name>
         <foreign-key-mapping/>
         <ejb-relationship-role> 
<ejb-relationship-role-name>Student-Places-Orders</ejb-relationship-role-name>
            <key-fields>
               <key-field>
                  <field-name>studentId</field-name>
                  <column-name>student_id</column-name>
               </key-field>
            </key-fields>
         </ejb-relationship-role> 
         <ejb-relationship-role> 
<ejb-relationship-role-name>Orders-ArePlacedBy-Student</ejb-relationship-role-name>
            <key-fields/>
         </ejb-relationship-role> 
      </ejb-relation> 

      <ejb-relation>
         <ejb-relation-name>Order-LineItems</ejb-relation-name>
         <foreign-key-mapping/>
         <ejb-relationship-role> 
<ejb-relationship-role-name>Order-Has-LineItems</ejb-relationship-role-name>
            <key-fields>
               <key-field>
                  <field-name>orderId</field-name>
                  <column-name>order_id</column-name>
               </key-field>
            </key-fields>
         </ejb-relationship-role> 
         <ejb-relationship-role> 
<ejb-relationship-role-name>LineItems-BelongTo-Order</ejb-relationship-role-name>
            <key-fields/>
         </ejb-relationship-role> 
      </ejb-relation> 

      <ejb-relation>
         <ejb-relation-name>LineItems-Course</ejb-relation-name>
         <foreign-key-mapping/>
         <ejb-relationship-role> 
<ejb-relationship-role-name>Course-IsUsedBy-LineItems</ejb-relationship-role-name>
            <key-fields>
               <key-field>
                  <field-name>courseId</field-name>
                  <column-name>course_id</column-name>
               </key-field>
            </key-fields>
         </ejb-relationship-role> 
         <ejb-relationship-role> 
<ejb-relationship-role-name>LineItems-Use-Course</ejb-relationship-role-name>
            <key-fields/>
         </ejb-relationship-role> 
      </ejb-relation> 

      <ejb-relation>
         <ejb-relation-name>Student-Enrollments</ejb-relation-name>
         <foreign-key-mapping/>
         <ejb-relationship-role> 
<ejb-relationship-role-name>Student-has-enrollments</ejb-relationship-role-name>
            <key-fields>
               <key-field>
                  <field-name>studentId</field-name>
                  <column-name>student_id</column-name>
               </key-field>
            </key-fields>
         </ejb-relationship-role> 
         <ejb-relationship-role> 
<ejb-relationship-role-name>Enrollment-of-student</ejb-relationship-role-name>
            <key-fields/>
         </ejb-relationship-role> 
      </ejb-relation> 

      <ejb-relation>
         <ejb-relation-name>Course-Enrollments</ejb-relation-name>
         <foreign-key-mapping/>
         <ejb-relationship-role> 
<ejb-relationship-role-name>Course-has-enrollments</ejb-relationship-role-name>
            <key-fields>
               <key-field>
                  <field-name>courseId</field-name>
                  <column-name>course_id</column-name>
               </key-field>
            </key-fields>
         </ejb-relationship-role> 
         <ejb-relationship-role> 
<ejb-relationship-role-name>Enrollment-of-course</ejb-relationship-role-name>
            <key-fields/>
         </ejb-relationship-role> 
      </ejb-relation> 

   </relationships>

</jbosscmp-jdbc>