如何在hibernate中分页获得sql的数据

public List<soft> queryByPage(int pageSize, int pageNow, String HQL) {
        Session session = null;
        List sftlist = new ArrayList();
        try {
            session = NewHibernateUtil.getsession();// 获得session对象
            //String hql = "from Employee emp";// 查询HQL语句
            HQL = "from soft sft";// 条件查询HQL语句
            Query q = session.createQuery(HQL);// 执行查询操作
            q.setFirstResult(pageSize * (pageNow - 1));
            q.setMaxResults(pageSize);
            sftlist = q.list();
        } catch (HibernateException e) {
            e.printStackTrace();
            System.out.println("查询失败");
        } finally {
            NewHibernateUtil.closesessicon();// 关闭session
        }
        return sftlist;
    }