开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > 电子政务应用 > 查看源码
ack.ejbgrpx~4~
资源名称：shiponline.rar　[点击查看]
上传用户：jnhyscl
上传日期：2010-03-08
资源大小：345k
文件大小：134k
源码类别：

电子政务应用

开发平台：

Java

ack.ejbgrpx~4~：源码内容
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <descriptors>
  3.   <ejb-jar.xml extralocation="" timestamp="1064577313343"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
  4. <!DOCTYPE ejb-jar PUBLIC "-//Sun Microsystems, Inc.//DTD Enterprise JavaBeans 2.0//EN" "http://java.sun.com/dtd/ejb-jar_2_0.dtd">
  5. <ejb-jar>
  6.     <enterprise-beans>
  7.         <entity>
  8.             <display-name>EsiteUserShoppingCart</display-name>
  9.             <ejb-name>EsiteUserShoppingCart</ejb-name>
  10.             <local-home>shiponline.EsiteUserShoppingCartHome</local-home>
  11.             <local>shiponline.EsiteUserShoppingCart</local>
  12.             <ejb-class>shiponline.EsiteUserShoppingCartBean</ejb-class>
  13.             <persistence-type>Container</persistence-type>
  14.             <prim-key-class>shiponline.EsiteUserShoppingCartPK</prim-key-class>
  15.             <reentrant>False</reentrant>
  16.             <cmp-version>2.x</cmp-version>
  17.             <abstract-schema-name>EsiteUserShoppingCart</abstract-schema-name>
  18.             <cmp-field>
  19.                 <field-name>user</field-name>
  20.             </cmp-field>
  21.             <cmp-field>
  22.                 <field-name>shoppingCartUserid</field-name>
  23.             </cmp-field>
  24.             <cmp-field>
  25.                 <field-name>shoppingCartInventoryid</field-name>
  26.             </cmp-field>
  27.         </entity>
  28.     </enterprise-beans>
  29.     <assembly-descriptor>
  30.         <container-transaction>
  31.             <method>
  32.                 <ejb-name>EsiteUserShoppingCart</ejb-name>
  33.                 <method-name>*</method-name>
  34.             </method>
  35.             <trans-attribute>Required</trans-attribute>
  36.         </container-transaction>
  37.     </assembly-descriptor>
  38. </ejb-jar>]]></ejb-jar.xml>
  39.   <sybase-easerver-config.xml extralocation="" timestamp="1064576913107"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
  40. <!DOCTYPE sybase-easerver-config SYSTEM "http://download.sybase.com/specifications/xsd/sybase-easerver-config_1_0.dtd">
  41. <sybase-easerver-config>
  42.   <configure type="update" entity="Component:ack/EsiteUserShoppingCart">
  43.     <property name="com.sybase.jaguar.component.bind.naming" value="EsiteUserShoppingCart" />
  44.     <property name="com.sybase.jaguar.component.storage" value="CtsComponents/JdbcStorage(cache=shiponline,table=map:&quot;esite_user_shoppingCart&quot;)" />
  45.     <property name="mapField:user" value="user" />
  46.     <property name="mapField:shoppingCartUserid" value="shoppingCart_userid" />
  47.     <property name="mapField:shoppingCartInventoryid" value="shoppingCart_inventoryid" />
  48.   </configure>
  49. </sybase-easerver-config>
  50. ]]></sybase-easerver-config.xml>
  51.   <ejb-borland.xml extralocation="" timestamp="1064577313343"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
  52. <!DOCTYPE ejb-jar PUBLIC "-//Borland Software Corporation//DTD Enterprise JavaBeans 2.0//EN" "http://www.borland.com/devsupport/appserver/dtds/ejb-jar_2_0-borland.dtd">
  53. <ejb-jar>
  54.     <enterprise-beans>
  55.         <entity>
  56.             <ejb-name>EsiteUserShoppingCart</ejb-name>
  57.             <bean-local-home-name>EsiteUserShoppingCart</bean-local-home-name>
  58.             <cmp2-info>
  59.                 <cmp-field>
  60.                     <field-name>user</field-name>
  61.                     <column-name>user</column-name>
  62.                 </cmp-field>
  63.                 <cmp-field>
  64.                     <field-name>shoppingCartUserid</field-name>
  65.                     <column-name>shoppingCart_userid</column-name>
  66.                 </cmp-field>
  67.                 <cmp-field>
  68.                     <field-name>shoppingCartInventoryid</field-name>
  69.                     <column-name>shoppingCart_inventoryid</column-name>
  70.                 </cmp-field>
  71.                 <table-name>esite_user_shoppingCart</table-name>
  72.             </cmp2-info>
  73.             <property>
  74.                 <prop-name>ejb-designer-id</prop-name>
  75.                 <prop-type>String</prop-type>
  76.                 <prop-value>EsiteUserShoppingCart</prop-value>
  77.             </property>
  78.         </entity>
  79.     </enterprise-beans>
  80.     <table-properties>
  81.         <table-name>esite_user_shoppingCart</table-name>
  82.         <column-properties>
  83.             <column-name>user</column-name>
  84.         </column-properties>
  85.         <column-properties>
  86.             <column-name>shoppingCart_userid</column-name>
  87.         </column-properties>
  88.         <column-properties>
  89.             <column-name>shoppingCart_inventoryid</column-name>
  90.         </column-properties>
  91.         <property>
  92.             <prop-name>datasource</prop-name>
  93.             <prop-type>String</prop-type>
  94.             <prop-value>serial://datasources/shiponline</prop-value>
  95.         </property>
  96.     </table-properties>
  97.     <assembly-descriptor />
  98. </ejb-jar>]]></ejb-borland.xml>
  99.   <ejb-modeler-schema.xml extralocation="" timestamp="1064577313333"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
  100. <schema-root-node name="DataSources" node-type="0" status="0">
  101.   <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">
  102.     <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">
  103.       <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" />
  104.       <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" />
  105.       <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" />
  106.       <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" />
  107.       <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" />
  108.     </schema-table-node>
  109.     <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">
  110.       <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" />
  111.       <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" />
  112.       <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" />
  113.     </schema-table-node>
  114.     <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">
  115.       <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" />
  116.       <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" />
  117.       <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" />
  118.     </schema-table-node>
  119.     <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">
  120.       <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" />
  121.       <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" />
  122.     </schema-table-node>
  123.     <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">
  124.       <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" />
  125.       <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" />
  126.       <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" />
  127.     </schema-table-node>
  128.     <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">
  129.       <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" />
  130.       <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" />
  131.       <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" />
  132.       <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" />
  133.       <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" />
  134.       <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" />
  135.       <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" />
  136.       <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" />
  137.       <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" />
  138.       <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" />
  139.     </schema-table-node>
  140.     <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">
  141.       <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" />
  142.       <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" />
  143.       <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" />
  144.       <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" />
  145.       <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" />
  146.       <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" />
  147.     </schema-table-node>
  148.     <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">
  149.       <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" />
  150.       <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" />
  151.       <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" />
  152.       <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" />
  153.       <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" />
  154.       <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" />
  155.       <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" />
  156.       <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" />
  157.       <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" />
  158.       <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" />
  159.       <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" />
  160.       <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" />
  161.       <schema-column-node name="ANCHORWATER" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="2" ordinal="13" precision="6" scale="6" vendor-type-name="numeric" is-primary-key="false" />
  162.       <schema-column-node name="ANCHORBOTTOM" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="14" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  163.       <schema-column-node name="ANCHORTON" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="15" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  164.       <schema-column-node name="ANCHORUSAGE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="16" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  165.       <schema-column-node name="OPERATOR" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="17" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  166.       <schema-column-node name="OPERATETIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="18" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
  167.       <schema-column-node name="MODIFIER" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="19" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  168.       <schema-column-node name="MODIFIEDTIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="20" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
  169.     </schema-table-node>
  170.     <schema-table-node name="VAO_BERTH" 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">
  171.       <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" />
  172.       <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" />
  173.       <schema-column-node name="VAO_BERTH_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" />
  174.       <schema-column-node name="PORTCODE" 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" />
  175.       <schema-column-node name="PORTCNAME" 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" />
  176.       <schema-column-node name="WORKAREACODE" 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" />
  177.       <schema-column-node name="WORKAREANAME" 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" />
  178.       <schema-column-node name="OPTCOMPANYCODE" 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" />
  179.       <schema-column-node name="OPTCOMPANY" 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" />
  180.       <schema-column-node name="BERTHCODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="10" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  181.       <schema-column-node name="BERTHNAME" 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" />
  182.       <schema-column-node name="BERTHLONGGITUDE" 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" />
  183.       <schema-column-node name="BERTHLATITUDE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="13" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  184.       <schema-column-node name="BERTHLENGTH" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="2" ordinal="14" precision="6" scale="6" vendor-type-name="numeric" is-primary-key="false" />
  185.       <schema-column-node name="BERTHDEPTH" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="2" ordinal="15" precision="6" scale="6" vendor-type-name="numeric" is-primary-key="false" />
  186.       <schema-column-node name="BERTHTON" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="16" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  187.       <schema-column-node name="BERTHCARGO" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="17" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  188.       <schema-column-node name="BERTHAPPLIANCE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="18" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  189.       <schema-column-node name="REMARK" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="19" precision="255" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  190.       <schema-column-node name="OPERATOR" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="20" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  191.       <schema-column-node name="OPERATETIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="21" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
  192.       <schema-column-node name="MODIFIER" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="22" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  193.       <schema-column-node name="MODIFIEDTIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="23" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
  194.     </schema-table-node>
  195.     <schema-table-node name="VAO_BRANCH" 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">
  196.       <schema-column-node name="VAO_BRANCH_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" />
  197.       <schema-column-node name="BRANCHCODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="2" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  198.       <schema-column-node name="BRANCHNAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="3" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  199.       <schema-column-node name="PORTCODE" 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" />
  200.       <schema-column-node name="PORTCNAME" 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" />
  201.     </schema-table-node>
  202.     <schema-table-node name="VAO_CARGOTYPE" 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">
  203.       <schema-column-node name="VAO_CARGOTYPE_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" />
  204.       <schema-column-node name="CARGOTYPECODE" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="2" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  205.       <schema-column-node name="CARGOTYPE" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="3" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  206.       <schema-column-node name="OPERATOR" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="4" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  207.       <schema-column-node name="OPERATETIME" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="93" ordinal="5" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
  208.       <schema-column-node name="MODIFIER" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="6" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  209.       <schema-column-node name="MODIFIEDTIME" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="93" ordinal="7" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
  210.     </schema-table-node>
  211.     <schema-table-node name="VAO_CNTRTYPE" 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">
  212.       <schema-column-node name="VAO_CNTRTYPE_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" />
  213.       <schema-column-node name="CNTRTYPECODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="1" ordinal="2" precision="2" scale="-1" vendor-type-name="char" is-primary-key="false" />
  214.       <schema-column-node name="CNTRTYPE" 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" />
  215.       <schema-column-node name="OPERATOR" 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" />
  216.       <schema-column-node name="OPERATETIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="5" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
  217.       <schema-column-node name="MODIFIER" 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" />
  218.       <schema-column-node name="MODIFIEDTIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="7" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
  219.     </schema-table-node>
  220.     <schema-table-node name="VAO_ENTRCONTACT" 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">
  221.       <schema-column-node name="VAO_ENTRCONTACT_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" />
  222.       <schema-column-node name="VAO_ENTRUSTER_ID" 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" />
  223.       <schema-column-node name="CURRENTMARK" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="1" ordinal="3" precision="1" scale="-1" vendor-type-name="char" is-primary-key="false" />
  224.       <schema-column-node name="CONTACTOR" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="4" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  225.       <schema-column-node name="GENDER" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="1" ordinal="5" precision="1" scale="-1" vendor-type-name="char" is-primary-key="false" />
  226.       <schema-column-node name="DEPARTMENT" 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" />
  227.       <schema-column-node name="JOBPOST" 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" />
  228.       <schema-column-node name="TITLE" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="8" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  229.       <schema-column-node name="POSITION" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="9" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  230.       <schema-column-node name="AGE" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="1" ordinal="10" precision="3" scale="-1" vendor-type-name="char" is-primary-key="false" />
  231.       <schema-column-node name="EFFECTDATE" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="1" ordinal="11" precision="8" scale="-1" vendor-type-name="char" is-primary-key="false" />
  232.       <schema-column-node name="EXPIREDATE" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="1" ordinal="12" precision="8" scale="-1" vendor-type-name="char" is-primary-key="false" />
  233.       <schema-column-node name="POSTALCODE" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="1" ordinal="13" precision="10" scale="-1" vendor-type-name="char" is-primary-key="false" />
  234.       <schema-column-node name="TELEX" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="14" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  235.       <schema-column-node name="TELEPHONE" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="15" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  236.       <schema-column-node name="EMAIL" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="16" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  237.       <schema-column-node name="FAX" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="17" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  238.       <schema-column-node name="OPERATOR" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="18" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  239.       <schema-column-node name="OPERATETIME" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="93" ordinal="19" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
  240.       <schema-column-node name="MODIFIER" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="20" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  241.       <schema-column-node name="MODIFIEDTIME" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="93" ordinal="21" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
  242.       <schema-column-node name="BRANCHCODE" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="22" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  243.       <schema-column-node name="BRANCHNAME" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="23" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  244.     </schema-table-node>
  245.     <schema-table-node name="VAO_ENTRUSTER" 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">
  246.       <schema-column-node name="VAO_ENTRUSTER_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" />
  247.       <schema-column-node name="BRANCHCODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="2" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  248.       <schema-column-node name="BRANCHNAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="3" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  249.       <schema-column-node name="ENTRUSTERCODE" 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" />
  250.       <schema-column-node name="MEMORYCODE" 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" />
  251.       <schema-column-node name="EABBR" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="6" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  252.       <schema-column-node name="CABBR" 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" />
  253.       <schema-column-node name="ENAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="8" precision="255" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  254.       <schema-column-node name="CNAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="9" precision="255" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  255.       <schema-column-node name="DISTRICT" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="10" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  256.       <schema-column-node name="ADDRESS" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="11" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  257.       <schema-column-node name="TELEX" 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" />
  258.       <schema-column-node name="EMAIL" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="13" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  259.       <schema-column-node name="POSTALCODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="1" ordinal="14" precision="10" scale="-1" vendor-type-name="char" is-primary-key="false" />
  260.       <schema-column-node name="TELEPHONE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="15" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  261.       <schema-column-node name="FAX" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="16" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  262.       <schema-column-node name="OPERATOR" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="17" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  263.       <schema-column-node name="OPERATETIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="18" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
  264.       <schema-column-node name="MODIFIER" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="19" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  265.       <schema-column-node name="MODIFIEDTIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="20" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
  266.     </schema-table-node>
  267.     <schema-table-node name="VAO_FUNCTION" 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">
  268.       <schema-column-node name="VAO_FUNCTION_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" />
  269.       <schema-column-node name="FUNCTIONCODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="2" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  270.       <schema-column-node name="FUNCTIONNAME" 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" />
  271.       <schema-column-node name="FUNCTIONSORT" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="4" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
  272.       <schema-column-node name="FUNCTIONGROUP" 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" />
  273.       <schema-column-node name="FUNCTIONURL" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="6" precision="150" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  274.       <schema-column-node name="ISSYSTEM" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="1" ordinal="7" precision="1" scale="-1" vendor-type-name="char" is-primary-key="false" />
  275.     </schema-table-node>
  276.     <schema-table-node name="VAO_LINE" 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">
  277.       <schema-column-node name="VAO_LINE_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" />
  278.       <schema-column-node name="LINECODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="2" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  279.       <schema-column-node name="LINENAME" 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" />
  280.       <schema-column-node name="OPERATOR" 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" />
  281.       <schema-column-node name="OPERATETIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="5" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
  282.       <schema-column-node name="MODIFIER" 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" />
  283.       <schema-column-node name="MODIFIEDTIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="7" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
  284.     </schema-table-node>
  285.     <schema-table-node name="VAO_NATION" 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">
  286.       <schema-column-node name="VAO_NATION_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" />
  287.       <schema-column-node name="NATIONCODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="1" ordinal="2" precision="3" scale="-1" vendor-type-name="char" is-primary-key="false" />
  288.       <schema-column-node name="ENAME" 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" />
  289.       <schema-column-node name="CNAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="4" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  290.       <schema-column-node name="OPERATOR" 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" />
  291.       <schema-column-node name="OPERATETIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="6" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
  292.       <schema-column-node name="MODIFIER" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="7" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  293.       <schema-column-node name="MODIFIEDTIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="8" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
  294.     </schema-table-node>
  295.     <schema-table-node name="VAO_OPERATOR" 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">
  296.       <schema-column-node name="VAO_OPERATOR_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" />
  297.       <schema-column-node name="BRANCHCODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="2" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  298.       <schema-column-node name="BRANCHNAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="3" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  299.       <schema-column-node name="OPERATORCODE" 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" />
  300.       <schema-column-node name="NAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="1" ordinal="5" precision="10" scale="-1" vendor-type-name="char" is-primary-key="false" />
  301.       <schema-column-node name="DEPARTMENT" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="6" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  302.       <schema-column-node name="GENDER" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="1" ordinal="7" precision="2" scale="-1" vendor-type-name="char" is-primary-key="false" />
  303.       <schema-column-node name="AGE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="8" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
  304.       <schema-column-node name="RANK" 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" />
  305.       <schema-column-node name="CONTACTWAY" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="10" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  306.       <schema-column-node name="RESUME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="11" precision="255" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  307.       <schema-column-node name="OPERATOR" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="12" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  308.       <schema-column-node name="OPERATETIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="13" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
  309.       <schema-column-node name="MODIFIER" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="14" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  310.       <schema-column-node name="MODIFIEDTIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="15" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
  311.     </schema-table-node>
  312.     <schema-table-node name="VAO_PORT" 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">
  313.       <schema-column-node name="PORTCODE" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="1" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  314.       <schema-column-node name="CNAME" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="2" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  315.       <schema-column-node name="ENAME" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="3" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  316.       <schema-column-node name="NATIONCODE" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="1" ordinal="4" precision="3" scale="-1" vendor-type-name="char" is-primary-key="false" />
  317.       <schema-column-node name="NATIONNAME" 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" />
  318.       <schema-column-node name="OPERATOR" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="6" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  319.       <schema-column-node name="OPERATETIME" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="93" ordinal="7" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
  320.       <schema-column-node name="MODIFIER" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="8" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  321.       <schema-column-node name="MODIFIEDTIME" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="93" ordinal="9" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
  322.       <schema-column-node name="VAO_PORT_ID" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="4" ordinal="10" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="true" />
  323.     </schema-table-node>
  324.     <schema-table-node name="VAO_POSALLOCATE" 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">
  325.       <schema-column-node name="VAO_POSALLOCATE_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" />
  326.       <schema-column-node name="VAO_POSITION_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" />
  327.       <schema-column-node name="VAO_OPERATOR_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="false" />
  328.       <schema-column-node name="BRANCHCODE" 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" />
  329.       <schema-column-node name="BRANCHNAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="5" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  330.     </schema-table-node>
  331.     <schema-table-node name="VAO_POSITION" 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">
  332.       <schema-column-node name="VAO_POSITION_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" />
  333.       <schema-column-node name="BRANCHCODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="2" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  334.       <schema-column-node name="BRANCHNAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="3" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  335.       <schema-column-node name="POSITIONCODE" 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" />
  336.       <schema-column-node name="POSITION" 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" />
  337.       <schema-column-node name="POSITIONDESCRIPT" 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" />
  338.       <schema-column-node name="OPERATOR" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="7" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  339.       <schema-column-node name="OPERATETIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="8" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
  340.       <schema-column-node name="MODIFIER" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="9" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  341.       <schema-column-node name="MODIFIEDTIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="10" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
  342.     </schema-table-node>
  343.     <schema-table-node name="VAO_PRIVILEGE" 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">
  344.       <schema-column-node name="VAO_PRIVILEGE_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" />
  345.       <schema-column-node name="VAO_FUNCTION_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" />
  346.       <schema-column-node name="VAO_SYSROLE_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="false" />
  347.     </schema-table-node>
  348.     <schema-table-node name="VAO_SYSROLE" 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">
  349.       <schema-column-node name="VAO_SYSROLE_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" />
  350.       <schema-column-node name="ROLECODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="2" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  351.       <schema-column-node name="SYSROLE" 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" />
  352.       <schema-column-node name="ROLEDESCRIPT" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="4" precision="255" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  353.     </schema-table-node>
  354.     <schema-table-node name="VAO_SYSUSER" 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">
  355.       <schema-column-node name="VAO_SYSUSER_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" />
  356.       <schema-column-node name="USERCODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="2" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  357.       <schema-column-node name="USERNAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="3" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  358.       <schema-column-node name="PASSWORD" 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" />
  359.       <schema-column-node name="ISUSABLE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="1" ordinal="5" precision="1" scale="-1" vendor-type-name="char" is-primary-key="false" />
  360.       <schema-column-node name="ISREGISTER" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="1" ordinal="6" precision="1" scale="-1" vendor-type-name="char" is-primary-key="false" />
  361.       <schema-column-node name="BRANCHCODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="7" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  362.       <schema-column-node name="BRANCHNAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="8" precision="70" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  363.       <schema-column-node name="DUTY" 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" />
  364.       <schema-column-node name="DEPARTMENT" 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" />
  365.       <schema-column-node name="TELEX" 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" />
  366.       <schema-column-node name="TELEPHONE" 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" />
  367.       <schema-column-node name="EMAIL" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="13" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  368.       <schema-column-node name="FAX" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="14" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  369.       <schema-column-node name="OPERATOR" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="15" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  370.       <schema-column-node name="OPERATETIME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="93" ordinal="16" precision="-1" scale="-1" vendor-type-name="datetime" is-primary-key="false" />
  371.     </schema-table-node>
  372.     <schema-table-node name="VAO_THISPORTDETAIL" 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">
  373.       <schema-column-node name="VAO_THISPORTDETAIL" 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" />
  374.       <schema-column-node name="PORTCODE" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="2" precision="17" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  375.       <schema-column-node name="PORTCNAME" 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" />
  376.       <schema-column-node name="PORTENAME" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="4" precision="35" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
  377.       <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" />