口袋妖怪黑2怪河马:数据库链接的方法
来源:百度文库 编辑:高校问答 时间:2024/10/05 08:19:45
<%
Dim connstr
connstr="provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & Server.MapPath("tushu.mdb")
Set bb = Server.CreateObject("ADODB.Connection")
bb.Open connstr
%>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-ch">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>查询表单</title>
</head>
<body><%
set rs = server.CreateObject("adodb.recordset")
rs.open "select * from user ",bb
%>
<%=rs("name")%>
<%=rs("jg")%>
<%=rs("zz")%>
</body>
</html>
不知道那错了,给看看行吗?
我用的是 Frontpage
Dim connstr
connstr="provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & Server.MapPath("tushu.mdb")
Set bb = Server.CreateObject("ADODB.Connection")
bb.Open connstr
%>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-ch">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>查询表单</title>
</head>
<body><%
set rs = server.CreateObject("adodb.recordset")
rs.open "select * from user ",bb
%>
<%=rs("name")%>
<%=rs("jg")%>
<%=rs("zz")%>
</body>
</html>
不知道那错了,给看看行吗?
我用的是 Frontpage