@echo off
start C:\Users\Desktop\import_user_sample.xlsx
start C:\Users\Desktop\征审有审批(初审)结论.sql
start C:\Users\Desktop\ermps_申请审批操作历史表_ermps_history.sql
start C:\Users\Desktop\债权.sql
pause
@echo off 为批处理的开始
start 为要执行的动作
pause 按任意键退出
2:文件下载:
echo=1/*>nul&@cls
@echo off
call :http "http://pic33.nipic.com/20130916/3420027_192919547000_2.jpg" D:\adtasks\a.jpg
call :http "http://pic33.nipic.com/20130916/3420027_192919547000_2.jpg" D:\adtasks\a1.jpg
::call :ftp 11.22.33.44 user pass "soft\a.zip" "C:\a.zip"
pause
goto :eof
::-----------------下面是函数定义区域-----------------
:ftp
echo Source: "ftp://%~2:%~3@%~1/%~4"
echo Destination: "%~f5"
echo Start downloading. . .
(
echo open %1
echo %2
echo %3
echo bin
echo get %4 %5
echo quit
)>ftp.tmp
>nul ftp -s:ftp.tmp
del ftp.tmp
echo OK!
goto :eof
:http
echo Source: "%~1"
echo Destination: "%~f2"
echo Start downloading. . .
cscript -nologo -e:jscript "%~f0" "%~1" "%~2"
echo OK!
goto :eof
*/
var iLocal,iRemote,xPost,sGet;
iLocal =WScript.Arguments(1);
iRemote = WScript.Arguments(0);
iLocal=iLocal.toLowerCase();
iRemote=iRemote.toLowerCase();
xPost = new ActiveXObject("Microsoft"+String.fromCharCode(0x2e)+"XMLHTTP");
xPost.Open("GET",iRemote,0);
xPost.Send();
sGet = new ActiveXObject("ADODB"+String.fromCharCode(0x2e)+"Stream");
sGet.Mode = 3;
sGet.Type = 1;
sGet.Open();
sGet.Write(xPost.responseBody);
sGet.SaveToFile(iLocal,2);
/*---------------解释--------------
批处理定义了两个函数ftp与http,分别调用它们则实现ftp和http的下载。
1、函数ftp
先构造一个临时文件,里面包含操作指令,用ftp.exe调用之,完成下载。
2、函数http
包含js代码,用cscript.exe调用之,完成下载。
*/