Java Reference
In-Depth Information
parseSQLCmd(SQLString);
}
protected void parseSQLCmd(String SQLCmd){
cmd = SQLCmd.substring(0,SQLCmd.indexOf(" "));
tableName = getTableName(SQLCmd);
int tNameEnds = SQLCmd.indexOf(tableName) + tableName.length();
int columnsEnd = SQLCmd.indexOf(" VALUES");
int valuesIndex = SQLCmd.indexOf(" VALUES");
int fromIndex = SQLCmd.indexOf(" FROM ");
int whereIndex = SQLCmd.indexOf(" WHERE ");
int orderIndex = SQLCmd.indexOf(" ORDER ");
int orderByIndex = SQLCmd.indexOf(" BY ",orderIndex);
if(whereIndex>-1) whereIndex += " VALUES".length();
if(valuesIndex>-1)valuesIndex += " VALUES".length();
if(cmd.equals("CREATE")){
columns = SQLCmd.substring(tNameEnds).trim();
}
else if(cmd.equals("INSERT")){
columns = SQLCmd.substring(tNameEnds,columnsEnd).trim();
values = SQLCmd.substring(valuesIndex).trim();
}
else if(cmd.equals("SELECT")){
fields = SQLCmd.substring("SELECT".length(),fromIndex).trim();
if(whereIndex>-1){
if(orderIndex>-1){
where = SQLCmd.substring(whereIndex,orderIndex);
}else{
where = SQLCmd.substring(whereIndex);
}
where = where.trim();
}
if(orderIndex>-1){
orderBy = SQLCmd.substring(orderByIndex).trim();
}
}
}
private String getTableName(String SQLCmd){
