Java Hibernate中使用SQL 而不使用HQL

//like12 add,20150618,数据库命中率查询

@SuppressWarnings("rawtypes")

public String getOracleHitRate() {

StringBuilder sql = new StringBuilder(

       " select ((1-(sum(decode(name, 'physical reads',value,0))/(sum(decode(name, 'db block gets',value,0)) "

               + " +sum(decode(name,'consistent gets',value,0))))) * 100) as Hit_Ratio "

               + " from v$sysstat "

);

 

List listTemp = this.getSession().createSQLQuery(sql.toString()).list();

String hitRate = listTemp.get(0).toString();

return hitRate;

}