本文介绍了一种使用ActiveX对象（SWbemLocator）连接到本地SQL Server实例并执行查询的方法。通过示例代码展示了如何获取SQL Server上的数据库名称，并将结果以HTML表格的形式展示。
<!DOCTYPE HTML PUBLIC "-//W3C//DTDHTML4.0Transitional//EN">
<html>
<head>
<title></title>
<metaname="GENERATOR"content="MicrosoftVisualStudio.NET7.1">
<metaname="vs_targetSchema"content="http://schemas.microsoft.com/
intellisense/ie5">
<scriptid="clientEventHandlersJS"language="javascript">
<!--
functionButton1_onclick(){
varlocator=newActiveXObject("WbemScripting.SWbemLocator");
varservice=locator.ConnectServer(".","rootMicrosoftSQLServer");
varproperties=service.ExecQuery("SELECTNameFROMMSSQL_Database");
vare=newEnumerator(properties);
document.write("<tableborder=1>");
dispHeading();
for(;!e.atEnd();e.moveNext())
{
varp=e.item();
document.write("<tr>");
document.write("<td>"+p.Name+"</td>");
document.write("<td>"+p.SQLServerName+"</td>");
document.write("</tr>");
}
document.write("</table>");
}
functiondispHeading()
{
document.write("<thead>");
document.write("<td>Name</td>");
document.write("<td>SQLServerName</td>");
document.write("</thead>");
}
//-->
</script>
</head>
<body> <INPUTid="Button1"type="button"value="Button"name="Button1"
language="javascript"onclick="returnButton1_onclick()">
</body>
</html>
用JAVASCRIPT连接sql server数据库
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
