public class StringBuilderForWhereClause extends Object
Modifier and Type | Field and Description |
---|---|
protected StringBuilder |
sb |
protected List<Object> |
values |
Constructor and Description |
---|
StringBuilderForWhereClause(List<Object> values) |
Modifier and Type | Method and Description |
---|---|
StringBuilderForWhereClause |
addCondition(String condition,
Object... parameterValues)
Adds a criteria, prefixed with AND if there are already some criteria.
|
StringBuilderForWhereClause |
and() |
StringBuilderForWhereClause |
append(String s) |
List<Object> |
getValueList() |
Object[] |
getValues() |
<T> StringBuilderForWhereClause |
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> StringBuilderForWhereClause |
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.
|
StringBuilderForWhereClause |
or() |
StringBuilderForWhereClause |
parameter(Object... parameterValues) |
static StringBuilderForWhereClause |
sb() |
net.java.ao.Query |
toQuery() |
String |
toString() |
protected final StringBuilder sb
public static StringBuilderForWhereClause sb()
public StringBuilderForWhereClause append(String s)
public StringBuilderForWhereClause addCondition(String condition, Object... parameterValues)
condition
- the condition, such as "FIELD = ?"parameterValues
- the values for the parameterpublic StringBuilderForWhereClause and()
public StringBuilderForWhereClause or()
public StringBuilderForWhereClause parameter(Object... parameterValues)
public Object[] getValues()
public <T> StringBuilderForWhereClause inClause(Collection<T> items)
public <T> StringBuilderForWhereClause inClause(Collection<T> items, String questionMark)
questionMark
- If null, "?" will be used to replace the parameters. However, you can pass "UPPER(?)" to
apply a transformation in SQL.public net.java.ao.Query toQuery()
Copyright © 2020 Play SQL. All rights reserved.