| java.lang.Object
 net.sf.jasperreports.engine.query.JRSqlAbstractInClause
All known Subclasses: net.sf.jasperreports.engine.query.JRSqlNotInClause, net.sf.jasperreports.engine.query.JRSqlInClause,
| JRSqlAbstractInClause | | abstract public class JRSqlAbstractInClause implements JRClauseFunction(Code) | | Base (NOT) IN clause function for SQL queries.
author:
Lucian Chirita (lucianc@users.sourceforge.net)
version:
$Id: JRSqlAbstractInClause.java 1683 2007-03-29 16:04:15Z lucianc $ |
| Method Summary | |
| abstract protected void | appendInOperator(StringBuffer sBuffer)
| | public void | apply(JRClauseTokens clauseTokens, JRQueryClauseContext queryContext)
Creates a (NOT) IN SQL clause.
The function expects two clause tokens (after the ID token):
- The first token is the SQL column to be used in the clause.
- The second token is the name of the report parameter that contains the value list.
The value of this parameter has to be an array, a java.util.Collection
or null.
The function constructs a column [NOT] IN (?, ?, .., ?) clause.
If the values list is null or empty, the function generates a SQL clause that
will always evaluate to true (e.g. | | protected void | handleNoValues(JRQueryClauseContext queryContext)
| | protected int | valuesCount(String paramName, Object paramValue)
|
| CLAUSE_TRUISM | | final protected static String CLAUSE_TRUISM(Code) | | |
| POSITION_DB_COLUMN | | final protected static int POSITION_DB_COLUMN(Code) | | |
| POSITION_PARAMETER | | final protected static int POSITION_PARAMETER(Code) | | |
| JRSqlAbstractInClause | | protected JRSqlAbstractInClause()(Code) | | |
| apply | | public void apply(JRClauseTokens clauseTokens, JRQueryClauseContext queryContext)(Code) | | Creates a (NOT) IN SQL clause.
The function expects two clause tokens (after the ID token):
- The first token is the SQL column to be used in the clause.
- The second token is the name of the report parameter that contains the value list.
The value of this parameter has to be an array, a java.util.Collection
or null.
The function constructs a column [NOT] IN (?, ?, .., ?) clause.
If the values list is null or empty, the function generates a SQL clause that
will always evaluate to true (e.g. 0 = 0).
|
|
|