Java Criteria.setMaxResults方法代码示例

import org.hibernate.Criteria; //导入方法依赖的package包/类
@Override
public List<App> getAppsOfDropMarket(Session session, String marketName, Integer currentPage, Integer pageSize) {
    ProjectionList proList = Projections.projectionList();
    proList.add(Projections.property("pkname"));
    proList.add(Projections.property("signatureSha1"));
    Criteria cri = session.createCriteria(App.class);
    cri.setProjection(proList);
    cri.setMaxResults(pageSize);
    cri.setFirstResult(HibernateHelper.firstResult(currentPage, pageSize));
    List<Object[]> list = HibernateHelper.list(cri);
    List<App> apps = null;
    if (list != null) {
        apps = new ArrayList<App>(list.size());
        for (Object[] obj : list) {
            App e = new App();
            e.setPkname((String) obj[0]);
            e.setSignatureSha1((String) obj[1]);
            apps.add(e);
        }
        list.clear();
    }
    return apps;
}
 

import org.hibernate.Criteria; //导入方法依赖的package包/类
@Override
public List<MarketApp> search(EnumMarket enumMarket, Short catalog, Integer subCatalog, int page, int rows,
        String keywords, String sort, String order) {
    Criteria cri = searchByFilter(enumMarket, catalog, subCatalog, keywords);

    if (sort != null && !sort.isEmpty()) {
        HibernateHelper.addOrder(cri, sort, order);
    } else {
        if (order != null && "asc".equals(order)) {
            cri.addOrder(Order.asc("id"));
        } else {
            cri.addOrder(Order.desc("id"));
        }
    }
    cri.setMaxResults(rows);
    cri.setFirstResult(HibernateHelper.firstResult(page, rows));
    List<MarketApp> list = HibernateHelper.list(cri);
    return list;
}
 

import org.hibernate.Criteria; //导入方法依赖的package包/类
@Override
public Pager<User> listUserByPage(int pageNo, int pageSize) {
	Session session = sessionFactory.getCurrentSession();
	Criteria criteria = session.createCriteria(User.class);
	long recordTotal = ((Long) criteria.setProjection(Projections.rowCount()).uniqueResult()).longValue();
	criteria.setProjection(null);
	criteria.addOrder(Order.desc("registerDate"));
	criteria.setFirstResult((pageNo - 1) * pageSize);
	criteria.setMaxResults(pageSize);
	List<User> results = criteria.list();
	return new Pager<User>(pageSize, pageNo, recordTotal, results);
}
 

import org.hibernate.Criteria; //导入方法依赖的package包/类
/**
 * Prepare the given Criteria object, applying cache settings and/or
 * a transaction timeout.
 * @param criteria the Criteria object to prepare
 * @see #setCacheQueries
 * @see #setQueryCacheRegion
 */
protected void prepareCriteria(Criteria criteria) {
	if (isCacheQueries()) {
		criteria.setCacheable(true);
		if (getQueryCacheRegion() != null) {
			criteria.setCacheRegion(getQueryCacheRegion());
		}
	}
	if (getFetchSize() > 0) {
		criteria.setFetchSize(getFetchSize());
	}
	if (getMaxResults() > 0) {
		criteria.setMaxResults(getMaxResults());
	}

	SessionHolder sessionHolder =
			(SessionHolder) TransactionSynchronizationManager.getResource(getSessionFactory());
	if (sessionHolder != null && sessionHolder.hasTimeout()) {
		criteria.setTimeout(sessionHolder.getTimeToLiveInSeconds());
	}
}
 

import org.hibernate.Criteria; //导入方法依赖的package包/类
@Override
public List<Rollinfo> searchForRolling(Short catalog, Integer subCatalog, int page, int rows, String keywords,
        String sort, String order) {
    Criteria cri = getSession().createCriteria(Rollinfo.class);
    Criteria appCriteria = cri.createCriteria("app", JoinType.LEFT_OUTER_JOIN);
    if (catalog != null) {
        appCriteria.add(Restrictions.eq("catalog", catalog));
    }
    if (subCatalog != null) {
        appCriteria.add(Restrictions.eq("subCatalog", subCatalog));
    }

    if (keywords != null && !keywords.isEmpty()) {
        appCriteria.add(Restrictions.like("name", keywords, MatchMode.ANYWHERE));
    }

    if (sort != null && !sort.isEmpty()) {
        HibernateHelper.addOrder(appCriteria, sort, order);
    }
    cri.setMaxResults(rows);
    cri.setFirstResult(HibernateHelper.firstResult(page, rows));
    List<Rollinfo> list = HibernateHelper.list(cri);
    return list;
}
 

import org.hibernate.Criteria; //导入方法依赖的package包/类
@Override
public List<MoViewTagApps> search(Integer tagId, Integer catalog, Short tagType, int page, int rows,
        String keywords, String sort, String order) {
    Criteria cri = searchByFilter(tagId, catalog, tagType, keywords);
    if (sort != null && !sort.isEmpty()) {
        HibernateHelper.addOrder(cri, sort, order);
    } else {
        if (order != null && "asc".equals(order)) {
            cri.addOrder(Order.asc("id"));
        } else {
            cri.addOrder(Order.desc("id"));
        }
    }
    cri.setMaxResults(rows);
    cri.setFirstResult(HibernateHelper.firstResult(page, rows));
    List<MoViewTagApps> list = HibernateHelper.list(cri);
    return list;
}
 

import org.hibernate.Criteria; //导入方法依赖的package包/类
public <T> List<T> findByExample(final String entityName, final T exampleEntity, final int firstResult,
    final int maxResults) {

if (exampleEntity == null) {
    throw new IllegalArgumentException("Example entity must not be null");
}

Criteria executableCriteria = (entityName != null ? getSession().createCriteria(entityName)
	: getSession().createCriteria(exampleEntity.getClass()));
executableCriteria.add(Example.create(exampleEntity));
if (firstResult >= 0) {
    executableCriteria.setFirstResult(firstResult);
}
if (maxResults > 0) {
    executableCriteria.setMaxResults(maxResults);
}
return executableCriteria.list();
   }
 

import org.hibernate.Criteria; //导入方法依赖的package包/类
private Object execute(FlowFinderCriteria flowFinderCriteria,
        DetachedCriteria flowStatusCriteria, Session session,
        boolean idProjection) {

    Criteria criteria = flowStatusCriteria.getExecutableCriteria(session);

    if (idProjection) {
        criteria.setProjection(Projections.id());
    }
    
    int maxResults = flowFinderCriteria.getMaxResults();
    if (maxResults != FlowFinderCriteria.DEFAULT_MAX_RESULTS) {
        criteria.setMaxResults(maxResults);
    }

    if (flowFinderCriteria.hasMessageQuery()) {
        FlowSearchCriteria flowSearchCriteria = new FlowSearchCriteria();
        flowSearchCriteria.setHibernateCriteria(criteria);
        flowSearchCriteria.setInboundMessageQuery(flowFinderCriteria.getInboundMessageQuery());
        flowSearchCriteria.setOutboundMessageQuery(flowFinderCriteria.getOutboundMessageQuery());
        return flowSearchCallback.findFlows(session, flowSearchCriteria);
    } else {
        return criteria.list();
    }
}
 

import org.hibernate.Criteria; //导入方法依赖的package包/类
/**
 * 设置分页参数到Criteria对象,辅助函数.
 */
protected Criteria setPageRequestToCriteria(final Criteria c, final PageRequest pageRequest) {
	AssertUtils.isTrue(pageRequest.getPageSize() > 0, "Page Size must larger than zero");
	
	c.setFirstResult(pageRequest.getOffset());
	c.setMaxResults(pageRequest.getPageSize());

	if (pageRequest.isOrderBySetted()) {
		for (PageRequest.Sort sort : pageRequest.getSort()) {
			if (PageRequest.Sort.ASC.equals(sort.getDir())) {
				c.addOrder(Order.asc(sort.getProperty()));
			} else {
				c.addOrder(Order.desc(sort.getProperty()));
			}
		}
	}
	return c;
}
 

import org.hibernate.Criteria; //导入方法依赖的package包/类
@Transactional(readOnly = true, rollbackFor = Exception.class)
public Pagination<JobDetailDO> pageByConditions(Integer pageIndex, Integer pageSize, String desc, Integer state) {
    Criteria criteria = daoSupport.createCriteria(JobDetailDO.class);
    if (!StringUtils.isEmpty(desc)) {
        criteria.add(Restrictions.like("description", "%" + desc + "%"));
    }
    if (state != 0) {
        criteria.add(Restrictions.eq("state", state));
    }
    //先获取总记录数
    Long totalCount = (Long) criteria.setProjection(Projections.count("id")).uniqueResult();

    criteria.setProjection(null);
    criteria.setFirstResult((pageIndex - 1) * pageSize);
    criteria.setMaxResults(pageIndex * pageSize);
    List items = criteria.list();

    Pagination<JobDetailDO> pagination = new Pagination<JobDetailDO>(pageIndex.longValue(), pageSize.longValue(), totalCount);
    pagination.setItems(items);
    return pagination;
}
 

import org.hibernate.Criteria; //导入方法依赖的package包/类
@Override
public List<MoTag> search(Short pId, String keywords, int page, int rows, String sort, String order) {
    // 查询条件
    Criteria cri = searchByFilter(pId, keywords);
    // 查询排序
    searchSort(sort, order, cri);
    cri.setMaxResults(rows);
    cri.setFirstResult(HibernateHelper.firstResult(page, rows));
    List<MoTag> list = HibernateHelper.list(cri);
    return list;
}
 

import org.hibernate.Criteria; //导入方法依赖的package包/类
@Override
public List<User> queryUserList(int page, int rows, String keyword, String order, String sort) {
    // 查询条件
    Criteria cri = searchByFilter(keyword);
    // 查询排序
    searchSort(sort, order, cri);
    cri.setMaxResults(rows);
    cri.setFirstResult(HibernateHelper.firstResult(page, rows));
    List<User> list = HibernateHelper.list(cri);
    return list;
}
 

import org.hibernate.Criteria; //导入方法依赖的package包/类
@Override
public List<Catalog> search(short catalog, int subCatalog, String keywords, int page, int rows, String sort,
        String order) {
    // 查询条件
    Criteria cri = searchByFilter(catalog, subCatalog, keywords);
    // 查询排序
    searchSort(sort, order, cri);
    cri.setMaxResults(rows);
    cri.setFirstResult(HibernateHelper.firstResult(page, rows));
    List<Catalog> list = HibernateHelper.list(cri);
    return list;
}
 

import org.hibernate.Criteria; //导入方法依赖的package包/类
@Override
public List<MoMixFeatured> search(Short type, Short picType, Boolean hidden, String keywords, int page, int rows,
        String sort, String order) {
    // 查询条件
    Criteria cri = searchByFilter(type, picType, hidden, keywords);
    // 查询排序
    searchSort(sort, order, cri);
    cri.setMaxResults(rows);
    cri.setFirstResult(HibernateHelper.firstResult(page, rows));
    List<MoMixFeatured> list = HibernateHelper.list(cri);
    return list;
}
 

import org.hibernate.Criteria; //导入方法依赖的package包/类
@Override
public List<MonUserChannelApp> queryList(String keyword, Boolean autCover, int page, int rows, String order,
        String sort) {
    Criteria cri = searchByFilter(keyword, autCover);
    // 查询排序
    searchSort(sort, order, cri);
    cri.setMaxResults(rows);
    cri.setFirstResult(HibernateHelper.firstResult(page, rows));
    List<MonUserChannelApp> list = HibernateHelper.list(cri);
    return list;
}