public void initialize(Serializable key, SessionImplementor session) throws HibernateException { LOG.debugf("Initializing collection: %s using named query: %s", persister.getRole(), queryName); // TODO: is there a more elegant way than downcasting? AbstractQueryImpl query = (AbstractQueryImpl) session.getNamedSQLQuery(queryName); if (query.getNamedParameters().length > 0) { query.setParameter(query.getNamedParameters()[0], key, persister.getKeyType()); } else { query.setParameter(0, key, persister.getKeyType()); } query.setCollectionKey(key).setFlushMode(FlushMode.MANUAL).list(); }
/** * 根据分页请求参数与Query获取分页请求对象 * * @param request 分页请求参数对象 * @param query Hibernate Query * @return {@link Page} */ public <X> Page<X> findPage(PageRequest request, Query query) { Page<X> page = new Page<X>(request); if (request == null) { return page; } AbstractQueryImpl impl = (AbstractQueryImpl) query; String queryString = setPageRequestToHql(impl.getQueryString(), request); ReflectionUtils.setFieldValue(impl, "queryString", queryString); if (request.isCountTotal()) { long totalCount = 0; if (impl.hasNamedParameters()) { Map<String, TypedValue> map = ReflectionUtils.getFieldValue(impl, "namedParameters"); Map<String, Object> values = new HashMap<String, Object>(); for (Map.Entry<String, TypedValue> entry : map.entrySet()) { values.put(entry.getKey(), entry.getValue().getValue()); } totalCount = countHqlResult(impl.getQueryString(), values); } else { List<Object> values = ReflectionUtils.invokeGetter(impl, "values"); totalCount = countHqlResult(impl.getQueryString(), values.toArray()); } page.setTotalItems(totalCount); } impl.setFirstResult(request.getOffset()); impl.setMaxResults(request.getPageSize()); List result = impl.list(); page.setResult(result); return page; }
private int countGeneratedParameters(Query query) { AbstractQueryImpl hqlQueryImpl = (AbstractQueryImpl) query; return hqlQueryImpl.getParameterMetadata().getNamedParameterNames().size(); }