package org.apache.jsp;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import java.sql.*;
import java.lang.Math.*;
public final class pagev4_jsp extends org.apache.jasper.runtime.HttpJspBase
implements org.apache.jasper.runtime.JspSourceDependent {
ResultSet rs = null;
ResultSet rsTmp = null;
String sql = "";
int PageSize = 6;
int Page = 3;
int totalPage = 1;
String str = "";
public String ShowOnePage(ResultSet rs, int Page, int PageSize) {
str = "";
// 先将记录指针定位到相应的位置
try {
rs.absolute((Page - 1) * PageSize + 1);
} catch (SQLException e) {
}
for (int iPage = 1; iPage <= PageSize; iPage++) {
str += ShowOneRec(rs, iPage);
try {
if (!rs.next()) {
break;
}
} catch (Exception e) {
}
}
return str;
}
// 显示单行记录子模块 且改变颜色
public String ShowOneRec(ResultSet rs, int i) {
String tt = "";
try {
if (i % 2 == 0) {
tt += "<TR bgcolor=#00ff00>";
} else {
tt += "<TR bgcolor=#0000ff>";
}
tt += "<TD>" + rs.getString("studentid") + "</TD>";
tt += "<TD>" + rs.getString("studentname") + "</TD>";
tt += "<TD>" + rs.getString("gender") + "</TD>";
tt += "<TD>" + rs.getString("phone") + "</TD>";
tt += "</TR>";
} catch (SQLException e) {
}
return tt;
}
private static final JspFactory _jspxFactory = JspFactory.getDefaultFactory();
private static java.util.List _jspx_dependants;
private javax.el.ExpressionFactory _el_expressionfactory;
private org.apache.AnnotationProcessor _jsp_annotationprocessor;
public Object getDependants() {
return _jspx_dependants;
}
public void _jspInit() {
_el_expressionfactory = _jspxFactory.getJspApplicationContext(getServletConfig().getServletContext()).getExpressionFactory();
_jsp_annotationprocessor = (org.apache.AnnotationProcessor) getServletConfig().getServletContext().getAttribute(org.apache.AnnotationProcessor.class.getName());
}
public void _jspDestroy() {
}
public void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
PageContext pageContext = null;
HttpSession session = null;
ServletContext application = null;
ServletConfig config = null;
JspWriter out = null;
Object page = this;
JspWriter _jspx_out = null;
PageContext _jspx_page_context = null;
try {
response.setContentType("text/html;charset=GBK");
pageContext = _jspxFactory.getPageContext(this, request, response,
null, true, 8192, true);
_jspx_page_context = pageContext;
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
_jspx_out = out;
out.write("\r\n");
out.write("\r\n");
out.write("\r\n");
db.Conn conn = null;
synchronized (_jspx_page_context) {
conn = (db.Conn) _jspx_page_context.getAttribute("conn", PageContext.PAGE_SCOPE);
if (conn == null){
conn = new db.Conn();
_jspx_page_context.setAttribute("conn", conn, PageContext.PAGE_SCOPE);
}
}
out.write('\r');
out.write('\n');
out.write('\r');
out.write('\n');
sql = "select * from student";
try {
rs = conn.executeQuery(sql);
} catch (Exception e) {
out.println("访问数据库出错！");
}
out.write("\r\n");
out.write("<html>\r\n");
out.write(" <head>\r\n");
out.write(" <title>分页浏览数据库的技巧</title>\r\n");
out.write(" </head>\r\n");
out.write(" <body bgcolor=\"#FFFFFF\">\r\n");
out.write(" <h2 ALIGN=\"CENTER\">JSP中的分页控制, Version 4</h2>\r\n");
out.write(" <hr>\r\n");
out.write(" <center>\r\n");
out.write(" <table border> \r\n");
out.write(" <TR bgcolor=lightblue>\r\n");
out.write(" <TH>学生编号</TH>\r\n");
out.write(" <TH>学生姓名</TH>\r\n");
out.write(" <TH>性别</TH>\r\n");
out.write(" <TH>联系电话</TH>\r\n");
out.write(" </TR>\r\n");
out.write(" ");
rsTmp = conn.executeQuery("select count(*) as mycount from student");
rsTmp.next();
int totalrecord = rsTmp.getInt("mycount");
if (totalrecord % PageSize == 0) {
totalPage = totalrecord / PageSize; // 如果是当前页码的整数倍
} else {
totalPage = (int) Math.floor(totalrecord / PageSize) + 1; // 如果最后还空余一页
}
if (totalPage == 0) {
totalPage = 1;
}
rsTmp.close();
try {
if (request.getParameter("Page") == null || request.getParameter("Page").equals("")) {
Page = 1;
} else {
Page = Integer.parseInt(request.getParameter("Page"));
}
} catch (java.lang.NumberFormatException e) { // 捕获用户从浏览器地址拦直接输入Page=sdfsdfsdf所造成的异常
Page = 1;
}
if (Page < 1) {
Page = 1;
}
if (Page > totalPage) {
Page = totalPage;
}
out.println(ShowOnePage(rs, Page, PageSize));
out.write("\r\n");
out.write(" </table>\r\n");
out.write(" <form Action=\"pagev4.jsp\" Method=\"GET\">\r\n");
out.write(" ");
if (Page != 1) {
out.println("<A HREF=pagev4.jsp?Page=1>第一页</A>");
out.println("<A HREF=pagev4.jsp?Page=" + (Page - 1) + ">上一页</A>");
}
if (Page != totalPage) {
out.println("<A HREF=pagev4.jsp?Page=" + (Page + 1) + ">下一页</A>");
out.println("<A HREF=pagev4.jsp?Page=" + totalPage + ">最后一页</A>");
}
rs.close();
out.write("\r\n");
out.write(" <p>输入页数：<input TYPE=\"TEXT\" Name=\"Page\" SIZE=\"3\"> 页数:<font COLOR=\"Red\">");
out.print(Page);
out.write('/');
out.print(totalPage);
out.write("</font> \r\n");
out.write(" </p>\r\n");
out.write(" </form>\r\n");
out.write(" </center>\r\n");
out.write(" <hr>\r\n");
out.write(" </body>\r\n");
out.write("</html>\r\n");
} catch (Throwable t) {
if (!(t instanceof SkipPageException)){
out = _jspx_out;
if (out != null && out.getBufferSize() != 0)
try { out.clearBuffer(); } catch (java.io.IOException e) {}
if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
}
} finally {
_jspxFactory.releasePageContext(_jspx_page_context);
}
}
}
jsp分页显示例子,简单明了
5星 · 超过95%的资源 需积分: 5 56 浏览量
2011-03-05
13:30:22
上传
评论
收藏 67KB ZIP 举报 
Webfenyexianshi.zip （43个子文件） 
Webfenyexianshi test src conf 
MANIFEST.MF 23B java db Conn.java 2KB web WEB-INF web.xml 490B index.jsp 466B pagev4.jsp 4KB META-INF context.xml 74B pagev1.jsp 2KB pagev2.jsp 2KB pagev3.jsp 3KB pagevdisp.jsp 3KB build generated src org apache jsp pagevdisp_jsp.class.smap 161B pagev3_jsp.java 6KB pagev3_jsp.class.smap 155B pagev1_jsp.class.smap 137B pagev2_jsp.java 5KB pagev1_jsp.java 5KB pagevdisp_jsp.java 6KB pagev4_jsp.class.smap 179B pagev4_jsp.java 8KB pagev2_jsp.class.smap 127B classes org apache jsp pagev3_jsp.class 8KB pagevdisp_jsp.class 8KB pagev1_jsp.class 6KB pagev2_jsp.class 7KB pagev4_jsp.class 8KB web WEB-INF web.xml 490B classes db Conn.class 3KB index.jsp 466B pagev4.jsp 4KB META-INF context.xml 74B MANIFEST.MF 23B pagev1.jsp 2KB pagev2.jsp 2KB pagev3.jsp 3KB pagevdisp.jsp 3KB build.xml 3KB nbproject build-impl.xml 43KB private private.xml 211B private.properties 2KB ant-deploy.xml 2KB project.properties 2KB project.xml 662B genfiles.properties 455B资源评论
wyttyut002015-06-05很好，就是和我想要的不一样- EasonGu2012-09-25谢谢楼主提供，这也太简单了点。。。
- luoqqsh2014-05-26x虚心学习虚心学习
- KARAS_YOYO2012-12-20跟我想的不太一样，不过还是谢谢了
- hsd黄2013-06-03谢谢楼主，不过和我想的不一样
