Package net.sf.jasperreports.engine.query

Class JRSqlBetweenClause

java.lang.Object

net.sf.jasperreports.engine.query.SQLBetweenBaseClause

net.sf.jasperreports.engine.query.JRSqlBetweenClause

All Implemented Interfaces:

JRClauseFunction

public class JRSqlBetweenClause
extends SQLBetweenBaseClause

Base BETWEEN clause function for SQL queries.

The purpose of this clause function is to find that a given value can be found in a given A...B interval.

The first token in the $X{...} syntax is the function ID token. Possible values for the BETWEEN clause function ID token are:

• BETWEEN - in this case the A...B interval will be considered open: (A,B)
• [BETWEEN - in this case the A...B interval will be considered right-open: [A,B)
• BETWEEN] - in this case the A...B interval will be considered left-open: (A,B]
• [BETWEEN] - in this case the A...B interval will be considered closed: [A,B]

Author:

Sanda Zaharia (shertage@users.sourceforge.net)

Field Summary

Fields

Modifier and Type	Field	Description
protected static final JRSqlBetweenClause	singleton

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

EXCEPTION_MESSAGE_KEY_QUERY_BETWEEN_CLAUSE_DB_COLUMN_TOKEN_MISSING, EXCEPTION_MESSAGE_KEY_QUERY_BETWEEN_CLAUSE_LEFT_PARAMETER_TOKEN_MISSING, EXCEPTION_MESSAGE_KEY_QUERY_BETWEEN_CLAUSE_NAME_TOKEN_MISSING, EXCEPTION_MESSAGE_KEY_QUERY_BETWEEN_CLAUSE_RIGHT_PARAMETER_TOKEN_MISSING, POSITION_CLAUSE_ID, POSITION_DB_COLUMN, POSITION_LEFT_PARAMETER, POSITION_RIGHT_PARAMETER

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

CLAUSE_FALSISM, CLAUSE_TRUISM

Constructor Summary

Constructors

Constructor	Description
JRSqlBetweenClause()

Method Summary

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

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

apply, getGreaterOperator, getLessOperator, handleGreaterClause, handleLessClause, isLeftClosed, isRightClosed

Methods inherited from class java.lang.Object

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

Field Details

singleton

protected static final JRSqlBetweenClause singleton

Constructor Details

JRSqlBetweenClause

public JRSqlBetweenClause()

Method Details

instance

public static JRSqlBetweenClause instance()

Returns the singleton function instance.

Returns:

the singleton function instance

createParameterHandler

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

Specified by:

createParameterHandler in class SQLBetweenBaseClause