ack.ejbgrpx~4~

大型EJB项目的代码,上传让大家看看,希望得到会员的资格,可以下到好的代码来学习,

        <table-name>esite_user_shoppingCart</table-name>
        <column-properties>
            <column-name>user</column-name>
        </column-properties>
        <column-properties>
            <column-name>shoppingCart_userid</column-name>
        </column-properties>
        <column-properties>
            <column-name>shoppingCart_inventoryid</column-name>
        </column-properties>
        <property>
            <prop-name>datasource</prop-name>
            <prop-type>String</prop-type>
            <prop-value>serial://datasources/shiponline</prop-value>
        </property>
    </table-properties>
    <assembly-descriptor />
</ejb-jar>]]></ejb-borland.xml>
  <ejb-modeler-schema.xml extralocation="" timestamp="1064577313333"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<schema-root-node name="DataSources" node-type="0" status="0">
  <schema-connection-node name="shiponline" node-type="4" status="0" catalog="null-object" connection-type="1" data-source-name="shiponline" driver="com.sybase.jdbc.SybDriver" file="null-object" password="" sql-schema="null-object" url="jdbc:sybase:Tds:fanhua02:5000/shiponline" use-data-source="true" username="sa" all-schemas="true" all-views="true">
    <schema-table-node name="INVENTORY" node-type="1" status="0" catalog="null-object" ref="false null com.sybase.jdbc.SybDriver jdbc:sybase:Tds:fanhua02:5000/shiponline" sql-schema="null-object">
      <schema-column-node name="ID" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="1" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="true" />
      <schema-column-node name="AUTHOR" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="2" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="BOOKTITLE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="3" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="PRICE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="8" ordinal="4" precision="-1" scale="-1" vendor-type-name="double precis" is-primary-key="false" />
      <schema-column-node name="INSTOCK" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="5" ordinal="5" precision="-1" scale="-1" vendor-type-name="smallint" is-primary-key="false" />
    </schema-table-node>
    <schema-table-node name="ORDERITEM" node-type="1" status="0" catalog="null-object" ref="false null com.sybase.jdbc.SybDriver jdbc:sybase:Tds:fanhua02:5000/shiponline" sql-schema="null-object">
      <schema-column-node name="ORDERID" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="1" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="true" />
      <schema-column-node name="INVENTORYID" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="2" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="true" />
      <schema-column-node name="QUANTITY" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="3" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
    </schema-table-node>
    <schema-table-node name="ORDERS" node-type="1" status="0" catalog="null-object" ref="false null com.sybase.jdbc.SybDriver jdbc:sybase:Tds:fanhua02:5000/shiponline" sql-schema="null-object">
      <schema-column-node name="ORDERSID" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="1" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="true" />
      <schema-column-node name="USERID" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="2" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
      <schema-column-node name="PROCESSED" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="3" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
    </schema-table-node>
    <schema-table-node name="SEQUENCE" node-type="1" status="0" catalog="null-object" ref="false null com.sybase.jdbc.SybDriver jdbc:sybase:Tds:fanhua02:5000/shiponline" sql-schema="null-object">
      <schema-column-node name="SEQUENCE_NAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="1" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="true" />
      <schema-column-node name="SEQUENCE_INDEX" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="4" ordinal="2" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
    </schema-table-node>
    <schema-table-node name="SHOPPINGCART" node-type="1" status="0" catalog="null-object" ref="false null com.sybase.jdbc.SybDriver jdbc:sybase:Tds:fanhua02:5000/shiponline" sql-schema="null-object">
      <schema-column-node name="USERID" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="1" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="true" />
      <schema-column-node name="INVENTORYID" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="2" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="true" />
      <schema-column-node name="QUANTITY" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="5" ordinal="3" precision="-1" scale="-1" vendor-type-name="smallint" is-primary-key="false" />
    </schema-table-node>
    <schema-table-node name="USERS" node-type="1" status="0" catalog="null-object" ref="false null com.sybase.jdbc.SybDriver jdbc:sybase:Tds:fanhua02:5000/shiponline" sql-schema="null-object">
      <schema-column-node name="ID" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="1" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
      <schema-column-node name="USERNAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="2" precision="10" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="FIRSTNAME" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="3" precision="10" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="LASTNAME" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="4" precision="10" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="ADDRESS" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="5" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="CITY" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="6" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="STATE" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="7" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="ZIP" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="8" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="PASSWORD" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="9" precision="10" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="LASTACCESSED" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="10" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
    </schema-table-node>
    <schema-table-node name="VAO_AGENTFEE" node-type="1" status="0" catalog="null-object" ref="false null com.sybase.jdbc.SybDriver jdbc:sybase:Tds:fanhua02:5000/shiponline" sql-schema="null-object">
      <schema-column-node name="VAO_AGENTFEE_ID" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="1" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="true" />
      <schema-column-node name="VAO_VSLENTRUST_ID" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="2" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
      <schema-column-node name="CURRENCY" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="1" ordinal="3" precision="3" scale="-1" vendor-type-name="char" is-primary-key="false" />
      <schema-column-node name="AMOUNT" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="2" ordinal="4" precision="12" scale="12" vendor-type-name="numeric" is-primary-key="false" />
      <schema-column-node name="BRANCHCODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="5" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="BRANCHNAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="6" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
    </schema-table-node>
    <schema-table-node name="VAO_ANCHORAREA" node-type="1" status="0" catalog="null-object" ref="false null com.sybase.jdbc.SybDriver jdbc:sybase:Tds:fanhua02:5000/shiponline" sql-schema="null-object">
      <schema-column-node name="BRANCHCODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="1" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="BRANCHNAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="2" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="VAO_ANCHORAREA_ID" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="3" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="true" />
      <schema-column-node name="WORKAREACODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="4" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="WORKAREANAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="5" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="PORTCODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="6" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="PORTCNAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="7" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="ANCHORCODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="8" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="ANCHORNAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="9" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="ANCHORLOACTION" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="10" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="ANCHORLONGGITUDE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="11" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="ANCHORLATITUDE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="12" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />