Class SelectStatement

java.lang.Object

SQLStatement

SelectStatement

public class SelectStatement
extends SQLStatement

A class that represents a SELECT statement.

Field Summary

Fields

Modifier and Type	Field and Description
static String	STAR

Constructor Summary

Constructors

Constructor and Description

SelectStatement(ArrayList<Object> selectList, ArrayList<Table> fromList, ConditionalExpression where, Limit limit, Boolean distinctSpecified) Constructs a SelectStatement object involving the specified columns and other objects from the SELECT clause, the specified tables from the FROM clause, the specified conditional expression from the WHERE clause (if any), the specified Limit object summarizing the LIMIT clause (if any), and the specified value indicating whether or not we should eliminate duplicates.

Method Summary

Modifier and Type	Method and Description
boolean	distinctSpecified() Returns a boolean value indicating whether duplicates should be eliminated in the result of this statement -- i.e., whether the user specified SELECT DISTINCT.
void	execute() Executes this SQL statement.

Methods inherited from class SQLStatement

addColumn, addColumnVal, addTable, getColumn, getColumnVal, getTable, getWhere, getWhereColumn, numColumns, numColumnVals, numTables, numWhereColumns, toString

Methods inherited from class java.lang.Object

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

Field Detail

STAR

public static final String STAR

See Also:

Constant Field Values

Constructor Detail

SelectStatement

public SelectStatement(ArrayList<Object> selectList,
                       ArrayList<Table> fromList,
                       ConditionalExpression where,
                       Limit limit,
                       Boolean distinctSpecified)

Constructs a SelectStatement object involving the specified columns and other objects from the SELECT clause, the specified tables from the FROM clause, the specified conditional expression from the WHERE clause (if any), the specified Limit object summarizing the LIMIT clause (if any), and the specified value indicating whether or not we should eliminate duplicates.

Parameters:

selectList - the columns and other objects from the SELECT clause

fromList - the list of tables from the FROM clause

where - the conditional expression from the WHERE clause (if any)

limit - summarizes the info in the LIMIT clause (if any)

distinctSpecified - should duplicates be eliminated?

Method Detail

distinctSpecified

public boolean distinctSpecified()

Returns a boolean value indicating whether duplicates should be eliminated in the result of this statement -- i.e., whether the user specified SELECT DISTINCT.

execute

public void execute()
             throws DatabaseException,
                    DeadlockException

Description copied from class: SQLStatement

Executes this SQL statement.

Specified by:

execute in class SQLStatement

Throws:

DatabaseException - if Berkeley DB encounters another problem accessing an underlying database.

DeadlockException - if deadlock occurs while accessing an underlying database.