javax.jcr.query.Query.setLimit()方法的使用及代码示例

x33g5p2x  于2022-01-28 转载在 其他  
字(7.8k)|赞(0)|评价(0)|浏览(307)

本文整理了Java中javax.jcr.query.Query.setLimit方法的一些代码示例，展示了Query.setLimit的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。Query.setLimit方法的具体详情如下：
包路径：javax.jcr.query.Query
类名称：Query
方法名：setLimit

Query.setLimit介绍

[英]Sets the maximum size of the result set to limit.
[中]将结果集的最大大小设置为[$0$]。

代码示例

代码示例来源：origin: apache/jackrabbit

  1. /** {@inheritDoc} */
  2. public void setLimit(long limit) throws RemoteException {
  3.   query.setLimit(limit);
  4. }

代码示例来源：origin: net.adamcin.oakpal/oakpal-core

  1. @Override
  2. public void setLimit(long limit) {
  3.   delegate.setLimit(limit);
  4. }

代码示例来源：origin: brix-cms/brix-cms

  1. public void execute() throws Exception {
  2.     getDelegate().setLimit(limit);
  3.   }
  4. });

代码示例来源：origin: brix-cms/brix-cms

  1. public void setLimit(long limit) {
  2.   getDelegate().setLimit(limit);
  3. }

代码示例来源：origin: org.apache.jackrabbit/jackrabbit-core

  1. /**
  2.  * @inheritDoc
  3.  */
  4. @Override
  5. public Node findNode(Name nodeName, Name ntName) throws RepositoryException {
  6.   Query query = buildQuery(nodeName, ntName);
  7.   query.setLimit(1);        
  8.   NodeIterator res = query.execute().getNodes();
  9.   if (res.hasNext()) {
  10.     return res.nextNode();
  11.   }
  12.   return null;
  13. }

代码示例来源：origin: apache/jackrabbit

  1. /**
  2.  * @inheritDoc
  3.  */
  4. @Override
  5. public Node findNode(Name nodeName, Name ntName) throws RepositoryException {
  6.   Query query = buildQuery(nodeName, ntName);
  7.   query.setLimit(1);        
  8.   NodeIterator res = query.execute().getNodes();
  9.   if (res.hasNext()) {
  10.     return res.nextNode();
  11.   }
  12.   return null;
  13. }

代码示例来源：origin: apache/jackrabbit-oak

  1. protected void processResultsOffsetPagination(@NotNull final QueryManager qm,
  2.     ExecutionContext context) throws RepositoryException {
  3.   for (int page = 0; page < PAGES; page++) {
  4.     Query query = getQuery(qm, context);
  5.     query.setLimit(LIMIT);
  6.     query.setOffset(page * LIMIT);
  7.     iterate(query);
  8.   }
  9. }

代码示例来源：origin: info.magnolia.ui/magnolia-ui-framework

  1. protected QueryResult executeQuery(String statement, String language, int limit, int offset) throws RepositoryException {
  2.   final Session jcrSession = MgnlContext.getJCRSession(WORKSPACE_NAME);
  3.   final QueryManager jcrQueryManager = jcrSession.getWorkspace().getQueryManager();
  4.   final Query query = jcrQueryManager.createQuery(statement, language);
  5.   if (limit > 0) {
  6.     query.setLimit(limit);
  7.   }
  8.   if (offset >= 0) {
  9.     query.setOffset(offset);
  10.   }
  11.   logger.debug("Executing query against workspace [{}] with statement [{}] and limit {} and offset {}...", new Object[]{WORKSPACE_NAME, statement, limit, offset});
  12.   long start = System.currentTimeMillis();
  13.   final QueryResult result = query.execute();
  14.   logger.debug("Query execution took {} ms", System.currentTimeMillis() - start);
  15.   return result;
  16. }

代码示例来源：origin: apache/jackrabbit-oak

  1. protected void processResultsKeysetPagination(@NotNull final QueryManager qm,
  2.     ExecutionContext context) throws RepositoryException {
  3.   Calendar now = Calendar.getInstance();
  4.   now.setTimeZone(TimeZone.getTimeZone("GMT"));
  5.   context.getMap().put(KEYSET_VAL_PROP, now);
  6.   for (int page = 0; page < PAGES; page++) {
  7.     Query query = getQuery(qm, context);
  8.     query.setLimit(LIMIT);
  9.     Node lastNode = iterate(query);
  10.     if (lastNode != null) {
  11.       Property prop =
  12.           lastNode.getProperty(ScalabilityNodeSuite.CTX_PAGINATION_KEY_PROP);
  13.       context.getMap().put(KEYSET_VAL_PROP, prop.getDate());
  14.     }
  15.   }
  16.   context.getMap().remove(KEYSET_VAL_PROP);
  17. }

代码示例来源：origin: apache/jackrabbit-oak

  1. protected void searchCommon(QueryManager qm, ExecutionContext context)
  2.   throws RepositoryException {
  3.   /** Execute standard query */
  4.   Query stdQuery = getStandardQuery(qm, context);
  5.   stdQuery.setLimit(LIMIT);
  6.   QueryResult stdResult = stdQuery.execute();
  7.   RowIterator stdIt = stdResult.getRows();
  8.   // Iterate the standard shown first
  9.   for (int rows = 0; stdIt.hasNext() && rows < LIMIT; rows++) {
  10.     Node node = stdIt.nextRow().getNode();
  11.     LOG.debug(node.getPath());
  12.   }
  13. }

代码示例来源：origin: apache/jackrabbit-oak

  1. protected void searchCommon(QueryManager qm, ExecutionContext
  2.   context) throws RepositoryException {
  3.   /** Execute standard query */
  4.   Query stdQuery = getStandardQuery(qm, context);
  5.   stdQuery.setLimit(LIMIT);
  6.   QueryResult stdResult = stdQuery.execute();
  7.   RowIterator stdIt = stdResult.getRows();
  8.   // Iterate the standard shown first
  9.   for (int rows = 0; stdIt.hasNext() && rows < LIMIT; rows++) {
  10.     Node node = stdIt.nextRow().getNode();
  11.     LOG.debug(node.getPath());
  12.   }
  13. }

代码示例来源：origin: stackoverflow.com

  1. Query q = pm.newQuery (...);
  2. q.setWhere(...);
  3. q.setRange (...);
  4. q.setOrdering (...);
  5. q.setLimit(...);
  6. q.newParameter(...); // declare a query parameter
  8. q.execute(34.5); // execute the SQL query with a parameter

代码示例来源：origin: apache/jackrabbit

  1. public void testLimit() throws Exception {
  2.   query.setLimit(1);
  3.   QueryResult result = query.execute();
  4.   checkResult(result, new Node[] { node1 });
  5.   query.setLimit(2);
  6.   result = query.execute();
  7.   checkResult(result, new Node[] { node1, node2 });
  8.   query.setLimit(3);
  9.   result = query.execute();
  10.   checkResult(result, new Node[] { node1, node2, node3 });
  11. }

代码示例来源：origin: apache/jackrabbit

  1. public void testSimplePagination() throws Exception {
  2.   List<String> expected = new ArrayList<String>(c);
  3.   Query q = newQuery();
  4.   for (int i = 0; i < c.size(); i++) {
  5.     q.setOffset(i);
  6.     q.setLimit(1);
  7.     List<String> out = qrToPaths(q.execute());
  8.     assertEquals(1, out.size());
  9.     assertTrue(expected.remove(out.get(0)));
  10.   }
  11.   assertTrue(expected.isEmpty());
  12. }

代码示例来源：origin: apache/jackrabbit

  1. public void testLimitGtSize() throws Exception {
  2.   List<String> expected = new ArrayList<String>(c);
  3.   Query q = newQuery();
  4.   q.setOffset(0);
  5.   q.setLimit(c.size() * 2);
  6.   List<String> out = qrToPaths(q.execute());
  7.   assertEquals(c.size(), out.size());
  8.   for (String s : out) {
  9.     assertTrue(expected.remove(s));
  10.   }
  11.   assertTrue(expected.isEmpty());
  12. }

代码示例来源：origin: apache/jackrabbit

  1. public void testLimitEqSize() throws Exception {
  2.   List<String> expected = new ArrayList<String>(c);
  3.   Query q = newQuery();
  4.   q.setOffset(0);
  5.   q.setLimit(c.size());
  6.   List<String> out = qrToPaths(q.execute());
  7.   assertEquals(c.size(), out.size());
  8.   for (String s : out) {
  9.     assertTrue(expected.remove(s));
  10.   }
  11.   assertTrue(expected.isEmpty());
  12. }

代码示例来源：origin: apache/jackrabbit

  1. /**
  2.  * https://issues.apache.org/jira/browse/JCR-2543
  3.  */
  4. public void testSQL2Limit() throws Exception {
  5.   Query q = qm.createQuery("SELECT * FROM [nt:unstructured]",
  6.       Query.JCR_SQL2);
  7.   q.setLimit(1);
  8.   QueryResult r = q.execute();
  9.   NodeIterator it = r.getNodes();
  10.   assertTrue(it.hasNext());
  11.   it.next();
  12.   assertFalse(it.hasNext());
  13. }

代码示例来源：origin: ModeShape/modeshape

  1. @Test
  2. public void shouldBeAbleToQueryWithLimitOnNonJoin() throws RepositoryException {
  3.   // Try with the LIMIT expression ...
  4.   String sql = "SELECT [jcr:path] FROM [car:Car] LIMIT 2";
  5.   Query query = session.getWorkspace().getQueryManager().createQuery(sql, Query.JCR_SQL2);
  6.   QueryResult result = query.execute();
  7.   validateQuery().rowCount(2).hasColumns("jcr:path").validate(query, result);
  8.   // Try with the method ...
  9.   sql = "SELECT [jcr:path] FROM [car:Car]";
  10.   query = session.getWorkspace().getQueryManager().createQuery(sql, Query.JCR_SQL2);
  11.   query.setLimit(2);
  12.   result = query.execute();
  13.   validateQuery().rowCount(2).hasColumns("jcr:path").validate(query, result);
  14. }

代码示例来源：origin: ModeShape/modeshape

  1. @Test
  2. public void shouldBeAbleToQueryWithTooLargeLimitOnNonJoin() throws RepositoryException {
  3.   // Try with the LIMIT expression ...
  4.   String sql = "SELECT [jcr:path] FROM [car:Car] LIMIT 100";
  5.   Query query = session.getWorkspace().getQueryManager().createQuery(sql, Query.JCR_SQL2);
  6.   QueryResult result = query.execute();
  7.   validateQuery().rowCount(13).hasColumns("jcr:path").validate(query, result);
  8.   // Try with the method ...
  9.   sql = "SELECT [jcr:path] FROM [car:Car]";
  10.   query = session.getWorkspace().getQueryManager().createQuery(sql, Query.JCR_SQL2);
  11.   query.setLimit(100);
  12.   result = query.execute();
  13.   validateQuery().rowCount(13).hasColumns("jcr:path").validate(query, result);
  14. }

代码示例来源：origin: ModeShape/modeshape

  1. @Test
  2. public void shouldBeAbleToQueryWithLimitOfZeroOnNonJoin() throws RepositoryException {
  3.   // Try with the LIMIT expression ...
  4.   String sql = "SELECT [jcr:path] FROM [car:Car] LIMIT 0";
  5.   Query query = session.getWorkspace().getQueryManager().createQuery(sql, Query.JCR_SQL2);
  6.   QueryResult result = query.execute();
  7.   validateQuery().rowCount(0).hasColumns("jcr:path").validate(query, result);
  8.   // Try with the method ...
  9.   sql = "SELECT [jcr:path] FROM [car:Car]";
  10.   query = session.getWorkspace().getQueryManager().createQuery(sql, Query.JCR_SQL2);
  11.   query.setLimit(0);
  12.   result = query.execute();
  13.   validateQuery().rowCount(0).hasColumns("jcr:path").validate(query, result);
  14. }

内容来源于网络，如有侵权，请联系作者删除！

query

相关文章

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新文章

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com