Interface Row

All Known Subinterfaces:
RowExt
public interface Row

The Row interface is returned by com.codename1.db.Cursor#getRow() to provide access to the content of an individual row.

Column indexes are zero-based. A SQL NULL reads back as null from #getString(int) and #getBlob(int), and as 0 from the numeric getters; use RowExt#wasNull() to tell a stored zero from a NULL.

while (cur.next()) {
    Row row = cur.getRow();
    int id = row.getInteger(0);
    String body = row.getString(1);
    System.out.println(id + ": " + body);
}

See the com.codename1.db package documentation for the full contract.

  • Method Summary

    Modifier and Type
    Method
    Description
    byte[]
    getBlob(int index)
    Gets column value by index.
    int
    getColumnType(int index)
    Returns how the value in a column of the current row is stored.
    double
    getDouble(int index)
    Gets column value by index.
    float
    getFloat(int index)
    Gets column value by index.
    int
    getInteger(int index)
    Gets column value by index.
    long
    getLong(int index)
    Gets column value by index.
    short
    getShort(int index)
    Gets column value by index.
    String
    getString(int index)
    Gets column value by index.

  • Method Details

    • getBlob

      byte[] getBlob(int index) throws IOException

      Gets column value by index.

      Parameters
      • index: starts with zero
      Returns

      byte [] data

      Throws
      • IOException
      Throws:
      IOException

    • getDouble

      double getDouble(int index) throws IOException

      Gets column value by index.

      Parameters
      • index: starts with zero
      Returns

      a double data from the database

      Throws
      • IOException
      Throws:
      IOException

    • getFloat

      float getFloat(int index) throws IOException

      Gets column value by index.

      Parameters
      • index: starts with zero
      Returns

      a float data from the database

      Throws
      • IOException
      Throws:
      IOException

    • getInteger

      int getInteger(int index) throws IOException

      Gets column value by index.

      Parameters
      • index: starts with zero
      Returns

      a int data from the database

      Throws
      • IOException
      Throws:
      IOException

    • getLong

      long getLong(int index) throws IOException

      Gets column value by index.

      Parameters
      • index: starts with zero
      Returns

      a long data from the database

      Throws
      • IOException
      Throws:
      IOException

    • getShort

      short getShort(int index) throws IOException

      Gets column value by index.

      Parameters
      • index: starts with zero
      Returns

      a short data from the database

      Throws
      • IOException
      Throws:
      IOException

    • getString

      String getString(int index) throws IOException

      Gets column value by index.

      Parameters
      • index: starts with zero
      Returns

      a String data from the database

      Throws
      • IOException
      Throws:
      IOException

    • getColumnType

      int getColumnType(int index) throws IOException

      Returns how the value in a column of the current row is stored.

      SQLite types values rather than columns, so one column can hold an integer in one row and text in the next, and the typed getters convert whatever is stored. A caller that has to hand a value back as it was written -- a scripting layer, a generic exporter -- asks this first.

      Parameters
      • index: the zero-based column index
      Returns

      one of Database#COLUMN_NULL, Database#COLUMN_INTEGER, Database#COLUMN_FLOAT, Database#COLUMN_TEXT, Database#COLUMN_BLOB, or Database#COLUMN_UNKNOWN when the engine cannot tell

      Throws
      • IOException: if the cursor is closed, not on a row, or the index is out of range
      Throws:
      IOException