Record (ScalarDB SQL)

All Known Implementing Classes:

ColumnsRecord, SingleColumnRecord
```
public interface Record
```
A record of a database.

Method Summary

All Methods Instance Methods Abstract Methods Default Methods
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.
`java.time.LocalDate`	`getDate(int i)` Returns the DATE value of the i-th column as a Java LocalDate type.
`java.time.LocalDate`	`getDate(java.lang.String columnName)` Returns the DATE value of the specified column as a Java LocalDate 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.
`java.time.LocalTime`	`getTime(int i)` Returns the TIME value of the i-th column as a Java LocalTime type.
`java.time.LocalTime`	`getTime(java.lang.String columnName)` Returns the TIME value of the specified column as a Java LocalTime type.
`java.time.LocalDateTime`	`getTimestamp(int i)` Returns the TIMESTAMP value of the i-th column as a Java LocalDateTime type.
`java.time.LocalDateTime`	`getTimestamp(java.lang.String columnName)` Returns the TIMESTAMP value of the specified column as a Java LocalDateTime type.
`java.time.Instant`	`getTimestampTZ(int i)` Returns the TIMESTAMPTZ value of the i-th column as a Java Instant type.
`java.time.Instant`	`getTimestampTZ(java.lang.String columnName)` Returns the TIMESTAMPTZ value of the specified column as a Java Instant 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
  - getDate
```
@Nullable
java.time.LocalDate getDate(java.lang.String columnName)
```
    Returns the DATE value of the specified column as a Java LocalDate type.
    
    Parameters:
    
    columnName - a column name of the value
    
    Returns:
    
    the DATE value of the specified column as a Java LocalDate type. If the value is NULL, null
  - getDate
```
@Nullable
java.time.LocalDate getDate(int i)
```
    Returns the DATE value of the i-th column as a Java LocalDate type.
    
    Parameters:
    
    i - the position of the column
    
    Returns:
    
    the DATE value of the specified column as a Java LocalDate type. If the value is NULL, null
  - getTime
```
@Nullable
java.time.LocalTime getTime(java.lang.String columnName)
```
    Returns the TIME value of the specified column as a Java LocalTime type.
    
    Parameters:
    
    columnName - a column name of the value
    
    Returns:
    
    the TIME value of the specified column as a Java LocalTime type. If the value is NULL, null
  - getTime
```
@Nullable
java.time.LocalTime getTime(int i)
```
    Returns the TIME value of the i-th column as a Java LocalTime type.
    
    Parameters:
    
    i - the position of the column
    
    Returns:
    
    the TIME value of the specified column as a Java LocalTime type. If the value is NULL, null
  - getTimestamp
```
@Nullable
java.time.LocalDateTime getTimestamp(java.lang.String columnName)
```
    Returns the TIMESTAMP value of the specified column as a Java LocalDateTime type.
    
    Parameters:
    
    columnName - a column name of the value
    
    Returns:
    
    the TIMESTAMP value of the specified column as a Java LocalDateTime type. If the value is NULL, null
  - getTimestamp
```
@Nullable
java.time.LocalDateTime getTimestamp(int i)
```
    Returns the TIMESTAMP value of the i-th column as a Java LocalDateTime type.
    
    Parameters:
    
    i - the position of the column
    
    Returns:
    
    the TIMESTAMP value of the specified column as a Java LocalDateTime type. If the value is NULL, null
  - getTimestampTZ
```
@Nullable
java.time.Instant getTimestampTZ(java.lang.String columnName)
```
    Returns the TIMESTAMPTZ value of the specified column as a Java Instant type.
    
    Parameters:
    
    columnName - a column name of the value
    
    Returns:
    
    the TIMESTAMPTZ value of the specified column as a Java Instant type. If the value is NULL, null
  - getTimestampTZ
```
@Nullable
java.time.Instant getTimestampTZ(int i)
```
    Returns the TIMESTAMPTZ value of the i-th column as a Java Instant type.
    
    Parameters:
    
    i - the position of the column
    
    Returns:
    
    the TIMESTAMPTZ value of the specified column as a Java Instant 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

Interface Record

Method Summary

Method Detail

isNull

isNull

getBoolean

getBoolean

getInt

getInt

getBigInt

getBigInt

getFloat

getFloat

getDouble

getDouble

getText

getText

getBlob

getBlob

getBlobAsByteBuffer

getBlobAsByteBuffer

getBlobAsBytes

getBlobAsBytes

getDate

getDate

getTime

getTime

getTimestamp

getTimestamp

getTimestampTZ

getTimestampTZ

getAsObject

getAsObject