sql = "select * from user,dept where user.id=1 order by id" ;
String[] t = sql.split("from") ;
sql = t[1] ;
t = sql.split("where") ;
sql = t[0] ;
t = sql.split(",") ;
for (int i = 0; i < t.length; i++)
{
System.out.println(t[i].trim());
}
sql = "select * from user,dept where user.id=1 order by id" ;
int indexF = sql.indexOf("from");
int indexW = sql.indexOf("where");
String s = sql.substring(indexF+4, indexW).trim() ;
String[] tablenames = s.split(",") ;
for (int i = 0; i < tablenames.length; i++)
{
System.out.println(tablenames[i]);
}