Package net.sf.jasperreports.engine.query

Class JRSqlLessOrGreaterClause

java.lang.Object

net.sf.jasperreports.engine.query.SQLLessOrGreaterBaseClause

net.sf.jasperreports.engine.query.JRSqlLessOrGreaterClause

All Implemented Interfaces:

JRClauseFunction

public class JRSqlLessOrGreaterClause
extends SQLLessOrGreaterBaseClause

Base LESS/GREATER clause function for SQL queries.

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.

Author:

Sanda Zaharia (shertage@users.sourceforge.net)

Field Summary

Fields

Modifier and Type	Field	Description
protected static final JRSqlLessOrGreaterClause	singleton

Fields inherited from class net.sf.jasperreports.engine.query.SQLLessOrGreaterBaseClause

EXCEPTION_MESSAGE_KEY_QUERY_LESS_GREATER_CLAUSE_DB_COLUMN_TOKEN_MISSING, EXCEPTION_MESSAGE_KEY_QUERY_LESS_GREATER_CLAUSE_NAME_TOKEN_MISSING, EXCEPTION_MESSAGE_KEY_QUERY_LESS_GREATER_CLAUSE_PARAMETER_TOKEN_MISSING, OPERATOR_GREATER, OPERATOR_GREATER_OR_EQUAL, OPERATOR_LESS, OPERATOR_LESS_OR_EQUAL, POSITION_CLAUSE_ID, POSITION_DB_COLUMN, POSITION_PARAMETER

Fields inherited from interface net.sf.jasperreports.engine.query.JRClauseFunction

CLAUSE_FALSISM, CLAUSE_TRUISM

Constructor Summary

Constructors

Constructor	Description
JRSqlLessOrGreaterClause()

Method Summary

Modifier and Type	Method	Description
protected ClauseFunctionParameterHandler	createParameterHandler(JRQueryClauseContext queryContext, String clauseId, String parameterName)
static JRSqlLessOrGreaterClause	instance()	Returns the singleton function instance.

Methods inherited from class net.sf.jasperreports.engine.query.SQLLessOrGreaterBaseClause

apply, handleLessOrGreaterOperator

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Details

singleton

protected static final JRSqlLessOrGreaterClause singleton

Constructor Details

JRSqlLessOrGreaterClause

public JRSqlLessOrGreaterClause()

Method Details

instance

public static JRSqlLessOrGreaterClause instance()

Returns the singleton function instance.

Returns:

the singleton function instance

createParameterHandler

protected ClauseFunctionParameterHandler createParameterHandler(JRQueryClauseContext queryContext,
 String clauseId,
 String parameterName)

Specified by:

createParameterHandler in class SQLLessOrGreaterBaseClause