nbsp;html public "-//w3c//dtd xhtml 1.0 transitional//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-transitional.dtd">
无标题文档
<script> <br />var objdbconn=new activexobject("adodb.connection"); <br />var strdsn = "driver={sql server};server=.;uid=sa;pwd=123;database=pointcard"; <br />objdbconn.open(strdsn); <br />var objrs=objdbconn.execute("select [head] from news"); <br />var fdcount=objrs.fields.count-1; <br />if(!objrs.eof) <br />{ <br />document.write("<table border=1><tr>"); <br /> for (var i=0;i<=fdcount;i++) <br /> document.write("<td><b>"+objrs.fields(i).name+""); <br /> document.write(""); <br /> while(!objrs.eof){ <br /> document.write("<tr>"); <br /> for (i=0;i<=fdcount;i++) <br /> document.write("<td valign='top'>"+objrs.fields(i).value+""); <br /> document.write(""); <br /> objrs.movenext(); <br /> } <br /> document.write(""); <br /> } <br /> else <br /> document.write("数据库内没有记录!<br>"); <br /> objrs.close(); <br /> objdbconn.close(); <br /> </script>
回复讨论(解决方案)
new ActiveXObject("ADODB.Connection");
这个对象只有ie才支持,火狐不支持