Package com.github.eikecochu.sqlbuilder

Class OrderBy

java.lang.Object

com.github.eikecochu.sqlbuilder.QueryPartImpl<OrderBy>

com.github.eikecochu.sqlbuilder.OrderBy

All Implemented Interfaces:

BeforeUnion<OrderBy>, QueryBuilder<OrderBy>, QueryPart, QueryPartLinked<OrderBy>, QueryPartSQL<OrderBy>

public class OrderBy
extends QueryPartImpl<OrderBy>
implements QueryBuilder<OrderBy>, BeforeUnion<OrderBy>

The ORDER BY expression. Allows ordering the selected data with multiple columns.

Constructor Summary

Constructors

Modifier	Constructor	Description
protected	OrderBy(BeforeOrderBy<?> parent)

Method Summary

Modifier and Type	Method	Description
OrderBy	asc(java.lang.String name)	Order ascending by a column
OrderBy	column(java.lang.String name)	Add a column to order by.
OrderBy	column(java.lang.String name, boolean ascending)	Order by a column name and ascending or descending
OrderBy	columns(java.lang.String... names)	Order by multiple columns
OrderBy	desc(java.lang.String name)	Order descending by a column
java.lang.String	string(QueryOptions options)	Transforms this statement into an SQL string

Methods inherited from class com.github.eikecochu.sqlbuilder.QueryPartImpl

parent, sql

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface com.github.eikecochu.sqlbuilder.BeforeUnion

union, union, unionAll, unionSQL

Methods inherited from interface com.github.eikecochu.sqlbuilder.QueryBuilder

query, query

Methods inherited from interface com.github.eikecochu.sqlbuilder.QueryPart

string

Methods inherited from interface com.github.eikecochu.sqlbuilder.QueryPartLinked

ext, parent, parent

Methods inherited from interface com.github.eikecochu.sqlbuilder.QueryPartSQL

sql

Constructor Detail

OrderBy

protected OrderBy(BeforeOrderBy<?> parent)

Method Detail

column

public OrderBy column(java.lang.String name,
                      boolean ascending)

Order by a column name and ascending or descending

Parameters:

name - The column name to order by

ascending - true for ascending order, false for descending order

Returns:

This ORDER BY statement

column

public OrderBy column(java.lang.String name)

Add a column to order by. Column name can also contain order direction, e.g. "COL DESC"

Parameters:

name - The column name to order by, including optional order direction

Returns:

This ORDER BY statement

columns

public OrderBy columns(java.lang.String... names)

Order by multiple columns

Parameters:

names - The column names to order by

Returns:

This ORDER BY statement

asc

public OrderBy asc(java.lang.String name)

Order ascending by a column

Parameters:

name - The column name to order by in ascending order

Returns:

This ORDER BY statement

desc

public OrderBy desc(java.lang.String name)

Order descending by a column

Parameters:

name - The column name to order by in descending order

Returns:

This ORDER BY statement

string

public java.lang.String string(QueryOptions options)

Description copied from interface: QueryPart

Transforms this statement into an SQL string

Specified by:

string in interface QueryPart

Parameters:

options - The QueryOptions to apply for transformation

Returns:

The created SQL string