Java Reference
In-Depth Information
import java.util.*;
import org.w3c.dom.Document;
import org.apache.xml.serialize.OutputFormat;
import org.apache.xml.serialize.XMLSerializer;
public class XMLDBTest{
static String UrlString = "file:///c:/projects/CustomerDB.xml";
static String SQLQuery =
"SELECT * FROM CUSTOMER WHERE "+
"( FIRST_NAME LIKE 'M%' OR CUSTOMER_NUMBER = '102' ) "+
"AND LAST_NAME = 'Corleone'";
static String[] SQLCmd =
{ "INSERT INTO CUSTOMER VALUES('101','Vito', 'Q','Corleone',"+
"'137 Main', 'New York','NY','10006','201-555-1213')",
"INSERT INTO CUSTOMER VALUES('102','James', 'J','Corleone',"+
"'123 Pine', 'New York','NY','10006','201-555-1214')",
"INSERT INTO CUSTOMER VALUES('103','Raquel','S','Corleone',"+
"'123 Pine', 'New York','NY','10006','201-555-1215')",
"INSERT INTO CUSTOMER VALUES('104','James', 'J','Witherspoon',"+
"'17 Oak','New York','NY','10006','201-555-1216')",
"INSERT INTO CUSTOMER VALUES('105','Fred', 'Q','Bloggs',"+
" '22 Walnut','New York','NY','10006','201-555-1217')"};
public String cNum = null;
public String fName = null;
public String lName = null;
public String street = null;
public String city = null;
public String state = null;
public String zip = null;
public String phone = null;
Document xmlDoc = null;
public XMLDBTest(){
try{
Class.forName("JavaDatabaseBible.ch19.JDBCforXML.XMLDriver");
}
catch (Exception e){
System.out.println(e);
}
