@ECHO OFF
echo 升级部署tomcat
set date=%date:~0,10%
set time=%time:~0,8%
set currDate=%date% %time%
echo %currDate%
echo 设置参数
set TOMCAT_REALPATH=D:\Program\tomcat\apache-tomcat-6.0.43-windows-x64\apache-tomcat-6.0.43
set TOMCAT_BIN=%TOMCAT_REALPATH%\bin
set TOMCAT_WORK=%TOMCAT_REALPATH%\work
set TOMCAT_APP=%TOMCAT_REALPATH%\wtpwebapps\xmcbglnew
set TOMCAT_POINT=8080
set WORK_SPACE=C:\Users\ZQ\Desktop
set WEBAPP_BAK=G:\APP_BAK\%date:~0,4%%date:~5,2%%date:~8,2%_bak
set XTSJ_WEBAPP_BAK=G:\XTSJ_WEBAPP_BAK\%date:~0,4%%date:~5,2%%date:~8,2%_%time:~0,2%%time:~3,2%%time:~6,2%_bak
set SQLSERVER_IP=192.168.6.43
SET SQLSERVER_USER=cbhs_main
SET SQLSERVER_PASS=cbhs2.43
SET SQLSERVER_DB=cbhs_20170320
SET SQLSERVER_SQL=%WORK_SPACE%\sjsql
echo 关闭服务
pushd %TOMCAT_BIN%
call shutdown.bat
echo 备份项目
mkdir %WEBAPP_BAK%
xcopy %TOMCAT_APP% %WEBAPP_BAK% /S /E /F /A /Y
echo 删除work目录
cd %TOMCAT_REALPATH%
if exist work rmdir /s /q work
echo 拷贝升级代码
xcopy %WORK_SPACE%\xmcbgl %TOMCAT_APP% /S /E /F /A /Y
echo 备份升级代码
mkdir %XTSJ_WEBAPP_BAK%
xcopy %WORK_SPACE%\xmcbgl %XTSJ_WEBAPP_BAK% /S /E /F /A /Y
echo 执行升级sql
sqlcmd -S %SQLSERVER_IP% -d %SQLSERVER_DB% -U %SQLSERVER_USER% -P %SQLSERVER_PASS% -i %SQLSERVER_SQL%.sql
echo 启动服务
:check_tomcat_stop
pushd %WORK_SPACE%
netstat -a -n >ipt.txt
find "%TOMCAT_POINT%" %WORK_SPACE%\ipt.txt && goto check_tomcat_stop
if exist ipt.txt del ipt.txt
pushd %TOMCAT_BIN%
call startup.bat
popd
pause