- 论坛徽章:
- 1
|
搞定.
myAccount = trim(request("username"))
myPass = trim(replace(request("Password"),"'",""))
set Conn = Server.CreateObject("Adodb.Connection")
Connstr = "Driver={SQL Server};Server=cylong;UID=sa;PWD=;Database=生产管理"
Conn.open connstr
CheckSql = "SELECT * FROM 用户 WHERE 用户名 = '"&myAccount&"'"
set checkRs = Server.CreateObject("Adodb.Recordset")
checkRs.Open CheckSql,Conn,1,1
if checkRs.eof then
response.write "<script language=javascript>alert('对不起用户不存在');history.back(-1)</script>"
else
if checkRS("密码") = '"&myPass&"' then
session("TYPE")=checkRs("types")
else
response.write "<script language=javascript>alert('对不起密码错误');history.back(-1)</script>"
end if
end if
checkRs.close
conn.close
Select Case session("type")
Case "1"
response.redirect "1.asp"
Case "2"
response.redirect "2.asp"
Case "3"
response.redirect "3.asp"
end select |
|