数据库服务管理脚本

echo off
cls
color 3
mode con cols=80 lines=30 & color 3
title Windows 数据库服务脚本管理 zongcai.liu
:menu
::选择菜单                    
echo #*********************************************************************#
echo ============== →Vista或Win7用户请以管理员身份运行← ================
echo #*********************************************************************#
echo.
echo     [1]启动MySQL     [2]关闭MySQL
echo     [3]启动SQLServer [4]关闭SQLServer
echo     [5]启动Oracle    [6]关闭Oracle      
echo     [7]解决Oracle无监听程序
echo     [8]远程连接     [9]计算器
echo 　　    其它键退出
echo.
echo #*********************************************************************#
set CHS=""
set /P CHS= 请选择:
if /I "%CHS%"=="1" (
goto a
)
if /I "%CHS%"=="2" (
goto b
)
if /I "%CHS%"=="3" (
goto c
)
if /I "%CHS%"=="4" (
goto d
)
if /I "%CHS%"=="5" (
goto e
)
if /I "%CHS%"=="6" (
goto f
)
if /I "%CHS%"=="7" (
goto g
)
if /I "%CHS%"=="8" (
goto h
)
if /I "%CHS%"=="9" (
goto i
)
if /I "%CHS%"=="Esc" (
exit
)
exit
:a
REM 启动mysql
net start MySQL
pause
cls
goto menu
:b
REM 关闭mysql
net stop MySQL
pause
cls
goto menu
:c
REM 启动sqlserver2005
net start "SQL Server (MSSQLSERVER)"
pause
cls
goto menu
:d
REM 关闭sqlserver2005
net stop "SQL Server (MSSQLSERVER)"
pause
cls
goto menu
:e
REM 启动OracleServiceORCL
net start "OracleServiceORCL"
net start "OracleOraDb11g_home1TNSListener"
pause
cls
goto menu
:f
REM 关闭OracleServiceORCL
net stop "OracleOraDb11g_home1TNSListener"
net stop "OracleServiceORCL"
pause
cls
goto menu
:g
net stop "OracleOraDb10g_home1TNSListener"
net stop "OracleServiceORCL"
net start "OracleServiceORCL"
net start "OracleOraDb10g_home1TNSListener"
echo 已经重新启动服务,请等待1分钟后尝试连接Orcale
pause
cls
goto menu
:h
mstsc
pause
cls
goto menu
:i
calc
pause
cls
goto menu






=========================================================

将以上语句复制保存到txt文件然后改后缀名成bat即可