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

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

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

Query.setDate介绍

[英]Bind a positional Date-valued parameter using just the Date portion.
[中]仅使用日期部分绑定位置日期值参数。

代码示例

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

  1. tx = s.beginTransaction();
  2. Query q = s.getNamedQuery( "night.moreRecentThan" );
  3. q.setDate( "date", aMonthAgo );
  4. assertEquals( 1, q.list().size() );
  5. q = s.getNamedQuery( "night.moreRecentThan" );
  6. q.setDate( "date", inAMonth );
  7. assertEquals( 0, q.list().size() );
  8. Statistics stats = sessionFactory().getStatistics();

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

  1. /**
  2.  * Gets all active diagnoses related to the specified patient.
  3.  *
  4.  * @param patient the patient whose active diagnoses are being queried.
  5.  * @return all active diagnoses associated with the specified patient.
  6.  */
  7. @SuppressWarnings("unchecked")
  8. @Override
  9. public List<Diagnosis> getActiveDiagnoses(Patient patient, Date fromDate) {
  10.   String fromDateCriteria = "";
  11.   if(fromDate != null){
  12.     fromDateCriteria = " and d.dateCreated >= :fromDate ";
  13.   }
  14.   Query query = sessionFactory.getCurrentSession().createQuery(
  15.     "from Diagnosis d where d.patient.patientId = :patientId and d.voided = false " 
  16.       + fromDateCriteria  
  17.       + " order by d.dateCreated desc");
  18.   query.setInteger("patientId", patient.getId());
  19.   if(fromDate != null){
  20.     query.setDate("fromDate", fromDate);
  21.   }
  22.   return query.list();
  23. }

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

  1. query.setInteger("patientId", patient.getPatientId());
  2. query.setInteger("creator", patient.getCreator().getUserId());
  3. query.setDate("dateCreated", patient.getDateCreated());

代码示例来源：origin: com.github.cafdataprocessing/corepolicy-hibernate

  1. @Override
  2. public Query setDate(int i, Date date) {
  3.   return query.setDate(i, date);
  4. }

代码示例来源：origin: com.github.cafdataprocessing/corepolicy-hibernate

  1. @Override
  2. public Query setDate(String s, Date date) {
  3.   return query.setDate(s, date);
  4. }

代码示例来源：origin: ezbz/projectx

  1. @Override
  2. public Query setDate(final int position, final Date date) {
  3.  return query.setDate(position, date);
  4. }

代码示例来源：origin: stackoverflow.com

  1. String queryStr = "select * from OmniMainEntity o where o.dateTime BETWEEN :startDate AND :endDate)"; // The query now changed to database independent
  2. Query query = manager.createQuery(queryStr);
  3. query.setDate("startDate", startDate);
  4. query.setDate("endDate", endDate);

代码示例来源：origin: riotfamily/riot

  1. public TypedQuery<T> setDate(String name, Date date) {
  2.   query.setDate(name, date);
  3.   return this;
  4. }

代码示例来源：origin: ezbz/projectx

  1. @Override
  2. public Query setDate(final String name, final Date date) {
  3.  return query.setDate(name, date);
  4. }

代码示例来源：origin: riotfamily/riot

  1. public TypedQuery<T> setDate(int position, Date date) {
  2.   query.setDate(position, date);
  3.   return this;
  4. }

代码示例来源：origin: stackoverflow.com

  1. Query q = session.CreateQuery("select * from Ifcitsv2013 left join IfcitsSensorphistory as h where timestamp between :startDate and :finishDate and h.id = 50");
  2. q.setDate("startDate", startDate);
  3. q.setDate("finishDate", finishDate);
  4. List result = q.list();

代码示例来源：origin: michael8335/zeus2

  1. @Override
  2.   public Object doInHibernate(Session session) throws HibernateException,
  3.       SQLException {
  4.     Query query=session.createQuery("from com.taobao.zeus.store.mysql.persistence.GroupPersistence where gmt_modified>?");
  5.     query.setDate(0, ignoreContentGroupJudge.lastModified);
  6.     List<GroupPersistence> list=query.list();
  7.     List<GroupDescriptor> result=new ArrayList<GroupDescriptor>();
  8.     for(GroupPersistence p:list){
  9.       result.add(PersistenceAndBeanConvert.convert(p));
  10.     }
  11.     return result;
  12.   }
  13. });

代码示例来源：origin: ctripcorp/dataworks-zeus

  1. @Override
  2.   public Object doInHibernate(Session session) throws HibernateException,
  3.       SQLException {
  4.     Query query=session.createQuery("from com.taobao.zeus.store.mysql.persistence.GroupPersistence where gmt_modified>?");
  5.     query.setDate(0, ignoreContentGroupJudge.lastModified);
  6.     List<GroupPersistence> list=query.list();
  7.     List<GroupDescriptor> result=new ArrayList<GroupDescriptor>();
  8.     for(GroupPersistence p:list){
  9.       result.add(PersistenceAndBeanConvertOld.convert(p));
  10.     }
  11.     return result;
  12.   }
  13. });

代码示例来源：origin: stackoverflow.com

  1. Query query = session.getNamedQuery("User.findByHash");
  2. query.setString("hash", hash);
  3. query.setDate("hash", new Date());

代码示例来源：origin: stackoverflow.com

  1. Query query = session.getNamedQuery("User.findByHash");
  2. query.setString("hash", hash);
  3. query.setDate("date_time_terminate", new Date());

代码示例来源：origin: org.opensingular/singular-support

  1. public static Query setParametersQuery(Query query, Map<String, Object> params) {
  2.   for (Map.Entry<String, Object> parameter : params.entrySet()) {
  3.     if (parameter.getValue() instanceof Collection<?>) {
  4.       query.setParameterList(parameter.getKey(),
  5.           (Collection<?>) parameter.getValue());
  6.     } else if (parameter.getValue() instanceof Integer) {
  7.       query.setInteger(parameter.getKey(), (Integer) parameter.getValue());
  8.     } else if (parameter.getValue() instanceof Date) {
  9.       query.setDate(parameter.getKey(), (Date) parameter.getValue());
  10.     } else {
  11.       query.setParameter(parameter.getKey(), parameter.getValue());
  12.     }
  13.   }
  14.   return query;
  15. }

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

  1. @Override
  2. public void markExpiredAccessors() {
  3.   getHibernateTemplate().execute(session -> {
  4.     session.createQuery(
  5.         "UPDATE Accessor a SET a.status=? WHERE a.expirationDate < ?")
  6.         .setParameter(0, Accessor.Status.EXPIRED)
  7.         .setDate(1, new Date())
  8.         .executeUpdate();
  9.     return null;
  10.   });
  11. }

代码示例来源：origin: michael8335/zeus2

  1. @Override
  2.   public Object doInHibernate(Session session) throws HibernateException,
  3.       SQLException {
  4.     Query query=session.createQuery("select id,groupId from com.taobao.zeus.store.mysql.persistence.JobPersistence where gmt_modified>?");
  5.     query.setDate(0, ignoreContentJobJudge.lastModified);
  6.     List<Object[]> list=query.list();
  7.     List<JobDescriptor> result=new ArrayList<JobDescriptor>();
  8.     for(Object[] o:list){
  9.       JobDescriptor jd=new JobDescriptor();
  10.       jd.setId(String.valueOf(o[0]));
  11.       jd.setGroupId(String.valueOf(o[1]));
  12.       result.add(jd);
  13.     }
  14.     return result;
  15.   }
  16. });

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

  1. public int getLateSubmissionsNumberByAgentId(final Long publishedAssessmentId, final String agentIdString, final Date dueDate) {
  2.   final HibernateCallback<List<AssessmentGradingData>> hcb = session -> {
  3.     Query q = session.createQuery(
  4.         "from AssessmentGradingData a where a.publishedAssessmentId = :id and a.agentId = :agent and a.forGrade = :forgrade and a.submittedDate > :submitted");
  5.     q.setLong("id", publishedAssessmentId);
  6.     q.setString("agent", agentIdString);
  7.     q.setBoolean("forgrade", true);
  8.     q.setDate("submitted", dueDate);
  9.     return q.list();
  10.   };
  11.   List<AssessmentGradingData> assessmentGradings = getHibernateTemplate().execute(hcb);
  12.   return assessmentGradings.size();
  13. }

代码示例来源：origin: org.sakaiproject.samigo/samigo-services

  1. public int getLateSubmissionsNumberByAgentId(final Long publishedAssessmentId, final String agentIdString, final Date dueDate) {
  2.   final HibernateCallback<List<AssessmentGradingData>> hcb = session -> {
  3.     Query q = session.createQuery(
  4.         "from AssessmentGradingData a where a.publishedAssessmentId = :id and a.agentId = :agent and a.forGrade = :forgrade and a.submittedDate > :submitted");
  5.     q.setLong("id", publishedAssessmentId);
  6.     q.setString("agent", agentIdString);
  7.     q.setBoolean("forgrade", true);
  8.     q.setDate("submitted", dueDate);
  9.     return q.list();
  10.   };
  11.   List<AssessmentGradingData> assessmentGradings = getHibernateTemplate().execute(hcb);
  12.   return assessmentGradings.size();
  13. }

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

query

相关文章

    查看更多

    热门标签

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

    最新文章

    更多

    Query类方法

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