筛选多条SQL所查询的表名

package ceshi; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.InputStream; import java.io.OutputStream; import java.util.ArrayList; import java.util.HashSet; import java.util.Iterator; import java.util.List; import java.util.Set; import java.util.Stack; import java.util.regex.Matcher; import java.util.regex.Pattern; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Workbook; import org.apache.poi.ss.usermodel.WorkbookFactory; import BJZFC.lp.pl.Write; public class lll { /** * @param args * @throws Exception */ public static void main(String[] args) throws Exception { // TODO Auto-generated method stub // TODO Auto-generated method stub // 转换可变的StringBuffer // String l ="SELECT DECODE(GROUPING(S.REGION_CODE),1,'合计',(SELECT DISTRICT_NAME FROM BS_DISTRICT WHERE REGION_ID = S.REGION_CODE)) REGION_NAME, DECODE(GROUPING(S.REGION_CODE),1,'', DECODE(GROUPING(S.COUNTY_CODE), 1, '小计', (SELECT DISTRICT_NAME FROM BS_DISTRICT WHERE REGION_ID = S.COUNTY_CODE))) COUNTY_NAME,DECODE(GROUPING(S.REGION_CODE),1,'',DECODE(GROUPING(S.COUNTY_CODE),1,'',DECODE(GROUPING(R.MARKET_CENTER_NAME),1,'小计',R.MARKET_CENTER_NAME))) AS PARENT_CHANNEL_NAME,DECODE(GROUPING(S.REGION_CODE),1,'',DECODE(GROUPING(S.COUNTY_CODE),1,'',DECODE(GROUPING(R.MARKET_CENTER_NAME),1,'',DECODE(GROUPING(R.CHANNEL_TYPE_NAME),1,'小计',R.CHANNEL_TYPE_NAME)))) AS CHANNEL_TYPE_NAME,DECODE(GROUPING(S.REGION_CODE),1,'',DECODE(GROUPING(S.COUNTY_CODE),1,'',DECODE(GROUPING(R.MARKET_CENTER_NAME),1,'',DECODE(GROUPING(R.CHANNEL_TYPE_NAME),1,'',DECODE(GROUPING(R.CHANNEL_TYPE_DTL_NAME),1,'小计',R.CHANNEL_TYPE_DTL_NAME))))) AS CHANNEL_TYPE_DTL_NAME,DECODE(GROUPING(S.REGION_CODE),1,'',DECODE(GROUPING(S.COUNTY_CODE),1,'',DECODE(GROUPING(R.MARKET_CENTER_NAME),1,'',DECODE(GROUPING(R.CHANNEL_TYPE_NAME),1,'',DECODE(GROUPING(R.CHANNEL_TYPE_DTL_NAME),1,'',DECODE(GROUPING(R.CHANNEL_TYPE_DTL3_NAME),1,'小计',R.CHANNEL_TYPE_DTL3_NAME)))))) AS CHANNEL_TYPE_DTL3_NAME, DECODE(GROUPING(S.REGION_CODE),1,'',DECODE(GROUPING(S.COUNTY_CODE),1,'',DECODE(GROUPING(R.MARKET_CENTER_NAME),1,'',DECODE(GROUPING(R.CHANNEL_TYPE_NAME),1,'',DECODE(GROUPING(R.CHANNEL_TYPE_DTL_NAME),1,'',DECODE(GROUPING(R.CHANNEL_TYPE_DTL3_NAME),1,'',DECODE(GROUPING(S.CHANNEL_ID),1,'小计',S.CHANNEL_ID))))))) AS CHANNEL_ID,DECODE(GROUPING(S.REGION_CODE),1,'',DECODE(GROUPING(S.COUNTY_CODE),1,'',DECODE(GROUPING(R.MARKET_CENTER_NAME),1,'',DECODE(GROUPING(R.CHANNEL_TYPE_NAME),1,'',DECODE(GROUPING(R.CHANNEL_TYPE_DTL_NAME),1,'',DECODE(GROUPING(R.CHANNEL_TYPE_DTL3_NAME),1,'',DECODE(GROUPING(S.CHANNEL_ID),1,'',DECODE(GROUPING(R.CHANNEL_NAME),1,'小计',R.CHANNEL_NAME)))))))) AS CHANNEL_NAME,DECODE(GROUPING(S.REGION_CODE),1,'',DECODE(GROUPING(S.COUNTY_CODE),1,'',DECODE(GROUPING(R.MARKET_CENTER_NAME),1,'',DECODE(GROUPING(R.CHANNEL_TYPE_NAME),1,'', DECODE(GROUPING(CHANNEL_TYPE_DTL_NAME),1,'', DECODE(GROUPING(R.CHANNEL_TYPE_DTL3_NAME),1,'',DECODE(GROUPING(S.CHANNEL_ID),1,'',DECODE(GROUPING(T_1),1,'小计',T_1)))))))) T_1,SUM(F_10) F_10 FROM RP_CHNL_RES_SHORT S,RP_CHANNEL R WHERE R.CHANNEL_ID(+)=S.CHANNEL_ID AND S.RPT_TYPE = '060200' AND S.REC_TYPE = 0 AND S.REGION_CODE =:REGION_ID AND S.COUNTY_CODE = :COUNTY_CODE AND R.MARKET_CENTER_ID = :MARKET_ID AND S.BUSI_DATE >= TO_NUMBER(REPLACE(:STARTDATE , '-', ''), '99999999') AND S.BUSI_DATE <= TO_NUMBER(REPLACE(:ENDDATE , '-', ''), '99999999') AND R.CHANNEL_TYPE = :CHANNEL_TYPE AND R.CHANNEL_TYPE_DTL = :CHNL_SE_TYPE AND R.CHANNEL_TYPE_DTL3 = :CHNL_TR_TYPE AND S.CHANNEL_ID = :CHANNEL_ID AND :RES_NUMBER_HLR AND F_11=:PLAN_ID AND F_12 IN (:PLAN_SET ) 按明细 report 20110524 LSJ 修改SQL中的视图名称为：V_RP_CHNL_RES_SHORT GROUP BY ROLLUP (S.REGION_CODE,S.COUNTY_CODE,R.MARKET_CENTER_NAME,R.CHANNEL_TYPE_NAME,R.CHANNEL_TYPE_DTL_NAME,R.CHANNEL_TYPE_DTL3_NAME,S.CHANNEL_ID, R.CHANNEL_NAME,T_1) HAVING GROUPING(S.REGION_CODE) = 0 AND GROUPING(S.COUNTY_CODE) = 0 AND GROUPING(MARKET_CENTER_NAME) = 0 AND GROUPING(R.CHANNEL_TYPE_NAME) = 0 AND GROUPING(R.CHANNEL_TYPE_DTL_NAME) = 0 AND GROUPING(CHANNEL_TYPE_DTL3_NAME) = 0 AND GROUPING(S.CHANNEL_ID) = 0 AND GROUPING(T_1) = 0 OR GROUPING(S.REGION_CODE) = 0 AND GROUPING(S.COUNTY_CODE) = 0 AND GROUPING(MARKET_CENTER_NAME) = 0 AND GROUPING(R.CHANNEL_TYPE_NAME) = 0 AND GROUPING(R.CHANNEL_TYPE_DTL_NAME) = 0 AND GROUPING(CHANNEL_TYPE_DTL3_NAME) = 0 AND GROUPING(S.CHANNEL_ID) = 0 AND GROUPING(T_1) = 1 OR GROUPING(S.REGION_CODE) = 0 AND GROUPING(S.COUNTY_CODE) = 0 AND GROUPING(MARKET_CENTER_NAME) = 0 AND GROUPING(R.CHANNEL_TYPE_NAME) = 0 AND GROUPING(R.CHANNEL_TYPE_DTL_NAME) = 0 AND GROUPING(CHANNEL_TYPE_DTL3_NAME) = 0 AND GROUPING(S.CHANNEL_ID) = 1 AND GROUPING(T_1) = 1 OR GROUPING(S.REGION_CODE) = 0 AND GROUPING(S.COUNTY_CODE) = 0 AND GROUPING(MARKET_CENTER_NAME) = 0 AND GROUPING(R.CHANNEL_TYPE_NAME) = 0 AND GROUPING(R.CHANNEL_TYPE_DTL_NAME) = 0 AND GROUPING(CHANNEL_TYPE_DTL3_NAME) = 1 AND GROUPING(S.CHANNEL_ID) = 1 AND GROUPING(T_1) = 1 OR GROUPING(S.REGION_CODE) = 0 AND GROUPING(S.COUNTY_CODE) = 0 AND GROUPING(MARKET_CENTER_NAME) = 0 AND GROUPING(R.CHANNEL_TYPE_NAME) = 0 AND GROUPING(R.CHANNEL_TYPE_DTL_NAME) = 1 AND GROUPING(CHANNEL_TYPE_DTL3_NAME) = 1 AND GROUPING(S.CHANNEL_ID) = 1 AND GROUPING(T_1) = 1 OR GROUPING(S.REGION_CODE) = 0 AND GROUPING(S.COUNTY_CODE) = 0 AND GROUPING(MARKET_CENTER_NAME) = 1 AND GROUPING(R.CHANNEL_TYPE_NAME) = 1 AND GROUPING(R.CHANNEL_TYPE_DTL_NAME) = 1 AND GROUPING(CHANNEL_TYPE_DTL3_NAME) = 1 AND GROUPING(S.CHANNEL_ID) = 1 AND GROUPING(T_1) = 1 OR GROUPING(S.REGION_CODE) = 0 AND GROUPING(S.COUNTY_CODE) = 1 AND GROUPING(MARKET_CENTER_NAME) = 1 AND GROUPING(R.CHANNEL_TYPE_NAME) = 1 AND GROUPING(R.CHANNEL_TYPE_DTL_NAME) = 1 AND GROUPING(CHANNEL_TYPE_DTL3_NAME) = 1 AND GROUPING(S.CHANNEL_ID) = 1 AND GROUPING(T_1) = 1 OR GROUPING(S.REGION_CODE) = 1 AND GROUPING(S.COUNTY_CODE) = 1 AND GROUPING(MARKET_CENTER_NAME) = 1 AND GROUPING(R.CHANNEL_TYPE_NAME) = 1 AND GROUPING(R.CHANNEL_TYPE_DTL_NAME) = 1 AND GROUPING(CHANNEL_TYPE_DTL3_NAME) = 1 AND GROUPING(S.CHANNEL_ID) = 1 AND GROUPING(T_1) = 1 ORDER BY S.REGION_CODE,S.COUNTY_CODE,R.MARKET_CENTER_NAME,R.CHANNEL_TYPE_NAME,R.CHANNEL_TYPE_DTL_NAME,CHANNEL_TYPE_DTL3_NAME,S.CHANNEL_ID,T_1" ; // String l = "SELECT ROWNUM,REGION_NAME,COUNTY_NAME,SUMCOUNT,SUMMONEY FROM(SELECT C.REGION_NAME, C.COUNTY_NAME, COUNT(*) SUMCOUNT, TO_CHAR(SUM(T.INVOICE_FEE) / 100, 'FM999999990.00') AS SUMMONEY FROM RES_INVOICE_USED_#REGION_ID# T,RP_CHANNEL C WHERE T.REGION_ID=C.REGION_CODE AND T.COUNTY_ID=C.COUNTY_CODE AND T.ORG_ID=C.CHANNEL_ID AND T.COUNTY_ID =:COUNTY_CODE AND C.MARKET_CENTER_ID=:MARKET_ID AND C.CHANNEL_TYPE=:CHANNEL_TYPE AND C.CHANNEL_TYPE_DTL=:CHNL_SE_TYPE AND C.CHANNEL_TYPE_DTL3=:CHNL_TR_TYPE AND C.CHANNEL_ID=:CHANNEL_ID AND T.USE_DATE BETWEEN TO_DATE(:STARTDATE , 'YYYY-MM-DD') AND TO_DATE(:ENDDATE ||' 23-59-59', 'yyyy-mm-dd hh24-mi-ss') AND T.RES_SPEC_ID IN ( SELECT RES_SPEC_ID FROM RES_SPEC R WHERE R.RES_TYPE_ID IN( '4000' ,'4002')) GROUP BY C.REGION_NAME, C.COUNTY_NAME) " ; String l = "SELECT '【' || R.BUSINESS_ID || '】' || CASE WHEN R.BUSINESS_ID = ANY(500000020001, 500000020002) AND (R.USER_STATE <> '1' OR R.USER_TYPE <> '1') THEN '套卡预开' ELSE R.BUSINESS_TYPE END AS BUSINESS_TYPE, R.DONE_CODE, TO_CHAR(R.DONE_DATE, 'YYYY-MM-DD HH24:MI:SS') DONE_DATE, R.OP_NAME, R.CUST_NAME, R.BILL_ID, R.OFFER_NAME, R.OLD_OFFER_NAME, CASE WHEN R.BUSINESS_ID = 500000020049 THEN R.DISCNT_REASON ELSE R.REMARKS END REMARKS, R.SIM_CODE, R.BILL_REGION_NAME, R.ORG_NAME, R.DISCNT_REASON, DECODE(R.IS_BATCH, '1', '是', '否') IS_BATCH, CHNL_OPER_ID REFEREE_ID, OPER_NAME REFEREE_NAME FROM RPT.RP_BUSI_DETAIL_#REGION_ID# R, RPT.RP_REFE_DETAIL_#REGION_ID# RRD, RPT.CHNL_OPER_INFO CPI WHERE R.ORG_ID IN (:ORG_ID ) AND R.DONE_DATE >= TO_DATE(:START_DATE , 'YYYY-MM-DD HH24-MI-SS') AND R.DONE_DATE <= TO_DATE(:END_DATE , 'YYYY-MM-DD HH24-M