Java Reference
In-Depth Information
}
public static void main(String args[]){
XMLQueryTest test = new XMLQueryTest();
serializeDocumentAsFile(test.createTable(),UrlString);
serializeDocumentAsFile(test.updateTable(SQLCmd),UrlString);
serializeDocumentAsFile(test.queryTable(SQLQuery),
"file:///c:/projects/ResultSet.xml");
}
public Document createTable(){
try{
Connection con = DriverManager.getConnection(UrlString);
Statement stmt = con.createStatement();
stmt.executeUpdate("CREATE TABLE CUSTOMER "+
"(CUSTOMER_NUMBER ATTRIBUTE, "+
"FIRST_NAME VARCHAR(30), "+
"MI VARCHAR(30), "+
"LAST_NAME VARCHAR(30), "+
"STREET VARCHAR(30), "+
"CITY VARCHAR(30), "+
"STATE VARCHAR(30), "+
"ZIP VARCHAR(30), "+
"PHONE VARCHAR(30))");
stmt.executeUpdate("INSERT INTO CUSTOMER VALUES("+
"'100','Michael','A','Corleone',"+
"'123 Pine','New York','NY','10006','201-555-
1212'");
xmlDoc =
((JavaDatabaseBible.ch19.JDBCforXML.XMLStatement)stmt).getXmlDocument();
}
catch (Exception e){
System.out.println(e);
}
return xmlDoc;
}
public Document updateTable(String[] SQLCmd){
try{
Connection con = DriverManager.getConnection(UrlString);
Statement stmt = con.createStatement();
for(int i=0;i<SQLCmd.length;i++){
