Hibernate特殊查询与更新

1) 分页查询

public List<Word> fetchWords(intoffset,int limit) {

      List<Word> list=null;

      Session session=HibernateUtil.getSessionFactory().getCurrentSession();

      Transaction tx=session.beginTransaction();

      try{

         Query query=session.createQuery("from Word");

         query.setFirstResult(offset);

         query.setMaxResults(limit);

         list=query.list();

         tx.commit();

      } catch(HibernateException e) {

         tx.rollback();

         e.printStackTrace();

      }finally{

         if(session!=null&&session.isOpen()){

            session.close();

         }

      }

      returnlist;

   }

2) 查询数量

public long getTotalNumber() {

      long total=0;

      Sessionsession=HibernateUtil.getSessionFactory().getCurrentSession();

      Transactiontx=session.beginTransaction();

      try {

         Queryquery=session.createQuery("select count(*)from Word");

         total=(Long)query.iterate().next();

         tx.commit();

      }catch (HibernateException e) {

         tx.rollback();

         e.printStackTrace();

      }finally{

         if(session!=null&&session.isOpen()){

            session.close();

         }

      }

      return total;

   }

3) 查询最大id

Queryquery=session.createQuery("select max(id) fromWord");

maxId=(Integer)query.iterate().next();

4)    更新

Query query= session.createQuery("updateOrderForm set doneSign = true where id = ?");

query.setInteger(0, id);

number= query.executeUpdate();

tx.commit();