org.hibernate.Query.iterate()方法的使用及代码示例

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

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

Query.iterate介绍

[英]Return the query results as an Iterator. If the query contains multiple results per row, the results are returned in an instance of Object[].

Entities returned as results are initialized on demand. The first SQL query returns identifiers only.
[中]以迭代器的形式返回查询结果。如果查询每行包含多个结果，则结果将在对象[]的实例中返回。
作为结果返回的实体按需初始化。第一个SQL查询只返回标识符。

代码示例

代码示例来源：origin: spring-projects/spring-framework

  1. @Deprecated
  2. @Override
  3. @SuppressWarnings({"rawtypes", "deprecation"})
  4. public Iterator<?> iterate(final String queryString, @Nullable final Object... values) throws DataAccessException {
  5.   return nonNull(executeWithNativeSession((HibernateCallback<Iterator<?>>) session -> {
  6.     org.hibernate.Query queryObject = queryObject(
  7.         ReflectionUtils.invokeMethod(createQueryMethod, session, queryString));
  8.     prepareQuery(queryObject);
  9.     if (values != null) {
  10.       for (int i = 0; i < values.length; i++) {
  11.         queryObject.setParameter(i, values[i]);
  12.       }
  13.     }
  14.     return queryObject.iterate();
  15.   }));
  16. }

代码示例来源：origin: org.springframework/spring-orm

  1. @Deprecated
  2. @Override
  3. @SuppressWarnings({"rawtypes", "deprecation"})
  4. public Iterator<?> iterate(final String queryString, @Nullable final Object... values) throws DataAccessException {
  5.   return nonNull(executeWithNativeSession((HibernateCallback<Iterator<?>>) session -> {
  6.     org.hibernate.Query queryObject = queryObject(
  7.         ReflectionUtils.invokeMethod(createQueryMethod, session, queryString));
  8.     prepareQuery(queryObject);
  9.     if (values != null) {
  10.       for (int i = 0; i < values.length; i++) {
  11.         queryObject.setParameter(i, values[i]);
  12.       }
  13.     }
  14.     return queryObject.iterate();
  15.   }));
  16. }

代码示例来源：origin: hibernate/hibernate-orm

  1. public SyntaxChecker checkIterate() {
  2.     Session s = openSession();
  3.     s.beginTransaction();
  4.     Query query = s.createQuery( hql );
  5.     preparer.prepare( query );
  6.     query.iterate();
  7.     s.getTransaction().commit();
  8.     s.close();
  9.     return this;
  10.   }
  11. }

代码示例来源：origin: hibernate/hibernate-orm

  1. Query query = s.createQuery("from DataPoint dp order by dp.x asc");
  2. s.setDefaultReadOnly( true );
  3. Iterator it = query.iterate();
  4. s.setDefaultReadOnly( false );
  5. while ( it.hasNext() ) {

代码示例来源：origin: hibernate/hibernate-orm

  1. q.setString( 0, "Simple 1" );
  2. q.setFirstResult(0);
  3. assertTrue( q.iterate().hasNext() );
  4. q = s.createQuery("from Simple s where s.name = :foo and upper(s.name) = :bar or s.count=:count or s.count=:count + 1");
  5. q.setParameter( "bar", "SIMPLE 1" );
  6. q.setInteger("count", 69);
  7. q.setFirstResult(0);
  8. assertTrue( q.iterate().hasNext() );
  9. q = s.createQuery("select s.id from Simple s");
  10. q.setFirstResult(1);
  11. q.setMaxResults( 2 );
  12. iter = q.iterate();
  13. int i=0;
  14. while ( iter.hasNext() ) {

代码示例来源：origin: hibernate/hibernate-orm

  1. assertEquals( ( (ManyToOneType) type ).getAssociatedEntityName(), "org.hibernate.test.hql.Zoo" );
  2. zoo = (Zoo) q
  3.   .iterate().next();
  4. assertEquals( zoo.getMammals().size(), 1 );
  5. assertEquals( zoo.getAnimals().size(), 1 );

代码示例来源：origin: hibernate/hibernate-orm

  1. q.setString(0, "Simple 1");
  2. q.setFirstResult(0);
  3. assertTrue( q.iterate().hasNext() );
  4. q = s.createQuery("from Simple s where s.name = :foo and upper(s.name) = :bar or s.count=:count or s.count=:count + 1");
  5. q.setParameter("bar", "SIMPLE 1");
  6. q.setInteger("count", 69);
  7. q.setFirstResult(0);
  8. assertTrue( q.iterate().hasNext() );
  9. q = s.createQuery("select s.id from Simple s");
  10. q.setFirstResult(1);
  11. q.setMaxResults(2);
  12. iter = q.iterate();
  13. int i=0;
  14. while ( iter.hasNext() ) {

代码示例来源：origin: hibernate/hibernate-orm

  1. assertTrue( q.iterate().hasNext() );
  2. assertTrue( s.createFilter( master.getIncoming(), "where this.id > -1 and this.name is not null" ).list().size()==0 );
  3. assertTrue( s.createFilter( master.getDetails(), "select max(this.i)" ).iterate().next() instanceof Integer );
  4. assertTrue( s.createFilter( master.getDetails(), "select max(this.i) group by this.id" ).iterate().next() instanceof Integer );
  5. assertTrue( s.createFilter( master.getDetails(), "select count(*)" ).iterate().next() instanceof Long );
  6. f.setInteger("top", 100);
  7. f.setInteger("bottom", 0);
  8. assertEquals( f.iterate().next(), new Integer(12) );
  9. f.setInteger("top", 2);
  10. assertEquals( f.iterate().next(), new Integer(0) );
  11. coll.add( new Integer(0) );
  12. f.setParameterList("list", coll);
  13. assertEquals( f.iterate().next(), new Integer(12) );
  14. assertEquals( f.iterate().next(), new Integer(12) );

代码示例来源：origin: hibernate/hibernate-orm

  1. getSelectNewQuery( session ).setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).iterate();
  2. fail("'select new' together with a resulttransformer should result in error!");

代码示例来源：origin: hibernate/hibernate-orm

  1. s.setDefaultReadOnly( false );
  2. assertFalse( s.isDefaultReadOnly() );
  3. Iterator it = query.iterate();
  4. assertTrue( query.isReadOnly() );
  5. DataPoint dpLast = ( DataPoint ) s.get( DataPoint.class, dp.getId() );

代码示例来源：origin: hibernate/hibernate-orm

  1. s.setDefaultReadOnly( true );
  2. assertTrue( s.isDefaultReadOnly() );
  3. Iterator it = query.iterate();
  4. assertFalse( query.isReadOnly() );
  5. DataPoint dpLast = ( DataPoint ) s.get( DataPoint.class, dp.getId() );

代码示例来源：origin: hazelcast/hazelcast-code-samples

  1. @Override
  2.   public Iterator<T> iterator() {
  3.     return new CloseableIterator<T>((HibernateIterator) query.iterate());
  4.   }
  5. }

代码示例来源：origin: uk.ac.ebi.intact.core/intact-core

  1. public Iterator<Interaction> getInteractionsForExperimentWithAcIterator( String ac ) {
  2.   Query query = getSession().createQuery("from InteractionImpl as interaction left join interaction.experiments as exp where exp.ac = :ac");
  3.   query.setParameter("ac", ac);
  4.   return query.iterate();
  5. }

代码示例来源：origin: org.n52.sensorweb/52n-sps-hibernate

  1. public long getCount(String procedure) {
  2.   LOGGER.debug("getCount({})", procedure);
  3.   Session currentSession = getCurrentSession();
  4.   Query query = currentSession.createQuery("select count(*) from SensorConfiguration");
  5.   return ((Long) query.iterate().next()).longValue();
  6. }

代码示例来源：origin: sakaiproject/sakai

  1. public boolean isEmpty(final String courseSetEid) {
  2.   HibernateCallback hc = session -> {
  3.     Query q = session.getNamedQuery("findNonEmptyCourseSet");
  4.     q.setParameter("eid", courseSetEid);
  5.     return Boolean.valueOf( ! q.iterate().hasNext());
  6.   };
  7.   return ((Boolean)getHibernateTemplate().execute(hc)).booleanValue();
  8. }

代码示例来源：origin: sakaiproject/sakai

  1. public boolean isEnrolled(final String userId, final Set<String> enrollmentSetEids) {
  2.   HibernateCallback hc = session -> {
  3.     Query q = session.getNamedQuery("countEnrollments");
  4.     q.setParameter("userId", userId);
  5.     q.setParameterList("enrollmentSetEids", enrollmentSetEids);
  6.     return q.iterate().next();
  7.   };
  8.   int i = ((Number)getHibernateTemplate().execute(hc)).intValue();
  9.   if(log.isDebugEnabled()) log.debug(userId + " is enrolled in " + i + " of these " + enrollmentSetEids.size() + " EnrollmentSets" );
  10.   return i > 0;
  11. }

代码示例来源：origin: uk.ac.ebi.intact.core/intact-core

  1. @Transactional(propagation = Propagation.MANDATORY)
  2. public Iterator<T> getByShortLabelLikeIterator(String value, boolean ignoreCase) {
  3.   Query query;
  4.   if (ignoreCase) {
  5.     query = getEntityManager().createQuery("from " + getEntityClass().getSimpleName() + " where lower(shortlabel) = lower(:label)");
  6.   } else {
  7.     query = getEntityManager().createQuery("from " + getEntityClass().getSimpleName() + " where shortlabel = :label");
  8.   }
  9.   query.setParameter("label", value);
  10.   return ((HibernateQuery) query).getHibernateQuery().iterate();
  11. }

代码示例来源：origin: org.ow2.bonita/bonita-server

  1. @Override
  2. public List<LabelImpl> getUserCustomLabels(final String ownerName) {
  3.  final List<LabelImpl> result = new ArrayList<LabelImpl>();
  4.  final Query query = getSession().getNamedQuery("getUserCustomLabels");
  5.  query.setString("ownerName", ownerName);
  6.  CollectionUtils.addAll(result, query.iterate());
  7.  return result;
  8. }

代码示例来源：origin: org.ow2.bonita/bonita-server

  1. @Override
  2. public Set<TaskInstance> getUserTasks(final String userId, final Collection<ActivityState> taskStates) {
  3.  final Query query = getSession().getNamedQuery("getUserTasksWithStates");
  4.  query.setString("userId", userId);
  5.  query.setParameterList("states", taskStates, ACTIVITY_STATE_USER_TYPE);
  6.  final Set<TaskInstance> result = new HashSet<TaskInstance>();
  7.  CollectionUtils.addAll(result, query.iterate());
  8.  return result;
  9. }

代码示例来源：origin: org.ow2.bonita/bonita-server

  1. @Override
  2. public Set<IncomingEventInstance> getIncomingEvents(final ActivityInstanceUUID activityUUID) {
  3.  final Set<IncomingEventInstance> result = new HashSet<IncomingEventInstance>();
  4.  final Query query = getSession().getNamedQuery("getActivityInstanceIncomingEvents");
  5.  query.setString("activityUUID", activityUUID.getValue());
  6.  CollectionUtils.addAll(result, query.iterate());
  7.  return result;
  8. }

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

query

相关文章

    查看更多

    热门标签

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

    最新文章

    更多

    Query类方法

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