不要因为没有阳光，而走不进春天，不要因为没有歌声，而放弃自己的追求，不要因为没有掌声，而丢掉自己的理想。其实每一条都通往阳光的大道，都充满坎坷，每一条通向理想的途径，都充满了艰辛与汗水！
核心代码：
<%@ page contentType="text/html" pageEncoding="GB2312" language="java"%>
<%@ page import="java.sql.*"%>
<html>
<head>
<title>hello</title>
</head>
<body>
<table border="1" spacing="2">
<%!
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++;
%>
<tr>
<td><%=departmentid%></td>
<td><%=departmentname%></td>
</tr>
<%
}while(rs.next());
con.close();
}
catch(Exception e){
}
%>
</table>
<a href = "fenye.jsp?curPage=1" >首页</a>
<a href = "fenye.jsp?curPage=<%=curPage-1%>" >上一页</a>
<a href = "fenye.jsp?curPage=<%=curPage+1%>" >下一页</a>
<a href = "fenye.jsp?curPage=<%=pageCount%>" >尾页</a>
第<%=curPage%>页/共<%=pageCount%>页
</body>
</html>
本篇代码希望各位朋友喜欢！
到此这篇关于javascriptp如何实现页面分页功能代码就介绍到这了。做人，虚心若竹，始终谦逊、矜持；傲骨像梅花，保持清雅，凛然。旁人怎么看待，那是别人的事情，人无需自卑，亦不能自负，一定要努力做最好的自己。更多相关javascriptp如何实现页面分页功能代码内容请查看相关栏目，小编编辑不易，再次感谢大家的支持！