📄 inquiregoods.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%@ page import="bean.Goods" %>
<%@ page import="bean.GoodsDao" %>
<%@page import="Manager.Page;"%>
<jsp:useBean id="pager" class="Manager.Page" scope="page"></jsp:useBean>
<%
//从数据库中去出结果集
int currentRecord = 0;
ArrayList<Goods> result = (ArrayList<Goods>)session.getAttribute("result");
pager.setTotalRecord(result.size());
pager.setTotalPage(result.size(),pager.getPageSize());
//计算并设置分页的参数
if(request.getParameter("currentRecord")!=null)
{
currentRecord = Integer.parseInt(request.getParameter("currentRecord"));
pager.setCurrentRecord(currentRecord);
pager.setCurrentPage(currentRecord,pager.getPageSize());
}
//从结果集中取出当前页面要显示的子集
List<Goods> subResult = null;
if(currentRecord == 0)
{
subResult = result.subList(0,pager.getPageSize());
}
if(pager.getCurrentRecord()+pager.getPageSize()<result.size())
subResult = result.subList(pager.getCurrentRecord(),pager.getCurrentRecord()+pager.getPageSize());
else
subResult = result.subList(pager.getCurrentRecord(),result.size());
%>
<html>
<head>
<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">
<style type="text/css">
<!--
a:link {
text-decoration: none;
color: #000000;
}
a:visited {
text-decoration: none;
color: #000000;
}
a:hover {
text-decoration: none;
}
a:active {
text-decoration: none;
color: #FF0000;
}
a {
font-size: 10pt;
color: #FF0000;
}
body,td,th {
font-size: 10pt;
}
-->
</style>
</head>
<body>
<table width="1828" height="479" border="1">
<tr>
<td height="17" colspan="2">
</td>
</tr>
<tr>
<td height="66">
<div class=title>
身份：管理员
</div>
</td>
<td>
</td>
</tr>
<tr>
<td width="120">
<div class=title align=center>
商品管理
</div>
<ul>
<li>
<a href="/AddCategory.jsp" target=_parent name=addCategory>添加商品分类</a>
</li>
<li>
<a href="/AddProduct.jsp" target=_parent name=addProduct>添加新商品</a>
</li>
<li>
<a href="/ChangeProduct.jsp" target=_parent name=changeproduct>修改商品信息</a>
</li>
<li>
<a href="/DelProduct.jsp" target=_parent name=delproduct>删除商品</a>
</li>
</ul>
<div class=title align=center>
用户管理
</div>
<ul>
<li>
<a href="/Manager/QueryUser.jsp" target="_parent"
name=queryuser>查询用户信息</a>
</li>
<li>
<a href="/Manager/DelUser.jsp" target="_parent" name=deluser>删除用户</a>
</li>
</ul>
<div class=title align=center>
订单管理
</div>
<ul>
<li>
<a href="/CheckOrder.jsp" target=_parent name=mypostreview>查看订单</a>
</li>
<li>
<a href="/DealOrder.jsp" target=_parent name=mypostreview>处理订单</a>
</li>
</ul>
<div class=title align=center>
<input type="button" name="changepwd" value="修改密码" />
<input type="button" name="quit" value="退出登陆" />
</div>
</td>
<td width="900" align=center><form action="" method="post">
商品查询：<input tpye="text" name=query value="请输入关键字" oncilck="javascript:this.value='';"/> <input type="submit" name="commit" value="查询"/>
</form><p></p>
<div style="position:relative; left:0px; top:5px"> <table width="500" border="1" height="200">
<tr>
<td height=20 >
id
</td>
<td height=20 >
name
</td>
<td height=20>
password
</td>
<td height=20>
phone
</td>
<td height=20>
addr
</td>
<td height=20>
email
</td>
<td height=20>
rdate
</td>
<td height=20>
flag
</td>
<td height=20>
修改商品信息
</td>
<td height=20>
删除记录
</td>
</tr>
<%
if (subResult.isEmpty() == false) {
for (int i = 0; i < subResult.size(); i++) {
Goods g2 = subResult.get(i);
out.print("<tr>");
out.print("<td>" + g2.getBookname() + "</td>");//方法名字要改！！！
out.print("<td>" + g2.getAuthor() + "</td>");
out.print("<td>" + g2.getIsbn() + "</td>");
out.print("<td>" + g2.getPrice() + "</td>");
out.print("<td>" + g2.getPublish() + "</td>");
out.print("<td>" + g2.getPages() + "</td>");
out.print("<td>" + g2.getPack() + "</td>");
out.print("<td>" + g2.getSort() + "</td>");
out.print("<td>" + "<a href='Manager/EditGoods?del=true'>"+"点击编辑商品信息"+"</a>" + "</td>");
out.print("<td>" + "<a href='Manager/DeleleGoods?del=true'>"+"删除商品"+"</a>" + "</td>");
out.print("<tr>");
}
}
%>
</table>
<span><font size="2">总<%=pager.getTotalRecord() %>条记录|总<%=pager.getTotalPage() %>页
|当前<%=pager.getCurrentPage()+1%>页|每页<%=pager.getPageSize() %>条|
<%
//如果已经到了首页就去掉前一页的链接
if(pager.getCurrentRecord()-pager.getPageSize()<0)
out.println("首页|");
else
//上一页就是把当前记录位置减去一页显示记录的条数
out.print("<a href='QueryUser.jsp?currentRecord="+(pager.getCurrentRecord()-pager.getPageSize())+"&pageSize="+pager.getPageSize()+"'>上一页</a>|");
//如果到了尾页就去掉下一页的链接
if(pager.getCurrentRecord()+pager.getPageSize()>pager.getTotalRecord())
out.println("尾页");
else
//下一页就是把当前记录位置加上一页显示记录的条数
out.print("<a href='QueryUser.jsp?currentRecord="+(pager.getCurrentRecord()+pager.getPageSize())+"&pageSize="+pager.getPageSize()+"'>下一页</a>|");
%>
</font></span></div>
</td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -