各位大侠,小弟想分解这样一个字符串,
select * from (select (select qzdata.qz_dict_units.unitname from qzdata.qz_dict_units where qzdata.qz_dict_units.unitcode=qzdata.qz_dict_stations.unitcode) as unitname,stationid ,unitcode as stationcount from
qzdata.qz_dict_stations ) where ******我想用JAVA语言把它分解后,然后只去表名,和查询的那个字段名,就可以了,谢谢了!!!
select * from (select (select qzdata.qz_dict_units.unitname from qzdata.qz_dict_units where qzdata.qz_dict_units.unitcode=qzdata.qz_dict_stations.unitcode) as unitname,stationid ,unitcode as stationcount from
qzdata.qz_dict_stations ) where ******我想用JAVA语言把它分解后,然后只去表名,和查询的那个字段名,就可以了,谢谢了!!!
StringBuffer sbFilter = new StringBuffer();
sbFilter.append(" select ")
.append(你要查询的字段名)
.append(" from (select (select qzdata.qz_dict_units.unitname")
.append(" from qzdata.qz_dict_units where")
.append(" qzdata.qz_dict_units.unitcode=qzdata.qz_dict_stations.unitcode)")
.append(" as unitname,stationid ,unitcode as stationcount from ")
.append(" qzdata.qz_dict_stations ) where")
.append(********where条件);
String strFilter = sbFilter.toString();