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

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

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

Query.setLong介绍

[英]Bind a positional long-valued parameter.
[中]绑定位置长值参数。

代码示例

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

  1. @Test
  2. public void shouldRetrieveSubSubEntityWithHQL() {
  3.   session = openSession();
  4.   try {
  5.     SubSubEntity loaded = (SubSubEntity) session.createQuery(
  6.         "select se from SubSubEntity se where se.id = :id" )
  7.         .setLong( "id", subSubEntityId )
  8.         .uniqueResult();
  9.     assertNotNull( loaded );
  10.   }
  11.   finally {
  12.     session.close();
  13.   }
  14. }

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

  1. @Test
  2. public void shouldNotRetrieveSubSubSubEntityWithHQL() {
  3.   session = openSession();
  4.   try {
  5.     SubSubSubEntity loaded = (SubSubSubEntity) session.createQuery(
  6.         "select se from SubSubSubEntity se where se.id = :id" )
  7.         .setLong( "id", subSubEntityId )
  8.         .uniqueResult();
  9.     assertNull( loaded );
  10.   }
  11.   finally {
  12.     session.close();
  13.   }
  14. }

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

  1. Session s = openSession();
  2. s.beginTransaction();
  3. s.createQuery( "from Animal a where abs(a.bodyWeight-:param) < 2.0" ).setLong( "param", 1 ).list();
  4. s.createQuery( "from Animal a where abs(:param - a.bodyWeight) < 2.0" ).setLong( "param", 1 ).list();
  5. if ( ( getDialect() instanceof HSQLDialect ) || ( getDialect() instanceof DB2Dialect ) ) {
  6.   s.createQuery( "from Animal where abs(cast(:x as long) - :y) < 2.0" ).setLong( "x", 1 ).setLong( "y", 1 ).list();
  7.   s.createQuery( "from Animal where abs(:x - cast(:y as long)) < 2.0" ).setLong( "x", 1 ).setLong( "y", 1 ).list();
  8.   s.createQuery( "from Animal where abs(cast(:x as long) - cast(:y as long)) < 2.0" ).setLong( "x", 1 ).setLong( "y", 1 ).list();
  9.   s.createQuery( "from Animal where abs(:x - :y) < 2.0" ).setLong( "x", 1 ).setLong( "y", 1 ).list();
  10.   s.createQuery( "from Animal where lower(upper(:foo)) like 'f%'" ).setString( "foo", "foo" ).list();
  11. s.createQuery( "from Animal a where abs(abs(a.bodyWeight - 1.0 + :param) * abs(length('ffobar')-3)) = 3.0" ).setLong(
  12.     "param", 1
  13. ).list();
  14.       .setLong( "param", 1 ).list();
  15.       .setLong( "param", 1 ).list();

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

  1. @Test
  2. public void testUpdateOnComponent() {
  3.   Session s = openSession();
  4.   Transaction t = s.beginTransaction();
  5.   Human human = new Human();
  6.   human.setName( new Name( "Stevee", 'X', "Ebersole" ) );
  7.   s.save( human );
  8.   s.flush();
  9.   t.commit();
  10.   String correctName = "Steve";
  11.   t = s.beginTransaction();
  12.   int count = s.createQuery( "update Human set name.first = :correction where id = :id" )
  13.       .setString( "correction", correctName )
  14.       .setLong( "id", human.getId().longValue() )
  15.       .executeUpdate();
  16.   assertEquals( "Incorrect update count", 1, count );
  17.   t.commit();
  18.   t = s.beginTransaction();
  19.   s.refresh( human );
  20.   assertEquals( "Update did not execute properly", correctName, human.getName().getFirst() );
  21.   s.createQuery( "delete Human" ).executeUpdate();
  22.   t.commit();
  23.   s.close();
  24. }

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

  1. @Test
  2. public void testUpdateOnDiscriminatorSubclass() {
  3.   TestData data = new TestData();
  4.   data.prepare();
  5.   Session s = openSession();
  6.   Transaction t = s.beginTransaction();
  7.   int count = s.createQuery( "update PettingZoo set name = name" ).executeUpdate();
  8.   assertEquals( "Incorrect discrim subclass update count", 1, count );
  9.   t.rollback();
  10.   t = s.beginTransaction();
  11.   count = s.createQuery( "update PettingZoo pz set pz.name = pz.name where pz.id = :id" )
  12.       .setLong( "id", data.pettingZoo.getId().longValue() )
  13.       .executeUpdate();
  14.   assertEquals( "Incorrect discrim subclass update count", 1, count );
  15.   t.rollback();
  16.   t = s.beginTransaction();
  17.   count = s.createQuery( "update Zoo as z set z.name = z.name" ).executeUpdate();
  18.   assertEquals( "Incorrect discrim subclass update count", 2, count );
  19.   t.rollback();
  20.   t = s.beginTransaction();
  21.   // TODO : not so sure this should be allowed.  Seems to me that if they specify an alias,
  22.   // property-refs should be required to be qualified.
  23.   count = s.createQuery( "update Zoo as z set name = name where id = :id" )
  24.       .setLong( "id", data.zoo.getId().longValue() )
  25.       .executeUpdate();
  26.   assertEquals( "Incorrect discrim subclass update count", 1, count );
  27.   t.commit();
  28.   s.close();
  29.   data.cleanup();
  30. }

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

  1. t = s.beginTransaction();
  2. IntegerVersioned created = ( IntegerVersioned ) s.createQuery( "from IntegerVersioned where id <> :initialId" )
  3.     .setLong( "initialId", initialId.longValue() )
  4.     .uniqueResult();
  5. t.commit();

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

  1. t = s.beginTransaction();
  2. TimestampVersioned created = ( TimestampVersioned ) s.createQuery( "from TimestampVersioned where id <> :initialId" )
  3.     .setLong( "initialId", initialId.longValue() )
  4.     .uniqueResult();
  5. t.commit();

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

  1. @Test
  2. @RequiresDialectFeature(
  3.     value = DialectChecks.HasSelfReferentialForeignKeyBugCheck.class,
  4.     comment = "self referential FK bug"
  5. )
  6. public void testSimpleDeleteOnAnimal() {
  7.   TestData data = new TestData();
  8.   data.prepare();
  9.   Session s = openSession();
  10.   Transaction t = s.beginTransaction();
  11.   int count = s.createQuery( "delete from Animal as a where a.id = :id" )
  12.       .setLong( "id", data.polliwog.getId().longValue() )
  13.       .executeUpdate();
  14.   assertEquals( "Incorrect delete count", 1, count );
  15.   count = s.createQuery( "delete Animal where id = :id" )
  16.       .setLong( "id", data.catepillar.getId().longValue() )
  17.       .executeUpdate();
  18.   assertEquals( "incorrect delete count", 1, count );
  19.   if ( getDialect().supportsSubqueryOnMutatingTable() ) {
  20.     count = s.createQuery( "delete from User u where u not in (select u from User u)" ).executeUpdate();
  21.     assertEquals( 0, count );
  22.   }
  23.   count = s.createQuery( "delete Animal a" ).executeUpdate();
  24.   assertEquals( "Incorrect delete count", 4, count );
  25.   List list = s.createQuery( "select a from Animal as a" ).list();
  26.   assertTrue( "table not empty", list.isEmpty() );
  27.   t.commit();
  28.   s.close();
  29.   data.cleanup();
  30. }

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

  1. .setLong( "last", lastContainerId.longValue() )
  2.     .list();
  3. Container container = ( Container ) all.get( 0 );

代码示例来源：origin: com.atlassian.hibernate/hibernate.adapter

  1. @Override
  2. @SuppressWarnings("deprecation")
  3. public Query setLong(final String name, final long val) {
  4.   if (queryV2ForCompare != null) {
  5.     queryV2ForCompare.setLong(name, val);
  6.   }
  7.   query.setLong(name, val);
  8.   return this;
  9. }

代码示例来源：origin: com.atlassian.crowd/crowd-persistence-hibernate5

  1. @Override
  2. @SuppressWarnings("unchecked")
  3. public DirectoryMapping findDirectoryMapping(long applicationId, long directoryId) throws DirectoryMappingNotFoundException {
  4.   final Optional<DirectoryMapping> maybeDirectoryMapping = session().getNamedQuery("findDirectoryMapping")
  5.       .setLong("applicationId", applicationId)
  6.       .setLong("directoryId", directoryId)
  7.       .uniqueResultOptional();
  8.   return maybeDirectoryMapping.orElseThrow(() -> new DirectoryMappingNotFoundException(applicationId, directoryId));
  9. }

代码示例来源：origin: com.atlassian.crowd/crowd-persistence-hibernate5

  1. public void removeAllRelationships(long directoryId) {
  2.   session().getNamedQuery("removeAllRelationships")
  3.       .setLong("directoryId", directoryId)
  4.       .executeUpdate();
  5. }

代码示例来源：origin: com.atlassian.crowd/crowd-persistence-hibernate5

  1. public void removeAll(long directoryId) {
  2.   // remove all relationships
  3.   membershipDao.removeAllRelationships(directoryId);
  4.   // remove all group attributes and groups
  5.   session().getNamedQuery("removeAllInternalGroupAttributesInDirectory")
  6.       .setLong("directoryId", directoryId)
  7.       .executeUpdate();
  8.   session().getNamedQuery("removeAllGroupsInDirectory")
  9.       .setLong("directoryId", directoryId)
  10.       .executeUpdate();
  11. }

代码示例来源：origin: com.atlassian.crowd/crowd-persistence-hibernate5

  1. @Override
  2. public void remove(final long directoryId, final String name) {
  3.   session().getNamedQuery("removeTokensByDirectoryAndName")
  4.       .setLong("directoryId", directoryId)
  5.       .setString("name", name)
  6.       .executeUpdate();
  7.   session().flush();
  8. }

代码示例来源：origin: com.atlassian.crowd/crowd-persistence-hibernate5

  1. @Override
  2. public boolean removeByDirectoryAndUsername(long directoryId, String username) {
  3.   final int numDeleted = session().getNamedQuery("removeExpirableUserTokensByUsernameAndDirectory")
  4.       .setString("username", username)
  5.       .setLong("directoryId", directoryId)
  6.       .executeUpdate();
  7.   return numDeleted > 0;
  8. }

代码示例来源：origin: com.atlassian.crowd/crowd-persistence-hibernate5

  1. public BoundedCount countDirectMembersOfGroup(long directoryId, String groupName, int potentialMaxCount) {
  2.   final Number count = (Number) session().getNamedQuery("countMembersOfGroup")
  3.       .setLong("directoryId", directoryId)
  4.       .setString("lowerGroupName", toLowerCase(groupName))
  5.       .setParameter("membershipType", MembershipType.GROUP_USER)
  6.       .uniqueResult();
  7.   return BoundedCount.exactly(count.longValue());
  8. }

代码示例来源：origin: com.atlassian.crowd/crowd-persistence-hibernate5

  1. public void removeUserMemberships(long directoryId, String username) {
  2.   session().getNamedQuery("removeAllEntityMemberships")
  3.       .setString("entityName", toLowerCase(username))
  4.       .setLong("directoryId", directoryId)
  5.       .setParameter("membershipType", MembershipType.GROUP_USER)
  6.       .executeUpdate();
  7. }

代码示例来源：origin: com.atlassian.crowd/crowd-persistence-hibernate5

  1. @Override
  2. public List<InternalApplicationDefaultGroupMembershipConfiguration> listAll(final Application application, ApplicationDirectoryMapping directoryMapping) throws DirectoryMappingNotFoundException {
  3.   final DirectoryMapping directoryMappingEntity = applicationDAO.findDirectoryMapping(application.getId(), directoryMapping.getDirectory().getId());
  4.   return session().getNamedQuery("listAllAutoAddGroupConfigurations")
  5.       .setLong("directoryMappingId", directoryMappingEntity.getId())
  6.       .list();
  7. }

代码示例来源：origin: com.atlassian.crowd/crowd-persistence-hibernate5

  1. @Override
  2. public void removeAll(final Application application, ApplicationDirectoryMapping directoryMapping) throws DirectoryMappingNotFoundException {
  3.   final DirectoryMapping directoryMappingEntity = applicationDAO.findDirectoryMapping(application.getId(), directoryMapping.getDirectory().getId());
  4.   session().getNamedQuery("removeAllDefaultGroupMembershipsForApplicationAndDirectory")
  5.       .setLong("directoryMappingId", directoryMappingEntity.getId())
  6.       .executeUpdate();
  7. }

代码示例来源：origin: com.atlassian.crowd/crowd-persistence-hibernate5

  1. @Override
  2. public void remove(final Application application, ApplicationDirectoryMapping directoryMapping, String groupName) throws DirectoryMappingNotFoundException {
  3.   final DirectoryMapping directoryMappingEntity = applicationDAO.findDirectoryMapping(application.getId(), directoryMapping.getDirectory().getId());
  4.   session().getNamedQuery("removeDefaultGroupMembershipConfiguration")
  5.       .setLong("directoryMappingId", directoryMappingEntity.getId())
  6.       .setString("groupName", groupName)
  7.       .executeUpdate();
  8. }

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

query

相关文章

    查看更多

    热门标签

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

    最新文章

    更多

    Query类方法

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