jsqlite

Class TableResult

java.lang.Object

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

Fields

Modifier and Type	Field and Description
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<String[]>	rows Rows of the result set.
String[]	types Types of columns of the result set or null.

Constructor Summary

Constructors

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

Method Summary

Methods

Modifier and Type	Method and Description
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

ncolumns

public int ncolumns

Number of columns in the result set.

nrows

public int nrows

Number of rows in the result set.

column

public String[] column

Column names of the result set.

types

public String[] types

Types of columns of the result set or null.

rows

public Vector<String[]> rows

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

maxrows

public int maxrows

Maximum number of rows to hold in the table.

atmaxrows

public boolean atmaxrows

Flag to indicate Maximum number of rows condition.

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.

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

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

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

toString

public String toString()

Make String representation of result set.

Overrides:

toString in class Object