|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object net.sf.jasperreports.engine.query.JRAbstractQueryExecuter net.sf.jasperreports.engine.query.JRJdbcQueryExecuter
public class JRJdbcQueryExecuter
JDBC query executer for SQL queries.
This query executer implementation offers built-in support for SQL queries.
Nested Class Summary |
---|
Nested classes/interfaces inherited from class net.sf.jasperreports.engine.query.JRAbstractQueryExecuter |
---|
JRAbstractQueryExecuter.QueryParameter |
Field Summary | |
---|---|
protected static java.lang.String |
CACHED_ROWSET_CLASS
|
protected static java.lang.String |
CLAUSE_ID_BETWEEN
|
protected static java.lang.String |
CLAUSE_ID_BETWEEN_CLOSED
|
protected static java.lang.String |
CLAUSE_ID_BETWEEN_LEFT_CLOSED
|
protected static java.lang.String |
CLAUSE_ID_BETWEEN_RIGHT_CLOSED
|
protected static java.lang.String |
CLAUSE_ID_EQUAL
|
protected static java.lang.String |
CLAUSE_ID_GREATER
|
protected static java.lang.String |
CLAUSE_ID_GREATER_OR_EQUAL
|
protected static java.lang.String |
CLAUSE_ID_IN
|
protected static java.lang.String |
CLAUSE_ID_LESS
|
protected static java.lang.String |
CLAUSE_ID_LESS_OR_EQUAL
|
protected static java.lang.String |
CLAUSE_ID_NOTEQUAL
|
protected static java.lang.String |
CLAUSE_ID_NOTIN
|
protected static java.lang.String |
CLOSE_CURSORS_AT_COMMIT
|
protected static java.lang.String |
CONCUR_READ_ONLY
|
protected static java.lang.String |
CONCUR_UPDATABLE
|
protected java.sql.Connection |
connection
|
protected static java.lang.String |
HOLD_CURSORS_OVER_COMMIT
|
protected java.sql.ResultSet |
resultSet
|
protected java.sql.PreparedStatement |
statement
The statement used to fire the query. |
protected static java.lang.String |
TYPE_FORWARD_ONLY
|
protected static java.lang.String |
TYPE_SCROLL_INSENSITIVE
|
protected static java.lang.String |
TYPE_SCROLL_SENSITIVE
|
Fields inherited from class net.sf.jasperreports.engine.query.JRAbstractQueryExecuter |
---|
CLAUSE_POSITION_ID, clauseFunctions, dataset |
Constructor Summary | |
---|---|
JRJdbcQueryExecuter(JasperReportsContext jasperReportsContext,
JRDataset dataset,
java.util.Map<java.lang.String,? extends JRValueParameter> parameters)
|
|
JRJdbcQueryExecuter(JRDataset dataset,
java.util.Map<java.lang.String,? extends JRValueParameter> parameters)
Deprecated. Replaced by JRJdbcQueryExecuter(JasperReportsContext, JRDataset, Map) . |
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.util.Calendar |
getParameterCalendar(JRPropertiesHolder properties)
|
protected java.lang.String |
getParameterReplacement(java.lang.String parameterName)
Returns the replacement text for a query parameter. |
java.sql.ResultSet |
getResultSet()
|
protected static int |
getResultSetType(java.lang.String type)
|
protected void |
registerFunctions()
Registers built-in clause functions . |
protected void |
setDate(int parameterIndex,
java.lang.Object parameterValue,
JRPropertiesHolder properties)
|
protected void |
setStatementMultiParameter(int parameterIndex,
java.lang.String parameterName,
int valueIndex,
java.lang.Object value,
JRPropertiesHolder properties)
|
protected int |
setStatementMultiParameters(int parameterIndex,
java.lang.String parameterName,
boolean ignoreNulls)
|
protected void |
setStatementParameter(int parameterIndex,
java.lang.Class<?> parameterType,
java.lang.Object parameterValue,
JRPropertiesHolder properties)
|
protected void |
setStatementParameter(int parameterIndex,
java.lang.String parameterName)
|
protected void |
setTime(int parameterIndex,
java.lang.Object parameterValue,
JRPropertiesHolder properties)
|
protected void |
setTimestamp(int parameterIndex,
java.lang.Object parameterValue,
JRPropertiesHolder properties)
|
protected void |
setTimeZone()
|
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
---|
protected static final java.lang.String CLAUSE_ID_IN
protected static final java.lang.String CLAUSE_ID_NOTIN
protected static final java.lang.String CLAUSE_ID_EQUAL
protected static final java.lang.String CLAUSE_ID_NOTEQUAL
protected static final java.lang.String CLAUSE_ID_LESS
protected static final java.lang.String CLAUSE_ID_GREATER
protected static final java.lang.String CLAUSE_ID_LESS_OR_EQUAL
protected static final java.lang.String CLAUSE_ID_GREATER_OR_EQUAL
protected static final java.lang.String CLAUSE_ID_BETWEEN
protected static final java.lang.String CLAUSE_ID_BETWEEN_CLOSED
protected static final java.lang.String CLAUSE_ID_BETWEEN_LEFT_CLOSED
protected static final java.lang.String CLAUSE_ID_BETWEEN_RIGHT_CLOSED
protected static final java.lang.String TYPE_FORWARD_ONLY
protected static final java.lang.String TYPE_SCROLL_INSENSITIVE
protected static final java.lang.String TYPE_SCROLL_SENSITIVE
protected static final java.lang.String CONCUR_READ_ONLY
protected static final java.lang.String CONCUR_UPDATABLE
protected static final java.lang.String HOLD_CURSORS_OVER_COMMIT
protected static final java.lang.String CLOSE_CURSORS_AT_COMMIT
protected static final java.lang.String CACHED_ROWSET_CLASS
protected java.sql.Connection connection
protected java.sql.PreparedStatement statement
protected java.sql.ResultSet resultSet
Constructor Detail |
---|
public JRJdbcQueryExecuter(JasperReportsContext jasperReportsContext, JRDataset dataset, java.util.Map<java.lang.String,? extends JRValueParameter> parameters)
public JRJdbcQueryExecuter(JRDataset dataset, java.util.Map<java.lang.String,? extends JRValueParameter> parameters)
JRJdbcQueryExecuter(JasperReportsContext, JRDataset, Map)
.
Method Detail |
---|
protected void registerFunctions()
clause functions
.
registerFunctions()
,
JRAbstractQueryExecuter.appendClauseChunk(StringBuffer, String[])
protected void setTimeZone()
protected java.lang.String getParameterReplacement(java.lang.String parameterName)
JRAbstractQueryExecuter
getParameterReplacement
in class JRAbstractQueryExecuter
parameterName
- the parameter name
JRQueryChunk.TYPE_PARAMETER
public JRDataSource createDatasource() throws JRException
JRQueryExecuter
JRDataSource
out of the result.
JRDataSource
wrapping the query execution result.
JRException
protected void createStatement() throws JRException
JRException
public java.sql.ResultSet getResultSet()
protected void setStatementParameter(int parameterIndex, java.lang.String parameterName) throws java.sql.SQLException
java.sql.SQLException
protected int setStatementMultiParameters(int parameterIndex, java.lang.String parameterName, boolean ignoreNulls) throws java.sql.SQLException
java.sql.SQLException
protected void setStatementMultiParameter(int parameterIndex, java.lang.String parameterName, int valueIndex, java.lang.Object value, JRPropertiesHolder properties) throws java.sql.SQLException
java.sql.SQLException
protected void setStatementParameter(int parameterIndex, java.lang.Class<?> parameterType, java.lang.Object parameterValue, JRPropertiesHolder properties) throws java.sql.SQLException
java.sql.SQLException
protected void setTimestamp(int parameterIndex, java.lang.Object parameterValue, JRPropertiesHolder properties) throws java.sql.SQLException
java.sql.SQLException
protected void setTime(int parameterIndex, java.lang.Object parameterValue, JRPropertiesHolder properties) throws java.sql.SQLException
java.sql.SQLException
protected void setDate(int parameterIndex, java.lang.Object parameterValue, JRPropertiesHolder properties) throws java.sql.SQLException
java.sql.SQLException
protected java.util.Calendar getParameterCalendar(JRPropertiesHolder properties)
public void close()
JRQueryExecuter
createDatasource
.
public boolean cancelQuery() throws JRException
JRQueryExecuter
true
if and only if the query was running and it has been canceled
JRException
protected static int getResultSetType(java.lang.String type)
protected static int getConcurrency(java.lang.String concurrency)
protected static int getHoldability(java.lang.String holdability, java.sql.Connection connection) throws java.sql.SQLException
java.sql.SQLException
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |