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

String tableName = null;
if(SQLCmd.startsWith("SELECT")){
tableName = wordAfter(SQLCmd, "FROM");
}
else if(SQLCmd.startsWith("INSERT")){
tableName = wordAfter(SQLCmd, "INTO");
}
else if(SQLCmd.startsWith("UPDATE")){
tableName = wordAfter(SQLCmd, "UPDATE");
}
else if(SQLCmd.startsWith("DELETE")){
tableName = wordAfter(SQLCmd, "FROM");
}
else if(SQLCmd.startsWith("CREATE")){
tableName = wordAfter(SQLCmd, "TABLE");
}
return tableName;
}
protected Vector splitFields(String fields){
Vector fieldVector = new Vector();
fields = fields.trim();
if(fields.startsWith("("))fields = fields.substring(1);
if(fields.endsWith(")"))
fields = fields.substring(0,fields.length()-1);
int comma = fields.indexOf(",");
while(comma >= 0){
String field = fields.substring(0,comma).trim();
fieldVector.addElement(field);
fields = fields.substring(comma+1).trim();
comma = fields.indexOf(",");
}
fieldVector.addElement(fields.trim());
return fieldVector;
}
protected Vector splitColumns(String columns){
return splitFields(columns);
}
protected Vector splitValues(String values){
return splitFields(values);