|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.h2.result.SortOrder
public class SortOrder
A sort order represents an ORDER BY clause in a query.
Field Summary | |
---|---|
static int |
ASCENDING
This bit mask means the values should be sorted in ascending order. |
static int |
DESCENDING
This bit mask means the values should be sorted in descending order. |
static int |
NULLS_FIRST
This bit mask means NULLs should be sorted before other data, no matter if ascending or descending order is used. |
static int |
NULLS_LAST
This bit mask means NULLs should be sorted after other data, no matter if ascending or descending order is used. |
Constructor Summary | |
---|---|
SortOrder(Database database,
int[] index,
int[] sortType)
Construct a new sort order object. |
Method Summary | |
---|---|
int |
compare(Value[] a,
Value[] b)
Compare two expression lists. |
static int |
compareNull(boolean aNull,
boolean bNull,
int sortType)
Compare two expressions where one of them is NULL. |
int[] |
getIndexes()
Get the column index list. |
int[] |
getSortTypes()
Get the sort order bit masks. |
java.lang.String |
getSQL(Expression[] list,
int visible)
Create the SQL snippet that describes this sort order. |
void |
sort(ObjectArray<Value[]> rows)
Sort a list of rows. |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
---|
public static final int ASCENDING
public static final int DESCENDING
public static final int NULLS_FIRST
public static final int NULLS_LAST
Constructor Detail |
---|
public SortOrder(Database database, int[] index, int[] sortType)
database
- the databaseindex
- the column index listsortType
- the sort order bit masksMethod Detail |
---|
public java.lang.String getSQL(Expression[] list, int visible)
list
- the expression listvisible
- the number of columns in the select list
public static int compareNull(boolean aNull, boolean bNull, int sortType)
aNull
- whether the first expression is nullbNull
- whether the second expression is nullsortType
- the sort bit mask to use
public int compare(Value[] a, Value[] b) throws java.sql.SQLException
a
- the first expression listb
- the second expression list
java.sql.SQLException
public void sort(ObjectArray<Value[]> rows) throws java.sql.SQLException
rows
- the list of rows
java.sql.SQLException
public int[] getIndexes()
public int[] getSortTypes()
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |