📄 househire.jsp
字号:
<%@ page language="java" pageEncoding="gbk" import="bean.House,dbManager.DBManager,java.sql.ResultSet,java.util.*"%>
<html>
<head>
<title>房屋租用管理</title>
<link rel="stylesheet" type="text/css" href="../../../css/secondcss.css">
<script type="text/javascript">
var str="";
// 全选操作
function checkJs(obj)
{
var elem = document.form1.elements;
for(var i = 0; i < elem.length; i++)
{
if(elem[i].type=="checkbox")
elem[i].checked=obj.checked;
}
}
// 获得各操作记录数
function getInfo()
{
var elem=document.form1.elements;
var count=0;
str="";
for(var i=0;i<elem.length;i++)
{
if(elem[i].type=="checkbox"&&elem[i].checked==true&&elem[i].id!="chkAll")
{
count++;
str += elem[i].value + ",";
}
}
return count;
}
// 删除操作提示
function DeleteInfo()
{
var count = getInfo();
if(count<1)
{
alert("请选择要删除的记录！");
return false;
}
else
{
if( confirm("您确定要删除这 "+count+" 记录吗？如果删除将无法恢复！") )
{
document.form1.action="../../../deleteHouseHire.do?s="+str;
document.form1.submit();
}
else
return false;
}
}
// 选择业主姓名点击查询后
function change()
{
if( form1.dropUserName.value == "0")
{
alert('请选择要查询的业主姓名');
return false;
}
else
{
document.form1.action="../../../changeUserID.do";
document.form1.submit();
}
}
</script>
</head>
<body>
<form id="form1" name="form1" method="post">
<table width="99%" border="0" style="border-top-width: 0px; border-left-width: 0px; background: none transparent scroll repeat 0% 0%;
border-bottom-width: 0px; letter-spacing: 0px; border-right-width: 0px; border-spacing: 0px">
<!--按钮操作表格-->
<tr>
<td width="34%"><div align="left"><strong><font size="3">房屋租用管理</font></strong></div></td>
<td width="18%"><div align="right">选择用户姓名：</div></td>
<td width="10%"><select name="dropUserName" style="font-size: 9pt">
<option value="0">请选择</option>
<%
DBManager db = new DBManager();
String selUser = "select userID,userName from t_user";
ResultSet rsUser = db.getResult(selUser);
while( rsUser.next() )
{
%>
<option value="<%=rsUser.getString("userID") %>"><%=rsUser.getString("userName") %></option>
<%
}
db.close();
%>
</select></td>
<td width="10%"><img src="../../../images/chazhao1.gif" width="69" height="22px" style="cursor:hand"
onmousemove="this.src='../../../images/chazhao2.gif'"
onmouseout="this.src='../../../images/chazhao1.gif'"
onmousedown="this.src='../../../images/chazhao3.gif'"
onmouseup="this.src='../../../images/chazhao2.gif'"
onclick="change()"></td>
<td width="10%"><img src="../../../images/zengjia1.gif" width="69" height="22px" style="cursor:hand"
onmousemove="this.src='../../../images/zengjia2.gif'"
onmouseout="this.src='../../../images/zengjia1.gif'"
onmousedown="this.src='../../../images/zengjia3.gif'"
onmouseup="this.src='../../../images/zengjia2.gif'"
onclick="window.open('addHouseHire.jsp','new1window','height=300,width=450,top=220,left=300')">
</td>
<td width="10%"><img src="../../../images/shanchu1.gif" width="69" height="22px" style="cursor:hand"
onmousemove="this.src='../../../images/shanchu2.gif'"
onmouseout="this.src='../../../images/shanchu1.gif'"
onmousedown="this.src='../../../images/shanchu3.gif'"
onmouseup="this.src='../../../images/shanchu2.gif'"
onclick="return DeleteInfo();"></td>
<td width="11%"><img src="../../../images/dayin1.gif" width="69" height="22px" style="cursor:hand"
onmousemove="this.src='../../../images/dayin2.gif'"
onmouseout="this.src='../../../images/dayin1.gif'"
onmousedown="this.src='../../../images/dayin3.gif'"
onmouseup="this.src='../../../images/dayin2.gif'"
onclick="if(confirm('您确定打印吗？')){ window.print();}"></td>
</tr>
</table>
<br>
<hr color="green">
<br>
<table width="99%" style="border-top-width: 0px; border-left-width: 0px; background: none transparent scroll repeat 0% 0%;
border-bottom-width: 0px; letter-spacing: 0px; border-right-width: 0px; border-spacing: 0px;">
<tbody>
<tr style="background-color:#5D7B9D;color:white; ">
<td><input type="checkbox" id="chkAll" onclick="checkJs(this)" />全选</td>
<td>房屋编号</td>
<td>建筑面积(㎡)</td>
<td>房屋用途</td>
<td>收费类型</td>
<td>业主姓名</td>
</tr>
<%
List arrayList = (ArrayList)session.getAttribute("list");
if( arrayList != null )
{
for( int i=0; i<arrayList.size(); i++)
{
House house = (House)arrayList.get(i);
%>
<tr style="background-color: #F7F6F3;color:#333333; ">
<td><input type="checkbox" id="chkid" name="chkid" value="<%=house.getHouseID() %>"/></td>
<td><%=house.getHouseID() %></td>
<td><%=house.getHouseArea() %></td>
<td><%=house.getHouseUse() %></td>
<td><%=house.getTypeID() %></td>
<td><%=house.getUserID() %></td>
</tr>
<%
}
}
else
{
out.println("<tr><td colspan='5' style='text-align: left'>");
out.println("没有找到相关信息！");
out.println("</td></tr>");
}
session.setAttribute("list",null);
%>
</tbody>
</table>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -