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()
Adds " AND " if the clause is not empty
|
StringBuilderForWhereClause |
addCondition(String condition,
Object... parameterValues)
Adds a criteria, prefixed with AND if there are already some criteria.
|
StringBuilderForWhereClause |
and() |
StringBuilderForWhereClause |
append(String s) |
void |
executePreparedStatement(Connection connection,
com.playsql.utils.activeobjects.nativesql.ResultSetConsumer consumer) |
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 |
insertAtBeginning(String expression)
Inserts an expression before the beginning of the string
|
boolean |
isEmpty() |
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 insertAtBeginning(String expression)
public StringBuilderForWhereClause addCondition()
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 void executePreparedStatement(Connection connection, com.playsql.utils.activeobjects.nativesql.ResultSetConsumer consumer) throws com.playsql.utils.exceptions.DBRYException
com.playsql.utils.exceptions.DBRYException
public net.java.ao.Query toQuery()
public boolean isEmpty()
Copyright © 2022 Requirement Yogi. All rights reserved.