protected Order(String propertyName,
    boolean ascending) 
{
		this.propertyName = propertyName;
		this.ascending = ascending;
}

Constructor for Order.

 public static Order asc(String propertyName) 
{
		return new Order(propertyName, true);
}

Ascending order

 public static Order desc(String propertyName) 
{
		return new Order(propertyName, false);
}

Descending order

 public Order ignoreCase() 
{
		ignoreCase = true;
		return this;
}

 public String toSqlString(Criteria criteria,
    CriteriaQuery criteriaQuery) throws HibernateException 
{
		String[] columns = criteriaQuery.getColumnsUsingProjection(criteria, propertyName);
		Type type = criteriaQuery.getTypeUsingProjection(criteria, propertyName);
		StringBuffer fragment = new StringBuffer();
		for ( int i=0; i< columns.length; i++ ) {
			SessionFactoryImplementor factory = criteriaQuery.getFactory();
			boolean lower = ignoreCase && type.sqlTypes( factory )[i]==Types.VARCHAR;
			if (lower) {
				fragment.append( factory.getDialect().getLowercaseFunction() )
					.append('(");
			}
			fragment.append( columns[i] );
			if (lower) fragment.append(')");
			fragment.append( ascending ? " asc" : " desc" );
			if ( i< columns.length-1 ) fragment.append(", ");
		}
		return fragment.toString();
}

Render the SQL fragment

 public String toString() 
{
		return propertyName + ' " + (ascending?"asc":"desc");
}