Spring Hibernate实现分页功能_Java教程

Spring Hibernate实现分页功能

2020-09-24 15:52Coder_py Java教程

这篇文章主要为大家详细介绍了Spring Hibernate实现分页功能的相关代码，具有一定的参考价值，感兴趣的小伙伴们可以参考一下

本实例采用Spring+Hibernate实现简单的分页功能，供大家参考，具体内容如下

最关键的是运用Hibernate的query里面的两个方法：

query.setFirstResult((p.getPage()-1)*p.getRows()); 指定从那个对象开始查询，参数的索引位置是从0开始的。

query.setMaxResults(p.getRows()); 分页时，一次最多产寻的对象数主要实现类：

									package com.paging;

									import java.util.List;

									import javax.annotation.Resource;

									import org.hibernate.Query;

									import org.hibernate.SessionFactory;

									import com.user.User;

									import sun.nio.cs.US_ASCII;

									public class Paging {

									 final int num=3;

									 @Resource

									 SessionFactory sessionFactory;

									 public void setSessionFactory(SessionFactory sessionFactory) {

									 this.sessionFactory = sessionFactory;

									 }

									 public List<User> paging(int index) {

									 String hql = "from User";

									 Query query = sessionFactory.getCurrentSession().createQuery(hql);

									 query.setFirstResult((index-1)*num);

									 query.setMaxResults(num);

									 return query.list();

									 }

									}

web层:

									package com.web;

									import java.util.List;

									import javax.annotation.Resource;

									import org.springframework.stereotype.Controller;

									import org.springframework.ui.Model;

									import org.springframework.web.bind.annotation.RequestMapping;

									import com.paging.Paging;

									import com.user.User;

									@Controller

									@RequestMapping("/Page")

									public class Web {

									 @Resource

									 Paging paging;

									 public void setPaging(Paging paging) {

									 this.paging = paging;

									 }

									 @RequestMapping("/page")

									 public String page(Model model,int index) {

									 List<User> list = paging.paging(index);

									 model.addAttribute("list", list);

									 return "index";

									 }

									}

jsp页面：

									<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>

									<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>

									<%

									String path = request.getContextPath();

									String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";

									%>

									<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

									<html>

									 <head>

									 <base href="<%=basePath%>" rel="external nofollow" >

									 <title>My JSP 'index.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 rel="stylesheet" type="text/css" href="styles.css" rel="external nofollow" >

									 -->

									 </head>

									 <body>

									 <h1><a href="/Paging/Page/page?index=1" rel="external nofollow" >1</a></h1>

									 <h1><a href="/Paging/Page/page?index=2" rel="external nofollow" >2</a></h1>

									 <h1><a href="/Paging/Page/page?index=3" rel="external nofollow" >3</a></h1>

									 <c:if test="${!empty list }">

									 <c:forEach items="${list}" var="list">

									 ${list.name}

									 ${list.adderss}

									     </c:forEach>

									 </c:if>

									 </body>

									</html>