记录多时需要分页显示。分页显示需要查找出记录总数,然后根据煤业的记录数计算startRow与maxRow,然后在查找数据,下面使用queryPagination.jsp页面用于显示分页效果Pagination.java用于实现分页功能。代码如下:
queryPagination.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/functions" prefix="fn"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@page import="com.helloweenvsfei.util.Pagination"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
<style type="text/css">
body, td, input, select, button {
font-size: 12px; }
table {
border-collapse: collapse;
border: 1px solid #000000;
}
td {
border: 1px solid #000000;
padding: 2px;
}
.title td {
text-align: center;
background: #DDDDDD;
}
</style>
</head>
<body>
<%
request.setAttribute("pagination", new Pagination(request, response));
%>
<sql:setDataSource driver="com.mysql.jdbc.Driver" user="root"
password="admin"
url="jdbc:mysql://localhost:3306/mysql?charachterEncoding=UTF-8"
var=