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

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

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

Query.setString介绍

[英]Bind a positional String-valued parameter.
[中]绑定位置字符串值参数。

代码示例

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

  1. private Agent fetchAgentByUuid(final String uuid) {
  2.     return (Agent) getHibernateTemplate().execute(session -> {
  3.       Query query = session.createQuery("from Agent where uuid = :uuid");
  4.       query.setString("uuid", uuid);
  5.       return query.uniqueResult();
  6.     });
  7.   }
  8. }

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

  1. Modification findModificationWithRevision(Session session, long materialId, String revision) {
  2.   Modification modification;
  3.   String key = cacheKeyForModificationWithRevision(materialId, revision);
  4.   modification = (Modification) goCache.get(key);
  5.   if (modification == null) {
  6.     synchronized (key) {
  7.       modification = (Modification) goCache.get(key);
  8.       if (modification == null) {
  9.         Query query = session.createQuery("FROM Modification WHERE materialId = ? and revision = ? ORDER BY id DESC");
  10.         query.setLong(0, materialId);
  11.         query.setString(1, revision);
  12.         modification = (Modification) query.uniqueResult();
  13.         goCache.put(key, modification);
  14.       }
  15.     }
  16.   }
  17.   return modification;
  18. }

代码示例来源：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. q = s.createQuery("from Simple s where s.name=:name");
  16. q.setString("name", "Simple 2");
  17. q.setCacheable(true);
  18. assertTrue( q.list().size()==1 );
  19. assertTrue( q.list().size()==1 );
  20. q = s.createQuery("from Simple s where s.name=?");
  21. q.setCacheable(true);
  22. q.setString(0, "Simple 1");
  23. assertTrue( q.list().size()==0 );
  24. assertTrue( q.list().size()==0 );

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

  1. log.debug("name: " + name);
  2. Query query = sessionFactory.getCurrentSession().createQuery(hql.toString());
  3. query.setParameter("DAEMON_USER_UUID", Daemon.getDaemonUserUuid());
  4. for (Map.Entry<String, String> e : namesMap.entrySet()) {
  5.   query.setString(e.getKey(), e.getValue());

代码示例来源：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: org.openmobster.core/security

  1. public Group read(String name) throws IDMException
  2. {
  3.   Session session = null;
  4.   Transaction tx = null;
  5.   try
  6.   {
  7.     Group group = null;
  8.     
  9.     session = this.hibernateManager.getSessionFactory().getCurrentSession();
  10.     tx = session.beginTransaction();
  11.     
  12.     String query = "from Group where name=?";
  13.     
  14.     group = (Group)session.createQuery(query).setString(0, name).setCacheable(true).uniqueResult();
  15.           
  16.     tx.commit();
  17.     
  18.     return group;
  19.   }
  20.   catch(Exception e)
  21.   {
  22.     log.error(this, e);
  23.     if(tx != null)
  24.     {
  25.       tx.rollback();
  26.     }
  27.     throw new IDMException(e);
  28.   }        
  29. }

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

  1. @SuppressWarnings("unchecked")
  2. public ActivityFullInstance<ActivityBody> getActivityRecord(
  3.   ProcessInstanceUUID instanceUUID, String activityId, String iterationId) {
  4.  Query query = getSession().getNamedQuery("findActivityInstance");
  5.  query.setCacheable(true);
  6.  query.setString("instanceUUID", instanceUUID.toString());
  7.  query.setString("activityId", activityId);
  8.  query.setString("iterationId", iterationId);
  9.  query.setMaxResults(1);
  10.  return (ActivityFullInstance<ActivityBody>) query.uniqueResult();
  11. }

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

  1. @SuppressWarnings("unchecked")
  2. public Set<ActivityFullInstance<TaskInstance>> getUserTasks(String userId, TaskState taskState) {
  3.  Query query = getSession().getNamedQuery("getUserTasksWithState");
  4.  query.setCacheable(true);
  5.  query.setString("userId", userId);
  6.  query.setParameter("state", taskState, taskStateUserType);
  7.  Set<ActivityFullInstance<TaskInstance>> result = new HashSet<ActivityFullInstance<TaskInstance>>();
  8.  result.addAll(query.list());
  9.  return result;
  10. }

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

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

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

  1. @Override
  2. public PersonAddress getPersonAddressByUuid(String uuid) {
  3.   return (PersonAddress) sessionFactory.getCurrentSession().createQuery("from PersonAddress p where p.uuid = :uuid")
  4.       .setString("uuid", uuid).uniqueResult();
  5. }

代码示例来源：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) );

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

  1. protected GradebookAssignment getAssignmentWithoutStats(final String gradebookUid, final Long assignmentId) throws HibernateException {
  2.   return (GradebookAssignment) getSessionFactory().getCurrentSession()
  3.       .createQuery("from GradebookAssignment as asn where asn.id = :assignmentid and asn.gradebook.uid = :gradebookuid and asn.removed is false")
  4.       .setLong("assignmentid", assignmentId)
  5.       .setString("gradebookuid", gradebookUid)
  6.       .uniqueResult();
  7. }

代码示例来源：origin: org.openmobster.core/security

  1. identity = (Identity)session.createQuery(query).setString(0, principal).setCacheable(true).uniqueResult();

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

  1. public PackageFullDefinition getPackage(String packageId, String version) {
  2.  final Query query = getSession().getNamedQuery("getPackageFromIdAndVersion");
  3.  query.setCacheable(true);
  4.  query.setString("packageId", packageId);
  5.  query.setString("version", version);
  6.  query.setMaxResults(1);
  7.  return (PackageFullDefinition) query.uniqueResult();
  8. }

代码示例来源：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. 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. q = s.createQuery("from Simple s where s.name=:name");
  16. q.setString("name", "Simple 2");
  17. q.setCacheable(true);
  18. assertTrue( q.list().size()==1 );
  19. assertTrue( q.list().size()==1 );
  20. q = s.createQuery("from Simple s where s.name=?");
  21. q.setCacheable(true);
  22. q.setString(0, "Simple 1");
  23. assertTrue( q.list().size()==0 );
  24. assertTrue( q.list().size()==0 );

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

  1. /**
  2.  * @see org.openmrs.PatientDAO#getAllergyByUuid(String)
  3.  */
  4.   @Override
  5. public Allergy getAllergyByUuid(String uuid) {
  6.   return (Allergy) sessionFactory.getCurrentSession().createQuery("from Allergy a where a.uuid = :uuid")
  7.       .setString("uuid", uuid).uniqueResult();
  8. }

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

  1. Session s = openSession();
  2. s.beginTransaction();
  3. for ( Object entity : s.createQuery( "from Assignable" ).list() ) {
  4.   s.delete( entity );
  5. for ( Object entity : s.createQuery( "from Category" ).list() ) {
  6.   s.delete( entity );
  7. Query basicParam = s.createSQLQuery( "select {category.*} from category {category} where {category}.name = 'Best'" )
  8.     .addEntity( "category", Category.class );
  9. List list = basicParam.list();
  10. assertEquals(1, list.size());
  11. unnamedParam.setString(0, "Good");
  12. unnamedParam.setString(1, "Best");
  13. list = unnamedParam.list();
  14. assertEquals(2, list.size());
  15. namedParam.setString("firstCat", "Better");
  16. namedParam.setString("secondCat", "Best");
  17. list = namedParam.list();
  18. assertEquals(2, list.size());
  19. s.getTransaction().commit();

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

  1. private Comment getInternalComment(final String gradebookUid, final Long assignmentId, final String studentUid) {
  2.   return (Comment) getHibernateTemplate().execute(session -> session
  3.       .createQuery("from Comment as c where c.studentId = :studentId and c.gradableObject.gradebook.uid = :gradebookUid and c.gradableObject.id = :assignmentId and gradableObject.removed is false")
  4.       .setString("studentId", studentUid)
  5.       .setString("gradebookUid", gradebookUid)
  6.       .setLong("assignmentId", assignmentId)
  7.       .uniqueResult());
  8. }

代码示例来源：origin: org.openmobster.core/security

  1. device = (Device)session.createQuery(query).setString(0, identifier).setCacheable(true).uniqueResult();

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

query

相关文章

    查看更多

    热门标签

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

    最新文章

    更多

    Query类方法

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