userpass.asp

《Web数据库技术》-高晗-vod点播系统程序源代码

<!--#include file="conn.asp"-->
<%
dim rs
dim sql
userid=replace(trim(request("userid")), "'", "''")
password=replace(trim(Request("password")), "'", "''")
sql="select * from users where userid='"&userid&"'and password='"&password&"'"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,3
if rs.bof and rs.eof then
	response.write"<script>alert('用户名或密码错误，不接受！');history.back();</Script>"
  response.end
end if
Dim userip 
userip=Request.ServerVariables("REMOTE_ADDR")'取得提交登陆信息用户的IP
response.cookies("userid")=rs("userid")
response.cookies("password")=rs("password")
response.cookies("userip")=userip
rs.close
set rs=nothing
conn.close
set conn=nothing
response.redirect Request.ServerVariables("HTTP_REFERER")
 %>