⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 queryuser.jsp

📁 整个系统采用MVC开发模式
💻 JSP
字号:
<%@ page language="java" import="java.util.*" pageEncoding="gbk"%>
<%@ page import="bean.User" %>
<%@page import="Manager.Page;"%>
<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>
<script language="javaScript">
function tiaozhuan(){
window.location.href="http://localhost:8080/Manager/ChangePwd.jsp";
}
function logout(){
window.location.href="http://localhost:8080/Manager/exit.jsp";
} 
</script>
	<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">



	</head>

	<body>


		<table width="1828" height="479" border="1">
			<tr>
				<td height="17" colspan="2">&nbsp; 
				</td>
			</tr>
			<tr>
				<td height="66">
					<div class=title>
						身份:管理员
					</div>
				</td>
				<td>
					&nbsp;
				</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="修改密码" size="10" onclick="tiaozhuan()">&nbsp;&nbsp; <input type="button" name="quit" value="退出登陆" onclick="logout()" >
					</div>
				</td>
				<td width="900" align=center><form action="Manager/Search" method="get">
				用户查询:<input tpye="text" name=username value="请输入关键字" onclick="javascript:this.value='';"/> <input type="submit" name="commit" value="查询"/>
				</form><p></p>
					<table width="700" border="1" height="400">
						<tr>
							<td>
								id
							</td>
							<td>
								name
							</td>
							<td>
								password
							</td>
							<td>
								phone
							</td>
							<td>
								addr
							</td>
							<td>
								email
							</td>
							<td>
								rdate
							</td>
							<td>
								flag
							</td>
							<td>
								删除记录
							</td>
						</tr>
						<%
						        int[] id=new int[subResult.size()];
								if (subResult.isEmpty() == false) {
								for (int i = 0; i < subResult.size(); i++) {
									User u2 = subResult.get(i);
									id[i]=u2.getUserid();
									
									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.getNickname() + "</td>");
									out.print("<td>" + u2.getBirthday() + "</td>");
									out.print("<td>" + u2.getEmail() + "</td>");
									out.print("<td>" + u2.getInterest() + "</td>");
									out.print("<td>" + u2.getIntroduce() + "</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>
					
				</td>
			</tr>
		</table>
	</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -