Hibernate支持MySQL中的limit语句吗?

使用休眠功能进行分页!setFirstResult(),setMaxResults())

http://www.javalobby.org/java/forums/t63849.html

使用 Query.setMaxResults(..)

我想, 如果我们使用标准,我们可以指定

criteria c=session.createReciteria(emp.class);
c.设置第一个结果(0);
c.设置最大结果(5);
list=c.list();

这里,0和5作为0,5的极限

来源: http://www.javatpoint.com/hcql

    List<Employee> dataList = null;
    Query hQuery = null;

    try {
        // Getting Session

        hSession = HibernateSessionFactory.getSession();
        hTransaction = hSession.beginTransaction();
        hQuery = hSession.getNamedQuery(query);

                    Iterator<Object> hIterator = paramMap.entrySet().iterator();

                    while (hIterator.hasNext()) {

     Map.Entry<String, Object> paramPair = (Map.Entry<String,Object>) hIterator.next();    

 hQuery.setParameter(paramPair.getKey(), paramPair.getValue());

        }

        hQuery.setFirstResult(1);
        hQuery.setMaxResults(100);

        System.out.println(hQuery);
        dataList = hQuery.list();

        hTransaction.commit();

    } catch (Exception e) {
        hTransaction.rollback();


    } finally {
        try {
            hSession.flush();
            HibernateSessionFactory.closeSession();
        } catch (Exception hExp) {}