📄 checkout.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%@ page import="java.sql.*"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>客人退房＆换房</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<jsp:useBean id="checkout" scope="session" class="db.DBCon" />
<body background="images/kite.gif">
<script language="javascript">
function del(){
<%
ResultSet rs_del=null;
String sql_del=null;
%>
return true;
}
function doSelect(){
var rad = document.all.checkbox1;
if(rad.checked){
document.all.chgroom.disabled=false;
}else{
document.all.chgroom.disabled=true;
document.all.chgroom.value="";
}
}
</script>
<form action="checkout.jsp" method="post" name="form1"> <P>
<table width="300px" cellspacing="0" cellpadding="0" border="0" align="center">
<tr>
<td><FONT size="2" color="#0000ff"> 请输入您的房间号：</FONT>
</td>
<td>
<INPUT type="text" name="room" size="15" maxlength="15">
</td>
</tr>
<tr>
<td>
<FONT color="orange" size="2">要换房请选中并输入房号</FONT>
</td>
<td>
<INPUT type="checkbox" name="checkbox1" value="OK" onclick="doSelect()" /> <INPUT type="text" name="chgroom" size="10" maxlength="10" disabled="disabled">
</td>
</tr>
<tr>
<td align="center" height="50px">
<INPUT type="submit" name="button1" value="确认">
</td>
</tr>
</table>
</form>
<%
String room=request.getParameter("room");
String chgroom=request.getParameter("chgroom");
String sql;
ResultSet rs=null;
String name;
String certificate;
String roomcode;
if(room!=null){
sql="select name,certificate,room.roomcode from room,guests where roomno='"+room+"' and room.roomcode=guests.roomcode";
rs=checkout.excuteQuery(sql);
%>
<HR>
<center>
<table width="300" cellspacing="0" cellpadding="0" align="center" border="0">
<tr align="left">
<td>
<P align="left"><FONT color="red"> <FONT size="2">房间</FONT></FONT><FONT size="2"> </FONT></P></td>
<td>
<P align="left"><FONT size="2"><FONT color="red"> 客人姓名</FONT> </FONT></P></td>
<td>
<P align="left"><FONT size="2"> <FONT color="red">证件号码</FONT></FONT>
</P></td>
<td>
<P align="left"><FONT size="2"> <FONT color="red"></FONT></FONT>
</P></td>
</tr>
<%
while(rs.next()){
name=rs.getString(1);
certificate=rs.getString(2);
roomcode=rs.getString(3);
%>
<tr align="left">
<td>
<FONT size="2">
<%=room%>
</FONT>
</td>
<TD>
<FONT size="2"><%=name%>
</FONT>
</TD>
<TD>
<FONT size="2"><%=certificate%>
</FONT>
</TD>
<td>
<%
if(chgroom=="" || chgroom==null){
%>
<a href="del.jsp?room=<%=room%>&roomcode=<%=roomcode%>&name=<%=name%>&certificate=<%=certificate%>" onclick="return del()"><FONT color="#8000ff" size="2">退房</FONT></a>
<%
}else{
%>
<a href="changeroom.jsp?room=<%=room%>&roomcode=<%=roomcode%>&name=<%=name%>&certificate=<%=certificate%>&chgroom=<%=chgroom%>" onclick="return del()"><FONT color="#8000ff" size="2">换房==><%=chgroom%></FONT></a>
<%}
%></td>
</tr>
<%
}
}
%>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -