[重要通告]如您遇疑難雜癥,本站支持知識(shí)付費(fèi)業(yè)務(wù),掃右邊二維碼加博主微信,可節(jié)省您寶貴時(shí)間哦!

一個(gè)軟件用到了一個(gè)數(shù)據(jù)庫(kù)，相對(duì)需要批處理來實(shí)現(xiàn)，那如何來實(shí)現(xiàn)呢？實(shí)現(xiàn)以下功能：

軟件路徑是?D:\Expressway\Projectsgb\Expway.exe
服務(wù)路徑是?D:\MySQL\MySQL Server 5.5\bin\MySQLd
當(dāng)運(yùn)行這個(gè)批處理文件時(shí)，①自動(dòng)把軟件結(jié)束掉，②自動(dòng)把服務(wù)重啟，③服務(wù)重啟完后，再啟動(dòng)軟件（注意這個(gè)順序不能亂。）

bat批處理

@echo off
taskkill /f /im Expway.exe
>nul 2>&1 "%SYSTEMROOT%\system32\cacls.exe" "%SYSTEMROOT%\system32\config\system"
if '%errorlevel%' NEQ '0' (
goto UACPrompt
) else ( goto gotAdmin )
:UACPrompt
echo Set UAC = CreateObject^("Shell.Application"^) > "%temp%\getadmin.vbs"
echo UAC.ShellExecute "%~s0", "", "", "runas", 1 >> "%temp%\getadmin.vbs"
"%temp%\getadmin.vbs"
exit /B
:gotAdmin
if exist "%temp%\getadmin.vbs" ( del "%temp%\getadmin.vbs" )

@echo off
for /f "skip=3 tokens=4" %%i in ('sc query mysql') do set "zt=%%i" &goto :next

:next
if /i "%zt%"=="RUNNING" (
echo 已經(jīng)發(fā)現(xiàn)該服務(wù)在運(yùn)行，正在關(guān)閉服務(wù)
net stop mysql
ping 127.0.0.1 -n 3
net start mysql
) else (
echo 該服務(wù)現(xiàn)在處于停止?fàn)顟B(tài)，即將開啟服務(wù)
net start mysql
)
ping 127.0.0.1 -n 3
start D:\Expressway\Projectsgb\Expway.exe
exit

解釋ping12.7.0.0.1 理解為延時(shí)就行

PowerShell腳本

if($script:MyInvocation.MyCommand.Path -ne $null) {
$current_dir = Split-Path -Path $script:MyInvocation.MyCommand.Path -Parent;
$current_script = Split-Path -Path $script:MyInvocation.MyCommand.Path -Leaf;
if(!([Security.Principal.WindowsPrincipal][Security.Principal.WindowsIdentity]::GetCurrent()).IsInRole([Security.Principal.WindowsBuiltInRole] "Administrator")) {
# NoExit makes keeps the window from closing. If you don't need it you can remove it.
Start-Process powershell.exe -Verb RunAs -ArgumentList "-NoProfile", "-NoExit", "-ExecutionPolicy", "Bypass", "-Command", "cd `"'$current_dir'`"; &`"'.\$current_script'`""
exit
}
}

ps | ?{$_.path -eq "D:\Expressway\Projectsgb\Expway.exe"} | kill -force
Get-WmiObject win32_service | ?{$_.PathName -like "*D:\MySQL\MySQL Server 5.5\bin\MySQLd"} | select Name | Restart-Service -Force
&"D:\Expressway\Projectsgb\Expway.exe"

問題未解決？付費(fèi)解決問題加Q或微信 2589053300 (即Q號(hào)又微信號(hào))右上方掃一掃可加博主微信

所寫所說，是心之所感，思之所悟，行之所得；文當(dāng)無敷衍，落筆求簡(jiǎn)潔。 以所舍，求所獲；有所依，方所成！