ejb-modeler-schema.xml~5~

一个很不错的电子商务后台管理系统 这是一个电子商务网站的后台管理系统 要运行此系统必须具备以下条件 1.首先要把SNSQL文本中的SQL脚本确保在SQL Server中执行 2.包Se

<?xml version="1.0" encoding="UTF-8"?>
<schema-root-node name="DataSources" node-type="0" status="0">
  <schema-connection-node name="snshop" node-type="4" status="0" catalog="null-object" connection-type="1" data-source-name="shop" driver="weblogic.jdbc.sqlserver.SQLServerDriver" file="null-object" password="xian" sql-schema="null-object" url="jdbc:bea:sqlserver://localhost:1433" use-data-source="true" username="xian" all-schemas="true" all-views="true">
    <schema-table-node name="bigcatalog" node-type="1" status="0" catalog="null-object" ref="false null weblogic.jdbc.sqlserver.SQLServerDriver jdbc:bea:sqlserver://localhost:1433" sql-schema="dbo">
      <schema-column-node name="catalog" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="1" precision="20" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="order" 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-column-node name="price" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="6" ordinal="3" precision="-1" scale="-1" vendor-type-name="float" is-primary-key="false" />
    </schema-table-node>
    <schema-table-node name="brand" node-type="1" status="0" catalog="null-object" ref="false null weblogic.jdbc.sqlserver.SQLServerDriver jdbc:bea:sqlserver://localhost:1433" sql-schema="dbo">
      <schema-column-node name="arrange" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="4" ordinal="4" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
      <schema-column-node name="brandName" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="2" precision="50" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="isCommend" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="3" precision="50" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="sequecnse" 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-table-node>
    <schema-table-node name="city" node-type="1" status="0" catalog="null-object" ref="false null weblogic.jdbc.sqlserver.SQLServerDriver jdbc:bea:sqlserver://localhost:1433" sql-schema="dbo">
      <schema-column-node name="cid" 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="city" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="3" precision="50" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="cno" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="4" ordinal="4" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
      <schema-column-node name="corder" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="4" ordinal="5" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
      <schema-column-node name="sheng" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="2" precision="50" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
    </schema-table-node>
    <schema-table-node name="dtproperties" node-type="1" status="0" catalog="null-object" ref="false null weblogic.jdbc.sqlserver.SQLServerDriver jdbc:bea:sqlserver://localhost:1433" sql-schema="dbo">
      <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 identity" is-primary-key="true" />
      <schema-column-node name="lvalue" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="-4" ordinal="6" precision="-1" scale="-1" vendor-type-name="image" is-primary-key="false" />
      <schema-column-node name="objectid" 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-column-node name="property" node-type="2" status="0" col-default="null-object" is-nullable="NO " java-sql-type="12" ordinal="3" precision="64" scale="-1" vendor-type-name="varchar" is-primary-key="true" />
      <schema-column-node name="uvalue" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="5" precision="255" scale="-1" vendor-type-name="nvarchar" is-primary-key="false" />
      <schema-column-node name="value" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="4" precision="255" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="version" node-type="2" status="0" col-default="(0)" is-nullable="NO " java-sql-type="4" ordinal="7" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
    </schema-table-node>
    <schema-table-node name="manager" node-type="1" status="0" catalog="null-object" ref="false null weblogic.jdbc.sqlserver.SQLServerDriver jdbc:bea:sqlserver://localhost:1433" sql-schema="dbo">
      <schema-column-node name="admin" node-type="2" status="0" col-default="null-object" is-nullable="NO " java-sql-type="12" ordinal="1" precision="25" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="popedom" 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="pwd" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="2" precision="30" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
    </schema-table-node>
    <schema-table-node name="omit" node-type="1" status="0" catalog="null-object" ref="false null weblogic.jdbc.sqlserver.SQLServerDriver jdbc:bea:sqlserver://localhost:1433" sql-schema="dbo">
      <schema-column-node name="sid" 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="sname" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="1" ordinal="2" precision="10" scale="-1" vendor-type-name="char" is-primary-key="false" />
      <schema-column-node name="sno" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="4" ordinal="3" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
      <schema-column-node name="sorder" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="4" ordinal="4" precision="-1" scale="-1" vendor-type-name="int" is-primary-key="false" />
    </schema-table-node>
    <schema-table-node name="order" node-type="1" status="0" catalog="null-object" ref="false null weblogic.jdbc.sqlserver.SQLServerDriver jdbc:bea:sqlserver://localhost:1433" sql-schema="dbo">
      <schema-column-node name="accept" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="5" precision="30" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="estate" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="6" precision="50" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="mayment" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="4" precision="30" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="moneyName" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="3" precision="50" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <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="false" />