jsp实现页面分页功能代码
来源:
中文源码网 浏览:237 次 日期:2024-05-18 11:42:43
【下载文档: jsp实现页面分页功能代码.txt 】
jsp实现页面分页功能代码
核心代码:
<%@ page contentType="text/html" pageEncoding="GB2312" language="java"%>
<%@ page import="java.sql.*"%>
hello
<%!
public static final String DRIVER = "com.mysql.jdbc.Driver";
public static final String USER = "root";
public static final String PASS = "";
public static final String URL = "jdbc:mysql://localhost:3306/teachinfo";
public static final int PAGESIZE = 5;
int pageCount;
int curPage = 1;
%>
<%
//一页放5个
String user = null;
String pass = null;
try{
Class.forName(DRIVER);
Connection con = DriverManager.getConnection(URL,USER,PASS);
String sql = "SELECT * FROM department";
PreparedStatement stat = con.prepareStatement(sql,ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_READ_ONLY);
ResultSet rs = stat.executeQuery();
rs.last();
int size = rs.getRow();
pageCount = (size%PAGESIZE==0)?(size/PAGESIZE):(size/PAGESIZE+1);
String tmp = request.getParameter("curPage");
if(tmp==null){
tmp="1";
}
curPage = Integer.parseInt(tmp);
if(curPage>=pageCount) curPage = pageCount;
boolean flag = rs.absolute((curPage-1)*PAGESIZE+1);
out.println(curPage);//输出到屏幕上
int count = 0;
do{
if(count>=PAGESIZE)break;
int departmentid = rs.getInt(1);
String departmentname = rs.getString(2);
count++;
%>
<%=departmentid%> |
<%=departmentname%> |
<%
}while(rs.next());
con.close();
}
catch(Exception e){
}
%>
首页上一页下一页尾页第<%=curPage%>页/共<%=pageCount%>页
本篇代码希望各位朋友喜欢!