借花献佛
<%
UserName = Request.Form( "UserName" )
If UserName = "" Then
Errmsg = "请输入用户名"
Else
'=============连接数据库===============
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.ConnectionString="driver={SQL Server};server=localhost;UID=sa;PWD=admin;Database=pubs"
'连接数据库
Conn.Open
'============从表Users中读取用户数据==============
'定义Recordset对象
Set rs=Server.CreateObject("ADODB.Recordset")
'设置Connection对象的ConnectionString
'设置rs的ActiveConnection属性,绑定到连接
Set rs.ActiveConnection = Conn
'设置游标类型
rs.CursorType = 3
'打开记录集
rs.Open "SELECT * FROM authors WHERE au_id='" & Trim(UserName) & "'"
'=============身份验证===========================
If rs.EOF Then
Errmsg = "用户不存在"
Response.write ErrMsg
Else
If trim(UserPwd) <> trim(rs.Fields("au_lname")) Then
Errmsg = "密码不正确"
Response.write ErrMsg
Else '登录成功
Session("UserId") = rs.Fields("au_lname")
Response.Write("登录成功,请进入<a href=adminindex.asp>首页</a>")
End If
End If
End If