hql与sql不同的查询方式

public TTemplate queryTemplateById(String id) {
		List<Object> listAgs = new ArrayList<Object>();
		String hql ="from TTemplate t where t.id=?";
		listAgs.add(id);
		List<TTemplate> result = this.find(hql, listAgs.toArray());
		if(result.size()>0){
			return result.get(0);
		}
		return null;
	}


public List<Map<String, String>> queryAreaTree(String code,int level) {
		StringBuffer sql = new StringBuffer();
		sql.append("select code \"id\", code \"code\",NAME \"text\",decode(connect_by_isleaf, 0, 'closed', '') \"state\", xzqh_level \"lev\" from CENDIC.Tb_Dic_Xzqh h  ");
		sql.append("WHERE level = ? start with code = ? connect by prior ID=PID order SIBLINGS by ORDERS ");
		Query query = createSQLQuery(sql.toString(), null,null,new Object[]{level,code});
		query.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);
		List<Map<String, String>> list = query.list() ;
		return list;
	}

@SuppressWarnings("unchecked")
	public List<Map<String, Object>> queryTemplateAudit(String type) {
		List<Object> listAgs = new ArrayList<Object>();
		String sql ="select t.* from T_TEMPLATE t where t.id in "
				+ "(select distinct r.REPORT_ID from t_report r where r.audit_status='01' AND R.DATA_STATUS!='03' and r.type=?) ";
		listAgs.add(type);
		sql +="order by t.MODIFY_DATE desc";
		Query q = createSQLQuery(sql, null, null, listAgs.toArray());
		q.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);
		List<Map<String, Object>> result = q.list();
		return result;
	}