传入字符串如下
create view "informix".sysdomains (id,owner,name,type) as select x0.extended_id ,x0.owner ,x0.name ,x0.type from "informix".sysxtdtypes x0 where (x0.domain = 'D' ) ;
通过下面的方法可以获取到想要的视图名“sysdomains”
import java.util.regex.Matcher;
import java.util.regex.Pattern;
private String getViewName(String sqlText){
//正则是:从字符串中截取第一个英文左括号之前的字符串
Pattern p = Pattern.compile(".*?(?=\\()");
Matcher m = p.matcher(sqlText);
String output = "";
if (m.find()) {
output = m.group();
}
String[] parts = output.split("\\.");
String lastPart = parts[parts.length-1].trim();
return lastPart;
}