public abstract class SQLLessOrGreaterBaseClause extends Object implements JRClauseFunction
| Modifier and Type | Field and Description |
|---|---|
protected static String |
CLAUSE_TRUISM |
static String |
EXCEPTION_MESSAGE_KEY_QUERY_LESS_GREATER_CLAUSE_DB_COLUMN_TOKEN_MISSING |
static String |
EXCEPTION_MESSAGE_KEY_QUERY_LESS_GREATER_CLAUSE_NAME_TOKEN_MISSING |
static String |
EXCEPTION_MESSAGE_KEY_QUERY_LESS_GREATER_CLAUSE_PARAMETER_TOKEN_MISSING |
protected static String |
OPERATOR_GREATER |
protected static String |
OPERATOR_GREATER_OR_EQUAL |
protected static String |
OPERATOR_LESS |
protected static String |
OPERATOR_LESS_OR_EQUAL |
protected static int |
POSITION_CLAUSE_ID |
protected static int |
POSITION_DB_COLUMN |
protected static int |
POSITION_PARAMETER |
| Modifier | Constructor and Description |
|---|---|
protected |
SQLLessOrGreaterBaseClause() |
| Modifier and Type | Method and Description |
|---|---|
void |
apply(JRClauseTokens clauseTokens,
JRQueryClauseContext queryContext)
Creates either a LESS or a GREATER SQL clause, depending on the clause ID.
|
protected abstract ClauseFunctionParameterHandler |
createParameterHandler(JRQueryClauseContext queryContext,
String clauseId,
String parameterName) |
protected void |
handleLessOrGreaterOperator(StringBuffer sBuffer,
String clauseId)
Appends the appropriate inequality sign to the query string, depending on the clause ID value
|
public static final String EXCEPTION_MESSAGE_KEY_QUERY_LESS_GREATER_CLAUSE_DB_COLUMN_TOKEN_MISSING
public static final String EXCEPTION_MESSAGE_KEY_QUERY_LESS_GREATER_CLAUSE_NAME_TOKEN_MISSING
public static final String EXCEPTION_MESSAGE_KEY_QUERY_LESS_GREATER_CLAUSE_PARAMETER_TOKEN_MISSING
protected static final int POSITION_CLAUSE_ID
protected static final int POSITION_DB_COLUMN
protected static final int POSITION_PARAMETER
protected static final String OPERATOR_LESS
protected static final String OPERATOR_LESS_OR_EQUAL
protected static final String OPERATOR_GREATER
protected static final String OPERATOR_GREATER_OR_EQUAL
protected static final String CLAUSE_TRUISM
public void apply(JRClauseTokens clauseTokens, JRQueryClauseContext queryContext)
The method expects two clause tokens (after the ID token):
The method constructs one of the following clauses:
column < ? if the clause ID is LESScolumn <= ? if the clause ID is LESS]column >= ? if the clause ID is GREATERcolumn > ? if the clause ID is [GREATER0 = 0).
apply in interface JRClauseFunctionclauseTokens - the clause tokensqueryContext - the query contextprotected abstract ClauseFunctionParameterHandler createParameterHandler(JRQueryClauseContext queryContext, String clauseId, String parameterName)
protected void handleLessOrGreaterOperator(StringBuffer sBuffer, String clauseId)
sBuffer - the StringBuffer that contains the generated queryclauseId - the clause IDCopyright © 2017. All rights reserved.