jsqlparser是github上一个开源项目，maven的配置如下：

<dependency>
<groupId>com.github.jsqlparser</groupId>
<artifactId>jsqlparser</artifactId>
<version>1.1</version>
</dependency>

publicList tablesNameBysql() {

String sql ="select * from Outvisit l left join patient p on l.patid=p.patientid join patstatic c on  l.patid=c.patid inner join patphone  ph  on l.patid=ph.patid where l.name='kevin'  union all select * from invisit v";

Statement statement = CCJSqlParserUtil.parse(sql);

//            Select selectStatement = (Select)statement;

TablesNamesFinder tablesNamesFinder =newTablesNamesFinder();

List result = tablesNamesFinder.getTableList(statement);

for(String tableStr:result){

logger.debug(">>>> "+ tableStr);

}

return result;

}

>>>> Outvisit

>>>> patient

>>>> patstatic

>>>> patphone

>>>> invisit