Question

如何在hibernate中实现 如下 sql 语句： select * from table1 order by col1+col2 desc;

其中 col1 和col2 为 table1 中两个为number 类型的字段。

Answer 1

该类继承DaoActionSupport类
1.
String hql = "select c from Table(实体名称) c order by col1+col2 desc";
getHibernateTemplate().find(hql);
2.
Criteria criteria = this.getSession.createCriteria(Table.class);
criteria.addOrder(Order.desc(col1+col2));
criteria.list();

Answer 2

from Teacher t order by t.age,t.salary desc

Answer 3

from table1 order by col1+col2 desc;