批处理启动/停止Windows服务示例

@echo off
rem Run as administrator
%1 mshta vbscript:CreateObject("Shell.Application").ShellExecute("cmd.exe","/c %~s0 ::","","runas",1)(window.close)&&exit
cd /d "%~dp0"

set DB1=MariaDB10.4
set DB2=MariaDB10.5
set DB3=MSSQLSERVER

set ASS=aspnet_state

:flag_loop

cls

rem echo %0

set state=

echo.
echo Database Type:
call :flag_state %DB1% state
echo 1 - %DB1% %state%
call :flag_state %DB2% state
echo 2 - %DB2% %state%
call :flag_state %DB3% state
echo 3 - %DB3% %state%
call :flag_state %ASS% state
echo 4 - %ASS% %state%
rem echo.

rem echo Action Type
rem echo S - start
rem echo X - stop

:flag_type
echo.
echo Please Input Database Type: R - Loop, Q - Exit

set /p type=

set return=%type%
call :upper_case %type% return
set type=%return%

call :check_exit %type%

if "%type%" == "1" (
call :flag_state %DB1% state & echo %DB1% %state% & call :flag_action %DB1%
) else if "%type%" == "2" (
call :flag_state %DB2% state & echo %DB2% %state% & call :flag_action %DB2%
) else if "%type%" == "3" (
call :flag_state %DB3% state & echo %DB3% %state% & call :flag_action %DB3%
) else if "%type%" == "4" (
call :flag_state %ASS% state & echo %ASS% %state% & call :flag_action %ASS%
) else if "%type%" == "R" (
goto flag_loop
) else (
goto flag_type
)

goto comments
函数
根据用户输入确定不同的操作
参数1: 要操作的服务名称，字符串
:comments
:flag_action
rem echo %~1
echo.
echo Please Input Action: S - Start, X - Stop, R - SelectType, Q - Exit

set /p action=
set return=%action%
call :upper_case %action% return
set action=%return%

call :check_exit %type%

if "%action%" == "S" (
call :flag_start %~1
) else if "%action%" == "X" (
call :flag_stop %~1
) else if "%action%" == "R" (
goto flag_type
) else (
goto flag_action
)
goto:eof

goto comments
函数
查询服务状态，并返回明确的服务状态，如 RUNNING 或 STOPPED，接受两个参数
参数1: 要查询的服务名称，字符串
参数2: 接受返回结果的变量
:comments
:flag_state
set fn=db_bat_123_tmp.log
sc query "%~1" |findstr "STATE" > %fn%
set /p value=<./%fn%
del %fn%
set index=2
for /F "tokens=%index% delims=:" %%a in ("%value%") do set value=:%%a
rem echo %value%
set %~2=%value%
goto:eof

:flag_start
echo start %~1
sc start %~1
timeout 2
call :flag_state %~1 state
echo %~1 %state%
goto flag_type
goto:eof

:flag_stop
echo stop %~1
sc stop %~1
timeout 2
call :flag_state %~1 state
echo %~1 %state%
goto flag_type
goto:eof

:check_exit
if "%~1" == "Q" (
goto flag_exit
) else if "%~1" == "EXIT" (
goto flag_exit
) else if "%~1" == "QUIT" (
goto flag_exit
)
goto:eof

:upper_case
set val=%~1
for %%i in (A B C D E F G H I J K L M N O P Q R S T U V W X Y Z) do call set val=%%val:%%i=%%i%%
set %~2=%val%
goto:eof

:lower_case
set val=%~1
for %%i in (a b c d e f g h i j k l m n o p q r s t u v w x y z) do call set val=%%val:%%i=%%i%%
set %~2=%val%
goto:eof

:flag_exit
exit