Can Hibernate alone implement pagination?

[Kunal Lakhani]

I have to implement a pagination concept, where a page shows only a limited subset (say, 10 Items) at a time, and users can navigate to the next and previous pages manually.

crit.setFirstResult(0);
crit.setMaxResults(20);
List results = crit.list();

This code produces 1st 20 records. But what about navigation to another page, where next set of 20 records are displayed?

Can Hibernate alone solve this problem, without going into other libraries like Display tag libraries & Jsp taglib?

[Hemant Thard]

Hi Kunal,

you can do that by using setFirstResult() method.

Check this Example

[Kunal Lakhani]

Thanks Hemant Thard. It fetches me required number of records in a jsp page. But how to navigate to another page where it will fetch me another set of records. Should i run the servlet & Dao class again?

[Bear Bibeault]

All you need to do is a little math. No frameworks needed for that.

[Kunal Lakhani]

Thanks Bear Bibeault.
I have fetched all the 30records, but i need to display them 5 at a page, each record with 2 radio buttons.

Should i call servlet & dao class again,but that will be a lot of db hits? Or should i have a link in jsp page invoking the dao code with next page number appended to the url?

Or should i invoke the dao code from jsp with page number incremented by 1? No i guess that's a bad idea

Can you please provide me some hint?

[Kunal Lakhani]

One option is to use code something like this

<jsp:root version="1.2" xmlns:jsp="http://java.sun.com/JSP/Page"
 xmlns:c="urn:jsptld:http://java.sun.com/jsp/jstl/core">
 <jsp:directive.page contentType="text/html; charset=UTF-8" />

 <link rel="stylesheet" type="text/css" href="css/screen.css" />
 <jsp:scriptlet>
     int pageNumber=1;
     if(request.getParameter("page") != null) {
       session.setAttribute("page", request.getParameter("page"));
       pageNumber = Integer.parseInt(request.getParameter("page"));
     } else {
       session.setAttribute("page", "1");
     }
     String nextPage = (pageNumber +1) + "";
     session.setAttribute( "EmpList", data.DAO.getData(pageNumber));
     System.out.println(((java.util.List)session.getAttribute("EmpList")).size());
     String myUrl = "pagingEmp.jsp?page=" + nextPage;
     System.out.println(myUrl);

     pageContext.setAttribute("myUrl", myUrl);
 </jsp:scriptlet>
 <h2 align="center">Emp Table with Display tag</h2>
 <jsp:useBean id="EmpList" scope="session" type="java.util.List"></jsp:useBean>
 <table>
    <tr>
      <th>Employee Id</th>
      <th>Name</th>
      <th>Job</th>
      <th>Salary</th>
    </tr>
    <c:forEach items="${EmpList}" var="emp" begin="0" end="10">
      <tr>
        <td><c:out value="${emp.empId}"></c:out></td>
        <td><c:out value="${emp.empName}"></c:out></td>
        <td><c:out value="${emp.empJob}"></c:out></td>
        <td><c:out value="${emp.empSal}"></c:out></td>
      </tr>
    </c:forEach>
 
    <tr>
      <td ></td>
      <td ><a >nextPage</a></td>
    </tr>
  </table>
</jsp:root>

Or, put the code which are in scriplet into a servlet, and call it each time . But, will that be efficient, if need to go for 70Records, 5 at a time, that too with 2 radio buttons, for getting user choice?

[Kunal Lakhani]

One more thing setFirstResult() returns the record stating from the arg value. But i need random records

[Kunal Lakhani]

Since i have the list of random Records, i should go for some that implements it in jsp itself, any way of iterating into the list for 5records

[Kunal Lakhani]

Bear Bibeault, what should i do?

[Ankit Kumar Yadav]

Kunal, if you got the solution, let us know. i am facing the same problem

[Kunal Lakhani]

The problem is solved by implementing pagination in jsp, not via hibernate

[Bear Bibeault]

All you need to do is keep track of which page number you want to look at, and do a little math to figure out what the value to pass to setFirstResult().