check.asp

来自「网上订房」· ASP 代码 · 共 24 行

<!--#include file="conn.asp"-->
<%
dim uid ,upwd
uid=trim(Request.Form("uid"))
upwd=trim(Request.Form("pwd"))

set rs=server.createobject("adodb.recordset")
sqltext="select * from userb where userid='" & uid & "' and password='" & upwd & "'"
rs.open sqltext,conn,1,1

'查找数据库，检查用户名是否存在
if rs.recordcount >= 1 then 
      session("user")=rs("userid")
      strSQL="update userb set loginnum=loginnum+1,pretime=now() where userid='"&uid&"'"
	  conn.Execute strSQL
      Response.Redirect "OrderHotel.asp"   
 	  response.end
 	  rs.close
	else
	 Response.Redirect "messagebox.asp?msg=您输入了错误的帐号或口令，请再次输入！" 
	 response.end
     rs.close
end if
%>