Hibernate : How to get List of records of an Entity

How to get List of records in Hibernate

    // List all records
    public List<User> list(){
        return sessionFactory.getCurrentSession()
                .createCriteria(User.class).list(); // List all records
    }

    // List records based on MAX
    public List<User> list(Integer max){
        return sessionFactory.getCurrentSession().createCriteria(User.class)
                .setMaxResults(max).list(); 
    }

    // List records with MAX records and OFFSET
    public List<User> list(Integer max, Integer offset){
        return sessionFactory.getCurrentSession().createCriteria(User.class)
                .setMaxResults(max) 
                .setFirstResult(offset)
                .list();
    }

    // List records with MAX records and OFFSET and ORDER by id field of User class
    public List<User> list(Integer max, Integer offset){
        return sessionFactory.getCurrentSession().createCriteria(User.class)
                .setMaxResults(max) 
                .setFirstResult(offset)
                .addOrder(Order.asc("id"))
                .list();
    }
this is body.

Leave a Comment

Powered by Blogger.