|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object org.sormula.translator.ColumnsTranslator<R> org.sormula.translator.AbstractWhereTranslator<R>
R
- row classpublic abstract class AbstractWhereTranslator<R>
Base class for translators that provide parameters for where clause.
Constructor Summary | |
---|---|
AbstractWhereTranslator(RowTranslator<R> rowTranslator)
Constructs for row translator. |
Method Summary | |
---|---|
void |
addColumnTranslator(ColumnTranslator<R> c)
Adds translator with equal as operator and "AND" as boolean operator. |
void |
addColumnTranslator(ColumnTranslator<R> c,
java.lang.String comparisonOperator,
java.lang.String booleanOperator)
Deprecated. |
void |
addColumnTranslator(ColumnTranslator<R> c,
java.lang.String booleanOperator,
java.lang.String comparisonOperator,
java.lang.String operand)
Adds translator with a specific sql comparison operator and boolean operator. |
java.lang.String |
createColumnParameterPhrase()
Creates column phrase with parameter placeholders and comparison operators like: "c1 cop1 a1 bo2 c2 cop2 a2 bo3 c3 cop3 a3..." where cN is column name, copN is WhereField.comparisonOperator() , aN is operand (typically "?"), and
boN is WhereField.booleanOperator() |
java.lang.String |
createSql()
Creates SQL for where phrase. |
java.lang.Object[] |
getParameters()
|
RowTranslator<R> |
getRowTranslator()
Gets row translator that was supplied in constructor. |
protected void |
initColumnTranslatorList(int columns)
Initializes objects to hold all column information. |
boolean |
isCollectionOperand()
Tests if where condition contains at least one column with an operand that use a collection as a parameter. |
boolean |
isInOperator()
Deprecated. |
protected boolean |
isInOperator(java.lang.String operator)
Deprecated. |
void |
setParameters(java.lang.Object[] parameters)
Sets parameters that are used in where phrase. |
Methods inherited from class org.sormula.translator.ColumnsTranslator |
---|
createColumnPhrase, createParameterPhrase, getColumnTranslator, getColumnTranslatorList, getRowClass, isIncludeIdentityColumns, read, setIncludeIdentityColumns, write |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public AbstractWhereTranslator(RowTranslator<R> rowTranslator) throws TranslatorException
rowTranslator
- row translator associated with where condition
TranslatorException
- if errorMethod Detail |
---|
protected void initColumnTranslatorList(int columns)
initColumnTranslatorList
in class ColumnsTranslator<R>
columns
- approximatenumber of columns that will be in translator (used as initial capacity)public java.lang.Object[] getParameters()
setParameters(Object[])
public void setParameters(java.lang.Object[] parameters)
SqlOperation.getParameters()
.
parameters
- parameters for where phrase; null if nonepublic java.lang.String createSql()
public RowTranslator<R> getRowTranslator()
public void addColumnTranslator(ColumnTranslator<R> c)
addColumnTranslator
in class ColumnsTranslator<R>
c
- column translator to add@Deprecated public void addColumnTranslator(ColumnTranslator<R> c, java.lang.String comparisonOperator, java.lang.String booleanOperator)
addColumnTranslator(ColumnTranslator, String, String, String)
.
c
- column translator to addcomparisonOperator
- sql comparison operator to use in where condition (examples: ">", "=<", "<>", etc.)booleanOperator
- logical operator to precede this column (examples: "AND", "OR", "AND NOT", etc.)public void addColumnTranslator(ColumnTranslator<R> c, java.lang.String booleanOperator, java.lang.String comparisonOperator, java.lang.String operand)
c
- column translator to addbooleanOperator
- logical operator to precede this column (examples: "AND", "OR", "AND NOT", etc.)comparisonOperator
- sql comparison operator to use in where condition (examples: ">", "=<", "<>", etc.)operand
- operand to follow operator; typically "?" indicates operand is SQL parameter@Deprecated public boolean isInOperator()
@Deprecated protected boolean isInOperator(java.lang.String operator)
public boolean isCollectionOperand()
public java.lang.String createColumnParameterPhrase()
WhereField.comparisonOperator()
, aN is operand (typically "?"), and
boN is WhereField.booleanOperator()
createColumnParameterPhrase
in class ColumnsTranslator<R>
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |