ejb-modeler-schema.xml~3~

一个使用EJB开发的真实项目

<?xml version="1.0" encoding="UTF-8"?>
<schema-root-node name="DataSources" node-type="0" status="0">
  <schema-connection-node name="DataSource" node-type="4" status="0" catalog="null-object" connection-type="1" data-source-name="" driver="weblogic.jdbc.mssqlserver4.Driver" file="null-object" password="" sql-schema="null-object" url="jdbc:weblogic:mssqlserver4:exitLeo@localhost:1433" use-data-source="true" username="sa" all-schemas="true" all-views="false" extended-properties="user=sa|password=">
    <schema-table-node name="admin_Info" node-type="1" status="0" catalog="null-object" ref="false null weblogic.jdbc.mssqlserver4.Driver jdbc:weblogic:mssqlserver4:exitLeo@localhost:1433" sql-schema="dbo">
      <schema-column-node name="adminCode" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="1" precision="50" scale="-1" vendor-type-name="varchar" is-primary-key="true" />
      <schema-column-node name="adminPW" 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.mssqlserver4.Driver jdbc:weblogic:mssqlserver4:exitLeo@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="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="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="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="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="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="gouWuChe_Info" node-type="1" status="0" catalog="null-object" ref="false null weblogic.jdbc.mssqlserver4.Driver jdbc:weblogic:mssqlserver4:exitLeo@localhost:1433" sql-schema="dbo">
      <schema-column-node name="dingDanHao" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="1" precision="50" scale="-1" vendor-type-name="varchar" is-primary-key="true" />
      <schema-column-node name="userCode" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="2" precision="50" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="number" 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="name" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="4" precision="50" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="model" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="5" precision="50" 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="YES" java-sql-type="12" ordinal="6" precision="50" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="count1" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="7" precision="50" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="zhiFu" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="8" precision="50" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
    </schema-table-node>
    <schema-table-node name="shouJi_Info" node-type="1" status="0" catalog="null-object" ref="false null weblogic.jdbc.mssqlserver4.Driver jdbc:weblogic:mssqlserver4:exitLeo@localhost:1433" sql-schema="dbo">
      <schema-column-node name="photo" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="1" precision="50" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="number" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="2" precision="50" scale="-1" vendor-type-name="varchar" is-primary-key="true" />
      <schema-column-node name="name" 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="model" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="4" precision="50" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="daXiao" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="5" precision="50" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="yanSe" 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="zhongLiang" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="7" precision="50" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="xiangXiJieShao" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="8" precision="50" 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="YES" java-sql-type="6" ordinal="9" precision="-1" scale="-1" vendor-type-name="float" is-primary-key="false" />
    </schema-table-node>
    <schema-table-node name="user_Info" node-type="1" status="0" catalog="null-object" ref="false null weblogic.jdbc.mssqlserver4.Driver jdbc:weblogic:mssqlserver4:exitLeo@localhost:1433" sql-schema="dbo">
      <schema-column-node name="userCode" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="1" precision="50" scale="-1" vendor-type-name="varchar" is-primary-key="true" />
      <schema-column-node name="userName" 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="userPW" 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="shenfenzheng" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="4" precision="50" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="telephone" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="5" precision="50" 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="6" precision="50" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="youZhengBianMa" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="7" precision="50" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
      <schema-column-node name="email" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="8" precision="50" scale="-1" vendor-type-name="varchar" is-primary-key="false" />
    </schema-table-node>
  </schema-connection-node>
</schema-root-node>