Java
JBuilder實務應用（17）
使用XML 模型元件
文／Dr. JBuilder


-----box-----
#程式1
<!ELEMENT request (req_name, parameter*)>
<!ELEMENT parameter (para_name, type, value)>
<!ELEMENT req_name (#PCDATA)>
<!ELEMENT para_name (#PCDATA)>
<!ELEMENT type (#PCDATA)>
<!ELEMENT value (#PCDATA)>
-----end-----


-----box-----
#程式2
<?xml version='1.0' ?>
<!DOCTYPE XMLToDBMS SYSTEM "xmldbms.dtd" >
<XMLToDBMS Version="1.0">
   <Options>
   </Options>
   <Maps>
      <ClassMap>
         <ElementType Name="request"/>
         <ToRootTable>
            <Table Name="request"/>
            <CandidateKey Generate="Yes">
               <Column Name="requestPK"/>
            </CandidateKey>
         </ToRootTable>
         <PropertyMap>
            <ElementType Name="req_name"/>
            <ToColumn>
               <Column Name="req_name"/>
            </ToColumn>
         </PropertyMap>
         <RelatedClass KeyInParentTable=
                      "Candidate">
            <ElementType Name="parameter"/>
            <CandidateKey Generate="Yes">
               <Column Name="requestPK"/>
            </CandidateKey>
            <ForeignKey>
               <Column Name="requestFK"/>
            </ForeignKey>
         </RelatedClass>
      </ClassMap>
      <ClassMap>
         <ElementType Name="parameter"/>
         <ToClassTable>
            <Table Name="parameter"/>
         </ToClassTable>
         <PropertyMap>
            <ElementType Name="para_name"/>
            <ToColumn>
               <Column Name="para_name"/>
            </ToColumn>
         </PropertyMap>
         <PropertyMap>
            <ElementType Name="type"/>
            <ToColumn>
               <Column Name="type"/>
            </ToColumn>
         </PropertyMap>
         <PropertyMap>
            <ElementType Name="value"/>
            <ToColumn>
               <Column Name="value"/>
            </ToColumn>
         </PropertyMap>
      </ClassMap>
   </Maps>
</XMLToDBMS>
-----end-----



-----box-----
#程式3
CREATE TABLE "request" (
      "req_name" VARCHAR(255), 
      "requestPK" INTEGER);
CREATE TABLE "parameter" (
      "para_name" VARCHAR(255), 
      "type" VARCHAR(255),
      "requestFK" INTEGER, 
      "value" VARCHAR(255));
CREATE TABLE XMLDBMSKey (HighKey Integer);
INSERT INTO XMLDBMSKey VALUES (0);
-----end-----



#程式4
<?xml version="1.0" encoding="UTF-8"?>
<!ELEMENT XmlEmployee (EmpNo, FirstName, 
  LastName, PhoneExt, 
  HireDate, DeptNo, 
  JobCode, JobGrade, 
  JobCountry, Salary, 
  FullName)>
<!ELEMENT DeptNo (#PCDATA)>
<!ELEMENT EmpNo (#PCDATA)>
<!ELEMENT FirstName (#PCDATA)>
<!ELEMENT FullName (#PCDATA)>
<!ELEMENT HireDate (#PCDATA)>
<!ELEMENT JobCode (#PCDATA)>
<!ELEMENT JobCountry (#PCDATA)>
<!ELEMENT JobGrade (#PCDATA)>
<!ELEMENT LastName (#PCDATA)>
<!ELEMENT PhoneExt (#PCDATA)>
<!ELEMENT Salary (#PCDATA)>
<!ELEMENT XmlEmployees (XmlEmployee+)>



#程式5
<?xml version="1.0"?>
<!DOCTYPE XmlEmployees SYSTEM 
                      "Employees.dtd">
<XmlEmployees> 
   <XmlEmployee>
      <EmpNo>2</EmpNo>
      <FirstName>Robert</FirstName>
      <LastName>Nelson</LastName>
      <PhoneExt>250</PhoneExt>
      <HireDate>1988-12-28</HireDate>
      <DeptNo>600</DeptNo>
      <JobCode>VP</JobCode>
      <JobGrade>2</JobGrade>
      <JobCountry>USA</JobCountry>
      <Salary>105900.000000</Salary>
      <FullName>Nelson, Robert</FullName>
   </XmlEmployee>
   <XmlEmployee>
      <EmpNo>4</EmpNo>
      <FirstName>Bruce</FirstName>
      <LastName>Young</LastName>
      <PhoneExt>233</PhoneExt>
      <HireDate>1988-12-28</HireDate>
      <DeptNo>621</DeptNo>
      <JobCode>Eng</JobCode>
      <JobGrade>2</JobGrade>
      <JobCountry>USA</JobCountry>
      <Salary>97500.000000</Salary>
      <FullName>Young, Bruce</FullName>
   </XmlEmployee>
   <XmlEmployee>
      <EmpNo>5</EmpNo>
      <FirstName>Kim</FirstName>
      <LastName>Lambert</LastName>
      <PhoneExt>22</PhoneExt>
      <HireDate>1989-02-06</HireDate>
      <DeptNo>130</DeptNo>
      <JobCode>Eng</JobCode>
      <JobGrade>2</JobGrade>
      <JobCountry>USA</JobCountry>
      <Salary>102750.000000</Salary>
      <FullName>Lambert, Kim</FullName>
   </XmlEmployee>
</XmlEmployees>



-----box-----
#程式6
1.	<?xml version='1.0' ?>
2.	<!DOCTYPE XMLToDBMS SYSTEM "xmldbms.dtd" >
3.	
4.	<XMLToDBMS Version="1.0">
5.	   <Options>
6.	   </Options>
7.	   <Maps>
8.	      <ClassMap>
9.	         <ElementType Name="XmlEmployee"/>
10.	         <ToClassTable>
11.	            <Table Name="XmlEmployee"/>
12.	         </ToClassTable>
13.	         <PropertyMap>
14.	            <ElementType Name="FullName"/>
15.	            <ToColumn>
16.	               <Column Name="FullName"/>
17.	            </ToColumn>
18.	         </PropertyMap>
19.	         <PropertyMap>
20.	            <ElementType Name="JobGrade"/>
21.	            <ToColumn>
22.	               <Column Name="JobGrade"/>
23.	            </ToColumn>
24.	         </PropertyMap>
25.	         <PropertyMap>
26.	            <ElementType Name="Salary"/>
27.	            <ToColumn>
28.	               <Column Name="Salary"/>
29.	            </ToColumn>
30.	         </PropertyMap>
31.	         <PropertyMap>
32.	            <ElementType Name="JobCode"/>
33.	            <ToColumn>
34.	               <Column Name="JobCode"/>
35.	            </ToColumn>
36.	         </PropertyMap>
37.	         <PropertyMap>
38.	            <ElementType Name="PhoneExt"/>
39.	            <ToColumn>
40.	               <Column Name="PhoneExt"/>
41.	            </ToColumn>
42.	         </PropertyMap>
43.	         <PropertyMap>
44.	            <ElementType Name="JobCountry"/>
45.	            <ToColumn>
46.	               <Column Name="JobCountry"/>
47.	            </ToColumn>
48.	         </PropertyMap>
49.	         <PropertyMap>
50.	            <ElementType Name="LastName"/>
51.	            <ToColumn>
52.	               <Column Name="LastName"/>
53.	            </ToColumn>
54.	         </PropertyMap>
55.	         <PropertyMap>
56.	            <ElementType Name="FirstName"/>
57.	            <ToColumn>
58.	               <Column Name="FirstName"/>
59.	            </ToColumn>
60.	         </PropertyMap>
61.	         <PropertyMap>
62.	            <ElementType Name="HireDate"/>
63.	            <ToColumn>
64.	               <Column Name="HireDate"/>
65.	            </ToColumn>
66.	         </PropertyMap>
67.	         <PropertyMap>
68.	            <ElementType Name="EmpNo"/>
69.	            <ToColumn>
70.	               <Column Name="EmpNo"/>
71.	            </ToColumn>
72.	         </PropertyMap>
73.	         <PropertyMap>
74.	            <ElementType Name="DeptNo"/>
75.	            <ToColumn>
76.	               <Column Name="DeptNo"/>
77.	            </ToColumn>
78.	         </PropertyMap>
79.	      </ClassMap>
80.	      <ClassMap>
81.	         <ElementType Name="XmlEmployees"/>
82.	         <ToRootTable>
83.	            <Table Name="XmlEmployees"/>
84.	            <CandidateKey Generate="Yes">
85.	             <Column Name="XmlEmployeesPK"/>
86.	            </CandidateKey>
87.	         </ToRootTable>
88.	         <RelatedClass KeyInParentTable=
                      "Candidate">
89.	          <ElementType Name="XmlEmployee"/>
90.	          <CandidateKey Generate="Yes">
91.	             <Column Name="XmlEmployeesPK"/>
92.	          </CandidateKey>
93.	          <ForeignKey>
94.	             <Column Name="XmlEmployeesFK"/>
95.	          </ForeignKey>
96.	         </RelatedClass>
97.	      </ClassMap>
98.	   </Maps>
99.	</XMLToDBMS>