📄 xtwh.jsp
字号:
<%@ page contentType="text/html;charset=GBK"%>
<%@ page import="java.sql.*" %>
<%@ page import="java.lang.Math.*" %>
<jsp:useBean id="conn" scope="page" class="load.DBManager"/>
<% request.setCharacterEncoding("GBK");%>
<%
if(session.getAttribute("login")==null){
%>
<jsp:forward page="login.jsp"/>
<% } %>
<%!
ResultSet rs=null;
ResultSet rsTmp=null;
int totalPage=1;
int PageSize=2;
String sql="";
int totalrecord=0;
int Page=1;
String type="";
%>
<%
sql="select * from download order by hits desc";
rs=conn.executeQuery(sql);
%>
<html>
<head>
<title>我的软件仓库</title>
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body text=#000000 bgcolor="#FFFFFF">
<center>
<%@ include file="title.htm" %>
<h2>软件仓库-系统维护</h2>
<%
sql="select count(*) as mycount from download";
rsTmp=conn.executeQuery(sql);
if(rsTmp.next())
totalrecord=rsTmp.getInt("mycount");
rsTmp.close();
if(totalrecord%PageSize==0)
totalPage=totalrecord/PageSize;
else
totalPage=(int)Math.floor(totalrecord/PageSize)+1;
if(request.getParameter("Page")==null||request.getParameter("Page").equals(""))
Page=1;
else
Page=Integer.parseInt(request.getParameter("Page"));
if(Page<1)
Page=1;
if(Page>totalPage)
Page=totalPage;
out.print(conn.xtwhShowOnePage(rs,Page,PageSize));
rs.close();
%>
<form action="xtwh.jsp" method="get">
<%
if(Page!=1)
{
out.print("<a href=xtwh.jsp?Page=1>第一页</a>"+" ");
out.print("<a href=xtwh.jsp?Page="+(Page-1)+">上一页</a>"+" ");
}
if(Page!=totalPage)
{
out.print("<a href=xtwh.jsp?Page="+(Page+1)+">下一页</a>"+" ");
out.print("<a href=xtwh.jsp?Page="+totalPage+">最后一页</a>"+" ");
}
%>
<p>
输入页数:<input type="text" name="Page" size="3">页数:<font color="Red"><%=Page%>/<%=totalPage%></font>
</p>
</form>
</center>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -