| 摘要 |
Disclosed herein is a method of converting data of a database and creating an XML document. In the method, a source XML document has user-defined tags is designed. The source XML document is separated into an XML document for normal data conversion which is used when converting normal data, and an XML document for repetitive data conversion which is used when converting repetitive data. An SQL query statement for data to be converted in a DB is generated. The SQL query statement is executed on the DB and thereafter resulting data obtained as a result of executing the SQL query statement is stored in a storage sheet. The structural data of the source XML document is mapped to the resulting data stored in the storage sheet. A new XML document is created by replacing the structural data of the source XML document with the resulting data.
|
