当前位置： 移动技术网 > IT编程>开发语言>Java > jsp实现页面分页功能代码

jsp实现页面分页功能代码

2017年12月08日  | 移动技术网IT编程  | 我要评论

核心代码：

<%@ 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>

本篇代码希望各位朋友喜欢！

您可能感兴趣的文章:

如对本文有疑问， 点击进行留言回复！！

相关文章:

验证码：
最近更新的文章
大家感兴趣的文章
移动技术网