Index (SQLBuilder 1.1 API)

A B C D E F G H I J K L N O P Q R S T U V W
All Classes All Packages

A

add(String) - Method in class com.github.eikecochu.sqlbuilder.StringJoiner
add(String, Object) - Method in class com.github.eikecochu.sqlbuilder.Values: Add a value
all() - Method in class com.github.eikecochu.sqlbuilder.Select: Enable ALL selection.
all() - Method in class com.github.eikecochu.sqlbuilder.Union
all(boolean) - Method in class com.github.eikecochu.sqlbuilder.Union
all(QueryBuilder) - Method in class com.github.eikecochu.sqlbuilder.ConditionValue: Set a subquery to be used as condition with restriction ALL
ALL - com.github.eikecochu.sqlbuilder.ConditionValue.ConditionValueType
and() - Method in class com.github.eikecochu.sqlbuilder.Conditionable: Connect the previous and next condition with the AND operator
AND - com.github.eikecochu.sqlbuilder.Conditionable.Operator
any(QueryBuilder) - Method in class com.github.eikecochu.sqlbuilder.ConditionValue: Set a subquery to be used as condition with restriction ANY
ANY - com.github.eikecochu.sqlbuilder.ConditionValue.ConditionValueType
as(QueryBuilder) - Method in class com.github.eikecochu.sqlbuilder.With: Use a subquery as the body of this WITH statement
asc(String) - Method in class com.github.eikecochu.sqlbuilder.OrderBy: Order ascending by a column

B

BeforeDelete - Interface in com.github.eikecochu.sqlbuilder: Implemented by keywords that precede the DELETE statement.
BeforeFrom - Interface in com.github.eikecochu.sqlbuilder: Implemented by keywords that precede the FROM statement.
BeforeGroupBy - Interface in com.github.eikecochu.sqlbuilder: Implemented by keywords that precede the GROUP BY statement.
BeforeHaving - Interface in com.github.eikecochu.sqlbuilder: Implemented by keywords that precede the HAVING statement.
BeforeInsert - Interface in com.github.eikecochu.sqlbuilder: Implemented by keywords that precede the INSERT statement.
BeforeJoin - Interface in com.github.eikecochu.sqlbuilder: Implemented by keywords that precede the JOIN statement.
BeforeOrderBy - Interface in com.github.eikecochu.sqlbuilder: Implemented by keywords that precede the ORDER BY statement.
BeforeSelect - Interface in com.github.eikecochu.sqlbuilder: Implemented by keywords that precede the SELECT statement.
BeforeUnion - Interface in com.github.eikecochu.sqlbuilder
BeforeUpdate - Interface in com.github.eikecochu.sqlbuilder: Implemented by keywords that precede the UPDATE statement.
BeforeWhere - Interface in com.github.eikecochu.sqlbuilder: Implemented by keywords that precede the WHERE statement.
BeforeWith - Interface in com.github.eikecochu.sqlbuilder: Implemented by keywords that precede the WITH statement.
between() - Method in class com.github.eikecochu.sqlbuilder.ConditionPart: The BETWEEN operator
between(Object, Object) - Method in class com.github.eikecochu.sqlbuilder.ConditionPart: The BETWEEN operator
BETWEEN - com.github.eikecochu.sqlbuilder.ConditionPart.Operator

C

cased(String) - Method in class com.github.eikecochu.sqlbuilder.QueryOptions
col(String) - Method in class com.github.eikecochu.sqlbuilder.Conditionable: Use a column as constraint
col(String) - Method in class com.github.eikecochu.sqlbuilder.ConditionValue: Set a column to be constrained
col(String, Object) - Method in class com.github.eikecochu.sqlbuilder.Conditionable: Compare a column to a value
col(String, Object...) - Method in class com.github.eikecochu.sqlbuilder.Conditionable: Compare a column to multiple values
column(String) - Method in class com.github.eikecochu.sqlbuilder.GroupBy: Group by column name
column(String) - Method in class com.github.eikecochu.sqlbuilder.Insert: Use a column to insert values into
column(String) - Method in class com.github.eikecochu.sqlbuilder.OrderBy: Add a column to order by.
column(String) - Method in class com.github.eikecochu.sqlbuilder.Select: Select a column by name
column(String) - Method in class com.github.eikecochu.sqlbuilder.With: Add a column to this WITH statement
column(String, boolean) - Method in class com.github.eikecochu.sqlbuilder.OrderBy: Order by a column name and ascending or descending
column(String, Object) - Method in class com.github.eikecochu.sqlbuilder.Insert: Insert a value into a column by name
COLUMN - com.github.eikecochu.sqlbuilder.ConditionValue.ConditionValueType
columns(ValueHolder) - Method in class com.github.eikecochu.sqlbuilder.Insert: Insert multiple values by ValueHolder
columns(String...) - Method in class com.github.eikecochu.sqlbuilder.GroupBy: Group by column names
columns(String...) - Method in class com.github.eikecochu.sqlbuilder.OrderBy: Order by multiple columns
columns(String...) - Method in class com.github.eikecochu.sqlbuilder.Select: Select multiple columns by name
columns(String...) - Method in class com.github.eikecochu.sqlbuilder.With: Add multiple columns to this WITH statement
com.github.eikecochu.sqlbuilder - package com.github.eikecochu.sqlbuilder
com.github.eikecochu.sqlbuilder.oracle - package com.github.eikecochu.sqlbuilder.oracle
condition(ConditionPart.Operator, ConditionValue.ConditionValueType, Object) - Method in class com.github.eikecochu.sqlbuilder.ConditionPart
condition(ConditionPart.Operator, ConditionValue.ConditionValueType, Object[]) - Method in class com.github.eikecochu.sqlbuilder.ConditionPart
Condition - Class in com.github.eikecochu.sqlbuilder: Condition to multiple statements, for example WHERE, JOIN etc.
Condition() - Constructor for class com.github.eikecochu.sqlbuilder.Condition
Conditionable<T extends Conditionable<T>> - Class in com.github.eikecochu.sqlbuilder: Abstract base class for condition like statements, generic to allow multiple origins, for example from WHERE, JOIN etc.
Conditionable() - Constructor for class com.github.eikecochu.sqlbuilder.Conditionable
Conditionable(QueryPart) - Constructor for class com.github.eikecochu.sqlbuilder.Conditionable
Conditionable.Operator - Enum in com.github.eikecochu.sqlbuilder
ConditionBiValue(ConditionPart<T>, ConditionPart.Operator) - Constructor for class com.github.eikecochu.sqlbuilder.ConditionValue.ConditionBiValue
ConditionPart<T extends Conditionable<T>> - Class in com.github.eikecochu.sqlbuilder
ConditionPart(Conditionable<T>, String) - Constructor for class com.github.eikecochu.sqlbuilder.ConditionPart
ConditionPart.Operator - Enum in com.github.eikecochu.sqlbuilder
ConditionValue<T extends Conditionable<T>> - Class in com.github.eikecochu.sqlbuilder
ConditionValue(ConditionPart<T>, ConditionPart.Operator) - Constructor for class com.github.eikecochu.sqlbuilder.ConditionValue
ConditionValue.ConditionBiValue<T extends Conditionable<T>> - Class in com.github.eikecochu.sqlbuilder
ConditionValue.ConditionValueType - Enum in com.github.eikecochu.sqlbuilder
connectBy() - Method in class com.github.eikecochu.sqlbuilder.oracle.ConnectBy
connectBy() - Method in class com.github.eikecochu.sqlbuilder.oracle.StartWith
ConnectBy - Class in com.github.eikecochu.sqlbuilder.oracle
ConnectBy(QueryPart) - Constructor for class com.github.eikecochu.sqlbuilder.oracle.ConnectBy
convert(Class<T>, Function<T, Object>) - Method in class com.github.eikecochu.sqlbuilder.QueryOptions: Register a converter for a specific class to be used for value conversion
copy() - Method in class com.github.eikecochu.sqlbuilder.QueryOptions
CROSS_JOIN - com.github.eikecochu.sqlbuilder.Join.JoinMode
crossJoin() - Method in interface com.github.eikecochu.sqlbuilder.BeforeJoin: Continue query with CROSS JOIN
crossJoin(Table) - Method in interface com.github.eikecochu.sqlbuilder.BeforeJoin: Continue query with CROSS JOIN
crossJoin(String) - Method in interface com.github.eikecochu.sqlbuilder.BeforeJoin: Continue query with CROSS JOIN
cycle() - Method in class com.github.eikecochu.sqlbuilder.oracle.ConnectBy

D

defaults() - Method in class com.github.eikecochu.sqlbuilder.Insert: Resets this INSERT statement columns and values
delete(Delete) - Method in interface com.github.eikecochu.sqlbuilder.BeforeDelete: Accept an existing DELETE statement as predecessor
delete(Table) - Method in interface com.github.eikecochu.sqlbuilder.BeforeDelete: Continue query with DELETE
delete(String) - Method in interface com.github.eikecochu.sqlbuilder.BeforeDelete: Continue query with DELETE
Delete - Class in com.github.eikecochu.sqlbuilder
Delete(BeforeDelete, String) - Constructor for class com.github.eikecochu.sqlbuilder.Delete
Delete(Table) - Constructor for class com.github.eikecochu.sqlbuilder.Delete: Create a new DELETE statement
Delete(String) - Constructor for class com.github.eikecochu.sqlbuilder.Delete: Create a new DELETE statement
Delete(Table) - Static method in class com.github.eikecochu.sqlbuilder.SQLBuilder: Start with an DELETE statement
Delete(String) - Static method in class com.github.eikecochu.sqlbuilder.SQLBuilder: Start with an DELETE statement
deleteSQL(String) - Method in interface com.github.eikecochu.sqlbuilder.BeforeDelete: Use plain SQL to form this DELETE statement
desc(String) - Method in class com.github.eikecochu.sqlbuilder.OrderBy: Order descending by a column
distinct() - Method in class com.github.eikecochu.sqlbuilder.Select: Enable DISTINCT selection.
distinct() - Method in class com.github.eikecochu.sqlbuilder.Union

E

eq() - Method in class com.github.eikecochu.sqlbuilder.ConditionPart: The EQUALS operator
eq(Object) - Method in class com.github.eikecochu.sqlbuilder.ConditionPart: The EQUALS operator.
eqCol(String) - Method in class com.github.eikecochu.sqlbuilder.ConditionPart: Set a column to be constrained
eqExpr(String, Object...) - Method in class com.github.eikecochu.sqlbuilder.ConditionPart: Set an expression to be used as condition
EQUALS - com.github.eikecochu.sqlbuilder.ConditionPart.Operator
exists(QueryBuilder) - Method in class com.github.eikecochu.sqlbuilder.Where
exists(String) - Method in class com.github.eikecochu.sqlbuilder.Where
Exists - Class in com.github.eikecochu.sqlbuilder
Exists(QueryBuilder) - Constructor for class com.github.eikecochu.sqlbuilder.Exists
expr(Expression) - Method in class com.github.eikecochu.sqlbuilder.ConditionValue: Set an expression to be used as condition
expr(String) - Method in class com.github.eikecochu.sqlbuilder.Update.UpdateValue: Use an expression to update the value
expr(String, Object...) - Method in class com.github.eikecochu.sqlbuilder.ConditionValue: Set an expression to be used as condition
Expression - Class in com.github.eikecochu.sqlbuilder
Expression(String, Object...) - Constructor for class com.github.eikecochu.sqlbuilder.Expression
EXPRESSION - com.github.eikecochu.sqlbuilder.ConditionValue.ConditionValueType
ext(U) - Method in class com.github.eikecochu.sqlbuilder.QueryPartImpl: Continue the building chain with any element, for example custom implemented expressions.

F

FETCH_ALL - Static variable in class com.github.eikecochu.sqlbuilder.QueryOptions
fetchAll() - Method in class com.github.eikecochu.sqlbuilder.QueryOptions: Fetch all columns on query
fetchFirst() - Method in class com.github.eikecochu.sqlbuilder.QueryOptions: Fetch the first row only on query
from() - Method in interface com.github.eikecochu.sqlbuilder.BeforeFrom: Continue query with FROM
from(From) - Method in interface com.github.eikecochu.sqlbuilder.BeforeFrom: Accept an existing FROM statement as predecessor
from(Table...) - Method in interface com.github.eikecochu.sqlbuilder.BeforeFrom: Continue query with FROM
from(String...) - Method in interface com.github.eikecochu.sqlbuilder.BeforeFrom: Continue query with FROM
From - Class in com.github.eikecochu.sqlbuilder
From(BeforeFrom) - Constructor for class com.github.eikecochu.sqlbuilder.From
fromSQL(String) - Method in interface com.github.eikecochu.sqlbuilder.BeforeFrom: Use plain SQL to form this FROM statement
fullOuterJoin() - Method in interface com.github.eikecochu.sqlbuilder.BeforeJoin: Continue query with FULL OUTER JOIN
fullOuterJoin(Table) - Method in interface com.github.eikecochu.sqlbuilder.BeforeJoin: Continue query with FULL OUTER JOIN
fullOuterJoin(String) - Method in interface com.github.eikecochu.sqlbuilder.BeforeJoin: Continue query with FULL OUTER JOIN

G

ge() - Method in class com.github.eikecochu.sqlbuilder.ConditionPart: The GREATER EQUALS operator
ge(Object) - Method in class com.github.eikecochu.sqlbuilder.ConditionPart: The GREATER EQUALS operator.
GE - com.github.eikecochu.sqlbuilder.ConditionPart.Operator
getDefaultOptions() - Static method in class com.github.eikecochu.sqlbuilder.QueryOptions: Returns the default options
group(Condition) - Method in class com.github.eikecochu.sqlbuilder.Conditionable: Include a subgroup in the condition
groupBy() - Method in interface com.github.eikecochu.sqlbuilder.BeforeGroupBy: Continue query with GROUP BY
groupBy(GroupBy) - Method in interface com.github.eikecochu.sqlbuilder.BeforeGroupBy: Accept an existing GROUP BY statement as predecessor
groupBy(String...) - Method in interface com.github.eikecochu.sqlbuilder.BeforeGroupBy: Continue query with GROUP BY
GroupBy - Class in com.github.eikecochu.sqlbuilder
GroupBy(BeforeGroupBy) - Constructor for class com.github.eikecochu.sqlbuilder.GroupBy
groupBySQL(String) - Method in interface com.github.eikecochu.sqlbuilder.BeforeGroupBy: Use plain SQL to form this GROUP BY statement
groupStart() - Method in class com.github.eikecochu.sqlbuilder.Conditionable: Start a nested condition group
gt() - Method in class com.github.eikecochu.sqlbuilder.ConditionPart: The GREATER THAN operator
gt(Object) - Method in class com.github.eikecochu.sqlbuilder.ConditionPart: The GREATER THAN operator.
GT - com.github.eikecochu.sqlbuilder.ConditionPart.Operator

H

having() - Method in interface com.github.eikecochu.sqlbuilder.BeforeHaving: Continue query with HAVING
having(Having) - Method in interface com.github.eikecochu.sqlbuilder.BeforeHaving: Accept an existing HAVING statement as predecessor
Having - Class in com.github.eikecochu.sqlbuilder
Having(BeforeHaving) - Constructor for class com.github.eikecochu.sqlbuilder.Having
havingSQL(String) - Method in interface com.github.eikecochu.sqlbuilder.BeforeHaving: Use plain SQL to form this HAVING statement

I

in() - Method in class com.github.eikecochu.sqlbuilder.ConditionPart: The IN operator
in(Iterable<Object>) - Method in class com.github.eikecochu.sqlbuilder.ConditionPart: The IN operator.
in(Object...) - Method in class com.github.eikecochu.sqlbuilder.ConditionPart: The IN operator.
IN - com.github.eikecochu.sqlbuilder.ConditionPart.Operator
indentString() - Method in class com.github.eikecochu.sqlbuilder.QueryOptions
INNER_JOIN - com.github.eikecochu.sqlbuilder.Join.JoinMode
innerJoin() - Method in interface com.github.eikecochu.sqlbuilder.BeforeJoin: Continue query with INNER JOIN
innerJoin(Table) - Method in interface com.github.eikecochu.sqlbuilder.BeforeJoin: Continue query with INNER JOIN
innerJoin(String) - Method in interface com.github.eikecochu.sqlbuilder.BeforeJoin: Continue query with INNER JOIN
insert(Insert) - Method in interface com.github.eikecochu.sqlbuilder.BeforeInsert: Accept an existing INSERT statement as predecessor
insert(Table) - Method in interface com.github.eikecochu.sqlbuilder.BeforeInsert: Continue query with INSERT
insert(String) - Method in interface com.github.eikecochu.sqlbuilder.BeforeInsert: Continue query with INSERT
Insert - Class in com.github.eikecochu.sqlbuilder
Insert(BeforeInsert, String) - Constructor for class com.github.eikecochu.sqlbuilder.Insert
Insert(Table) - Constructor for class com.github.eikecochu.sqlbuilder.Insert: Create a new INSERT statement
Insert(String) - Constructor for class com.github.eikecochu.sqlbuilder.Insert: Create a new INSERT statement
Insert(Table) - Static method in class com.github.eikecochu.sqlbuilder.SQLBuilder: Start with an INSERT statement
Insert(String) - Static method in class com.github.eikecochu.sqlbuilder.SQLBuilder: Start with an INSERT statement
insertSQL(String) - Method in interface com.github.eikecochu.sqlbuilder.BeforeInsert: Use plain SQL to form this INSERT statement
InsertValue - Class in com.github.eikecochu.sqlbuilder
InsertValue(Insert, String) - Constructor for class com.github.eikecochu.sqlbuilder.InsertValue
IS_NOT_NULL - com.github.eikecochu.sqlbuilder.ConditionPart.Operator
IS_NULL - com.github.eikecochu.sqlbuilder.ConditionPart.Operator
isKeyword(String) - Static method in class com.github.eikecochu.sqlbuilder.Name: Returns true if the passed string is recognized as a keyword.
isNull() - Method in class com.github.eikecochu.sqlbuilder.ConditionPart: The IS NULL operator
iterator() - Method in class com.github.eikecochu.sqlbuilder.Values

J

join() - Method in interface com.github.eikecochu.sqlbuilder.BeforeJoin: Continue query with INNER JOIN
join(Join) - Method in interface com.github.eikecochu.sqlbuilder.BeforeJoin: Accept an existing JOIN statement as predecessor
join(Join.JoinMode) - Method in interface com.github.eikecochu.sqlbuilder.BeforeJoin: Continue query with the passed JOIN mode
join(Table) - Method in interface com.github.eikecochu.sqlbuilder.BeforeJoin: Continue query with JOIN
join(String) - Method in interface com.github.eikecochu.sqlbuilder.BeforeJoin: Continue query with JOIN
Join - Class in com.github.eikecochu.sqlbuilder
Join(BeforeJoin) - Constructor for class com.github.eikecochu.sqlbuilder.Join
Join(BeforeJoin, Join.JoinMode) - Constructor for class com.github.eikecochu.sqlbuilder.Join
Join.JoinMode - Enum in com.github.eikecochu.sqlbuilder
joinSQL(String) - Method in interface com.github.eikecochu.sqlbuilder.BeforeJoin: Use plain SQL to form this JOIN statement

K

KEYWORDS - Static variable in class com.github.eikecochu.sqlbuilder.Name

L

le() - Method in class com.github.eikecochu.sqlbuilder.ConditionPart: The LESSER EQUALS operator
le(Object) - Method in class com.github.eikecochu.sqlbuilder.ConditionPart: The LESSER EQUALS operator.
LE - com.github.eikecochu.sqlbuilder.ConditionPart.Operator
LEFT_JOIN - com.github.eikecochu.sqlbuilder.Join.JoinMode
leftJoin() - Method in interface com.github.eikecochu.sqlbuilder.BeforeJoin: Continue query with LEFT JOIN
leftJoin(Table) - Method in interface com.github.eikecochu.sqlbuilder.BeforeJoin: Continue query with LEFT JOIN
leftJoin(String) - Method in interface com.github.eikecochu.sqlbuilder.BeforeJoin: Continue query with LEFT JOIN
leftOuterJoin() - Method in interface com.github.eikecochu.sqlbuilder.BeforeJoin: Continue query with LEFT OUTER JOIN
leftOuterJoin(Table) - Method in interface com.github.eikecochu.sqlbuilder.BeforeJoin: Continue query with LEFT OUTER JOIN
leftOuterJoin(String) - Method in interface com.github.eikecochu.sqlbuilder.BeforeJoin: Continue query with LEFT OUTER JOIN
like() - Method in class com.github.eikecochu.sqlbuilder.ConditionPart: The LIKE operator
like(Object) - Method in class com.github.eikecochu.sqlbuilder.ConditionPart: The LIKE operator.
LIKE - com.github.eikecochu.sqlbuilder.ConditionPart.Operator
lt() - Method in class com.github.eikecochu.sqlbuilder.ConditionPart: The LESSER THAN operator
lt(Object) - Method in class com.github.eikecochu.sqlbuilder.ConditionPart: The LESSER THAN operator.
LT - com.github.eikecochu.sqlbuilder.ConditionPart.Operator

N

Name - Class in com.github.eikecochu.sqlbuilder
Name() - Constructor for class com.github.eikecochu.sqlbuilder.Name
NestedCondition<T extends Conditionable<T>> - Class in com.github.eikecochu.sqlbuilder: Condition to multiple statements, for example WHERE, JOIN etc.
newLine() - Method in class com.github.eikecochu.sqlbuilder.QueryOptions
newLine(boolean) - Method in class com.github.eikecochu.sqlbuilder.QueryOptions
nocycle() - Method in class com.github.eikecochu.sqlbuilder.oracle.ConnectBy
not() - Method in class com.github.eikecochu.sqlbuilder.ConditionPart: The NOT operator
NOT_EQUALS - com.github.eikecochu.sqlbuilder.ConditionPart.Operator
notEmpty() - Method in class com.github.eikecochu.sqlbuilder.StringJoiner
notEq() - Method in class com.github.eikecochu.sqlbuilder.ConditionPart: The NOT EQUALS operator
notEq(Object) - Method in class com.github.eikecochu.sqlbuilder.ConditionPart: The NOT EQUALS operator.

O

on() - Method in class com.github.eikecochu.sqlbuilder.Join: Set join conditions
or() - Method in class com.github.eikecochu.sqlbuilder.Conditionable: Connect the previous and next condition with the OR operator
OR - com.github.eikecochu.sqlbuilder.Conditionable.Operator
orAbort() - Method in class com.github.eikecochu.sqlbuilder.Insert: Set this INSERT statement to be INSERT OR ABORT
orAbort() - Method in class com.github.eikecochu.sqlbuilder.Update: Set this UPDATE statement to be UPDATE OR ABORT
orderBy() - Method in interface com.github.eikecochu.sqlbuilder.BeforeOrderBy: Continue query with ORDER BY
orderBy(OrderBy) - Method in interface com.github.eikecochu.sqlbuilder.BeforeOrderBy: Accept an existing ORDER BY statement as predecessor
orderBy(String...) - Method in interface com.github.eikecochu.sqlbuilder.BeforeOrderBy: Continue query with ORDER BY
OrderBy - Class in com.github.eikecochu.sqlbuilder
OrderBy(BeforeOrderBy) - Constructor for class com.github.eikecochu.sqlbuilder.OrderBy
orderBySQL(String) - Method in interface com.github.eikecochu.sqlbuilder.BeforeOrderBy: Use plain SQL to form this ORDER BY statement
orFail() - Method in class com.github.eikecochu.sqlbuilder.Insert: Set this INSERT statement to be INSERT OR FAIL
orFail() - Method in class com.github.eikecochu.sqlbuilder.Update: Set this UPDATE statement to be UPDATE OR FAIL
orIgnore() - Method in class com.github.eikecochu.sqlbuilder.Insert: Set this INSERT statement to be INSERT OR IGNORE
orIgnore() - Method in class com.github.eikecochu.sqlbuilder.Update: Set this UPDATE statement to be UPDATE OR IGNORE
orReplace() - Method in class com.github.eikecochu.sqlbuilder.Insert: Set this INSERT statement to be INSERT OR REPLACE
orReplace() - Method in class com.github.eikecochu.sqlbuilder.Update: Set this UPDATE statement to be UPDATE OR REPLACE
orRollback() - Method in class com.github.eikecochu.sqlbuilder.Insert: Set this INSERT statement to be INSERT OR ROLLBACK
orRollback() - Method in class com.github.eikecochu.sqlbuilder.Update: Set this UPDATE statement to be UPDATE OR ROLLBACK
OUTER_JOIN - com.github.eikecochu.sqlbuilder.Join.JoinMode
outerJoin() - Method in interface com.github.eikecochu.sqlbuilder.BeforeJoin: Continue query with OUTER JOIN
outerJoin(Table) - Method in interface com.github.eikecochu.sqlbuilder.BeforeJoin: Continue query with OUTER JOIN
outerJoin(String) - Method in interface com.github.eikecochu.sqlbuilder.BeforeJoin: Continue query with OUTER JOIN

P

padCased(String) - Method in class com.github.eikecochu.sqlbuilder.QueryOptions
padded(String) - Method in class com.github.eikecochu.sqlbuilder.QueryOptions
parent(QueryPart) - Method in class com.github.eikecochu.sqlbuilder.QueryPartImpl: Set the parent of this expression
PostProcessor<T> - Interface in com.github.eikecochu.sqlbuilder
prepare(Connection) - Method in class com.github.eikecochu.sqlbuilder.Query: Prepares the statement using the passed database connection
prepare(Connection, QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.Query: Prepares the statement using the passed database connection
preparedString(QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.Expression
preparedValuesString() - Method in class com.github.eikecochu.sqlbuilder.QueryOptions
process(T, Connection) - Method in interface com.github.eikecochu.sqlbuilder.PostProcessor: Transforms the passed value into another value

Q

query() - Method in class com.github.eikecochu.sqlbuilder.Query
query() - Method in interface com.github.eikecochu.sqlbuilder.QueryBuilder: Returns the Query representation of this builder instance
query(Query) - Method in class com.github.eikecochu.sqlbuilder.InsertValue
Query - Class in com.github.eikecochu.sqlbuilder
Query(String) - Static method in class com.github.eikecochu.sqlbuilder.SQLBuilder: Create a final Query
QueryBuilder - Interface in com.github.eikecochu.sqlbuilder
QueryOptions - Class in com.github.eikecochu.sqlbuilder
QueryOptions() - Constructor for class com.github.eikecochu.sqlbuilder.QueryOptions
QueryPart - Interface in com.github.eikecochu.sqlbuilder
QueryPartImpl<T extends QueryPartImpl<T>> - Class in com.github.eikecochu.sqlbuilder
QueryPartImpl(QueryPart) - Constructor for class com.github.eikecochu.sqlbuilder.QueryPartImpl

R

recursive() - Method in class com.github.eikecochu.sqlbuilder.With: Flag WITH statement as RECURSIVE
replace() - Method in class com.github.eikecochu.sqlbuilder.Insert: Set this INSERT statement to be REPLACE
RIGHT_JOIN - com.github.eikecochu.sqlbuilder.Join.JoinMode
rightJoin() - Method in interface com.github.eikecochu.sqlbuilder.BeforeJoin: Continue query with RIGHT JOIN
rightJoin(Table) - Method in interface com.github.eikecochu.sqlbuilder.BeforeJoin: Continue query with RIGHT JOIN
rightJoin(String) - Method in interface com.github.eikecochu.sqlbuilder.BeforeJoin: Continue query with RIGHT JOIN
rightOuterJoin() - Method in interface com.github.eikecochu.sqlbuilder.BeforeJoin: Continue query with RIGHT OUTER JOIN
rightOuterJoin(Table) - Method in interface com.github.eikecochu.sqlbuilder.BeforeJoin: Continue query with RIGHT OUTER JOIN
rightOuterJoin(String) - Method in interface com.github.eikecochu.sqlbuilder.BeforeJoin: Continue query with RIGHT OUTER JOIN

S

select() - Method in interface com.github.eikecochu.sqlbuilder.BeforeSelect: Continue query with SELECT
select() - Method in class com.github.eikecochu.sqlbuilder.Insert
select(Select) - Method in interface com.github.eikecochu.sqlbuilder.BeforeSelect: Accept an existing SELECT statement as predecessor
select(String...) - Method in interface com.github.eikecochu.sqlbuilder.BeforeSelect: Continue query with SELECT
Select - Class in com.github.eikecochu.sqlbuilder
Select(BeforeSelect) - Constructor for class com.github.eikecochu.sqlbuilder.Select
Select(String...) - Constructor for class com.github.eikecochu.sqlbuilder.Select: Create a new SELECT statement
Select() - Static method in class com.github.eikecochu.sqlbuilder.SQLBuilder: Start with a SELECT statement
Select(String...) - Static method in class com.github.eikecochu.sqlbuilder.SQLBuilder: Start with a SELECT statement
selectSQL(String) - Method in interface com.github.eikecochu.sqlbuilder.BeforeSelect: Use plain SQL to form this SELECT statement
set(ValueHolder) - Method in class com.github.eikecochu.sqlbuilder.Update: Set multiple values to be updated
set(String) - Method in class com.github.eikecochu.sqlbuilder.Update: Set a value to be updated
set(String, Object) - Method in class com.github.eikecochu.sqlbuilder.Update: Set a value to be updated
setDefaultOptions(QueryOptions) - Static method in class com.github.eikecochu.sqlbuilder.QueryOptions: Sets the default options
sql(String) - Method in class com.github.eikecochu.sqlbuilder.QueryPartImpl: Set SQL as content
SQLBuilder - Class in com.github.eikecochu.sqlbuilder
startWith() - Method in class com.github.eikecochu.sqlbuilder.oracle.ConnectBy
StartWith - Class in com.github.eikecochu.sqlbuilder.oracle
StartWith(ConnectBy) - Constructor for class com.github.eikecochu.sqlbuilder.oracle.StartWith
string() - Method in interface com.github.eikecochu.sqlbuilder.QueryPart: Transforms this statement into an SQL string using the default QueryOptions
string(QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.Condition
string(QueryOptions) - Method in enum com.github.eikecochu.sqlbuilder.Conditionable.Operator
string(QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.Conditionable
string(QueryOptions) - Method in enum com.github.eikecochu.sqlbuilder.ConditionPart.Operator
string(QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.ConditionPart
string(QueryOptions) - Method in enum com.github.eikecochu.sqlbuilder.ConditionValue.ConditionValueType
string(QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.Delete
string(QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.Exists
string(QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.Expression
string(QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.From
string(QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.GroupBy
string(QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.Having
string(QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.Insert
string(QueryOptions) - Method in enum com.github.eikecochu.sqlbuilder.Join.JoinMode
string(QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.Join
string(QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.Name
string(QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.NestedCondition
string(QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.oracle.ConnectBy
string(QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.oracle.StartWith
string(QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.OrderBy
string(QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.Query
string(QueryOptions) - Method in interface com.github.eikecochu.sqlbuilder.QueryPart: Transforms this statement into an SQL string
string(QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.Select
string(QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.Union
string(QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.Update
string(QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.Where
string(QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.With
string(QueryOptions, Connection) - Method in class com.github.eikecochu.sqlbuilder.Query: Transforms this statement into an SQL string
StringJoiner - Class in com.github.eikecochu.sqlbuilder
StringJoiner() - Constructor for class com.github.eikecochu.sqlbuilder.StringJoiner
subquery(Query, String) - Method in class com.github.eikecochu.sqlbuilder.From: Specify a subquery to select from
subquery(Query, String) - Method in class com.github.eikecochu.sqlbuilder.Join: Add a subquery as join target

T

table(Table) - Method in class com.github.eikecochu.sqlbuilder.From: Specify the target table by Table representation
table(String) - Method in class com.github.eikecochu.sqlbuilder.From: Specify the target table by name
table(String) - Method in class com.github.eikecochu.sqlbuilder.Join: Join to a table by name
Table - Interface in com.github.eikecochu.sqlbuilder
tableName() - Method in interface com.github.eikecochu.sqlbuilder.Table: The table name
tables(Table...) - Method in class com.github.eikecochu.sqlbuilder.From: Specify the target table by Table representations
tables(String...) - Method in class com.github.eikecochu.sqlbuilder.From: Specify the target tables by name
ticked(String) - Method in class com.github.eikecochu.sqlbuilder.QueryOptions
toString() - Method in class com.github.eikecochu.sqlbuilder.Expression
toString() - Method in class com.github.eikecochu.sqlbuilder.Query
toString() - Method in class com.github.eikecochu.sqlbuilder.StringJoiner
toString(String) - Method in class com.github.eikecochu.sqlbuilder.StringJoiner

U

union() - Method in interface com.github.eikecochu.sqlbuilder.BeforeUnion: Continue query with UNION
union(Union) - Method in interface com.github.eikecochu.sqlbuilder.BeforeUnion: Accept an existing UNION statement as predecessor
Union - Class in com.github.eikecochu.sqlbuilder
Union(BeforeUnion) - Constructor for class com.github.eikecochu.sqlbuilder.Union
unionAll() - Method in interface com.github.eikecochu.sqlbuilder.BeforeUnion: Continue query with UNION ALL
unionSQL(String) - Method in interface com.github.eikecochu.sqlbuilder.BeforeUnion: Use plain SQL to form this UNION statement
update(Table) - Method in interface com.github.eikecochu.sqlbuilder.BeforeUpdate: Continue query with UPDATE
update(Update) - Method in interface com.github.eikecochu.sqlbuilder.BeforeUpdate: Accept an existing UPDATE statement as predecessor
update(String) - Method in interface com.github.eikecochu.sqlbuilder.BeforeUpdate: Continue query with UPDATE
Update - Class in com.github.eikecochu.sqlbuilder
Update(BeforeUpdate, String) - Constructor for class com.github.eikecochu.sqlbuilder.Update
Update(Table) - Constructor for class com.github.eikecochu.sqlbuilder.Update: Create a new UPDATE statement
Update(String) - Constructor for class com.github.eikecochu.sqlbuilder.Update: Create a new UPDATE statement
Update(Table) - Static method in class com.github.eikecochu.sqlbuilder.SQLBuilder: Start with an UPDATE statement
Update(String) - Static method in class com.github.eikecochu.sqlbuilder.SQLBuilder: Start with an UPDATE statement
Update.UpdateValue - Class in com.github.eikecochu.sqlbuilder
updateSQL(String) - Method in interface com.github.eikecochu.sqlbuilder.BeforeUpdate: Use plain SQL to form this UPDATE statement
UpdateValue(Update, String) - Constructor for class com.github.eikecochu.sqlbuilder.Update.UpdateValue

V

value(Object) - Method in class com.github.eikecochu.sqlbuilder.ConditionValue: Set a value to be used as condition
value(Object) - Method in class com.github.eikecochu.sqlbuilder.Insert: Insert a value by value only.
value(Object) - Method in class com.github.eikecochu.sqlbuilder.InsertValue
value(Object) - Method in class com.github.eikecochu.sqlbuilder.Update.UpdateValue: Set the updated value
VALUE - com.github.eikecochu.sqlbuilder.ConditionValue.ConditionValueType
ValueHolder - Interface in com.github.eikecochu.sqlbuilder: The ValueHolder instance allows to declare an arbitrary class as a ValueHolder to be used in various methods of the SQLBuilder, for example Where.where(ValueHolder).
valueOf(String) - Static method in enum com.github.eikecochu.sqlbuilder.Conditionable.Operator: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.github.eikecochu.sqlbuilder.ConditionPart.Operator: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.github.eikecochu.sqlbuilder.ConditionValue.ConditionValueType: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.github.eikecochu.sqlbuilder.Join.JoinMode: Returns the enum constant of this type with the specified name.
values() - Static method in enum com.github.eikecochu.sqlbuilder.Conditionable.Operator: Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.github.eikecochu.sqlbuilder.ConditionPart.Operator: Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.github.eikecochu.sqlbuilder.ConditionValue.ConditionValueType: Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.github.eikecochu.sqlbuilder.Join.JoinMode: Returns an array containing the constants of this enum type, in the order they are declared.
values(ValueHolder) - Method in class com.github.eikecochu.sqlbuilder.Conditionable: Set the comparing values
values(ValueHolder) - Method in class com.github.eikecochu.sqlbuilder.Insert: Insert multiple values by value only.
values(Iterable<Object>) - Method in class com.github.eikecochu.sqlbuilder.ConditionValue: Set multiple values to be used as conditions
values(Object...) - Method in class com.github.eikecochu.sqlbuilder.ConditionValue: Set multiple values to be used as conditions
values(Object...) - Method in class com.github.eikecochu.sqlbuilder.InsertValue
values(Object, Object) - Method in class com.github.eikecochu.sqlbuilder.ConditionValue.ConditionBiValue: Set two values to be used as conditions
Values - Class in com.github.eikecochu.sqlbuilder
Values() - Constructor for class com.github.eikecochu.sqlbuilder.Values
valueString(QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.Expression

W

where() - Method in interface com.github.eikecochu.sqlbuilder.BeforeWhere: Continue query with WHERE
where(ValueHolder) - Method in interface com.github.eikecochu.sqlbuilder.BeforeWhere: Continue query with WHERE
where(Where) - Method in interface com.github.eikecochu.sqlbuilder.BeforeWhere: Accept an existing WHERE statement as predecessor
Where - Class in com.github.eikecochu.sqlbuilder
Where(BeforeWhere) - Constructor for class com.github.eikecochu.sqlbuilder.Where
whereSQL(String) - Method in interface com.github.eikecochu.sqlbuilder.BeforeWhere: Use plain SQL to form this WHERE statement
with(With) - Method in interface com.github.eikecochu.sqlbuilder.BeforeWith: Accept an existing WITH statement as predecessor
with(String) - Method in interface com.github.eikecochu.sqlbuilder.BeforeWith: Continue query with WITH
With - Class in com.github.eikecochu.sqlbuilder
With(BeforeWith, String) - Constructor for class com.github.eikecochu.sqlbuilder.With
With(String) - Constructor for class com.github.eikecochu.sqlbuilder.With: Create a new WITH statement
With(String) - Static method in class com.github.eikecochu.sqlbuilder.SQLBuilder: Start with a WITH statement
withSQL(String) - Method in interface com.github.eikecochu.sqlbuilder.BeforeWith: Use plain SQL to form this WITH statement

A B C D E F G H I J K L N O P Q R S T U V W
All Classes All Packages