Javatpoint Logo
JavaTpoint

how to do pagination in Hibernate ? a

By: rahimk*** On: Tue Jan 31 11:44:00 IST 2017     Question Reputation0 Answer Reputation0 Quiz Belt Series Points0  0Blank User
how to do pagination in Hibernate ? and i dont want to fetch whole record at a time...Up0Down
hibernate  x  70Tags

 
You can take help of query Interface,
There are two methods to use pagination (setFirstResult(),setMaxResult).
Below is an exaple.........
public static List getData(int pageNumber) {
SessionFactory sessionFactory = new Configuration().configure("hibernate.cfg.xml").buildSessionFactory();
Session session = sessionFactory.openSession();
List result = null;
try {
session.beginTransaction();
Query query = session.createQuery("from Image");
query = query.setFirstResult(pageSize * (pageNumber - 1));
query.setMaxResults(pageSize);
result = query.list();
session.getTransaction().commit();
} catch (Exception e) {
e.printStackTrace();
}
return result;		Image Created0Down
By: [email protected] On: Tue Feb 14 10:02:39 IST 2017 Question Reputation0 Answer Reputation0 Belt Series Points0 0User Image
Are You Satisfied :0Yes0No