# 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.

There is more thorough coverage of the `Database API here`.

The sample code below presents a Database Explorer tool that allows executing arbitrary SQL and viewing the tabular results:

    Toolbar.setGlobalToolbar(true);
    Style s = UIManager.getInstance().getComponentStyle("TitleCommand");
    FontImage icon = FontImage.createMaterial(FontImage.MATERIAL_QUERY_BUILDER, s);
    Form hi = new Form("SQL Explorer", new BorderLayout());
    hi.getToolbar().addCommandToRightBar("", icon, (e) -> {
        TextArea query = new TextArea(3, 80);
        Command ok = new Command("Execute");
        Command cancel = new Command("Cancel");
        if(Dialog.show("Query", query, ok, cancel) == ok) {
            Database db = null;
            Cursor cur = null;
            try {
                db = Display.getInstance().openOrCreate("MyDB.db");
                if(query.getText().startsWith("select")) {
                    cur = db.executeQuery(query.getText());
                    int columns = cur.getColumnCount();
                    hi.removeAll();
                    if(columns > 0) {
                        boolean next = cur.next();
                        if(next) {
                            ArrayList data = new ArrayList<>();
                            String[] columnNames = new String[columns];
                            for(int iter = 0 ; iter

    @author Chen

- ## Method Summary

  Modifier and Type
  Method
  Description
  `byte[]`
  `getBlob(int index)`
  Gets column value by index.
  `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 java.io.IOException

    Gets column value by index.

    ###### Parameters

    - `index`: starts with zero

    ###### Returns

    byte [] data

    ###### Throws

    - `IOException`
    Throws:
      `java.io.IOException`

  - ### getDouble

    double getDouble(int index) throws java.io.IOException

    Gets column value by index.

    ###### Parameters

    - `index`: starts with zero

    ###### Returns

    a double data from the database

    ###### Throws

    - `IOException`
    Throws:
      `java.io.IOException`

  - ### getFloat

    float getFloat(int index) throws java.io.IOException

    Gets column value by index.

    ###### Parameters

    - `index`: starts with zero

    ###### Returns

    a float data from the database

    ###### Throws

    - `IOException`
    Throws:
      `java.io.IOException`

  - ### getInteger

    int getInteger(int index) throws java.io.IOException

    Gets column value by index.

    ###### Parameters

    - `index`: starts with zero

    ###### Returns

    a int data from the database

    ###### Throws

    - `IOException`
    Throws:
      `java.io.IOException`

  - ### getLong

    long getLong(int index) throws java.io.IOException

    Gets column value by index.

    ###### Parameters

    - `index`: starts with zero

    ###### Returns

    a long data from the database

    ###### Throws

    - `IOException`
    Throws:
      `java.io.IOException`

  - ### getShort

    short getShort(int index) throws java.io.IOException

    Gets column value by index.

    ###### Parameters

    - `index`: starts with zero

    ###### Returns

    a short data from the database

    ###### Throws

    - `IOException`
    Throws:
      `java.io.IOException`

  - ### getString

    String getString(int index) throws java.io.IOException

    Gets column value by index.

    ###### Parameters

    - `index`: starts with zero

    ###### Returns

    a String data from the database

    ###### Throws

    - `IOException`
    Throws:
      `java.io.IOException`