java - Hibernate 中按计数排序

Question

我有一个名为“count”的字段。现在我想按该字段对表进行排序。据我所知，COUNT是Hibernate中的保留语句。有没有什么方法可以在不重命名的情况下订购表？我的代码:

@Override
public List<Distribution> getListOrderByCount(String userName) {
    List<Distribution> result = (List<Distribution>) sessionFactory
            .getCurrentSession()
            .createQuery(
                    "from Distribution where username=:userName ORDER BY count DESC")
            .setString("userName", userName).list();
    return result;
}

Answer 1

试试这个!

@Override
public List<Distribution> getListOrderByCount(String userName) {
    List<Distribution> result = (List<Distribution>) sessionFactory
            .getCurrentSession()
            .createQuery(
      "from Distribution as d where d.username=:userName ORDER BY d.count DESC")
            .setString("userName", userName).list();
    return result;
}