通过合并Hibernate的查询输出列表形成的对象的排序ArrayList

Question

我想按日期的月份排序ArrayList，这是通过合并从HiberNate查询输出得到的2个列表形成的，但问题是最终的ArrayList不能转换为我的项目的任何特定的用户定义类。

sql = "select round(sum(d.displayCost),2), month(d.date) as  date, '0' as flag from Countinfo d where  year(d.date)=2015 and d.resultId is not null group by month(d.date) ";
query = session.createQuery(sql);

List list1 = query.list();

sql = " select round(sum(c.clickCost),2), month(c.date) as date, '1'  as flag from Countinfo c where  year(c.date)=2015 and c.resultId is not null group by month(c.date) order by date, flag";
query = session.createQuery(sql);

List resultSet = query.list();

resultSet.addAll(list1);

ListIterator iterator = resultSet.listIterator();

我想让ResultSetarraylist按月排序。

提前谢谢

Answer 1

的确，您可以通过使用Array.sort对数组进行排序，但是在您的情况下，为什么要再次迭代，而不是通过在sql中使用ORDER BY来获得已经排序的结果，然后在添加（合并）一个列表元素到另一个列表元素时，您可以通过使用自定义函数在特定位置排序和插入元素来添加一个元素。

public void sortAndInsert(List resultSet, Object objToInsert)//Object is your own type
{      
  for (int i = 0; i < resultSet.size(); i++) 
  {
    // if the element property is smaller we move to next element
    if (resultSet(i).MonthName < objToInsert.MonthName) //Maonth Name is just property name what I have used to compare on
        continue;
    else
    {  
       resultSet.add(i, x);
       return;
    }
  }    
}

Answer 2

尝试这样做：

    Arrays.sort(resultSet.toArray(), new Comparator<Object>() {
        @Override
        public int compare(Object o1, Object o2) { 
            // cast your objects to the correct type (watch out for ClassCastException!), 
            // then compare their month fields
            // and return -1, 0 or 1 according to the contract of Comparator
            return 0;
        }
    });