📄 usersearch.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%@ page import="com.qyg.shop.user.*" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%
UserManageDAO dao = new UserManageDAO();
int currentPage = 1;//当前页数
int pageSize = 8;//在此设定每页的大小
int pageCount = 0;//页面总数
String AdminName = null;//管理员名
String AdminId = null;//管理员ID
String action = null;//获得页面方法，delete,update,add,search四种
String name = null;//要查询用户名
List<User> users = null;//查询到用户信息
//session验证，防止非法进入
if (session.getAttribute("adminName") != null) {
AdminName = session.getAttribute("adminName").toString();
AdminId = session.getAttribute("adminId").toString();
} else {
out.print("请误非法登陆，<a href='/qygshop/manage/Login.jsp' target='_parent'>点此进入</a>");
out.close();
}
//session验证完
/*删除得到的ID的对象*/
if ((action = request.getParameter("action")) != null) {
if (action.equals("delete")) {
//out.print(request.getParameter("id"));//测试
int id = Integer.parseInt(request.getParameter("id"));
dao.delete(id);
}
}
/*删除完*/
/*得到总页数pageCount及用户信息*/
if ((name = request.getParameter("name")) != null)
{
session.setAttribute("name",name);
}
if(session.getAttribute("name")!=null)
{
int number = dao.getTotalUserLikeName(session.getAttribute("name").toString());//得到查到用户总数
pageCount = number % pageSize == 0 ? number / pageSize : number
/ pageSize + 1;//得到总页数，另一种算法(number+pageSize-1)/pageSize;
users = dao.getUsersLikeName(session.getAttribute("name").toString());
}
/*得到总结束完*/
//得到URL传来的参数
if (request.getParameter("page") != null)
currentPage = Integer.parseInt(request.getParameter("page"));
currentPage = currentPage < 1 ? 1 : currentPage;
currentPage = currentPage > pageCount ? pageCount : currentPage;
//得到URL传来的参数完
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'UserSearch.jsp' starting page</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">
<link rel="stylesheet" href="css/common.css" type="text/css"></link>
</head>
<BODY bgcolor="#D9EAFC">
<!-- 查询提交模块 -->
<form action="manage/UserSearch.jsp" method="get">
<div align="center" id="search">
请输入要查找的用户名<input type="text" name="name"/> <input type="submit" value="查询"/>
</div>
</form>
<!-- 查询模块完 -->
<!-- 分页跳转链接 -->
<div align="center" id="pageButton">
<%
if (currentPage > 1) {
%>
<a href="manage/UserSearch.jsp?page=1">首 页</a>
<a href="manage/UserSearch.jsp?page=<%=currentPage -1%>">上一页</a>
<%
}
%>
<%
if (currentPage < pageCount) {
%>
<a href="manage/UserSearch.jsp?page=<%=currentPage +1%>">下一页</a>
<a href="manage/UserSearch.jsp?page=<%=pageCount%>">末 页</a>
<%
}
%>
第<%=currentPage%>页/共<%=pageCount%>页
</div>
<!-- 分页跳转完 -->
<table border="1" cellpadding="1" width="98%" class="datalist">
<tr>
<th>编号</th>
<th>用户名</th>
<th>电话</th>
<th>住址</th>
<th>注册日期</th>
<th>权限</th>
<th>帐户余额</th>
<th colspan="2">操作</th>
</tr>
<!-- 实现分页源码 -->
<%
Iterator<User> it = users.iterator();
for (int i = 0; i < pageSize * (currentPage - 1); i++) {
it.next();
}
for (int i = 0; i < pageSize && it.hasNext(); i++) {
User user = it.next();
out.print("<tr>");
out.print("<td>" + user.getId() + "</td>");
out.print("<td>" + user.getName() + "</td>");
out.print("<td>" + user.getPhone() + "</td>");
out.print("<td>" + user.getAddr() + "</td>");
out.print("<td>" + user.getRdate() + "</td>");
out.print("<td>" + user.getPower() + "</td>");
out.print("<td>" + user.getMoney() + "</td>");
out.print("<td><a href='manage/User.jsp?action=delete&id="+user.getId()+"'>删除</a></td>");
out.print("<td><a href='manage/UserEdit.jsp?action=update&id="+user.getId()+"'>修改</a></td>");
}
%>
<!-- 实现分页源码完 -->
</table>
<script language="javascript">
var rows = document.getElementsByTagName('tr');
for (var i=0;i<rows.length;i++){
rows[i].onmouseover = function(){ //鼠标在行上面的时候
this.className += 'altrow';
}
rows[i].onmouseout = function(){ //鼠标离开时
this.className = this.className.replace('altrow','');
}
}
</script>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -