SQLite
Class TableResult

java.lang.Object
  SQLite.TableResult

All Implemented Interfaces:

Callback

public class TableResult

extends Object

implements Callback

Class representing an SQLite result set as returned by the Database.get_table convenience method.

Example:

   ...
   SQLite.Database db = new SQLite.Database();
   db.open("db", 0);
   System.out.print(db.get_table("select * from TEST"));
   ...
 

Example output:

   id|firstname|lastname|
   0|John|Doe|
   1|Speedy|Gonzales|
   ...
 

Field Summary

boolean	atmaxrows Flag to indicate Maximum number of rows condition.
String[]	column Column names of the result set.
int	maxrows Maximum number of rows to hold in the table.
int	ncolumns Number of columns in the result set.
int	nrows Number of rows in the result set.
Vector	rows Rows of the result set.
String[]	types Types of columns of the result set or null.

Constructor Summary

TableResult()
Create an empty result set.

TableResult(int maxrows)
Create an empty result set with maximum number of rows.

Method Summary

void	clear() Clear result set.
void	columns(String[] coldata) Callback method used while the query is executed.
boolean	newrow(String[] rowdata) Callback method used while the query is executed.
String	toString() Make String representation of result set.
void	types(String[] types) Callback method used while the query is executed.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

atmaxrows

public boolean atmaxrows

Flag to indicate Maximum number of rows condition.

column

public String[] column

Column names of the result set.

maxrows

public int maxrows

Maximum number of rows to hold in the table.

ncolumns

public int ncolumns

Number of columns in the result set.

nrows

public int nrows

Number of rows in the result set.

rows

public Vector rows

Rows of the result set. Each row is stored as a String array.

types

public String[] types

Types of columns of the result set or null.

Constructor Detail

TableResult

public TableResult()

Create an empty result set.

TableResult

public TableResult(int maxrows)

Create an empty result set with maximum number of rows.

Parameters:

maxrows - number of rows

Method Detail

clear

public void clear()

Clear result set.

columns

public void columns(String[] coldata)

Callback method used while the query is executed.

Specified by:

columns in interface Callback

Parameters:

coldata - string array holding the column names

newrow

public boolean newrow(String[] rowdata)

Callback method used while the query is executed.

Specified by:

newrow in interface Callback

Parameters:

rowdata - string array holding the column values of the row

Returns:

true to abort

toString

public String toString()

Make String representation of result set.

types

public void types(String[] types)

Callback method used while the query is executed.

Specified by:

types in interface Callback

Parameters:

types - string array holding column types