📄 account.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%@ page import="com.qyg.shop.account.*" %>
<%String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%
AccountManageDAO dao=new AccountManageDAO();//新建一个充值操作类的对象
String AdminName=null;//管理员名
String AdminId=null;//管理员ID
String action=null;//判断处理页面的方法，有account冲值，finish完成冲值
String id=null;//冲值单号
int number;//申请充值的总数
int currentPage=1;//当前页数
int pageSize=5;//在此设定每页的大小
int pageCount=0;//页面总数
//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验证完
number=dao.getTotalOfAccounts();//得到申请充值数量
pageCount=number%pageSize==0?number/pageSize:number/pageSize+1;//得到总页数，另一种算法(number+pageSize-1)/pageSize;
if(request.getParameter("action")!=null) action=request.getParameter("action").toString();
if(request.getParameter("id")!=null) id=request.getParameter("id").toString();
if(request.getParameter("page")!=null) currentPage=Integer.parseInt(request.getParameter("page"));
currentPage=currentPage<1?1:currentPage;//为防止URL溢出，当currentPage<1时，返回第一页
currentPage=currentPage>pageCount?pageCount:currentPage;//为防止URL溢出，当currentPage>pageCount时，返回最后页
//完成充值模块
if(action!=null&&id!=null){
if(action.equals("finish")){
//out.print("119");//测试
dao.delete(Integer.parseInt(id));
}
}
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'Main.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">
<div align="center">
欢迎<font color="red" size="16"><%=AdminName%></font>登陆管理员页面
</div>
<%if(number>=1){ %>
<div align="right">现<a href="manage/Account.jsp?action=account">有<%=number%>条</a>冲值信息</div>
<%} %>
<div align="center" id="pageButton">
<!-- 实现分页浏览功能 -->
<%if(action!=null){ %>
<%if(action.equals("account")){ %>
<%if(currentPage>1){%>
<a href="manage/Account.jsp?action=account&page=1">首 页</a>
<a href="manage/Account.jsp?action=account&page=<%=(currentPage-1) %>">上一页</a>
<%} %>
<%if(currentPage<pageCount){ %>
<a href="manage/Account.jsp?action=account&page=<%=(currentPage+1) %>">下一页</a>
<a href="manage/Account.jsp?action=account&page=<%=pageCount %>">末 页</a>
<%} %>
<%} %>
<%} %>
<!--实现结束 -->
</div>
<table border="1" cellpadding="1" cellspacing="1" width="98%" class="datalist">
<!-- 利用程序语言，实现假分页模块 -->
<%
if(action!=null)
{
if(action.equals("account"))
{
out.print("<tr><th>申请号</th><th scope='col'>申请人ID</th><th scope='col'>申请金额</th><th scope='col'>申请状态</th></tr>");
List<Account> accounts=dao.getAllAccounts();
Iterator<Account> it=accounts.iterator();
//根据当前页与分页大小，来跳过数据行数，如30条，每页10条，共3页，如果浏览第二页，则跳过前10条
for(int i=0;i<(currentPage-1)*pageSize;i++)
{
it.next();
}
//显示中间数据，如果没到数据尾 且 小于每页大小，则输出
for(int i=0;i<pageSize&&it.hasNext();i++)
{
Account account=it.next();
%>
<tr>
<td><%=account.getAccount_id() %></td>
<td><%=account.getAccount_userId() %></td>
<td><%=account.getAccount_money() %></td>
<td><a href="manage/Account.jsp?action=finish&id=<%=account.getAccount_id()%>">完成充值</a></td>
</tr>
<% }
}
}
%>
<!-- 利用程序语言，实现假分页模块结束 -->
</table>
</body>
<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>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -