package xbean;

import java.io.*;
import java.beans.Beans;
import xbean.*;
public class SQLQueryBeanTest {
static public void main(String args[]) {
String databaseName = "XML";
String tableName = "CUSTOMER";
String SQLQuery = "SELECT * FROM CUSTOMER WHERE STATE = 'NY'";
try{
SQLQueryBean queryBean = (SQLQueryBean)Beans.instantiate(null,
"xbean.SQLQueryBean");
SerializerBean serializer =
(SerializerBean)Beans.instantiate(null,
"xbean.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);
}
}
}