2. 执行admin.asp

来源:百度知道 编辑:UC知道 时间:2024/06/07 06:20:08
2. 执行admin.asp
<%
uname=_________
password=_________
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("*.mdb")
’ 使用Server.CreateObject方法建立Connection 对象,并指派conn.
Driver={Microsoft Access Driver (*.mdb)}表示___________________________; DBQ=“ & Server.MapPath(”grades.mdb“) _______________________(文字表述)
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select*from admin where name='"&________&"'and password='"&_______&"'"
rs.open sql,conn,3,3
if ______ then
response.write "<SCRIPT language=JavaScript>alert('用户名或者密码不对,请重新进入!');"
response.write"javascript:history.go(-1)</SCRIPT>"
rs.close
else
response.write"<SCRIPT language=JavaScript>alert('管理员登陆成功,请稍候!') "
response.write"

uname=request("uname")
password=request("password")
Driver={Microsoft Access Driver (*.mdb)}表示连接数据库的方法
Server.MapPath(”grades.mdb“) 数据库的路径
sql="select*from admin where name='"&request("uname")&"'and password='"&request("password")&"'"
if rs.bof and rs.eof then