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

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

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

Query.setInteger介绍

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

代码示例

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

  1. Session s = openSession();
  2. try {
  3.   Query q = s.createQuery("select bar from Bar as bar where bar.x > :myX");
  4.   q.list();
  5.   fail("Should throw QueryException for missing myX");
  6.   Query q = s.createQuery("select bar from Bar as bar where bar.x > ?");
  7.   q.list();
  8.   fail("Should throw QueryException for missing ?");
  9.   Query q = s.createQuery("select bar from Bar as bar where bar.x > ? or bar.short = 1 or bar.string = 'ff ? bb'");
  10.   q.setInteger(0, 1);
  11.   q.list();

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

  1. assertEquals( session.createFilter( customer.getOrders(), "" ).list().size(), 1 );
  2. assertEquals( session.createFilter( order.getLineItems(), "" ).list().size(), 1 );
  3. assertEquals( session.createFilter( order.getLineItems(), "where this.quantity > :quantity" ).setInteger( "quantity", 5 ).list().size(), 0 );

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

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

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

  1. s.save( bar2 );
  2. List list = s.createQuery(
  3.     "from Bar bar left join bar.baz baz left join baz.cascadingBars b where bar.name like 'Bar %'"
  4. ).list();
  5. assertTrue( row instanceof Object[] && ( (Object[]) row ).length==3 );
  6. Query q = s.createQuery("select bar, b from Bar bar left join bar.baz baz left join baz.cascadingBars b where bar.name like 'Bar%'");
  7. list = q.list();
  8. if ( !(getDialect() instanceof SAPDBDialect) ) assertTrue( list.size()==2 );
  9. q = s.createQuery("select bar, b from Bar bar left join bar.baz baz left join baz.cascadingBars b where ( bar.name in (:nameList) or bar.name in (:nameList) ) and bar.string = :stringVal");
  10. HashSet nameList = new HashSet();
  11. nameList.add( "bar" );
  12. q.setParameterList( "nameList", nameList );
  13. q.setParameter( "stringVal", "a string" );
  14. list = q.list();
  15. if ( !(getDialect() instanceof SAPDBDialect) ) assertTrue( list.size()==2 );
  16. q = s.createQuery("select bar from Bar bar order by ((bar.x - :valueX)*(bar.x - :valueX))");
  17. q.setInteger( "valueX", bar.getX() + 1 );
  18. list = q.list();
  19. assertTrue( ((Bar) list.get( 0 )).getX() == bar.getX() );
  20. q.setInteger( "valueX", bar2.getX() + 1 );
  21. list = q.list();
  22. assertTrue( ((Bar)list.get(0)).getX() == bar2.getX());

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

  1. /**
  2.  * @see org.openmrs.api.db.PersonDAO#getLosingPersonMergeLogs(org.openmrs.Person)
  3.  */
  4. @Override
  5. public PersonMergeLog getLosingPersonMergeLogs(Person person) throws DAOException {
  6.   return (PersonMergeLog) sessionFactory.getCurrentSession().createQuery(
  7.     "from PersonMergeLog p where p.loser.id = :loserId").setInteger("loserId", person.getId()).uniqueResult();
  8. }

代码示例来源：origin: denimgroup/threadfix

  1. @Override
  2. public boolean hasMappings(int id) {
  3.    Object result = sessionFactory.getCurrentSession().createQuery(
  4.          "from VulnerabilityMap map where map.channelVulnerability = :channelVuln")
  5.        .setInteger("channelVuln", id).list();
  6.       return result == null;
  7. }

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

  1. s.save(simple );
  2. s.createQuery( "from Simple s where repeat('foo', 3) = 'foofoofoo'" ).list();
  3. s.createQuery( "from Simple s where repeat(s.name, 3) = 'foofoofoo'" ).list();
  4. s.createQuery( "from Simple s where repeat( lower(s.name), (3 + (1-1)) / 2) = 'foofoofoo'" ).list();
  5. Query q = s.createQuery("from Simple s");
  6. q.setMaxResults( 10 );
  7. assertTrue( q.list().size()==3 );
  8. q = s.createQuery("from Simple s");
  9. q.setMaxResults( 1 );
  10. assertTrue( q.list().size()==1 );
  11. q = s.createQuery("from Simple s");
  12. assertTrue( q.list().size() == 3 );
  13. q = s.createQuery("from Simple s where s.name = ?");
  14. q.setString( 0, "Simple 1" );
  15. q.setParameter( "bar", "SIMPLE 1" );
  16. q.setString( "foo", "Simple 1" );
  17. q.setInteger("count", 69);
  18. q.setFirstResult(0);
  19. assertTrue( q.iterate().hasNext() );

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

  1. .createQuery(
  2.       "select count(*) from User u where (u.username = :uname1 or u.systemId = :uname2 or u.username = :sysid1 or u.systemId = :sysid2 or u.systemId = :uname3) and u.userId <> :uid");
  3. query.setString("uname1", username);
  4. query.setString("sysid2", systemId);
  5. query.setString("uname3", usernameWithCheckDigit);
  6. query.setInteger("uid", userId);

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

  1. String[] tags = {"ADMIN", "EMPLOYEE"};
  2. String hql = "select u from User u " +
  3.         "join u.roles r " +
  4.         "where r.name in (:tags)" +
  5.         "group by u " +
  6.         "having count(r)=:tag_count";
  7. Query query = session.createQuery(hql);
  8. query.setParameterList("tags", tags);
  9. query.setInteger("tag_count", tags.length);
  10. List<User> Users = query.list();

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

  1. s.createQuery( "from Simple s where repeat('foo', 3) = 'foofoofoo'" ).list();
  2.   s.createQuery( "from Simple s where repeat(s.name, 3) = 'foofoofoo'" ).list();
  3.   s.createQuery( "from Simple s where repeat( lower(s.name), 3 + (1-1) / 2) = 'foofoofoo'" ).list();
  4. Query q = s.createQuery("from Simple s");
  5. q.setMaxResults(10);
  6. assertTrue( q.list().size()==3 );
  7. q = s.createQuery("from Simple s");
  8. q.setMaxResults(1);
  9. assertTrue( q.list().size()==1 );
  10. q = s.createQuery("from Simple s");
  11. assertTrue( q.list().size()==3 );
  12. q = s.createQuery("from Simple s where s.name = ?");
  13. q.setString(0, "Simple 1");
  14. q.setParameter("bar", "SIMPLE 1");
  15. q.setString("foo", "Simple 1");
  16. q.setInteger("count", 69);
  17. q.setFirstResult(0);
  18. assertTrue( q.iterate().hasNext() );

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

  1. Query query = sessionFactory.getCurrentSession().createQuery(hql);
  2. query.setString("identifier", patientIdentifier.getIdentifier());
  3. query.setInteger("idType", patientIdentifier.getIdentifierType().getPatientIdentifierTypeId());
  4. if (checkPatient) {
  5.   query.setInteger("ptId", patientIdentifier.getPatient().getPatientId());
  6.   query.setInteger("locationId", patientIdentifier.getLocation().getLocationId());

代码示例来源：origin: denimgroup/threadfix

  1. @SuppressWarnings("unchecked")
  2. @Override
  3. public List<WafRule> retrieveByWafAndDirective(Waf waf,
  4.     WafRuleDirective directive) {
  5.   return sessionFactory
  6.     .getCurrentSession()
  7.     .createQuery( "from WafRule wafRule where wafRule.waf = :wafId " +
  8.       "and wafRule.wafRuleDirective = :directiveId")
  9.     .setInteger("wafId", waf.getId())
  10.     .setInteger("directiveId", directive.getId()).list();
  11. }

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

  1. assertTrue( s.createQuery( "select elements(master.details) from Master master" ).list().size()==2 );
  2. t.commit();
  3. s.close();
  4. List list = s.createQuery( "from Master m left join fetch m.details" ).list();
  5. Master m = (Master) list.get(0);
  6. assertTrue( Hibernate.isInitialized( m.getDetails() ) );
  7. master = dd.getMaster();
  8. assertTrue( "detail-master", master.getDetails().contains(dd) );
  9. assertTrue( s.createFilter( master.getDetails(), "order by this.i desc" ).list().size()==2 );
  10. assertTrue( s.createFilter( master.getDetails(), "select this where this.id > -1" ).list().size()==2 );
  11. Query q = s.createFilter( master.getDetails(), "where this.id > :id" );
  12. q.setInteger("id", -1);
  13. assertTrue( q.list().size()==2 );
  14. q = s.createFilter( master.getDetails(), "where this.id > :id1 and this.id < :id2" );
  15. q.setInteger("id1", -1);
  16. q.setInteger("id2", 99999999);
  17. assertTrue( q.list().size()==2 );
  18. q.setInteger("id2", -1);
  19. assertTrue( q.list().size()==0 );
  20. f.setInteger("top", 100);
  21. f.setInteger("bottom", 0);
  22. assertEquals( f.iterate().next(), new Integer(12) );
  23. f.setInteger("top", 2);
  24. assertEquals( f.iterate().next(), new Integer(0) );

代码示例来源：origin: denimgroup/threadfix

  1. @Override
  2. public void delete(Integer reportId) {
  3.   Session session = sessionFactory.getCurrentSession();
  4.   String hql;
  5.   hql = "delete from Report where id = :id";
  6.   session.createQuery(hql).setInteger("id", reportId).executeUpdate();
  7. }

代码示例来源：origin: denimgroup/threadfix

  1. @SuppressWarnings("unchecked")
  2. public List<Vulnerability> getVulns(Application app) {
  3.   return (List<Vulnerability>) sessionFactory.getCurrentSession()
  4.       .createQuery("from Vulnerability vuln where vuln.application = :appId")
  5.       .setInteger("appId", app.getId()).list();
  6. }

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

  1. /**
  2.  * Gets primary diagnoses for a given encounter
  3.  *
  4.  * @param encounter the specific encounter to get the primary diagnoses for.
  5.  * @return list of primary diagnoses for an encounter
  6.  */
  7. @Override
  8. public List<Diagnosis> getPrimaryDiagnoses(Encounter encounter) {
  9.   Query query = sessionFactory.getCurrentSession().createQuery(
  10.     "from Diagnosis d where d.encounter.encounterId = :encounterId and d.rank = :rankId order by dateCreated desc");
  11.   query.setInteger("encounterId", encounter.getId());
  12.   query.setInteger("rankId", PRIMARY_RANK);
  13.   return query.list();
  14. }

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

  1. public ItemData findByItemEventCrfOrdinal(Integer itemId, Integer eventCrfId, Integer ordinal) {
  2.   String query = "from " + getDomainClassName()
  3.       + " item_data where item_data.item.itemId = :itemid and item_data.eventCrf.eventCrfId = :eventcrfid and item_data.ordinal = :ordinal "
  4.       + "and deleted=false";
  5.   org.hibernate.Query q = getCurrentSession().createQuery(query);
  6.   q.setInteger("itemid", itemId);
  7.   q.setInteger("eventcrfid", eventCrfId);
  8.   q.setInteger("ordinal", ordinal);
  9.   return (ItemData) q.uniqueResult();
  10. }

代码示例来源：origin: denimgroup/threadfix

  1. @Override
  2. @SuppressWarnings("unchecked")
  3. public List<ChannelSeverity> retrieveByChannel(ChannelType channelType) {
  4.   return sessionFactory
  5.       .getCurrentSession()
  6.       .createQuery(
  7.           "from ChannelSeverity cs where cs.channelType = :channelTypeId order by cs.numericValue desc")
  8.       .setInteger("channelTypeId", channelType.getId()).list();
  9. }

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

  1. /**
  2.  * @see org.openmrs.api.db.PersonDAO#getWinningPersonMergeLogs(org.openmrs.Person)
  3.  */
  4. @Override
  5. @SuppressWarnings("unchecked")
  6. public List<PersonMergeLog> getWinningPersonMergeLogs(Person person) throws DAOException {
  7.   return (List<PersonMergeLog>) sessionFactory.getCurrentSession().createQuery(
  8.     "from PersonMergeLog p where p.winner.id = :winnerId").setInteger("winnerId", person.getId()).list();
  9. }

代码示例来源：origin: OpenNMS/opennms

  1. private OnmsNode getNode(Integer nodeId, Session session) {
  2.   if (nodeId != null) {
  3.     Query q = session.createQuery("from OnmsNode as n where n.id = :nodeId");
  4.     q.setInteger("nodeId",  nodeId);
  5.     return (OnmsNode)q.uniqueResult();
  6.   }
  7.   return null;
  8. }

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

query

相关文章

    查看更多

    热门标签

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

    最新文章

    更多

    Query类方法

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