windos 批处理

mysql创建数据库
:MYSQL建库脚本
:start
@ECHO off

rem'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
rem 请在使用和转载时保留作者信息
rem MKSQL.BAT
rem
rem Date: 7/6/2007
rem Company Newhi
rem www.newhi.net
rem Email liuqi@newhi.net
rem '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

title MYSQL建库程序
@mode con cols=40 lines=10
color 1e

set /p mysqlid="请输入登陆名:"
cls

if exist D:\mysql\data\%mysqlid%_db goto end

set /p mysqlpw="请输入数据库密码:"
cls


cd C:\Program Files\MySQL\MySQL Server 5.1\bin
echo create database %mysqlid%_db;|MySQL -h localhost -uroot -proot

echo grant select,insert,update,delete,Create,Drop,References,Index,Alter on %mysqlid%_db.* to %mysqlid%@localhost identified by "%mysqlpw%"; |MySQL -h localhost -uroot -p密码
cls
echo ┏─────────────┓
echo │ ▉▉▉▉▉▉ 50%%│
echo ┗─────────────┛
ping -n 2 127.1>nul
cls
echo ┏─────────────┓
echo │ ▉▉▉▉▉▉▉▉▉▉ 100%%│
echo ┗─────────────┛
ping -n 2 127.1>nul
cls

echo %mysqlid% 用户数据库%mysqlid%建立成功！
echo 等待MYSQL服务重新启动
echo use test ;select * from teacher;
ping -n 5 127.0.0.1>nul

net stop "MySql"
net start "MySql"
goto over
:end
echo %mysqlid% 已存在 请核实后输入!
ping -n 5 127.0.0.1>nul
goto start
:over


『第 2 楼』:

:mssql 建库脚本
:start
@ECHO off

rem'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
rem 请在使用和转载时保留作者信息
rem MKSQL.BAT
rem
rem Date: 7/6/2007
rem Company Newhi
rem www.newhi.net
rem Email liuqi@newhi.net
rem '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''


title MSSQL建库程序
@mode con cols=40 lines=10
color 1e


set /p mssqlid="请输入登陆名:"
cls

if exist D:\mssqldata\%mssqlid%_db_Data.MDF goto end
echo 你输入的登陆名是 %mssqlid%
set /p mssqlpw="请输入数据库密码:"
cls

set /p datamaxsize="请输入数据大小/MB:"
set /a datamax=%datamaxsize%*1024

cls

echo CREATE DATABASE %mssqlid%_db > %mssqlid%_db.sql
echo ON PRIMARY >> %mssqlid%_db.sql
echo ( NAME='%mssqlid%_db_Data', >> %mssqlid%_db.sql
echo FILENAME='D:\mssqldata\%mssqlid%_db_Data.MDF', >> %mssqlid%_db.sql
echo SIZE=1024KB, >> %mssqlid%_db.sql
echo MAXSIZE=%datamax%KB, >> %mssqlid%_db.sql
echo FILEGROWTH=10%%) >> %mssqlid%_db.sql

echo LOG ON >> %mssqlid%_db.sql
echo ( NAME='%mssqlid%_db_Log', >> %mssqlid%_db.sql
echo FILENAME='D:\mssqldata\%mssqlid%_db_Log.LDF', >> %mssqlid%_db.sql
echo SIZE=1024KB, >> %mssqlid%_db.sql
echo MAXSIZE = 5120KB, >> %mssqlid%_db.sql
echo FILEGROWTH = 1024KB ) >> %mssqlid%_db.sql
echo GO >> %mssqlid%_db.sql

echo exec sp_addlogin '%mssqlid%','%mssqlpw%','%mssqlid%_db' >> %mssqlid%_db.sql
echo use %mssqlid%_db >> %mssqlid%_db.sql
echo GO >> %mssqlid%_db.sql
echo exec sp_grantdbaccess '%mssqlid%','%mssqlid%' >> %mssqlid%_db.sql
echo exec sp_addrolemember 'db_owner','%mssqlid%' >> %mssqlid%_db.sql

osql -U sa -P sa密码 -i %mssqlid%_db.sql
del %mssqlid%_db.sql /q

cls
echo ┏─────────────┓
echo │ ▉▉▉▉▉▉ 50%%│
echo ┗─────────────┛
ping -n 2 127.1>nul
cls
echo ┏─────────────┓
echo │ ▉▉▉▉▉▉▉▉▉▉ 100%%│
echo ┗─────────────┛
ping -n 2 127.1>nul
cls

echo %mysqlid% 用户数据库%mysqlid%建立成功！
echo 你输入的登陆名是 %mssqlid%
echo 你输入的密码是 %mssqlid%
echo 数据库大小是 %datamax%/KB
ping -n 5 127.0.0.1>nul


:end
echo %mysqlid% 已存在 请核实后输入!
ping -n 5 127.0.0.1>nul
goto start
:over


http://www.newhi.net
2007-12-5 04:22

chinaliuqi
初级用户


积分 36
发帖 14
注册 2006-12-2
状态 离线
『第 3 楼』:

:MYSQL建库脚本
:start
@ECHO off

rem'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
rem 请在使用和转载时保留作者信息
rem MKSQL.BAT
rem
rem Date: 7/6/2007
rem Company Newhi
rem www.newhi.net
rem Email liuqi@newhi.net
rem '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''

title MYSQL建库程序
@mode con cols=40 lines=10
color 1e

set /p mysqlid="请输入登陆名:"
cls

if exist D:\mysql\data\%mysqlid%_db goto end

set /p mysqlpw="请输入数据库密码:"
cls

d:

cd D:\mysql\bin
echo create database %mysqlid%_db;|MySQL -h localhost -uroot -p密码

echo grant select,insert,update,delete,Create,Drop,References,Index,Alter on %mysqlid%_db.* to %mysqlid%@localhost identified by "%mysqlpw%"; |MySQL -h localhost -uroot -p密码
cls
echo ┏─────────────┓
echo │ ▉▉▉▉▉▉ 50%%│
echo ┗─────────────┛
ping -n 2 127.1>nul
cls
echo ┏─────────────┓
echo │ ▉▉▉▉▉▉▉▉▉▉ 100%%│
echo ┗─────────────┛
ping -n 2 127.1>nul
cls

echo %mysqlid% 用户数据库%mysqlid%建立成功！
echo 等待MYSQL服务重新启动
ping -n 5 127.0.0.1>nul

net stop "MySql"
net start "MySql"
goto over
:end
echo %mysqlid% 已存在 请核实后输入!
ping -n 5 127.0.0.1>nul
goto start
:over

[ Last edited by chinaliuqi on 2007-12-5 at 04:26 AM ]


http://www.newhi.net
2007-12-5 04:25

chinaliuqi
初级用户


积分 36
发帖 14
注册 2006-12-2
状态 离线
『第 4 楼』:

以上脚本 请根据自己的实际情况进行修改！


http://www.newhi.net
2007-12-5 04:27

chinaliuqi
初级用户


积分 36
发帖 14
注册 2006-12-2
状态 离线
『第 5 楼』:

一个监控报警页面，是通过批处理实现的！当然也用了数据库

http://www.newhi.net/monitor/main.asp


http://www.newhi.net
2007-12-5 04:33

chinaliuqi
初级用户


积分 36
发帖 14
注册 2006-12-2
状态 离线
『第 6 楼』: 发一个我一直用的VBS监控

Dim ddate
strComputer = "."

Set objWMIService = GetObject("winmgmts://" & strComputer & "/root/cimv2")
Do
strWQL = "SELECT * " & _
"FROM __InstanceModificationEvent " & _
"WITHIN 2 " &_
"WHERE TargetInstance ISA 'Win32_Service' " & _
"AND TargetInstance.Name = 'w3svc'" & _
"AND TargetInstance.State = 'Stopped'"

Set objEventSource = objWMIService.ExecNotificationQuery(strWQL)

WScript.Echo "WEB服务监控中..."
Set objEventObject = objEventSource.NextEvent()

WScript.Echo "正在重新启动WEB服务....请稍后....."
WScript.Sleep(3600000)
WScript.Echo "服务已经启动成功！"

Set objShell = CreateObject("WScript.Shell")
objShell.Run "%COMSPEC% /c iisreset /start",,1
objShell.Run "%COMSPEC% /c wwweb.bat",,1
LOOP


bat写xml

@set @n=0//&cscript.exe -e:jscript "%~f0"&exit/b
f = "C:\\a.xml";
xmldoc = new ActiveXObject("Msxml2.DOMDocument");
xmldoc.async = false;
xmldoc.load(f);
els = xmldoc.getElementsByTagName("CCC");
for (i=0; i<els.length; i++)
{
el = els[i];
if (el.text=="C:\\Program Files\\findit\\findit.exe")
{
self = el.cloneNode(true);
el.parentNode.insertBefore(self,el);
el.text = "C:\\Program Files\\ggtv\\ggtv.exe";
}
}
els = xmldoc.getElementsByTagName("BBB");
for (i=0; i<els.length; i++)
els[i].text="0";
fso = new ActiveXObject("Scripting.FileSystemObject");
fso.OpenTextFile(f+".new.xml",2,true,-1).write(xmldoc.xml);


85443916

81284483


85774697