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

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

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

Query.setParameters介绍

[英]Bind values and types to positional parameters. Allows binding more than one at a time; no real performance impact. The number of elements in each array should match. That is, element number-0 in types array corresponds to element-0 in the values array, etc,
[中]

代码示例

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

  1. sessionFactory = getHibernateTemplate().getSessionFactory();
  2. Session session = sessionFactory.getCurrentSession();
  3. Query query = session
  4. .createQuery("select value from table where ...");
  5. query.setParameters("param1", value1);
  6. result = (Type) query.uniqueResult();

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

  1. public TypedQuery<T> setParameters(Object[] values, Type[] types) throws HibernateException {
  2. query.setParameters(values, types);
  3. return this;
  4. }

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

  1. @Override
  2. public Query setParameters(Object[] objects, Type[] types) {
  3. return query.setParameters(objects, types);
  4. }

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

  1. @Override
  2. public Query setParameters(final Object[] values, final Type[] types) throws HibernateException {
  3. return query.setParameters(values, types);
  4. }

代码示例来源:origin: org.sakaiproject/sakai-rwiki-impl

  1. public Object doInHibernate(Session session)
  2. throws HibernateException
  3. {
  4. String search = basepath.replaceAll("([A%_])", "A$1"); //$NON-NLS-1$ //$NON-NLS-2$
  5. return session
  6. .createQuery(
  7. "from RWikiCurrentObjectImpl as r " //$NON-NLS-1$
  8. + "where r.name like concat(?,'%') escape 'A' " //$NON-NLS-1$
  9. + "and r.version >= ? " //$NON-NLS-1$
  10. + "order by r.version desc, r.name asc") //$NON-NLS-1$
  11. .setParameters(new Object[] { search, time },
  12. new Type[] { Hibernate.STRING, Hibernate.DATE })
  13. .list();
  14. }
  15. };

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

  1. //sessionFactory = getHibernateTemplate().getSessionFactory();
  2. Session session = getSessionFactory().getCurrentSession();
  3. Query query = session.createQuery("select value from table where ...");
  4. query.setParameters("param1", value1);
  5. result = (Type) query.uniqueResult(); //The type is you desired result type.
  6. //test for null here if needed

代码示例来源:origin: org.sakaiproject/sakai-rwiki-impl

  1. public Object doInHibernate(Session session)
  2. throws HibernateException
  3. {
  4. return session
  5. .createQuery(
  6. "select distinct r " //$NON-NLS-1$
  7. + " from RWikiCurrentObjectImpl as r, " //$NON-NLS-1$
  8. + " RWikiCurrentObjectContentImpl as c " //$NON-NLS-1$
  9. + " where r.realm = ? and (" //$NON-NLS-1$
  10. + " lower(r.name) like ? or " //$NON-NLS-1$
  11. + " lower(c.content) like ? " //$NON-NLS-1$
  12. + expression.toString() + " ) and " //$NON-NLS-1$
  13. + " r.id = c.rwikiid " //$NON-NLS-1$
  14. + " order by r.name ").setParameters( //$NON-NLS-1$
  15. criteriaList.toArray(), types).list();
  16. }
  17. };

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

  1. Query query = session.createQuery("select value from table where param1 = :param1").addScalar("value", StandardBasicTypes.STRING);
  2. query.setParameters("param1", value1);
  3. result = (String) query.uniqueResult();

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

  1. Query query = session.createQuery("select value from table where param1 = :param1").addScalar("value", Type);
  2. query.setParameters("param1", value1);
  3. result = (Type) query.uniqueResult();

代码示例来源:origin: net.sf.jabb/jabb-core

  1. /**
  2. * Setup a query with parameters and other configurations.
  3. * @param query
  4. * @param paramValues
  5. * @param paramTypes
  6. * @param offset
  7. * @param limit
  8. */
  9. private void setupQuery(Query query, Object[] paramValues, Type[] paramTypes, Integer offset, Integer limit){
  10. if (paramValues != null && paramTypes != null){
  11. query.setParameters(paramValues, paramTypes);
  12. }
  13. if (offset != null){
  14. query.setFirstResult(offset);
  15. }
  16. if (limit != null){
  17. query.setMaxResults(limit);
  18. }
  19. }

相关文章