hibernate执行sql语句

hibernate 的管理下，执行sql语句     

//执行查询
     Session session = hibernateTemplate.getSessionFactory().openSession();
     List result = session.createQuery(" from News ").list();
     System.out.println(result.size());
     
     //执行事务
     final String sql = "insert into news_table values (25,'insert')";
//     session.createQuery(sql).executeUpdate(); //这样做没有事务管理，不得行
     Object rt = hibernateTemplate.execute(new HibernateCallback(){
              public Object doInHibernate(Session session)throws HibernateException, SQLException {
              SQLQuery query=session.createSQLQuery(sql);
              query.setParameter("pid", 23);
              return query.executeUpdate() ;
           }
     });
     System.out.println(rt);