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

return 0;
}
private boolean createTable(XMLCommand sql){
Vector columnVector = sql.splitColumns(sql.columns);
for(int i=0;i<columnVector.size();i++){
String columnDef = ((String)columnVector.elementAt(i)).trim();
int space = columnDef.indexOf(" ");
if(space>=0){
String colName = columnDef.substring(0,space);
String colType = columnDef.substring(space+1);
columnNameVector.addElement(colName);
columnTypeVector.addElement(colType);
}
}
return true;
}
private void initColumnData(XMLCommand sql){
NodeList records = xmlDoc.getElementsByTagName(sql.tableName);
Element record = (Element)records.item(0);
NamedNodeMap attribs = record.getAttributes();
for(int i=0;i<attribs.getLength();i++){
Node n = attribs.item(i);
if(n.getNodeType()==Node.ATTRIBUTE_NODE){
columnNameVector.addElement(n.getNodeName());
columnTypeVector.addElement("ATTRIBUTE");
}
}
NodeList fields = record.getChildNodes();
for(int i=0;i<fields.getLength();i++){
Node n = fields.item(i);
if(n.getNodeType()==Node.ELEMENT_NODE){
Element field = (Element)n;
columnNameVector.addElement(field.getTagName());
columnTypeVector.addElement("VARCHAR");
}
}
}
private boolean insert(XMLCommand sql){
if(columnNameVector.isEmpty())initColumnData(sql);
Vector data = sql.splitValues(sql.values);