org.outerj.xreporter.report.definition
Class ParameterSqlPart

java.lang.Object
  extended byorg.outerj.xreporter.report.definition.ParameterSqlPart
All Implemented Interfaces:
org.apache.avalon.framework.configuration.Configurable, SqlPart

public class ParameterSqlPart
extends java.lang.Object
implements SqlPart, org.apache.avalon.framework.configuration.Configurable

Inserts the value of a parameter into a SQL statement.


Field Summary
protected  java.lang.String ref
           
protected  java.lang.String sqlAfter
          An extra piece of sql to insert after the parameter (only if the parameter is required and/or has a value)
protected  java.lang.String sqlBefore
          An extra piece of sql to insert before the parameter (only if the parameter is required and/or has a value)
 
Constructor Summary
ParameterSqlPart()
           
 
Method Summary
 void addToSqlStatement(java.lang.StringBuffer statement, ExecutionContext executionContext)
          Adds a piece of SQL to the supplied StringBuffer
 int bind(java.sql.PreparedStatement statement, int start, ExecutionContext executionContext)
          Fills in any IN parameters that this SqlPart has added during the call to addToSqlStatement(java.lang.StringBuffer, org.outerj.xreporter.report.definition.ExecutionContext).
 void configure(org.apache.avalon.framework.configuration.Configuration configuration)
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

ref

protected java.lang.String ref

sqlBefore

protected java.lang.String sqlBefore
An extra piece of sql to insert before the parameter (only if the parameter is required and/or has a value)


sqlAfter

protected java.lang.String sqlAfter
An extra piece of sql to insert after the parameter (only if the parameter is required and/or has a value)

Constructor Detail

ParameterSqlPart

public ParameterSqlPart()
Method Detail

configure

public void configure(org.apache.avalon.framework.configuration.Configuration configuration)
               throws org.apache.avalon.framework.configuration.ConfigurationException
Specified by:
configure in interface org.apache.avalon.framework.configuration.Configurable
Throws:
org.apache.avalon.framework.configuration.ConfigurationException

addToSqlStatement

public void addToSqlStatement(java.lang.StringBuffer statement,
                              ExecutionContext executionContext)
Description copied from interface: SqlPart
Adds a piece of SQL to the supplied StringBuffer

Specified by:
addToSqlStatement in interface SqlPart

bind

public int bind(java.sql.PreparedStatement statement,
                int start,
                ExecutionContext executionContext)
         throws java.sql.SQLException
Description copied from interface: SqlPart
Fills in any IN parameters that this SqlPart has added during the call to SqlPart.addToSqlStatement(java.lang.StringBuffer, org.outerj.xreporter.report.definition.ExecutionContext).

Specified by:
bind in interface SqlPart
Returns:
the position where the next IN-parameter should come
Throws:
java.sql.SQLException