showuser.asp

随着计算机技术的广泛应用,在酒店客房管理中引入计算机管理技术,成为一个值得深入研究的问题。本系统采用ASP+ACCESS作为开发环境,本文首先概要的论述了ASP的有关知识与现状。之后

<!--#include file="../inc/conn.asp"-->
<!--#include file="checkpwd.asp"-->
<!--#include file="../inc/title.inc"-->
<style>
TD {
	FONT-SIZE: 9pt
; color: #000000
}
</style>
<%
 'set rs=server.CreateObject("adodb.recordset")
num=trim(request.Form("num"))'证件号'此字段不能用no名否则用做关键字查询时无法查询
'x="342423198403075457"
sql="select * from [book] where num='"&num&"'"
'response.Write(sql)
'rs.open sql,conn,1,1
set rs=conn.execute(sql)
'response.Write rs("nam")
'conn.close
%>
<table width="788" border="0" cellpadding="0" cellspacing="1">
  <!--DWLayoutTable-->
  <tr> 
    <td width="786" height="59">&nbsp;</td>
  </tr>
  <tr> 
    <td height="422" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#3399FF">
        <!--DWLayoutTable-->
        <tr> 
          <td width="784" height="422" valign="top"> <form action="tuifang.asp" method="post">
              <table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
                <!--DWLayoutTable-->
                <tr> 
                  <td height="23" align="center" valign="middle" bgcolor="#3333CC"><font color="#FFFFFF" face="楷体_GB2312"><strong>用户资料</strong></font></td>
                </tr>
                <tr> 
                  <td width="784" height="369"><table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#333399">
                      <!--DWLayoutTable-->
                      <tr> 
                        <td height="23" colspan="2" align="center" valign="middle"><!--DWLayoutEmptyCell-->&nbsp;</td>
                        <td width="2"></td>
                      </tr>
                      <tr> 
                        <td width="314" height="28"  align="right" valign="middle"bgcolor="#FFFFFF">姓名：</td>
                        <td width="464"  align="left" valign="middle"bgcolor="#FFFFFF"> 
                          <font color="#FF0000"> 
                          <% response.Write rs("nam")%>
                          </font></td>
                        <td></td>
                      </tr>
                      <tr> 
                        <td height="28" align="right" valign="middle" bgcolor="#FFFFFF">性别：</td>
                        <td align="left" valign="middle" bgcolor="#FFFFFF"><font color="#FF0000"><%=rs("sex")%></font></td>
                        <td></td>
                      </tr>
                      <tr> 
                        <td height="28" align="right" valign="middle" bgcolor="#FFFFFF">年龄：</td>
                        <td  align="left" valign="middle"bgcolor="#FFFFFF"><font color="#FF0000"><%=rs("eage")%> 
                          </font></td>
                        <td></td>
                      </tr>
                      <tr> 
                        <td height="29" align="right" valign="middle" bgcolor="#FFFFFF">证件:</td>
                        <td align="left" valign="middle" bgcolor="#FFFFFF"><font color="#FF0000"><%=rs("cn")%> 
                          </font></td>
                        <td></td>
                      </tr>
                      <tr> 
                        <td height="28" align="right" valign="middle" bgcolor="#FFFFFF">证件号：</td>
                        <td align="left" valign="middle" bgcolor="#FFFFFF"><font color="#FF0000"><%=rs("zhengjianh")%> 
                          <input name="hiddenField" type="hidden" value="<%=rs("zhengjianh")%>">
                          </font></td>
                        <td></td>
                      </tr>
                      <tr> 
                        <td height="28" align="right" valign="middle" bgcolor="#FFFFFF">国籍：</td>
                        <td align="left" valign="middle" bgcolor="#FFFFFF"><font color="#FF0000"><%=rs("guoji")%> 
                          </font></td>
                        <td></td>
                      </tr>
                      <tr> 
                        <td height="28"align="right" valign="middle" bgcolor="#FFFFFF">工作单位：</td>
                        <td align="left" valign="middle" bgcolor="#FFFFFF"><font color="#FF0000"><%=rs("danwei")%> 
                          </font></td>
                        <td></td>
                      </tr>
                      <tr> 
                        <td height="28" align="right" valign="middle" bgcolor="#FFFFFF">到达时间：</td>
                        <td align="left" valign="middle" bgcolor="#FFFFFF"><font color="#FF0000"><%=rs("dtime")%> 
                          </font></td>
                        <td></td>
                      </tr>
                      <tr> 
                        <td height="28" align="right" valign="middle" bgcolor="#FFFFFF">离开时间：</td>
                        <td align="left" valign="middle" bgcolor="#FFFFFF"> <font color="#FF0000"><%=rs("ltime")%></font></td>
                        <td></td>
                      </tr>
                      <tr> 
                        <td height="28" align="right" valign="middle" bgcolor="#FFFFFF">人数</td>
                        <td align="left" valign="middle" bgcolor="#FFFFFF"><font color="#FF0000"><%=rs("renshu")%> 
                          </font></td>
                        <td></td>
                      </tr>
                      <tr> 
                        <td height="28" align="right" valign="middle" bgcolor="#FFFFFF">email</td>
                        <td align="left" valign="middle" bgcolor="#FFFFFF"><font color="#FF0000"><%=rs("emal")%> 
                          </font></td>
                        <td></td>
                      </tr>
                      <tr> 
                        <td height="28" align="right" valign="middle" bgcolor="#FFFFFF">联系电话</td>
                        <td align="left" valign="middle" bgcolor="#FFFFFF"><font color="#FF0000"><%=rs("tel")%></font></td>
                        <td></td>
                      </tr>
                      <tr> 
                        <td height="28" align="right" valign="middle" bgcolor="#FFFFFF">房间类型</td>
                        <td align="left" valign="middle" bgcolor="#FFFFFF"><font color="#FF0000"><%=rs("roomid")%> 
                          <input name="roomid" type="hidden" id="roomid" value="<%=rs("roomid")%>">
                          </font></td>
                        <td></td>
                      </tr>
                      <tr> 
                        <td height="28" align="right" valign="middle" bgcolor="#FFFFFF">房间数</td>
                        <td align="left" valign="middle" bgcolor="#FFFFFF"><font color="#FF0000"><%=rs("roomnum")%> 
                          </font></td>
                        <td></td>
                      </tr>
                      <tr> 
                        <td height="29" valign="middle" align="right" bgcolor="#FFFFFF">订单号</td>
                        <td valign="middle" align="left" bgcolor="#FFFFFF"><font color="#FF0000"><%=rs("num")%>
                          <input name="ddhao" type="hidden" id="ddhao" value="<%=rs("num")%>">
                          </font></td>
                        <td></td>
                      </tr>
                      <tr> 
                        <td height="31" valign="middle" align="right"bgcolor="#FFFFFF">确认状态</td>
                        <td valign="middle" align="left" bgcolor="#FFFFFF"><font color="#FF0000"> 
                          <%
						'response.Write rs("")
						if rs("chk") then
						response.Write("房间已开！")
						else 
						response.Write("尚未开房！")
						end if %>
                          </font></td>
                        <td></td>
                      </tr>
                      <tr> 
                        <td height="63" align="right" valign="middle" bgcolor="#FFFFFF">其他要求：</td>
                        <td valign="top" bgcolor="#FFFFFF"><font color="#FF0000"><%=rs("other")%></font></td>
                        <td></td>
                      </tr>
                      <tr> 
                        <td height="27" valign="middle" align="right" bgcolor="#FFFFFF">房间号：</td>
                        <td valign="middle" align="left" bgcolor="#FFFFFF"><font color="#FF0000">
						<%
						if rs("fangjh")="" then 
						response.Write("已退房！")
						else
						response.Write rs("fangjh")
						end if
						%>
                          <input name="fangjh" type="hidden" id="fangjh" value="<%=rs("fangjh")%>">
                          </font></td>
                        <td></td>
                      </tr>
                      <tr> 
                        <td height="32" colspan="3" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
                            <!--DWLayoutTable-->
                            <tr> 
                              <td width="190" height="32">&nbsp;</td>
                              <td width="254" valign="middle" align="center"><!--DWLayoutEmptyCell-->&nbsp;</td>
                              <td width="338">&nbsp;</td>
                            </tr>
                          </table></td>
                      </tr>
                      <tr>
                        <td height="23">&nbsp;</td>
                        <td>&nbsp;</td>
                        <td></td>
                      </tr>
                    </table></td>
                </tr>
                <tr> 
                  <td height="30"  align="right" valign="top"bgcolor="#3333CC"><font color="#FFFFFF">2007-9</font></td>
                </tr>
              </table>
            </form></td>
        </tr>
      </table></td>
  </tr>
  <tr> 
    <td height="1"></td>
  </tr>
</table>