xdev.db.jdbc

Class JDBCPager

java.lang.Object

xdev.db.jdbc.JDBCPager

All Implemented Interfaces:

AutoCloseable, DBPager

public class JDBCPager
extends Object
implements DBPager

Since:

4.0

Author:

XDEV Software (HL)

Constructor Summary

Constructors

Constructor and Description
JDBCPager(JDBCConnection connection, QueryInfo queryInfo, ResultSet resultSet, int rowsPerPage)

Method Summary

Modifier and Type	Method and Description
void	close() Closes the pager and its underlying resources.
Result	firstPage() Scrolls to the first Page
int	getCurrentPageIndex() returns the number of the current Page
DBDataSource<?>	getDataSource()
int	getMaxPageIndex() returns the number of the last Page
int	getRowsPerPage() Returns the number of rows to be shown on a page.
int	getTotalRows() Returns the number of all rows, returned from the database
Result	gotoPage(int page) Scrolls to the given pageNumber
Result	gotoRow(int row) Scrolls to the given row
boolean	hasNextPage()
boolean	hasPreviousPage()
boolean	isClosed()
Result	lastPage() Scrolls to the last Page
Result	nextPage() Scrolls to the next Page
Result	previousPage() Scrolls to the previous Page
Result	setRowsPerPage(int rowsPerPage) Sets the number of rows to be shown on a page and returns the new result of the current page.

Methods inherited from class java.lang.Object

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

Constructor Detail

JDBCPager

public JDBCPager(JDBCConnection connection,
                 QueryInfo queryInfo,
                 ResultSet resultSet,
                 int rowsPerPage)
          throws DBException

Throws:

DBException

Method Detail

getDataSource

public DBDataSource<?> getDataSource()

Specified by:

getDataSource in interface DBPager

Returns:

the datasource of this pager

setRowsPerPage

public Result setRowsPerPage(int rowsPerPage)
                      throws DBException

Description copied from interface: DBPager

Sets the number of rows to be shown on a page and returns the new result of the current page.

Specified by:

setRowsPerPage in interface DBPager

Parameters:

rowsPerPage - int

Throws:

DBException

getRowsPerPage

public int getRowsPerPage()

Description copied from interface: DBPager

Returns the number of rows to be shown on a page.

Specified by:

getRowsPerPage in interface DBPager

Returns:

rowsPerPage int

getTotalRows

public int getTotalRows()

Description copied from interface: DBPager

Returns the number of all rows, returned from the database

Specified by:

getTotalRows in interface DBPager

Returns:

totalRows int

getCurrentPageIndex

public int getCurrentPageIndex()

Description copied from interface: DBPager

returns the number of the current Page

Specified by:

getCurrentPageIndex in interface DBPager

Returns:

int

getMaxPageIndex

public int getMaxPageIndex()

Description copied from interface: DBPager

returns the number of the last Page

Specified by:

getMaxPageIndex in interface DBPager

Returns:

int

hasNextPage

public boolean hasNextPage()

Specified by:

hasNextPage in interface DBPager

Returns:

true if the pager can go forward

hasPreviousPage

public boolean hasPreviousPage()

Specified by:

hasPreviousPage in interface DBPager

Returns:

true if the pager can go backward

nextPage

public Result nextPage()
                throws DBException

Description copied from interface: DBPager

Scrolls to the next Page

Specified by:

nextPage in interface DBPager

Throws:

DBException

previousPage

public Result previousPage()
                    throws DBException

Description copied from interface: DBPager

Scrolls to the previous Page

Specified by:

previousPage in interface DBPager

Throws:

DBException

firstPage

public Result firstPage()
                 throws DBException

Description copied from interface: DBPager

Scrolls to the first Page

Specified by:

firstPage in interface DBPager

Throws:

DBException

lastPage

public Result lastPage()
                throws DBException

Description copied from interface: DBPager

Scrolls to the last Page

Specified by:

lastPage in interface DBPager

Throws:

DBException

gotoPage

public Result gotoPage(int page)
                throws DBException

Description copied from interface: DBPager

Scrolls to the given pageNumber

Specified by:

gotoPage in interface DBPager

Throws:

DBException

gotoRow

public Result gotoRow(int row)
               throws DBException

Description copied from interface: DBPager

Scrolls to the given row

Specified by:

gotoRow in interface DBPager

Throws:

DBException

close

public void close()
           throws DBException

Description copied from interface: DBPager

Closes the pager and its underlying resources.

Specified by:

close in interface AutoCloseable

Specified by:

close in interface DBPager

Throws:

DBException

isClosed

public boolean isClosed()
                 throws DBException

Specified by:

isClosed in interface DBPager

Returns:

true if this pager or an underlying resource has been closed, false otherwise

Throws:

DBException