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

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

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

Query.setLong介绍

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

代码示例

代码示例来源：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: gocd/gocd

  1. public Long getTotalModificationsFor(final MaterialInstance materialInstance) {
  2.   String key = materialModificationCountKey(materialInstance);
  3.   Long totalCount = (Long) goCache.get(key);
  4.   if (totalCount == null || totalCount == 0) {
  5.     synchronized (key) {
  6.       totalCount = (Long) goCache.get(key);
  7.       if (totalCount == null || totalCount == 0) {
  8.         totalCount = (Long) getHibernateTemplate().execute((HibernateCallback) session -> {
  9.           Query q = session.createQuery("select count(*) FROM Modification WHERE materialId = ?");
  10.           q.setLong(0, materialInstance.getId());
  11.           return q.uniqueResult();
  12.         });
  13.         goCache.put(key, totalCount);
  14.       }
  15.     }
  16.   }
  17.   return totalCount;
  18. }

代码示例来源：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: 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: org.wso2.bpel/ode-dao-hibernate

  1. @SuppressWarnings("unchecked")
  2. public Collection<ActivityRecoveryDAO> getActivityRecoveries() {
  3.   entering("ProcessInstanceDaoImpl.getActivityRecoveries");
  4.  List<ActivityRecoveryDAO> results = new ArrayList<ActivityRecoveryDAO>();
  5.  Query qry = getSession().createQuery(QRY_RECOVERIES);
  6.  qry.setLong(0, _instance.getId());
  7.  Iterator iter = qry.iterate();
  8.  while (iter.hasNext())
  9.   results.add(new ActivityRecoveryDaoImpl(_sm, (HActivityRecovery) iter.next()));
  10.  Hibernate.close(iter);
  11.  return results;
  12. }

代码示例来源：origin: org.jbpm.jbpm3/jbpm-jpdl

  1. public List calculateAverageTimeByNode(long processDefinitionId, long minumumDurationMillis) {
  2.  try {
  3.   List tuples = session.getNamedQuery("GraphSession.calculateAverageTimeByNode")
  4.    .setLong("processDefinitionId", processDefinitionId)
  5.    .setDouble("minimumDuration", minumumDurationMillis)
  6.    .list();
  7.   if (tuples.isEmpty()) return Collections.EMPTY_LIST;
  8.   List results = new ArrayList();
  9.   for (Iterator i = tuples.iterator(); i.hasNext();) {
  10.    Object[] values = (Object[]) i.next();
  11.    AverageNodeTimeEntry entry = new AverageNodeTimeEntry();
  12.    entry.setNodeId(((Number) values[0]).longValue());
  13.    entry.setNodeName((String) values[1]);
  14.    entry.setCount(((Number) values[2]).intValue());
  15.    entry.setAverageDuration(((Number) values[3]).longValue());
  16.    entry.setMinDuration(((Number) values[4]).longValue());
  17.    entry.setMaxDuration(((Number) values[5]).longValue());
  18.    results.add(entry);
  19.   }
  20.   return results;
  21.  }
  22.  catch (HibernateException e) {
  23.   handle(e);
  24.   throw new JbpmPersistenceException("could not calculate average time by node "
  25.    + "for process definition " + processDefinitionId, e);
  26.  }
  27. }

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

  1. public Integer getCountItemFacades(final Long questionPoolId) {
  2.   final HibernateCallback<Number> hcb = session -> {
  3.     Query q = session.createQuery("select count(ab) from ItemData ab, QuestionPoolItemData qpi where ab.itemId = qpi.itemId and qpi.questionPoolId = :id");
  4.     q.setLong("id", questionPoolId);
  5.     q.setCacheable(true);
  6.     return (Number) q.uniqueResult();
  7.   };
  8.       
  9.   return getHibernateTemplate().execute(hcb).intValue();
  10. }

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

  1. @Override
  2. @SuppressWarnings("unchecked")
  3. public List<Long> getTaskInstancesWaitingTimeOfUser(final String username, final Date since, final Date until) {
  4.  final Query query = getSession().getNamedQuery("getTaskInstancesWaitingTimeOfUser");
  5.  query.setLong("since", since.getTime());
  6.  query.setLong("until", until.getTime());
  7.  query.setString("userId", username);
  8.  return formatList(query.list());
  9. }

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

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

代码示例来源：origin: jtalks-org/jcommune

  1. /**
  2.    * {@inheritDoc}
  3.    */
  4.   @Override
  5.   public UserContact getContactById(long id) {
  6.     return (UserContact) session()
  7.         .createQuery("from UserContact u where u.id = ?")
  8.         .setCacheable(true)
  9.         .setLong(0, id)
  10.         .uniqueResult();
  11.   }
  12. }

代码示例来源：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: org.sakaiproject.samigo/samigo-services

  1. public void removeAssessment(final Long assessmentId) {
  2.   // if pubAssessment exist, simply set assessment to inactive else delete assessment
  3.   List<PublishedAssessmentData> count = (List<PublishedAssessmentData>) getHibernateTemplate()
  4.       .findByNamedParam("select count(p) from PublishedAssessmentData p where p.assessmentId = :id", "id", assessmentId);
  5.   log.debug("removeAssesment: no. of pub Assessment = {}", count.size());
  6.   Iterator iter = count.iterator();
  7.   int i = ((Long) iter.next()).intValue();
  8.   if (i < 1) {
  9.     AssessmentData assessment = (AssessmentData) getHibernateTemplate().load(AssessmentData.class, assessmentId);
  10.     AssessmentService s = new AssessmentService();
  11.     List resourceIdList = s.getAssessmentResourceIdList(assessment);
  12.     if (log.isDebugEnabled()) log.debug("*** we have no. of resource in assessment=" + resourceIdList.size());
  13.     s.deleteResources(resourceIdList);
  14.   }
  15.   
  16.   final String softDeleteQuery = "update AssessmentData set status = :status WHERE assessmentBaseId = :id";
  17.   getHibernateTemplate().execute(session -> {
  18.     Query q = session.createQuery(softDeleteQuery);
  19.     q.setInteger("status", AssessmentIfc.DEAD_STATUS);
  20.     q.setLong("id", assessmentId);
  21.     return q.executeUpdate();
  22.   });
  23. }

代码示例来源：origin: com.github.albfernandez/jbpm-jpdl

  1. public List calculateAverageTimeByNode(long processDefinitionId, long minumumDurationMillis) {
  2.  try {
  3.   List tuples = session.getNamedQuery("GraphSession.calculateAverageTimeByNode")
  4.    .setLong("processDefinitionId", processDefinitionId)
  5.    .setDouble("minimumDuration", minumumDurationMillis)
  6.    .list();
  7.   if (tuples.isEmpty()) return Collections.EMPTY_LIST;
  8.   List results = new ArrayList();
  9.   for (Iterator i = tuples.iterator(); i.hasNext();) {
  10.    Object[] values = (Object[]) i.next();
  11.    AverageNodeTimeEntry entry = new AverageNodeTimeEntry();
  12.    entry.setNodeId(((Number) values[0]).longValue());
  13.    entry.setNodeName((String) values[1]);
  14.    entry.setCount(((Number) values[2]).intValue());
  15.    entry.setAverageDuration(((Number) values[3]).longValue());
  16.    entry.setMinDuration(((Number) values[4]).longValue());
  17.    entry.setMaxDuration(((Number) values[5]).longValue());
  18.    results.add(entry);
  19.   }
  20.   return results;
  21.  }
  22.  catch (HibernateException e) {
  23.   handle(e);
  24.   throw new JbpmPersistenceException("could not calculate average time by node "
  25.    + "for process definition " + processDefinitionId, e);
  26.  }
  27. }

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

  1. Modification findLatestModification(final MaterialInstance expandedInstance) {
  2.   Modifications modifications = cachedModifications(expandedInstance);
  3.   if (modifications != null && !modifications.isEmpty()) {
  4.     return modifications.get(0);
  5.   }
  6.   String cacheKey = latestMaterialModificationsKey(expandedInstance);
  7.   synchronized (cacheKey) {
  8.     Modification modification = (Modification) getHibernateTemplate().execute((HibernateCallback) session -> {
  9.       Query query = session.createQuery("FROM Modification WHERE materialId = ? ORDER BY id DESC");
  10.       query.setMaxResults(1);
  11.       query.setLong(0, expandedInstance.getId());
  12.       return query.uniqueResult();
  13.     });
  14.     goCache.put(cacheKey, new Modifications(modification));
  15.     return modification;
  16.   }
  17. }

代码示例来源：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: sakaiproject/sakai

  1. protected List<GradebookAssignment> getAssignments(final Long gradebookId) throws HibernateException {
  2.   return getSessionFactory().getCurrentSession()
  3.       .createQuery("from GradebookAssignment as asn where asn.gradebook.id = :gradebookid and asn.removed is false")
  4.       .setLong("gradebookid", gradebookId)
  5.       .list();
  6. }

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

  1. public long getSubPoolSize(final Long poolId) {
  2.   final HibernateCallback<Number> hcb = session -> {
  3.     Query q = session.createQuery("select count(qpp) from QuestionPoolData qpp where qpp.parentPoolId = :id");
  4.     q.setCacheable(true);
  5.     q.setLong("id", poolId);
  6.     return (Number) q.uniqueResult();
  7.   };
  8.   
  9.   return getHibernateTemplate().execute(hcb).longValue();
  10. }

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

  1. @Override
  2. @SuppressWarnings("unchecked")
  3. public List<Long> getTaskInstancesWaitingTimeOfUser(final String username, final ActivityDefinitionUUID taskUUID,
  4.   final Date since, final Date until) {
  5.  final Query query = getSession().getNamedQuery("getTaskInstancesWaitingTimeOfUserFromActivityDefinitionUUID");
  6.  query.setLong("since", since.getTime());
  7.  query.setLong("until", until.getTime());
  8.  query.setString("activityUUID", taskUUID.getValue());
  9.  query.setString("userId", username);
  10.  return formatList(query.list());
  11. }

代码示例来源：origin: apache/ctakes

  1. public Double getKernel(KernelEvaluation kernelEvaluation,
  2.     long instanceId1, long instanceId2) {
  3.   long instanceId1s = instanceId1 <= instanceId2 ? instanceId1
  4.       : instanceId2;
  5.   long instanceId2s = instanceId1 <= instanceId2 ? instanceId2
  6.       : instanceId1;
  7.   Query q = this.getSessionFactory().getCurrentSession()
  8.       .getNamedQuery("getKernelEvaluation");
  9.   q.setCacheable(true);
  10.   q.setInteger("kernelEvaluationId",
  11.       kernelEvaluation.getKernelEvaluationId());
  12.   q.setLong("instanceId1", instanceId1s);
  13.   q.setLong("instanceId2", instanceId2s);
  14.   KernelEvaluationInstance g = (KernelEvaluationInstance) q
  15.       .uniqueResult();
  16.   if (g != null) {
  17.     return g.getSimilarity();
  18.   } else {
  19.     return null;
  20.   }
  21. }

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

  1. public QuestionPoolAccessData getQuestionPoolAccessData(final Long poolId,
  2.   final String agentId) {
  3.    final HibernateCallback<List> hcb = session -> {
  4.      Query q = session.createQuery("from QuestionPoolAccessData as qpa where qpa.questionPoolId = :id and qpa.agentId = :agent");
  5.      q.setLong("id", poolId);
  6.      q.setString("agent", agentId);
  7.      return q.list();
  8.    };
  9.    List list = getHibernateTemplate().execute(hcb);
  10.    return (QuestionPoolAccessData) list.get(0);
  11. }

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

query

相关文章

    查看更多

    热门标签

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

    最新文章

    更多

    Query类方法

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