hotellogin.asp

ASP程序实现的酒店预定系统

<!--#include file="../../include/adoconn.asp"-->

<%
set rs=server.createobject("adodb.recordset")
strsql="select 呢称 from xt_td_User where 会员卡号='"+trim(request("username"))+"' and 密码='" & trim(request("password")) & "'"
set rs=conn.execute(strsql)
'检测是否员工
set rs1=server.createobject("adodb.recordset")
strsql="select 姓名 from xt_td_worker where 员工编码='"+trim(request("username"))+"' and 密码='" & trim(request("password")) & "'"
set rs1=conn.execute(strsql)

sName=""
if not rs.eof then   sName=rs(0)
if not rs1.eof then   sName=rs1(0)

if sName="" then
%>
<%
    sqlRs=" Select * From xt_td_hotel Where 酒店编码=" & request("hotel_id") &"
    set rst2=conn.execute(sqlrs)
     
%>
            <script Language="JavaScript">
            <!--
            alert("卡号或密码输入错误!");
            history.back(-1);
            // -->
            </script>

<%
else
	session("UID")=trim(request("username"))
	session("Name")=sName
	if len(trim(request("username")))<>5 then
  	   response.redirect("hotel_order.asp?hotel_id=<%=rst2("酒店编码")%>")
  	else
  	   response.redirect("../Manager/Manager.htm")
  	end if   
end if
%>