60f86a1d8869001b17ebfb69563bbe4c

来自「《精通SOA：基于服务总线的Struts+EJB+Web Service整合应用」· 代码 · 共 131 行

<?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>Account</ejb-name>
      <data-source-name>PLEASE_MODIFY_THIS</data-source-name>
      <table-name>account</table-name>
      <field-map>
         <cmp-field>accountID</cmp-field>
         <dbms-column>accountid</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>userID</cmp-field>
         <dbms-column>userid</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>registrationFee</cmp-field>
         <dbms-column>registrationFee</dbms-column>
      </field-map>

      <weblogic-query>
         <query-method>
            <method-name>findByUserID</method-name>
            <method-params>
               <method-param>java.lang.Integer</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM account as a where a.userID=?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findAll</method-name>
            <method-params>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM account as a]]></weblogic-ql>
      </weblogic-query>

   </weblogic-rdbms-bean>
   <weblogic-rdbms-bean>
      <ejb-name>SequenceNum</ejb-name>
      <data-source-name>PLEASE_MODIFY_THIS</data-source-name>
      <table-name>sequence_num</table-name>
      <field-map>
         <cmp-field>indexNum</cmp-field>
         <dbms-column>index_num</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>maxUserID</cmp-field>
         <dbms-column>max_userid</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>maxAccountID</cmp-field>
         <dbms-column>max_accountid</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 sequence_num as a]]></weblogic-ql>
      </weblogic-query>

   </weblogic-rdbms-bean>
   <weblogic-rdbms-bean>
      <ejb-name>User</ejb-name>
      <data-source-name>PLEASE_MODIFY_THIS</data-source-name>
      <table-name>user</table-name>
      <field-map>
         <cmp-field>userID</cmp-field>
         <dbms-column>userid</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>loginName</cmp-field>
         <dbms-column>login_name</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>name</cmp-field>
         <dbms-column>name</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>password</cmp-field>
         <dbms-column>password</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>phone</cmp-field>
         <dbms-column>phone</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>email</cmp-field>
         <dbms-column>email</dbms-column>
      </field-map>
      <field-map>
         <cmp-field>createTime</cmp-field>
         <dbms-column>createTime</dbms-column>
      </field-map>

      <weblogic-query>
         <query-method>
            <method-name>findByLoginName</method-name>
            <method-params>
               <method-param>java.lang.String</method-param>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM user as a where a.loginName=?1]]></weblogic-ql>
      </weblogic-query>
      <weblogic-query>
         <query-method>
            <method-name>findAll</method-name>
            <method-params>
            </method-params>
         </query-method>
         <weblogic-ql><![CDATA[SELECT OBJECT(a) FROM user as a]]></weblogic-ql>
      </weblogic-query>

   </weblogic-rdbms-bean>

     <!-- 
       To add weblogic relationships for beans not managed by XDoclet, add
       a file to your XDoclet merge directory called weblogic-cmp-rdbms-relationships.xml that contains
       the <weblogic-rdbms-relation></weblogic-rdbms-relation> markups for those beans.
     --> 

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

</weblogic-rdbms-jar>