Index

Overview

Package

Class

Use

Deprecated

Index

Home >> All >> javatools >> [ db overview ]

PREV NEXT

A B C D E F G H I J L M N O P R S T U V W

A

AbstractTable - class javatools.db.AbstractTable.: A class representing tabular data.
AbstractTable() - Constructor for class javatools.db.AbstractTable
add(DbRow) - Method in class javatools.db.DbRowSet: Adds a row to the list.
addAll(DbAbstractTable) - Method in class javatools.db.DbSelector: Add all the columns from the given table to the select list.
addAllExcept(DbAbstractTable, DbColumn) - Method in class javatools.db.DbSelector: Add all the columns from the given table to the select list.
addAllExcept(DbAbstractTable, Set) - Method in class javatools.db.DbSelector: Add all the columns from the given table to the select list.
addColumn(DbColumn, Object) - Method in class javatools.db.DbInserter: Specify the value of a column to add.
addColumn(Object) - Method in class javatools.db.DbSelector: Add the given object to the select column list.
addColumn(Object, String) - Method in class javatools.db.DbSelector: Add the given object to the select column list with an "AS" alias.
addColumn(DbColumn, Object) - Method in class javatools.db.DbUpdater: Add a column specification to update.
addFatherTable(DbAbstractTable, DbColumn[], DbColumn[], int, int) - Method in class javatools.db.DbDynamicConstraint: Adds a new father table.
addFatherTable(DbReferencedTable, DbColumn[], DbColumn[], int, int) - Method in class javatools.db.DbReferencedTable
addGroupBy(DbExpr) - Method in class javatools.db.DbSelector: Adds a GROUP BY column to this select.
addJoinedTable(DbJoinedTable) - Method in class javatools.db.DbSelector: Adds a joined table.
addOrderBy(DbExpr, boolean) - Method in class javatools.db.DbSelector: Add an ORDER BY clause to this select.
addSonTable(DbAbstractTable, int) - Method in class javatools.db.DbDynamicConstraint: Adds a son table.
addSonTable(DbReferencedTable, int) - Method in class javatools.db.DbReferencedTable
and(DbExpr) - Method in class javatools.db.DbExpr: Returns an expression created as an "and" between the current expression and another expression.
args - Variable in class javatools.db.DbExprFuncDef: The arguments for the function.
args - Variable in class javatools.db.DbMiscExpr: See DbFuncExpr
asMap - Variable in class javatools.db.DbSelector: Maps columns to "AS" arguments.
autoCommit - Variable in class javatools.db.DbDatabase: true: each database update is autocommitted; false: commit must be made manually.
automaticBuild - Variable in class javatools.db.DbDynamicConstraint
automaticChecking - Variable in class javatools.db.DbConstraint: true: check is done at all times; false: check is performed only with an explicit call to check.

B

build(DbManager, String, String, String, int, String, String, String, String) - Static method in class javatools.db.ConnectionString: Returns a connection string for given parameters
build(DbManager, String, String, String, int, String, String, String) - Static method in class javatools.db.ConnectionString: Returns a connection string for given parameters
build() - Method in class javatools.db.DbConstraint: After all settings, it finally builds all static references.
build() - Method in class javatools.db.DbDynamicConstraint: Builds all static lists.
buildArrays() - Method in class javatools.db.DbDynamicConstraint
buildColumns() - Method in class javatools.db.DbFixedAbstractTable
buildConstraints() - Method in class javatools.db.DbConstraint
buildDefaultValues() - Method in class javatools.db.DbConstraint
buildDeleteCascadeChildren() - Method in class javatools.db.DbConstraint
buildFatherRecords() - Method in class javatools.db.DbConstraint
buildReferences() - Method in class javatools.db.DbConstraint
buildSearchSets() - Method in class javatools.db.DbConstraint
buildSet(Integer[], DbIterator) - Method in class javatools.db.DbConstraint
buildSonColsList() - Method in class javatools.db.DbConstraint
buildSonRecords(int) - Method in class javatools.db.DbConstraint
buildSonWhere(int) - Method in class javatools.db.DbConstraint
buildSonsWhereList() - Method in class javatools.db.DbConstraint
buildTableName() - Method in class javatools.db.DbJoinedTable
buildUp() - Method in class javatools.db.DbFixedAbstractTable: Performs building of static lists.
buildUpdateCascadeChildren() - Method in class javatools.db.DbConstraint
buildUpdateLists() - Method in class javatools.db.DbConstraint

C

CASCADE - Static variable in class javatools.db.DbConstraint: It means that, in case of an UPDATE/DELETE operation, the constraint MUST cascade the operation, that is updating/deleting in cascade all involved rows.
CASCADE - Static variable in class javatools.db.DbReferencedTable
ConnectionString - class javatools.db.ConnectionString.: A class to manage the building of connection string for JDBC.
ConnectionString() - Constructor for class javatools.db.ConnectionString
c1 - Variable in class javatools.db.DbCriterion: The first term.
c2 - Variable in class javatools.db.DbCriterion: The second term.
canDoUpdate - Variable in class javatools.db.DbConstraint: true: update can be done.
cascade() - Method in class javatools.db.DbConstraint
catchDefaults() - Method in class javatools.db.DbFixedAbstractTable: Finds defaults.
catchDefaults() - Method in class javatools.db.DbReferencedTable
check(int) - Method in class javatools.db.DbConstraint: After setting all dynamic (i.e.
check(int) - Method in class javatools.db.DbDynamicConstraint: Performs checking in the table, after setting all dynamic and "static" data.
checkChildren() - Method in class javatools.db.DbConstraint: Checks recursively each son.
checkFathers() - Method in class javatools.db.DbConstraint: Performs checking for father tables.
checkFathers() - Method in class javatools.db.DbDynamicConstraint: Checks the fathers.
checkStatement - Variable in class javatools.db.DbDatabase: A flag indicating if a DBMS supports check clauses in its constraints.
checkThis(int) - Method in class javatools.db.DbConstraint: Performs base checks.
checkThis(int) - Method in class javatools.db.DbDynamicConstraint: Performs base checking.
clear() - Method in class javatools.db.DbConstraint: Clears everything.
clear() - Method in class javatools.db.DbRowSet: Completely clears this row set.
clearReferences() - Method in class javatools.db.DbReferencedTable
clone() - Method in class javatools.db.DbConstraint: Clones this object.
cloned - Variable in class javatools.db.DbConstraint: true: the object is cloned.
close() - Method in class javatools.db.DbConnection: Closes the connection.
close() - Method in class javatools.db.DbManager: Close ALL connections associated with this database.
close() - Method in interface javatools.db.DbResult: Closes this table.
close() - Method in class javatools.db.DbRowSet: Closes this table.
close() - Method in class javatools.db.DbTable: Closes this table.
colNameMap - Variable in class javatools.db.AbstractTable: Maps the columns to their names.
colNameMap - Variable in class javatools.db.DbFixedAbstractTable: A map containing all column names.
column - Variable in class javatools.db.DbOrderBy: The column to be used for sorting.
columnCount - Variable in class javatools.db.DbTable
columnList - Variable in class javatools.db.DbSelector: Contains the columns used in this operation.
columns - Variable in class javatools.db.DbFixedAbstractTable: The array containing all the columns of the table.
columns - Variable in class javatools.db.DbTable: Contains the list of columns.
commit() - Method in class javatools.db.DbConnection: Commits all operations.
commit() - Method in class javatools.db.DbManager: Perform a commit on ALL connections associated with this database.
commitClose() - Method in class javatools.db.DbConnection: Commits all the operations and closes the connection.
commitClose() - Method in class javatools.db.DbManager: Commit and close ALL connections associated with this database.
con - Variable in class javatools.db.DbConnection: The real Connection object.
connectString - Variable in class javatools.db.DbDatabase: The connection string for this DBMS-database.
connectionThreadMap - Variable in class javatools.db.DbDatabase: A map to reference each connection to each thread.
constraint - Variable in class javatools.db.DbReferencedTable
constraintEmulation - Variable in class javatools.db.DbConstraint: true: emulation made as needed; false: emulation is not made.
constraints - Variable in class javatools.db.DbConstraint: Contains an array of constraint to perform cascade-check and cascade-updates.
containsAllStrings(String[]) - Method in class javatools.db.DbExpr: Creates an expression to be used to search in char columns containing one of the specified strings.
containsAllStrings(List) - Method in class javatools.db.DbExpr: Creates an expression to be used to search in char columns containing one of the specified strings.
count() - Method in class javatools.db.DbExpr: Returns the count expression for the current expression.
createDatabase(String, int, String) - Method in class javatools.db.DbDatabaseAdmin: Creates a database.
createIndex(String, DbAbstractTable, DbColumn[]) - Method in class javatools.db.DbDatabaseAdmin: Creates an index for a database.
createReferences() - Method in class javatools.db.DbDynamicConstraint
createReferences() - Method in class javatools.db.DbReferencedTable
createUser(String, String) - Method in class javatools.db.DbDatabaseAdmin
createdInThread - Variable in class javatools.db.DbConnection: It should contain the current thread, or a new thread, in case a specific function in DbDatabase is called.
currentOperation - Variable in class javatools.db.DbConstraint: Represents the current operation.

D

DELETE_OPERATION - Static variable in class javatools.db.DbConstraint: It represents a DELETE operation.
DO_NOTHING - Static variable in class javatools.db.DbConstraint: It means that, in case of an UPDATE/DELETE operation, the table MUST NOT do anything to repair itself.
DO_NOTHING - Static variable in class javatools.db.DbReferencedTable
DbAbstractTable - class javatools.db.DbAbstractTable.
DbAbstractTable(DbDatabase) - Constructor for class javatools.db.DbAbstractTable: Creates a new instance of DbAbstractDatabaseTable
DbAndExpr - class javatools.db.DbAndExpr.: An expression of the form A AND B.
DbAndExpr(DbDatabase, Object, Object) - Constructor for class javatools.db.DbAndExpr: Builds a new "and" expression in the form "o1 AND o2".
DbCachedIterator - class javatools.db.DbCachedIterator.: A class to represent a "cached" DbIterator, that is an iterator that can be called more than once.
DbCachedIterator(DbCachedTable) - Constructor for class javatools.db.DbCachedIterator: Creates new DbCachedIterator
DbCachedTable - class javatools.db.DbCachedTable.: It's a "cached" table, that represents a result from SELECT in a cached way, that is it can be accessed more than once.
DbCachedTable(DbDatabase) - Constructor for class javatools.db.DbCachedTable: Creates new DbCachedTable
DbColumn - class javatools.db.DbColumn.: A class that represents a particular column within a particular DbTable.
DbColumn(DbAbstractTable, int) - Constructor for class javatools.db.DbColumn: Creates a new DbColumn.
DbConnection - class javatools.db.DbConnection.: A Database connection.
DbConnection(DbDatabase, Connection) - Constructor for class javatools.db.DbConnection: Creates a new DbConnection.
DbConstraint - class javatools.db.DbConstraint.: This abstract class represents a generic set of constraints for a table.
DbConstraint() - Constructor for class javatools.db.DbConstraint: Creates new DbConstraint
DbConstraint(DbAbstractTable) - Constructor for class javatools.db.DbConstraint: Creates a new DbConstraint for a specified table.
DbCriterion - class javatools.db.DbCriterion.: It is a class that represents an expression of the type "A op B", where "op" is a generic operator.
DbCriterion(DbDatabase, Object, String, Object) - Constructor for class javatools.db.DbCriterion: Builds a new DbCriterion object.
DbDatabase - class javatools.db.DbDatabase.: A class that represents a particular database.
DbDatabase() - Constructor for class javatools.db.DbDatabase: Builds a new DbDatabase empty object.
DbDatabase(DbManager, String, String, String, String, String) - Constructor for class javatools.db.DbDatabase: Builds a new DbDatabase object.
DbDatabaseAdmin - class javatools.db.DbDatabaseAdmin.: Class to manage administrator functions.
DbDatabaseAdmin(DbManager, String, String, String, String, String) - Constructor for class javatools.db.DbDatabaseAdmin: Creates new DbDatabaseAdmin
DbDatabaseAdmin(DbDatabase) - Constructor for class javatools.db.DbDatabaseAdmin: Creates new DbDatabaseAdmin
DbDeleter - class javatools.db.DbDeleter.: A class used to delete records from SQL tables.
DbDeleter(DbAbstractTable) - Constructor for class javatools.db.DbDeleter: Builds a new DbDeleter object.
DbDynamicConstraint - class javatools.db.DbDynamicConstraint.: It is a class representing a "dynamic" constraint, i.e.
DbDynamicConstraint(DbAbstractTable) - Constructor for class javatools.db.DbDynamicConstraint: Creates new DbDynamicConstraint
DbException - exception javatools.db.DbException.: An Exception class for this package.
DbException(String) - Constructor for class javatools.db.DbException: Builds a new DbException object.
DbException(String, Exception) - Constructor for class javatools.db.DbException: Builds a new DbException object.
DbException(Exception) - Constructor for class javatools.db.DbException: Builds a new DbException object.
DbExpr - class javatools.db.DbExpr.: An sql expression class.
DbExpr(DbDatabase) - Constructor for class javatools.db.DbExpr: Constructor for the DbExpr object
DbExprFuncDef - class javatools.db.DbExprFuncDef.: An SQL expression of the form FUNCNAME(parameter....).
DbExprFuncDef(DbDatabase, String) - Constructor for class javatools.db.DbExprFuncDef: Constructor for the DbExprFuncDef object
DbExprFuncDef(DbDatabase, String, Object) - Constructor for class javatools.db.DbExprFuncDef: Constructor for the DbExprFuncDef object
DbExprFuncDef(DbDatabase, String, Object, Object) - Constructor for class javatools.db.DbExprFuncDef: Constructor for the DbExprFuncDef object
DbFalseExpr - class javatools.db.DbFalseExpr.: An expression that always evaluates to false.
DbFalseExpr(DbDatabase) - Constructor for class javatools.db.DbFalseExpr: Builds a new false expression.
DbFixedAbstractTable - class javatools.db.DbFixedAbstractTable.: It represents a real database table.
DbFixedAbstractTable(DbDatabase) - Constructor for class javatools.db.DbFixedAbstractTable: Creates new DbFixedAbstractTable
DbInserter - class javatools.db.DbInserter.: A class used to insert records into SQL tables.
DbInserter(DbAbstractTable, DbSelector) - Constructor for class javatools.db.DbInserter: Creates a new DbInserter.
DbInserter(DbAbstractTable) - Constructor for class javatools.db.DbInserter: Creates a new inserter.
DbIterator - interface javatools.db.DbIterator.: An iterator interface for DbTables.
DbJoinedTable - class javatools.db.DbJoinedTable.: This class represents a "joined table" in an SQL statement.
DbJoinedTable(DbDatabase, DbAbstractTable, DbAbstractTable, int, DbExpr) - Constructor for class javatools.db.DbJoinedTable: Creates a new instance of DbJoinedTable
DbLiteral - class javatools.db.DbLiteral.: Inserts a piece of literal text within the SQL expression.
DbLiteral(DbDatabase, String) - Constructor for class javatools.db.DbLiteral: Constructor for the DbLiteral object
DbManager - class javatools.db.DbManager.: A class to manage all the other DbDatabases.
DbManager() - Constructor for class javatools.db.DbManager
DbMiscExpr - class javatools.db.DbMiscExpr.: An SQL expression of the form FUNCNAME(parameter....).
DbMiscExpr(DbDatabase, String) - Constructor for class javatools.db.DbMiscExpr: See DbFuncExpr
DbMiscExpr(DbDatabase, String, Object) - Constructor for class javatools.db.DbMiscExpr: See DbFuncExpr
DbMiscExpr(DbDatabase, String, Object, Object) - Constructor for class javatools.db.DbMiscExpr: See DbFuncExpr
DbOrExpr - class javatools.db.DbOrExpr.: An expression of the form A OR B.
DbOrExpr(DbDatabase, Object, Object) - Constructor for class javatools.db.DbOrExpr: Creates a new OR expression.
DbOrderBy - class javatools.db.DbOrderBy.: A class that represents an ORDER BY clause in a SELECT.
DbOrderBy(DbExpr, boolean) - Constructor for class javatools.db.DbOrderBy: Creates a new DbOrderBy expression.
DbParenthesis - class javatools.db.DbParenthesis.: This expression has the result of putting parenthesis around another expression.
DbParenthesis(DbDatabase, DbExpr) - Constructor for class javatools.db.DbParenthesis: Constructor for the DbParenthesis object
DbReferencedDeleter - class javatools.db.DbReferencedDeleter.: It is just a DbDeleter, except in the fact it takes care of constraints.
DbReferencedDeleter(DbAbstractTable) - Constructor for class javatools.db.DbReferencedDeleter: Creates a new DbReferencedDeleter.
DbReferencedInserter - class javatools.db.DbReferencedInserter.: It is just like a DbInserter, except on the fact it takes care of constraints.
DbReferencedInserter(DbAbstractTable, DbSelector) - Constructor for class javatools.db.DbReferencedInserter: Creates new DbReferencedInserter
DbReferencedInserter(DbAbstractTable) - Constructor for class javatools.db.DbReferencedInserter: Creates new DbReferencedInserter
DbReferencedTable - class javatools.db.DbReferencedTable.: It is currently a hybrid.
DbReferencedTable(DbDatabase) - Constructor for class javatools.db.DbReferencedTable
DbReferencedUpdater - class javatools.db.DbReferencedUpdater.: It is just like DbUpdater, except in the fact it takes care of constraints.
DbReferencedUpdater(DbAbstractTable) - Constructor for class javatools.db.DbReferencedUpdater: Creates a new DbReferencedUpdater.
DbResult - interface javatools.db.DbResult.: A class representing tabular data.
DbRow - class javatools.db.DbRow.: A row of tabular data.
DbRow(AbstractTable) - Constructor for class javatools.db.DbRow: Not public.
DbRowSet - class javatools.db.DbRowSet.: It contains only a set of rows.
DbRowSet() - Constructor for class javatools.db.DbRowSet: Creates new DbRowSet
DbRowSetIterator - class javatools.db.DbRowSetIterator.
DbRowSetIterator(DbRowSet) - Constructor for class javatools.db.DbRowSetIterator: Creates a new instance of DbRowSetIterator
DbSelector - class javatools.db.DbSelector.: A class used to select tabular data from an SQL database.
DbSelector(DbDatabase) - Constructor for class javatools.db.DbSelector: Create a new DbSelector.
DbSequence - class javatools.db.DbSequence.: Generates unique values for use as keys.
DbSequence(DbDatabase, String) - Constructor for class javatools.db.DbSequence: Creates a new DbSequence.
DbTable - class javatools.db.DbTable.: A class representing tabular data.
DbTable(DbDatabase) - Constructor for class javatools.db.DbTable: Creates a new DbTable.
DbTableIterator - class javatools.db.DbTableIterator.: An iterator class for DbTables.
DbTableIterator(DbTable) - Constructor for class javatools.db.DbTableIterator: Creates a new DbIterator
DbTableUser - interface javatools.db.DbTableUser.: It is an interface for all the "things" that use tables.
DbTrueExpr - class javatools.db.DbTrueExpr.: An expression that always evaluates to true.
DbTrueExpr(DbDatabase) - Constructor for class javatools.db.DbTrueExpr: Creates a new DbTrueExpr expression.
DbUpdater - class javatools.db.DbUpdater.: A class used to update records from SQL tables.
DbUpdater(DbAbstractTable) - Constructor for class javatools.db.DbUpdater: Creates a new DbUpdater.
DbValueList - class javatools.db.DbValueList.: This class represents a set of values to be used in an expression.
DbValueList(DbDatabase, Collection) - Constructor for class javatools.db.DbValueList: Creates new DbValueList
database - Variable in class javatools.db.DbConnection: The database to connect to.
databaseNameMap - Variable in class javatools.db.DbManager: A map for matching DBMSs to names.
dateTrunc() - Method in class javatools.db.DbExpr: Truncs the date? Obscure.
db - Variable in class javatools.db.DbAbstractTable
db - Variable in class javatools.db.DbExpr: The database to be used to represent this expression.
db - Variable in class javatools.db.DbSequence: The database to be used.
db - Variable in class javatools.db.DbTable: The database used for the connection.
dbms2creator - Variable in class javatools.db.DbDatabaseAdmin
dbms2userCreator - Variable in class javatools.db.DbDatabaseAdmin
defaultValues - Variable in class javatools.db.DbConstraint: Contains default values for each referenced field of each father table.
defaultValues - Variable in class javatools.db.DbFixedAbstractTable: Array containing the default values.
defaultValues - Variable in class javatools.db.DbTable: Contains the default values for this table.
deleteCascadeChildren - Variable in class javatools.db.DbConstraint: Currently unused.
deleteOperations - Variable in class javatools.db.DbConstraint: It contains the delete operations for each father table.
deleteOperations - Variable in class javatools.db.DbDynamicConstraint
deleter() - Method in class javatools.db.DbAbstractTable: Returns a deleter for this table.
deleter() - Method in class javatools.db.DbFixedAbstractTable: Returns a deleter for this table.
deleter() - Method in class javatools.db.DbJoinedTable: Returns a deleter for deleting rows in the database.
deleter() - Method in class javatools.db.DbReferencedTable
descending - Variable in class javatools.db.DbOrderBy: true: if the order is descending; false: if the order is ascending.
displaySize - Variable in class javatools.db.AbstractTable: This array contains the display size for each field.
distinct - Variable in class javatools.db.DbSelector: true: clause DISTINCT will be put; false: clause DISTINCT will not be put.
driver - Variable in class javatools.db.DbDatabase: The JDBC driver to access this DBMS.
dropDatabase(String) - Method in class javatools.db.DbDatabaseAdmin: Destroys a database.
dropTable(DbAbstractTable) - Method in class javatools.db.DbDatabaseAdmin: Deletes a table from a database.

E

equal(Object) - Method in class javatools.db.DbExpr: Return an expression representing this column being equal to another value.
equals(Object) - Method in class javatools.db.AbstractTable: Check if an object is equal to the current one.
equals(Object) - Method in class javatools.db.DbColumn: Checks if a column equals another column.
equals(Object) - Method in class javatools.db.DbDatabase: Checks if a DbDatabase object equals this one.
equals(Object) - Method in class javatools.db.DbJoinedTable: Check if an object is equal to the current one.
execute(DbConnection) - Method in class javatools.db.DbDeleter: Execute this delete command on a specific connection.
execute() - Method in class javatools.db.DbDeleter: Execute this command on the default connection.
execute(DbConnection) - Method in class javatools.db.DbInserter: Execute this command on a specific connection.
execute() - Method in class javatools.db.DbInserter: Execute this command on the default connection.
execute() - Method in class javatools.db.DbReferencedDeleter: Execute this command on the default connection.
execute() - Method in class javatools.db.DbReferencedInserter: Execute this command on the default connection.
execute() - Method in class javatools.db.DbReferencedUpdater: Execute this command on the default connection.
execute(DbConnection) - Method in class javatools.db.DbSelector: Execute and return a DbTable.
execute() - Method in class javatools.db.DbSelector: Execute and return a DbTable with the default DbConnection.
execute(DbConnection) - Method in class javatools.db.DbUpdater: Execute this delete command on a specific connection.
execute() - Method in class javatools.db.DbUpdater: Execute this command on the default connection.
executeToResultSet(DbConnection) - Method in class javatools.db.DbSelector: Execute and get a JDBC ResultSet.
expr - Variable in class javatools.db.DbParenthesis: The parenthesized expression.

F

falseExpr() - Method in class javatools.db.DbDatabase: Return an expression representing an SQL false expression.
fatherColsChildren - Variable in class javatools.db.DbConstraint: For each son, it contains the referenced column of THIS table.
fatherRecords - Variable in class javatools.db.DbConstraint: Contains the father records used to find eventually involved rows.
fatherTables - Variable in class javatools.db.DbConstraint: It contains all father tables of the one referenced by this constraint.
fatherTables - Variable in class javatools.db.DbDynamicConstraint
fatherTablesColumns - Variable in class javatools.db.DbConstraint: It contains the father keys for each father table.
fatherTablesColumns - Variable in class javatools.db.DbDynamicConstraint
finalize() - Method in class javatools.db.DbConnection: Destroys this object.
finalize() - Method in class javatools.db.DbTable: Destroys this object.
findRefPosition(int) - Method in class javatools.db.DbConstraint
foreignKey - Variable in class javatools.db.DbDatabase: A flag indicating if a DBMS supports foreign keys.
fromList - Variable in class javatools.db.DbConstraint: A list of values/expression to put data into (used in INSERT/UPDATE operations).
fromList - Variable in class javatools.db.DbInserter: The list of values that will be stored.
fromList - Variable in class javatools.db.DbUpdater: The list of data to update.
func - Variable in class javatools.db.DbExprFuncDef: The function name.
func - Variable in class javatools.db.DbMiscExpr: See DbFuncExpr

G

get(int) - Method in class javatools.db.DbRowSet: Returns a row at the specified position.
getAddColumn() - Method in class javatools.db.DbTable: Adds a column and returns it to the caller.
getAutomaticChecking() - Method in class javatools.db.DbConstraint: Returns the current automatic checking setting.
getBytes(String) - Method in class javatools.db.DbRow: Return a blob column as an array of bytes.
getCheckStatement() - Method in class javatools.db.DbDatabase: Returns the capability of DBMS to handle check statements.
getColumn(String) - Method in class javatools.db.DbAbstractTable: Get the DbColumn representing the column with this name.
getColumn(int) - Method in class javatools.db.DbAbstractTable: Get the column of the given index.
getColumn(int) - Method in class javatools.db.DbFixedAbstractTable: Get the column of the given index.
getColumn(String) - Method in class javatools.db.DbFixedAbstractTable: Get the DbColumn representing the column with this name.
getColumn(String) - Method in class javatools.db.DbJoinedTable: Get the DbColumn representing the column with this name.
getColumn(int) - Method in class javatools.db.DbJoinedTable: Get the column of the given index.
getColumn() - Method in class javatools.db.DbOrderBy: The column to sort on.
getColumn(int) - Method in class javatools.db.DbSelector: Gets a column in the column list.
getColumn(String) - Method in class javatools.db.DbTable: Get the DbColumn representing the column with this name.
getColumn(int) - Method in class javatools.db.DbTable: Get the column of the given index.
getColumnCount() - Method in class javatools.db.AbstractTable: Returns the number of columns
getColumnCount() - Method in class javatools.db.DbFixedAbstractTable: Returns the number of contained columns.
getColumnCount() - Method in class javatools.db.DbJoinedTable: Returns the number of columns
getColumnCount() - Method in class javatools.db.DbTable: Returns the number of columns.
getColumnIndex(String) - Method in class javatools.db.AbstractTable
getColumnName(int) - Method in class javatools.db.AbstractTable
getConstraint() - Method in class javatools.db.DbAbstractTable: Returns the DbConstraint object associated with this table.
getConstraint() - Method in class javatools.db.DbJoinedTable: Returns the DbConstraint object associated with this table.
getConstraint() - Method in class javatools.db.DbReferencedTable
getConstraint() - Method in class javatools.db.DbTable: Returns null (no constraint in a simple DbTable).
getConstraintEmulation() - Method in class javatools.db.DbConstraint: Returns if constraint emulation is enabled.
getDatabase() - Method in class javatools.db.DbAbstractTable: Get the database that this table came from When inheriting, you can pass a "null" value.
getDatabase(String, String, String, String, String) - Method in class javatools.db.DbManager: Return the database object associated with this name or parameters.
getDatabase(String) - Method in class javatools.db.DbManager: Return the database associated with this name.
getDatabase() - Method in class javatools.db.DbTable: Get the database that this table came fr
getDatabaseNameMap() - Method in class javatools.db.DbManager: Return a Map that maps DbDatabases to names.
getDefault(int) - Method in class javatools.db.DbAbstractTable: Returns the default value for the field at the given index.
getDefault(String) - Method in class javatools.db.DbAbstractTable: Returns the default value for the field whose name is specified.
getDefault(int) - Method in class javatools.db.DbFixedAbstractTable: Returns the default value for the requested column.
getDefault(String) - Method in class javatools.db.DbFixedAbstractTable: Returns the default value for a given column.
getDefault(int) - Method in class javatools.db.DbJoinedTable: Returns the default value for the field at the given index.
getDefault(String) - Method in class javatools.db.DbJoinedTable: Returns the default value for the field whose name is specified.
getDefault(int) - Method in class javatools.db.DbTable: Returns the default value for this table.
getDefault(String) - Method in class javatools.db.DbTable: Returns the default value of a column.
getDefaultValues(int) - Method in class javatools.db.DbConstraint: Returns an array containing the default values for fields of a father table whose index is specified.
getDefaultValues(int) - Method in class javatools.db.DbDynamicConstraint: Returns the default values of referenced father table whose index is specified.
getDeleteOperation(int) - Method in class javatools.db.DbConstraint: Returns what kind of operation will be done in case of a deletion of the father table specified by index.
getDeleteOperation(int) - Method in class javatools.db.DbDynamicConstraint: Returns the delete operation that should be done for the father table whose index is specified.
getDeleteOperation(int) - Method in class javatools.db.DbReferencedTable
getDescending() - Method in class javatools.db.DbOrderBy: Is this clause descending order?
getEmulationsNeeded() - Method in class javatools.db.DbDatabase
getExistingThreadConnection() - Method in class javatools.db.DbDatabase: Get a DbConnection that will be associated with this Thread, but only if one exists already.
getFatherColumns(int) - Method in class javatools.db.DbConstraint: Returns the referenced father columns of a father table whose index is specified.
getFatherColumns(int) - Method in class javatools.db.DbDynamicConstraint: The referenced columns of father table whose index is specified.
getFatherColumns(int) - Method in class javatools.db.DbReferencedTable
getFatherTable(int) - Method in class javatools.db.DbConstraint: Returns a father table whose index is specified.
getFatherTable(int) - Method in class javatools.db.DbDynamicConstraint: Returns a father table whose index is specified.
getFatherTable(int) - Method in class javatools.db.DbReferencedTable
getFatherTablesCount() - Method in class javatools.db.DbConstraint: Returns the number of referenced father tables.
getFatherTablesCount() - Method in class javatools.db.DbDynamicConstraint: Returns the number of referenced father tables.
getFatherTablesCount() - Method in class javatools.db.DbReferencedTable
getFileName() - Method in class javatools.db.DbFixedAbstractTable
getForeignKey() - Method in class javatools.db.DbDatabase: Returns the capability of DBMS to handle foreign keys.
getFullTableName() - Method in class javatools.db.AbstractTable: Returns the complete table name.
getFullTableName() - Method in class javatools.db.DbTable: Returns the complete table name.
getIndex() - Method in class javatools.db.DbColumn: Returns the index of the column among the fields of the table.
getInt(String) - Method in class javatools.db.DbRow: Return a column as an int.
getInteger(String) - Method in class javatools.db.DbRow: Return a column as an Integer.
getJoinedTable(DbAbstractTable, DbAbstractTable, int, DbExpr) - Method in class javatools.db.DbDatabase: Returns a joined table.
getLong(String) - Method in class javatools.db.DbRow: Return a column as a log.
getName() - Method in class javatools.db.DbColumn: Returns the column name.
getNameDatabaseMap() - Method in class javatools.db.DbManager: Return a Map that maps names to DbDatabases.
getNewConnection() - Method in class javatools.db.DbDatabase: Return a brand new DbConnection.
getNext() - Method in class javatools.db.DbTableIterator: Puts the pointer one step after.
getNumber(String) - Method in class javatools.db.DbRow: Return a column as a number
getOnDeleteCascade() - Method in class javatools.db.DbDatabase: Returns the capability of DBMS to handle ON DELETE CASCADE clauses.
getOnDeleteSetDefault() - Method in class javatools.db.DbDatabase: Returns the capability of DBMS to handle ON DELETE SET DEFAULT clauses.
getOnDeleteSetNull() - Method in class javatools.db.DbDatabase: Returns the capability of DBMS to handle ON DELETE SET NULL clauses.
getOnUpdateCascade() - Method in class javatools.db.DbDatabase: Returns the capability of DBMS to handle ON UPDATE CASCADE clauses.
getOnUpdateSetDefault() - Method in class javatools.db.DbDatabase: Returns the capability of DBMS to handle ON UPDATE SET DEFAULT clauses.
getOnUpdateSetNull() - Method in class javatools.db.DbDatabase: Returns the capability of DBMS to handle ON UPDATE SET NULL clauses.
getPassword() - Method in class javatools.db.DbDatabase
getProperty(String) - Method in class javatools.db.DbDatabase: A database can have a set of properties associated with it.
getProps() - Method in class javatools.db.DbManager: Return a properties object for the db subsystem.
getQueryString() - Method in class javatools.db.DbAndExpr: Returns the query string related to this expression.
getQueryString() - Method in class javatools.db.DbColumn: Returns the query string related to this column.
getQueryString() - Method in class javatools.db.DbCriterion: Returns the query string related to this expression.
getQueryString() - Method in class javatools.db.DbDeleter: Returns the query string related to this deleter.
getQueryString() - Method in class javatools.db.DbExpr: Any DbExpr needs to be able to convert into the SQL string equivilent.
getQueryString() - Method in class javatools.db.DbExprFuncDef: Gets the queryString attribute of the DbExprFuncDef object
getQueryString() - Method in class javatools.db.DbInserter: Returns the complete query string.
getQueryString() - Method in class javatools.db.DbLiteral: Gets the queryString attribute of the DbLiteral object
getQueryString() - Method in class javatools.db.DbMiscExpr: See DbFuncExpr
getQueryString() - Method in class javatools.db.DbOrExpr: Returns the query string related to this expression.
getQueryString() - Method in class javatools.db.DbOrderBy: Returns the query string related to these expression.
getQueryString() - Method in class javatools.db.DbParenthesis: Gets the queryString attribute of the DbParenthesis object
getQueryString() - Method in class javatools.db.DbSelector: Get the query string represented by this query.
getQueryString() - Method in class javatools.db.DbUpdater: Returns the query string for this object.
getQueryString() - Method in class javatools.db.DbValueList: Any DbExpr needs to be able to convert into the SQL string equivilent.
getRefColumns(int) - Method in class javatools.db.DbConstraint: Returns the referencing columns of THIS table for a father table whose index is specified.
getRefColumns(int) - Method in class javatools.db.DbDynamicConstraint: Returns the referencing columns of THIS table to the father table whose index is specified.
getRefColumns(int) - Method in class javatools.db.DbReferencedTable
getSequence(String) - Method in class javatools.db.DbDatabase: Ahem...
getSize() - Method in class javatools.db.DbColumn: Returns the display size of this column.
getSonFatherIndex(int) - Method in class javatools.db.DbConstraint: Returns in which position a son table references THIS table in its constraint.
getSonFatherIndex(int) - Method in class javatools.db.DbDynamicConstraint: Returns the index that a son table uses to reference this table.
getSonFatherIndex(int) - Method in class javatools.db.DbReferencedTable
getSonTable(int) - Method in class javatools.db.DbConstraint: Returns a son table whose index is specified.
getSonTable(int) - Method in class javatools.db.DbDynamicConstraint: Returns a son table whose index is specified.
getSonTable(int) - Method in class javatools.db.DbReferencedTable
getSonTablesCount() - Method in class javatools.db.DbConstraint: Returns the number of son tables.
getSonTablesCount() - Method in class javatools.db.DbDynamicConstraint: Returns the number of son tables.
getSonTablesCount() - Method in class javatools.db.DbReferencedTable
getSqlConnection() - Method in class javatools.db.DbConnection: Returns the real JDBC connection.
getString(Object) - Static method in class javatools.db.DbExpr: Utility function to turn o into an SQL expression.
getString(String) - Method in class javatools.db.DbRow: Return a column as a String.
getSubExpr(DbColumn[]) - Method in class javatools.db.DbColumn: Currently unused.
getTable() - Method in class javatools.db.DbConstraint: Returns the referenced table.
getTable(String) - Method in class javatools.db.DbDatabase: Return an object representing a particular table in the database.
getThreadConnection() - Method in class javatools.db.DbDatabase: Get a DbConnection that will be associated with this Thread.
getUpdateOperation(int) - Method in class javatools.db.DbConstraint: Returns what kind of operation will be done in case of an update of the father table specified by index.
getUpdateOperation(int) - Method in class javatools.db.DbDynamicConstraint: Returns the update operation that should be done for the father table whose index is specified.
getUpdateOperation(int) - Method in class javatools.db.DbReferencedTable
getUserName() - Method in class javatools.db.DbDatabase
getValue(String) - Method in class javatools.db.DbRow: Return a column in the native type.
getValue(int) - Method in class javatools.db.DbRow: Returns a value of a column.
getValueArray() - Method in class javatools.db.DbRow: Returns all the array of values.
getValueCount() - Method in class javatools.db.DbRow: Returns the number of contained values.
getValuesQueryString() - Method in class javatools.db.DbInserter: Returns the sub-query-string for VALUES clause.
getWhere() - Method in class javatools.db.DbSelector: Returns the where condition.
greaterThan(Object) - Method in class javatools.db.DbExpr: Return an expression representing this column being greater than another value.
greaterThanOrEqual(Object) - Method in class javatools.db.DbExpr: Return an expression representing this column being greater than or equal to another value.
groupBy - Variable in class javatools.db.DbSelector: Contains the columns for grouping.
groupByClause(List) - Method in class javatools.db.DbSelector: Generates the GROUP Bye clause.

H

hasNext() - Method in class javatools.db.DbCachedIterator: Checks if this iterator has a value after the current one.
hasNext() - Method in class javatools.db.DbRowSetIterator
hasNext() - Method in class javatools.db.DbTableIterator: Are there more items in this iterator?
hasNextRow() - Method in class javatools.db.DbCachedIterator: Are there more rows to iterator through?
hasNextRow() - Method in interface javatools.db.DbIterator: Are there more rows to iterator through?
hasNextRow() - Method in class javatools.db.DbRowSetIterator: Are there more rows to iterator through?
hasNextRow() - Method in class javatools.db.DbTableIterator: Are there more rows to iterator through?
hasThreadConnection() - Method in class javatools.db.DbDatabase: Does this thread have a default connection associated with it? (i.e.

I

INNER_JOIN - Static variable in class javatools.db.DbJoinedTable: Represents an inner join.
INSERT_OPERATION - Static variable in class javatools.db.DbConstraint: It represents an INSERT operation.
in(Object) - Method in class javatools.db.DbExpr: Returns an expression to represent the "in" clause.
in(Collection) - Method in class javatools.db.DbExpr: Returns an expression that means "IN (value1, value2, ..., valuen)"
index - Variable in class javatools.db.DbColumn: The position between the fields.
initCreatorMap() - Method in class javatools.db.DbDatabaseAdmin
initLists() - Method in class javatools.db.DbConstraint: Builds all dynamic lists (where clauses, constraints etc.).
initStaticLists() - Method in class javatools.db.DbConstraint: Inits static lists, like indexes of son tables, default values of father tables etc.
inserter(DbSelector) - Method in class javatools.db.DbAbstractTable: Return an inserter for inserting new data in the database.
inserter() - Method in class javatools.db.DbAbstractTable: Return an inserter for inserting new data in the database.
inserter(DbSelector) - Method in class javatools.db.DbFixedAbstractTable: Return an inserter for inserting new data in the database.
inserter() - Method in class javatools.db.DbFixedAbstractTable: Return an inserter for inserting new data in the database.
inserter() - Method in class javatools.db.DbJoinedTable: Return an inserter for inserting new data in the database.
inserter(DbSelector) - Method in class javatools.db.DbJoinedTable: Return an inserter for inserting new data in the database.
inserter(DbSelector) - Method in class javatools.db.DbReferencedTable: Return an inserter for inserting new data in the database.
inserter() - Method in class javatools.db.DbReferencedTable: Return an inserter for inserting new data in the database.
intoList - Variable in class javatools.db.DbConstraint: A list of columns to put data into (used in INSERT/UPDATE operations).
intoList - Variable in class javatools.db.DbInserter: The list of columns in which data will be stored.
intoList - Variable in class javatools.db.DbUpdater: The list of columns to update.
isClosed() - Method in class javatools.db.DbConnection: Checks if this connection is closed.
isNotNull() - Method in class javatools.db.DbExpr: Gets the notNull attribute of the DbExpr object
isNull() - Method in class javatools.db.DbExpr: Gets the null attribute of the DbExpr object
iterator() - Method in class javatools.db.DbCachedTable: Return an iterator to iterate over the rows in this table.
iterator() - Method in interface javatools.db.DbResult: Return an iterator to iterate over the rows in this table.
iterator() - Method in class javatools.db.DbRowSet: Return an iterator to iterate over the rows in this table.
iterator() - Method in class javatools.db.DbTable: Return an iterator to iterate over the rows in this table.
iteratorSize(Iterator) - Method in class javatools.db.DbConstraint

J

javatools.db - package javatools.db
joinCondition - Variable in class javatools.db.DbJoinedTable
joinType - Variable in class javatools.db.DbJoinedTable
joinedTables - Variable in class javatools.db.DbSelector: Contains the list of joined tables.

L

LEFT_JOIN - Static variable in class javatools.db.DbJoinedTable: Represents a left join.
last - Variable in class javatools.db.DbTableIterator: Represents the last row returned outside.
lastException - Variable in class javatools.db.DbTableIterator: Represents the last exception caught for this object.
lessThan(Object) - Method in class javatools.db.DbExpr: Return an expression representing this column being less than another value.
lessThanOrEqual(Object) - Method in class javatools.db.DbExpr: Return an expression representing this column being less than or equal to another value.
like(Object) - Method in class javatools.db.DbExpr: Return an expression representing this column being LIKE another value.
limit - Variable in class javatools.db.DbSelector: Limits the search to a certain amount of rows.
listIterator() - Method in class javatools.db.DbRowSet
loadStructure() - Method in class javatools.db.DbFixedAbstractTable: Loads table structure from a file: localConfigPath/TABLENAME.table.
lower() - Method in class javatools.db.DbExpr: Returns an expression in which it will take the lowercase value for current expression.

M

manager - Variable in class javatools.db.DbDatabase: The manager for databases.
max() - Method in class javatools.db.DbExpr: Returns an expression in which it will take the max value for current expression.
min() - Method in class javatools.db.DbExpr: Returns an expression in which it will take the max value for current expression.

N

NATURAL_JOIN - Static variable in class javatools.db.DbJoinedTable: Represents a left join.
name - Variable in class javatools.db.DbDatabase: The name of this DBMS.
name - Variable in class javatools.db.DbSequence: The name for this sequence.
nameDatabaseMap - Variable in class javatools.db.DbManager: A map for matching names to DBMSs.
names - Variable in class javatools.db.AbstractTable: This array contains the names of the fields of the table.
next() - Method in class javatools.db.DbCachedIterator: Takes the next object from the iterator.
next() - Method in class javatools.db.DbRowSetIterator
next() - Method in class javatools.db.DbSequence: Gets the next value.
next(DbConnection) - Method in class javatools.db.DbSequence: Returns the next value, with a specific connection.
next() - Method in class javatools.db.DbTableIterator: Returns the next item.
nextRow() - Method in class javatools.db.DbCachedIterator: Get the next DbRow in the table.
nextRow() - Method in interface javatools.db.DbIterator: Get the n