Question

Can someone help me write a better code. I tried this but its not working :

Query query = session.createQuery("from MyTable order by :sortvariable :sortorder");
query.setParameter("sortvariable", sortvar);
query.setParameter("sortorder", order);

这一点也没有发挥作用。

Query query = session.createQuery("from MyTable table order by table." + sortvar + " " + " :sortorder");
query.setParameter("sortorder", order);

I managet to get it working with this :

Query query = session.createQuery("from MyTable table order by table." + sortvar + " " + order);

我需要问一下,因为我是使用固定的MaxResults()和设立第一Result()。

Answer 1

我不认为你可以使用参数确定这样的关键词。您能否利用APIC标准来做些什么?

boolean sortAscending = ...;
Criteria criteria = session.createCriteria(MyTable.class);
criteria.addOrder(sortAscending? Order.asc(sortVar): Order.desc(sortVar));

友情链接