How to enable Hibernate SQL Logging in Spring Boot using application.properties

logging.level.org.hibernate.SQL=DEBUG

spring.jpa.hibernate.ddl-auto=update
spring.datasource.url=jdbc:mysql://localhost/ekiras
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
logging.level.org.hibernate.SQL=DEBUG

STEP 1 :: Add the dependencies

    
    compile('org.springframework.boot:spring-boot-starter-data-jpa')
    compile('org.springframework.boot:spring-boot-starter-jdbc')
    runtime('mysql:mysql-connector-java')

STEP 2 :: Make Entity classes

• This one topic can have many questions.
• All the questions will be deleted or updated when topic is deleted/updated.
• Its mapping is defined by Entity Question by the mapping of topic variable.
• It will give a list of all question of a topic when it is fetched
• If you do not need questions when topic is fetched then make fetch type as LAZY

    @OneToMany(cascade = CascadeType.ALL,mappedBy = "topic",fetch = FetchType.EAGER)
    private List questions;

• One question can belong to only one topic.
• When you fetch question, it will not fetch the topic because the fetch mode is LAZY
• It will join make the foreign key column as topic_id. If you want any other name, then you can define using @JoinColumn annotation

    @ManyToOne(fetch = FetchType.LAZY)
    @JoinColumn(name = "topic_id")
    private Topic topic;

Points To Remember

Make a field Non Updatable in an Hibernate Entity

@Entity
public class User {

    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Long id;

    @Column(name = "email",updatable = false, nullable = false, unique = true)
    private String email;

    // GETTERS and SETTERS
}

How to Send Rest Response For Lazy fetched Hibernate Objects with Jackson

@Configuration
@EnableWebMvc
public class HibernateAwareObjectMapper extends WebMvcConfigurerAdapter {

    //More configuration....

    /* Here we register the Hibernate4Module into an ObjectMapper, then set this custom-configured ObjectMapper
     * to the MessageConverter and return it to be added to the HttpMessageConverters of our application*/
    public MappingJackson2HttpMessageConverter jacksonMessageConverter(){
        MappingJackson2HttpMessageConverter messageConverter = new MappingJackson2HttpMessageConverter();

        ObjectMapper mapper = new ObjectMapper();
        //Registering Hibernate4Module to support lazy objects
        mapper.registerModule(new Hibernate4Module());

        messageConverter.setObjectMapper(mapper);
        return messageConverter;

    }

    @Override
    public void configureMessageConverters(List<HttpMessageConverter<?>> converters) {
        //Here we add our custom-configured HttpMessageConverter
        converters.add(jacksonMessageConverter());
        super.configureMessageConverters(converters);
    }

    //More configuration....

}

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();
    }

Points To Remember

• java.util.Date 
• java.util.Calendar

How to use @Temporal annotation

@Target({ METHOD, FIELD })
@Retention(RUNTIME)
public @interface Temporal {
 /**
  * The type used in mapping <code>java.util.Date</code> or <code>java.util.Calendar</code>.
  */
 TemporalType value();
}

public enum TemporalType {
 DATE,
 TIME,
 TIMESTAMP
}

package com.ekiras.domian;

import javax.persistence.*;
import java.util.Date;

@Entity
public class User {

    @Id
    @SequenceGenerator(name = "test")
    @GeneratedValue(strategy = GenerationType.AUTO, generator = "test")
    private Long id;

    @Temporal(value = TemporalType.DATE)
    private Date dateCreated1;

    @Temporal(value = TemporalType.TIMESTAMP)
    private Date dateCreated2;


    @Temporal(value = TemporalType.TIME)
    private Date dateCreated3;

    // GETTERS and SETTERS
}

Caused by: org.hibernate.AnnotationException: @Temporal should only be set on a java.util.Date or java.util.Calendar property: com.ekiras.domian.User.name
 at org.hibernate.cfg.annotations.SimpleValueBinder.setType(SimpleValueBinder.java:182)
 at org.hibernate.cfg.annotations.PropertyBinder.makePropertyAndValue(Propertyjava:195)
 at org.hibernate.cfg.annotations.PropertyBinder.makePropertyValueAndBind(PropertyBinder.java:216)
 at org.hibernate.cfg.AnnotationBinder.processElementAnnotations(AnnotationBinder.java:2241)
 at org.hibernate.cfg.AnnotationBinder.processIdPropertiesIfNotAlready(AnnotationBinder.java:963)
 at org.hibernate.cfg.AnnotationBinder.bindClass(AnnotationBinder.java:796)
 at org.hibernate.cfg.Configuration$MetadataSourceQueue.processAnnotatedClassesQueue(Configuration.java:3845)
 at org.hibernate.cfg.Configuration$MetadataSourceQueue.processMetadata(Configuration.java:3799)
 at org.hibernate.cfg.Configuration.secondPassCompile(Configuration.java:1412)
 at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1846)
 at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$4.perform(EntityManagerFactoryBuilderImpl.java:857)
 ... 23 more

Points To Remember

• @Column annotation is used to define the column name, type, constraints.
• It should be used with the fields either above the getter or above field declaration.

How to use @Column Annotation in Hibernate

package com.ekiras.domian;

import com.ekiras.enums.Gender;

import javax.persistence.*;
import java.util.Date;

@Entity
public class User {

    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Long id;

    @Column(name = "name",length = 100)
    private String name;
    
    @Column(name = "current_age")
    private Integer age;

    @Column(name = "address",columnDefinition = "text")
    private String address;
    
    @Column
    private Gender gender;

    @Column(name = "email",updatable = false, nullable = false, unique = true)
    private String email;

    private Long mobile;

    @Temporal(value = TemporalType.DATE)
    private Date dateCreated;

   // GETTERS AND SETTERS
}

What @Column annotation did is

• See the use of @Temporal annotation in hibernate.
• See the how to use columnDefinition property of @Column annotation.

Points to remember

How to use @Id annotation in Hibernate

@Target({METHOD, FIELD})
@Retention(RUNTIME)

public @interface Id {
}

Caused by: javax.persistence.PersistenceException: [PersistenceUnit: default] Unable to build Hibernate SessionFactory
 at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.persistenceException(EntityManagerFactoryBuilderImpl.java:1249)
 at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.access$600(EntityManagerFactoryBuilderImpl.java:120)
 at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$4.perform(EntityManagerFactoryBuilderImpl.java:860)
 at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$4.perform(EntityManagerFactoryBuilderImpl.java:850)
 at org.hibernate.boot.registry.classloading.internal.ClassLoaderServiceImpl.withTccl(ClassLoaderServiceImpl.java:425)
 at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:849)
 at org.springframework.orm.jpa.vendor.SpringHibernateJpaPersistenceProvider.createContainerEntityManagerFactory(SpringHibernateJpaPersistenceProvider.java:60)
 at org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean.createNativeEntityManagerFactory(LocalContainerEntityManagerFactoryBean.java:343)
 at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.afterPropertiesSet(AbstractEntityManagerFactoryBean.java:318)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1633)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1570)
 ... 15 more
 Caused by: org.hibernate.AnnotationException: No identifier specified for entity: com.ekiras.domian.User
 at org.hibernate.cfg.InheritanceState.determineDefaultAccessType(InheritanceState.java:277)
 at org.hibernate.cfg.InheritanceState.getElementess(InheritanceState.java:224)
 at org.hibernate.cfg.AnnotationBinder.bindClass(AnnotationBinder.java:775)
 at org.hibernate.cfg.Configuration$MetadataSourceQueue.processAnnotatedClassesQueue(Configuration.java:3845)
 at org.hibernate.cfg.Configuration$MetadataSourceQueue.processMetadata(Configuration.java:3799)
 at org.hibernate.cfg.Configuration.secondPassCompile(Configuration.java:1412)
 at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1846)
 at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl$4.perform(EntityManagerFactoryBuilderImpl.java:857)
 ... 23 common frames omitted

How to use @Entity annotation in Hibernate

• Id
• Name
• Age
• Address
• Gender
• Email
• Mobile

package com.ekiras.domian;

import com.ekiras.enums.Gender;
import javax.persistence.Entity;

@Entity
public class User {

    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Long id;
    private String name;
    private Integer age;
    private String address;
    private Gender gender;
    private String email;
    private Long mobile;

    // GETTERS and SETTERS
}

@Documented
@Target(TYPE)
@Retention(RUNTIME)
public @interface Entity {
   String name() default "";
}

(Optional) The entity name. Defaults to the unqualified name of the entity class. This name is used to refer to the entity in queries. The name must not be a reserved literal in the Java Persistence query language.

1. JDBC
2. Mysql
3. JPA
4. MVC
5. Gradle

Create Basic CRUD for Person Entity with JPA and Mysql

Project Structure

build.gradle

View Maven Dependencies (pom.xml) here.

buildscript {
    ext {
        springBootVersion = '1.2.5.RELEASE'
    }
    repositories {
        maven { url "http://repo.spring.io/libs-milestone" }
        mavenCentral()
    }
    dependencies {
        classpath("org.springframework.boot:spring-boot-gradle-plugin:${springBootVersion}") 
        classpath("io.spring.gradle:dependency-management-plugin:0.5.1.RELEASE")
    }
}

apply plugin: 'java'
apply plugin: 'eclipse-wtp'
apply plugin: 'idea'
apply plugin: 'spring-boot' 
apply plugin: 'io.spring.dependency-management' 
apply plugin: 'war'


war {
    baseName = 'springboot'
    version = '0.0.1-SNAPSHOT'
}
sourceCompatibility = 1.7
targetCompatibility = 1.7

repositories {
    mavenCentral()
    maven { url "http://repo.spring.io/libs-milestone" }
}

configurations {
    providedRuntime
}

dependencies {
    compile("org.springframework.boot:spring-boot-starter-data-jpa")
    compile("javax.servlet:jstl:1.2")
    runtime("mysql:mysql-connector-java")
    compile("org.springframework.boot:spring-boot-starter-jdbc")
    compile ("org.springframework.boot:spring-boot-starter-web")
    providedRuntime("org.springframework.boot:spring-boot-starter-tomcat")
    providedRuntime 'org.apache.tomcat.embed:tomcat-embed-jasper'
}


eclipse {
    classpath {
         containers.remove('org.eclipse.jdt.launching.JRE_CONTAINER')
         containers 'org.eclipse.jdt.launching.JRE_CONTAINER/org.eclipse.jdt.internal.debug.ui.launcher.StandardVMType/JavaSE-1.7'
    }
}

task wrapper(type: Wrapper) {
    gradleVersion = '2.3'
}

AppConfig.java

package com.ekiras.config;

import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Import;
import org.springframework.web.servlet.config.annotation.DefaultServletHandlerConfigurer;
import org.springframework.web.servlet.config.annotation.EnableWebMvc;
import org.springframework.web.servlet.config.annotation.ResourceHandlerRegistry;
import org.springframework.web.servlet.config.annotation.WebMvcConfigurerAdapter;
import org.springframework.web.servlet.view.InternalResourceViewResolver;

/**
 * Created by ekansh on 12/7/15.
 */
@Configuration
public class AppConfiguration extends WebMvcConfigurerAdapter{

    @Override
    public void configureDefaultServletHandling(DefaultServletHandlerConfigurer configurer) {
        configurer.enable();
    }

    @Bean
    public InternalResourceViewResolver viewResolver() {
        InternalResourceViewResolver resolver = new InternalResourceViewResolver();
        resolver.setViewClass(org.springframework.web.servlet.view.JstlView.class);
        resolver.setPrefix("/WEB-INF/views/");
        resolver.setSuffix(".jsp");
        return resolver;
    }

}

Person.java

package com.ekiras.domain;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;

/**
 * Created by ekansh on 12/7/15.
 */
@Entity
public class Person {

    @Override
    public String toString(){
        return this.name;
    }

    @Id
    @GeneratedValue
    @Column(name = "id")
    private Long id;

    @Column(name = "name")
    private String name;

    @Column(name = "email", nullable = false, unique = true)
    private String email;

    @Column(name = "password")
    private String password;

    @Column(name = "mobile")
    private String mobile;

    private transient String confirmPassword;

    // Getters and Setters
}

PersonRepository.java

package com.ekiras.repository;

import com.ekiras.domain.Person;
import org.springframework.data.repository.CrudRepository;
import org.springframework.stereotype.Repository;

/**
 * Created by ekansh on 14/7/15.
 */
@Repository
public interface PersonRepository extends CrudRepository<Person,Long> {

}

PersonService.java

package com.ekiras.service;

import com.ekiras.dao.PersonDAO;
import com.ekiras.domain.Person;
import com.ekiras.repository.PersonRepository;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

/**
 * Created by ekansh on 13/7/15.
 */
@Service
public class PersonService {

    @Autowired
    private PersonDAO personDAO;

    @Autowired
    private PersonRepository personRepository;

    public Object findAll(){
        return personRepository.findAll();
    }

    public Person findById(Long id){
        return personRepository.findOne(id);
    }

    public Person save(Person person){
        return personRepository.save(person);
    }

}

PersonController.java

package com.ekiras.controller;

import com.ekiras.domain.Person;
import com.ekiras.service.PersonService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;

/**
 * Created by ekansh on 12/7/15.
 */

@Controller
@RequestMapping(value = {"","/person"})
public class PersonController {

    @Autowired
    private PersonService personService;


    @RequestMapping(value = {"/","index"})
    public String index(Model model){
        System.out.println(personService.findAll());
        model.addAttribute("persons", personService.findAll());
        return "person/index";
    }

    @RequestMapping(value = "create")
    public String create(){
        return "person/create";
    }

    @RequestMapping(value = "save", method = RequestMethod.POST)
    public String save(Person person){
        personService.save(person);
        return "redirect:index";
    }

    @RequestMapping(value = "edit/{id}")
    public String edit(@PathVariable Long id, Model model){
        model.addAttribute("person",personService.findById(id));
        return "person/edit";
    }


    @RequestMapping(value = "update",method = RequestMethod.POST)
    public String update(Person person){
        personService.save(person);
        return "redirect:index";
    }


    @RequestMapping(value = "/test")
    public String test(){
        return " hello world";
    }


}

gradle bootRun

Points To Remember

• Table name (optional,default ="")- to set the name of the table in database
• Table schema (optional,default ="")- to set the schema of the table in database
• Table catalog (optional,default ="") -to set the catalog of the table
• Table Constraints (optional,default = []) to set the constraints on the table.

@Table(
name="person",
schema="ekiras",
uniqueConstraints = {@UniqueConstraint(columnNames = {"id","email"})}
)
public class Person {
  private Long id;
  private String name;
  private String email;
  // code
}

Points To Remember

• You need to inject the SessionFactory object in the service or the controller, where you want to use it.
• Get the current session from the session factory and execute the query in this session using sessionFactory.getCurrentSession().
• You can also execute the query in a new session by using sessionFactory.openSession().

Executing SQL query in grails

package com.ekiras.grails;

class Person{

 String username
 String email
 String password

 static mapping = {
        
    }

 static constraints = {
        username nullable: true
        password nullable: false, blank: false
        email nullable: false, blank: false
    }



}

package com.ekiras.grails;

import org.hibernate.SessionFactory;
import grails.transaction.Transactional

import com.ekiras.grails.Person;

@Transactional
class PersonService{

 SessionFactory sessionFactory;

 def listPersons(){
  String query = "select distinct username from person";
  def personList = sessionFactory.getCurrentSession().createSQLQuery(query).list();
  return personList;
 }

 boolean deletePerson(Person person){
  String query = "delete from person where username=${person.username}";
  Integer rowsEffected = sessionFactory.getCurrentSession().createSQLQuery(query).executeUpdate();
  if(rowsEffected == 1);
    return true;
  else
    return false;
 }

  Person updatePerson(Person person){
  String query = "update person set username=${person.username} where id={person.id}";
  Integer rowsEffected = sessionFactory.getCurrentSession().createSQLQuery(query).executeUpdate();
  if(rowsEffected == 1);
    return person;
  else
    // throw new Exception();
 }


}

Syntax to use OrderBy in Hibernate Criteria Query

criteria.addOrder(Order.asc("propertyName"))
criteria.addOrder(Order.desc("propertyName"))

Order results according to an order in Hibernate 

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

   }

• Order by propertyName id in ascending order
  

  sessionFactory.getCurrentSession()
                .createCriteria(Catgeory.class)
                .addOrder(Order.asc("id"))
                .list();

• Order by propertyName name in descending order
  

  sessionFactory.getCurrentSession()
                .createCriteria(Catgeory.class)
                .addOrder(Order.desc("name"))
                .list();

• Order by propertyName name in random order
  

  sessionFactory.getCurrentSession()
                .createCriteria(Catgeory.class)
                criteria.add(Restrictions.sqlRestriction("1=1 order by rand()"));
                .list();

  The above code will return the list of Category domain objects in a random order.

Syntax to get List of domain Object

criteria.list()

How to get a List of a Domain class using Hibernate's Criteria Query.

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

   }

• Simplest way to get a list of a Domain class (Category) in our example is
  

  sessionFactory.getCurrentSession().createCriteria(Category.class).list();

• You can use pagination in the following way with list()
  

  @SuppressWarnings("unchecked")
   public List<Category>; list(Integer offset){
    return sessionFactory.getCurrentSession()
     .createCriteria(Category.class)
     .setFirstResult(offset!=null?offset:0)
     .setMaxResults(10)
     .list();
   }
  

• Use this method as a generic method to get a list of all the records of a domain in the database.
  

  @SuppressWarnings("rawtypes")
   public List list(Class clazz){  
    return (List)getSession().createCriteria(clazz).list();
   }

• You can Order your list according to any property like
  

  public List<Category> list(Integer offset){
    return getSession()
     .createCriteria(Category.class)
     .addOrder(Order.desc("id"))
     .list();
   }
  

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;

       // GETTERS and SETTERS

PersonService.java

package com.ekiras.service;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.ekiras.dao.PersonDAO;
import com.ekiras.domain.Person;

@Service
public class PersonService {

 @Autowired
 private PersonDAO personDAO;
 
 
 public List<Person> list(Integer offset, Integer maxResults){
  return personDAO.list(offset, maxResults);
 }
 
 public Long count(){
  return personDAO.count();
 }
 
 public void save(){
  personDAO.save();
 }
 
}

PersonDAO.java

package com.ekiras.dao;

import java.util.List;

import org.hibernate.SessionFactory;
import org.hibernate.criterion.Projections;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;

import com.ekiras.domain.Person;

@Repository
@Transactional
public class PersonDAO {

 @Autowired 
 private SessionFactory sessionFactory;
 
 @SuppressWarnings("unchecked")
 @Transactional
 public List<Person> list(Integer offset, Integer maxResults){
  return sessionFactory.openSession()
    .createCriteria(Person.class)
    .setFirstResult(offset!=null?offset:0)
    .setMaxResults(maxResults!=null?maxResults:10)
    .list();
 }
 
 
 public Long count(){
  return (Long)sessionFactory.openSession()
    .createCriteria(Person.class)
    .setProjection(Projections.rowCount())
    .uniqueResult();
 }
 
 
 public void save(){
  for(int itr=1;itr <= 100 ; itr++){
   Person person = new Person("Person_"+itr,Math.max(25, (itr%2)*35));
   sessionFactory.openSession()
   .save(person);
  }
  
  
  
 }
 
}

PersonController.java

package com.ekiras.controller;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;

import com.ekiras.service.PersonService;

@Controller
@RequestMapping(value="/person")
public class PersonController {

 @Autowired
 private PersonService personService;
 
 @RequestMapping(value="/list")
 public String list(Model model, Integer offset, Integer maxResults){
  model.addAttribute("persons", personService.list(offset, maxResults));
  model.addAttribute("count", personService.count());
  model.addAttribute("offset", offset);
  return "/person/list";
 }
 
 @RequestMapping(value="/save")
 public String save(){
  personService.save();
  return "/person/list";
 }
 
}

PaginationTaglib.java

package com.ekiras.taglib;

import java.io.Writer;

import javax.servlet.jsp.JspException;
import javax.servlet.jsp.JspWriter;
import javax.servlet.jsp.tagext.SimpleTagSupport;

public class PaginationTaglib extends SimpleTagSupport {
 private String uri;
 private int offset;
 private int count;
 private int max = 10;
 private int steps = 10;
 private String previous = "Previous";
 private String next = "Next";

 private Writer getWriter() {
  JspWriter out = getJspContext().getOut();
  return out;
 }

 @Override
 public void doTag() throws JspException {
  Writer out = getWriter();

  try {
   out.write("<nav>");
   out.write("<ul class=\"pagination\">");
   
   if(offset<steps)
    out.write(constructLink(1, previous, "disabled", true));
   else
    out.write(constructLink(offset-steps, previous, null, false));
   
   for(int itr=0;itr<count;itr+=steps) {
    if(offset==itr)
     out.write(constructLink((itr/10+1)-1 *steps, String.valueOf(itr/10+1), "active", true));
    else
     out.write(constructLink(itr/10*steps, String.valueOf(itr/10+1), null , false));
   }

   if(offset+steps>=count)
    out.write(constructLink(offset+steps, next, "disabled", true));
   else
    out.write(constructLink(offset+steps, next, null , false));
   
   
   out.write("</ul>");
   out.write("</nav>");
  } catch (java.io.IOException ex) {
   throw new JspException("Error in Paginator tag", ex);
  }
 }


 private String constructLink(int page, String text, String className, boolean disabled) {
  StringBuilder link = new StringBuilder("<li");
  if (className != null) {
   link.append(" class=\"");
   link.append(className);
   link.append("\"");
  }
  if(disabled)
   link.append(">").append("<a href=\"#\">"+text+"</a></li>");
  else
   link.append(">").append("<a href=\""+uri+"?offset="+page + "\">"+text+"</a></li>");
  return link.toString();
 }

 public String getUri() {
  return uri;
 }

 public void setUri(String uri) {
  this.uri = uri;
 }

 public int getOffset() {
  return offset;
 }

 public void setOffset(int offset) {
  this.offset = offset;
 }

 public int getCount() {
  return count;
 }

 public void setCount(int count) {
  this.count = count;
 }

 public int getMax() {
  return max;
 }

 public void setMax(int max) {
  this.max = max;
 }

 public String getPrevious() {
  return previous;
 }

 public void setPrevious(String previous) {
  this.previous = previous;
 }

 public String getNext() {
  return next;
 }

 public void setNext(String next) {
  this.next = next;
 }

 public int getSteps() {
  return steps;
 }

 public void setSteps(int steps) {
  this.steps = steps;
 }

}

list.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
 pageEncoding="UTF-8"%>
<%@ taglib prefix="tag" uri="/WEB-INF/taglibs/customTaglib.tld"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link rel="stylesheet" type="text/css" href="/css/bootstrap.css" />
<link rel="stylesheet" type="text/css" href="/css/bootstrap.min.css" />
<link rel="stylesheet" type="text/css" href="/css/font-awesome.min.css" />
<title>| Ekiras</title>
</head>
<body>
 <nav class="navbar navbar-default">
 <div class="container-fluid">
  <!-- Brand and toggle get grouped for better mobile display -->
  <div class="navbar-header">
   <button type="button" class="navbar-toggle collapsed"
    data-toggle="collapse" data-target="#bs-example-navbar-collapse-1">
    <span class="sr-only">Toggle navigation</span> <span
     class="icon-bar"></span> <span class="icon-bar"></span> <span
     class="icon-bar"></span>
   </button>
   <a class="navbar-brand" href="#">Brand</a>
  </div>

  <!-- Collect the nav links, forms, and other content for toggling -->
  <div class="collapse navbar-collapse"
   id="bs-example-navbar-collapse-1">
   <ul class="nav navbar-nav">
    <li class="active"><a href="#">Link <span class="sr-only">(current)</span></a></li>
    <li><a href="#">Link</a></li>
    <li class="dropdown"><a href="#" class="dropdown-toggle"
     data-toggle="dropdown" role="button" aria-expanded="false">Dropdown
      <span class="caret"></span>
    </a>
     <ul class="dropdown-menu" role="menu">
      <li><a href="#">Action</a></li>
      <li><a href="#">Another action</a></li>
      <li><a href="#">Something else here</a></li>
      <li class="divider"></li>
      <li><a href="#">Separated link</a></li>
      <li class="divider"></li>
      <li><a href="#">One more separated link</a></li>
     </ul></li>
   </ul>
   <form class="navbar-form navbar-left" role="search">
    <div class="form-group">
     <input type="text" class="form-control" placeholder="Search">
    </div>
    <button type="submit" class="btn btn-default">Submit</button>
   </form>
   <ul class="nav navbar-nav navbar-right">
    <li><a href="#">Link</a></li>
    <li class="dropdown"><a href="#" class="dropdown-toggle"
     data-toggle="dropdown" role="button" aria-expanded="false">Dropdown
      <span class="caret"></span>
    </a>
     <ul class="dropdown-menu" role="menu">
      <li><a href="#">Action</a></li>
      <li><a href="#">Another action</a></li>
      <li><a href="#">Something else here</a></li>
      <li class="divider"></li>
      <li><a href="#">Separated link</a></li>
     </ul></li>
   </ul>
  </div>
  <!-- /.navbar-collapse -->
 </div>
 <!-- /.container-fluid --> </nav>

 <div class="container">
  <div class="well">
   <strong>List of Persons</strong>
  </div>
  <table class="table table-stripped">
   <tr>
    <th>S.No</th>
    <th>Name</th>
    <th>Age</th>
   </tr>
   <c:forEach items="${persons}" var="person" varStatus="itr">
    <tr>
     <td>${offset + itr.index +1 }</td>
     <td>${person.name }</td>
     <td>${person.age }</td>
    </tr>
   </c:forEach>
  </table>
  <tag:paginate max="15" offset="${offset}" count="${count}"
   uri="/person/list" next="&raquo;" previous="&laquo;" />
 </div>


 <script type="text/javascript" src="/js/jquery.js"></script>
 <script type="text/javascript" src="/js/bootstrap.min.js"></script>
</body>
</html>

This is how you can do pagination using bootstrap style in spring hibernate mvc application.

Download this example from Github.

Points To Remember

• Offset may be required to do pagination or get the results after a particular result from the database.
• Using offset you can define the first result to be included in the result set from the database. 
• You can use setFirstResult on the CriteriaQuery to set the first result that you want.

Using offset to get the results

@SuppressWarnings("unchecked")
public List<Person> getCategories(Integer offset){
  return getSession()
   .createCriteria(Person.class)
   .setFirstResult(offset!=null?offset:0)
   .setMaxResults(10)
   .list();
 }