Package com.github.tadukoo.database.mysql.syntax.statement

Class SQLSelectStatement

java.lang.Object

com.github.tadukoo.database.mysql.syntax.statement.SQLSelectStatement

public class SQLSelectStatement
extends Object

SQL Select Statement is used to build a MySQL select statement

Version:

Alpha v.0.3

Author:

Logan Ferree (Tadukoo)

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static interface	SQLSelectStatement.Build	The building part of building a SQLSelectStatement
static interface	SQLSelectStatement.ColumnsOrTables	The Columns and Tables part of building a SQLSelectStatement
static interface	SQLSelectStatement.DistinctOrColumnsOrTables	The distinct of columns or Tables part of building a SQLSelectStatement
static interface	SQLSelectStatement.FromTables	The Tables part of building a SQLSelectStatement
static class	SQLSelectStatement.SQLSelectStatementBuilder	A builder to build a SQLSelectStatement.
static interface	SQLSelectStatement.WhereStatementAndBuild	The Where Statement and building part of building a SQLSelectStatement

Field Summary

Fields

Modifier and Type	Field	Description
private final boolean	distinct	Whether to select distinct columns or not
private final List<TableRef>	fromTables	The tables to grab data from
private final List<ColumnRef>	returnColumns	The columns to be selected
private final Conditional	whereStatement	The conditional where statement

Constructor Summary

Constructors

Modifier	Constructor	Description
private	SQLSelectStatement(boolean distinct, List<ColumnRef> returnColumns, List<TableRef> fromTables, Conditional whereStatement)	Constructs a new SQLSelectStatement using the given parameters.

Method Summary

Modifier and Type	Method	Description
static SQLSelectStatement.DistinctOrColumnsOrTables	builder()
List<TableRef>	getFromTables()
List<ColumnRef>	getReturnColumns()
Conditional	getWhereStatement()
boolean	isDistinct()
String	toString()

Methods inherited from class java.lang.Object

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

Field Details

distinct

private final boolean distinct

Whether to select distinct columns or not

returnColumns

private final List<ColumnRef> returnColumns

The columns to be selected

fromTables

private final List<TableRef> fromTables

The tables to grab data from

whereStatement

private final Conditional whereStatement

The conditional where statement

Constructor Details

SQLSelectStatement

private SQLSelectStatement(boolean distinct,
 List<ColumnRef> returnColumns,
 List<TableRef> fromTables,
 Conditional whereStatement)

Constructs a new SQLSelectStatement using the given parameters.

Parameters:

distinct - Whether to select distinct columns or not

returnColumns - The columns to be selected

fromTables - The tables to grab data from

whereStatement - The conditional where statement

Method Details

builder

public static SQLSelectStatement.DistinctOrColumnsOrTables builder()

Returns:

A new builder to build a SQLSelectStatement

isDistinct

public boolean isDistinct()

Returns:

Whether to select distinct columns or not

getReturnColumns

public List<ColumnRef> getReturnColumns()

Returns:

The columns to be selected

getFromTables

public List<TableRef> getFromTables()

Returns:

The tables to grab data from

getWhereStatement

public Conditional getWhereStatement()

Returns:

The conditional where statement

toString

public String toString()

Overrides:

toString in class Object