A B C D E F G I L N P Q R S T V

A

absolute(int) - Method in class litebase.ResultSet

Places this RecordSet cursor at the given absolute row.

add(Control) - Method in class litebase.ui.DBListBox

Does nothing

add(Object) - Method in class litebase.ui.DBListBox

REPLACES the current items with the given ones.

add(Object[]) - Method in class litebase.ui.DBListBox

REPLACES the current items with the given ones.

afterLast() - Method in class litebase.ResultSet

Places the cursor after the last record

AlreadyCreatedException - exception litebase.AlreadyCreatedException.

This exception may be thrown by LitebaseConnection.execute, when a table or index was already created.

AlreadyCreatedException() - Constructor for class litebase.AlreadyCreatedException

AlreadyCreatedException(String) - Constructor for class litebase.AlreadyCreatedException

aspdb - Variable in class litebase.LitebaseConnection

attr - Variable in class litebase.RowIterator

The attribute for this row.

B

bag - Variable in class litebase.LitebaseConnection

bag - Variable in class litebase.ResultSet

beforeFirst() - Method in class litebase.ResultSet

Places the cursor before the first record

C

CHAR_NOCASE_TYPE - Static variable in class litebase.ResultSetMetaData

Used by the getColumnType method

CHAR_TYPE - Static variable in class litebase.ResultSetMetaData

Used by the getColumnType method

clearParameters() - Method in class litebase.PreparedStatement

This method clears all of the input parameter that have been set on this statement.

close() - Method in class litebase.ResultSet

Releases all memory allocated for this object.

close() - Method in class litebase.RowIterator

Closes this iterator.

closeAll() - Method in class litebase.LitebaseConnection

Close all catalogs, so that they are immediately written to disk (at desktop) or release the file handles (at device).

col - Variable in class litebase.ui.DBListBox

The column that will be displayed

convert(String) - Method in class litebase.LitebaseConnection

Convert from stream (.pdb) to plain file.

D

data - Variable in class litebase.RowIterator

The data for the current row.

DATE_TYPE - Static variable in class litebase.ResultSetMetaData

Used by the getColumnType method

DATETIME_TYPE - Static variable in class litebase.ResultSetMetaData

Used by the getColumnType method

DBListBox - class litebase.ui.DBListBox.

DBListBox is a simple implementation of a Listbox.

DBListBox() - Constructor for class litebase.ui.DBListBox

Creates an empty Listbox.

DBListBox(String[][], int) - Constructor for class litebase.ui.DBListBox

Creates a Listbox with the given items.

deleteLogFiles() - Static method in class litebase.LitebaseConnection

Deletes all log files found in the device.

DOUBLE_TYPE - Static variable in class litebase.ResultSetMetaData

Used by the getColumnType method

drawItem(Graphics, int, int, int) - Method in class litebase.ui.DBListBox

You can extend ListBox and overide this method to draw the items

DriverException - exception litebase.DriverException.

This exception may be dispatched if any problem, other than a SQL parsing error, occurs.

DriverException() - Constructor for class litebase.DriverException

DriverException(String) - Constructor for class litebase.DriverException

E

execute(String) - Method in class litebase.LitebaseConnection

Used to execute a create table or create index SQL commands.

executeQuery() - Method in class litebase.PreparedStatement

This method executes a prepared SQL query and returns its ResultSet.

executeQuery(String) - Method in class litebase.LitebaseConnection

Used to execute queries in a table.

executeUpdate() - Method in class litebase.PreparedStatement

This method executes an SQL INSERT, UPDATE or DELETE statement.

executeUpdate(String) - Method in class litebase.LitebaseConnection

Used to execute updates in a table (insert, delete, update, alter table, drop).

exists(String) - Method in class litebase.LitebaseConnection

Returns if the given table already exists.

F

find(char) - Method in class litebase.ui.DBListBox

Does nothing

first() - Method in class litebase.ResultSet

Places the cursor in the first record

FLOAT_TYPE - Static variable in class litebase.ResultSetMetaData

Used by the getColumnType method

G

getChars(int) - Method in class litebase.ResultSet

Given the column index (starting from 1), returns a char array that is represented by this column.

getChars(String) - Method in class litebase.ResultSet

Given the column name (case insensitive), returns a char array that is represented by this column.

getColumnCount() - Method in class litebase.ResultSetMetaData

Returns the number of columns for this resultset

getColumnDisplaySize(int) - Method in class litebase.ResultSetMetaData

Given the column index (starting at 1), returns the display size.

getColumnLabel(int) - Method in class litebase.ResultSetMetaData

Given the column index (starting at 1), returns the column name.

getColumnType(int) - Method in class litebase.ResultSetMetaData

Given the column index (starting at 1), returns the column type.

getCurrentRowId(String) - Method in class litebase.LitebaseConnection

Returns the current rowid for a given table.

getDate(int) - Method in class litebase.ResultSet

Given the column index (starting from 1), returns a Date value that is represented by this column.

getDate(String) - Method in class litebase.ResultSet

Given the column name (case insensitive), returns an Date value that is represented by this column.

getDateTime(int) - Method in class litebase.ResultSet

Given the column index (starting from 1), returns a Time (correspondent to DATETIME LitebaseConnection data type) value that is represented by this column.

getDateTime(String) - Method in class litebase.ResultSet

Given the column name (case insensitive), returns a Time (correspondent to DATETIME LitebaseConnection data type) value that is represented by this column.

getDouble(int) - Method in class litebase.ResultSet

Given the column index (starting from 1), returns a double value that is represented by this column.

getDouble(String) - Method in class litebase.ResultSet

Given the column name (case insensitive), returns a double value that is represented by this column.

getErrorPosition() - Method in class litebase.SQLParseException

Returns the position where the error was found.

getFloat(int) - Method in class litebase.ResultSet

Given the column index (starting from 1), returns a float value that is represented by this column.

getFloat(String) - Method in class litebase.ResultSet

Given the column name (case insensitive), returns a float value that is represented by this column.

getInstance(String) - Static method in class litebase.LitebaseConnection

Creates a LitebaseConnection for the given creator id, storing the database in main memory, and as flat file.

getInstance(String, String) - Static method in class litebase.LitebaseConnection

Creates a LitebaseConnection for the given creator id and with the given connection paramList.

getInt(int) - Method in class litebase.ResultSet

Given the column index (starting from 1), returns an int value that is represented by this column.

getInt(String) - Method in class litebase.ResultSet

Given the column name (case insensitive), returns an int value that is represented by this column.

getItemAt(int) - Method in class litebase.ui.DBListBox

Get the Object at the given Index.

getItems() - Method in class litebase.ui.DBListBox

Returns all items in this ListBox.

getItemWidth(int) - Method in class litebase.ui.DBListBox

Returns the width of the given item index with the current fontmetrics.

getLogName() - Static method in class litebase.LitebaseConnection

Returns the name of the catalog used to store the logs, or null if log is disabled.

getLong(int) - Method in class litebase.ResultSet

Given the column index (starting from 1), returns a long value that is represented by this column.

getLong(String) - Method in class litebase.ResultSet

Given the column name (case insensitive), returns a long value that is represented by this column.

getRecordCount(String) - Method in class litebase.LitebaseConnection

Returns the total number of records for a table, which includes the deleted rows, but excluding the record 0, which is used to store the table metadata.

getResultSetMetaData() - Method in class litebase.ResultSet

Returns the metadata for this resultset.

getRow() - Method in class litebase.ResultSet

Returns the current physical row of the Table that the cursor is.

getRowCount() - Method in class litebase.ResultSet

Returns the number of rows of this resultset

getRowCount(String) - Method in class litebase.LitebaseConnection

Returns the number of valid rows in a table.

getRowIterator(String) - Method in class litebase.LitebaseConnection

Gets an iterator for a table.

getSelectedIndex() - Method in class litebase.ui.DBListBox

Returns the position of the selected item of the Listbox or -1 if the listbox has no selected index yet.

getSelectedItem() - Method in class litebase.ui.DBListBox

Returns the selected item of the Listbox or null if none is selected

getShort(int) - Method in class litebase.ResultSet

Given the column index (starting from 1), returns a short value that is represented by this column.

getShort(String) - Method in class litebase.ResultSet

Given the column name (case insensitive), returns a short value that is represented by this column.

getString(int) - Method in class litebase.ResultSet

Given the column index (starting from 1), returns a String that is represented by this column.

getString(String) - Method in class litebase.ResultSet

Given the column name (case insensitive), returns a String that is represented by this column.

getStrings() - Method in class litebase.ResultSet

Returns all Strings of this resultset in order, starting from the first record.

getStrings(int) - Method in class litebase.ResultSet

This is the most powerful method of this class.

getStrings(int, boolean, boolean) - Method in class litebase.ResultSet

Deprecated. Use getStrings(count) instead.

I

indexOf(Object) - Method in class litebase.ui.DBListBox

Does nothing.

insert(Object, int) - Method in class litebase.ui.DBListBox

Does nothing

INT_TYPE - Static variable in class litebase.ResultSetMetaData

Used by the getColumnType method

L

last() - Method in class litebase.ResultSet

Places the cursor in the last record

litebase - package litebase

Package that contains the classes that manipulate files using SQL.

litebase.ui - package litebase.ui

Useful controls to be used with Litebase.

LitebaseConnection - class litebase.LitebaseConnection.

This class is the one used to issue SQL commands.

LOG_LEVEL_MAX - Static variable in class litebase.LitebaseConnection

Maximum log level.

LOG_LEVEL_NONE - Static variable in class litebase.LitebaseConnection

Default logging level: 0 (no logs generated).

LONG_TYPE - Static variable in class litebase.ResultSetMetaData

Used by the getColumnType method

N

next() - Method in class litebase.ResultSet

Returns the next record of this ResultSet

next() - Method in class litebase.RowIterator

Moves to the next record and fills the data members.

nextNotSynced() - Method in class litebase.RowIterator

Moves to the next with an attribute different of SYNCED.

P

prepare(String) - Method in class litebase.PreparedStatement

Prepare a SQL statement.

PreparedStatement - class litebase.PreparedStatement.

Represents a SQL Statement that can be prepared (compiled) once and executed many times with different parameter values.

PreparedStatement(LitebaseConnection) - Constructor for class litebase.PreparedStatement

Basic constructor

prepareStatement(String) - Method in class litebase.LitebaseConnection

Creates a pre-compiled statement with the given sql.

prev() - Method in class litebase.ResultSet

Returns the previous record of this ResultSet

PrimaryKeyViolationException - exception litebase.PrimaryKeyViolationException.

This exception may be thrown by LitebaseConnection.executeUpdate, when an update in a table can not be completed because it violates the primary key rule.

PrimaryKeyViolationException() - Constructor for class litebase.PrimaryKeyViolationException

PrimaryKeyViolationException(String) - Constructor for class litebase.PrimaryKeyViolationException

processLogs(String[], String, boolean) - Static method in class litebase.LitebaseConnection

This is a handy method that can be used to reproduce all commands of a log file.

purge(String) - Method in class litebase.LitebaseConnection

Used to delete physically the records of the given table.

Q

qsort() - Method in class litebase.ui.DBListBox

Sorts the elements of this ListBox.

R

relative(int) - Method in class litebase.ResultSet

Moves the cursor rows in distance.

remove(Control) - Method in class litebase.ui.DBListBox

Does nothing

remove(int) - Method in class litebase.ui.DBListBox

Does nothing

remove(Object) - Method in class litebase.ui.DBListBox

Does nothing

removeAll() - Method in class litebase.ui.DBListBox

Empties this ListBox, setting all elements of the array to null so they can be garbage collected.

reset() - Method in class litebase.RowIterator

Reset the counter to zero so you can restart to fetch records.

ResultSet - class litebase.ResultSet.

This class represents a set or rows resulting from a LitebaseConnection.executeQuery method call.

ResultSetMetaData - class litebase.ResultSetMetaData.

This class returns useful information for the resultset columns.

ResultSetMetaData(ResultSet) - Constructor for class litebase.ResultSetMetaData

ROW_ATTR_DELETED - Static variable in class litebase.RowIterator

ROW_ATTR_NEW - Static variable in class litebase.RowIterator

ROW_ATTR_SYNCED - Static variable in class litebase.RowIterator

ROW_ATTR_UPDATED - Static variable in class litebase.RowIterator

rowid - Variable in class litebase.RowIterator

The rowid for the current row

RowIterator - class litebase.RowIterator.

Class used to iterate through the rows of a database.

rowNumber - Variable in class litebase.RowIterator

The number of the row.

rs - Variable in class litebase.ResultSetMetaData

The underlying resultset

S

select(int) - Method in class litebase.ui.DBListBox

Select an item and scroll to it if necessary.

setDate(int, Date) - Method in class litebase.PreparedStatement

it formats the Date d in a string "YYYY/MM/DD" and calls the setString IMPORTANT: You must use care with the constructor “new Date()”.

setDateTime(int, Date, Time) - Method in class litebase.PreparedStatement

It formats the Date d and the Time t in a string "YYYY/MM/DD HH:MM:SS:ZZZ" and calls the setString IMPORTANT: You must use care with the constructor “new Date()”.

setDecimalPlaces(int, int) - Method in class litebase.ResultSet

Sets the number of decimal places that the given column (starting from 1) will have when being converted to String.

setDisplayCol(int) - Method in class litebase.ui.DBListBox

Sets the column of the String matrix that will be used to display the elements.

setDouble(int, double) - Method in class litebase.PreparedStatement

This method sets the specified parameter from the given Java double value.

setInt(int, int) - Method in class litebase.PreparedStatement

This method sets the specified parameter from the given Java int value.

setItemAt(int, Object) - Method in class litebase.ui.DBListBox

Does nothing

setLogLevel(int) - Static method in class litebase.LitebaseConnection

Sets the current log level.

setLong(int, long) - Method in class litebase.PreparedStatement

This method sets the specified parameter from the given Java long value.

setRowInc(String, int) - Method in class litebase.LitebaseConnection

Set the row increment used when creating or updating big amounts of data.

setString(int, String) - Method in class litebase.PreparedStatement

This method sets the specified parameter from the given Java String value.

setSynced() - Method in class litebase.RowIterator

If the attribute is currently NEW or UPDATED, this method sets them to SYNCED.

setTime(int, Time) - Method in class litebase.PreparedStatement

It formats the Time t in a string "YYYY/MM/DD HH:MM:SS:ZZZ" and calls the setString

SHORT_TYPE - Static variable in class litebase.ResultSetMetaData

Used by the getColumnType method

sitems - Variable in class litebase.ui.DBListBox

The String items

size() - Method in class litebase.ui.DBListBox

Returns the number of items

SQLParseException - exception litebase.SQLParseException.

This exception may be dispatched by routines that handle the parsing of an SQL command.

SQLParseException() - Constructor for class litebase.SQLParseException

Default constructor.

SQLParseException(String) - Constructor for class litebase.SQLParseException

Constructor which accepts an error message.

SQLParseException(String, int) - Constructor for class litebase.SQLParseException

Constructor which accepts an error message and the error position.

T

toString() - Method in class litebase.PreparedStatement

Returns the sql used in this statement.

V

version - Static variable in class litebase.LitebaseConnection

versionStr - Static variable in class litebase.LitebaseConnection

A B C D E F G I L N P Q R S T V