JSTL实现分页

开发环境:Myeclipse10、sqlservler2005、tomcat7.0.40

<%@ page language=”java” import=”java.util.*” pageEncoding=”UTF-8″%><%@ taglib prefix=”c” uri=”http://java.sun.com/jsp/jstl/core” %><%@ taglib prefix=”sql” uri=”http://java.sun.com/jsp/jstl/sql” %><%@ taglib prefix=”fmt” uri=”http://java.sun.com/jsp/jstl/fmt” %><%@ taglib prefix=”fn” uri=”http://java.sun.com/jsp/jstl/functions” %><%@include file=”conn.jsp” %><!DOCTYPE HTML PUBLIC “-//W3C//DTD HTML 4.01 Transitional//EN”><html> <head><base href=”<%=basePath%>”><title>My JSP ‘fenye.jsp’ starting page</title><meta http-equiv=”pragma” content=”no-cache”><meta http-equiv=”cache-control” content=”no-cache”><meta http-equiv=”expires” content=”0″><meta http-equiv=”keywords” content=”keyword1,keyword2,keyword3″><meta http-equiv=”description” content=”This is my page”><!–<link type=”text/css” href=”styles.css”>–></head><body> <div> <c:set var=”pagesize” value=”4″ scope=”page” /><sql:query var=”result1″ maxRows=”6″ startRow=”0″> select * from Table_1</sql:query><!–记录数 –><c:set var=”number” value=”${result1.rowCount}” scope=”page” /><!– 计算分页数 –> <c:set var=”pagenumber” value=”${(number+pagesize-1)/pagesize}” /><font color=”blue”><c:out value=”${number}” /></font><table><tr><td>书名</td><td>作者</td><td>价格</td><th>操作</th></tr><!–判断是否有信息 –><!– 如果类别为空 otherwise –><c:choose><c:when test=”${empty result1.rows}”><tr><td colspan=”4″>暂时没有图书!</td></tr></c:when><c:otherwise><c:forEach items=”${result1.rowsByIndex}” var=”row1″ begin=”${param.start}” end=”${param.start+pagesize-1}” ><tr><td>${row1[0]}</td><td>${row1[1]}</td><td>${row1[2]}</td><td><a href=”delete.jsp?name=${row1[0]}”>删除</a></td></tr></c:forEach></c:otherwise></c:choose></table><!–分页 –><c:choose><c:when test=”${param.start>0}” ><a href=”fenye.jsp?start=${param.start-pagesize}”>上一页</a></c:when><c:otherwise>上一页</c:otherwise></c:choose><c:choose><c:when test=”${param.start+pagesize<number}” ><a href=”fenye.jsp?start=${param.start+pagesize}”>下一页</a></c:when><c:otherwise>下一页</c:otherwise></c:choose><!– 显示记录数 –>共<font color=”red”>${number}</font>条记录 <!– 显示分页数 –>共<fmt:parseNumber type=”number” value=”${pagenumber}” integerOnly=”true” />页</div> </body></html>,香港服务器,香港服务器,虚拟主机寂寞的人总是记住生命中出现的每一个人,

JSTL实现分页

相关文章:

你感兴趣的文章:

标签云: