28,409
社区成员




<%
dim id,pwd,sql,conn
id = trim(request.form("id"))
pwd = trim(request.form("pwd"))
set conn = server.CreateObject("adodb.connection")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq="& Server.MapPath("\liuyan2\db\notebook.mdb")
set rs = server.CreateObject("adodb.recordset")
sql="select * from users where id='"&id&"' and pwd='"& pwd &"'"
rs.open sql,conn,1,1
if not rs.eof then
response.write("登录成功!")
session("UserName") =id
session.Timeout = 20
else
response.write("<script language='javascript' type='text/javascript'>alert('用户名或密码错误!');history.go(-1);</script>")
end if
%>
Sub ULogin()
userName = request.Form("userName")'用户名
pwd = MD6(request.Form("pwd")) '密码
yzm = request.Form("yzm") '用户名
if dbRs(0,"select id,bugName,isoff,utype from userInfo where bugName = '"& userName &"' and bugPwd = '"& pwd &"'") = "0" then
call ShowAlert("错误提示:用户名或密码错误,请重新输入!",xurl)
else
if rs("isoff") = 1 then ShowAlert "提示:您的用户已被禁用,如需登陆,请与管理员联系!","login.asp"
session("bugUName") = rs("bugName")
session("utype") = rs("utype")
session("bugUID") = rs("id")
session.Timeout = 20
call ShowAlert("提示:登录成功!","index.asp")
end if
call dbconn(2)'关闭记录集rs
End sub