📄 admin_device_result.jsp
字号:
<%@ page language="java"%>
<%@ page import="java.sql.*"%>
<%@ page contentType="text/html;charset=GB2312"%>
<%
String admin_device_Loginmessage=(String)session.getValue("admin_device_loginSign");
String adminID=(String)session.getValue("adminID");
if(admin_device_Loginmessage!="OK")
{
response.sendRedirect("admin_device_index.jsp");
}
%>
<jsp:useBean class="manage_sys.manage_sys" id="device_index" scope="page"></jsp:useBean>
<%
String Search=new String(request.getParameter("Search").getBytes("8859_1"));
String Select=new String(request.getParameter("Select").getBytes("8859_1"));
String sql="select * from my_device where "+Select+" like '"+"%"+Search+"%"+"'";
ResultSet rs=device_index.executeQuery(sql);
int pageLine=10;
int totalRec=0;
int intPage=1;
int i;
if (request.getParameter("page")!=null)
intPage=Integer.parseInt(request.getParameter("page"));
try{
String sql1="select count(*)as cnt from my_device where "+Select+" like '"+"%"+Search+"%"+"'";
ResultSet countrs=device_index.executeQuery(sql1);
if(countrs.next())
totalRec=countrs.getInt("cnt");
countrs.close();
device_index.closeStmt();
}
catch(Exception e){
e.printStackTrace();
}
int intPageCount=0;
intPageCount=(totalRec+pageLine-1)/pageLine;
%>
<html>
<head>
<title>设备管理</title>
<script language=JavaScript>
<!--
function disConfirm(){
return confirm("确认要删除这本书吗？删除后所有关于该书的信息将同时删除!");
}
//-->
</script>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../../images/css.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.style5 {font-size: 14px; }
-->
</style>
</head>
<%@include file="adm_device_head.jsp"%>
<table width="778" border="0" cellspacing="0" cellpadding="0" height="119" align="center">
<tr>
<td height="25" bgcolor="#999999"><div align="center">
<div align="center">
<table width="778" border="0" cellspacing="1" cellpadding="1">
<tr>
<td height="30" bgcolor="#FFFFFF"><div align="center"><font color="#000099"><%=adminID%>,您好！</font><font color="#000099">欢迎您使用本系统。</font></div></td>
</tr>
</table>
</div>
</div></td>
</tr>
<tr>
<td valign="top" bgcolor="#999999"><table width="100%" border="0" cellspacing="1" cellpadding="1">
<tr bgcolor="#FFFFFF">
<td colspan="6"><form name="form1" method="post" action="admin_device_result.jsp">
<div align="center"></div>
<div align="center">
<p><font color="#000000" size="+2"><br>图书检索</font></p>
<p>书名
<input name="Search" type="text" id="Search">
<select name="Select" size="1" id="Select">
<option value="dev_name">设备名</option>
<option value="dev_NO">设备编号</option>
<option value="dev_class">设备类型</option>
<option value="dev_status">设备状态</option>
</select>
</p>
</div> <div align="center">
<p>
<input type="submit" name="Submit" value="检索">
<input type="reset" name="Submit" value="重置">
</p>
</div>
</form></td>
<td colspan="6"><table width="100%" border="0" cellspacing="10" cellpadding="10">
<tr>
<td><div align="center"><a href="admin_add_device.jsp"><img src="../../images/tjsb.jpg" width="80" height="22" border="0"></a></div></td>
<td><div align="center"><a href="admin_password_edit.jsp"><img src="../../images/xgmm.jpg" width="80" height="22" border="0"></a></div></td>
</tr>
<tr>
<td><div align="center"><a href="admin_user_index.jsp"><img src="../../images/zhgl.jpg" width="80" height="22" border="0"></a></div></td>
<td><div align="center"><a href="admin_logout.jsp"><img src="../../images/tcxt.jpg" width="80" height="22" border="0"></a></div></td>
</tr>
</table></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="30" colspan="12"><div align="center">图书浏览</div></td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="55" height="28"><div align="center">设备号</div></td>
<td width="137"><div align="center">设备名</div></td>
<td width="89"><div align="center">设备类别</div></td>
<td width="75"><div align="center">品牌</div></td>
<td width="82"><div align="center">单价</div></td>
<td width="113"><div align="center">购入时间</div></td>
<td width="80"><div align="center">设备状态</div></td>
<td colspan="2"><div align="center">管理操作</div></td>
</tr>
<%//out.println("hellotencent!");
//out.println(superadmin);
if (intPageCount>0)
{
for(i=1;i<=(intPage-1)*pageLine;i++)
rs.next();
for(i=1;i<=pageLine;i++){
if(rs.next()){
String ID=rs.getString("ID");
String dev_name=rs.getString("dev_name");
String dev_NO=rs.getString("dev_NO");
//String dev_classNO=rs.getString("dev_classNO");
String dev_class =rs.getString("dev_class");
String dev_brand =rs.getString("dev_brand");
String dev_price =rs.getString("dev_price");
String dev_regtime =rs.getString("dev_regtime");
String dev_status =rs.getString("dev_status");
%>
<tr bgcolor="#FFFFFF">
<td height="28"><div align="center" class="style5"><a href="admin_device_show.jsp?ID=<%=ID%>" target="_blank"><%=dev_NO%></a></div></td>
<td height="22"><div align="center" class="style5"><a href="admin_device_show.jsp?ID=<%=ID%>" target="_blank"><%=dev_name%></a></div></td>
<td height="22"><div align="center" class="style5"><%=dev_class%></div></td>
<td height="22"><div align="center" class="style5"><%=dev_brand%></div></td>
<td height="22"><div align="center" class="style5"><%=dev_price%></div></td>
<td height="22"><div align="center" class="style5"><%=(dev_regtime).substring(0,10)%></div></td>
<td height="22"><div align="center" class="style5"><%=dev_status%></div></td>
<td width="61" height="22"><div align="center"><a href="admin_device_edit.jsp?ID=<%=ID%>" target="_blank">编辑</a></div></td>
<td width="58" height="22"><div align="center"><a href="admin_delete_device.jsp?ID=<%=ID%>&&intPage=<%=intPage%>" onClick="return disConfirm()"><font color="#FF0000">删除</font></a></div></td>
</tr>
<%
}
}
}
%>
</table></td>
</tr>
</table>
<table width="778" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td> <%
out.print("<tr><br>");
if(intPageCount*pageLine<totalRec)
intPageCount++;
if(intPage>intPageCount)
intPage=intPageCount;
if(intPage<1)
intPage=1;
out.print("<form method='post' name=fPageNum action='admin_device_index.jsp'>");
out.print("<p align='left'><font color='#000099'> 分页</font> ");
if(intPage<2)
out.print("<font color='#000099'>首页 上一页 </font>");
else{
out.print("<a href='admin_device_index.jsp?page=1'><font color='#000099'>首页</font></a> ");
out.print("<a href='admin_device_index.jsp?page="+(intPage-1)+"'><font color='#000099'>上一页</font></a> ");
}
if(intPage-intPageCount>=0)
out.print("<font color='#000099'> 下一页 尾页</font>");
else{
out.print("<a href='admin_device_index.jsp?page="+(intPage+1)+"'><font color='#000099'>下一页</font></a> <a href='admin_device_index.jsp?page="+intPageCount+"'><font color='#000099'>尾页</font></a>");
}
out.print(" <font color='#000099'>    页次</font>：<strong><font color='#000099'>"+intPage+"/"+intPageCount+"</font></strong><font color='#000099'>页</font>");
out.print(" <font color='#000099'>共</font><b><font color='#000099'>"+totalRec+"</font></b><font color='#000099'>个项目</font><b><font color='#000099'>    "+pageLine+"</font></b><font color='#000099'>条/页</font>");
out.print("<font color='#000099'>转到第</font><input type='text' name='page' size=2 maxlength=10 class=smallInput value="+intPage+">");
out.print("<font color='#000099'>页</font><input class=buttonface type='submit' value='GO' name='cndok'></span></p></form>");
out.print("</td>");
out.print("</tr>");
%></td>
</tr>
</table>
</html>
<%@include file="adm_device_tail.jsp"%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -