Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes XML and Related Technologies and the fly likes XML & Databases Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Engineering » XML and Related Technologies
Bookmark "XML & Databases" Watch "XML & Databases" New topic
Author

XML & Databases

Nirmala Devi
Greenhorn

Joined: Jul 31, 2001
Posts: 3

I have a question related to displaying the Database records using XML. I had gone through the eleven rules for moving a relational database to XML by Kevin Williams. All the rules are clear. But when I try to create an XML to do this, I am confused.
Details�.
After explaining all the eleven rules, the author creates the following DTD.
<!ELEMENT SalesData (Invoice*, Customer*, Part*, MonthlyTotal*)>
<!ATTLIST SalesData
Status (NewVersion | UpdateVersion | CourtesyCopy) #REQUIRED>
<ELEMENT Invoice (LineItem*)>
<ATTLIST Invoice
InvoiceNumber CDATA #REQUIRED
TrackingNumber CDATA #REQUIRED
OrderDate CDATA #REQUIRED
ShipDate CDATA #REQUIRED
ShipMethod (USPS | FedEx | UPS) #REQUIRED
��
(For the sake of discussion, I included only Invoice table here)
How do I create an XML for the above DTD, which displays all the records (say 10 records) from the Invoice database.???
I couldn't understand the XML, which is given by Kevin. How the values are coming from invoice table into this XML??
Any explanation is appreciated.
Regards
Devi
Ajith Kallambella
Sheriff

Joined: Mar 17, 2000
Posts: 5782
I haven't read the book myself, but I'm guessing there is a little class that translates the DB Result set into an XML string. Apparently this approach happens to be a popular one for generating XML-ized resultsets for databases that are not XML enabled.


Open Group Certified Distinguished IT Architect. Open Group Certified Master IT Architect. Sun Certified Architect (SCEA).
 
Don't get me started about those stupid light bulbs.
 
subject: XML & Databases
 
Similar Threads
ID and IDREF attributes in XML
XML and XSL
passing Invalid characters within XML tags
Urgent help !!!!!!
Whether It need to be validated