salesdb_1_app_location.tblxmi

一个简单的EJB实例.用DB2连接.JSP页面.很好用.供大家学习

<?xml version="1.0" encoding="UTF-8"?>
<RDBSchema:RDBTable xmi:version="2.0" xmlns:xmi="http://www.omg.org/XMI" xmlns:RDBSchema="RDBSchema.xmi" xmi:id="LOCATION" name="LOCATION" primaryKey="ZIPCODEPK">
  <database href="META-INF/backends/DB2UDBNT_V8_1/salesdb_1.dbxmi#salesdb"/>
  <schema href="META-INF/backends/DB2UDBNT_V8_1/salesdb_1_APP.schxmi#APP"/>
  <columns xmi:type="RDBSchema:RDBColumn" xmi:id="CITY" name="CITY">
    <type xmi:type="RDBSchema:SQLCharacterStringType" xmi:id="SQLCharacterStringType_1138282785265" characterSet="800" length="40">
      <originatingType xmi:type="RDBSchema:SQLCharacterStringType" href="DB2UDBNT_V8_Primitives.xmi#SQLCharacterStringType_3"/>
    </type>
  </columns>
  <columns xmi:type="RDBSchema:RDBColumn" xmi:id="STATE" name="STATE">
    <type xmi:type="RDBSchema:SQLCharacterStringType" xmi:id="SQLCharacterStringType_1138282785266" characterSet="800" length="2">
      <originatingType xmi:type="RDBSchema:SQLCharacterStringType" href="DB2UDBNT_V8_Primitives.xmi#SQLCharacterStringType_1"/>
    </type>
  </columns>
  <columns xmi:type="RDBSchema:RDBColumn" xmi:id="ZIPCODE" name="ZIPCODE">
    <type xmi:type="RDBSchema:SQLCharacterStringType" xmi:id="SQLCharacterStringType_1138282785267" characterSet="800" length="5">
      <originatingType xmi:type="RDBSchema:SQLCharacterStringType" href="DB2UDBNT_V8_Primitives.xmi#SQLCharacterStringType_1"/>
    </type>
  </columns>
  <columns xmi:type="RDBSchema:RDBColumn" xmi:id="AREACODE" name="AREACODE">
    <type xmi:type="RDBSchema:SQLCharacterStringType" xmi:id="SQLCharacterStringType_1138282785268" characterSet="800" length="3">
      <originatingType xmi:type="RDBSchema:SQLCharacterStringType" href="DB2UDBNT_V8_Primitives.xmi#SQLCharacterStringType_1"/>
    </type>
  </columns>
  <namedGroup xmi:type="RDBSchema:SQLReference" xmi:id="ZIPCODEPK" name="ZIPCODEPK" members="ZIPCODE" constraint="SQLConstraint_1138282785265">
    <referenceByKey href="META-INF/backends/DB2UDBNT_V8_1/salesdb_1_APP_PURCHASE.tblxmi#LOCATIONFK"/>
  </namedGroup>
  <constraints xmi:id="SQLConstraint_1138282785265" name="ZIPCODEPK" type="PRIMARYKEY" primaryKey="ZIPCODEPK"/>
</RDBSchema:RDBTable>