net.sf.jasperreports.engine.query
Class JRJdbcQueryExecuter
java.lang.Object
net.sf.jasperreports.engine.query.JRAbstractQueryExecuter
net.sf.jasperreports.engine.query.JRJdbcQueryExecuter
- All Implemented Interfaces:
- JRQueryExecuter
public class JRJdbcQueryExecuter
- extends JRAbstractQueryExecuter
JDBC query executer for SQL queries.
This query executer implementation offers built-in support for SQL queries.
- Version:
- $Id: JRJdbcQueryExecuter.java 4170 2011-01-27 12:31:13Z shertage $
- Author:
- Teodor Danciu (teodord@users.sourceforge.net)
Method Summary |
boolean |
cancelQuery()
Cancels the query if it's currently running. |
void |
close()
Closes resources kept open during the data source iteration. |
JRDataSource |
createDatasource()
Executes the query and creates a JRDataSource out of the result. |
protected void |
createStatement()
|
protected static int |
getConcurrency(java.lang.String concurrency)
|
protected static int |
getHoldability(java.lang.String holdability,
java.sql.Connection connection)
|
protected java.lang.String |
getParameterReplacement(java.lang.String parameterName)
Returns the replacement text for a query parameter. |
protected static int |
getResultSetType(java.lang.String type)
|
protected void |
registerFunctions()
Registers built-in clause functions . |
protected void |
setStatementMultiParameter(int parameterIndex,
java.lang.String parameterName,
int valueIndex,
java.lang.Object value)
|
protected int |
setStatementMultiParameters(int parameterIndex,
java.lang.String parameterName)
|
protected int |
setStatementMultiParameters(int parameterIndex,
java.lang.String parameterName,
boolean ignoreNulls)
|
protected void |
setStatementParameter(int parameterIndex,
java.lang.Class parameterType,
java.lang.Object parameterValue)
|
protected void |
setStatementParameter(int parameterIndex,
java.lang.String parameterName)
|
Methods inherited from class net.sf.jasperreports.engine.query.JRAbstractQueryExecuter |
addQueryMultiParameters, addQueryMultiParameters, addQueryParameter, appendClauseChunk, appendParameterChunk, appendParameterClauseChunk, appendQueryChunk, appendTextChunk, applyClause, checkParameter, getBooleanParameter, getBooleanParameterOrProperty, getCollectedParameterNames, getCollectedParameters, getParameter, getParameterValue, getParameterValue, getQueryString, getStringParameter, getStringParameterOrProperty, getValueParameter, getValueParameter, parameterHasValue, parseQuery, registerClauseFunction, resolveFunction, unregisterClauseFunction |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
CLAUSE_ID_IN
protected static final java.lang.String CLAUSE_ID_IN
- See Also:
- Constant Field Values
CLAUSE_ID_NOTIN
protected static final java.lang.String CLAUSE_ID_NOTIN
- See Also:
- Constant Field Values
CLAUSE_ID_EQUAL
protected static final java.lang.String CLAUSE_ID_EQUAL
- See Also:
- Constant Field Values
CLAUSE_ID_NOTEQUAL
protected static final java.lang.String CLAUSE_ID_NOTEQUAL
- See Also:
- Constant Field Values
CLAUSE_ID_LESS
protected static final java.lang.String CLAUSE_ID_LESS
- See Also:
- Constant Field Values
CLAUSE_ID_GREATER
protected static final java.lang.String CLAUSE_ID_GREATER
- See Also:
- Constant Field Values
CLAUSE_ID_LESS_OR_EQUAL
protected static final java.lang.String CLAUSE_ID_LESS_OR_EQUAL
- See Also:
- Constant Field Values
CLAUSE_ID_GREATER_OR_EQUAL
protected static final java.lang.String CLAUSE_ID_GREATER_OR_EQUAL
- See Also:
- Constant Field Values
CLAUSE_ID_BETWEEN
protected static final java.lang.String CLAUSE_ID_BETWEEN
- See Also:
- Constant Field Values
CLAUSE_ID_BETWEEN_CLOSED
protected static final java.lang.String CLAUSE_ID_BETWEEN_CLOSED
- See Also:
- Constant Field Values
CLAUSE_ID_BETWEEN_LEFT_CLOSED
protected static final java.lang.String CLAUSE_ID_BETWEEN_LEFT_CLOSED
- See Also:
- Constant Field Values
CLAUSE_ID_BETWEEN_RIGHT_CLOSED
protected static final java.lang.String CLAUSE_ID_BETWEEN_RIGHT_CLOSED
- See Also:
- Constant Field Values
TYPE_FORWARD_ONLY
protected static final java.lang.String TYPE_FORWARD_ONLY
- See Also:
- Constant Field Values
TYPE_SCROLL_INSENSITIVE
protected static final java.lang.String TYPE_SCROLL_INSENSITIVE
- See Also:
- Constant Field Values
TYPE_SCROLL_SENSITIVE
protected static final java.lang.String TYPE_SCROLL_SENSITIVE
- See Also:
- Constant Field Values
CONCUR_READ_ONLY
protected static final java.lang.String CONCUR_READ_ONLY
- See Also:
- Constant Field Values
CONCUR_UPDATABLE
protected static final java.lang.String CONCUR_UPDATABLE
- See Also:
- Constant Field Values
HOLD_CURSORS_OVER_COMMIT
protected static final java.lang.String HOLD_CURSORS_OVER_COMMIT
- See Also:
- Constant Field Values
CLOSE_CURSORS_AT_COMMIT
protected static final java.lang.String CLOSE_CURSORS_AT_COMMIT
- See Also:
- Constant Field Values
JRJdbcQueryExecuter
public JRJdbcQueryExecuter(JRDataset dataset,
java.util.Map parameters)
registerFunctions
protected void registerFunctions()
- Registers built-in
clause functions
.
- See Also:
registerFunctions()
,
JRAbstractQueryExecuter.appendClauseChunk(StringBuffer, String[])
getParameterReplacement
protected java.lang.String getParameterReplacement(java.lang.String parameterName)
- Description copied from class:
JRAbstractQueryExecuter
- Returns the replacement text for a query parameter.
- Specified by:
getParameterReplacement
in class JRAbstractQueryExecuter
- Parameters:
parameterName
- the parameter name
- Returns:
- the replacement text
- See Also:
JRQueryChunk.TYPE_PARAMETER
createDatasource
public JRDataSource createDatasource()
throws JRException
- Description copied from interface:
JRQueryExecuter
- Executes the query and creates a
JRDataSource
out of the result.
- Returns:
- a
JRDataSource
wrapping the query execution result.
- Throws:
JRException
createStatement
protected void createStatement()
throws JRException
- Throws:
JRException
setStatementParameter
protected void setStatementParameter(int parameterIndex,
java.lang.String parameterName)
throws java.sql.SQLException
- Throws:
java.sql.SQLException
setStatementMultiParameters
protected int setStatementMultiParameters(int parameterIndex,
java.lang.String parameterName,
boolean ignoreNulls)
throws java.sql.SQLException
- Throws:
java.sql.SQLException
setStatementMultiParameters
protected int setStatementMultiParameters(int parameterIndex,
java.lang.String parameterName)
throws java.sql.SQLException
- Throws:
java.sql.SQLException
setStatementMultiParameter
protected void setStatementMultiParameter(int parameterIndex,
java.lang.String parameterName,
int valueIndex,
java.lang.Object value)
throws java.sql.SQLException
- Throws:
java.sql.SQLException
setStatementParameter
protected void setStatementParameter(int parameterIndex,
java.lang.Class parameterType,
java.lang.Object parameterValue)
throws java.sql.SQLException
- Throws:
java.sql.SQLException
close
public void close()
- Description copied from interface:
JRQueryExecuter
- Closes resources kept open during the data source iteration.
This method is called after the report is filled or the dataset is iterated.
If a resource is not needed after the data source has been created, it should be
released at the end of
createDatasource
.
cancelQuery
public boolean cancelQuery()
throws JRException
- Description copied from interface:
JRQueryExecuter
- Cancels the query if it's currently running.
This method will be called from a different thread if the client decides to
cancel the filling process.
- Returns:
true
if and only if the query was running and it has been canceled
- Throws:
JRException
getResultSetType
protected static int getResultSetType(java.lang.String type)
getConcurrency
protected static int getConcurrency(java.lang.String concurrency)
getHoldability
protected static int getHoldability(java.lang.String holdability,
java.sql.Connection connection)
throws java.sql.SQLException
- Throws:
java.sql.SQLException
© 2001-2010 Jaspersoft Corporation www.jaspersoft.com