Package | Description |
---|---|
org.springframework.data.relational.core.sql |
Statement Builder implementation.
|
Modifier and Type | Class and Description |
---|---|
class |
AsteriskFromTable
|
class |
BindMarker
Bind marker/parameter placeholder used to construct prepared statements with parameter substitution.
|
class |
BooleanLiteral
Represents a
Boolean literal. |
class |
Column
Column name within a
SELECT … FROM clause. |
static class |
Expressions.SimpleExpression |
class |
Literal<T>
Represents a literal.
|
class |
NumericLiteral
Represents a
Number literal. |
class |
SimpleFunction
Simple function accepting one or more
Expression s. |
class |
StringLiteral
Represents a
CharSequence literal. |
class |
SubselectExpression
Wrapper for a
Select query to be used as subselect. |
Modifier and Type | Method and Description |
---|---|
static Expression |
Expressions.asterisk() |
static Expression |
Expressions.asterisk(Table table) |
Expression |
Between.getBegin() |
Expression |
Between.getColumn() |
Expression |
Between.getEnd() |
Expression |
OrderByField.getExpression() |
Expression |
SimpleCondition.getExpression() |
Expression |
Comparison.getLeft() |
Expression |
Like.getLeft() |
Expression |
Comparison.getRight() |
Expression |
Like.getRight() |
Expression |
AssignValue.getValue() |
static Expression |
Expressions.just(String sql)
Creates a plain
sql Expression . |
Modifier and Type | Method and Description |
---|---|
List<Expression> |
SimpleFunction.getExpressions() |
Modifier and Type | Method and Description |
---|---|
SelectBuilder.SelectOnConditionComparison |
SelectBuilder.SelectOnCondition.and(Expression column)
Declare an additional source column in the
JOIN . |
Between |
Column.between(Expression begin,
Expression end)
Creates a
BETWEEN Condition . |
static Between |
Conditions.between(Expression columnOrExpression,
Expression begin,
Expression end)
Creates a
BETWEEN Condition . |
static SimpleFunction |
Functions.count(Expression... columns)
Creates a new
COUNT function. |
static AssignValue |
AssignValue.create(Column target,
Expression value)
|
static IsNull |
IsNull.create(Expression expression)
Creates a new
IsNull expression. |
static In |
In.create(Expression columnOrExpression,
Collection<? extends Expression> expressions)
|
static In |
In.create(Expression columnOrExpression,
Expression... expressions)
|
static In |
In.create(Expression columnOrExpression,
Expression... expressions)
|
static In |
In.create(Expression columnOrExpression,
Expression arg)
|
static Like |
Like.create(Expression leftColumnOrExpression,
Expression rightColumnOrExpression)
|
static Between |
Between.create(Expression columnOrExpression,
Expression begin,
Expression end)
|
static Comparison |
Comparison.create(Expression leftColumnOrExpression,
String comparator,
Expression rightColumnOrExpression)
|
static In |
In.createNotIn(Expression columnOrExpression,
Collection<? extends Expression> expressions)
|
static In |
In.createNotIn(Expression columnOrExpression,
Expression... expressions)
|
static In |
In.createNotIn(Expression columnOrExpression,
Expression... expressions)
|
static In |
In.createNotIn(Expression columnOrExpression,
Expression arg)
|
SelectBuilder.SelectFromAndJoinCondition |
SelectBuilder.SelectOnConditionComparison.equals(Expression column)
|
In |
Column.in(Expression... expression)
|
static Condition |
Conditions.in(Expression columnOrExpression,
Collection<? extends Expression> expressions)
|
static In |
Conditions.in(Expression columnOrExpression,
Expression... expressions)
|
static In |
Conditions.in(Expression columnOrExpression,
Expression... expressions)
|
static In |
Conditions.in(Expression columnOrExpression,
Expression arg)
Creates a
IN clause . |
static Comparison |
Conditions.isEqual(Expression leftColumnOrExpression,
Expression rightColumnOrExpression)
Creates a
= (equals) Condition . |
Comparison |
Column.isEqualTo(Expression expression)
Creates a
= (equals) Condition . |
Comparison |
Column.isGreater(Expression expression)
Creates a {@code !
|
static Comparison |
Conditions.isGreater(Expression leftColumnOrExpression,
Expression rightColumnOrExpression)
|
Comparison |
Column.isGreaterOrEqualTo(Expression expression)
Creates a
<= (greater or equal to) Condition . |
static Comparison |
Conditions.isGreaterOrEqualTo(Expression leftColumnOrExpression,
Expression rightColumnOrExpression)
|
Comparison |
Column.isLess(Expression expression)
Creates a
< (less) Condition . |
static Comparison |
Conditions.isLess(Expression leftColumnOrExpression,
Expression rightColumnOrExpression)
|
Comparison |
Column.isLessOrEqualTo(Expression expression)
CCreates a
<= (greater) Condition . |
static Comparison |
Conditions.isLessOrEqualTo(Expression leftColumnOrExpression,
Expression rightColumnOrExpression)
|
static Comparison |
Conditions.isNotEqual(Expression leftColumnOrExpression,
Expression rightColumnOrExpression)
Creates a {@code !
|
Comparison |
Column.isNotEqualTo(Expression expression)
Creates a {@code !
|
static IsNull |
Conditions.isNull(Expression expression)
Creates a
IS NULL condition. |
Like |
Column.like(Expression expression)
Creates a
LIKE Condition . |
static Like |
Conditions.like(Expression leftColumnOrExpression,
Expression rightColumnOrExpression)
Creates a
LIKE Condition . |
static SimpleFunction |
Functions.lower(Expression expression)
Creates a new
LOWER function. |
Between |
Column.notBetween(Expression begin,
Expression end)
Creates a
NOT BETWEEN Condition . |
static Between |
Conditions.notBetween(Expression columnOrExpression,
Expression begin,
Expression end)
Creates a
NOT BETWEEN Condition . |
In |
Column.notIn(Expression... expression)
|
static Condition |
Conditions.notIn(Expression columnOrExpression,
Collection<? extends Expression> expressions)
|
static In |
Conditions.notIn(Expression columnOrExpression,
Expression... expressions)
|
static In |
Conditions.notIn(Expression columnOrExpression,
Expression... expressions)
|
static In |
Conditions.notIn(Expression columnOrExpression,
Expression arg)
Creates a
NOT IN clause . |
Like |
Column.notLike(Expression expression)
Creates a
NOT LIKE Condition . |
static Like |
Conditions.notLike(Expression leftColumnOrExpression,
Expression rightColumnOrExpression)
Creates a
NOT LIKE Condition . |
SelectBuilder.SelectOnConditionComparison |
SelectBuilder.SelectOn.on(Expression column)
Declare the source column in the
JOIN . |
SelectBuilder.SelectAndFrom |
SelectBuilder.select(Expression... expressions)
Include one or more
Expression s in the select list. |
SelectBuilder.SelectFrom |
SelectBuilder.SelectAndFrom.select(Expression... expressions)
Include one or more
Expression s in the select list. |
static SelectBuilder.SelectAndFrom |
StatementBuilder.select(Expression... expressions)
Creates a new
SelectBuilder and includes one or more SELECT columns. |
SelectBuilder.SelectAndFrom |
SelectBuilder.select(Expression expression)
Include a
Expression in the select list. |
SelectBuilder.SelectFrom |
SelectBuilder.SelectAndFrom.select(Expression expression)
Include a
Expression in the select list. |
static SelectBuilder.SelectAndFrom |
StatementBuilder.select(Expression expression)
Creates a new
SelectBuilder and includes the SELECT columns. |
AssignValue |
Column.set(Expression value)
Creates a value
assignment . |
static SimpleFunction |
Functions.upper(Expression expression)
Creates a new
UPPER function. |
static AssignValue |
Assignments.value(Column target,
Expression value)
|
InsertBuilder.InsertValuesWithBuild |
InsertBuilder.InsertIntoColumnsAndValuesWithBuild.value(Expression value)
Add a
value to the VALUES list. |
InsertBuilder.InsertValuesWithBuild |
InsertBuilder.InsertValuesWithBuild.value(Expression value)
Add a
value to the VALUES list. |
InsertBuilder.InsertValuesWithBuild |
InsertBuilder.InsertValues.value(Expression value)
Add a
value to the VALUES list. |
InsertBuilder.InsertValuesWithBuild |
InsertBuilder.InsertIntoColumnsAndValuesWithBuild.values(Expression... values)
Add one or more
values to the VALUES list. |
InsertBuilder.InsertValuesWithBuild |
InsertBuilder.InsertValuesWithBuild.values(Expression... values)
Add one or more
values to the VALUES list. |
InsertBuilder.InsertValuesWithBuild |
InsertBuilder.InsertValues.values(Expression... values)
Add one or more
values to the VALUES list. |
Modifier and Type | Method and Description |
---|---|
static SimpleFunction |
Functions.count(Collection<? extends Expression> columns)
Creates a new
COUNT function. |
static In |
In.create(Expression columnOrExpression,
Collection<? extends Expression> expressions)
|
static SimpleFunction |
SimpleFunction.create(String functionName,
List<Expression> expressions)
|
static In |
In.createNotIn(Expression columnOrExpression,
Collection<? extends Expression> expressions)
|
static Condition |
Conditions.in(Expression columnOrExpression,
Collection<? extends Expression> expressions)
|
static Condition |
Conditions.notIn(Expression columnOrExpression,
Collection<? extends Expression> expressions)
|
SelectBuilder.SelectAndFrom |
SelectBuilder.select(Collection<? extends Expression> expressions)
Include one or more
Expression s in the select list. |
SelectBuilder.SelectFrom |
SelectBuilder.SelectAndFrom.select(Collection<? extends Expression> expressions)
Include one or more
Expression s in the select list. |
static SelectBuilder.SelectAndFrom |
StatementBuilder.select(Collection<? extends Expression> expressions)
Creates a new
SelectBuilder and includes one or more Expression s in the select list. |
InsertBuilder.InsertValuesWithBuild |
InsertBuilder.InsertIntoColumnsAndValuesWithBuild.values(Collection<? extends Expression> values)
Add one or more
values to the VALUES list. |
InsertBuilder.InsertValuesWithBuild |
InsertBuilder.InsertValuesWithBuild.values(Collection<? extends Expression> values)
Add one or more
values to the VALUES list. |
InsertBuilder.InsertValuesWithBuild |
InsertBuilder.InsertValues.values(Collection<? extends Expression> values)
Add one or more
values to the VALUES list. |
Copyright © 2017–2021 Pivotal Software, Inc.. All rights reserved.