JSP+JDBC_假分页
假分页:将数据全部读取出来,放入ResultSet中,再分别显示,具体代码如下:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<head>
<title></title>
</head>
<body>
<center>
<h1>
人员列表
</h1>
<hr>
<br>
<%!
final String jspUrl="index_false_1.jsp";
%>
<%
//定义如下分页变量
//1.定义每页要显示的页数
int lineSize = 3;
//2.定义一个当前是第几页
int currentPage = 1;
// 计算出总页数
int pageSize= 0;
// 总记录数
int allRecorders=0;
// 接收传过来的当前页,第一次打开时没有传过来的值会发生异常,因此要try{}catch{}
try{
currentPage = Integer.parseInt(request.getParameter("cp"));
}catch(Exception e){
}
final String DBDRIVER = "org.gjt.mm.mysql.Driver";
final String DBURL = "jdbc:mysql://59.64.167.41:3306/ren";
final String DBUSER = "root";
final String DBPASSWORD = "111111";
Connection conn = null;
%>
<%
try {
Class.forName(DBDRIVER);
conn = DriverManager.getConnection(DBURL, DBUSER, DBPASSWORD);
PreparedStatement pstmt = null;
//先求出记录总数
String sql = "select count(Id) from person";
pstmt = conn.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();
if(rs .next())
{