Package totalcross.sql

Interface ResultSet

All Superinterfaces:

java.lang.AutoCloseable

All Known Implementing Classes:

SQLite4JResultSet

public interface ResultSet
extends java.lang.AutoCloseable

Field Summary

Fields

Modifier and Type	Field	Description
static int	CLOSE_CURSORS_AT_COMMIT
static int	CONCUR_READ_ONLY
static int	CONCUR_UPDATABLE
static int	FETCH_FORWARD
static int	FETCH_REVERSE
static int	FETCH_UNKNOWN
static int	HOLD_CURSORS_OVER_COMMIT
static int	TYPE_FORWARD_ONLY
static int	TYPE_SCROLL_INSENSITIVE
static int	TYPE_SCROLL_SENSITIVE

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()
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()

Field Detail

FETCH_FORWARD

static final int FETCH_FORWARD

See Also:

Constant Field Values

FETCH_REVERSE

static final int FETCH_REVERSE

See Also:

Constant Field Values

FETCH_UNKNOWN

static final int FETCH_UNKNOWN

See Also:

Constant Field Values

TYPE_FORWARD_ONLY

static final int TYPE_FORWARD_ONLY

See Also:

Constant Field Values

TYPE_SCROLL_INSENSITIVE

static final int TYPE_SCROLL_INSENSITIVE

See Also:

Constant Field Values

TYPE_SCROLL_SENSITIVE

static final int TYPE_SCROLL_SENSITIVE

See Also:

Constant Field Values

CONCUR_READ_ONLY

static final int CONCUR_READ_ONLY

See Also:

Constant Field Values

CONCUR_UPDATABLE

static final int CONCUR_UPDATABLE

See Also:

Constant Field Values

HOLD_CURSORS_OVER_COMMIT

static final int HOLD_CURSORS_OVER_COMMIT

See Also:

Constant Field Values

CLOSE_CURSORS_AT_COMMIT

static final int CLOSE_CURSORS_AT_COMMIT

See Also:

Constant Field Values

Method Detail

next

boolean next()
      throws java.sql.SQLException

Throws:

java.sql.SQLException

close

void close()
    throws java.sql.SQLException

Specified by:

close in interface java.lang.AutoCloseable

Throws:

java.sql.SQLException

wasNull

boolean wasNull()
         throws java.sql.SQLException

Throws:

java.sql.SQLException

getString

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

Throws:

java.sql.SQLException

getBoolean

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

Throws:

java.sql.SQLException

getByte

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

Throws:

java.sql.SQLException

getShort

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

Throws:

java.sql.SQLException

getInt

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

Throws:

java.sql.SQLException

getLong

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

Throws:

java.sql.SQLException

getDouble

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

Throws:

java.sql.SQLException

getBigDecimal

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

Throws:

java.sql.SQLException

getBytes

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

Throws:

java.sql.SQLException

getDate

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

Throws:

java.sql.SQLException

getTime

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

Throws:

java.sql.SQLException

getTimestamp

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

Throws:

java.sql.SQLException

getString

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

Throws:

java.sql.SQLException

getBoolean

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

Throws:

java.sql.SQLException

getByte

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

Throws:

java.sql.SQLException

getShort

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

Throws:

java.sql.SQLException

getInt

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

Throws:

java.sql.SQLException

getLong

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

Throws:

java.sql.SQLException

getDouble

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

Throws:

java.sql.SQLException

getBigDecimal

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

Throws:

java.sql.SQLException

getBytes

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

Throws:

java.sql.SQLException

getDate

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

Throws:

java.sql.SQLException

getTime

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

Throws:

java.sql.SQLException

getTimestamp

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

Throws:

java.sql.SQLException

getWarnings

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

Throws:

java.sql.SQLException

clearWarnings

void clearWarnings()
            throws java.sql.SQLException

Throws:

java.sql.SQLException

getCursorName

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

Throws:

java.sql.SQLException

getMetaData

ResultSetMetaData getMetaData()
                       throws java.sql.SQLException

Throws:

java.sql.SQLException

getObject

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

Throws:

java.sql.SQLException

getObject

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

Throws:

java.sql.SQLException

findColumn

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

Throws:

java.sql.SQLException

getBigDecimal

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

Throws:

java.sql.SQLException

getBigDecimal

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

Throws:

java.sql.SQLException

isBeforeFirst

boolean isBeforeFirst()
               throws java.sql.SQLException

Throws:

java.sql.SQLException

isAfterLast

boolean isAfterLast()
             throws java.sql.SQLException

Throws:

java.sql.SQLException

isFirst

boolean isFirst()
         throws java.sql.SQLException

Throws:

java.sql.SQLException

isLast

boolean isLast()
        throws java.sql.SQLException

Throws:

java.sql.SQLException

beforeFirst

void beforeFirst()
          throws java.sql.SQLException

Throws:

java.sql.SQLException

afterLast

void afterLast()
        throws java.sql.SQLException

Throws:

java.sql.SQLException

first

boolean first()
       throws java.sql.SQLException

Throws:

java.sql.SQLException

last

boolean last()
      throws java.sql.SQLException

Throws:

java.sql.SQLException

getRow

int getRow()
    throws java.sql.SQLException

Throws:

java.sql.SQLException

absolute

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

Throws:

java.sql.SQLException

relative

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

Throws:

java.sql.SQLException

previous

boolean previous()
          throws java.sql.SQLException

Throws:

java.sql.SQLException

setFetchDirection

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

Throws:

java.sql.SQLException

getFetchDirection

int getFetchDirection()
               throws java.sql.SQLException

Throws:

java.sql.SQLException

setFetchSize

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

Throws:

java.sql.SQLException

getFetchSize

int getFetchSize()
          throws java.sql.SQLException

Throws:

java.sql.SQLException

getType

int getType()
     throws java.sql.SQLException

Throws:

java.sql.SQLException

getConcurrency

int getConcurrency()
            throws java.sql.SQLException

Throws:

java.sql.SQLException

getStatement

Statement getStatement()
                throws java.sql.SQLException

Throws:

java.sql.SQLException