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 JRSqlBetweenClause
singleton
-
Fields inherited from class net.sf.jasperreports.engine.query.SQLBetweenBaseClause
CLAUSE_TRUISM, 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
-
-
Constructor Summary
Constructors Constructor Description JRSqlBetweenClause()
-
Method Summary
All Methods Static Methods Instance Methods Concrete Methods 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
-
-
-
-
Field Detail
-
singleton
protected static final JRSqlBetweenClause singleton
-
-
Method Detail
-
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 classSQLBetweenBaseClause
-
-