<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%>
查出来的数据怎么显示啊
//用 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%>
查出来的数据怎么显示啊
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货