Importing XML Data into a Database
Now that you know how to convert database records into well-formed XML documents, let’s turn things around to look at how the process works in reverse. This section examines how data marked up with XML can be converted into SQL statements and inserted into a database.
Dynamically Constructing SQL Queries from an XML Document with SAX
Again, we’ll begin with a simple example—consider the XML document in Listing 7.10.
Listing 7.10. An XML Book List (books.xml)
<?xml version="1.0"?> <list> <item> <title>Waking Up With The Red-Eyed Bed Monster</title> <author>J. I. M. Somniac</author> <blurb>The blood-chillingly true story of one man's fight against the monsters under his bed.</blurb> </item> <item> <title>The ...