org.hibernate.Criteria.setFirstResult java code examples

Common ways to obtain Criteria

private void myMethod () {
 Criteria c =Session session;Class persistentClass;session.createCriteria(persistentClass)
Smart code suggestions by Codota
}

 DetachedCriteria idsOnlyCriteria = DetachedCriteria.forClass(MyClass.class);
//add other joins and query params here
idsOnlyCriteria.setProjection(Projections.distinct(Projections.id()));

Criteria criteria = getSession().createCriteria(myClass);
criteria.add(Subqueries.propertyIn("id", idsOnlyCriteria));
criteria.setFirstResult(0).setMaxResults(50);
return criteria.list();

@Override
@SuppressWarnings({"unchecked", "deprecation"})
public <T> List<T> findByExample(
    @Nullable final String entityName, final T exampleEntity, final int firstResult, final int maxResults)
    throws DataAccessException {
  Assert.notNull(exampleEntity, "Example entity must not be null");
  return nonNull(executeWithNativeSession((HibernateCallback<List<T>>) session -> {
    Criteria executableCriteria = (entityName != null ?
        session.createCriteria(entityName) : session.createCriteria(exampleEntity.getClass()));
    executableCriteria.add(Example.create(exampleEntity));
    prepareCriteria(executableCriteria);
    if (firstResult >= 0) {
      executableCriteria.setFirstResult(firstResult);
    }
    if (maxResults > 0) {
      executableCriteria.setMaxResults(maxResults);
    }
    return executableCriteria.list();
  }));
}

@Override
@SuppressWarnings("unchecked")
public List<?> findByCriteria(final DetachedCriteria criteria, final int firstResult, final int maxResults)
    throws DataAccessException {
  Assert.notNull(criteria, "DetachedCriteria must not be null");
  return nonNull(executeWithNativeSession((HibernateCallback<List<?>>) session -> {
    Criteria executableCriteria = criteria.getExecutableCriteria(session);
    prepareCriteria(executableCriteria);
    if (firstResult >= 0) {
      executableCriteria.setFirstResult(firstResult);
    }
    if (maxResults > 0) {
      executableCriteria.setMaxResults(maxResults);
    }
    return executableCriteria.list();
  }));
}

@Override
@SuppressWarnings({"unchecked", "deprecation"})
public <T> List<T> findByExample(
    @Nullable final String entityName, final T exampleEntity, final int firstResult, final int maxResults)
    throws DataAccessException {
  Assert.notNull(exampleEntity, "Example entity must not be null");
  return nonNull(executeWithNativeSession((HibernateCallback<List<T>>) session -> {
    Criteria executableCriteria = (entityName != null ?
        session.createCriteria(entityName) : session.createCriteria(exampleEntity.getClass()));
    executableCriteria.add(Example.create(exampleEntity));
    prepareCriteria(executableCriteria);
    if (firstResult >= 0) {
      executableCriteria.setFirstResult(firstResult);
    }
    if (maxResults > 0) {
      executableCriteria.setMaxResults(maxResults);
    }
    return executableCriteria.list();
  }));
}

Criteria criteria=session.createCriteria(Student.class);
  criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
  criteria.add(Restrictions.ne("enquiryStatus", ENQUIRY.JOINED));
  criteria.setMaxResults(10);
  criteria.setFirstResult((paginate.getStartIndex()-1)*10);
  List<Student> students = criteria.list();
 criteria.setProjection(null);
 criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
 Long resultCount = (Long)criteria.uniqueResult();

@Override
@SuppressWarnings("unchecked")
public List<?> findByCriteria(final DetachedCriteria criteria, final int firstResult, final int maxResults)
    throws DataAccessException {
  Assert.notNull(criteria, "DetachedCriteria must not be null");
  return nonNull(executeWithNativeSession((HibernateCallback<List<?>>) session -> {
    Criteria executableCriteria = criteria.getExecutableCriteria(session);
    prepareCriteria(executableCriteria);
    if (firstResult >= 0) {
      executableCriteria.setFirstResult(firstResult);
    }
    if (maxResults > 0) {
      executableCriteria.setMaxResults(maxResults);
    }
    return executableCriteria.list();
  }));
}

@Test
public void testCriteria() {
  Session session = openSession();
  session.beginTransaction();
  Criteria criteria = session.createCriteria( Door.class );
  criteria.setLockMode( LockMode.PESSIMISTIC_WRITE );
  criteria.setFirstResult( 2 );
  criteria.setMaxResults( 2 );
  @SuppressWarnings("unchecked") List<Door> results = criteria.list();
  assertEquals( 2, results.size() );
  for ( Door door : results ) {
    assertEquals( LockMode.PESSIMISTIC_WRITE, session.getCurrentLockMode( door ) );
  }
  session.getTransaction().commit();
  session.close();
}

assertTrue( list.size()==1 && list.get(0)==f );
list = s.createCriteria(Foo.class)
  .setFirstResult(1)
  .addOrder( Order.asc("date") )
  .addOrder( Order.desc("string") )

/**
 * @see org.openmrs.api.db.OpenmrsDataDAO#getAll(boolean, java.lang.Integer, java.lang.Integer)
 */
@Override
public List<T> getAll(boolean includeVoided, Integer firstResult, Integer maxResults) {
  Criteria crit = sessionFactory.getCurrentSession().createCriteria(mappedClass);
  
  if (!includeVoided) {
    crit.add(Restrictions.eq("voided", false));
  }
  crit.setFirstResult(firstResult);
  crit.setMaxResults(maxResults);
  
  return crit.list();
  
}

/**
 * @see org.openmrs.api.db.OpenmrsMetadataDAO#getAll(boolean, java.lang.Integer, java.lang.Integer)
 */
@Override
public List<T> getAll(boolean includeRetired, Integer firstResult, Integer maxResults) {
  Criteria crit = sessionFactory.getCurrentSession().createCriteria(mappedClass);
  
  if (!includeRetired) {
    crit.add(Restrictions.eq("retired", false));
  }
  crit.setFirstResult(firstResult);
  crit.setMaxResults(maxResults);
  
  return crit.list();
  
}

.setFirstResult( 1 ).setMaxResults( 3 ).list();

 Criteria crit = HibernateUtil.getSession().createCriteria( persistentClass );
crit.setFirstResult(startIndex);
crit.setFetchSize(fetchSize);
crit.setCachable(true); // Enable caching of this query result
return crit.list();

/**
 * @see org.openmrs.api.db.EncounterDAO#getEncounters(String, Integer, Integer, Integer,
 *      boolean)
 */
@Override
@SuppressWarnings("unchecked")
public List<Encounter> getEncounters(String query, Integer patientId, Integer start, Integer length,
    boolean includeVoided) {
  if (StringUtils.isBlank(query) && patientId == null) {
    return Collections.emptyList();
  }
  
  Criteria criteria = createEncounterByQueryCriteria(query, patientId, includeVoided, true);
  
  if (start != null) {
    criteria.setFirstResult(start);
  }
  if (length != null && length > 0) {
    criteria.setMaxResults(length);
  }
  
  return criteria.list();
}

/**
 * @see org.openmrs.api.db.ConceptDAO#getConceptReferenceTerms(String, ConceptSource, Integer,
 *      Integer, boolean)
 */
@SuppressWarnings("unchecked")
@Override
public List<ConceptReferenceTerm> getConceptReferenceTerms(String query, ConceptSource conceptSource, Integer start,
    Integer length, boolean includeRetired) throws APIException {
  Criteria criteria = createConceptReferenceTermCriteria(query, conceptSource, includeRetired);
  
  if (start != null) {
    criteria.setFirstResult(start);
  }
  if (length != null && length > 0) {
    criteria.setMaxResults(length);
  }
  
  return criteria.list();
}

private void setFirstAndMaxResult(Criteria criteria, Integer start, Integer length) {
  if (start != null) {
    criteria.setFirstResult(start);
  }
  
  int maximumSearchResults = HibernatePersonDAO.getMaximumSearchResults();
  if (length != null && length < maximumSearchResults) {
    criteria.setMaxResults(length);
  } else {
    if (log.isDebugEnabled()) {
      log.debug("Limiting the size of the number of matching patients to " + maximumSearchResults);
    }
    criteria.setMaxResults(maximumSearchResults);
  }
}

@Override
public ListPart<T> listPart(Long firstResult, Long maxResults) {
  criteria.setProjection(null);
  criteria.setResultTransformer(Criteria.ROOT_ENTITY);
  
  if (firstResult != null) {
    criteria.setFirstResult(firstResult.intValue());
  }
  
  if (maxResults != null) {
    criteria.setMaxResults(maxResults.intValue());
  }
  
  @SuppressWarnings("unchecked")
  List<T> list = criteria.list();
  
  return ListPart.newListPart(list, firstResult, maxResults, null, null);
}

/**
 * @see org.openmrs.hl7.db.HL7DAO#getHL7Batch(Class, int, int, Integer, String)
 */
@Override
@SuppressWarnings( { "rawtypes", "unchecked" })
public <T> List<T> getHL7Batch(Class clazz, int start, int length, Integer messageState, String query)
    throws DAOException {
  Criteria crit = getHL7SearchCriteria(clazz, messageState, query);
  crit.setFirstResult(start);
  crit.setMaxResults(length);
  crit.addOrder(Order.asc("dateCreated"));
  return crit.list();
}

public List<?> getListByCriteria(DetachedCriteria criteria, Integer startPage, Integer pageSize) {
  if (startPage != null && pageSize != null) {
    return criteria.getExecutableCriteria(getCurrentSession()).setProjection(null)
        .setResultTransformer(CriteriaSpecification.ROOT_ENTITY).setFirstResult(startPage).setMaxResults(pageSize).list();
  } else {
    return criteria.getExecutableCriteria(getCurrentSession()).setProjection(null)
        .setResultTransformer(CriteriaSpecification.ROOT_ENTITY).list();
  }
}

/**
 * @see org.openmrs.api.db.ProviderDAO#getProviders(String, Map, Integer, Integer, boolean)
 */
@Override
public List<Provider> getProviders(String name, Map<ProviderAttributeType, String> serializedAttributeValues,
    Integer start, Integer length, boolean includeRetired) {
  Criteria criteria = prepareProviderCriteria(name, includeRetired);
  if (start != null) {
    criteria.setFirstResult(start);
  }
  if (length != null) {
    criteria.setMaxResults(length);
  }
  
  if (includeRetired) {
    //push retired Provider to the end of the returned list
    criteria.addOrder(Order.asc("retired"));
  }
  
  List<Provider> providers = criteria.list();
  if (serializedAttributeValues != null) {
    CollectionUtils.filter(providers, new AttributeMatcherPredicate<Provider, ProviderAttributeType>(
        serializedAttributeValues));
  }
  return providers;
}

public <T> List<T> getListByCriteria(DetachedCriteria criteria, PageInfo page) {
  if (page == null) {
    return criteria.getExecutableCriteria(getCurrentSession()).setProjection(null)
        .setResultTransformer(CriteriaSpecification.ROOT_ENTITY).list();
  } else {
    return criteria.getExecutableCriteria(getCurrentSession()).setProjection(null)
        .setResultTransformer(CriteriaSpecification.ROOT_ENTITY).setFirstResult((page.getPageNum() - 1) * page.getPageSize())
        .setMaxResults(page.getPageSize()).list();
  }
}

Javadoc

Set the first result to be retrieved.

Popular methods of Criteria

list
Get the results.
add
Add a Criterion to constrain the results to be retrieved.
uniqueResult
Convenience method to return a single instance that matches the query, or null if the query returns
addOrder
Add an Order to the result set.
setProjection
Used to specify that the query results will be a projection (scalar in nature). Implicitly specifies
setMaxResults
Set a limit upon the number of objects to be retrieved.
setResultTransformer
Set a strategy for handling the query results. This determines the "shape" of the query result.
createAlias
Join an association using the specified join-type, assigning an alias to the joined association. The
createCriteria
Create a new Criteria, "rooted" at the associated entity, using the specified join type.
setFetchMode
Specify an association fetching strategy for an association or a collection of values.
setCacheable
Enable caching of this query result, provided query caching is enabled for the underlying session fa
setFetchSize
Set a fetch size for the underlying JDBC query.

Popular in Java

Finding current android device location
onRequestPermissionsResult (Fragment)
getExternalFilesDir (Context)
getSupportFragmentManager (FragmentActivity)
Return the FragmentManager for interacting with fragments associated with this activity.
Format (java.text)
The base class for all formats. This is an abstract base class which specifies the protocol for clas
Dictionary (java.util)
The Dictionary class is the abstract parent of any class, such as Hashtable, which maps keys to valu
LinkedHashMap (java.util)
Hash table and linked list implementation of the Map interface, with predictable iteration order. Th
Reference (javax.naming)
Filter (javax.servlet)
A filter is an object that performs filtering tasks on either the request to a resource (a servlet o
SAXParseException (org.xml.sax)
Encapsulate an XML parse error or warning.This exception may include information for locating the er

How to use setFirstResultmethodin org.hibernate.Criteria

Best Java code snippets using org.hibernate.Criteria.setFirstResult (Showing top 20 results out of 756)

How to use
setFirstResult
method
in
org.hibernate.Criteria