安裝手冊水文信息發(fā)布外網系統(tǒng)

環(huán)境軟件安 Jdk1.6安 tomcat6安 .NETframework2.0或更 安裝 數據 3.1 配置文 數據轉換配 數據庫連接配 轉換規(guī)則修 綜合程序配 Jdk1.6tomcat6雙 ，選擇jdk的安裝路徑：C:\ProgramFilestomcat.NETframework2.0在網上flash并安oralce11gr2版本，pl/sqldeveloperjsswrt、strong、jsswyyorclpl/sqldevelopersql JSSWMAXSIZEUNLIMITEDLOGGINGEXTENTMANAGEMENTLOCALSEGMENTSPACEMANAGEMENTAUTOstrong_reJSSWYYCREATESMALLFILETABLESPACE"JSSWYY"DATAFILE'D:\APP\ADMINISTRATOR\ORADATA\ORCL\JSSWYY'SIZE2000MAUTOEXTENDONNEXT100KMAXSIZEUNLIMITEDLOGGINGEXTENTMANAGEMENTLOCALSEGMENTSPACEMANAGEMENTAUTOstrong，如圖把默認表空間，臨時表空間，概要文件選好。strongdbastrongjsslt123pdajsswyyorcl3.1jsswxxSSI文件放在D:\strongsoft\pda\tomcat\webapps\ 應用庫文件上的文件里需要配置源數據.txt、目標數.datadataUserID=strong;Password=strong;DataSourceUserID=strong;Password=strong;DataSourceUserID=jsswyyorcl;Password=jsswyyorcl;DataSource在D:\Strongsoft\PDA_數據轉換\轉換規(guī)則.ini sourceconn1=source.txt//源數據庫文件// source1=selectDRPINTVSTCDTM,PDR,DYP,WTHfromST_PPTN_RwhereTM>=to_date('@param1yyyy-MM-ddHH24:mi:ss')andTM<=to_date('@param2','yyyy-MM-ddHH24:mi:ss')andstcdin(selectSTCDfromST_STBPRP_BwhereLOCALITYlike'江蘇水文%')dest1=begindeletefromST_PPTN_Rwherestcd='@STCD@'andtm=to_date('@TM@','yyyy-MM-ddHH24:mi:ss')andintv=@INTV@;insertintoST_PPTN_R(DRP,INTV,STCD,TM,PDR,DYP,WTH)values(@DRP@,@INTV@,'@STCD@',to_date('@TM@','yyyy-MM-ddHH24:mi:ss'),@PDR@,@DYP@,'@WTH@');end;//在目標數據庫中刪除數據，并插入數據delete1=deletefromST_PPTN_Rwheretmto_date(to_char(add_months(sysdate,-1),'YYYY-MM-DD')||'00:00:00','yyyy-MM-ddHH24:mi:ss')//刪除近一個月的數據//source2=selectSTCD,TM,RZ,INQ,W,BLRZ,OTQ,RWCHRCD,RWPTN,INQDR,MSQMTfromST_rsvr_RwhereTM>=to_date('@param1','yyyy-MM-ddHH24:mi:ss')andTM<=to_date('@param2yyyy-MM-ddHH24:mi:ss')andstcdinselectSTCDfromST_STBPRP_BwhereLOCALITYlike'江蘇水文%')to_date('@param1yyyy-MM-ddHH24:mi:ss')andTM<=to_date('@param2yyyy-MM-ddHH24:mi:ss')andstcdin(selectSTCDfromST_STBPRP_BwhereLOCALITYlike'江蘇水文%')dest3=begindeletefromST_RIVER_Rwherestcd='@STCD@'andtm=to_date('@TM@','yyyy-MM-ddHH24:mi:ss');insertintoST_RIVER_R(STCD,TM,Z,Q,XSA,XSAVV,XSMXV,FLWCHRCD,WPTN,MSQMT,MSAMT,MSVMT)values('@STCD@',to_date('@TM@','yyyy-MM-dd whereTM>=to_date('@param1yyyy-MM-ddHH24:mi:ss')andTM<=to_date('@param2yyyy-MM-ddHH24:mi:ss')andstcdin(selectSTCDfromST_STBPRP_BwhereLOCALITYlike'江蘇水文%') source5=selectSTCD,TM,TDZ,AIRP,TDCHRCD,TDPTN,HMKfromST_tide_RwhereTM>=to_date('@param1','yyyy-MM-HH24:mi:ss')andTM<=to_date('@param2yyyy-MM-ddHH24:mi:ss')andstcdinselectSTCDfromST_STBPRP_BwhereLOCALITYlike江dest5=begindeletefromST_tide_Rwherestcd='@STCD@'andtm=to_date('@TM@','yyyy-MM-ddHH24:mi:ss');insertintoST_tide_R(STCD,TM,TDZ,AIRP,TDCHRCD,TDPTN,HMK)values('@STCD@',to_date('@TM@','yyyy-MM-ddsource6=selectSTCD,TM,UPZ,DWZ,TGTQ,SWCHRCD,SUPWPTN,SDWWPTN,MSQMTfromST_was_RwhereTM>=to_date('@param1','yyyy-MM-ddHH24:mi:ss')andTM<=to_date('@param2yyyy-MM-ddHH24:mi:ss')andstcdinselectSTCDfromST_STBPRP_BwhereLOCALITYlike'江蘇水文%')dest6=begindeletefromST_was_Rwherestcd='@STCD@'andtm=to_date('@TM@','yyyy-MM-ddHH24:mi:ss');insertintoST_was_R(STCD,TM,UPZ,DWZ,TGTQ,SWCHRCD,SUPWPTN,SDWWPTN,MSQMT)values('@STCD@',to_date('@TM@','yyyy-MM-dd MENTS,MODITIME,ISTOPICfromst_stbprp_b MENTS,MODITIME,ISTOPIC)valueswq_nmisp_d HL,I,SI,B,NTfromwq_nmisp_dwhereSPT>=to_date('@param1','yyyy-MM-ddHH24:mi:ss')andSPT<=to_date('@param2','yyyy-MM-ddHH24:mi:ss')dest8=begindeletefromwq_nmisp_dwherestcd='@STCD@'andSPT=to_date('@SPT@','yyyy-MM-ddHH24:mi:ss');insertintowq_nmisp_d delete8=deletefromwq_nmisp_dwhereSPT<to_date(to_char(add_months(sysdate,-3),'YYYY-MM-DD')||'00:00:00','yyyy-MM-ddwq_misp_dwq_misp_dwhereSPT>=to_date('@param1','yyyy-MM-ddHH24:mi:ss')andSPT<=to_date('@param2','yyyy-MM-ddHH24:mi:ss')dest9=begindeletefromwq_misp_dwherestcd='@STCD@'andSPT=to_date('@TM@','yyyy-MM-ddHH24:mi:ss');insertintowq_misp_ddelete9=deletefromwq_misp_dwhereSPT<to_date(to_char(add_months(sysdate,-3),'YYYY-MM-DD')||'00:00:00','yyyy-MM-ddwq_phncp_dto_date('@param1','yyyy-MM-ddHH24:mi:ss')andSPT<=to_date('@param2','yyyy-MM-dddest10=begindeletefromwq_phncp_dwherestcd='@STCD@'andSPT=to_date('@SPT@','yyyy-MM-ddHH24:mi:ss');insertintowq_phncp_dto_date('@SPT@','yyyy-MM-ddHH24:mi:ss'),'@VLPH@','@BENF@','@ERLBF24@','@SLBF246@','@WLF@','@SXJF246@','@NT@');end;delete10=deletefromwq_phncp_dwhereSPT<to_date(to_char(add_months(sysdate,-3),'YYYY-MM-DD')||'00:00:00','yyyy-MM-ddwq_opcp_dwhereSPT>=to_date('@param1','yyyy-MM-ddHH24:mi:ss')andSPT<=to_date('@param2','yyyy-MM-dddest11=begindeletefromwq_opcp_dwherestcd='@STCD@'andSPT=to_date('@SPT@','yyyy-MM-ddHH24:mi:ss');insertintowq_opcp_d(STCD,PRPNM,LYNM,WBTP,SPT,BHC,DDT,ROGOR,DLL,JJDLL,MLLL,DDV,DBCH,ATLJ,BJQ,JNW,XQJZH,NXL,NT)valuesdelete11=deletefromwq_opcp_dwhereSPT<to_date(to_char(add_months(sysdate,-3),'YYYY-MM-DD')||'00:00:00','yyyy-MM-ddwq_mooop_dwq_mooop_dwhereSPT>=to_date('@param1','yyyy-MM-ddHH24:mi:ss')andSPT<=to_date('@param2','yyyy-MM-dddest12=begindeletefromwq_mooop_dwherestcd='@STCD@'andSPT=to_date('@SPT@','yyyy-MM-ddHH24:mi:ss');insertintodelete12=deletefromwq_mooop_dwhereSPT<to_date(to_char(add_months(sysdate,-3),'YYYY-MM-DD')||'00:00:00','yyyy-MM-ddwq_wbhp_dsource13=selectSTCD,PRPNM,LYNM,WBTP,SPT,BCTC,TCG,FCG,FS,NTfromwq_wbhp_dwhereSPT>=to_date('@param1','yyyy-MM-ddHH24:mi:ss')andSPT<=to_date('@param2','yyyy-MM-ddHH24:mi:ss')dest13=begindeletefromwq_wbhp_dwherestcd='@STCD@'andSPT=to_date('@SPT@','yyyy-MM-ddHH24:mi:ss');insertintowq_wbhp_ddelete13=deletefromwq_wbhp_dwhereSPT<to_date(to_char(add_months(sysdate,-3),'YYYY-MM-DD')||'00:00:00','yyyy-MM-ddwq_hydroe_dsource14=selectSTCD,SPT,Z,Q,Sfromwq_hydroe_dwhereSPT>=to_date('@param1','yyyy-MM-ddHH24:mi:ss')andSPT<=to_date('@param2','yyyy-MM-ddHH24:mi:ss')dest14=begindeletefromwq_hydroe_dwherestcd='@STCD@'andSPT=to_date('@SPT@','yyyy-MM-ddHH24:mi:ss');insertintowq_hydroe_d(STCD,SPT,Z,Q,S)values('@STCD@',to_date('@SPT@','yyyy-MM-ddHH24:mi:ss'),'@Z@','@Q@','@S@');end;delete14=deletefromwq_hydroe_dwhereSPT<to_date(to_char(add_months(sysdate,-3),'YYYY-MM-DD')||'00:00:00','yy