asp文件打不开,应该是代码错了,提示一直徘徊在第10行和第11行即
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(""&db&"")
conn.Open Connstr
查了百度也按照里面的要求改也弄不了
下面是全部代码,其他部分有没有错误也不太清楚。第一次连接后台数据库,请各位大佬海涵,真的不会,一个作业已经做了4天,没有进展,整个人处于崩溃状态。谢谢大家了!
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
dim conn
dim connstr
dim dbstr
db="C:\Users\1\Documents"
dbstr="school.mdb"
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(""&db&"")
conn.Open Connstr
dim rs
set rs=server.createobject("adodb.recordset")'???
sub close_conn '?????
conn.close
set conn = nothing
end sub
sub close_rs '???
rs.close
set rs = nothing
end sub
dim User,Pwd,Schno,Schname,Sex,Class,Phone,Oicq,email
User = trim(request.form("User"))
Pwd = trim(request.form("Pwd"))
Schno = trim(request.form("Schno"))
Schname = trim(request.form("Schname"))
Sex = trim(request.form("Sex"))
Class = trim(request.form("Class"))
Phone = trim(request.form("Phone"))
Oicq = trim(request.form("Oicq"))
email = trim(request.form("email"))
sql = "select * from users"
if action=1 then
rs.open sql,conn,1,3
rs.addnew
rs("User")=User
rs("Pwd")=Pwd
rs("Schno")=Schno
rs("Schname")=Schname
rs("Sex")=Sex
rs("Class")=Class
rs("Phone")=Phone
rs("Oicq")=Oicq
rs("email")=email
rs.update
call close_conn
response.write "<script>alert('???,????!');location.href=login1.asp'</script>"
end if
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>?????</title>
</head>
<body>
<form action="" method="get">
<table width="400" border="1" align="center" cellspacing="0" bgcolor=#EEEEEE>
<tr>
<td align="center"><strong>??????</strong></td>
</tr>
<tr>
<td>???:<input type="nvarchar" name="User"></td>
</tr>
<tr>
<td>??:<input type="nvarchar" name="Pwd"></td>
</tr>
<tr>
<td>??:<input type="bigint" name="Schno"></td>
</tr>
<tr>
<td>??:<input type="nvarchar" name="Schname"></td>
</tr>
<tr>
<td>??:<input type="nvarchar" name="Sex"></td>
</tr>
<tr>
<td>??:<input type="nvarchar" name="Class"></td>
</tr>
<tr>
<td>??:<input type="nvarchar" name="Phone"></td>
</tr>
<tr>
<td valign="middle">QQ?:<input type="bigint" name="Oicq"></td>
</tr>
<tr>
<td>????:<input type="nvarchar" name="email"></td>
</tr>
<tr>
<td align="center" height="30" valign="middle"> <input type="submit" name="??" id="??" value="??" />
<input type="submit" name="??" id="??" value="??" /></td>
</tr>
</table>
</form>
</body>
</html>