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 ([email protected])

See Also:

JRSqlAbstractInClause.apply(JRClauseTokens, JRQueryClauseContext)

Field Summary

Fields

Modifier and Type	Field and Description
protected static String	OPERATOR_AND_OR
protected static String	OPERATOR_NOT_IN
protected static String	OPERATOR_NULL
protected static JRSqlNotInClause	singleton

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

CLAUSE_TRUISM, 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_PARAMETER

Constructor Summary

Constructors

Constructor and Description
JRSqlNotInClause()

Method Summary

Modifier and Type	Method and Description
protected void	appendAndOrOperator(StringBuffer sBuffer)
protected void	appendInOperator(StringBuffer sBuffer)
protected void	appendNullOperator(StringBuffer sBuffer)
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 Detail

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 Detail

JRSqlNotInClause

public JRSqlNotInClause()

Method Detail

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