org.j2ee.dao.util
Class JdbcOracleNTopQueryWrapperAction

java.lang.Object
  |
  +--org.j2ee.dao.AbstractJdbcDAOAction
        |
        +--org.j2ee.dao.util.JdbcOracleNTopQueryWrapperAction

All Implemented Interfaces:

DAOAction, JdbcDAOAction

public class JdbcOracleNTopQueryWrapperAction

extends AbstractJdbcDAOAction

Action Wrapper that implements the N-Top Query Last modified $Date: 2004/05/18 10:50:18 $

Version:

$Revision: 1.1.1.1 $

Author:

jvlio (jvlio@users.sourceforge.net)

Field Summary

Fields inherited from interface org.j2ee.dao.JdbcDAOAction

CALL_FUNCTION, CALL_PROCEDURE, DDL, NO_OUT_PARAM, QUERY, UPDATE

Constructor Summary

JdbcOracleNTopQueryWrapperAction()

JdbcOracleNTopQueryWrapperAction(org.j2ee.dao.JdbcDAOAction action)

Method Summary

void	cachPreparedStatement(java.sql.PreparedStatement pstmt)
org.j2ee.dao.JdbcDAOAction	getAction()
int[]	getDataTypesForParams() This method retuns the SQL Type for parameters to be setted to sql statement.
long	getFirstRow()
int	getNumberOfRows()
java.lang.Object[]	getParameters() This method retuns the parameters to be setted to sql statement.
java.sql.PreparedStatement	getPreparedStatement()
java.lang.String	getSQL() This method define the sql statement to be executed.
void	handleResults(java.sql.ResultSet rs) Handle the results of query statements. If the statement is of type QUERY (select), then when the execution of the statement finalize and no exception occurs, this method is call for handle the results.
boolean	isCaching()
void	setAction(org.j2ee.dao.JdbcDAOAction action)
void	setCaching(boolean caching)
void	setFirstRow(long firstRow)
void	setNumberOfRows(int numberOfRows)

Methods inherited from class org.j2ee.dao.AbstractJdbcDAOAction

execute, getDataTypesForOutParams, getStmtType, getTO, handleResults, handleResults, isCall, isQuery, isUpdate, setErrorHandler, setStmtType, setTO

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

JdbcOracleNTopQueryWrapperAction

public JdbcOracleNTopQueryWrapperAction()

JdbcOracleNTopQueryWrapperAction

public JdbcOracleNTopQueryWrapperAction(org.j2ee.dao.JdbcDAOAction action)

Method Detail

getNumberOfRows

public int getNumberOfRows()

setNumberOfRows

public void setNumberOfRows(int numberOfRows)

getFirstRow

public long getFirstRow()

setFirstRow

public void setFirstRow(long firstRow)

getAction

public org.j2ee.dao.JdbcDAOAction getAction()

setAction

public void setAction(org.j2ee.dao.JdbcDAOAction action)

getSQL

public java.lang.String getSQL()

Description copied from interface: JdbcDAOAction

This method define the sql statement to be executed.

Specified by:

getSQL in interface JdbcDAOAction

Specified by:

getSQL in class AbstractJdbcDAOAction

Returns:

SQL Statement

getParameters

public java.lang.Object[] getParameters()

Description copied from interface: JdbcDAOAction

This method retuns the parameters to be setted to sql statement.

Specified by:

getParameters in interface JdbcDAOAction

Overrides:

getParameters in class AbstractJdbcDAOAction

Returns:

sql statement parameters values.

getDataTypesForParams

public int[] getDataTypesForParams()

Description copied from interface: JdbcDAOAction

This method retuns the SQL Type for parameters to be setted to sql statement. If this statement has not parameters, null can be returned.

Specified by:

getDataTypesForParams in interface JdbcDAOAction

Overrides:

getDataTypesForParams in class AbstractJdbcDAOAction

Returns:

sql statement parameters types.

See Also:

Types

handleResults

public void handleResults(java.sql.ResultSet rs)
                   throws java.sql.SQLException

Description copied from interface: JdbcDAOAction

Handle the results of query statements.
If the statement is of type QUERY (select), then when the execution of the statement finalize and no exception occurs, this method is call for handle the results.

Specified by:

handleResults in interface JdbcDAOAction

Overrides:

handleResults in class AbstractJdbcDAOAction

Parameters:

rs - ResultSet returned by query.

java.sql.SQLException

cachPreparedStatement

public void cachPreparedStatement(java.sql.PreparedStatement pstmt)

Specified by:

cachPreparedStatement in interface JdbcDAOAction

Overrides:

cachPreparedStatement in class AbstractJdbcDAOAction

getPreparedStatement

public java.sql.PreparedStatement getPreparedStatement()

Specified by:

getPreparedStatement in interface JdbcDAOAction

Overrides:

getPreparedStatement in class AbstractJdbcDAOAction

isCaching

public boolean isCaching()

Specified by:

isCaching in interface JdbcDAOAction

Overrides:

isCaching in class AbstractJdbcDAOAction

setCaching

public void setCaching(boolean caching)

Specified by:

setCaching in interface JdbcDAOAction

Overrides:

setCaching in class AbstractJdbcDAOAction