批处理下载文件，移动文件，插入数据库，移动文件，删除文件操作

来源：互联网发布：淘宝卖家一年的收入编辑：程序博客网时间：2024/06/05 10:03

echo off
title FTP自动执行服务窗口,请不要关闭
mode con:cols=50 lines=15
cls
set scriptFlag=1
set dirPath=D:/wujt
set ftpServer=218.241.481.34
set ftpUserName=hollycrm
set ftpPassword=Password
set ftpDelaySeconds=5
set dbUserName=hollydv
set dbPassWord=hollydv

set dbSID=JANGTA

:ftpOper
del /q/s %dirPath%/tmp/*

echo %ftpUserName%> ftp.ini
echo %ftpPassword%>> ftp.ini
echo prompt >> ftp.ini
echo bin >> ftp.ini
echo lcd tmp >> ftp.ini
echo cd /request/>> ftp.ini
echo mget *.txt >> ftp.ini
echo mdelete *.txt >> ftp.ini
echo cd bak >> ftp.ini
echo mput *.txt >> ftp.ini
echo bye >> ftp.ini

ftp -s:ftp.ini %ftpServer%
del /q ftp.ini
cd %dirPath%/tmp/
FOR /F "delims==" %%i IN ('dir /b/s *.txt') DO @echo insert into TBL_DM_IVR_CHARGEFORCALL(ID,GET_FILE_NAME,STATE,CREATE_TIME,LAST_EXCUTE_TIME) values(sys_guid(),'%%i','0',to_char(sysdate,'yyyy-mm-dd hh24:mi:ss'),to_char(sysdate,'yyyy-mm-dd hh24:mi:ss')); >> insert.sql

echo commit; >> insert.sql
echo exit >> insert.sql
copy D:/wujt/tmp/*.txt D:/wujt/files/*
type insert.sql|sqlplus %dbUserName%/%dbPassWord%@%dbSID%

cd /d %dirPath%
sleep %ftpDelaySeconds%

if "%scriptFlag%"=="1" goto ftpOper