com.scalar.db.sql

Interface Record

All Known Implementing Classes:

ColumnsRecord, SingleColumnRecord

public interface Record

A record of a database.

Method Summary

Modifier and Type	Method and Description
java.lang.Object	getAsObject(int i) Returns the value of the i-th column as a Java Object type.
java.lang.Object	getAsObject(java.lang.String columnName) Returns the value of the specified column as a Java Object type.
long	getBigInt(int i) Returns the BIGINT value of the i-th column as a Java long type.
long	getBigInt(java.lang.String columnName) Returns the BIGINT value of the specified column as a Java long type.
default java.nio.ByteBuffer	getBlob(int i) Returns the BLOB value of the i-th column as a Java ByteBuffer type.
default java.nio.ByteBuffer	getBlob(java.lang.String columnName) Returns the BLOB value of the specified column as a Java ByteBuffer type.
java.nio.ByteBuffer	getBlobAsByteBuffer(int i) Returns the BLOB value of the i-th column as a Java ByteBuffer type.
java.nio.ByteBuffer	getBlobAsByteBuffer(java.lang.String columnName) Returns the BLOB value of the specified column as a Java ByteBuffer type.
byte[]	getBlobAsBytes(int i) Returns the BLOB value of the i-th column as a Java byte array type.
byte[]	getBlobAsBytes(java.lang.String columnName) Returns the BLOB value of the specified column as a Java byte array type.
boolean	getBoolean(int i) Returns the BOOLEAN value of the i-th column as a Java boolean type.
boolean	getBoolean(java.lang.String columnName) Returns the BOOLEAN value of the specified column as a Java boolean type.
double	getDouble(int i) Returns the DOUBLE value of the i-th column as a Java double type.
double	getDouble(java.lang.String columnName) Returns the DOUBLE value of the specified column as a Java double type.
float	getFloat(int i) Returns the FLOAT value of the i-th column as a Java float type.
float	getFloat(java.lang.String columnName) Returns the FLOAT value of the specified column as a Java float type.
int	getInt(int i) Returns the INT value of the i-th column as a Java int type.
int	getInt(java.lang.String columnName) Returns the INT value of the specified column as a Java int type.
java.lang.String	getText(int i) Returns the TEXT value of the i-th column as a Java String type.
java.lang.String	getText(java.lang.String columnName) Returns the TEXT value of the specified column as a Java String type.
boolean	isNull(int i) Indicates whether the value of the i-th column is NULL.
boolean	isNull(java.lang.String columnName) Indicates whether the value of the specified column is NULL.

Method Detail

isNull

boolean isNull(java.lang.String columnName)

Indicates whether the value of the specified column is NULL.

Parameters:

columnName - a column name of the value

Returns:

whether the value of the specified column is NULL

isNull

boolean isNull(int i)

Indicates whether the value of the i-th column is NULL.

Parameters:

i - the position of the column

Returns:

whether the value of the specified column is NULL

getBoolean

boolean getBoolean(java.lang.String columnName)

Returns the BOOLEAN value of the specified column as a Java boolean type.

Note that, due to its signature, this method cannot return null. If the value is NULL, it will return 0. If this doesn't work for you, either call isNull(String) before calling this method, or use getAsObject(String) instead.

Parameters:

columnName - a column name of the value

Returns:

the BOOLEAN value of the specified column as a Java boolean type

getBoolean

boolean getBoolean(int i)

Returns the BOOLEAN value of the i-th column as a Java boolean type.

Note that, due to its signature, this method cannot return null. If the value is NULL, it will return 0. If this doesn't work for you, either call isNull(String) before calling this method, or use getAsObject(String) instead.

Parameters:

i - the position of the column

Returns:

the BOOLEAN value of the specified column as a Java boolean type

getInt

int getInt(java.lang.String columnName)

Returns the INT value of the specified column as a Java int type.

Note that, due to its signature, this method cannot return null. If the value is NULL, it will return 0. If this doesn't work for you, either call isNull(String) before calling this method, or use getAsObject(String) instead.

Parameters:

columnName - a column name of the value

Returns:

the INT value of the specified column as a Java int type

getInt

int getInt(int i)

Returns the INT value of the i-th column as a Java int type.

Note that, due to its signature, this method cannot return null. If the value is NULL, it will return 0. If this doesn't work for you, either call isNull(String) before calling this method, or use getAsObject(String) instead.

Parameters:

i - the position of the column

Returns:

the INT value of the specified column as a Java int type

getBigInt

long getBigInt(java.lang.String columnName)

Returns the BIGINT value of the specified column as a Java long type.

Note that, due to its signature, this method cannot return null. If the value is NULL, it will return 0. If this doesn't work for you, either call isNull(String) before calling this method, or use getAsObject(String) instead.

Parameters:

columnName - a column name of the value

Returns:

the BIGINT value of the specified column as a Java long type

getBigInt

long getBigInt(int i)

Returns the BIGINT value of the i-th column as a Java long type.

Note that, due to its signature, this method cannot return null. If the value is NULL, it will return 0. If this doesn't work for you, either call isNull(String) before calling this method, or use getAsObject(String) instead.

Parameters:

i - the position of the column

Returns:

the BIGINT value of the specified column as a Java long type

getFloat

float getFloat(java.lang.String columnName)

Returns the FLOAT value of the specified column as a Java float type.

Note that, due to its signature, this method cannot return null. If the value is NULL, it will return 0.0. If this doesn't work for you, either call isNull(String) before calling this method, or use getAsObject(String) instead.

Parameters:

columnName - a column name of the value

Returns:

the FLOAT value of the specified column as a Java float type

getFloat

float getFloat(int i)

Returns the FLOAT value of the i-th column as a Java float type.

Note that, due to its signature, this method cannot return null. If the value is NULL, it will return 0.0. If this doesn't work for you, either call isNull(String) before calling this method, or use getAsObject(String) instead.

Parameters:

i - the position of the column

Returns:

the FLOAT value of the specified column as a Java float type

getDouble

double getDouble(java.lang.String columnName)

Returns the DOUBLE value of the specified column as a Java double type.

Note that, due to its signature, this method cannot return null. If the value is NULL, it will return 0.0. If this doesn't work for you, either call isNull(String) before calling this method, or use getAsObject(String) instead.

Parameters:

columnName - a column name of the value

Returns:

the DOUBLE value of the specified column as a Java double type

getDouble

double getDouble(int i)

Returns the DOUBLE value of the i-th column as a Java double type.

Note that, due to its signature, this method cannot return null. If the value is NULL, it will return 0.0. If this doesn't work for you, either call isNull(String) before calling this method, or use getAsObject(String) instead.

Parameters:

i - the position of the column

Returns:

the DOUBLE value of the specified column as a Java double type

getText

@Nullable
java.lang.String getText(java.lang.String columnName)

Returns the TEXT value of the specified column as a Java String type.

Parameters:

columnName - a column name of the value

Returns:

the TEXT value of the specified column as a Java String type. If the value is NULL, null

getText

@Nullable
java.lang.String getText(int i)

Returns the TEXT value of the i-th column as a Java String type.

Parameters:

i - the position of the column

Returns:

the TEXT value of the specified column as a Java String type. If the value is NULL, null

getBlob

@Nullable
default java.nio.ByteBuffer getBlob(java.lang.String columnName)

Returns the BLOB value of the specified column as a Java ByteBuffer type.

Parameters:

columnName - a column name of the value

Returns:

the BLOB value of the specified column as a Java ByteBuffer type. If the value is NULL, null

getBlob

@Nullable
default java.nio.ByteBuffer getBlob(int i)

Returns the BLOB value of the i-th column as a Java ByteBuffer type.

Parameters:

i - the position of the column

Returns:

the BLOB value of the specified column as a Java ByteBuffer type. If the value is NULL, null

getBlobAsByteBuffer

@Nullable
java.nio.ByteBuffer getBlobAsByteBuffer(java.lang.String columnName)

Returns the BLOB value of the specified column as a Java ByteBuffer type.

Parameters:

columnName - a column name of the value

Returns:

the BLOB value of the specified column as a Java ByteBuffer type. If the value is NULL, null

getBlobAsByteBuffer

@Nullable
java.nio.ByteBuffer getBlobAsByteBuffer(int i)

Returns the BLOB value of the i-th column as a Java ByteBuffer type.

Parameters:

i - the position of the column

Returns:

the BLOB value of the specified column as a Java ByteBuffer type. If the value is NULL, null

getBlobAsBytes

@Nullable
byte[] getBlobAsBytes(java.lang.String columnName)

Returns the BLOB value of the specified column as a Java byte array type.

Parameters:

columnName - a column name of the value

Returns:

the BLOB value of the specified column as a Java byte array type. If the value is NULL, null

getBlobAsBytes

@Nullable
byte[] getBlobAsBytes(int i)

Returns the BLOB value of the i-th column as a Java byte array type.

Parameters:

i - the position of the column

Returns:

the BLOB value of the specified column as a Java byte array type. If the value is NULL, null

getAsObject

@Nullable
java.lang.Object getAsObject(java.lang.String columnName)

Returns the value of the specified column as a Java Object type.

If the columns is a BOOLEAN type, it returns a Boolean object. If the columns is an INT type, it returns an Integer object. If the columns is a BIGINT type, it returns a LONG object. If the columns is a FLOAT type, it returns a FLOAT object. If the columns is a DOUBLE type, it returns a DOUBLE object. If the columns is a TEXT type, it returns a String object. If the columns is a BLOB type, it returns a ByteBuffer object.

Parameters:

columnName - a column name of the value

Returns:

the value of the specified column as a Java Object type. If the value is NULL, null

getAsObject

@Nullable
java.lang.Object getAsObject(int i)

Returns the value of the i-th column as a Java Object type.

If the columns is a BOOLEAN type, it returns a Boolean object. If the columns is an INT type, it returns an Integer object. If the columns is a BIGINT type, it returns a LONG object. If the columns is a FLOAT type, it returns a FLOAT object. If the columns is a DOUBLE type, it returns a DOUBLE object. If the columns is a TEXT type, it returns a String object. If the columns is a BLOB type, it returns a ByteBuffer object.

Parameters:

i - the position of the column

Returns:

the value of the specified column as a Java Object type. If the value is NULL, null