使用JSTL做的分页程序

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!-- Author by JohnConnor -->
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %>
<%@ 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/functions" prefix="fn" %>
<%@ taglib uri="http://jakarta.apache.org/taglibs/string-1.1" prefix="str" %>
<!-- ----------------------------------- -->
<sql:setDataSource driver="com.mysql.jdbc.Driver"
       url="jdbc:mysql://localhost:3306/数据库名"
       password="密码"
       user="用户名"
       var="ds"/>
<sql:query var="count" dataSource="${ds}">
SELECT ID FROM 数据库名
</sql:query>
<c:set var="rowCount">${count.rowCount}</c:set>
<c:set var="pageSize" value="30"></c:set><!-- pageSize为每页显示的条数-->
<c:set var="pageCount">${rowCount / pageSize}</c:set><!--pageCount为页数-->
<c:choose>
<c:when test="${(rowCount % pageSize) > 0}">
<c:set var="pageCount">${fn:split((pageCount + 1),'.')[0]}</c:set>
</c:when>
<c:otherwise>
<c:set var="pageCount">${fn:split(pageCount,'.')[0]}</c:set>
</c:otherwise>
</c:choose>
<c:set var="strPage">${param.page}</c:set>
<c:choose>
<c:when test="${empty strPage}">
<c:set var="currentPage">1</c:set>
</c:when>
<c:otherwise>
<c:set var="currentPage">${strPage}</c:set>
</c:otherwise>
</c:choose>
<!-- ----------------------------------- -->

使用时请保留author by