String strSQLTOTAL = "select isnull(sum(a.day),0) as a1,isnull(sum(a.month),0) as a2,isnull(sum(a.year),0) as a3 " + "from km_report_rzrqkhs a " + "where a.info_date='" + info_date + "' "; SQLQuery queryViewTotal = this.getBaseDao().getHibernateSession() .createSQLQuery(strSQLTOTAL); queryViewTotal.setFirstResult(0); queryViewTotal.setMaxResults(1); List<Object[]> viewTotalList = queryViewTotal.list(); 這個代碼中我加了 as a1 ,as a2 as a3,object[]中的數據就是對的。
添加回答
舉報
0/150
提交
取消