Accessing XML Documents Using SQL - Java Database Programming Bible - page 470

package JavaDatabaseBible.ch19.JDBCforXML;
import java.util.Vector;
import java.sql.*;
import org.w3c.dom.Document;
import org.w3c.dom.Element;
import org.w3c.dom.Node;
import org.w3c.dom.NodeList;
import org.w3c.dom.NamedNodeMap;
import org.xml.sax.InputSource;
import JavaDatabaseBible.ch19.JDBCImpl.JDBCStatementImpl;
public class XMLStatement extends JDBCStatementImpl{
private InputSource xml;
private Document xmlDoc;
private Vector columnNameVector = new Vector();
private Vector columnTypeVector = new Vector();
public XMLStatement(){
}
public XMLStatement(InputSource xml){
this.xml = xml;
}
public XMLStatement(Document xmlDoc){
this.xmlDoc = xmlDoc;
}
public ResultSet executeQuery(String sqlQuery) throws SQLException{
XMLQuery query = new XMLQuery(sqlQuery);
return query.processDoc(xmlDoc);
}
public int executeUpdate(String sqlString){
XMLCommand sql = new XMLCommand(sqlString);
if(sql.cmd.equals("CREATE")){
createTable(sql);
}
if(sql.cmd.equals("INSERT")){
insert(sql);
}