Package net.sf.jasperreports.engine.query

Class JRSqlNotInClause

java.lang.Object

net.sf.jasperreports.engine.query.JRSqlAbstractInClause

net.sf.jasperreports.engine.query.JRSqlNotInClause

All Implemented Interfaces:

JRClauseFunction

public class JRSqlNotInClause
extends JRSqlAbstractInClause

SQL "NOT 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_NOT_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 JRSqlNotInClause	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
JRSqlNotInClause()

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 JRSqlNotInClause	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_NOT_IN

protected static final String OPERATOR_NOT_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 JRSqlNotInClause singleton

Constructor Details

JRSqlNotInClause

public JRSqlNotInClause()

Method Details

instance

public static JRSqlNotInClause 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