Java Code Examples for org.hibernate.SQLQuery#setMaxResults()
The following examples show how to use
org.hibernate.SQLQuery#setMaxResults() .
You can vote up the ones you like or vote down the ones you don't like,
and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
Source File: BaseDao.java From JgFramework with Apache License 2.0 | 5 votes |
protected SQLQuery getQuery(String queryString, Map<String, Object> where, int start, int limit, boolean returnMap) { Session session = this.getSession(); SQLQuery query = null; if (start > -1 && limit > 0) { query = session.createSQLQuery(queryString); query.setFirstResult(start); query.setMaxResults(limit); } else { query = session.createSQLQuery(queryString); } if (where != null) { for (Entry<String, Object> entry : where.entrySet()) { Object value = entry.getValue(); String key = entry.getKey(); if (value instanceof Collection) { query.setParameterList(key, (Collection) value); } else if (value instanceof Object[]) { query.setParameterList(key, (Object[]) value); } else { query.setParameter(key, value); } } } if (returnMap) { query.setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP); } return query; }
Example 2
Source File: QueryUtil.java From ctsms with GNU Lesser General Public License v2.1 | 4 votes |
public static Query createSearchQuery(CriteriaInstantVO criteriaInstantVO, DBModule module, PSFVO psf, SessionFactory sessionFactory, CriterionTieDao criterionTieDao, CriterionPropertyDao criterionPropertyDao, CriterionRestrictionDao criterionRestrictionDao) throws Exception { ArrayList<QueryParameterValue> queryValues = new ArrayList<QueryParameterValue>(); HashMap<NamedParameterValues, Object> namedParameterValuesCache = new HashMap<NamedParameterValues, Object>(); StringBuilder sqlQuery = createSQLSetStatement(criteriaInstantVO, module, psf, sessionFactory, queryValues, createCriterionTieMap(criterionTieDao), createCriterionTieNameMap(criterionTieDao), createCriterionPropertyMap(module, criterionPropertyDao), createCriterionRestrictionMap(criterionRestrictionDao), null); Class rootEntityClass = getRootEntityClass(module); SQLQuery query; if (psf != null) { if (psf.getUpdateRowCount()) { StringBuilder countStatement = new StringBuilder("select count(*) from ("); countStatement.append(sqlQuery); countStatement.append(") as resultset"); Query countQuery = sessionFactory.getCurrentSession().createSQLQuery(countStatement.toString()); setQueryValues(countQuery, queryValues, namedParameterValuesCache); psf.setRowCount(new Long(countQuery.uniqueResult().toString())); } String sortField = psf.getSortField(); if (sortField != null && sortField.length() > 0) { // http://weblogs.sqlteam.com/jeffs/archive/2007/12/13/select-distinct-order-by-error.aspx sqlQuery.append(" order by "); sqlQuery.append(getPropertyColumnName(rootEntityClass, sortField, sessionFactory)); if (psf.getSortOrder()) { sqlQuery.append(" asc"); } else { sqlQuery.append(" desc"); } } query = sessionFactory.getCurrentSession().createSQLQuery(sqlQuery.toString()); if (psf.getFirst() != null) { query.setFirstResult(psf.getFirst()); } if (psf.getPageSize() != null) { query.setMaxResults(psf.getPageSize()); } } else { query = sessionFactory.getCurrentSession().createSQLQuery(sqlQuery.toString()); } setQueryValues(query, queryValues, namedParameterValuesCache); query.addEntity(rootEntityClass); return query; }