📄 testpage.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<% request.setCharacterEncoding("gb2312"); %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>数据分页功能</title>
<style type="text/css">
<!--
body {
background-color: #CCFF99;
}
-->
</style></head>
<body>
<form action="#">
<table width="932" height="31" border="1" align="center" >
<tr bgcolor="#66CC33">
<td width="158" height="25"><div align="center">文件名称</div></td>
<td width="142"><div align="center">文件关键字</div></td>
<td width="139"><div align="center">文件提交人</div></td>
<td width="150"><div align="center">文件来源</div></td>
<td width="135"><div align="center">文件类别</div></td>
<td width="168"><div align="center">上传时间</div></td>
</tr>
</table>
<table width="930" height="28" border="0" align="center" bordercolor="#FFFFFF" >
<p>
<%
String fullsql=(String)session.getAttribute("whr");
Connection conn=null;
Statement state=null;
ResultSet rs=null;
int pagesize=4;
int rowcount=0;
int pagecount=0;
try{
String dsn = "jdbc:odbc:my";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(dsn,"","");
state=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=state.executeQuery(fullsql);
}
catch(Exception eeeee){
out.println("异常产生！");
}
if(!rs.next()){
out.println("无记录！");
}
else{
rs.last();
rowcount=rs.getRow();
int showpage=1;
pagecount=((rowcount%pagesize)==0?(rowcount/pagesize):(rowcount/pagesize)+1);
String topage=request.getParameter("topage");
if(topage!=null){
showpage=Integer.parseInt(topage);
if(showpage>pagecount){
showpage=pagecount;
}else if(showpage<=0){
showpage=1;
}
}
String topagesize=request.getParameter("selectPageSize");
if(topagesize!=null){
pagesize=Integer.parseInt(topagesize);
}
rs.absolute((showpage-1)*pagesize+1);
for(int i=1;i<=pagesize;i++){
%>
</p>
<tr bgcolor="#FFFFCC">
<td width="163" height="22" ><div align="center"><%=rs.getString("title")%></div></td>
<td width="137" ><div align="center"><%=rs.getString("keyword")%></div></td>
<td width="139"><div align="center"><%=rs.getString("sender")%></div></td>
<td width="150"><div align="center"><%=rs.getString("origin")%></div></td>
<td width="146"><div align="center"><%=rs.getString("kind")%></div></td>
<td width="169"><div align="center"><%=rs.getString("ddate")%></div></td>
</tr>
<%
if(!rs.next()) break;
}
%>
</table>
<table width="810" align="center">
<tr>
<td width="535" height="26" colspan="8" align="right">
每页显示
<select name="selectPageSize" width=7 class="avidmComboBoxLittle" onChange="changePageSize('user_list_',this,document.forms[0].selectCurrentPage)">
<option value="4">4
<option value="8">8
<option value="12">12
<option value="16">16
</select>
条记录 <a href="testPage.jsp?topage=<%=1%>">第一页</a>
<a href="testPage.jsp?topage=<%=showpage-1%>">上一页</a>
<a href="testPage.jsp?topage=<%=showpage+1%>">下一页</a>
<a href="testPage.jsp?topage=<%=pagecount%>">最后一页</a>
<span class="bgcolr">
<input name="topage" type="text" class="txt_grey" size="5" value="<%=showpage%>">
页</span>
<%
}
%>
</table>
<p align="right">返回主界面<a href="upload.jsp"><img src="image/sales.gif" width="21" height="22" border="0"></a></p>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -