hibernate实施原始sql

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