Jsp刷新分页模板，很全

 ???????<%--page的分页--%> ???????<style type="text/css"> ???????????a { ???????????????color: #555555; ???????????????text-decoration: none; ???????????????cursor: pointer; ???????????} ???????????.pages a.p_pre:hover { ???????????????background-color: #eaeaea; ???????????????color: #555555; ???????????????border: 1px solid #cccccc; ???????????} ???????????.pages a { ???????????????height: 36px; ???????????????line-height: 36px; ???????????????overflow: hidden; ???????????????color: #666666; ???????????????font-size: 16px; ???????????????text-align: center; ???????????????display: inline-block; ???????????????padding: 0 12px; ???????????????margin: 0 4px; ???????????????border: 1px solid #cccccc; ???????????????-webkit-border-radius: 2px; ???????????????-moz-border-radius: 2px; ???????????????border-radius: 2px; ???????????} ???????????.pages a:hover, .pages a.cur { ???????????????color: #FFF; ???????????????background-color: #DD4E62; ???????????????border: 1px solid #DD4E62; ???????????} ???????</style> ???????<div class="pages"> ???????????<c:if test="${pager.totalPage>=1}"> ???????????????<a href="${pageContext.request.contextPath}${pager.url}&pageindex=1" class="p_pre">首页</a> ???????????????<c:if test="${pager.pageIndex>1}"> ???????????????????<a href="${pageContext.request.contextPath}${pager.url}&pageindex=${pager.pageIndex-1}" class="p_pre">上一页</a> ???????????????</c:if> ???????????????<c:forEach ?var="temp" begin="${pager.pageIndex>3?pager.pageIndex-3:1}" end="${pager.totalPage-pager.pageIndex>3?pager.pageIndex+3:pager.totalPage}" step="1"> ???????????????????<c:if test="${pager.pageIndex==temp}"> ???????????????????????<a href="${pageContext.request.contextPath}${pager.url}&pageindex=${temp}" class="cur">${temp}</a> ???????????????????</c:if> ???????????????????<c:if test="${pager.pageIndex!=temp}"> ???????????????????????<a href="${pageContext.request.contextPath}${pager.url}&pageindex=${temp}">${temp}</a> ???????????????????</c:if> ???????????????</c:forEach> ???????????????<c:if test="${pager.pageIndex<pager.totalPage}"> ???????????????????<a href="${pageContext.request.contextPath}${pager.url}&pageindex=${pager.pageIndex+1}" class="p_pre">下一页</a> ???????????????</c:if> ???????????????<a href="${pageContext.request.contextPath}${pager.url}&pageindex=${pager.totalPage}" class="p_pre">尾页</a> ???????????</c:if> ???????????<c:if test="${pager.totalPage==0}"> ???????????????<a href="#" class="cur">暂无记录</a> ???????????</c:if> ???????</div>

<c:forEach items="${pager.lists}" var="item"> ???????????????????<li class="w-280 m-l-13 m-r-13 bg-c-ffffff m-t-8 m-b-23 fl"> ???????????????????????<a href="${pageContext.request.contextPath}/selectAllSys_videoByCid/${item.cid}" class="dsblock w-260 hg-140 ovhidden "> ???????????????????????????<img src="${pageContext.request.contextPath}/jsp/front/videopic/${item.cimage}" alt=""/> ???????????????????????????<div class="course-label"> ???????????????????????????????<c:if test="${item.ctype==1}"> ???????????????????????????????????<label>精品视频</label> ???????????????????????????????</c:if> ???????????????????????????????<c:if test="${item.ctype!=1}"> ???????????????????????????????????<label>最新视频</label> ???????????????????????????????</c:if> ???????????????????????????????<%--<label>${item.ctype}</label>--%> ???????????????????????????</div> ???????????????????????</a> ???????????????????????<div class="w-255 p-l-10 p-r-15 fl"> ???????????????????????????<div class="home_calsstxt w-200 fl"> ???????????????????????????????<h3 class="w-all fs-16 ftc-000000 line-h32 ?one_hidden ?m-t-6 fl">${item.cname}</h3> ???????????????????????????????<span class="dsblock w-all fs-14 ftc-ff0000 line-h32 fl">¥${item.cprice}</span> </div> ???????????????????????</div> ???????????????????</li> ???????????????</c:forEach>

package cn.dawn.util;import java.util.List;public class PagerInfo<T> { ???????????private int totalPage;// 总页数 ???????private int totalSize;// 总记录数 ???????private int pageSize;//每页的记录数 ???????private int pageIndex;//页码 ???????private String url;//地址 ???????public String getUrl() { ???????????return url; ???????} ???????public void setUrl(String url) { ???????????this.url = url; ???????} ???????private List<T> lists; ???????public int getTotalPage() { ???????????//如果总记录数除以每页显示的记录数能整除，那么总页数等于商，否则商+1 ???????????int total=totalSize%pageSize==0?totalSize/pageSize:totalSize/pageSize+1; ???????????return total; ???????} ???????public void setTotalPage(int totalPage) { ???????????this.totalPage = totalPage; ???????} ???????public int getTotalSize() { ???????????return totalSize; ???????} ???????public void setTotalSize(int totalSize) { ???????????this.totalSize = totalSize; ???????} ???????public List<T> getLists() { ???????????return lists; ???????} ???????public void setLists(List<T> lists) { ???????????this.lists = lists; ???????} ???????public int getPageSize() { ???????????return pageSize; ???????} ???????public void setPageSize(int pageSize) { ???????????this.pageSize = pageSize; ???????} ???????public int getPageIndex() { ???????????return pageIndex; ???????} ???????public void setPageIndex(int pageIndex) { ???????????this.pageIndex = pageIndex; ???????} ???????????}

 ???/*根据搜索框查视频列表*/ ???@RequestMapping("/searchcourselisttocontroller") ???public ?String searchcourselisttocontroller(Model model,Integer pageindex,String cname){ ???????if(cname==null){ ???????????cname=""; ???????} ???????try { ???????????PagerInfo<Sys_course> pager = iCourseService.searchcourselisttocontroller(pageindex,cname); ???????????pager.setUrl("/searchcourselisttocontroller?cname="+cname); ???????????model.addAttribute("pager",pager); ???????} catch (Exception e) { ???????????e.printStackTrace(); ???????} ???????return "searchcourselist"; ???}

 ???@Override ???public PagerInfo<Sys_course> selectAllTypeThreeSys_course(Integer pageindex) throws Exception { ???????int index2=pageindex==null?1:pageindex; ???????//分页的集合 ???????PagerInfo<Sys_course> page=new PagerInfo<Sys_course>(); ???????Map<String,Object> map=new HashMap<String,Object>(); ???????map.put("pageIndex",(index2-1)*8); ???????map.put("pageSize",8); ???????List<Sys_course> lists = iCourseDAO.selectAllTypeThreeSys_course(map); ???????page.setLists(lists); ???????page.setTotalSize(iCourseDAO.selectAllTypeThreeSys_courseCount(map)); ???????page.setPageSize(8); ???????page.setPageIndex(index2); ???????return page; ???}

 ???<select id="selectAllTypeThreeSys_course" resultType="Sys_course"> ???????SELECT * FROM sys_course WHERE cparent IN(SELECT c.cid AS ciddd ?FROM sys_course ?AS c WHERE cparent IN(SELECT cid FROM sys_course WHERE cparent=0)) ORDER BY ccreatetime DESC LIMIT #{pageIndex},#{pageSize} ???</select> ???<select id="selectAllTypeThreeSys_courseCount" resultType="int"> ???????SELECT COUNT(1) FROM sys_course WHERE cparent IN(SELECT c.cid AS ciddd ?FROM sys_course ?AS c WHERE cparent IN(SELECT cid FROM sys_course WHERE cparent=0)) ORDER BY ccreatetime DESC ???</select>

 ???@Test ???/* ???* 查询姓名中包含b的员工，并且按照薪水降序排序 ???* */ ???public void t12CriteriaPage(){ ???????int count=((Long)session.createCriteria(Emp.class) ???????????.add(Restrictions.ilike("name","b",MatchMode.ANYWHERE)) ???????????????.setProjection(Projections.count("name")).uniqueResult()).intValue(); ???????System.out.println(count); ???????//设置当前页和页大小 ???????int pageIndex=2; ???????int pageSize=2; ???????//计算总页数 ???????int totalPage=(count%pageSize==0)?(count/pageSize):(count/pageSize+1); ???????//根据薪水进行降序排序 ???????Criteria criteria = session.createCriteria(Emp.class) ???????????????.add(Restrictions.ilike("name","b",MatchMode.ANYWHERE)) ???????????????.addOrder(Order.desc("sal")); ???????//设置 起始页和页大小 ???????List<Emp> emps=criteria.setFirstResult((pageIndex-1)*pageSize) ???????????????.setMaxResults(pageSize).list(); ???????/*遍历*/ ???????for (Emp emp:emps){ ???????????System.out.println(emp); ???????} ???????/* ???????Hibernate: select count(this_.name) as y0_ from Emp this_ where lower(this_.name) like ? ???????3 ???????Hibernate: select this_.empId as empId1_1_0_, this_.name as name2_1_0_, this_.sal as sal3_1_0_, this_.job as job4_1_0_, this_.deptNo as deptNo5_1_0_ from Emp this_ where lower(this_.name) like ? order by this_.sal desc limit ?, ? ???????Hibernate: select dept0_.deptId as deptId1_0_0_, dept0_.name as name2_0_0_, dept0_.location as location3_0_0_ from Dept dept0_ where dept0_.deptId=? ???????Emp{empId=2, name=‘Ab‘, job=‘财务猿2‘, sal=5000.0, dept=Dept{deptId=1, name=‘xx部‘, location=‘1楼‘}} ???????* */ ???}

@Test ???/** ????* 分页 ????* ????* 01.查询总记录数 ????* 02.每页显示的数据 ????* 03.总页数 ????*/ ???public void t1Page(){ ???????String hql="select count(*) from Teacher";//会返回Long类型 ???????int counts=((Long)session.createQuery(hql).uniqueResult()).intValue(); ???????/*页大小*/ ???????int pageSize=2; ???????/*总页数*/ ???????int totalPages=(counts%pageSize==0)?(counts/pageSize):(counts/pageSize+1); ???????/*显示第二页内容*/ ???????int pageIndex=2; ???????hql="from Teacher"; ???????Query query = session.createQuery(hql);; ???????/*从哪一条开始查*/ ???????query.setFirstResult((pageIndex-1)*pageSize); ???????/*设置页大小*/ ???????query.setMaxResults(pageSize); ???????List<Teacher> teachers = query.list(); ???????for (Teacher t:teachers) { ???????????System.out.println(t); ???????} ???}