如何使用JAVASCRIPT从sqlserver数据库中获得数据?

如题.
请各位高人指教!
分不够,可以加.
---------------------------------------------------------------

var conn = new ActiveXObject("ADODB.Connection");
conn.Open("Data Source=190.190.200.100,1433;Initial Catalog=pubs;User ID=sa;Password=asdasd;");

var strSQL = "Select * From Data";

var rs = new ActiveXObject("ADODB.Recordset");
rs.CursorType = 3; //adOpenStatic
rs.LockType = 1; //adLockReadOnly
rs.Open(strSQL, conn)

---------------------------------------------------------------

可以的，你试试

 1<html>
 2<head>
 3<title>表格显示数据表记录</title>
 4</head>
 5<body>
 6<h2>表格显示数据表记录</h2>
 7<hr/>
 8<script language="JavaScript">   
 9// 创建数据库对象   
10var objdbConn = new ActiveXObject("ADODB.Connection");   
11// DSN字符串   
12var strdsn = "Driver={SQL Server};Server=127.0.0.1;Database=study;UID=sa;PWD=";   
13// 打开数据源   
14objdbConn.Open(strdsn);   
15// 执行SQL的数据库查询   
16var objrs = objdbConn.Execute("select * from student");   
17// 获取字段数目   
18var fdCount = objrs.Fields.Count - 1;   
19// 检查是否有记录   
20if (!objrs.EOF){   
21document.write("<table border=1><tr>");   
22// 显示数据库的字段名称   
23for (var i=0; i <= fdCount; i++)   
24document.write("<td><b>" + objrs.Fields(i).Name + "</b></td>");   
25document.write("</tr>");   
26// 显示数据库内容   
27while (!objrs.EOF){   
28document.write("<tr>");   
29// 显示每笔记录的字段   
30for (i=0; i <= fdCount; i++)   
31document.write("<td valign='top'>" + objrs.Fields(i).Value + "</td>");   
32document.write("</tr>");   
33objrs.moveNext(); // 移到下一笔记录   
34}   
35document.write("</table>");   
36}   
37else   
38document.write("数据库内没有记录!<br>");   
39objrs.Close(); // 关闭记录集合   
40objdbConn.Close(); // 关闭数据库链接   
41</script>
42</body>
43</html>

---------------------------------------------------------------

楼上提到的都是使用adodb的方式访问，对于sql server 2000，你可以去参考SQLXML ，这里提供了一个isapi用来支持sql server在iis上的直接查询和修改

具体的内容应该是这几个方面
1.允许url查询
2.允许模板
3.允许XPath
4.允许Post
具体资料你参考sqlxml 3.0，在.net环境下还实现托管类
---------------------------------------------------------------

 1<script language="javascript">   
 2var conn = new ActiveXObject("ADODB.Connection");   
 3conn.Open("Data Source=202.117.148.134,1433;Initial Catalog=xb;User ID=xb;Password=xb;");   
 4  
 5var strSQL = "Select * From words";   
 6  
 7var rs = new ActiveXObject("ADODB.Recordset");   
 8rs.CursorType = 3; //adOpenStatic   
 9rs.LockType = 1; //adLockReadOnly   
10rs.Open(strSQL, conn)   
11</script>

---------------------------------------------------------------

js从数据库中读数据--测试成功:

1<br/>

 1<script language="javascript">   
 2var conn = new ActiveXObject("ADODB.Connection");   
 3conn.Open("Provider=sqloledb; server=202.117.148.162; uid=xb; pwd=xb; database=xb");   
 4var strSQL = "Select * From article";   
 5  
 6var rs = new ActiveXObject("ADODB.Recordset");   
 7rs.CursorType = 3; //adOpenStatic   
 8rs.LockType = 1; //adLockReadOnly   
 9rs.Open(strSQL, conn)   
10  
11var fdCount = rs.Fields.Count - 1; // 检查是否有记录   
12if (!rs.EOF)   
13{   
14document.write("<table border=1><tr>");   
15for (var i=0; i <= fdCount; i++)   
16document.write("<td><b>" + rs.Fields(i).Name + "</b></td>");   
17document.write("</tr>");   
18  
19while(!rs.EOF)   
20{ document.write("<tr>");   
21for (i=0; i <= fdCount; i++)   
22document.write("<td valign='top'>" + rs.Fields(i).Value + "</td>");   
23document.write("</tr>");   
24rs.moveNext(); // 移到下一笔记录   
25}   
26document.write("</table>");   
27}   
28else   
29{ document.write("数据库内没有记录!<br>"); }   
30  
31rs.Close(); // 关闭记录集合   
32conn.Close(); // 关闭数据库链接   
33</script>