In this section you will learn how to add ordering ability to in Hibernate Application when using hibernateTemplate.

hibernateTemplate-Order Results

     

In this section you will learn how to add ordering ability to in Hibernate Application when using hibernateTemplate. There are many ways you can order your results when using hibernateTemplate.

Suppose you have a class called "Student" with the fields "studentName", "StudentCode" and you want to retrieve all the records from database in sorted by "studentName" in ascending order. There are following options for you.

1. Use getHibernateTemplate().find() method
   Following code shows how you can use getHibernateTemplate().find() method:
   public Collection loadAllStudent() throws DataAccessException{
     return getHibernateTemplate().find("from Student student order by student.studentName");
   }
    
2. Use getHibernateTemplate().findByCriteria()
   Following code shows how you can use getHibernateTemplate().findByCriteria() function in your hibernate application.
   public Collection loadAllStudent() throws DataAccessException{
      return getHibernateTemplate().findByCriteria(DetachedCriteria.forClass(Student.class).addOrder(Order.asc("studentName")));
   }
    
   

Related Tags for hibernateTemplate-Order Results:
c,  database,  exception,  hibernate,  class,  ant,  data,  template,  io,  sort,  load,  method,  find,  get,  order,  collection,  dal,  field,  name,  return,  using,  fields,  tab,  row,  student,  show,  public,  for,  options,  rows,  ie,  call,  record,  with,  ada,  nat,  records,  results,  to,  base,  option,  pos,  sse,  ld,  ws,  sh,  e,  throw,  it,  rte,  ls,  can,  li,  use,  trie,  ul,  result,  man,  from,  ce,  in,  dataaccess,  cal,  as,  m,  nt,  sorted,  tr,  wan,  temp,  os,  ca,  aac,  os,  ad,  cl,  es,  retrieve,  em,  end,  ase,  all,  me,  how,  hr,  pp,  when,  s,  urn,  su,  so,  ess,  col,  at,  any,  late,  ha,  lts,  ll,  collect,  mpl,  follow,  except,  and,  ascending,  ar,  cod,  code,  cc,  collect,  tco,  rds,  rt,  want,  wing,  sce,  s,  s,  ri,  rd,  th,  sho,  av,  st,  access,  ab,  ending,  fin,  lds,  many,  pl,  nd,  ode,  on,  om,  ol,  o

More Tutorials from this section

• Hibernate How To
• hibernateTemplate-Order Results
• hibernateTemplate-Order Results
• jtable displays search results
• Show results in HTML
• display results on same jsp page
• display results on same jsp page
• display results on same jsp page
• STRUTS-display search results - Struts
• Hibernate Criteria :Ordering the results
• Java File Handling Test Results
• Hibernate DetachedCriteria mutiple results in java
• Displaying Error pages in results tree in jmeter
• save links clicked in search engine results
• how to write quesry results into spread sheet
• MySql Databse query to fetch results from database
• Changing random results to ASC or DSC - SQL
• Hibernate Criteria Set Max Results
• count statement that saves results on a variable in a java bean
• count statement that saves results on a variable in a java bean