📄 resultuser.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="gb2312"%>
<%@ page import="bean.User" %>
<%@ page import="bean.UserDAO" %>
<%@page import="Manager.Page;"%>
<jsp:useBean id="user" class="bean.User" scope="page"></jsp:useBean>
<jsp:useBean id="userdao" class="bean.UserDAO" scope="page"></jsp:useBean>
<jsp:useBean id="pager" class="Manager.Page" scope="page"></jsp:useBean>
<%
//从数据库中去出结果集
int currentRecord = 0;
ArrayList<User> result = (ArrayList<User>)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<User> 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">
</head>
<body>
<div style="margin:10 0 10 0;"><h2>符合查询条件的结果为</h2></div>
<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>
</tr>
<%
if (subResult.isEmpty() == false) {
for (int i = 0; i < subResult.size(); i++) {
User u2 = subResult.get(i);
out.print("<tr>");
out.print("<td>" + u2.getUserid() + "</td>");
out.print("<td>" + u2.getUsername() + "</td>");
out.print("<td>" + u2.getPassword() + "</td>");
out.print("<td>" + u2.getEmail() + "</td>");
out.print("<td>" + "<a href="+"Manager/Delete?del="+u2.getUserid()+">"+"删除"+"</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 + -