Java Reference
In-Depth Information
String SQLQuery = "SELECT * FROM CUSTOMERS WHERE STATE = 'NY'";
try{
SQLQueryBean queryBean = (SQLQueryBean)Beans.instantiate(null,
"JavaDatabaseBible.ch17.Xbeans.SQLQueryBean");
SerializerBean serializer =
(SerializerBean)Beans.instantiate(null,
"JavaDatabaseBible.ch17.Xbeans.SerializerBean");
queryBean.setDatabaseName(databaseName);
queryBean.setTableName(tableName);
queryBean.setSQLQuery(SQLQuery);
queryBean.setDOMListener(serializer);
serializer.setOutputStream(new FileOutputStream("Customers.xml"));
queryBean.processDocument();
}catch(Exception e){
System.err.println(e);
}
}
}
The output from this example is shown in Listing 17-9 . You should be able to recognize it as the XML
document shown in Figure 17-1 , which is created using an Xbean designed to output a JTree.
Listing 17-9: DOM document serialized from the Customer Table
<?xml version="1.0"?>
<CUSTOMERS DBNAME="CONTACTS">
<CUSTOMER CUSTOMER_NUMBER="100">
<FIRST_NAME>Michael</FIRST_NAME>
<MI>A</MI>
<LAST_NAME>Corleone</LAST_NAME>
<STREET>123 Pine</STREET>
<CITY>New York</CITY>
<STATE>NY </STATE>
<ZIP>10006</ZIP>
<PHONE>201-555-1212</PHONE>
</CUSTOMER>
<CUSTOMER CUSTOMER_NUMBER="101">
<FIRST_NAME>Fredo</FIRST_NAME>
<MI>X</MI>
<LAST_NAME>Corleone</LAST_NAME>
<STREET>19 Main</STREET>
Search WWH ::




Custom Search