sql.append("order by a.T_DATA_DATE desc,a.QUES_SUM desc");
Query qu= HibernateUtil.currentSession().createSQLQuery(sql.toString())
.addScalar("ruleCode", Hibernate.STRING)
.addScalar("ruleId", Hibernate.STRING)
.addScalar("schdType", Hibernate.STRING)
.addScalar("chkDate", Hibernate.DATE)
.addScalar("queType", Hibernate.STRING)
.addScalar("chkResult", Hibernate.STRING)
.addScalar("ruleName", Hibernate.STRING)
.addScalar("selSum", Hibernate.INTEGER)
.addScalar("quesSum", Hibernate.INTEGER)
.addScalar("quesState", Hibernate.STRING)
.addScalar("gBatch", Hibernate.STRING)
.addScalar("gId", Hibernate.STRING)
.addScalar("dataDate", Hibernate.STRING)
.addScalar("quesId", Hibernate.STRING)
.addScalar("bigClass", Hibernate.STRING)
.addScalar("smallClass", Hibernate.STRING)
.setCacheable(false);
转载于:https://www.cnblogs.com/zhouchunDIY/p/8259654.html