📄 brow.jsp
字号:
<%@ page contentType="text/html;charset=GBK"%>
<%@ page import="java.sql.*" %>
<%@ page import="java.lang.Math.*" %>
<% request.setCharacterEncoding("GBK");%>
<jsp:useBean id="conn" scope="page" class="load.DBManager"/>
<%!
ResultSet rs=null;
ResultSet rsTmp=null;
int totalPage=1;
int PageSize=6;
String sql="";
int totalrecord=0;
int Page=1;
String type="";
String key="";
%>
<html>
<head>
<title>我的软件仓库</title>
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<body text=#000000 bgcolor="#FFFFFF">
<center>
<%@ include file="title.htm" %>
<%
if(request.getParameter("m_type")!=null)
{
type=request.getParameter("m_type");
key=request.getParameter("m_key");
}
if(request.getParameter("m_key")!=null)
{
key=request.getParameter("m_key");
}
sql="select * from download";
if(type!=null&&!type.equals("")&&key!=null&&!key.equals(""))
sql+=" where "+type+" like '%"+key+"%'";
else if(key!=null&&!key.equals(""))
sql+=" where showname like '%"+key+"%'";
rs=conn.executeQuery(sql);
if(rs.next()){
%>
<h2>我的软件仓库-分类显示</h2>
<form action="brow.jsp" method="post">
请选择类别:
<select name="m_type">
<option value="showname"<%if(type.equals("showname")) out.print("selected");%>>软件名称</option>
<option value="date"<%if(type.equals("date")) out.print("selected");%>>加入时间</option>
<option value="hits" <%if(type.equals("hits")) out.print("selected");%>>下载数量</option>
</select>
请输入关键字:<input type="text" name="m_key" value="">
<input type="submit" value="查看">
</form>
<%
sql="select count(*) as mycount from download";
if(type!=null&&!type.equals("")&&key!=null&&!key.equals(""))
sql+=" where "+type+" like '%"+key+"%'";
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.showOnePage(rs,Page,PageSize));
rs.close();
%>
<form action="brow.jsp" method="get">
<%
if(Page!=1)
{
out.print("<a href=brow.jsp?Page=1&m_type="+type+"&m_key="+key+">第一页</a>"+" ");
out.print("<a href=brow.jsp?Page="+(Page-1)+"&m_type="+type+"&m_key="+key+">上一页</a>"+" ");
}
if(Page!=totalPage)
{
out.print("<a href=brow.jsp?Page="+(Page+1)+"&m_type="+type+"&m_key="+key+">下一页</a>"+" ");
out.print("<a href=brow.jsp?Page="+totalPage+"&m_type="+type+"&m_key="+key+">最后一页</a>"+" ");
}
%>
<p>
输入页数:<input type="text" name="Page" size="3">页数:<font color="Red"><%=Page%>/<%=totalPage%></font>
</p>
</form>
</center>
</body>
</html>
<% }else out.print("没有匹配的软件!"); %>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -