WebRoot/zhusu/diaohuan.jsp

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="com.util.*"%>
<%
request.setCharacterEncoding("gb2312");
DBO db=new DBO();
db.open();
String keyid=(String)request.getParameter("keyid");
%>
<html>
<head>
<LINK href="../css/admin.css" type="text/css" rel="stylesheet"><meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>住宿添加</title>
<body>
<script language="javascript">
function checkDo(){
if(form.kfid.value==""){
alert("客房不能为空");
return false;
form.kfid.focus();
}if(form.yhid.value==""){
alert("用户名不能为空");
return false;
form.yhid.focus();
}form.action="zhusu_diaohuan.jsp";
form.submit();
}
</script><style type="text/css">
<!--
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
	background-color: #EEF2FB;
}
a:hover{
color:#FF0000;
text-decoration:underline;
}
-->
</style>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<br>
<br>
<div align="center">  <h3>住宿登记</h3><hr width=80% color=#880000><form name="form" method="post" action="">
<input type="hidden" name="keyid" value="<%=keyid%>">
<table width="98%" border=1 style="border-collapse: collapse; border-style: dotted; border-width: 1px"  bordercolor="#999999" cellspacing="1" cellpadding="1">
<tr>    <td width="14%">客房</td>    <td width="86%"><%
db.open();
ResultSet  kefangrs=null;
String kefangsql="select a.*,b.lbmc,b.jg from kefang a,leibie b where 1=1 and a.lbid=b.lbid and a.kfid not  in (select kfid from zhusu where  zsid='"+keyid+"') ";
kefangrs=db.query(kefangsql);
%>
 <select name="kfid">
 <option  value="">请选择</option>
<%
 while(kefangrs.next()){%>
<option value="<%=kefangrs.getString("kfid")%>" ><%=kefangrs.getString("kfmc")%>【<%=kefangrs.getString("lbmc")%>：<%=kefangrs.getString("jg")%>】</option>
<%}%>
</select>