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);