Hibernate使用原生sql语句

异常类型1：could not extract resulted --->表名字和类名不一致

异常类型2：could not execute query---->可能是sql语句错；

异常类型3;org.hibernate.service.UnknownServiceException: Unknown service requested ;sessionFactory 中改成getsession()不用currentsession

相关参考：

http://houzhiqingjava.blog.163.com/blog/static/1673995072013710114220367/

http://www.jb51.net/article/76825.htm

 

样式：

 Session session = HibernateUtil.getSession();
         Transaction tx = session.beginTransaction();
//         session.createSQLQuery("update submenu set status = "+2+" where id= "+26);
         String sql = "select t.* from user t ";
         SQLQuery query=session.createSQLQuery(sql);
            query.addEntity(Users.class);
          List resu = query.list();
           System.out.println(resu);
          for(Object s:resu){
          System.out.println(s.toString());
         }         tx.commit();
         System.out.println(query.toString());
         System.out.println(query);
//         Query q = session.createSQLQuery(sql).addEntity(Question.class).addEntity(Answer.class);
            session.close();
  }