org.ephman.abra.database
Class SortCriteria

java.lang.Object
  extended byorg.ephman.abra.database.SortCriteria
Direct Known Subclasses:
SortAndLimitCriteria

public class SortCriteria
extends java.lang.Object


Field Summary
protected  java.util.Vector sortExpressions
           
protected  java.lang.String tableAlias
           
 
Constructor Summary
SortCriteria()
          Create a new SortCriteria - this object will be used to sort result of a query in a specific way.
SortCriteria(java.lang.String column, boolean ascending)
          create a new sc with an inital column, asc
 
Method Summary
 void addCriteria(java.lang.String column, boolean ascending)
          Add a sort criteria.
 java.util.Vector getSortExpressions()
          Return a vector of sort expressions
 void setTableAlias(java.lang.String alias)
           
 java.lang.String toString()
          Return the SQL string that can be used in a query to sort the query result.
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Field Detail

sortExpressions

protected java.util.Vector sortExpressions

tableAlias

protected java.lang.String tableAlias
Constructor Detail

SortCriteria

public SortCriteria()
Create a new SortCriteria - this object will be used to sort result of a query in a specific way.


SortCriteria

public SortCriteria(java.lang.String column,
                    boolean ascending)
create a new sc with an inital column, asc

Method Detail

setTableAlias

public void setTableAlias(java.lang.String alias)

getSortExpressions

public java.util.Vector getSortExpressions()
Return a vector of sort expressions


addCriteria

public void addCriteria(java.lang.String column,
                        boolean ascending)
Add a sort criteria.

Parameters:
column - name of the column to sort on
ascending - if true, the sort will use ascending order

toString

public java.lang.String toString()
Return the SQL string that can be used in a query to sort the query result. The format of the string is: 'order by colA ascending, colB descending, ...' etc If no sort criteria has been specified, an empty string will be returned.