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

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

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

Query.getResultList介绍

暂无

代码示例

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

  1. /**
  2.  * Get the results of a {@link CriteriaQuery} query.
  3.  *
  4.  * @param criteria the {@link CriteriaQuery} query to run
  5.  * @return the list of matched query results
  6.  */
  7. protected List<E> list(CriteriaQuery<E> criteria) throws HibernateException {
  8.   return currentSession().createQuery(requireNonNull(criteria)).getResultList();
  9. }

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

  1. /**
  2.  * Convenience method to return a single instance that matches the criteria query,
  3.  * or null if the criteria returns no results.
  4.  *
  5.  * @param criteriaQuery the {@link CriteriaQuery} query to run
  6.  * @return the single result or {@code null}
  7.  * @throws HibernateException if there is more than one matching result
  8.  */
  9. protected E uniqueResult(CriteriaQuery<E> criteriaQuery) throws HibernateException {
  10.   return AbstractProducedQuery.uniqueElement(
  11.     currentSession()
  12.       .createQuery(requireNonNull(criteriaQuery))
  13.       .getResultList()
  14.   );
  15. }

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

  1. @Test
  2. public void testQueryingSingle() {
  3.   doInHibernate( this::sessionFactory, s -> {
  4.     final String base = "from PolymorphicPropertyBase p left join ";
  5.     s.createQuery( base + "p.base b left join b.relation1 " ).getResultList();
  6.     s.createQuery( base + "p.base b left join b.relation2 " ).getResultList();
  7.     s.createQuery( base + "p.baseEmbeddable.embeddedRelation1 b left join b.relation1" ).getResultList();
  8.     s.createQuery( base + "p.baseEmbeddable.embeddedRelation2 b left join b.relation2" ).getResultList();
  9.     s.createQuery( base + "p.baseEmbeddable.embeddedBase b left join b.relation1" ).getResultList();
  10.     s.createQuery( base + "p.baseEmbeddable.embeddedBase b left join b.relation2" ).getResultList();
  11.   } );
  12. }

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

  1. @Test
  2. public void testQueryingMultiple() {
  3.   doInHibernate( this::sessionFactory, s -> {
  4.     final String base = "from PolymorphicPropertyBase p left join ";
  5.     s.createQuery( base + "p.base b left join b.relation1 left join b.relation2" ).getResultList();
  6.     s.createQuery( base + "p.base b left join b.relation2 left join b.relation1" ).getResultList();
  7.     s.createQuery( base + "p.baseEmbeddable.embeddedBase b left join b.relation1 left join b.relation2" ).getResultList();
  8.     s.createQuery( base + "p.baseEmbeddable.embeddedBase b left join b.relation2 left join b.relation1" ).getResultList();
  9.   } );
  10. }

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

  1. @Test
  2. @SuppressWarnings({ "unchecked", "rawtypes" })
  3. public void testCurrentSession() {
  4.   String firstName = "Tony";
  5.   insertPerson(firstName);
  6.   Query q = sessionFactory.getCurrentSession().createQuery("select p from Person as p");
  7.   List<Person> people = q.getResultList();
  8.   assertEquals(1, people.size());
  9.   assertEquals(firstName, people.get(0).getFirstName());
  10.   assertSame(applicationContext, people.get(0).postLoaded);
  11. }

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

  1. @Test
  2. public void testSelect() {
  3.   doInHibernate( this::sessionFactory, session -> {
  4.     session.createQuery(
  5.       "select a.id " +
  6.       "from A a " +
  7.       "where exists (" +
  8.       "	select 1 " +
  9.       "	from B b " +
  10.       "	where b.id = a.id" +
  11.       ")"
  12.     )
  13.     .getResultList();
  14.   } );
  15. }

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

  1. @Test
  2. public void testOneToOneLazyLoading() {
  3.   doInHibernate( this::sessionFactory, s -> {
  4.     PostDetails post = (PostDetails) s.createQuery("select a from PostDetails a").getResultList().get(0);
  5.     assertFalse(isInitialized(post.post));
  6.   } );
  7. }

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

  1. @Test
  2. public void testPessimisticLockWithUnionThenFollowOnLocking() {
  3.   final Session session = openSession();
  4.   session.beginTransaction();
  5.   sqlStatementInterceptor.getSqlQueries().clear();
  6.   List<Vehicle> vehicles = session.createQuery( "select v from Vehicle v" )
  7.     .setLockOptions( new LockOptions( LockMode.PESSIMISTIC_WRITE ) )
  8.     .getResultList();
  9.   assertEquals( 3, vehicles.size() );
  10.   assertEquals( 4, sqlStatementInterceptor.getSqlQueries().size() );
  11.   session.getTransaction().commit();
  12.   session.close();
  13. }

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

  1. @Test
  2. public void test() {
  3.   doInHibernate( this::sessionFactory, session -> {
  4.     List<CorporateUser> users = session.createQuery(
  5.       "select u from CorporateUser u where u.emailAddresses = :address", CorporateUser.class )
  6.     .setParameter( "address", new Array(), ArrayType.INSTANCE )
  7.     .getResultList();
  8.     assertTrue( users.isEmpty() );
  9.   } );
  10. }

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

  1. @Test
  2. public void testPessimisticLockWithNamedQueryExplicitlyEnablingFollowOnLockingThenFollowOnLocking() {
  3.   final Session session = openSession();
  4.   session.beginTransaction();
  5.   sqlStatementInterceptor.getSqlQueries().clear();
  6.   List<Product> products = session.createNamedQuery(
  7.     "product_by_name", Product.class )
  8.   .getResultList();
  9.   assertEquals( 50, products.size() );
  10.   assertEquals( 51, sqlStatementInterceptor.getSqlQueries().size() );
  11.   session.getTransaction().commit();
  12.   session.close();
  13. }

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

  1. @Test
  2. public void testMakeEnvelope() {
  3.   Long addressId = insertEvent( c( 10, 5 ) );
  4.   doInHibernate( this::sessionFactory, session -> {
  5.     List<Event> events = session.createQuery(
  6.         "select e " +
  7.             "from Event e " +
  8.             "where within(e.location, makeenvelope(0, 0, 11, 11, -1 )) = true", Event.class )
  9.         .getResultList();
  10.     assertEquals( 1, events.size() );
  11.   } );
  12. }

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

  1. @Test
  2. public void testPessimisticLockWithCountDistinctThenFollowOnLocking() {
  3.   final Session session = openSession();
  4.   session.beginTransaction();
  5.   sqlStatementInterceptor.getSqlQueries().clear();
  6.   List<Product> products = session.createQuery(
  7.     "select p from Product p where ( select count(distinct p1.id) from Product p1 ) > 0 ", Product.class )
  8.   .setLockOptions( new LockOptions( LockMode.PESSIMISTIC_WRITE ).setFollowOnLocking( false ) )
  9.   .getResultList();
  10.   assertEquals( 50, products.size() );
  11.   assertEquals( 1, sqlStatementInterceptor.getSqlQueries().size() );
  12.   session.getTransaction().commit();
  13.   session.close();
  14. }

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

  1. @Test
  2. public void testPessimisticLockWithMaxResultsThenNoFollowOnLocking() {
  3.   final Session session = openSession();
  4.   session.beginTransaction();
  5.   sqlStatementInterceptor.getSqlQueries().clear();
  6.   List<Product> products =
  7.       session.createQuery(
  8.           "select p from Product p", Product.class )
  9.           .setLockOptions( new LockOptions( LockMode.PESSIMISTIC_WRITE ) )
  10.           .setMaxResults( 10 )
  11.           .getResultList();
  12.   assertEquals( 10, products.size() );
  13.   assertEquals( 1, sqlStatementInterceptor.getSqlQueries().size() );
  14.   session.getTransaction().commit();
  15.   session.close();
  16. }

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

  1. @Test
  2. public void testPessimisticLockWithMaxResultsAndOrderByThenFollowOnLocking() {
  3.   final Session session = openSession();
  4.   session.beginTransaction();
  5.   sqlStatementInterceptor.getSqlQueries().clear();
  6.   List<Product> products =
  7.       session.createQuery(
  8.           "select p from Product p order by p.id", Product.class )
  9.           .setLockOptions( new LockOptions( LockMode.PESSIMISTIC_WRITE ) )
  10.           .setMaxResults( 10 )
  11.           .getResultList();
  12.   assertEquals( 10, products.size() );
  13.   assertEquals( 11, sqlStatementInterceptor.getSqlQueries().size() );
  14.   session.getTransaction().commit();
  15.   session.close();
  16. }

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

  1. @Test
  2. public void testStoredProcedureOutParameter() {
  3.   doInHibernate( this::sessionFactory, session -> {
  4.     List<Object[]> persons = session
  5.         .createNamedQuery(
  6.             "getPerson")
  7.         .setParameter(1, 1L)
  8.         .getResultList();
  9.     assertEquals(1, persons.size());
  10.   } );
  11. }

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

  1. @Test
  2. public void testBuffer() {
  3.   Long addressId = insertEvent( c( 10, 5 ) );
  4.   doInHibernate( this::sessionFactory, session -> {
  5.     List<Event> events = session.createQuery(
  6.         "select e " +
  7.             "from Event e " +
  8.             "where within( e.location, buffer(:window, 100)) = true", Event.class )
  9.         .setParameter( "window", window )
  10.         .getResultList();
  11.     assertEquals( 1, events.size() );
  12.   } );
  13. }

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

  1. @Test
  2. public void HHH_10463_TestCoalesce() {
  3.   doInHibernate( this::sessionFactory, session -> {
  4.     Query query = session.createQuery( "from Person p where p.name = coalesce(:name , p.name) ");
  5.     query.setParameter("name", "Johannes");
  6.     List<Person> resultList = query.getResultList();
  7.     assertThat(resultList, hasItem(person));
  8.   } );
  9. }

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

  1. @Test
  2. @TestForIssue( jiraKey = "HHH-11726" )
  3. public void testDistinctPassThroughFalse() {
  4.   doInHibernate( this::sessionFactory, session -> {
  5.     sqlStatementInterceptor.getSqlQueries().clear();
  6.     List<Person> persons = session.createQuery(
  7.         "select distinct p from Person p left join fetch p.phones ")
  8.         .setHint(QueryHints.HINT_PASS_DISTINCT_THROUGH, false)
  9.         .setMaxResults(5)
  10.         .getResultList();
  11.     assertEquals(1, persons.size());
  12.     String sqlQuery = sqlStatementInterceptor.getSqlQueries().getLast();
  13.     assertFalse(sqlQuery.contains(" distinct "));
  14.   });
  15. }

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

  1. @Test
  2. @RequiresDialect( PostgreSQL81Dialect.class )
  3. public void HHH_10463_NullInCoalesce_PostgreSQL_Workaround() {
  4.   doInHibernate( this::sessionFactory, session -> {
  5.     Query query = session.createQuery("from Person p where p.name = coalesce(cast( :name as string) , p.name) ");
  6.     query.setParameter("name", null);
  7.     List<Person> resultList = query.getResultList();
  8.     assertThat(resultList, hasItem(person));
  9.   } );
  10. }

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

  1. @Test
  2. @SkipForDialect( jiraKey = "HHH-10463", value =  PostgreSQL81Dialect.class)
  3. @SkipForDialect( jiraKey = "HHH-10463", value =  Oracle8iDialect.class)
  4. public void HHH_10463_NullInCoalesce() {
  5.   doInHibernate( this::sessionFactory, session -> {
  6.     Query query = session.createQuery("from Person p where p.name = coalesce(:name, p.name) ");
  7.     query.setParameter("name", null);
  8.     List<Person> resultList = query.getResultList();
  9.     assertThat(resultList, hasItem(person));
  10.   } );
  11. }

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

query

相关文章

    查看更多

    热门标签

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

    最新文章

    更多

    Query类方法

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