Example usage for org.hibernate Criteria setFirstResult

Introduction

In this page you can find the example usage for org.hibernate Criteria setFirstResult.

Prototype

public Criteria setFirstResult(int firstResult);

Source Link

Document

Set the first result to be retrieved.

Usage

From source file:com.xxl.report.service.ReportService.java

public PageList getReportScheduleList(Integer systemID, ReportScheduleVO searchVO, Integer firstResult,
        Integer fetchSize) throws CommonException {
    try {/*from w  ww.  j  a v a2  s  .co  m*/
        hibernateSession = HibernateUtil.currentSession();
        Criteria criteria = hibernateSession.createCriteria(ReportSchedule.class);
        int size = fetchSize.intValue();
        int system = systemID.intValue();
        if (this.isSystemModule(system)) {
            system = 0;// ???????????????????????????????????????????????????
        }
        if (searchVO != null) {
            if (system == 0 && searchVO.getModuleID() != null) {
                system = searchVO.getModuleID().intValue();
            }
            if (searchVO.getReportModuleID() != null) {
                ReportModule reportModule = (ReportModule) hibernateSession.load(ReportModule.class,
                        searchVO.getReportModuleID());
                criteria.add(Expression.eq("reportModule", reportModule));
            }
            if (searchVO.getReportName() != null) {
                criteria.add(Expression.like("reportName", "%" + searchVO.getReportName() + "%"));
            }
            if (searchVO.getRemark() != null) {
                criteria.add(Expression.like("remark", "%" + searchVO.getRemark() + "%"));
            }
            if (searchVO.getValid() != null) {
                criteria.add(Expression.eq("valid", searchVO.getValid()));
            }
            if (searchVO.getLastExcuteResult() != null) {
                criteria.add(Expression.eq("lastExcuteResult", searchVO.getLastExcuteResult()));
            }
        }
        if (system != 0) {
            //            List modules = SemAppUtils.getSubmodules(system,
            //                  hibernateSession);
            //            criteria.add(Expression.in("module", modules));
            ItModule module = new ItModule();
            module.setId(new Integer(system));
            criteria.add(Expression.eq("module", module));

        }
        Integer rowCount = (Integer) criteria.setProjection(Projections.rowCount()).uniqueResult();
        criteria.setProjection(null);
        if (size > 0) {
            criteria.setFirstResult(firstResult.intValue());
            criteria.setMaxResults(size);
        }
        criteria.addOrder(Order.desc("module"));
        List list = new ArrayList();
        Iterator iter = criteria.list().iterator();
        while (iter.hasNext()) {
            ReportSchedule reportSchedule = (ReportSchedule) iter.next();
            ReportScheduleVO vo = (ReportScheduleVO) reportSchedule.toVO();
            list.add(vo);
        }
        logger.debug("report admin EJB rowCount=" + rowCount);
        PageList pageList = new PageList();
        pageList.setResults(rowCount.intValue());
        pageList.setItems(list);
        return pageList;
    } catch (HibernateException ee) {
        logger.error(ee);
        throw new CommonException("??" + ee.getMessage());

    } finally {
        try {
            HibernateUtil.closeSession();
        } catch (HibernateException e) {
        }
    }
}

From source file:com.yahoo.elide.datastores.hibernate3.HibernateTransaction.java

License:Apache License

/**
 * Generates the Hibernate ScrollableIterator for Hibernate Query.
 *
 * @param loadClass The hibernate class to build the query off of.
 * @param criteria The criteria to use for filters
 * @param sortingRules The possibly empty sorting rules.
 * @param pagination The Optional pagination object.
 * @return The Iterable for Hibernate./* w ww  .  ja  v  a2 s . com*/
 */
public Iterable loadObjects(final Class<?> loadClass, final Criteria criteria,
        final Optional<Set<Order>> sortingRules, final Optional<Pagination> pagination, RequestScope scope) {
    if (sortingRules.isPresent()) {
        sortingRules.get().forEach(criteria::addOrder);
    }

    if (pagination.isPresent()) {
        Pagination paginationData = pagination.get();
        criteria.setFirstResult(paginationData.getOffset());
        criteria.setMaxResults(paginationData.getLimit());
    } else {
        Integer queryLimit = getQueryLimit();
        if (queryLimit != null) {
            criteria.setMaxResults(queryLimit);
        }
    }

    if (isJoinQuery()) {
        joinCriteria(criteria, loadClass, scope);
    }

    criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
    if (!isScrollEnabled || isJoinQuery()) {
        return criteria.list();
    }
    return new ScrollableIterator(criteria.scroll(scrollMode));
}

From source file:com.yahoo.elide.datastores.hibernate5.HibernateTransaction.java

License:Apache License

/**
 * Generates the Hibernate ScrollableIterator for Hibernate Query.
 *
 * @param loadClass The hibernate class to build the query off of.
 * @param criteria The criteria to use for filters
 * @param sortingRules The possibly empty sorting rules.
 * @param pagination The Optional pagination object.
 * @return The Iterable for Hibernate.//from  ww w  .  jav  a 2s  .  co m
 */
public Iterable loadObjects(final Class<?> loadClass, final Criteria criteria,
        final Optional<Set<Order>> sortingRules, final Optional<Pagination> pagination) {
    if (sortingRules.isPresent()) {
        sortingRules.get().forEach(criteria::addOrder);
    }

    if (pagination.isPresent()) {
        Pagination paginationData = pagination.get();
        criteria.setFirstResult(paginationData.getOffset());
        criteria.setMaxResults(paginationData.getLimit());
    }

    if (isScrollEnabled) {
        return new ScrollableIterator(criteria.scroll(scrollMode));
    }
    return criteria.list();
}

From source file:com.zc.orm.hibernate.HibernateDao.java

License:Apache License

/**
 * ?Criteria,./*from  w  w w .j  a  v a  2  s  .com*/
 */
protected Criteria setPageParameterToCriteria(final Criteria c, final Page<T> page) {
    c.setFirstResult(page.getFirstResult() - 1);
    c.setMaxResults(page.getPageSize());
    //?
    super.setPageParameterToCriteria(c, page.getOrderBy(), page.getOrderDir());
    return c;
}

From source file:com.zdtx.ifms.common.service.BaseManager.java

/**
 * public do print pdf interface//from w ww  .  j  a  v a2  s  . c om
 */
public void doPrintPdf(final String title, final Boolean hasSeq, final String headerArray,
        final String fieldsArray, final Map<String, String> convert, final Integer[] colWidth,
        final Integer pageSize, final String... paper) {
    DetachedCriteria criteria = (DetachedCriteria) Struts2Util.getSession().getAttribute("criteria_export");
    Criteria criteria2 = criteria.getExecutableCriteria(baseDao.getSession());
    criteria2.setFirstResult(0);
    criteria2.setMaxResults(1000);
    Utils.printPDF(title, hasSeq, criteria2.list(), headerArray, fieldsArray, convert, colWidth, pageSize,
            paper);
}

From source file:com.zdtx.ifms.common.service.BaseManager.java

/**
 * public do export excel interface/*from  ww  w.  j a v  a2s . c om*/
 */
public InputStream doExportExcel(final String title, final String headerArray, final String fieldsArray,
        final Map<String, String> convert) {
    DetachedCriteria detachedCriteria = (DetachedCriteria) Struts2Util.getSession()
            .getAttribute("criteria_export");
    Criteria criteria = detachedCriteria.getExecutableCriteria(baseDao.getSession());
    criteria.setFirstResult(0);
    criteria.setMaxResults(1000);
    return Utils.exportExcel(criteria.list(), title, headerArray, fieldsArray, convert);
}

From source file:com.zutubi.pulse.master.model.persistence.hibernate.HibernateBuildResultDao.java

License:Apache License

public List<BuildResult> findLatestCompleted(final Project project, final int first, final int max) {
    return getHibernateTemplate().execute(new HibernateCallback<List<BuildResult>>() {
        public List<BuildResult> doInHibernate(Session session) throws HibernateException {
            Criteria criteria = getBuildResultCriteria(session, project, ResultState.getCompletedStates(),
                    false);// w  w  w.ja v  a  2  s. c om
            criteria.setFirstResult(first);
            criteria.setMaxResults(max);
            criteria.addOrder(Order.desc("number"));
            return criteria.list();
        }
    });
}

From source file:com.zutubi.pulse.master.model.persistence.hibernate.HibernateBuildResultDao.java

License:Apache License

public List<BuildResult> findLatestByProject(final Project project, final ResultState[] states, final int first,
        final int max) {
    return getHibernateTemplate().execute(new HibernateCallback<List<BuildResult>>() {
        public List<BuildResult> doInHibernate(Session session) throws HibernateException {
            Criteria criteria = getBuildResultCriteria(session, project, states, false);
            criteria.setFirstResult(first);
            criteria.setMaxResults(max);
            criteria.addOrder(Order.desc("id"));
            return criteria.list();
        }//from  w ww . j av  a2  s  .c o  m
    });
}

From source file:com.zutubi.pulse.master.model.persistence.hibernate.HibernateBuildResultDao.java

License:Apache License

public List<BuildResult> queryBuilds(final Project[] projects, final ResultState[] states,
        final String[] statuses, final long earliestStartTime, final long latestStartTime, final int first,
        final int max, final boolean mostRecentFirst, final boolean includePinned) {
    return getHibernateTemplate().execute(new HibernateCallback<List<BuildResult>>() {
        public List<BuildResult> doInHibernate(Session session) throws HibernateException {
            Criteria criteria = session.createCriteria(BuildResult.class);
            criteria.add(Restrictions.isNull("user"));
            if (!includePinned) {
                criteria.add(Restrictions.eq("pinned", false));
            }/*w  w  w .j a  v  a2  s.  c om*/
            addProjectsToCriteria(projects, criteria);
            addStatesToCriteria(states, criteria);
            addStatusesToCriteria(statuses, criteria);
            addDatesToCriteria(earliestStartTime, latestStartTime, criteria);

            if (first >= 0) {
                criteria.setFirstResult(first);
            }

            if (max >= 0) {
                criteria.setMaxResults(max);
            }

            if (mostRecentFirst) {
                criteria.addOrder(Order.desc("id"));
            } else {
                criteria.addOrder(Order.asc("id"));
            }

            return criteria.list();
        }
    });
}