Module com.aoindustries.aoserv.client

Package com.aoindustries.aoserv.client.sql

Class SqlSelect

java.lang.Object

com.aoindustries.aoserv.client.sql.SqlSelect

public final class SqlSelect
extends Object

Represents a parsed SELECT statement.

Author:

AO Industries, Inc.

Field Summary

Fields

Modifier and Type	Field	Description
static final String	BY	The case-insensitive BY keyword.
static final String	FROM	The case-insensitive FROM keyword.
static final String	ORDER	The case-insensitive ORDER keyword.
static final String	SELECT	The case-insensitive SELECT keyword.

Constructor Summary

Constructors

Constructor	Description
SqlSelect(List<SqlExpression> expressions, Table fromTable, List<SqlOrderByExpression> orderBy)

Method Summary

Modifier and Type	Method	Description
void	execute(AoservConnector connector, Appendable out, boolean isInteractive)	Executes the query for display output.
List<SqlExpression>	getExpressions()	SqlExpression.isAggregate() on every expression will match isAggregate().
Table	getFromTable()
List<SqlOrderByExpression>	getOrderBy()
boolean	isAggregate()
String	toString()

Methods inherited from class java.lang.Object

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

Field Details

SELECT

public static final String SELECT

The case-insensitive SELECT keyword.

See Also:

• Constant Field Values

FROM

public static final String FROM

The case-insensitive FROM keyword.

See Also:

• Constant Field Values

ORDER

public static final String ORDER

The case-insensitive ORDER keyword.

See Also:

• Constant Field Values

BY

public static final String BY

The case-insensitive BY keyword.

See Also:

• Constant Field Values

Constructor Details

SqlSelect

public SqlSelect(List<SqlExpression> expressions,
 Table fromTable,
 List<SqlOrderByExpression> orderBy)
          throws IllegalArgumentException

Throws:

IllegalArgumentException

Method Details

toString

public String toString()

Overrides:

toString in class Object

isAggregate

public boolean isAggregate()

getExpressions

public List<SqlExpression> getExpressions()

SqlExpression.isAggregate() on every expression will match isAggregate(). Mixed aggregate and non-aggregate not currently supported.

getFromTable

public Table getFromTable()

getOrderBy

public List<SqlOrderByExpression> getOrderBy()

execute

public void execute(AoservConnector connector,
 Appendable out,
 boolean isInteractive)
             throws IOException,
SQLException

Executes the query for display output. TODO: This does not yet implement WHERE, so does not yet have any query planner phase. TODO: This implementation writes to the given out, and has not yet been split into separate execute and display phases.

Throws:

IOException

SQLException