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

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

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

Query.setResultTransformer介绍

[英]Set a strategy for handling the query results. This can be used to change "shape" of the query result.
[中]设置处理查询结果的策略。这可用于更改查询结果的“形状”。

代码示例

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

  1. Query query=session.createSQLQuery("your query");
  2. query.setResultTransformer(AliasToEntityMapResultTransformer.INSTANCE);
  3. List<Map<String,Object>> aliasToValueMapList=query.list();

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

  1. hqlQuery.setResultTransformer( tupleTransformer  );

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

  1. t = s.beginTransaction();
  2. Query sqlQuery = s.getNamedQuery("EmploymentAndPerson");
  3. sqlQuery.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);
  4. list = sqlQuery.list();
  5. assertEquals(1,list.size() );
  6. t = s.beginTransaction();
  7. sqlQuery = s.getNamedQuery( "organizationreturnproperty" );
  8. sqlQuery.setResultTransformer( Transformers.ALIAS_TO_ENTITY_MAP );
  9. list = sqlQuery.list();
  10. assertEquals( 2,list.size() );

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

  1. Transaction t = session.beginTransaction();
  2. try {
  3.   getSelectNewQuery( session ).setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).list();
  4.   fail("'select new' together with a resulttransformer should result in error!");
  5.   getSelectNewQuery( session ).setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).iterate();
  6.   fail("'select new' together with a resulttransformer should result in error!");
  7.   getSelectNewQuery( session ).setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).scroll();
  8.   fail("'select new' together with a resulttransformer should result in error!");

代码示例来源：origin: bill1012/AdminEAP

  1. public List<Map> findMap(String hql) {
  2.   Query query = this.getCurrentSession().createQuery(hql);
  3.   query.setResultTransformer(CriteriaSpecification.ALIAS_TO_ENTITY_MAP);
  4.   return query.list();
  5. }

代码示例来源：origin: bill1012/AdminEAP

  1. @SuppressWarnings("unchecked")
  2. public List<Map<String, Object>> findMapBySql(String sql, int page, int rows) {
  3.   SQLQuery sqlQuery = this.getCurrentSession().createSQLQuery(sql);
  4.   return sqlQuery.setFirstResult((page - 1) * rows).setMaxResults(rows).setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).list();
  5. }

代码示例来源：origin: bill1012/AdminEAP

  1. @SuppressWarnings("unchecked")
  2. public List<Map<String, Object>> findMapBySql(String sql, Map<String, Object> params, int page, int rows) {
  3.   SQLQuery sqlQuery = this.getCurrentSession().createSQLQuery(sql);
  4.   sqlQuery=getSqlQueryByMap(sqlQuery,params);
  5.   return sqlQuery.setFirstResult((page - 1) * rows).setMaxResults(rows).setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).list();
  6. }

代码示例来源：origin: bill1012/AdminEAP

  1. @Override
  2. public List findMapBySql(String sql, int firstResult, int maxResult, Object[] params, Type[] types, Class clazz) {
  3.   if (clazz != null)
  4.     return this.getCurrentSession().createSQLQuery(sql).setParameters(params, types).setFirstResult(firstResult)
  5.         .setMaxResults(maxResult).setResultTransformer(Transformers.aliasToBean(clazz)).list();
  6.   else
  7.     return this.getCurrentSession().createSQLQuery(sql).setParameters(params, types).setFirstResult(firstResult)
  8.         .setMaxResults(maxResult).setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP).list();
  9. }

代码示例来源：origin: slyak/spring-data-jpa-extra

  1. public static <C> Query transform(Query query, Class<C> clazz) {
  2.   ResultTransformer transformer;
  3.   if (Map.class.isAssignableFrom(clazz)) {
  4.     transformer = Transformers.ALIAS_TO_ENTITY_MAP;
  5.   } else if (Number.class.isAssignableFrom(clazz) || clazz.isPrimitive() || String.class.isAssignableFrom(clazz) ||
  6.       Date.class.isAssignableFrom(clazz)) {
  7.     transformer = transformerCache.computeIfAbsent(clazz, SmartTransformer::new);
  8.   } else {
  9.     transformer = transformerCache.computeIfAbsent(clazz, BeanTransformerAdapter::new);
  10.   }
  11.   return query.setResultTransformer(transformer);
  12. }

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

  1. @Override
  2. public long count(Query query, HibernateParameter... parameters) {
  3.  return (Long) HibernateTool.setParameters(query, parameters)
  4.                .setResultTransformer(CriteriaSpecification.PROJECTION)
  5.                .setResultTransformer(CriteriaSpecification.DISTINCT_ROOT_ENTITY)
  6.                .uniqueResult();
  7. }

代码示例来源：origin: org.geomajas.plugin/geomajas-plugin-deskmanager

  1. public boolean geodeskIdExists(String publicId) {
  2.   Query q = factory.getCurrentSession().createQuery("select id from Geodesk l WHERE l.geodeskId = :id");
  3.   q.setParameter("id", publicId);
  4.   q.setResultTransformer(DistinctRootEntityResultTransformer.INSTANCE);
  5.   Object result = q.uniqueResult();
  6.   return (result != null);
  7. }

代码示例来源：origin: org.geomajas.plugin/geomajas-plugin-deskmanager

  1. public Geodesk getGeodeskByPublicIdInternal(String id) {
  2.   if (geodeskExists(id)) {
  3.     Query q = factory.getCurrentSession().createQuery(
  4.         "FROM Geodesk l WHERE l.geodeskId = :id AND " + "l.deleted = false AND " + "l.active = true AND "
  5.             + "l.blueprint.geodesksActive = true");
  6.     q.setParameter("id", id);
  7.     q.setResultTransformer(DistinctRootEntityResultTransformer.INSTANCE);
  8.     return (Geodesk) q.uniqueResult();
  9.   } else {
  10.     return null;
  11.   }
  12. }

代码示例来源：origin: com.querydsl/querydsl-jpa

  1. @Override
  2. public boolean transform(Query query, FactoryExpression<?> projection) {
  3.   if (query instanceof HibernateQuery) {
  4.     ResultTransformer transformer = new FactoryExpressionTransformer(projection);
  5.     ((HibernateQuery) query).getHibernateQuery().setResultTransformer(transformer);
  6.     return true;
  7.   } else {
  8.     return false;
  9.   }
  10. }

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

  1. public Actor retrieveByUserCod(String userName) {
  2.   if (userName == null) {
  3.     return null;
  4.   }
  5.   Query query = getSession().createSQLQuery(
  6.       "select a.CO_ATOR as \"cod\", a.CO_USUARIO as \"codUsuario\", a.NO_ATOR as \"nome\", a.DS_EMAIL as \"email\" " +
  7.           " FROM " + Constants.SCHEMA + ".VW_ATOR a " +
  8.           " WHERE UPPER(rtrim(ltrim(a.CO_USUARIO))) = :codUsuario");
  9.   query.setParameter("codUsuario", userName.toUpperCase());
  10.   query.setResultTransformer(new FindActorByUserCodResultTransformer());
  11.   return (Actor) query.uniqueResult();
  12. }

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

  1. public Actor retrieveByUserCod(String userName) {
  2.   if (userName == null) {
  3.     return null;
  4.   }
  5.   Query query = getSession().createSQLQuery(
  6.       "select a.CO_ATOR as \"cod\", a.CO_USUARIO as \"codUsuario\", a.NO_ATOR as \"nome\", a.DS_EMAIL as \"email\" " +
  7.           " FROM " + Constants.SCHEMA + ".VW_ATOR a " +
  8.           " WHERE UPPER(rtrim(ltrim(a.CO_USUARIO))) = :codUsuario");
  9.   query.setParameter("codUsuario", userName.toUpperCase());
  10.   query.setResultTransformer(new FindActorByUserCodResultTransformer());
  11.   return (Actor) query.uniqueResult();
  12. }

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

  1. @Override
  2. @SuppressWarnings("unchecked")
  3. public List<EventCouple> getMessageEventCouples() {
  4.  final Query query = getSession().getNamedQuery("getMessageEventCouples");
  5.  query.setResultTransformer(Transformers.aliasToBean(EventCouple.class));
  6.  return formatList(query.list());
  7. }

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

  1. @Override
  2. @SuppressWarnings("unchecked")
  3. public List<EventCouple> getCorrelationKeyMessageEventCouples(final int maxCouples) {
  4.  final Query query = getSession().getNamedQuery("getCorrelationKeyMessageEventCouples");
  5.  query.setMaxResults(maxCouples);
  6.  query.setResultTransformer(Transformers.aliasToBean(EventCouple.class));
  7.  return formatList(query.list());
  8. }

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

  1. private List<Map<String, Serializable>> quickSearchMap(RequirementSearchContext query) {
  2.   return makeRequirementSearchQuery(query)
  3.       .setFirstResult(query.getQuickFilter().getFirst())
  4.       .setMaxResults(query.getQuickFilter().getCount())
  5.       .setResultTransformer(AliasToEntityMapResultTransformer.INSTANCE)
  6.       .list();
  7. }

代码示例来源：origin: org.opensingular/server-commons

  1. public List<PetitionDTO> quickSearch(QuickFilter filtro, List<String> siglasProcesso, List<String> formNames) {
  2.   final Query query = createQuery(filtro, siglasProcesso, false, formNames);
  3.   query.setFirstResult(filtro.getFirst());
  4.   query.setMaxResults(filtro.getCount());
  5.   query.setResultTransformer(new AliasToBeanResultTransformer(getResultClass()));
  6.   return query.list();
  7. }

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

  1. private List<Map<String, Serializable>> quickSearchMap(RequirementSearchContext query) {
  2.   return makeRequirementSearchQuery(query)
  3.       .setFirstResult(query.getQuickFilter().getFirst())
  4.       .setMaxResults(query.getQuickFilter().getCount())
  5.       .setResultTransformer(AliasToEntityMapResultTransformer.INSTANCE)
  6.       .list();
  7. }

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

query

相关文章

    查看更多

    热门标签

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

    最新文章

    更多

    Query类方法

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