Ekiras

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) ...

Syntax to use OrderBy in Hibernate Criteria Query The order can be specified using addOrder on a Criteria Object criteria.addOrder(Order.asc("propertyName")) criteria.addOrder(Order.desc("propertyName")) Order results according to an order in Hibernate  Suppose we have a class Category.java package com.ekiras.domain; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.OneToMany; import javax.persistence.Table; @Entity @Table(name="category") public class Category { public Category(){} public Category(Long id){ this.id = id; } public Category(Long id, String name){ this.id = id; this.name = name; } @Id @Column(nullable=false, name="id") @GeneratedValue(strategy=GenerationType.AUTO) private Long id; @Column(nullable=false, name="name") private String name; // Gett...

Syntax to get List of domain Object list can be used on the Criteria object as shown below. criteria.list() How to get a List of a Domain class using Hibernate's Criteria Query. If we have a domain class Category  as shown below. Catgeory.class package com.ekiras.domain; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.OneToMany; import javax.persistence.Table; @Entity @Table(name="category") public class Category { public Category(){} public Category(Long id){ this.id = id; } public Category(Long id, String name){ this.id = id; this.name = name; } @Id @Column(nullable=false, name="id") @GeneratedValue(strategy=GenerationType.AUTO) private Long id; @Column(nullable=false, name="name") private String name; // Getters and Setters } We can get the list of all the categories ...

Points To Remember Create a Pagination Taglib using this example . Add Bootstrap css and js in the jsp you want to do pagination and include the taglib in the jsp. Pagination in Spring Hibernate Application using Bootstrap Create a Domain Person. Create a Service PersonService Create a Dao PersonDao . Create a Controller PersonController . Create a Taglib PaginationTaglib. Person.java package com.ekiras.domain; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.Table; @Entity @Table(name="person") public class Person { public Person(){}; public Person(String name,Integer age){ this.name = name; this.age = age; } @Id @GeneratedValue(strategy=GenerationType.AUTO) @Column(name="id") private Long id; @Column(name="name") private String name; @Column(name="age") private Integer age; ...