org.outerj.xreporter.report.definition
Class ParameterSqlPart

java.lang.Object
  org.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