hibernate执行原始sql

List<Object[]> list = null;
Session session = this.getHibernateTemplate().getSessionFactory().openSession();
try {
        list = session.createSQLQuery(sql).list();
        for(Object[] o:list){ //强制转化为object[]对象,数组的长度区决于你的sql查询多少个列的数据.....
	     System.out.print(((String)o[0])); 
	     System.out.print(((String)o[1])); 
        }

}catch(Exception e) {
        e.printStackTrace();
}finally{
        session.close();
}