bat导出数据库

@echo off   
echo 开始执行程序...

title Echo date if format 'yyyy-MM-dd HH:mm:ss'
for /f "tokens=1 delims=/ " %%j in ("%date%") do set d1=%%j
for /f "tokens=2 delims=/ " %%j in ("%date%") do set d2=%%j
for /f "tokens=3 delims=/ " %%j in ("%date%") do set d3=%%j
for /f "tokens=1 delims=: " %%j in ("%time%") do set t1=%%j
for /f "tokens=2 delims=: " %%j in ("%time%") do set t2=%%j
for /f "tokens=3 delims=:. " %%j in ("%time%") do set t3=%%j

rem set currentDate=%d1%-%d2%-%d3% %t1%:%t2%:%t3%

set currentDate=%d1%%d2%%d3%%t1%%t2%%t3%

echo %currentDate%

exp ideal/ideal@XE file="d:\hybrid%currentdate%.dmp" owner=ideal

echo 执行结束...
echo 如果执行完希望窗口立即关闭,请去掉pause
pause