org.pentaho.platform.plugin.services.connections.sql

Class SQLResultSet

java.lang.Object

org.pentaho.platform.plugin.services.connections.sql.SQLResultSet

All Implemented Interfaces:

org.pentaho.commons.connection.IDisposable, org.pentaho.commons.connection.IPeekable, org.pentaho.commons.connection.IPentahoResultSet

public class SQLResultSet
extends Object
implements org.pentaho.commons.connection.IPentahoResultSet, org.pentaho.commons.connection.IPeekable

Author:

wseyler TODO To change the template for this generated type comment go to Window - Preferences - Java - Code Style - Code Templates

Constructor Summary

Constructors

Constructor and Description
SQLResultSet(ResultSet nativeResultSet, SQLConnection nativeConnection)

Method Summary

Modifier and Type	Method and Description
void	beforeFirst()
void	close()
void	closeConnection()
void	dispose()
int	getColumnCount() Returns the column count from the result set.
Object[]	getDataColumn(int column)
Object[]	getDataRow(int row)
org.pentaho.commons.connection.IPentahoMetaData	getMetaData()
int	getRowCount() Get a rowCount from the resultset.
Object	getValueAt(int row, int column) Returns the value of the specified row and the specified column from within the resultset.
boolean	isScrollable()
org.pentaho.commons.connection.IPentahoResultSet	memoryCopy() Attention: It does not clone data! It is create the shallow copy of metadata! It is create the shallow copy of data.
Object[]	next() (non-Javadoc)
Object[]	peek()
void	setMetaData(org.pentaho.commons.connection.IPentahoMetaData metadata)

Methods inherited from class java.lang.Object

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

Constructor Detail

SQLResultSet

public SQLResultSet(ResultSet nativeResultSet,
                    SQLConnection nativeConnection)

Method Detail

setMetaData

public void setMetaData(org.pentaho.commons.connection.IPentahoMetaData metadata)

getMetaData

public org.pentaho.commons.connection.IPentahoMetaData getMetaData()

Specified by:

getMetaData in interface org.pentaho.commons.connection.IPentahoResultSet

peek

public Object[] peek()

Specified by:

peek in interface org.pentaho.commons.connection.IPeekable

next

public Object[] next()

(non-Javadoc)

Specified by:

next in interface org.pentaho.commons.connection.IPentahoResultSet

Throws:

SQLResultSetException

See Also:

returns null if no more rows

closeConnection

public void closeConnection()

Specified by:

closeConnection in interface org.pentaho.commons.connection.IPentahoResultSet

close

public void close()

Specified by:

close in interface org.pentaho.commons.connection.IPentahoResultSet

dispose

public void dispose()

Specified by:

dispose in interface org.pentaho.commons.connection.IDisposable

isScrollable

public boolean isScrollable()

Specified by:

isScrollable in interface org.pentaho.commons.connection.IPentahoResultSet

getColumnCount

public int getColumnCount()

Returns the column count from the result set.

Specified by:

getColumnCount in interface org.pentaho.commons.connection.IPentahoResultSet

Returns:

the column count.

getRowCount

public int getRowCount()

Get a rowCount from the resultset. If the resultset

Specified by:

getRowCount in interface org.pentaho.commons.connection.IPentahoResultSet

Returns:

the row count.

getValueAt

public Object getValueAt(int row,
                         int column)

Returns the value of the specified row and the specified column from within the resultset.

Specified by:

getValueAt in interface org.pentaho.commons.connection.IPentahoResultSet

Parameters:

row - the row index.

column - the column index.

Returns:

the value.

memoryCopy

public org.pentaho.commons.connection.IPentahoResultSet memoryCopy()

Attention: It does not clone data! It is create the shallow copy of metadata! It is create the shallow copy of data. You must avoid to use this method.

Specified by:

memoryCopy in interface org.pentaho.commons.connection.IPentahoResultSet

Returns:

new instance the MemoryResultSet with same metadata

beforeFirst

public void beforeFirst()

Specified by:

beforeFirst in interface org.pentaho.commons.connection.IPentahoResultSet

getDataColumn

public Object[] getDataColumn(int column)

Specified by:

getDataColumn in interface org.pentaho.commons.connection.IPentahoResultSet

getDataRow

public Object[] getDataRow(int row)

Specified by:

getDataRow in interface org.pentaho.commons.connection.IPentahoResultSet