Example usage for org.hibernate.criterion Order toSqlString

Introduction

In this page you can find the example usage for org.hibernate.criterion Order toSqlString.

Prototype

public String toSqlString(Criteria criteria, CriteriaQuery criteriaQuery) 

Source Link

Document

Render the SQL fragment

Usage

From source file:com.gisgraphy.hibernate.criterion.ProjectionOrder.java

License:Open Source License

@Override
public String toSqlString(Criteria criteria, CriteriaQuery criteriaQuery) throws HibernateException {
    Order nso = new NativeSQLOrder(criteriaQuery.getColumnsUsingProjection(criteria, aliasName)[0],
            this.ascending);
    return nso.toSqlString(criteria, criteriaQuery);

}

---

From source file:org.iternine.jeppetto.dao.hibernate.HibernateQueryModelDAO.java

License:Apache License

private void buildOrderClause(StringBuilder queryStringBuilder, QueryModel queryModel, Criteria criteria,
        CriteriaQueryTranslator criteriaQueryTranslator) {
    boolean firstOrderItem = true;

    if (queryModel.getSorts() != null) {
        for (Sort sort : queryModel.getSorts()) {
            if (firstOrderItem) {
                queryStringBuilder.append(" order by ");
            } else {
                queryStringBuilder.append(',');
            }/*from   w w w  . ja  va2s. co m*/

            Order order = sort.getSortDirection() == SortDirection.Ascending ? Order.asc(sort.getField())
                    : Order.desc(sort.getField());

            queryStringBuilder.append(order.toSqlString(criteria, criteriaQueryTranslator));

            firstOrderItem = false;
        }
    }
}

---