public class JRSqlLessOrGreaterClause extends java.lang.Object implements JRClauseFunction
The first token in the $X{...} syntax is the function ID token. Possible values for the LESS | GREATER clause function ID token are:
LESS
- in this case the LESS THAN
operator <
will be applied.LESS]
- in this case the LESS OR EQUAL
operator <=
will be applied.GREATER
- in this case the GREATER THAN
operator >
will be applied.[GREATER
- in this case the GREATER OR EQUAL
operator >=
will be applied.Modifier and Type | Field and Description |
---|---|
protected static java.lang.String |
CLAUSE_TRUISM |
protected static java.lang.String |
OPERATOR_GREATER |
protected static java.lang.String |
OPERATOR_GREATER_OR_EQUAL |
protected static java.lang.String |
OPERATOR_LESS |
protected static java.lang.String |
OPERATOR_LESS_OR_EQUAL |
protected static int |
POSITION_CLAUSE_ID |
protected static int |
POSITION_DB_COLUMN |
protected static int |
POSITION_PARAMETER |
protected static JRSqlLessOrGreaterClause |
singleton |
Constructor and Description |
---|
JRSqlLessOrGreaterClause() |
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 void |
handleLessOrGreaterOperator(java.lang.StringBuffer sBuffer,
java.lang.String clauseId)
Appends the appropriate inequality sign to the query string, depending on the clause ID value
|
static JRSqlLessOrGreaterClause |
instance()
Returns the singleton function instance.
|
protected static final int POSITION_CLAUSE_ID
protected static final int POSITION_DB_COLUMN
protected static final int POSITION_PARAMETER
protected static final java.lang.String OPERATOR_LESS
protected static final java.lang.String OPERATOR_LESS_OR_EQUAL
protected static final java.lang.String OPERATOR_GREATER
protected static final java.lang.String OPERATOR_GREATER_OR_EQUAL
protected static final java.lang.String CLAUSE_TRUISM
protected static final JRSqlLessOrGreaterClause singleton
public static JRSqlLessOrGreaterClause instance()
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 LESS
column <= ?
if the clause ID is LESS]
column >= ?
if the clause ID is GREATER
column > ?
if the clause ID is [GREATER
0 = 0
).
apply
in interface JRClauseFunction
clauseTokens
- the clause tokensqueryContext
- the query contextprotected void handleLessOrGreaterOperator(java.lang.StringBuffer sBuffer, java.lang.String clauseId)
sBuffer
- the StringBuffer that contains the generated queryclauseId
- the clause ID© 2001-2010 Jaspersoft Corporation www.jaspersoft.com