Package totalcross.sql.sqlite4j

Class SQLite4JResultSet

java.lang.Object

totalcross.sql.sqlite4j.SQLite4JResultSet

All Implemented Interfaces:

java.lang.AutoCloseable, ResultSet

public class SQLite4JResultSet
extends java.lang.Object
implements ResultSet

Field Summary

Fields inherited from interface totalcross.sql.ResultSet

CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE

Constructor Summary

Constructors

Constructor	Description
SQLite4JResultSet(java.sql.ResultSet rs)

Method Summary

Modifier and Type	Method	Description
boolean	absolute(int row)
void	afterLast()
void	beforeFirst()
void	clearWarnings()
void	close()
int	findColumn(java.lang.String columnName)
boolean	first()
BigDecimal	getBigDecimal(int columnIndex)
BigDecimal	getBigDecimal(int columnIndex, int scale)
BigDecimal	getBigDecimal(java.lang.String columnName)
BigDecimal	getBigDecimal(java.lang.String columnName, int scale)
boolean	getBoolean(int columnIndex)
boolean	getBoolean(java.lang.String columnName)
byte	getByte(int columnIndex)
byte	getByte(java.lang.String columnName)
byte[]	getBytes(int columnIndex)
byte[]	getBytes(java.lang.String columnName)
int	getConcurrency()
java.lang.String	getCursorName()
Date	getDate(int columnIndex)
Date	getDate(java.lang.String columnName)
double	getDouble(int columnIndex)
double	getDouble(java.lang.String columnName)
int	getFetchDirection()
int	getFetchSize()
double	getFloat(int columnIndex)
double	getFloat(java.lang.String columnName)
int	getInt(int columnIndex)
int	getInt(java.lang.String columnName)
long	getLong(int columnIndex)
long	getLong(java.lang.String columnName)
ResultSetMetaData	getMetaData()
java.lang.Object	getObject(int columnIndex)
java.lang.Object	getObject(java.lang.String columnName)
int	getRow()
short	getShort(int columnIndex)
short	getShort(java.lang.String columnName)
Statement	getStatement()
java.lang.String	getString(int columnIndex)
java.lang.String	getString(java.lang.String columnName)
Time	getTime(int columnIndex)
Time	getTime(java.lang.String columnName)
Timestamp	getTimestamp(int columnIndex)
Timestamp	getTimestamp(java.lang.String columnName)
int	getType()
java.sql.SQLWarning	getWarnings()
boolean	isAfterLast()
boolean	isBeforeFirst()
boolean	isFirst()
boolean	isLast()
boolean	last()
boolean	next()
boolean	previous()
boolean	relative(int rows)
void	setFetchDirection(int direction)
void	setFetchSize(int rows)
boolean	wasNull()

Methods inherited from class java.lang.Object

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

Constructor Detail

SQLite4JResultSet

public SQLite4JResultSet(java.sql.ResultSet rs)

Method Detail

next

public boolean next()
             throws java.sql.SQLException

Specified by:

next in interface ResultSet

Throws:

java.sql.SQLException

close

public void close()
           throws java.sql.SQLException

Specified by:

close in interface java.lang.AutoCloseable

Specified by:

close in interface ResultSet

Throws:

java.sql.SQLException

wasNull

public boolean wasNull()
                throws java.sql.SQLException

Specified by:

wasNull in interface ResultSet

Throws:

java.sql.SQLException

getString

public java.lang.String getString(int columnIndex)
                           throws java.sql.SQLException

Specified by:

getString in interface ResultSet

Throws:

java.sql.SQLException

getBoolean

public boolean getBoolean(int columnIndex)
                   throws java.sql.SQLException

Specified by:

getBoolean in interface ResultSet

Throws:

java.sql.SQLException

getByte

public byte getByte(int columnIndex)
             throws java.sql.SQLException

Specified by:

getByte in interface ResultSet

Throws:

java.sql.SQLException

getShort

public short getShort(int columnIndex)
               throws java.sql.SQLException

Specified by:

getShort in interface ResultSet

Throws:

java.sql.SQLException

getInt

public int getInt(int columnIndex)
           throws java.sql.SQLException

Specified by:

getInt in interface ResultSet

Throws:

java.sql.SQLException

getLong

public long getLong(int columnIndex)
             throws java.sql.SQLException

Specified by:

getLong in interface ResultSet

Throws:

java.sql.SQLException

getFloat

public double getFloat(int columnIndex)
                throws java.sql.SQLException

Throws:

java.sql.SQLException

getDouble

public double getDouble(int columnIndex)
                 throws java.sql.SQLException

Specified by:

getDouble in interface ResultSet

Throws:

java.sql.SQLException

getBigDecimal

public BigDecimal getBigDecimal(int columnIndex,
                                int scale)
                         throws java.sql.SQLException

Specified by:

getBigDecimal in interface ResultSet

Throws:

java.sql.SQLException

getBytes

public byte[] getBytes(int columnIndex)
                throws java.sql.SQLException

Specified by:

getBytes in interface ResultSet

Throws:

java.sql.SQLException

getDate

public Date getDate(int columnIndex)
             throws java.sql.SQLException

Specified by:

getDate in interface ResultSet

Throws:

java.sql.SQLException

getTime

public Time getTime(int columnIndex)
             throws java.sql.SQLException

Specified by:

getTime in interface ResultSet

Throws:

java.sql.SQLException

getTimestamp

public Timestamp getTimestamp(int columnIndex)
                       throws java.sql.SQLException

Specified by:

getTimestamp in interface ResultSet

Throws:

java.sql.SQLException

getString

public java.lang.String getString(java.lang.String columnName)
                           throws java.sql.SQLException

Specified by:

getString in interface ResultSet

Throws:

java.sql.SQLException

getBoolean

public boolean getBoolean(java.lang.String columnName)
                   throws java.sql.SQLException

Specified by:

getBoolean in interface ResultSet

Throws:

java.sql.SQLException

getByte

public byte getByte(java.lang.String columnName)
             throws java.sql.SQLException

Specified by:

getByte in interface ResultSet

Throws:

java.sql.SQLException

getShort

public short getShort(java.lang.String columnName)
               throws java.sql.SQLException

Specified by:

getShort in interface ResultSet

Throws:

java.sql.SQLException

getInt

public int getInt(java.lang.String columnName)
           throws java.sql.SQLException

Specified by:

getInt in interface ResultSet

Throws:

java.sql.SQLException

getLong

public long getLong(java.lang.String columnName)
             throws java.sql.SQLException

Specified by:

getLong in interface ResultSet

Throws:

java.sql.SQLException

getFloat

public double getFloat(java.lang.String columnName)
                throws java.sql.SQLException

Throws:

java.sql.SQLException

getDouble

public double getDouble(java.lang.String columnName)
                 throws java.sql.SQLException

Specified by:

getDouble in interface ResultSet

Throws:

java.sql.SQLException

getBigDecimal

public BigDecimal getBigDecimal(java.lang.String columnName,
                                int scale)
                         throws java.sql.SQLException

Specified by:

getBigDecimal in interface ResultSet

Throws:

java.sql.SQLException

getBytes

public byte[] getBytes(java.lang.String columnName)
                throws java.sql.SQLException

Specified by:

getBytes in interface ResultSet

Throws:

java.sql.SQLException

getDate

public Date getDate(java.lang.String columnName)
             throws java.sql.SQLException

Specified by:

getDate in interface ResultSet

Throws:

java.sql.SQLException

getTime

public Time getTime(java.lang.String columnName)
             throws java.sql.SQLException

Specified by:

getTime in interface ResultSet

Throws:

java.sql.SQLException

getTimestamp

public Timestamp getTimestamp(java.lang.String columnName)
                       throws java.sql.SQLException

Specified by:

getTimestamp in interface ResultSet

Throws:

java.sql.SQLException

getWarnings

public java.sql.SQLWarning getWarnings()
                                throws java.sql.SQLException

Specified by:

getWarnings in interface ResultSet

Throws:

java.sql.SQLException

clearWarnings

public void clearWarnings()
                   throws java.sql.SQLException

Specified by:

clearWarnings in interface ResultSet

Throws:

java.sql.SQLException

getCursorName

public java.lang.String getCursorName()
                               throws java.sql.SQLException

Specified by:

getCursorName in interface ResultSet

Throws:

java.sql.SQLException

getMetaData

public ResultSetMetaData getMetaData()
                              throws java.sql.SQLException

Specified by:

getMetaData in interface ResultSet

Throws:

java.sql.SQLException

getObject

public java.lang.Object getObject(int columnIndex)
                           throws java.sql.SQLException

Specified by:

getObject in interface ResultSet

Throws:

java.sql.SQLException

getObject

public java.lang.Object getObject(java.lang.String columnName)
                           throws java.sql.SQLException

Specified by:

getObject in interface ResultSet

Throws:

java.sql.SQLException

findColumn

public int findColumn(java.lang.String columnName)
               throws java.sql.SQLException

Specified by:

findColumn in interface ResultSet

Throws:

java.sql.SQLException

getBigDecimal

public BigDecimal getBigDecimal(int columnIndex)
                         throws java.sql.SQLException

Specified by:

getBigDecimal in interface ResultSet

Throws:

java.sql.SQLException

getBigDecimal

public BigDecimal getBigDecimal(java.lang.String columnName)
                         throws java.sql.SQLException

Specified by:

getBigDecimal in interface ResultSet

Throws:

java.sql.SQLException

isBeforeFirst

public boolean isBeforeFirst()
                      throws java.sql.SQLException

Specified by:

isBeforeFirst in interface ResultSet

Throws:

java.sql.SQLException

isAfterLast

public boolean isAfterLast()
                    throws java.sql.SQLException

Specified by:

isAfterLast in interface ResultSet

Throws:

java.sql.SQLException

isFirst

public boolean isFirst()
                throws java.sql.SQLException

Specified by:

isFirst in interface ResultSet

Throws:

java.sql.SQLException

isLast

public boolean isLast()
               throws java.sql.SQLException

Specified by:

isLast in interface ResultSet

Throws:

java.sql.SQLException

beforeFirst

public void beforeFirst()
                 throws java.sql.SQLException

Specified by:

beforeFirst in interface ResultSet

Throws:

java.sql.SQLException

afterLast

public void afterLast()
               throws java.sql.SQLException

Specified by:

afterLast in interface ResultSet

Throws:

java.sql.SQLException

first

public boolean first()
              throws java.sql.SQLException

Specified by:

first in interface ResultSet

Throws:

java.sql.SQLException

last

public boolean last()
             throws java.sql.SQLException

Specified by:

last in interface ResultSet

Throws:

java.sql.SQLException

getRow

public int getRow()
           throws java.sql.SQLException

Specified by:

getRow in interface ResultSet

Throws:

java.sql.SQLException

absolute

public boolean absolute(int row)
                 throws java.sql.SQLException

Specified by:

absolute in interface ResultSet

Throws:

java.sql.SQLException

relative

public boolean relative(int rows)
                 throws java.sql.SQLException

Specified by:

relative in interface ResultSet

Throws:

java.sql.SQLException

previous

public boolean previous()
                 throws java.sql.SQLException

Specified by:

previous in interface ResultSet

Throws:

java.sql.SQLException

setFetchDirection

public void setFetchDirection(int direction)
                       throws java.sql.SQLException

Specified by:

setFetchDirection in interface ResultSet

Throws:

java.sql.SQLException

getFetchDirection

public int getFetchDirection()
                      throws java.sql.SQLException

Specified by:

getFetchDirection in interface ResultSet

Throws:

java.sql.SQLException

setFetchSize

public void setFetchSize(int rows)
                  throws java.sql.SQLException

Specified by:

setFetchSize in interface ResultSet

Throws:

java.sql.SQLException

getFetchSize

public int getFetchSize()
                 throws java.sql.SQLException

Specified by:

getFetchSize in interface ResultSet

Throws:

java.sql.SQLException

getType

public int getType()
            throws java.sql.SQLException

Specified by:

getType in interface ResultSet

Throws:

java.sql.SQLException

getConcurrency

public int getConcurrency()
                   throws java.sql.SQLException

Specified by:

getConcurrency in interface ResultSet

Throws:

java.sql.SQLException

getStatement

public Statement getStatement()
                       throws java.sql.SQLException

Specified by:

getStatement in interface ResultSet

Throws:

java.sql.SQLException