當前位置: 首頁>>代碼示例>>Java>>正文

Java TypedQuery.setFirstResult方法代碼示例

本文整理匯總了Java中javax.persistence.TypedQuery.setFirstResult方法的典型用法代碼示例。如果您正苦於以下問題：Java TypedQuery.setFirstResult方法的具體用法？Java TypedQuery.setFirstResult怎麽用？Java TypedQuery.setFirstResult使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類javax.persistence.TypedQuery的用法示例。


在下文中一共展示了TypedQuery.setFirstResult方法的15個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的Java代碼示例。

示例1: getUsers

import javax.persistence.TypedQuery; //導入方法依賴的package包/類
@Override
public List<UserModel> getUsers(RealmModel realm, int firstResult, int maxResults) {

	TypedQuery<UserEntity> query = em.createNamedQuery("getAllUsers", UserEntity.class);
	if (firstResult != -1) {
		query.setFirstResult(firstResult);
	}
	if (maxResults != -1) {
		query.setMaxResults(maxResults);
	}
	List<UserEntity> results = query.getResultList();
	List<UserModel> users = new LinkedList<>();
	for (UserEntity entity : results)
		users.add(new UserAdapter(session, realm, model, entity));
	return users;
}
開發者ID:allianzit，項目名稱:ait-platform，代碼行數:17，代碼來源:AitEjbUserStorageProvider.java

示例2: searchForUser

import javax.persistence.TypedQuery; //導入方法依賴的package包/類
@Override
public List<UserModel> searchForUser(String search, RealmModel realm, int firstResult, int maxResults) {
	TypedQuery<UserEntity> query = em.createNamedQuery("searchForUser", UserEntity.class);
	query.setParameter("search", "%" + search.toLowerCase() + "%");
	if (firstResult != -1) {
		query.setFirstResult(firstResult);
	}
	if (maxResults != -1) {
		query.setMaxResults(maxResults);
	}
	List<UserEntity> results = query.getResultList();
	List<UserModel> users = new LinkedList<>();
	for (UserEntity entity : results)
		users.add(new UserAdapter(session, realm, model, entity));
	return users;
}
開發者ID:allianzit，項目名稱:ait-platform，代碼行數:17，代碼來源:AitEjbUserStorageProvider.java

示例3: list

import javax.persistence.TypedQuery; //導入方法依賴的package包/類
@Override
public <T> List<T> list(Pageable pageable) {
	if (parent != null) {
		applyPredicateToCriteria(sq);
		return parent.list(pageable);
	}
	if (pageable == null) {
		return list();
	} else {
		Sort sort = pageable.getSort();
		orders.addAll(QueryUtils.toOrders(sort, root, cb));
		applyPredicateToCriteria(criteria);
		TypedQuery<?> query = em.createQuery(criteria);
		
		query.setFirstResult(pageable.getOffset());
		query.setMaxResults(pageable.getPageSize());

		return transform(query, false);
	}
}
開發者ID:muxiangqiu，項目名稱:linq，代碼行數:21，代碼來源:LinqImpl.java

示例4: readPage

import javax.persistence.TypedQuery; //導入方法依賴的package包/類
private <T> Page<T> readPage(TypedQuery<Long> countQuery, TypedQuery<T> query, Pageable pageable) {
    query.setFirstResult(pageable.getOffset());
    query.setMaxResults(pageable.getPageSize());

    return PageableExecutionUtils.getPage(query.getResultList(), pageable,
        () -> executeCountQuery(countQuery));
}
開發者ID:xm-online，項目名稱:xm-commons，代碼行數:8，代碼來源:PermittedRepository.java

示例5: buscarComLimite

import javax.persistence.TypedQuery; //導入方法依賴的package包/類
public List<T> buscarComLimite(int paginaAtual, int tamanhoPagina) {
    CriteriaBuilder cb = entityManager.getCriteriaBuilder();
    CriteriaQuery<T> cq = cb.createQuery(entityClass);
    Root<T> root = cq.from(entityClass);
    cq.select(root);
    cq.orderBy(cb.desc(root.get("id")));
    TypedQuery typedQuery = entityManager.createQuery(cq);
    typedQuery.setFirstResult(paginaAtual);
    typedQuery.setMaxResults(tamanhoPagina);
    return typedQuery.getResultList();
}
開發者ID:JDanielT，項目名稱:search-doc，代碼行數:12，代碼來源:DAOGenerico.java

示例6: resultsWithStartAndLimit

import javax.persistence.TypedQuery; //導入方法依賴的package包/類
/**
 * Returns the query result for a query with a start and limit parameter.
 * Negative starts and limits are ignored.
 * @param em The currently open entity manager.
 * @param query The query. Parameters must all be bound.
 * @param start The start index. Negative values are ignored.
 * @param limit The limit. Negative values are ignored.
 * @return The query result.
 */
protected List<P> resultsWithStartAndLimit(EntityManager em, TypedQuery<P> query, int start, int limit) {
	if (start >= 0) {
		query.setFirstResult(start);
    }
	if (limit >= 0) {
		query = query.setMaxResults(limit);
	}
	return query.getResultList();
}
開發者ID:DescartesResearch，項目名稱:Pet-Supply-Store，代碼行數:19，代碼來源:AbstractPersistenceRepository.java

示例7: getUsers

import javax.persistence.TypedQuery; //導入方法依賴的package包/類
@Override
public List<UserModel> getUsers(RealmModel realm, int firstResult, int maxResults) {

    TypedQuery<UserEntity> query = em.createNamedQuery("getAllUsers", UserEntity.class);
    if (firstResult != -1) {
        query.setFirstResult(firstResult);
    }
    if (maxResults != -1) {
        query.setMaxResults(maxResults);
    }
    List<UserEntity> results = query.getResultList();
    List<UserModel> users = new LinkedList<>();
    for (UserEntity entity : results) users.add(new UserAdapter(session, realm, model, entity));
    return users;
}
開發者ID:nmajorov，項目名稱:keycloak_training，代碼行數:16，代碼來源:EjbExampleUserStorageProvider.java

示例8: list

import javax.persistence.TypedQuery; //導入方法依賴的package包/類
public List<T> list(Integer startPosition, Integer limit) {
    TypedQuery<T> typedQuery = entityManager.createQuery(this.getQuery());
    if (startPosition != null) {
        typedQuery.setFirstResult(startPosition);
    }
    if (limit != null) {
        typedQuery.setMaxResults(limit);
    }
    return typedQuery.getResultList();
}
開發者ID:coodoo-io，項目名稱:coodoo-listing，代碼行數:11，代碼來源:ListingQuery.java

示例9: getRandomQuizzes

import javax.persistence.TypedQuery; //導入方法依賴的package包/類
public List<Quiz> getRandomQuizzes(int n, long categoryId){

        TypedQuery<Long>  sizeQuery= em.createQuery("select count(q) from Quiz q where q.subCategory.parent.id=?1", Long.class);
        sizeQuery.setParameter(1, categoryId);
        long size = sizeQuery.getSingleResult();

        if(n > size){
            throw new IllegalArgumentException("Cannot chose " + n + " unique quizzes out of the " + size + " existing");
        }

        Random random = new Random();

        List<Quiz> quizzes = new ArrayList<>();
        Set<Integer> chosen = new HashSet<>();

        while(chosen.size() < n) {

            int k = random.nextInt((int)size);
            if(chosen.contains(k)){
                continue;
            }
            chosen.add(k);

            TypedQuery<Quiz> query = em.createQuery(
                    "select q from Quiz q where q.subCategory.parent.id=?1",
                    Quiz.class);
            query.setParameter(1, categoryId);
            query.setMaxResults(1);
            query.setFirstResult(k);

            quizzes.add(query.getSingleResult());
        }


        return  quizzes;
    }
開發者ID:arcuri82，項目名稱:testing_security_development_enterprise_systems，代碼行數:37，代碼來源:QuizEjb.java

示例10: getRandomQuizzes

import javax.persistence.TypedQuery; //導入方法依賴的package包/類
public List<Quiz> getRandomQuizzes(int n, long categoryId){

        TypedQuery<Long> sizeQuery= em.createQuery(
                "select count(q) from Quiz q where q.subCategory.parent.id=?1", Long.class);
        sizeQuery.setParameter(1, categoryId);
        long size = sizeQuery.getSingleResult();

        if(n > size){
            throw new IllegalArgumentException("Cannot choose " + n + " unique quizzes out of the " + size + " existing");
        }

        Random random = new Random();

        List<Quiz> quizzes = new ArrayList<>();
        Set<Integer> chosen = new HashSet<>();

        while(chosen.size() < n) {

            int k = random.nextInt((int)size);
            if(chosen.contains(k)){
                continue;
            }
            chosen.add(k);

            TypedQuery<Quiz> query = em.createQuery(
                    "select q from Quiz q where q.subCategory.parent.id=?1", Quiz.class);
            query.setParameter(1, categoryId);
            query.setMaxResults(1);
            query.setFirstResult(k);

            quizzes.add(query.getSingleResult());
        }


        return  quizzes;
    }
開發者ID:arcuri82，項目名稱:testing_security_development_enterprise_systems，代碼行數:37，代碼來源:QuizEjb.java

示例11: search

import javax.persistence.TypedQuery; //導入方法依賴的package包/類
@Override
public List<?> search(String entityName, String query, int limit, int pageNumber)
{
	List<T> resultsList = new ArrayList<>();
	
	Class<T> clazz = entityList.get(entityName);
	
	if(clazz == null) throw new RuntimeException("ENTITY.NOT.FOUND");
	
	boolean isValid = query == null ? true : validateQuery(query, clazz);  
	
	if(isValid) {
		
		CriteriaBuilder criteriaBuilder = entitymanager.getCriteriaBuilder();
		CriteriaQuery<T> cq = criteriaBuilder.createQuery(clazz);
		
		Root<T> root = cq.from(clazz);			
		
		if(query!=null) {
			Predicate predicate = populatePredicates(root, query);
			cq.where(predicate);				
		}
		
           cq.select(root);
           TypedQuery<T> q = entitymanager.createQuery(cq);
           q.setFirstResult((pageNumber-1) * limit);
           q.setMaxResults(limit);
           resultsList = q.getResultList();
           System.out.println(resultsList.size());
	} else {
		throw new RuntimeException("Property defined in the query is not valid, doesn't belong to the entity type:"+entityName);
	}
	return resultsList;
}
開發者ID:tairmansd，項目名稱:CriteriaBuilder，代碼行數:35，代碼來源:CriteriaServiceImpl.java

示例12: findAll

import javax.persistence.TypedQuery; //導入方法依賴的package包/類
@SuppressWarnings("unchecked")
/**
 * 分頁條件查詢
 * @param cq 條件
 * @param pageable 分頁信息
 * @param <T> 領域類（實體類）範型
 * @return 分頁結果
 */
public static <T> Page<T> findAll(CriteriaQuery<T> cq, Pageable pageable) {
	Class<T> domainClass = cq.getResultType();
	Root<T> root;
	if (CollectionUtils.isEmpty(cq.getRoots())) {
		root = cq.from(domainClass);
	} else {
		root = (Root<T>) cq.getRoots().iterator().next();
	}
	EntityManager em = getEntityManager(domainClass);
	if (pageable == null) {
		List<T> list = findAll(cq);
		return new PageImpl<T>(list);
	} else {
		Sort sort = pageable.getSort();
		cq.orderBy(QueryUtils.toOrders(sort, root, em.getCriteriaBuilder()));
		TypedQuery<T> query = em.createQuery(cq);
		
		query.setFirstResult(pageable.getOffset());
		query.setMaxResults(pageable.getPageSize());

		Long total = count(cq);
		List<T> content = total > pageable.getOffset() ? query.getResultList() : Collections.<T> emptyList();

		return new PageImpl<T>(content, pageable, total);
	}
}
開發者ID:muxiangqiu，項目名稱:linq，代碼行數:35，代碼來源:JpaUtil.java

示例13: paging

import javax.persistence.TypedQuery; //導入方法依賴的package包/類
@Override
public <T> Page<T> paging(Pageable pageable) {
	if (parent != null) {
		applyPredicateToCriteria(sq);
		return parent.paging(pageable);
	}
	List<T> list;
	if (pageable == null) {
		list = list();
		return new PageImpl<T>(list);
	} else {
		Sort sort = pageable.getSort();
		if (sort != null) {
			orders.addAll(QueryUtils.toOrders(sort, root, cb));
		}
		applyPredicateToCriteria(criteria);
		TypedQuery<?> query = em.createQuery(criteria);
		
		query.setFirstResult(pageable.getOffset());
		query.setMaxResults(pageable.getPageSize());

		Long total = JpaUtil.count(criteria);
		List<T> content = Collections.<T> emptyList();
		if (total > pageable.getOffset()) {
			content = transform(query, false);
		}

		return new PageImpl<T>(content, pageable, total);
	}
}
開發者ID:muxiangqiu，項目名稱:linq，代碼行數:31，代碼來源:LinqImpl.java

示例14: personDTOResultTest

import javax.persistence.TypedQuery; //導入方法依賴的package包/類
@Test
   public void personDTOResultTest() {
StrQLBuilder sql = StrQLBuilder.createNative()
	.select("p.id_person as idPerson")
	.select("p.name AS name")
	.select("p.surname as \"surname\"")
	.select("p.enabled as enabled,p.alive as alive")
	.select("p.creation_date as creationDate")
	.select("p.age as age, p.height as height")
	.select("p.name as reallyLongPropertyToTestLongAliases")
	.select("p.name as \"reallyLongPropertyToTestLongAliases\"")
	.select("p.birthday")
	.select("p.name as parent.name")
	.from("Person p")
	.leftjoin("Job j").on("j.id_job = p.id_job").and("p.name = :name", "Luis")
	.where("p.name = :pname", "Luis")
	.andlike("p.name", ":name_pattern", "uis")
	.and("p.name IN :pnamearray", (Object) new String[] { "Luis" })
	.and("p.name IN :pnamelist", Arrays.asList("Luis"))
	.and("p.name IN (:pnamelist2)", Arrays.asList("Luis"))
	.order(by("surname", DESC).and("name"));

TypedQuery<PersonDTO> query = sql.createQuery(entityManager, PersonDTO.class);
query.setFirstResult(0);
query.setMaxResults(1);
List<PersonDTO> persons = query.getResultList();

assertThat(persons, hasSize(1));
PersonDTO person = persons.get(0);
assertThat(person, is(not(nullValue())));
assertThat(person.getIdPerson(), is(not(nullValue())));
assertThat(person.getName(), is("Luis"));
assertThat(person.getSurname(), is("Labiano"));
assertThat(person.getAge(), is(11));
assertThat(person.getHeight(), is(1.20f));
assertThat(person.getBirthday(), is(not(nullValue())));
assertThat(person.getCreationDate(), is(not(nullValue())));
assertThat(person.getEnabled(), is(Enabled.ENABLED));
assertThat(person.getAlive(), is(true));
assertThat(person.getReallyLongPropertyToTestLongAliases(), is("Luis"));
assertThat(person.getParent().getName(), is("Luis"));
   }
開發者ID:iaunzu，項目名稱:strqlbuilder，代碼行數:43，代碼來源:StrQLBuilderNativeTest.java

示例15: list

import javax.persistence.TypedQuery; //導入方法依賴的package包/類
public List<R> list(int offset, int size) {
	TypedQuery<R> typedQuery = em.createQuery(query);
	typedQuery.setFirstResult(offset);
	typedQuery.setMaxResults(size);
	return typedQuery.getResultList();
}
開發者ID:szsucok，項目名稱:sucok-framework，代碼行數:7，代碼來源:BaseDao.java


注：本文中的javax.persistence.TypedQuery.setFirstResult方法示例由純淨天空整理自Github/MSDocs等開源代碼及文檔管理平台，相關代碼片段篩選自各路編程大神貢獻的開源項目，源碼版權歸原作者所有，傳播和使用請參考對應項目的License；未經允許，請勿轉載。