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

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

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

Query.getSingleResult介绍

暂无

代码示例

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

  1. @Override
  2. public Person findByName(String name) {
  3.   return (Person) this.sessionFactory.getCurrentSession().createQuery(
  4.     "from Person person where person.name = :name").setParameter("name", name).getSingleResult();
  5. }

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

  1. @Before
  2. public void prepare() {
  3.   final Session s = openSession();
  4.   final Transaction t = s.beginTransaction();
  5.   try {
  6.     final Number count = (Number) s.createQuery("SELECT count(ID) FROM SimpleEntity").getSingleResult();
  7.     if (count.longValue() > 0L) {
  8.       // entity already added previously
  9.       return;
  10.     }
  11.     final Map<String, Object> entity = new HashMap<>();
  12.     entity.put( "id", 1L );
  13.     entity.put( "name", "TheParent" );
  14.     final Map<String, Object> c1 = new HashMap<>();
  15.     c1.put( "id", 1L );
  16.     c1.put( "parent", entity );
  17.     s.save( "SimpleEntity", entity );
  18.     s.save( "ChildEntity", c1 );
  19.   }
  20.   finally {
  21.     t.commit();
  22.     s.close();
  23.   }
  24. }

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

  1. @Test(expected = PersistenceException.class)
  2. @TestForIssue(jiraKey = "HHH-12132")
  3. public void testLegacyBooleanType() throws Exception {
  4.   rebuildSessionFactory( configuration -> {
  5.     configuration.setProperty( "hibernate.dialect.hana.use_legacy_boolean_type", Boolean.FALSE.toString() );
  6.   } );
  7.   Session s = openSession();
  8.   s.beginTransaction();
  9.   LegacyBooleanEntity legacyEntity = new LegacyBooleanEntity();
  10.   legacyEntity.key = Integer.valueOf( 2 );
  11.   legacyEntity.bool = Boolean.FALSE;
  12.   s.persist( legacyEntity );
  13.   s.flush();
  14.   s.getTransaction().commit();
  15.   s.clear();
  16.   Query<LegacyBooleanEntity> query = s.createQuery( "select b from " + LEGACY_ENTITY_NAME + " b where bool = true", LegacyBooleanEntity.class );
  17.   query.getSingleResult();
  18. }

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

  1. @Test(expected = PersistenceException.class)
  2. @TestForIssue(jiraKey = "HHH-12132")
  3. public void testBooleanTypeLegacyBehavior() throws Exception {
  4.   rebuildSessionFactory( configuration -> {
  5.     configuration.setProperty( "hibernate.dialect.hana.use_legacy_boolean_type", Boolean.TRUE.toString() );
  6.   } );
  7.   Session s = openSession();
  8.   s.beginTransaction();
  9.   BooleanEntity entity = new BooleanEntity();
  10.   entity.key = Integer.valueOf( 2 );
  11.   entity.bool = Boolean.FALSE;
  12.   s.persist( entity );
  13.   s.flush();
  14.   s.getTransaction().commit();
  15.   s.clear();
  16.   Query<BooleanEntity> query = s.createQuery( "select b from " + ENTITY_NAME + " b where bool = true", BooleanEntity.class );
  17.   query.getSingleResult();
  18. }

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

  1. @Test
  2. @TestForIssue(jiraKey = "HHH-12132")
  3. public void testLegacyBooleanTypeLegacyBehavior() throws Exception {
  4.   rebuildSessionFactory( configuration -> {
  5.     configuration.setProperty( "hibernate.dialect.hana.use_legacy_boolean_type", Boolean.TRUE.toString() );
  6.   } );
  7.   Session s = openSession();
  8.   s.beginTransaction();
  9.   LegacyBooleanEntity legacyEntity = new LegacyBooleanEntity();
  10.   legacyEntity.key = Integer.valueOf( 1 );
  11.   legacyEntity.bool = Boolean.TRUE;
  12.   s.persist( legacyEntity );
  13.   s.flush();
  14.   s.getTransaction().commit();
  15.   s.clear();
  16.   Query<LegacyBooleanEntity> legacyQuery = s.createQuery( "select b from " + LEGACY_ENTITY_NAME + " b where bool = true", LegacyBooleanEntity.class );
  17.   LegacyBooleanEntity retrievedEntity = legacyQuery.getSingleResult();
  18.   assertEquals( Integer.valueOf( 1 ), retrievedEntity.key );
  19.   assertTrue( retrievedEntity.bool );
  20. }

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

  1. @Test
  2. @TestForIssue(jiraKey = "HHH-12132")
  3. public void testBooleanTypeDefaultBehavior() throws Exception {
  4.   rebuildSessionFactory();
  5.   Session s = openSession();
  6.   s.beginTransaction();
  7.   BooleanEntity entity = new BooleanEntity();
  8.   entity.key = Integer.valueOf( 1 );
  9.   entity.bool = Boolean.TRUE;
  10.   s.persist( entity );
  11.   s.flush();
  12.   s.getTransaction().commit();
  13.   s.clear();
  14.   Query<BooleanEntity> legacyQuery = s.createQuery( "select b from " + ENTITY_NAME + " b where bool = true", BooleanEntity.class );
  15.   BooleanEntity retrievedEntity = legacyQuery.getSingleResult();
  16.   assertEquals( Integer.valueOf( 1 ), retrievedEntity.key );
  17.   assertTrue( retrievedEntity.bool );
  18. }

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

  1. @Test
  2. @TestForIssue(jiraKey = "HHH-12132")
  3. public void testBooleanType() throws Exception {
  4.   rebuildSessionFactory( configuration -> {
  5.     configuration.setProperty( "hibernate.dialect.hana.use_legacy_boolean_type", Boolean.FALSE.toString() );
  6.   } );
  7.   Session s = openSession();
  8.   s.beginTransaction();
  9.   BooleanEntity entity = new BooleanEntity();
  10.   entity.key = Integer.valueOf( 1 );
  11.   entity.bool = Boolean.TRUE;
  12.   s.persist( entity );
  13.   s.flush();
  14.   s.getTransaction().commit();
  15.   s.clear();
  16.   Query<BooleanEntity> legacyQuery = s.createQuery( "select b from " + ENTITY_NAME + " b where bool = true", BooleanEntity.class );
  17.   BooleanEntity retrievedEntity = legacyQuery.getSingleResult();
  18.   assertEquals( Integer.valueOf( 1 ), retrievedEntity.key );
  19.   assertTrue( retrievedEntity.bool );
  20. }

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

  1. final Number count = (Number) s.createQuery("SELECT count(ID) FROM SimpleEntity").getSingleResult();
  2. if (count.longValue() > 0L) {

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

  1. @Test
  2. public void testPolymorphicAssociation() {
  3.   doInHibernate( this::sessionFactory, session1 -> {
  4.     Family family = session1.createQuery( "FROM Family f", Family.class ).getSingleResult();
  5.     List<Person> members = family.getMembers();
  6.     assertThat( members.size(), is( familyMembers.size() ) );
  7.     for ( Person person : members ) {
  8.       if ( person instanceof Man ) {
  9.         assertThat( ( (Man) person ).getHobby(), is( john.getHobby() ) );
  10.       }
  11.       else if ( person instanceof Woman ) {
  12.         assertThat( ( (Woman) person ).getJob(), is( jane.getJob() ) );
  13.       }
  14.       else if ( person instanceof Child ) {
  15.         if ( person.getName().equals( "Susan" ) ) {
  16.           assertThat( ( (Child) person ).getFavouriteToy(), is( susan.getFavouriteToy() ) );
  17.         }
  18.         else {
  19.           assertThat( ( (Child) person ).getFavouriteToy(), is( mark.getFavouriteToy() ) );
  20.         }
  21.       }
  22.       else {
  23.         fail( "Unexpected result: " + person );
  24.       }
  25.     }
  26.   } );
  27. }

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

  1. "select pa from PersonAddress pa where pa.person = :person", PersonAddress.class )
  2. .setParameter( "person", person )
  3. .getSingleResult();

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

  1. @Test
  2. public void test() {
  3.   final DateEvent _dateEvent = doInJPA( this::entityManagerFactory, entityManager -> {
  4.     DateEvent dateEvent = new DateEvent();
  5.     dateEvent.setCreatedOn( Instant.from( DateTimeFormatter.ISO_INSTANT.parse( "2016-10-13T06:40:18.745Z" ) ) );
  6.     entityManager.persist( dateEvent );
  7.     return dateEvent;
  8.   } );
  9.   doInJPA( this::entityManagerFactory, entityManager -> {
  10.     DateEvent dateEvent = entityManager.unwrap( Session.class )
  11.     .createQuery(
  12.       "select de " +
  13.       "from DateEvent de " +
  14.       "where de.createdOn = '2016-10-13T06:40:18.745Z' ", DateEvent.class )
  15.     .getSingleResult();
  16.     assertNotNull(dateEvent);
  17.     assertEquals(_dateEvent.getId(), dateEvent.getId());
  18.   } );
  19.   doInJPA( this::entityManagerFactory, entityManager -> {
  20.     DateEvent dateEvent = entityManager.unwrap( Session.class )
  21.     .createQuery(
  22.       "select de " +
  23.       "from DateEvent de " +
  24.       "where de.createdOn = :createdOn ", DateEvent.class )
  25.     .setParameter( "createdOn", Instant.from( DateTimeFormatter.ISO_INSTANT.parse( "2016-10-13T06:40:18.745Z" ) ) )
  26.     .getSingleResult();
  27.     assertNotNull(dateEvent);
  28.     assertEquals(_dateEvent.getId(), dateEvent.getId());
  29.   } );
  30. }

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

  1. @Test
  2. public void testJPQLUpperAttributeValueBindParameterType() throws Exception {
  3.   doInJPA( this::entityManagerFactory, entityManager -> {
  4.     //tag::basic-attribute-converter-query-parameter-converter-object-example[]
  5.     SessionFactory sessionFactory = entityManager.getEntityManagerFactory()
  6.         .unwrap( SessionFactory.class );
  7.     MetamodelImplementor metamodelImplementor = (MetamodelImplementor) sessionFactory.getMetamodel();
  8.     Type captionType = metamodelImplementor
  9.         .entityPersister( Photo.class.getName() )
  10.         .getPropertyType( "caption" );
  11.     Photo photo = (Photo) entityManager.createQuery(
  12.       "select p " +
  13.       "from Photo p " +
  14.       "where upper(caption) = upper(:caption) ", Photo.class )
  15.     .unwrap( Query.class )
  16.     .setParameter( "caption", new Caption("Nicolae Grigorescu"), captionType)
  17.     .getSingleResult();
  18.     //end::basic-attribute-converter-query-parameter-converter-object-example[]
  19.     assertEquals( "Dorobantul", photo.getName() );
  20.   } );
  21. }

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

  1. "JOIN parent.string s " +
  2.         "JOIN FETCH s.map", MultilingualString.class )
  3.     .getSingleResult();
  4. assertEquals( 2, m.getMap().size() );
  5. localizedString = m.getMap().get( "English" );

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

  1. @Test
  2. public void testFetchEager() {
  3.   doInHibernate( this::sessionFactory, s -> {
  4.     PropertySet set = new PropertySet( "string" );
  5.     Property property = new StringProperty( "name", "Alex" );
  6.     set.setSomeProperty( property );
  7.     s.save( set );
  8.   } );
  9.   PropertySet result = doInHibernate( this::sessionFactory, s -> {
  10.     return s.createQuery( "select s from PropertySet s where name = :name", PropertySet.class )
  11.         .setParameter( "name", "string" )
  12.         .getSingleResult();
  13.   } );
  14.   assertNotNull( result );
  15.   assertNotNull( result.getSomeProperty() );
  16.   assertTrue( result.getSomeProperty() instanceof StringProperty );
  17.   assertEquals( "Alex", result.getSomeProperty().asString() );
  18. }

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

  1. checkResult( session.createQuery( "from Person p", Person.class ).getSingleResult() );
  2. });

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

  1. @Test
  2. @TestForIssue(jiraKey = "HHH-12978")
  3. public void testEnumAsBindParameterAndExtract() {
  4.   doInHibernate( this::sessionFactory, s -> {
  5.     binderTriggerable.reset();
  6.     extractorTriggerable.reset();
  7.     s.createQuery( "select p.id from Person p where p.id = :id", Long.class )
  8.         .setParameter( "id", person.getId() )
  9.         .getSingleResult();
  10.     assertTrue( binderTriggerable.wasTriggered() );
  11.     assertTrue( extractorTriggerable.wasTriggered() );
  12.   } );
  13.   doInHibernate( this::sessionFactory, s -> {
  14.     binderTriggerable.reset();
  15.     extractorTriggerable.reset();
  16.     s.createQuery(
  17.         "select p.gender from Person p where p.gender = :gender and p.hairColor = :hairColor",
  18.         Gender.class
  19.     )
  20.         .setParameter( "gender", Gender.MALE )
  21.         .setParameter( "hairColor", HairColor.BROWN )
  22.         .getSingleResult();
  23.     assertTrue( binderTriggerable.wasTriggered() );
  24.     assertTrue( extractorTriggerable.wasTriggered() );
  25.   } );
  26. }

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

  1. .getSingleResult();
  2. .getSingleResult();

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

  1. simple = session.createQuery( "FROM Simple", Simple.class ).getSingleResult();
  2. session.getTransaction().commit();

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

  1. @Test
  2. public void testFetchLazy() {
  3.   doInHibernate( this::sessionFactory, s -> {
  4.     LazyPropertySet set = new LazyPropertySet( "string" );
  5.     Property property = new StringProperty( "name", "Alex" );
  6.     set.setSomeProperty( property );
  7.     s.save( set );
  8.   } );
  9.   LazyPropertySet result = doInHibernate( this::sessionFactory, s -> {
  10.     return s.createQuery( "select s from LazyPropertySet s where name = :name", LazyPropertySet.class )
  11.         .setParameter( "name", "string" )
  12.         .getSingleResult();
  13.   } );
  14.   assertNotNull( result );
  15.   assertNotNull( result.getSomeProperty() );
  16.   try {
  17.     result.getSomeProperty().asString();
  18.     fail( "should not get the property string after session closed." );
  19.   }
  20.   catch (LazyInitializationException e) {
  21.     // expected
  22.   }
  23.   catch (Exception e) {
  24.     fail( "should not throw exception other than LazyInitializationException." );
  25.   }
  26. }

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

  1. @Test
  2. public void testFetchLazy() {
  3.   doInHibernate( this::sessionFactory, s -> {
  4.     LazyPropertySet set = new LazyPropertySet( "string" );
  5.     Property property = new StringProperty( "name", "Alex" );
  6.     set.setSomeProperty( property );
  7.     s.save( set );
  8.   } );
  9.   LazyPropertySet result = doInHibernate( this::sessionFactory, s -> {
  10.     return s.createQuery( "select s from LazyPropertySet s where name = :name", LazyPropertySet.class )
  11.         .setParameter( "name", "string" )
  12.         .getSingleResult();
  13.   } );
  14.   assertNotNull( result );
  15.   assertNotNull( result.getSomeProperty() );
  16.   try {
  17.     result.getSomeProperty().asString();
  18.     fail( "should not get the property string after session closed." );
  19.   }
  20.   catch (LazyInitializationException e) {
  21.     // expected
  22.   }
  23.   catch (Exception e) {
  24.     fail( "should not throw exception other than LazyInitializationException." );
  25.   }
  26. }

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

query

相关文章

    查看更多

    热门标签

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

    最新文章

    更多

    Query类方法

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