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

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

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

Query.list介绍

[英]Return the query results as a List. If the query contains multiple results per row, the results are returned in an instance of Object[].
[中]以列表形式返回查询结果。如果查询每行包含多个结果，则结果将在对象[]的实例中返回。

代码示例

代码示例来源：origin: gocd/gocd

  1. @Override
  2. public List<Plugin> getAllPlugins() {
  3.   return (List<Plugin>) transactionTemplate.execute((TransactionCallback) transactionStatus -> {
  4.     Query query = sessionFactory.getCurrentSession().createQuery("FROM " + Plugin.class.getSimpleName());
  5.     query.setCacheable(true);
  6.     return query.list();
  7.   });
  8. }

代码示例来源：origin: citerus/dddsample-core

  1. public List<Cargo> findAll() {
  2.  return getSession().createQuery("from Cargo").list();
  3. }

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

  1. /**
  2.  * Call setEntity() on a cacheable query - see FORGE-265
  3.  */
  4. public List listEventsOfOrganizer(Person organizer) {
  5.   Session session = sessionFactory.getCurrentSession();
  6.   session.beginTransaction();
  7.   Query query = session.createQuery("from Event ev where ev.organizer = :organizer");
  8.   query.setCacheable(true);
  9.   query.setEntity("organizer", organizer);
  10.   List result = query.list();
  11.   session.getTransaction().commit();
  12.   return result;
  13. }

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

  1. assertTrue(
  2.     s.createFilter( master1.getIncoming(), "where this.id > 0 and this.name is not null" )
  3.         .list()
  4.         .size() == 2
  5. );
  6. Iterator iter = master1.getIncoming().iterator();
  7. int i=0;
  8. while ( iter.hasNext() ) {
  9.   Master m = (Master) iter.next();
  10.   assertTrue( "outgoing", m.getOutgoing().size()==1 );
  11.   assertTrue( "outgoing", m.getOutgoing().contains(master1) );

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

  1. Query q = s.createQuery("from Simple s");
  2. List list = q.setCacheable(true).list();
  3. assertTrue( list.size()==1 );
  4. t.commit();
  5. q = s.createQuery("from Simple s");
  6. list = q.setCacheable(true).list();
  7. assertTrue( list.size()==1 );
  8. t.commit();
  9. q = s.createQuery("from Simple s");
  10. list = q.setCacheable(true).list();
  11. assertTrue( list.size()==2 );
  12. t.commit();
  13. t = s.beginTransaction();
  14. q = s.createQuery("from Simple s");
  15. list = q.setCacheable(true).list();
  16. assertTrue( list.size()==2 );
  17. Iterator i = list.iterator();
  18. while ( i.hasNext() ) s.delete( i.next() );
  19. t.commit();
  20. s.close();

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

  1. Query query = s.createQuery("from HighestBid b where b.name = :name");
  2. query.setParameter( "name", "widget", StringType.INSTANCE );
  3. HighestBid highestBid = (HighestBid) query.list().iterator().next();

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

  1. protected List getCountedStudentGradeRecords(final Long gradebookId, final String studentId) throws HibernateException {
  2.   return getSessionFactory().getCurrentSession().createQuery(
  3.     "select agr from AssignmentGradeRecord as agr, GradebookAssignment as asn where agr.studentId = :studentid and agr.gradableObject = asn and asn.removed is false and asn.notCounted is false and asn.gradebook.id = :gradebookid and asn.ungraded is false")
  4.     .setString("studentid", studentId)
  5.     .setLong("gradebookid", gradebookId)
  6.     .list();
  7. }

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

  1. @Test
  2. public void test2ndLevelSubClass() throws Exception {
  3.   Session s = openSession();
  4.   Transaction tx = s.beginTransaction();
  5.   A320b a = new A320b();
  6.   a.setJavaEmbeddedVersion( "Elephant" );
  7.   a.setNbrOfSeats( 300 );
  8.   s.persist( a );
  9.   tx.commit();
  10.   s.close();
  11.   s = openSession();
  12.   tx = s.beginTransaction();
  13.   Query q = s.createQuery( "from " + A320.class.getName() + " as a where a.javaEmbeddedVersion = :version" );
  14.   q.setString( "version", "Elephant" );
  15.   List a320s = q.list();
  16.   assertNotNull( a320s );
  17.   assertEquals( 1, a320s.size() );
  18.   tx.commit();
  19.   s.close();
  20. }

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

  1. Query q = s.createQuery("from Simple s where s.name=?");
  2. q.setCacheable(true);
  3. q.setString(0, "Simple 1");
  4. assertTrue( q.list().size()==1 );
  5. assertTrue( q.list().size()==1 );
  6. assertTrue( q.list().size()==1 );
  7. q = s.createQuery("from Simple s where s.name=:name");
  8. q.setCacheable(true);
  9. q.setString("name", "Simple 1");
  10. assertTrue( q.list().size()==1 );
  11. simple = (Simple) q.list().get(0);
  12. q.setString("name", "Simple 2");
  13. assertTrue( q.list().size()==0 );
  14. assertTrue( q.list().size()==0 );
  15. simple.setName("Simple 2");
  16. assertTrue( q.list().size()==1 );
  17. assertTrue( q.list().size()==1 );
  18. t.commit();
  19. s.close();
  20. q = s.createQuery("from Simple s where s.name=:name");
  21. q.setString("name", "Simple 2");
  22. q.setCacheable(true);
  23. assertTrue( q.list().size()==1 );
  24. assertTrue( q.list().size()==1 );
  25. t.commit();
  26. s.close();

代码示例来源：origin: gocd/gocd

  1. public Modifications getModificationsFor(final MaterialInstance materialInstance, final Pagination pagination) {
  2.   String key = materialModificationsWithPaginationKey(materialInstance);
  3.   String subKey = materialModificationsWithPaginationSubKey(pagination);
  4.   Modifications modifications = (Modifications) goCache.get(key, subKey);
  5.   if (modifications == null) {
  6.     synchronized (key) {
  7.       modifications = (Modifications) goCache.get(key, subKey);
  8.       if (modifications == null) {
  9.         List<Modification> modificationsList = (List<Modification>) getHibernateTemplate().execute((HibernateCallback) session -> {
  10.           Query q = session.createQuery("FROM Modification WHERE materialId = ? ORDER BY id DESC");
  11.           q.setFirstResult(pagination.getOffset());
  12.           q.setMaxResults(pagination.getPageSize());
  13.           q.setLong(0, materialInstance.getId());
  14.           return q.list();
  15.         });
  16.         if (!modificationsList.isEmpty()) {
  17.           modifications = new Modifications(modificationsList);
  18.           goCache.put(key, subKey, modifications);
  19.         }
  20.       }
  21.     }
  22.   }
  23.   return modifications;
  24. }

代码示例来源：origin: org.jboss.dashboard-builder/dashboard-provider-core

  1. protected void txFragment(Session session) throws Exception {
  2.   FlushMode flushMode = session.getFlushMode();
  3.   session.setFlushMode(FlushMode.COMMIT);
  4.   StringBuffer sql = new StringBuffer();
  5.   sql.append("from ").append(DataProviderImpl.class.getName()).append(" as instance ");
  6.   sql.append("where instance.id = :id");
  7.   Query query = session.createQuery(sql.toString());
  8.   if (id != null) query.setLong("id", id.longValue());
  9.   query.setCacheable(true);
  10.   results.addAll(query.list());
  11.   session.setFlushMode(flushMode);
  12. }}.execute();
  13. if (results.size() > 0) return (DataProviderImpl) results.get(0);

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

  1. @SuppressWarnings("unchecked")
  2. public Set<PackageDependency> getPackageDependencies(String className) {
  3.  final Query query = getSession().getNamedQuery("getPackageDependencies");
  4.  query.setCacheable(true);
  5.  query.setString("className", className);
  6.  final List<PackageDependency> results = query.list();
  7.  if (results != null) {
  8.   return new HashSet<PackageDependency>(results);
  9.  }
  10.  return null;
  11. }

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

  1. queryWithCollection.setLong("id",  jboss.getId() );
  2. list = queryWithCollection.list();
  3. assertEquals(list.size(),1);

代码示例来源：origin: my2iu/Jinq

  1. List<Object> results = q.list();
  2.    if (results.size() > hints.automaticResultsPagingSize)
  3.    List<Object> results = q.list();
  4.    resultIterator = results.iterator();
  5. if (resultIterator.hasNext())
  6.   nextElement(reader.readResult(resultIterator.next()));

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

  1. s.save( bar2 );
  2. Query q = s.createQuery("select bar, b from Bar bar left join bar.baz baz left join baz.cascadingBars b where bar.name like 'Bar%'");
  3. list = q.list();
  4. if ( !(getDialect() instanceof SAPDBDialect) ) assertTrue( list.size()==2 );
  5. q = s.createQuery("select bar, b from Bar bar left join bar.baz baz left join baz.cascadingBars b where ( bar.name in (:nameList) or bar.name in (:nameList) ) and bar.string = :stringVal");
  6. HashSet nameList = new HashSet();
  7. nameList.add( "bar" );
  8. q.setParameterList( "nameList", nameList );
  9. q.setParameter( "stringVal", "a string" );
  10. list = q.list();
  11. if ( !(getDialect() instanceof SAPDBDialect) ) assertTrue( list.size()==2 );
  12. assertTrue( result != null );
  13. q = s.createQuery("select bar, b from Bar bar left join bar.baz baz left join baz.cascadingBars b where bar.name like :name and b.name like :name");
  14. q.setString( "name", "Bar%" );
  15. list = q.list();
  16. assertTrue( list.size()==1 );
  17. q = s.createQuery("select bar from Bar bar order by ((bar.x - :valueX)*(bar.x - :valueX))");
  18. q.setInteger( "valueX", bar.getX() + 1 );
  19. list = q.list();
  20. assertTrue( ((Bar) list.get( 0 )).getX() == bar.getX() );
  21. q.setInteger( "valueX", bar2.getX() + 1 );
  22. list = q.list();
  23. assertTrue( ((Bar)list.get(0)).getX() == bar2.getX());

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

  1. cOrig.getProxyOwner(),
  2.         cOrig.getNonLazyOwner(),
  3.         cOrig.getLazyDataPoints().iterator().next(),
  4.         cOrig.getNonLazyJoinDataPoints().iterator().next(),
  5.         cOrig.getNonLazySelectDataPoints().iterator().next()
  6. List list = s.createFilter( c.getLazyDataPoints(), "" )
  7.     .setMaxResults( 1 )
  8.     .list();
  9. assertEquals( 1, list.size() );
  10. assertFalse( s.isReadOnly( list.get( 0 ) ) );
  11. list = s.createFilter( c.getNonLazyJoinDataPoints(), "" )
  12.     .setMaxResults( 1 )
  13.     .list();
  14. assertEquals( 1, list.size() );
  15. assertFalse( s.isReadOnly( list.get( 0 ) ) );
  16. list = s.createFilter( c.getNonLazySelectDataPoints(), "" )
  17.     .setMaxResults( 1 )
  18.     .list();
  19. assertEquals( 1, list.size() );
  20. assertFalse( s.isReadOnly( list.get( 0 ) ) );

代码示例来源：origin: org.sakaiproject.edu-services.gradebook/gradebook-service-impl

  1. protected List getCountedStudentGradeRecords(Long gradebookId, String studentId) throws HibernateException {
  2.   return getSessionFactory().getCurrentSession().createQuery(
  3.     "select agr from AssignmentGradeRecord as agr, GradebookAssignment as asn where agr.studentId = :studentid and agr.gradableObject = asn and asn.removed is false and asn.notCounted is false and asn.gradebook.id = :gradebookid and asn.ungraded is false")
  4.     .setString("studentid", studentId)
  5.     .setLong("gradebookid", gradebookId)
  6.     .list();
  7. }

代码示例来源：origin: netgloo/spring-boot-samples

  1. @SuppressWarnings("unchecked")
  2. public List<User> getAll() {
  3.  return getSession().createQuery("from User").list();
  4. }

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

  1. /**
  2.  * Call setEntity() on a cacheable query - see FORGE-265
  3.  */
  4. public List listEventsOfOrganizer(Person organizer) {
  5.   Session session = sessionFactory.getCurrentSession();
  6.   session.beginTransaction();
  7.   Query query = session.createQuery("from Event ev where ev.organizer = :organizer");
  8.   query.setCacheable(true);
  9.   query.setEntity("organizer", organizer);
  10.   List result = query.list();
  11.   session.getTransaction().commit();
  12.   return result;
  13. }

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

  1. s = openSession();
  2. tx = s.beginTransaction();
  3. Query q = s.createQuery( "from Being h where h.identity = :name1 or h.identity = :name2" );
  4. q.setString("name1", "marc");
  5. q.setString("name2", "steve");
  6. final List result = q.list();
  7. assertEquals( 2, result.size() );
  8. s.delete( result.get(0) );

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

query

相关文章

    查看更多

    热门标签

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

    最新文章

    更多

    Query类方法

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