hibernate - HQL 中按字符串参数自定义顺序

Question

我有一个这样的 HQL 查询:

Query query = session.createQuery("from User as user where user.joined!=null order by user.joined desc");

如何将变量 User 属性设置为查询的排序顺序？我的解决方案:

String order = "user.joined";
Query query = session.createQuery("from User as user where user.joined!=null order by :order desc").setString("order", order);

不给出有序查询结果。

Answer 1

使用 criteria query 。

List<User> users = session.createCriteria(User.class)
    .add(Restrictions.isNotNull("joined"))
    .addOrder(Order.desc(order))
    .list();

或者，使用 HQL:

Query query = session.createQuery("from User as user where user.joined!=null order by user." + order + " desc");