Index (SQLBuilder 1.2 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 a string
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: Enable UNION ALL to join all results without removing duplicate results.
all(boolean) - Method in class com.github.eikecochu.sqlbuilder.Union: Pass true to enable UNION ALL or false to enable 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.ConditionValueType: The ANY value.
and() - Method in class com.github.eikecochu.sqlbuilder.Conditionable: Connect the previous and next condition with the AND operator
AND - com.github.eikecochu.sqlbuilder.ConjunctiveOperator: The AND 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.ConditionValueType: The ALL value.
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<T extends BeforeDelete<T>> - Interface in com.github.eikecochu.sqlbuilder: Implemented by keywords that precede the DELETE statement.
BeforeFrom<T extends BeforeFrom<T>> - Interface in com.github.eikecochu.sqlbuilder: Implemented by keywords that precede the FROM statement.
BeforeGroupBy<T extends BeforeGroupBy<T>> - Interface in com.github.eikecochu.sqlbuilder: Implemented by keywords that precede the GROUP BY statement.
BeforeHaving<T extends BeforeHaving<T>> - Interface in com.github.eikecochu.sqlbuilder: Implemented by keywords that precede the HAVING statement.
BeforeInsert<T extends BeforeInsert<T>> - Interface in com.github.eikecochu.sqlbuilder: Implemented by keywords that precede the INSERT statement.
BeforeJoin<T extends BeforeJoin<T>> - Interface in com.github.eikecochu.sqlbuilder: Implemented by keywords that precede the JOIN statement.
BeforeOrderBy<T extends BeforeOrderBy<T>> - Interface in com.github.eikecochu.sqlbuilder: Implemented by keywords that precede the ORDER BY statement.
BeforeSelect<T extends BeforeSelect<T>> - Interface in com.github.eikecochu.sqlbuilder: Implemented by keywords that precede the SELECT statement.
BeforeUnion<T extends BeforeUnion<T>> - Interface in com.github.eikecochu.sqlbuilder: Implemented by keywords that precede the UNION statement.
BeforeUpdate<T extends BeforeUpdate<T>> - Interface in com.github.eikecochu.sqlbuilder: Implemented by keywords that precede the UPDATE statement.
BeforeWhere<T extends BeforeWhere<T>> - Interface in com.github.eikecochu.sqlbuilder: Implemented by keywords that precede the WHERE statement.
BeforeWith<T extends BeforeWith<T>> - 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.CompareOperator: The BETWEEN operator.

C

cased(String) - Method in class com.github.eikecochu.sqlbuilder.QueryOptions: Turns a string uppercase if enabled, else lowercase
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, CompareOperator, ConditionValueType, Object...) - Method in class com.github.eikecochu.sqlbuilder.Conditionable: Use a column as constraint and set the comparative element
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
col(String, String, ConditionValueType, Object...) - Method in class com.github.eikecochu.sqlbuilder.Conditionable: Use a column as constraint and set the comparative element
colsEq(String, String) - Method in class com.github.eikecochu.sqlbuilder.Conditionable: Compare a column to another column
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(String, String) - Method in class com.github.eikecochu.sqlbuilder.Select: Select a column by name
COLUMN - com.github.eikecochu.sqlbuilder.ConditionValueType: The COLUMN value.
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.mssql - package com.github.eikecochu.sqlbuilder.mssql
com.github.eikecochu.sqlbuilder.mysql - package com.github.eikecochu.sqlbuilder.mysql
com.github.eikecochu.sqlbuilder.oracle - package com.github.eikecochu.sqlbuilder.oracle
CompareOperator - Enum in com.github.eikecochu.sqlbuilder: The CompareOperator represents valid comparation operations between SQL expressions, for example in the WHERE statement, or the JOIN statement.
condition(CompareOperator, ConditionValueType, Object) - Method in class com.github.eikecochu.sqlbuilder.ConditionPart
condition(CompareOperator, 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: Creates a new empty conditionable
Conditionable(QueryPartLinked<?>) - Constructor for class com.github.eikecochu.sqlbuilder.Conditionable
ConditionBiValue<T extends Conditionable<T>> - Class in com.github.eikecochu.sqlbuilder: The ConditionBiValue is used for the BETWEEN operator, to restrict values to two.
ConditionBiValue(ConditionPart<T>, CompareOperator) - Constructor for class com.github.eikecochu.sqlbuilder.ConditionBiValue
ConditionPart<T extends Conditionable<T>> - Class in com.github.eikecochu.sqlbuilder: The ConditionPart is a part of the conditionable expression.
ConditionPart(Conditionable<T>, String) - Constructor for class com.github.eikecochu.sqlbuilder.ConditionPart
ConditionValue<T extends Conditionable<T>> - Class in com.github.eikecochu.sqlbuilder: The condition value that is used to represent values to use for conditions.
ConditionValue(ConditionPart<T>, CompareOperator) - Constructor for class com.github.eikecochu.sqlbuilder.ConditionValue
ConditionValueType - Enum in com.github.eikecochu.sqlbuilder: The ConditionValueType is used to express what a ConditionPart contains as value.
ConjunctiveOperator - Enum in com.github.eikecochu.sqlbuilder: The ConjunctiveOperator is used to chain the various ConditionPart elements together to form the conditions of a query.
connectBy() - Method in class com.github.eikecochu.sqlbuilder.oracle.ConnectBy: Creates a new ConnectBy instance
connectBy() - Method in class com.github.eikecochu.sqlbuilder.oracle.StartWith: Creates a new ConnectBy instance
ConnectBy - Class in com.github.eikecochu.sqlbuilder.oracle: ConnectBy statement Supported by Oracle 11g
ConnectBy(QueryPartLinked<?>) - Constructor for class com.github.eikecochu.sqlbuilder.oracle.ConnectBy
copy() - Method in class com.github.eikecochu.sqlbuilder.QueryOptions: Copies this instance including values and returns the new instance
CROSS_JOIN - com.github.eikecochu.sqlbuilder.JoinMode: The CROSS JOIN mode.
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: Enables CYCLE selection

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: The DELETE expression.
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: Enable UNION to join only distinct results.

E

entry(String, Object) - Static method in interface com.github.eikecochu.sqlbuilder.ValueHolder: Creates a new Map.Entry instance
EntryWrapper() - Constructor for class com.github.eikecochu.sqlbuilder.ValueHolder.EntryWrapper
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(Expression) - Method in class com.github.eikecochu.sqlbuilder.ConditionPart: Set an expression to be used as condition
eqExpr(String, Object...) - Method in class com.github.eikecochu.sqlbuilder.ConditionPart: Set an expression to be used as condition
EQUALS - com.github.eikecochu.sqlbuilder.CompareOperator: The EQUALS operator.
exists(QueryBuilder<?>) - Method in class com.github.eikecochu.sqlbuilder.Where: Continues the condition with an EXISTS expression
exists(String) - Method in class com.github.eikecochu.sqlbuilder.Where: Continues the condition with an EXISTS expression
Exists - Class in com.github.eikecochu.sqlbuilder: The EXISTS expression.
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.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: Expressions are used to create stored procedure calls.
Expression(String, Object...) - Constructor for class com.github.eikecochu.sqlbuilder.Expression: Create a new expression with multiple IN parameters
EXPRESSION - com.github.eikecochu.sqlbuilder.ConditionValueType: The EXPRESSION value.
ext(U) - Method in interface com.github.eikecochu.sqlbuilder.QueryPartLinked: Continue the building chain with any element, for example custom implemented expressions.

F

fetch(int) - Method in class com.github.eikecochu.sqlbuilder.mssql.Offset: Create a new Fetch statement with the amount of rows to be fetched
Fetch - Class in com.github.eikecochu.sqlbuilder.mssql: Fetch statement Supported by MS SQL Server, Oracle 12c, PostgreSQL
Fetch(int) - Constructor for class com.github.eikecochu.sqlbuilder.mssql.Fetch: Create a new Fetch statement with the amount of rows to be fetched
Fetch(QueryPartLinked<?>, int) - Constructor for class com.github.eikecochu.sqlbuilder.mssql.Fetch
FETCH_ALL - Static variable in class com.github.eikecochu.sqlbuilder.QueryOptions: The default value of the fetchSize variable.
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(QueryBuilder<?>) - Method in interface com.github.eikecochu.sqlbuilder.BeforeFrom: Specify a subquery to select from
from(QueryBuilder<?>, String) - Method in interface com.github.eikecochu.sqlbuilder.BeforeFrom: Specify a subquery to select from
from(Table...) - Method in interface com.github.eikecochu.sqlbuilder.BeforeFrom: Continue query with FROM
from(Iterable<? extends Map.Entry<String, Object>>) - Static method in interface com.github.eikecochu.sqlbuilder.ValueHolder: Create a ValueHolder from an Iterable instance
from(String...) - Method in interface com.github.eikecochu.sqlbuilder.BeforeFrom: Continue query with FROM
from(Map<String, Object>) - Static method in interface com.github.eikecochu.sqlbuilder.ValueHolder: Creates a ValueHolder instance from a Map instance
From - Class in com.github.eikecochu.sqlbuilder: The FROM expression.
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
fromString(String) - Static method in enum com.github.eikecochu.sqlbuilder.CompareOperator: Converts a string to a CompareOperator, if possible.
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.CompareOperator: The GREATER EQUALS operator.
getDefaultOptions() - Static method in class com.github.eikecochu.sqlbuilder.QueryOptions: Returns the default options
getKey() - Method in class com.github.eikecochu.sqlbuilder.ValueHolder.EntryWrapper
getValue() - Method in class com.github.eikecochu.sqlbuilder.ValueHolder.EntryWrapper
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: The GROUP BY expression.
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.CompareOperator: The GREATER THAN 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: The HAVING expression.
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.Expression: Add a new IN parameter
in(Object...) - Method in class com.github.eikecochu.sqlbuilder.ConditionPart: The IN operator.
IN - com.github.eikecochu.sqlbuilder.CompareOperator: The IN operator.
indent() - Method in class com.github.eikecochu.sqlbuilder.QueryOptions: Increases the indent level by 1
indentString() - Method in class com.github.eikecochu.sqlbuilder.QueryOptions: Creates an indent string based on the indent size and level
INNER_JOIN - com.github.eikecochu.sqlbuilder.JoinMode: The INNER JOIN mode.
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
innerJoinOnColsEq(Table, String, String) - Method in interface com.github.eikecochu.sqlbuilder.BeforeJoin: Continue query with INNER JOIN and use two columns as condition with col1 = col2
innerJoinOnColsEq(String, String, String) - Method in interface com.github.eikecochu.sqlbuilder.BeforeJoin: Continue query with INNER JOIN and use two columns as condition with col1 = col2
inOut(Object, int) - Method in class com.github.eikecochu.sqlbuilder.Expression: Add a new IN/OUT parameter
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: The INSERT expression.
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
INSERT - com.github.eikecochu.sqlbuilder.InsertMode: The INSERT mode.
INSERT_OR_ABORT - com.github.eikecochu.sqlbuilder.InsertMode: The INSERT OR ABORT mode.
INSERT_OR_FAIL - com.github.eikecochu.sqlbuilder.InsertMode: The INSERT OR FAIL mode.
INSERT_OR_IGNORE - com.github.eikecochu.sqlbuilder.InsertMode: The INSERT OR IGNORE mode.
INSERT_OR_REPLACE - com.github.eikecochu.sqlbuilder.InsertMode: The INSERT OR REPLACE mode.
INSERT_OR_ROLLBACK - com.github.eikecochu.sqlbuilder.InsertMode: The INSERT OR ROLLBACK mode.
InsertMode - Enum in com.github.eikecochu.sqlbuilder: InsertMode defines how the INSERT statement inserts values into the database.
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: The InsertValue represents a value that is inserted into the database with the INSERT statement.
InsertValue(Insert, String) - Constructor for class com.github.eikecochu.sqlbuilder.InsertValue
IS_NOT_NULL - com.github.eikecochu.sqlbuilder.CompareOperator: The IS NOT NULL operator.
IS_NULL - com.github.eikecochu.sqlbuilder.CompareOperator: The IS NULL operator.
isDelete() - Method in class com.github.eikecochu.sqlbuilder.Query: Checks if this builder represents a DELETE statement
isExpression() - Method in class com.github.eikecochu.sqlbuilder.Query: Checks if this builder represents a function expression
isInsert() - Method in class com.github.eikecochu.sqlbuilder.Query: Checks if this builder represents an INSERT statement
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
isSelect() - Method in class com.github.eikecochu.sqlbuilder.Query: Checks if this builder represents a SELECT statement
isStatementType(Class<?>) - Method in class com.github.eikecochu.sqlbuilder.Query: Checks if this builder represents the passed statement type
isUpdate() - Method in class com.github.eikecochu.sqlbuilder.Query: Checks if this builder represents an UPDATE statement
iterator() - Method in interface com.github.eikecochu.sqlbuilder.ValueHolder
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(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: The JOIN expression.
Join(BeforeJoin<?>) - Constructor for class com.github.eikecochu.sqlbuilder.Join
Join(BeforeJoin<?>, JoinMode) - Constructor for class com.github.eikecochu.sqlbuilder.Join
JoinMode - Enum in com.github.eikecochu.sqlbuilder: The JoinMode describes how a JOIN between two elements is made.
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: The KEYWORDS set is used to identify database keywords in names to apply escaping to avoid errors when executing the query.

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.CompareOperator: The LESSER EQUALS operator.
LEFT_JOIN - com.github.eikecochu.sqlbuilder.JoinMode: The LEFT JOIN mode.
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.CompareOperator: The LIKE operator.
Limit - Class in com.github.eikecochu.sqlbuilder.mysql: Limit statement Supported by MySQL
Limit(int) - Constructor for class com.github.eikecochu.sqlbuilder.mysql.Limit: Create a new Limit statement with the amount of rows to be fetched
Limit(QueryPartLinked<?>, int) - Constructor for class com.github.eikecochu.sqlbuilder.mysql.Limit
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.CompareOperator: The LESS THAN operator.

N

Name - Class in com.github.eikecochu.sqlbuilder: The Name class represents a name used in a query, for example a table name, column name or function name.
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: Creates a newline if required, when pretty printing is enabled
newLine(boolean) - Method in class com.github.eikecochu.sqlbuilder.QueryOptions: Creates a newline or space, if enabled
nocycle() - Method in class com.github.eikecochu.sqlbuilder.oracle.ConnectBy: Enables NOCYCLE selection
not() - Method in class com.github.eikecochu.sqlbuilder.ConditionPart: The NOT operator
NOT_EQUALS - com.github.eikecochu.sqlbuilder.CompareOperator: The NOT EQUALS operator.
notEmpty() - Method in class com.github.eikecochu.sqlbuilder.StringJoiner: Checks if this StringJoiner contains strings
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

offset(int) - Method in class com.github.eikecochu.sqlbuilder.mysql.Limit: Creates a new Offset instance with the offset to skip when selecting data
Offset - Class in com.github.eikecochu.sqlbuilder.mssql: Offset statement Supported by MS SQL Server, Oracle 12c, PostgreSQL
Offset - Class in com.github.eikecochu.sqlbuilder.mysql: Offset statement Supported by MySQL
Offset(int) - Constructor for class com.github.eikecochu.sqlbuilder.mssql.Offset: Creates a new Offset instance with the offset to skip when selecting data
Offset(int) - Constructor for class com.github.eikecochu.sqlbuilder.mysql.Offset: Creates a new Offset instance with the offset to skip when selecting data
Offset(QueryPartLinked<?>, int) - Constructor for class com.github.eikecochu.sqlbuilder.mssql.Offset
Offset(QueryPartLinked<?>, int) - Constructor for class com.github.eikecochu.sqlbuilder.mysql.Offset
on() - Method in class com.github.eikecochu.sqlbuilder.Join: Set join conditions
onColsEq(String, String) - Method in class com.github.eikecochu.sqlbuilder.Join: Set join conditions to join on two equal columns
or() - Method in class com.github.eikecochu.sqlbuilder.Conditionable: Connect the previous and next condition with the OR operator
OR - com.github.eikecochu.sqlbuilder.ConjunctiveOperator: The OR 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: The ORDER BY expression.
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
out(int) - Method in class com.github.eikecochu.sqlbuilder.Expression: Add a new OUT parameter
OUTER_JOIN - com.github.eikecochu.sqlbuilder.JoinMode: The OUTER JOIN mode.
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: Combines the methods padded and cased
padded(String) - Method in class com.github.eikecochu.sqlbuilder.QueryOptions: Pads a string to a specified length, if enabled
parent() - Method in interface com.github.eikecochu.sqlbuilder.QueryPartLinked: Get the parent of this expression
parent(QueryPartLinked<?>) - Method in class com.github.eikecochu.sqlbuilder.QueryPartImpl
parent(QueryPartLinked<?>) - Method in interface com.github.eikecochu.sqlbuilder.QueryPartLinked: Set the parent of this expression
PostProcessor<T> - Interface in com.github.eikecochu.sqlbuilder: The PostProcessor interface is used to create postprocessing instances for postprocessing multiple elements during the building process of the query.
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
prepareCall(Connection, QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.Query: Prepares the call using the passed database connection
preparedString(QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.Expression: Turns this expression into a string with value placeholders for query preparation
preparedValuesString() - Method in class com.github.eikecochu.sqlbuilder.QueryOptions: Returns all contained prepared values as a simple, concatenated string
process(T) - Method in interface com.github.eikecochu.sqlbuilder.QueryProcessor: The process method.
process(T, QueryOptions, 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.Expression
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: Use a subquery as value supplier.
query(U) - Method in interface com.github.eikecochu.sqlbuilder.QueryBuilder: Allows the user to finish the query building process by passing the query to a specified processor.
Query - Class in com.github.eikecochu.sqlbuilder: The Query class is the final class of the building process and describes a complete query.
Query(String) - Static method in class com.github.eikecochu.sqlbuilder.SQLBuilder: Create a final Query
QueryBuilder<T extends QueryBuilder<T>> - Interface in com.github.eikecochu.sqlbuilder: The QueryBuilder interface that is implemented by all expressions that mark the possible end of a query.
QueryOptions - Class in com.github.eikecochu.sqlbuilder: The QueryOptions class holds all options that are applied at various places throughout the building process of a query.
QueryOptions() - Constructor for class com.github.eikecochu.sqlbuilder.QueryOptions
QueryPart - Interface in com.github.eikecochu.sqlbuilder: The QueryPart interface is implemented by all parts of the query building process to turn them into strings for query assembly when building.
QueryPartImpl<T extends QueryPartImpl<T>> - Class in com.github.eikecochu.sqlbuilder: The default QueryPart implementation used by most expressions.
QueryPartImpl(QueryPartLinked<?>) - Constructor for class com.github.eikecochu.sqlbuilder.QueryPartImpl: Create a new instance with a parent expression
QueryPartLinked<T extends QueryPartLinked<T>> - Interface in com.github.eikecochu.sqlbuilder: The QueryPartLinked interface is implemented by all expressions that can link to parent expressions for building chains.
QueryPartSQL<T extends QueryPartSQL<T>> - Interface in com.github.eikecochu.sqlbuilder: The QueryPartSQL interface is the interface of all expressions that support adding plain SQL into them instead of building methods.
QueryProcessor - Interface in com.github.eikecochu.sqlbuilder: The QueryProcessor interface to implement for query postprocessing.

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
REPLACE - com.github.eikecochu.sqlbuilder.InsertMode: The REPLACE mode.
RIGHT_JOIN - com.github.eikecochu.sqlbuilder.JoinMode: The RIGHT JOIN mode.
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: The SELECT expression.
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
setIn(int, Object) - Method in class com.github.eikecochu.sqlbuilder.Expression: Sets a parameter to be an IN parameter.
setInOut(int, Object, int) - Method in class com.github.eikecochu.sqlbuilder.Expression: Sets a parameter to be an IN/OUT parameter.
setIns(Object...) - Method in class com.github.eikecochu.sqlbuilder.Expression: Set multiple parameters to be IN parameters.
setOut(int, int) - Method in class com.github.eikecochu.sqlbuilder.Expression: Sets a parameter to be an OUT parameter.
setOuts(Integer...) - Method in class com.github.eikecochu.sqlbuilder.Expression: Set multiple parameters to be OUT parameters.
setValue(Object) - Method in class com.github.eikecochu.sqlbuilder.ValueHolder.EntryWrapper
setValue(Object) - Method in class com.github.eikecochu.sqlbuilder.ValueHolder.ValueEntry
sql(String) - Method in class com.github.eikecochu.sqlbuilder.QueryPartImpl
sql(String) - Method in interface com.github.eikecochu.sqlbuilder.QueryPartSQL: Set SQL as content
SQLBuilder - Class in com.github.eikecochu.sqlbuilder: Convenience class for quick starting a new statement.
startWith() - Method in class com.github.eikecochu.sqlbuilder.oracle.ConnectBy: Creates a new StartWith instance
StartWith - Class in com.github.eikecochu.sqlbuilder.oracle: StartWith statement Supported by Oracle 11g
StartWith(ConnectBy) - Constructor for class com.github.eikecochu.sqlbuilder.oracle.StartWith
statementType() - Method in class com.github.eikecochu.sqlbuilder.Query: Returns the statement type.
string() - Method in interface com.github.eikecochu.sqlbuilder.QueryPart: Transforms this statement into an SQL string using the default QueryOptions
string(QueryOptions) - Method in enum com.github.eikecochu.sqlbuilder.CompareOperator
string(QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.Condition
string(QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.Conditionable
string(QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.ConditionPart
string(QueryOptions) - Method in enum com.github.eikecochu.sqlbuilder.ConditionValueType
string(QueryOptions) - Method in enum com.github.eikecochu.sqlbuilder.ConjunctiveOperator
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.InsertMode
string(QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.Join
string(QueryOptions) - Method in enum com.github.eikecochu.sqlbuilder.JoinMode
string(QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.mssql.Fetch
string(QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.mssql.Offset
string(QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.mysql.Limit
string(QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.mysql.Offset
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, boolean) - Method in class com.github.eikecochu.sqlbuilder.Expression: Turns this expression into a string.
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: The StringJoiner class is used to assemble the query string with support for adding strings and collections of strings and optionally joining them with a delimiter.
StringJoiner() - Constructor for class com.github.eikecochu.sqlbuilder.StringJoiner
subquery(QueryBuilder<?>) - Method in class com.github.eikecochu.sqlbuilder.From: Specify a subquery to select from
subquery(QueryBuilder<?>, String) - Method in class com.github.eikecochu.sqlbuilder.From: Specify a subquery to select from
subquery(QueryBuilder<?>, 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: The Table interface is a representation of a table with a name.
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: Wraps a keyword in ticks or quotes, if enabled
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: Assembles all strings, separated by a delimiter

U

unindent() - Method in class com.github.eikecochu.sqlbuilder.QueryOptions: Decreases the indent level by 1
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: The UNION expression.
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: The UPDATE expression.
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
updateSQL(String) - Method in interface com.github.eikecochu.sqlbuilder.BeforeUpdate: Use plain SQL to form this UPDATE statement
UpdateValue - Class in com.github.eikecochu.sqlbuilder: The UpdateValue class that represents a database value to be used with an UPDATE statement.
UpdateValue(Update, String) - Constructor for class com.github.eikecochu.sqlbuilder.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: Set a value to be inserted
value(Object) - Method in class com.github.eikecochu.sqlbuilder.UpdateValue: Set the updated value
VALUE - com.github.eikecochu.sqlbuilder.ConditionValueType: The VALUE type.
ValueEntry() - Constructor for class com.github.eikecochu.sqlbuilder.ValueHolder.ValueEntry
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).
ValueHolder.EntryWrapper - Class in com.github.eikecochu.sqlbuilder: The EntryWrapper is a wrapper around the Map.Entry class to support automatic key prefixing.
ValueHolder.ValueEntry - Class in com.github.eikecochu.sqlbuilder: The ValueEntry class is an implementation of the Map.Entry class
valueOf(String) - Static method in enum com.github.eikecochu.sqlbuilder.CompareOperator: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.github.eikecochu.sqlbuilder.ConditionValueType: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.github.eikecochu.sqlbuilder.ConjunctiveOperator: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.github.eikecochu.sqlbuilder.InsertMode: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.github.eikecochu.sqlbuilder.JoinMode: Returns the enum constant of this type with the specified name.
values() - Static method in enum com.github.eikecochu.sqlbuilder.CompareOperator: 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.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.ConjunctiveOperator: 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.InsertMode: 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.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(ValueHolder) - Method in class com.github.eikecochu.sqlbuilder.InsertValue: Set multiple values to be inserted
values(ValueHolder, String) - Method in class com.github.eikecochu.sqlbuilder.Conditionable: Set the comparing values with prefix
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: Set multiple values to be inserted
values(Object, Object) - Method in class com.github.eikecochu.sqlbuilder.ConditionBiValue: Set two values to be used as conditions
values(String) - Method in interface com.github.eikecochu.sqlbuilder.ValueHolder: Returns the values stored in this ValueHolder.
Values - Class in com.github.eikecochu.sqlbuilder: The default ValueHolder implementation with convenience methods to add values.
Values() - Constructor for class com.github.eikecochu.sqlbuilder.Values
valueString(QueryOptions) - Method in class com.github.eikecochu.sqlbuilder.Expression: Turns this expression into a string with the passed values inserted.

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(ValueHolder, String) - 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: The WHERE expression.
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: The WITH expression.
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
withAlias(String) - Method in interface com.github.eikecochu.sqlbuilder.Table: The table name with alias
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