@ECHO off
@title Hræ°æ®åºé¨é¨ã人åä¿¡æ¯åæ¥
SET user=hrmis
SET password=hrmis
SET serverip=192.168.0.110
SET db=HRDBG
ECHO ......å½å使ç¨çæ°æ®åºè¿æ¥ï¼æå¡å¨IP:%serverip% æ°æ®åº:%db% ç¨æ·å:%user% å¯ç : %password%
ECHO ......请确认æ°æ®åºè¿æ¥è®¾ç½®æ£ç¡®ï¼å¦æä¸æ£ç¡®è¯·ç¹çªå£å³ä¸è§Ãéåº!!!!!!!
pause
set t0=%TIME:~0,1%
set logTIME=_%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%_%TIME:~0,2%%TIME:~3,2%%TIME:~6,2%
if "%t0%"==" " set logTIME=_%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%_0%TIME:~1,1%%TIME:~3,2%%TIME:~6,2%
set logfile0=Mas%logTIME%.log
ECHO ......èæ¬ç¨åºå¼å§è¿è¡æ¶é´ï¼[%DATE:~0,10% %TIME:~0,8%]
ECHO ......èæ¬ç¨åºå¼å§è¿è¡æ¶é´ï¼[%DATE:~0,10% %TIME:~0,8%] >> %logfile0%
ECHO ......å½å使ç¨çæ°æ®åºè¿æ¥ï¼æå¡å¨IP:%serverip% æ°æ®åº:%db% ç¨æ·å:%user% å¯ç : %password% >>%logfile0%
ECHO .............updatesql\1ãé¨é¨ã人åä¿¡æ¯åæ¥.sql
ECHO .............updatesql\1ãé¨é¨ã人åä¿¡æ¯åæ¥.sql>>%logfile0%
osql -U %user% -P %password% -S %serverip% -d %db% -i updatesql\1ãé¨é¨ã人åä¿¡æ¯åæ¥.sql>>%logfile0% -n
ECHO .............updatesql\2ãèå¤æ°æ®å¯¼å
¥.sql
ECHO .............updatesql\2ãèå¤æ°æ®å¯¼å
¥.sql>>%logfile0%
osql -U %user% -P %password% -S %serverip% -d %db% -i updatesql\2ãèå¤æ°æ®å¯¼å
¥.sql>>%logfile0% -n
ECHO .............updatesql\3ãå çéæ°è®¡ç®.sql
ECHO .............updatesql\3ãå çéæ°è®¡ç®.sql>>%logfile0%
osql -U %user% -P %password% -S %serverip% -d %db% -i updatesql\3ãå çéæ°è®¡ç®.sql>>%logfile0% -n
ECHO [%DATE:~0,10% %TIME:~0,8%]å¤çæåï¼éåºç³»ç»éæ°ç»éï¼è·åæç»ç»æãããããã
ECHO [%DATE:~0,10% %TIME:~0,8%]å®æã >> %logfile0%
pause
以ä¸æ¯BAT示èæ件ï¼ä¿å为BATæ ¼å¼æå¼
温馨提示:答案为网友推荐,仅供参考