org.j2ee.dao.util
Class HibernateDB2NTopWrapperAction

java.lang.Object
  |
  +--org.j2ee.dao.AbstractHibernateDAOAction
        |
        +--org.j2ee.dao.util.AbstractPageByPageAction
              |
              +--org.j2ee.dao.util.HibernateDB2NTopWrapperAction

All Implemented Interfaces:

DAOAction, HibernateDAOAction

public class HibernateDB2NTopWrapperAction

extends AbstractPageByPageAction

Last modified $Date: 2004/05/18 10:50:17 $

Version:

$Revision: 1.1.1.1 $

Author:

mochoa (mochoa@users.sourceforge.net)

Field Summary

Fields inherited from class org.j2ee.dao.util.AbstractPageByPageAction

action

Fields inherited from interface org.j2ee.dao.HibernateDAOAction

DELETE, HQL_QUERY, LOAD, SAVE, SQL_QUERY, UPDATE

Constructor Summary

HibernateDB2NTopWrapperAction()

HibernateDB2NTopWrapperAction(int fromNo, int toNo)

Method Summary

java.lang.String

getSQL() This method must return a valid SQL query, it will receive all the named parameters defined by the action object plus two aditionals parameters named firstRow and lastRow representing the values for the window to be select.

Methods inherited from class org.j2ee.dao.util.AbstractPageByPageAction

getAction, getFrom, getList, getNamesForParams, getParameters, getReturnAliasForSqlQuery, getReturnClassForSqlQuery, getTo, handleResults, print, setAction, setFrom, setTo

Methods inherited from class org.j2ee.dao.AbstractHibernateDAOAction

execute, getHQL, getStmtType, getTO, handleResult, handleResult, isCaching, isDelete, isHqlQuery, isLoad, isSave, isSqlQuery, isUpdate, setCaching, setErrorHandler, setStmtType, setTO

Methods inherited from class java.lang.Object

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

Constructor Detail

HibernateDB2NTopWrapperAction

public HibernateDB2NTopWrapperAction()

HibernateDB2NTopWrapperAction

public HibernateDB2NTopWrapperAction(int fromNo,
                                     int toNo)

Method Detail

getSQL

public java.lang.String getSQL()

Description copied from class: AbstractPageByPageAction

This method must return a valid SQL query, it will receive all the named parameters defined by the action object plus two aditionals parameters named firstRow and lastRow representing the values for the window to be select.

Specified by:

getSQL in interface HibernateDAOAction

Specified by:

getSQL in class AbstractPageByPageAction

Returns:

an String using DB2's syntax for Limit—with offset querys. http://troels.arvin.dk/db/rdbms/ for more information.