📄 addhousehire.jsp
字号:
<%@ page language="java" pageEncoding="gbk" import="java.sql.ResultSet,dbManager.DBManager"%>
<html>
<head>
<title>房屋租用管理增加页面</title>
<link rel="stylesheet" type="text/css" href="../../../css/secondcss.css">
<script type="text/javascript">
function addHouseHire()
{
if( form1.userName.value =="00" || form1.houseID.value == "00")
{
alert('请选择业主姓名或房屋编号！');
return false;
}
else
form1.submit();
}
</script>
</head>
<%
DBManager db = new DBManager();
String sqlUser = "select userID,userName from t_user";
String sqlHouse = "select houseID from t_house where houseState='2'";
ResultSet rs1 = db.getResult(sqlUser);
ResultSet rs2 = db.getResult(sqlHouse);
%>
<body>
<form name="form1" method="post" action="../../../addHouseHire.do">
<div id="Layer1" style="position:absolute; width:143px; height:57px; z-index:1; left: 20px; top: 73px;">
<img src="../../../images/user.jpg" width="32" height="32">
<font size="3" face="楷体_GB2312"><strong>选择业主姓名</strong></font>
<select name="userName" style="width:99%;height:20px">
<option value="00">请选择</option>
<% while(rs1.next()) {%>
<option value="<%=rs1.getString("userID") %>"><%=rs1.getString("userName") %></option>
<% } %>
</select>
</div>
<div id="Layer2" style="position:absolute; width:143px; height:57px; z-index:1; left: 263px; top: 74px;">
<img src="../../../images/house.jpg" width="32" height="32">
<font size="3" face="楷体_GB2312"><strong>选择入住房屋</strong></font>
<select name="houseID" style="width:99%;height:20px" >
<option value="00">请选择</option>
<% while(rs2.next()) {%>
<option value="<%=rs2.getString("houseID") %>"><%=rs2.getString("houseID") %></option>
<% }db.close(); %>
</select>
</div>
<div id="Layer3" style="position:absolute; width:69px; height:29px; z-index:2; left: 179px; top: 127px;">
<img src="../../../images/next.gif" width="32" height="32"><img src="../../../images/next.gif" width="32" height="32">
</div>
<div id="Layer4" style="position:absolute; width:100px; height:27px; z-index:3; left: 163px; top: 177px;">
<img src="../../../images/ruzhu1.jpg" width="100" height="50" style="cursor:hand" alt="确认该用户入住此房屋吗？"
onmouseover="this.src='../../../images/ruzhu2.jpg'"
onmouseout="this.src='../../../images/ruzhu1.jpg'"
onclick="addHouseHire()">
</div>
</form>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -