Skip navigation links

com.sigmadynamics.server.DataServices.DatabaseProvider
Interface SDResultSet

public interface SDResultSet

ResultSet

Since:

1.0

Field Summary

static SDResultSet

EMPTY_RESULT_SET

Method Summary

boolean	absolute(int row)
void	afterLast()
void	beforeFirst()
void	close()
int	findColumn(java.lang.String columnName)
boolean	first()
java.sql.Array	getArray(int i)
java.sql.Array	getArray(java.lang.String colName)
java.io.InputStream	getAsciiStream(int columnIndex)
java.io.InputStream	getAsciiStream(java.lang.String columnName)
java.math.BigDecimal	getBigDecimal(int columnIndex)
java.math.BigDecimal	getBigDecimal(java.lang.String columnName)
java.io.InputStream	getBinaryStream(int columnIndex)
java.io.InputStream	getBinaryStream(java.lang.String columnName)
java.sql.Blob	getBlob(int i)
java.sql.Blob	getBlob(java.lang.String colName)
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)
java.io.Reader	getCharacterStream(int columnIndex)
java.io.Reader	getCharacterStream(java.lang.String columnName)
java.sql.Clob	getClob(int i)
java.sql.Clob	getClob(java.lang.String colName)
java.sql.Date	getDate(int columnIndex)
java.sql.Date	getDate(int columnIndex, java.util.Calendar cal)
java.sql.Date	getDate(java.lang.String columnName)
java.sql.Date	getDate(java.lang.String columnName, java.util.Calendar cal)
long	getDateAsMillis(int columnIndex) Returns date/time in milliseconds UTC.
long	getDateAsMillis(int columnIndex, java.util.Calendar cal) Returns date/time in milliseconds UTC.
long	getDateAsMillis(java.lang.String columnName) Returns date/time in milliseconds UTC.
double	getDouble(int columnIndex)
double	getDouble(java.lang.String columnName)
float	getFloat(int columnIndex)
float	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)
java.lang.Object	getObject(int columnIndex)
java.lang.Object	getObject(int i, java.util.Map<java.lang.Class<?>> map)
java.lang.Object	getObject(java.lang.String columnName)
int	getRow()
short	getShort(int columnIndex)
short	getShort(java.lang.String columnName)
java.lang.String	getString(int columnIndex)
java.lang.String	getString(java.lang.String columnName)
java.sql.Time	getTime(int columnIndex)
java.sql.Time	getTime(int columnIndex, java.util.Calendar cal)
java.sql.Time	getTime(java.lang.String columnName)
java.sql.Time	getTime(java.lang.String columnName, java.util.Calendar cal)
java.sql.Timestamp	getTimestamp(int columnIndex)
java.sql.Timestamp	getTimestamp(int columnIndex, java.util.Calendar cal)
java.sql.Timestamp	getTimestamp(java.lang.String columnName)
java.sql.Timestamp	getTimestamp(java.lang.String columnName, java.util.Calendar cal)
int	getType()
boolean	isAfterLast()
boolean	isBeforeFirst()
boolean	isFirst()
boolean	isLast()
boolean	last()
boolean	next()
boolean	relative(int rows)
boolean	wasNull()

Field Detail

EMPTY_RESULT_SET

static final SDResultSet EMPTY_RESULT_SET

Method Detail

next

boolean next()

See Also:

ResultSet.next()

close

void close()

See Also:

ResultSet.close()

wasNull

boolean wasNull()

See Also:

ResultSet.wasNull()

getString

java.lang.String getString(int columnIndex)

See Also:

ResultSet.getString(int)

getBoolean

boolean getBoolean(int columnIndex)

See Also:

ResultSet.getBoolean(int)

getByte

byte getByte(int columnIndex)

See Also:

ResultSet.getByte(int)

getShort

short getShort(int columnIndex)

See Also:

ResultSet.getShort(int)

getInt

int getInt(int columnIndex)

See Also:

ResultSet.getInt(int)

getLong

long getLong(int columnIndex)

See Also:

ResultSet.getLong(int)

getFloat

float getFloat(int columnIndex)

See Also:

ResultSet.getFloat(int)

getDouble

double getDouble(int columnIndex)

See Also:

ResultSet.getDouble(int)

getBytes

byte[] getBytes(int columnIndex)

See Also:

ResultSet.getBytes(int)

getDate

java.sql.Date getDate(int columnIndex)

See Also:

ResultSet.getDate(int)

getTime

java.sql.Time getTime(int columnIndex)

See Also:

ResultSet.getTime(int)

getTimestamp

java.sql.Timestamp getTimestamp(int columnIndex)

See Also:

ResultSet.getTimestamp(int)

getAsciiStream

java.io.InputStream getAsciiStream(int columnIndex)

See Also:

ResultSet.getAsciiStream(int)

getBinaryStream

java.io.InputStream getBinaryStream(int columnIndex)

See Also:

ResultSet.getBinaryStream(int)

getString

java.lang.String getString(java.lang.String columnName)

See Also:

ResultSet.getString(String)

getBoolean

boolean getBoolean(java.lang.String columnName)

See Also:

ResultSet.getBoolean(String)

getByte

byte getByte(java.lang.String columnName)

See Also:

ResultSet.getByte(String)

getShort

short getShort(java.lang.String columnName)

See Also:

ResultSet.getShort(String)

getInt

int getInt(java.lang.String columnName)

See Also:

ResultSet.getInt(String)

getLong

long getLong(java.lang.String columnName)

See Also:

ResultSet.getLong(String)

getFloat

float getFloat(java.lang.String columnName)

See Also:

ResultSet.getFloat(String)

getDouble

double getDouble(java.lang.String columnName)

See Also:

ResultSet.getDouble(String)

getBytes

byte[] getBytes(java.lang.String columnName)

See Also:

ResultSet.getBytes(String)

getDate

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

See Also:

ResultSet.getDate(String)

getTime

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

See Also:

ResultSet.getTime(String)

getTimestamp

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

See Also:

ResultSet.getTimestamp(String)

getAsciiStream

java.io.InputStream getAsciiStream(java.lang.String columnName)

See Also:

ResultSet.getAsciiStream(String)

getBinaryStream

java.io.InputStream getBinaryStream(java.lang.String columnName)

See Also:

ResultSet.getBinaryStream(String)

getObject

java.lang.Object getObject(int columnIndex)

See Also:

ResultSet.getObject(int)

getObject

java.lang.Object getObject(java.lang.String columnName)

See Also:

ResultSet.getObject(String)

findColumn

int findColumn(java.lang.String columnName)

See Also:

ResultSet.findColumn(String)

getCharacterStream

java.io.Reader getCharacterStream(int columnIndex)

See Also:

ResultSet.getCharacterStream(int)

getCharacterStream

java.io.Reader getCharacterStream(java.lang.String columnName)

See Also:

ResultSet.getCharacterStream(String)

getBigDecimal

java.math.BigDecimal getBigDecimal(int columnIndex)

See Also:

ResultSet.getBigDecimal(int)

getBigDecimal

java.math.BigDecimal getBigDecimal(java.lang.String columnName)

See Also:

ResultSet.getBigDecimal(String)

isBeforeFirst

boolean isBeforeFirst()

See Also:

ResultSet.isBeforeFirst()

isAfterLast

boolean isAfterLast()

See Also:

ResultSet.isAfterLast()

isFirst

boolean isFirst()

See Also:

ResultSet.isFirst()

isLast

boolean isLast()

See Also:

ResultSet.isLast()

beforeFirst

void beforeFirst()

See Also:

ResultSet.beforeFirst()

afterLast

void afterLast()

See Also:

ResultSet.afterLast()

first

boolean first()

See Also:

ResultSet.first()

last

boolean last()

See Also:

ResultSet.last()

getRow

int getRow()

See Also:

ResultSet.getRow()

absolute

boolean absolute(int row)

See Also:

ResultSet.absolute(int)

relative

boolean relative(int rows)

See Also:

ResultSet.relative(int)

getType

int getType()

See Also:

ResultSet.getType()

getBlob

java.sql.Blob getBlob(int i)

See Also:

ResultSet.getBlob(int)

getClob

java.sql.Clob getClob(int i)

See Also:

ResultSet.getClob(int)

getArray

java.sql.Array getArray(int i)

See Also:

ResultSet.getArray(int)

getObject

java.lang.Object getObject(int i,
                           java.util.Map<java.lang.Class<?>> map)

See Also:

ResultSet.getObject(String, java.util.Map)

getBlob

java.sql.Blob getBlob(java.lang.String colName)

See Also:

ResultSet.getBlob(String)

getClob

java.sql.Clob getClob(java.lang.String colName)

See Also:

ResultSet.getClob(String)

getArray

java.sql.Array getArray(java.lang.String colName)

See Also:

ResultSet.getArray(String)

getDate

java.sql.Date getDate(int columnIndex,
                      java.util.Calendar cal)

See Also:

WARNING: There is a bug in the Oracle driver such that this method will not work if the column is any data type other than DATE. For example, a TIMESTAMP column will fail. getDateAsMillis(int, Calendar) should be used instead.

getDate

java.sql.Date getDate(java.lang.String columnName,
                      java.util.Calendar cal)

See Also:

ResultSet.getDate(String, Calendar)

getTime

java.sql.Time getTime(int columnIndex,
                      java.util.Calendar cal)

See Also:

ResultSet.getTime(int, Calendar)

getTime

java.sql.Time getTime(java.lang.String columnName,
                      java.util.Calendar cal)

See Also:

ResultSet.getTime(String, Calendar)

getTimestamp

java.sql.Timestamp getTimestamp(int columnIndex,
                                java.util.Calendar cal)

See Also:

WARNING: There is a bug in the Oracle driver such that this method will not work if the column is any data type other than DATE. For example, a TIMESTAMP column will fail. getDateAsMillis(int, Calendar) should be used instead.

getTimestamp

java.sql.Timestamp getTimestamp(java.lang.String columnName,
                                java.util.Calendar cal)

See Also:

ResultSet.getTimestamp(String, Calendar)

getDateAsMillis

long getDateAsMillis(int columnIndex)

Returns date/time in milliseconds UTC. If the data in database does not contain time zone information, it is assumed to be in UTC.

Parameters:

columnIndex - 1-based column index.

Returns:

date/time in milliseconds UTC.

getDateAsMillis

long getDateAsMillis(int columnIndex,
                     java.util.Calendar cal)

Returns date/time in milliseconds UTC.

Parameters:

columnIndex - 1-based column index.

cal - defines the time zone to be used if the data in database does not contain time zone information.

Returns:

date/time in milliseconds UTC.

getDateAsMillis

long getDateAsMillis(java.lang.String columnName)

Returns date/time in milliseconds UTC. If the data in database does not contain time zone information, it is assumed to be in UTC.

Parameters:

columnName - the name of a column.

Returns:

date/time in milliseconds UTC.

Skip navigation links