?? showuser.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"> </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--> </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"> </td>
<td width="254" valign="middle" align="center"><!--DWLayoutEmptyCell--> </td>
<td width="338"> </td>
</tr>
</table></td>
</tr>
<tr>
<td height="23"> </td>
<td> </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>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -