JS+sqlserver查询到的数据怎么显示啊
投稿人：zengdddd
- <script runat="server" language="javascript">
- //用 javascript 写服务器端连接数据库的代码示例
- var conn = new ActiveXObject("ADODB.Connection");
- conn.Open("Provider=Sqloledb; Data Source=数据库地址; User ID=用户名; " + "Password=密码; Initial Catalog=数据库名");
- var rs = new ActiveXObject("ADODB.Recordset");
- var sql="select * from zd_user";
- rs.open(sql, conn);
- shtml = "<table width='100%' border=1>";
- shtml +="<tr bgcolor='#f4f4f4'><td>id</td><td>username</td><td>password</td><td>email</td><td>address</td><td>answer</td><td>fax</td></tr>";
- while(!rs.EOF) {
- shtml += "<tr><td>" + rs("id") + "</td><td>" + rs("username") + "</td><td>" + rs("password") + "</td><td>" + rs("email") + "</td><td>" + rs("address") + "</td><td>" + rs("answer") + "</td><td>" + rs("fax") + "</td></tr>";
- rs.moveNext;
- }
- shtml += "</table>";
- rs.close();
- rs = null;
- conn.close();
- conn = null;
- </script>
下面的能在DIV层里面显示吗
<%=shtml%>
查出来的数据怎么显示啊