room.asp

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

<!--#include file="head.asp"-->
<!--#include file="conn.asp"-->
<table width="967" border="0" cellpadding="0" cellspacing="0">
  <!--DWLayoutTable-->
  <tr> 
    <td width="236" height="172" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#0000FF">
        <!--DWLayoutTable-->
        <tr> 
          <td width="234" height="169" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
              <!--DWLayoutTable-->
              <tr> 
                <td width="234" height="169" valign="top"><!--#include file="gogao.asp"--></td>
              </tr>
            </table></td>
        </tr>
      </table></td>
    <td width="731" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#0000FF" >
        <%
		sql="select * from [room]"
        set rs=conn.execute(sql)
		do while not rs.eof
		%>
        <tr > 
          <td width="197" height="16" valign="top" bgcolor="#FFFFFF"><%=rs("roomnam")%></td>
          <td width="531" rowspan="2" valign="top" bgcolor="#FFFFFF"><%=rs("descrip")%></td>
        </tr>
        <tr > 
          <td height="135" valign="top" bgcolor="#FFFFFF"><img src="imgs/scoll13.jpg" width="198" height="135"></td>
        </tr>
        <tr > 
          <td height="17" valign="top" bgcolor="#FFFFFF">剩余：<font color="#FF0000"><%=rs("lnum")%>间</font></td>
          <td valign="top" bgcolor="#FFFFFF">单价：<font color="#FF0000"><%=rs("pric")%>元</font></td>
        </tr
		><%
		rs.movenext
		loop
		%>
      </table></td>
  </tr>
  <tr> 
    <td height="182">&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
</table>
<!--#include file="inc/copyright.inc"-->