APIdia Launch Partner
Top Description Methods
io.github.spannm.jackcess

public Interface Row

extends Map<String, Object>
Known Direct Implementers
io.github.spannm.jackcess.impl.RowImpl
Imports
io.github.spannm.jackcess.complex.ComplexValueForeignKey, io.github.spannm.jackcess.util.OleBlob, java.math.BigDecimal, java.time.LocalDateTime, java.util.Date, .Map

A row of data as column name->value pairs. Values are strongly typed, and column names are case sensitive.

Method Summary

Modifier and TypeMethod and Description
public BigDecimal
getBigDecimal(String name)

Convenience method which gets the value for the row with the given name, casting it to a BigDecimal (DataTypes MONEY, NUMERIC).

public OleBlob
getBlob(String name)

Convenience method which gets the value for the row with the given name, converting it to an OleBlob (DataTypes OLE).

public Boolean
getBoolean(String name)

Convenience method which gets the value for the row with the given name, casting it to a Boolean (DataType BOOLEAN).

public Byte
getByte(String name)

Convenience method which gets the value for the row with the given name, casting it to a Byte (DataType BYTE).

public byte[]
getBytes(String name)

Convenience method which gets the value for the row with the given name, casting it to a byte[] (DataTypes BINARY, OLE).

public Date
getDate(String name)
Deprecated this is only valid for Database instances configured for the legacy DateTimeType#DATE.

Convenience method which gets the value for the row with the given name, casting it to a Date (DataType SHORT_DATE_TIME).

public Double
getDouble(String name)

Convenience method which gets the value for the row with the given name, casting it to a Double (DataType DOUBLE).

public Float
getFloat(String name)

Convenience method which gets the value for the row with the given name, casting it to a Float (DataType FLOAT).

public ComplexValueForeignKey
getForeignKey(String name)

Convenience method which gets the value for the row with the given name, casting it to a ComplexValueForeignKey (DataType COMPLEX_TYPE).

public RowId

Returns:

the id of this row
getId
()

Returns the id of this row.

public Integer
getInt(String name)

Convenience method which gets the value for the row with the given name, casting it to a Integer (DataType LONG).

public LocalDateTime
getLocalDateTime(String name)

Convenience method which gets the value for the row with the given name, casting it to a LocalDateTime (DataType SHORT_DATE_TIME or EXT_DATE_TIME).

public Short
getShort(String name)

Convenience method which gets the value for the row with the given name, casting it to a Short (DataType INT).

public String
getString(String name)

Convenience method which gets the value for the row with the given name, casting it to a String (DataTypes TEXT, MEMO, GUID).

Inherited from java.util.Map:
clearcomputecomputeIfAbsentcomputeIfPresentcontainsKeycontainsValuecopyOfentryentrySetequalsforEachgetgetOrDefaulthashCodeisEmptykeySetmergeofofofofofofofofofofofofEntriesofLazyputputAllputIfAbsentremoveremovereplacereplacereplaceAllsizevalues

Method Detail

getBigDecimalback to summary
public BigDecimal getBigDecimal(String name)

Convenience method which gets the value for the row with the given name, casting it to a BigDecimal (DataTypes MONEY, NUMERIC).

getBlobback to summary
public OleBlob getBlob(String name)

Convenience method which gets the value for the row with the given name, converting it to an OleBlob (DataTypes OLE).

Note, the OleBlob should be closed after use.

getBooleanback to summary
public Boolean getBoolean(String name)

Convenience method which gets the value for the row with the given name, casting it to a Boolean (DataType BOOLEAN).

getByteback to summary
public Byte getByte(String name)

Convenience method which gets the value for the row with the given name, casting it to a Byte (DataType BYTE).

getBytesback to summary
public byte[] getBytes(String name)

Convenience method which gets the value for the row with the given name, casting it to a byte[] (DataTypes BINARY, OLE).

getDateback to summary
public Date getDate(String name)

Deprecated

this is only valid for Database instances configured for the legacy DateTimeType#DATE. Prefer using DateTimeType#LOCAL_DATE_TIME and the corresponding getLocalDateTime method. Using Date is being phased out and will eventually be removed.

Convenience method which gets the value for the row with the given name, casting it to a Date (DataType SHORT_DATE_TIME).

Annotations
@Deprecated
getDoubleback to summary
public Double getDouble(String name)

Convenience method which gets the value for the row with the given name, casting it to a Double (DataType DOUBLE).

getFloatback to summary
public Float getFloat(String name)

Convenience method which gets the value for the row with the given name, casting it to a Float (DataType FLOAT).

getForeignKeyback to summary
public ComplexValueForeignKey getForeignKey(String name)

Convenience method which gets the value for the row with the given name, casting it to a ComplexValueForeignKey (DataType COMPLEX_TYPE).

getIdback to summary
public RowId getId()

Returns the id of this row.

Returns:RowId

the id of this row

getIntback to summary
public Integer getInt(String name)

Convenience method which gets the value for the row with the given name, casting it to a Integer (DataType LONG).

getLocalDateTimeback to summary
public LocalDateTime getLocalDateTime(String name)

Convenience method which gets the value for the row with the given name, casting it to a LocalDateTime (DataType SHORT_DATE_TIME or EXT_DATE_TIME). This method will only work for Database instances configured for DateTimeType#LOCAL_DATE_TIME.

getShortback to summary
public Short getShort(String name)

Convenience method which gets the value for the row with the given name, casting it to a Short (DataType INT).

getStringback to summary
public String getString(String name)

Convenience method which gets the value for the row with the given name, casting it to a String (DataTypes TEXT, MEMO, GUID).