public class StringBuilderForAOWhereClause extends StringBuilderForWhereClause
Modifier and Type | Field and Description |
---|---|
private AOContext |
context |
sb, values
Constructor and Description |
---|
StringBuilderForAOWhereClause(AOContext context,
List<Object> values)
Start building an AO Where clause.
|
Modifier and Type | Method and Description |
---|---|
StringBuilderForAOWhereClause |
addCondition()
Adds " AND " if the clause is not empty
|
StringBuilderForAOWhereClause |
and() |
StringBuilderForAOWhereClause |
append(String s) |
StringBuilderForAOWhereClause |
append(StringBuilderForAOWhereClause whereClauseSubquery) |
StringBuilderForAOWhereClause |
column(String column) |
StringBuilderForAOWhereClause |
column(String tableAlias,
String column)
Appends a column name.
|
StringBuilderForAOWhereClause |
column2(String table,
String column) |
String |
escapeLike(String likeExpression,
char... allowedCharacters) |
<T> StringBuilderForAOWhereClause |
inClause(Collection<T> items)
Builds a clause " IN(?, ...) ", with as many question marks as non-null values im
`items`, and pass them as parameters.
|
<T> StringBuilderForAOWhereClause |
inClause(Collection<T> items,
String questionMark)
Builds a clause " IN(?, ...) ", with as many question marks as non-null values im
`items`, and pass them as parameters.
|
StringBuilderForAOWhereClause |
likeClause(String parameter)
Appends " LIKE ?".
|
StringBuilderForAOWhereClause |
likeLowerClause(Object parameter)
Appends " LIKE LOWER(?)".
|
StringBuilderForAOWhereClause |
or() |
StringBuilderForAOWhereClause |
parameter(Object... parameterValues) |
StringBuilderForAOWhereClause |
renameAs(boolean escapeAliasName,
String newName)
Renames the previous column or table.
|
static StringBuilderForAOWhereClause |
sb(AOContext context) |
static StringBuilderForAOWhereClause |
sb(AOContext context,
List<Object> values) |
StringBuilderForAOWhereClause |
table(String table) |
void |
toQuery(net.java.ao.Query query)
Assigns the current object to the Query's WHERE clause.
|
StringBuilderForAOWhereClause |
unlimitedColumn(boolean escapeTableAlias,
String table,
String column) |
addCondition, executePreparedStatement, getValueList, getValues, insertAtBeginning, isEmpty, sb, toQuery, toString
private final AOContext context
public static StringBuilderForAOWhereClause sb(AOContext context)
public static StringBuilderForAOWhereClause sb(AOContext context, List<Object> values)
public StringBuilderForAOWhereClause unlimitedColumn(boolean escapeTableAlias, String table, String column)
public StringBuilderForAOWhereClause column(String tableAlias, String column)
tableAlias
- the name of the table, or rather its alias in the query.
Don't forget that it won't be escaped; if you need escaping please use column2(java.lang.String, java.lang.String)
public StringBuilderForAOWhereClause column2(String table, String column)
public StringBuilderForAOWhereClause column(String column)
public StringBuilderForAOWhereClause table(String table)
public StringBuilderForAOWhereClause likeClause(String parameter)
public StringBuilderForAOWhereClause likeLowerClause(Object parameter)
public StringBuilderForAOWhereClause append(String s)
append
in class StringBuilderForWhereClause
public StringBuilderForAOWhereClause addCondition()
StringBuilderForWhereClause
addCondition
in class StringBuilderForWhereClause
public StringBuilderForAOWhereClause and()
and
in class StringBuilderForWhereClause
public StringBuilderForAOWhereClause or()
or
in class StringBuilderForWhereClause
public StringBuilderForAOWhereClause parameter(Object... parameterValues)
parameter
in class StringBuilderForWhereClause
public <T> StringBuilderForAOWhereClause inClause(Collection<T> items)
StringBuilderForWhereClause
inClause
in class StringBuilderForWhereClause
public <T> StringBuilderForAOWhereClause inClause(Collection<T> items, String questionMark)
StringBuilderForWhereClause
inClause
in class StringBuilderForWhereClause
questionMark
- If null, "?" will be used to replace the parameters. However, you can pass "UPPER(?)" to
apply a transformation in SQL.public StringBuilderForAOWhereClause renameAs(boolean escapeAliasName, String newName)
public StringBuilderForAOWhereClause append(@Nonnull StringBuilderForAOWhereClause whereClauseSubquery)
public void toQuery(net.java.ao.Query query)
Copyright © 2022 Requirement Yogi. All rights reserved.