Package net.sf.jasperreports.engine.query

Class JRSqlInClause

java.lang.Object

net.sf.jasperreports.engine.query.JRSqlAbstractInClause

net.sf.jasperreports.engine.query.JRSqlInClause

All Implemented Interfaces:

JRClauseFunction

public class JRSqlInClause
extends JRSqlAbstractInClause

SQL "IN" clause function.

Author:

Lucian Chirita (lucianc@users.sourceforge.net)

See Also:

• JRSqlAbstractInClause.apply(JRClauseTokens, JRQueryClauseContext)

Field Summary

Fields

Modifier and Type	Field	Description
protected static final String	OPERATOR_AND_OR
protected static final String	OPERATOR_IN
protected static final String	OPERATOR_NULL
static final String	PROPERTY_NO_VALUES_RESULT	Property that specifies the boolean result of the IN clause of an SQL query when the list of values is null or empty and the optional third parameter of the clause is not provided.
protected static final JRSqlInClause	singleton

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

EXCEPTION_MESSAGE_KEY_QUERY_IN_CLAUSE_DB_COLUMN_TOKEN_MISSING, EXCEPTION_MESSAGE_KEY_QUERY_IN_CLAUSE_INVALID_PARAMETER_TYPE, EXCEPTION_MESSAGE_KEY_QUERY_IN_CLAUSE_PARAMETER_TOKEN_MISSING, POSITION_DB_COLUMN, POSITION_NO_VALUES_RESULT, POSITION_PARAMETER

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

CLAUSE_FALSISM, CLAUSE_TRUISM

Constructor Summary

Constructors

Constructor	Description
JRSqlInClause()

Method Summary

Modifier and Type	Method	Description
protected void	appendAndOrOperator(StringBuffer sBuffer)
protected void	appendInOperator(StringBuffer sBuffer)
protected void	appendNullOperator(StringBuffer sBuffer)
protected String	getNoValuesResultProperty()
static JRSqlInClause	instance()	Returns the singleton function instance.

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

apply, convert, handleNoValues

Methods inherited from class java.lang.Object

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

Field Details

PROPERTY_NO_VALUES_RESULT

public static final String PROPERTY_NO_VALUES_RESULT

Property that specifies the boolean result of the IN clause of an SQL query when the list of values is null or empty and the optional third parameter of the clause is not provided.

See Also:

• Constant Field Values

OPERATOR_IN

protected static final String OPERATOR_IN

See Also:

• Constant Field Values

OPERATOR_NULL

protected static final String OPERATOR_NULL

See Also:

• Constant Field Values

OPERATOR_AND_OR

protected static final String OPERATOR_AND_OR

See Also:

• Constant Field Values

singleton

protected static final JRSqlInClause singleton

Constructor Details

JRSqlInClause

public JRSqlInClause()

Method Details

instance

public static JRSqlInClause instance()

Returns the singleton function instance.

Returns:

the singleton function instance

appendInOperator

protected void appendInOperator(StringBuffer sBuffer)

Specified by:

appendInOperator in class JRSqlAbstractInClause

appendNullOperator

protected void appendNullOperator(StringBuffer sBuffer)

Specified by:

appendNullOperator in class JRSqlAbstractInClause

appendAndOrOperator

protected void appendAndOrOperator(StringBuffer sBuffer)

Specified by:

appendAndOrOperator in class JRSqlAbstractInClause

getNoValuesResultProperty

protected String getNoValuesResultProperty()

Specified by:

getNoValuesResultProperty in class JRSqlAbstractInClause