Reversing order of list using criteria in spring hibernate

Question

so i am trying to reverse somehow my list after getting it in my database by using spring hibernate but i don't have much idea about the criteria here is my code by the way

Controller

@RequestMapping(value = "/Crime")
public String show(Map<String, Object> map) 
{
    map.put("complainList", complainService.listComplains());
    return "/complains/Crime";
}

my DAO

public interface ComplainsDao 
{
   public List<Complains> listComplains();
}

my DAO IMPLEMENTATION

@Repository
public class ComplainsDaoImpl implements ComplainsDao 
{
   public List<Complains> listComplains() 
   {
      return getSession().createCriteria(Complains.class).list();
   }
}

Service

public interface ComplainService 
{
    public List<Complains> listComplains();
}

Service implementation

@Service
public class ComplainsServiceImpl implements ComplainService 
{
   @Transactional(readOnly = true)
   public List<Complains> listComplains() 
   {
      return complainsDao.listComplains();
   }
}

those datas have an id which is complainId it shows me an order ascending 1234 it should be in descending order 4321 — , Dec 30 '14 at 08:51

score 1 · Accepted Answer · answered Dec 30 '14 at 08:52

1

Criteria has an addOrder method for this:

public List<Complains> listComplains() {
    return getSession().createCriteria(Complains.class).addOrder(Order.desc("complainId")).list();
}

answered Dec 30 '14 at 08:52

bedrin

3,939
25
48

score 0 · Answer 2 · answered Dec 30 '14 at 08:51

0

If you have used Comparator or Comparable for design of your Complain class just change the logic of comparing in compare or compareTo method

answered Dec 30 '14 at 08:51

Sanjay Rabari

2,024
13
28

score 0 · Answer 3 · edited May 23 '17 at 10:33

0

Agree with the above answer by @bedrin

You can order the results using org.hibernate.criterion.Order.

have a look at below links for some complex examples as well.

from hibernate docs

Reversing order of list using criteria in spring hibernate

3 Answers3