贴完隐形车衣注意什么:javascript高手请帮忙~

来源:百度文库 编辑:杭州交通信息网 时间:2024/04/23 17:35:45
请问在js脚本页面如何访问数据库?
楼下的哥们,我这是编程,不是IT故障啊!~~~~

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>

<body>
<script language="JavaScript" type="text/JavaScript">
var objdbConn=new ActiveXObject("ADODB.Connection");
var strdsn="DRIVER{Microsoft Access Driver(*.mdb)};"+"DBQ=C:\\books.mdb";
objdbConn.Open(strdsn);
var objrs=objdbConn.Execute("SELECT * FROM book");
var fdCount=objrs.Fields.Count-1;
if(!objrs.EOF)
{
document.write("<table border=1><tr>");
for (var i=0;i<=fdCount;i++)
document.write("<td><b>"+objrs.Fields(i).Name+"</b></td>");
document.write("</tr>");
while(!objrs.EOF){
document.write("<tr>");
for (i=0;i<=fdCount;i++)
document.write("<td valign='top'>"+objrs.Fields(i).Value+"</td>");
document.write("</tr>");
objrs.moveNext();
}
document.write("</table>");
}
else
document.write("数据库内没有记录!<br>");
objrs.Close();
objdbConn.Close();
</script>

</body>
</html>

script language="javascript" runat="server">
var conn=new ActiveXObject("Adodb.Connection");
var rs=new ActiveXObject("Adodb.Recordset");
conn.ConnectionString="provider=Microsoft.Jet.OLEDB.4.0;data source=db1.mdb";
conn.Open();
rs.LockType=rs.CursorType=1;
rs.ActiveConnection=cn;
rs.Source="SELECT username FROM USERS";
rs.Open();
if(!rs.EOF){
rows=rs.GetRows();
for(var i=0;i<=rows.ubound(2);i++){
Response.Write(rows.getItem(0,i)+"<br />");//循环输出用户名
}
}else{
rs.Close();
}
</script>