ejb-modeler-schema.xml~2~

网上银行系统 该系统是一个B/S结构的系统； 该系统采用J2EE技术架构（Struts+EJB） 该系统数据库为Oracle9i 该系统的应用服务器为Weblogic8

<?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="oracle:thin:@192.168.0.15:1521:lmedu" driver="oracle.jdbc.driver.OracleDriver" file="null-object" password="zjw" sql-schema="null-object" url="jdbc:oracle:thin:@192.168.0.15:1521:lmedu" use-data-source="true" username="zjw" all-schemas="true" all-views="false" extended-properties="">
    <schema-table-node name="ACCOUNT" node-type="1" status="0" catalog="null-object" ref="false null oracle.jdbc.driver.OracleDriver jdbc:oracle:thin:@localhost:1521:mytestdb" sql-schema="SCOTT">
      <schema-column-node name="ID" 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="VARCHAR2" is-primary-key="true" />
      <schema-column-node name="NAME" 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="VARCHAR2" is-primary-key="false" />
      <schema-column-node name="IDENTITYCARD" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="3" precision="50" scale="-1" vendor-type-name="VARCHAR2" is-primary-key="false" />
      <schema-column-node name="OPENBANK" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="12" ordinal="4" precision="100" scale="-1" vendor-type-name="VARCHAR2" 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="5" precision="50" scale="-1" vendor-type-name="VARCHAR2" is-primary-key="false" />
      <schema-column-node name="BALANCE" node-type="2" status="0" col-default="0.00 " is-nullable="NO" java-sql-type="3" ordinal="6" precision="10" scale="0" vendor-type-name="NUMBER" is-primary-key="false" />
      <schema-column-node name="OPENDATE" 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="DATE" is-primary-key="false" />
      <schema-column-node name="STATUS" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="1" ordinal="8" precision="1" scale="-1" vendor-type-name="CHAR" is-primary-key="false" />
    </schema-table-node>
    <schema-table-node name="BONUS" node-type="1" status="0" catalog="null-object" ref="false null oracle.jdbc.driver.OracleDriver jdbc:oracle:thin:@localhost:1521:mytestdb" sql-schema="SCOTT">
      <schema-column-node name="ENAME" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="1" precision="10" scale="-1" vendor-type-name="VARCHAR2" is-primary-key="false" />
      <schema-column-node name="JOB" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="2" precision="9" scale="-1" vendor-type-name="VARCHAR2" is-primary-key="false" />
      <schema-column-node name="SAL" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="3" ordinal="3" precision="22" scale="0" vendor-type-name="NUMBER" is-primary-key="false" />
      <schema-column-node name="COMM" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="3" ordinal="4" precision="22" scale="0" vendor-type-name="NUMBER" is-primary-key="false" />
    </schema-table-node>
    <schema-table-node name="DEPT" node-type="1" status="0" catalog="null-object" ref="false null oracle.jdbc.driver.OracleDriver jdbc:oracle:thin:@localhost:1521:mytestdb" sql-schema="SCOTT">
      <schema-column-node name="DEPTNO" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="3" ordinal="1" precision="2" scale="0" vendor-type-name="NUMBER" is-primary-key="true" />
      <schema-column-node name="DNAME" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="2" precision="14" scale="-1" vendor-type-name="VARCHAR2" is-primary-key="false" />
      <schema-column-node name="LOC" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="3" precision="13" scale="-1" vendor-type-name="VARCHAR2" is-primary-key="false" />
    </schema-table-node>
    <schema-table-node name="EMP" node-type="1" status="0" catalog="null-object" ref="false null oracle.jdbc.driver.OracleDriver jdbc:oracle:thin:@localhost:1521:mytestdb" sql-schema="SCOTT">
      <schema-column-node name="EMPNO" node-type="2" status="0" col-default="null-object" is-nullable="NO" java-sql-type="3" ordinal="1" precision="4" scale="0" vendor-type-name="NUMBER" is-primary-key="true" />
      <schema-column-node name="ENAME" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="2" precision="10" scale="-1" vendor-type-name="VARCHAR2" is-primary-key="false" />
      <schema-column-node name="JOB" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="12" ordinal="3" precision="9" scale="-1" vendor-type-name="VARCHAR2" is-primary-key="false" />
      <schema-column-node name="MGR" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="3" ordinal="4" precision="4" scale="0" vendor-type-name="NUMBER" is-primary-key="false" />
      <schema-column-node name="HIREDATE" 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="DATE" is-primary-key="false" />
      <schema-column-node name="SAL" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="3" ordinal="6" precision="7" scale="0" vendor-type-name="NUMBER" is-primary-key="false" />
      <schema-column-node name="COMM" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="3" ordinal="7" precision="7" scale="0" vendor-type-name="NUMBER" is-primary-key="false" />
      <schema-column-node name="DEPTNO" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="3" ordinal="8" precision="2" scale="0" vendor-type-name="NUMBER" is-primary-key="false" />
    </schema-table-node>
    <schema-table-node name="SALGRADE" node-type="1" status="0" catalog="null-object" ref="false null oracle.jdbc.driver.OracleDriver jdbc:oracle:thin:@localhost:1521:mytestdb" sql-schema="SCOTT">
      <schema-column-node name="GRADE" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="3" ordinal="1" precision="22" scale="0" vendor-type-name="NUMBER" is-primary-key="false" />
      <schema-column-node name="LOSAL" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="3" ordinal="2" precision="22" scale="0" vendor-type-name="NUMBER" is-primary-key="false" />
      <schema-column-node name="HISAL" node-type="2" status="0" col-default="null-object" is-nullable="YES" java-sql-type="3" ordinal="3" precision="22" scale="0" vendor-type-name="NUMBER" is-primary-key="false" />
    </schema-table-node>
  </schema-connection-node>
</schema-root-node>