- getAfter(SelectDescriptor.Key) - Method in class org.brains2b.sql.meta.SelectDescriptor
-
- getAutoIncrement() - Method in class org.brains2b.sql.meta.TypesInfo
-
- getBefore(SelectDescriptor.Key) - Method in class org.brains2b.sql.meta.SelectDescriptor
-
- getBoolValue(String) - Method in class org.brains2b.sql.SQLRecord
-
get the boolean value belonging to the column identified by name
- getBoolValue(int) - Method in class org.brains2b.sql.SQLRecord
-
get the value of the column at the given index as a boolean.
- getCatalog() - Method in class org.brains2b.sql.meta.ProcedureModel
-
get the Catalog for this ProcedureModel
- getCatalog() - Method in class org.brains2b.sql.meta.TableModel
-
get the Catalog for this TableModel
- getCatalogs() - Method in class org.brains2b.sql.meta.SQLMetaData
-
get the catalog names which can be retrieved for this database
- getColumn(int) - Method in class org.brains2b.sql.SQLRecord
-
get the column identifier for the column at the given index
- getColumnCount() - Method in class org.brains2b.sql.SQLRecord
-
get the number of fields in this cursor data object
- getColumns() - Method in class org.brains2b.sql.meta.ConstraintModel
-
get the Columns referenced by this constraint
- getColumns() - Method in class org.brains2b.sql.meta.IndexModel
-
get the columns involved in this Index
- getColumns() - Method in class org.brains2b.sql.meta.SelectDescriptor
-
get a comma-seperated list of columns for this
select statement
- getColumns(String, String, String, String) - Method in class org.brains2b.sql.meta.SQLMetaData
-
get a List of SqlColumModels for each colum that can be found for the parameters supplied.
- getColumns() - Method in class org.brains2b.sql.meta.TableModel
-
get the columns for this Table
- getColumnSize() - Method in class org.brains2b.sql.meta.ColumnModel
-
get the size of the column for non-numeric types or the precision for numeric types
- getColumnType(String) - Method in class org.brains2b.sql.SQLRecord
-
get the column type for the column identified by name
- getColumnType(int) - Method in class org.brains2b.sql.SQLRecord
-
get the column type for the column given by the specified index
- getConnection() - Method in interface org.brains2b.sql.Connector
-
get the JDBC connection for this Connector
- getConnection() - Method in class org.brains2b.sql.LocalConnector
-
get the JDBC connection for this Connector
- getConnection() - Method in class org.brains2b.sql.meta.SQLMetaData
-
get the connection to the Database
- getConnection() - Method in class org.brains2b.sql.RemoteConnector
-
get the JDBC connection for this Connector
- getConstraints(String, String, String, String) - Method in class org.brains2b.sql.meta.SQLMetaData
-
get a List of Constraints (Primary | Foreign ) defined in this database for the
given catalog,schema and pattern.
- getDataType() - Method in class org.brains2b.sql.meta.ColumnModel
-
get the datatype as defined in java.sql.Type
- getDataType() - Method in class org.brains2b.sql.meta.ParameterModel
-
get the datatype as defined in java.sql.Type
- getDataType() - Method in class org.brains2b.sql.meta.TypeModel
-
- getDataType(Class) - Method in class org.brains2b.sql.meta.TypesInfo
-
get the java.sql.Types value for a given class
- getDataType(String, int, int) - Method in class org.brains2b.sql.meta.TypesInfo
-
get the closest datatype for a field given the typename, columSize and decimal digits
- getDb() - Method in class org.brains2b.sql.meta.TypesInfo
-
- getDbName() - Method in class org.brains2b.sql.LocalConnector
-
get the database name this connection uses.
- getDecimalDigits() - Method in class org.brains2b.sql.meta.ColumnModel
-
get the number of decimal places for a numeric field.
- getDefault() - Method in class org.brains2b.sql.meta.ColumnModel
-
get the column default value
- getDoubleValue(int) - Method in class org.brains2b.sql.SQLRecord
-
get the value of the column at the given index as a double.
- getDoubleValue(String) - Method in class org.brains2b.sql.SQLRecord
-
get the double value belonging to the column identified by name
- getExcept() - Method in class org.brains2b.sql.meta.SelectDescriptor
-
- getFrom() - Method in class org.brains2b.sql.meta.SelectDescriptor
-
get a comma-seperated list of tables from the FROM-part
of this select statement
- getGroupBy() - Method in class org.brains2b.sql.meta.SelectDescriptor
-
get a comma-seperated list of columns from the GROUP BY-part
of this select statement
- getHaving() - Method in class org.brains2b.sql.meta.SelectDescriptor
-
get the HAVING clause of this select statement
- getInBetween(SelectDescriptor.Key, SelectDescriptor.Key) - Method in class org.brains2b.sql.meta.SelectDescriptor
-
- getIndex(String) - Method in class org.brains2b.sql.SQLRecord
-
get the index of the column identified by name
- getIndices(String, String, String, boolean) - Method in class org.brains2b.sql.meta.SQLMetaData
-
get a list of Indices for the given parameters.
- getIndices() - Method in class org.brains2b.sql.meta.TableModel
-
get the indices for this Table
- getInputStream() - Method in interface org.brains2b.sql.meta.types.Stream
-
get the input stream
- getIntersect() - Method in class org.brains2b.sql.meta.SelectDescriptor
-
- getIntValue(int) - Method in class org.brains2b.sql.SQLRecord
-
get the value of the column at the given index as an integer.
- getIntValue(String) - Method in class org.brains2b.sql.SQLRecord
-
get the intValue belonging to the column identified by name
- getJavaType(int, int, int) - Method in class org.brains2b.sql.meta.TypesInfo
-
gets a Class as a valid java type on the basis of JDBC column information
- getJavaTypeName(int, int, int) - Method in class org.brains2b.sql.meta.TypesInfo
-
gets a String representation of a valid java type on the basis of JDBC column information
- getJoins() - Method in class org.brains2b.sql.meta.SelectDescriptor
-
- getLimitRows(int) - Method in class org.brains2b.sql.meta.TypesInfo
-
- getLongValue(int) - Method in class org.brains2b.sql.SQLRecord
-
get the value of the column at the given index as a long.
- getLongValue(String) - Method in class org.brains2b.sql.SQLRecord
-
get the longValue belonging to the column identified by name
- getMaxScale() - Method in class org.brains2b.sql.meta.TypeModel
-
- getMetaData() - Method in class org.brains2b.sql.meta.SQLMetaData
-
get the DatabaseMetaData object associated with the connection used
- getMinScale() - Method in class org.brains2b.sql.meta.TypeModel
-
- getName() - Method in class org.brains2b.sql.meta.ColumnModel
-
get the name for this model's instance
- getName() - Method in class org.brains2b.sql.meta.ConstraintModel
-
get the name for this model's instance
- getName() - Method in class org.brains2b.sql.meta.IndexModel
-
get the name for this model's instance
- getName() - Method in class org.brains2b.sql.meta.ParameterModel
-
get the name for this model's instance
- getName() - Method in class org.brains2b.sql.meta.ProcedureModel
-
get the name for this model's instance
- getName() - Method in interface org.brains2b.sql.meta.SQLMetaModel
-
get the name for this model's instance
- getName() - Method in class org.brains2b.sql.meta.TableModel
-
get the name for this model's instance
- getName() - Method in class org.brains2b.sql.meta.TypeModel
-
- getOrderBy() - Method in class org.brains2b.sql.meta.SelectDescriptor
-
get a comma-seperated list of columns from the ORDER BY-part
of this select statement
- getOutputStream() - Method in interface org.brains2b.sql.meta.types.Stream
-
get the output stream
- getParameters() - Method in class org.brains2b.sql.meta.ProcedureModel
-
get the parameters for this ProcedureModel
- getParameters(String, String, String) - Method in class org.brains2b.sql.meta.SQLMetaData
-
get the parameters belonging to the procedure
- getParamType() - Method in class org.brains2b.sql.meta.ParameterModel
-
get the datatype as defined in java.sql.Type
- getPrecision() - Method in class org.brains2b.sql.meta.TypeModel
-
- getPrimaryKey() - Method in class org.brains2b.sql.meta.TableModel
-
- getProcedures(String, String, String) - Method in class org.brains2b.sql.meta.SQLMetaData
-
get a List of Procedures defined in this database without possible parameters
for the given catalog,schema and pattern.
- getProcedures(String, String, String, boolean) - Method in class org.brains2b.sql.meta.SQLMetaData
-
get a List of Procedures defined in this database for the
given catalog,schema and pattern.
- getRecord() - Method in class org.brains2b.sql.meta.ColumnModel
-
the record which defines all the values for the model
- getRecord() - Method in class org.brains2b.sql.meta.ConstraintModel
-
the record which defines all the values for the model
- getRecord() - Method in class org.brains2b.sql.meta.IndexModel
-
the record which defines all the values for the model
- getRecord() - Method in class org.brains2b.sql.meta.ParameterModel
-
the record which defines all the values for the model
- getRecord() - Method in class org.brains2b.sql.meta.ProcedureModel
-
the record which defines all the values for the model
- getRecord() - Method in interface org.brains2b.sql.meta.SQLMetaModel
-
the record which defines all the values for the model
- getRecord() - Method in class org.brains2b.sql.meta.TableModel
-
the record which defines all the values for the model
- getRecord() - Method in class org.brains2b.sql.meta.TypeModel
-
- getRemarks() - Method in class org.brains2b.sql.meta.ColumnModel
-
get optional remarks for a column
- getRemarks() - Method in class org.brains2b.sql.meta.TableModel
-
get optional remarks for this table
- getReturnValue() - Method in class org.brains2b.sql.meta.ProcedureModel
-
get the return value for this ProcedureModel
- getSchema() - Method in class org.brains2b.sql.meta.ProcedureModel
-
get the Schema for this ProcedureModel
- getSchema() - Method in class org.brains2b.sql.meta.TableModel
-
get the Schema for this TableModel
- getSchemas() - Method in class org.brains2b.sql.meta.SQLMetaData
-
get the schema names which can be retrieved for this database
- getSequence() - Method in class org.brains2b.sql.meta.ColumnModel
-
- getServerName() - Method in class org.brains2b.sql.LocalConnector
-
get the name of the server this connection uses.
- getSQLType(int, int, int) - Method in class org.brains2b.sql.meta.TypesInfo
-
- getString(String) - Method in class org.brains2b.sql.SQLRecord
-
- getString(int) - Method in class org.brains2b.sql.SQLRecord
-
- getTableName() - Method in class org.brains2b.sql.meta.ColumnModel
-
get the table name
- getTableName() - Method in class org.brains2b.sql.meta.ConstraintModel
-
get the table name for this Constraint
- getTableName() - Method in class org.brains2b.sql.meta.IndexModel
-
get the table for this index
- getTables(String, String, String) - Method in class org.brains2b.sql.meta.SQLMetaData
-
get a List of TableModel objects, without their columns
dependant on the parameters supplied.
- getTables(String, String, String, String) - Method in class org.brains2b.sql.meta.SQLMetaData
-
get a List of TableModel objects for a specific type, without their columns
dependant on the parameters supplied.
- getTables(String, String, String, String, boolean) - Method in class org.brains2b.sql.meta.SQLMetaData
-
get a List of TableModel objects for a specific type, without their columns
dependant on the parameters supplied.
- getTablesWithColumns(String, String, String) - Method in class org.brains2b.sql.meta.SQLMetaData
-
get a List of TableModel objects, including their columns
dependant on the parameters supplied.
- getTableTypes() - Method in class org.brains2b.sql.meta.SQLMetaData
-
get the table types supported by the database
- getType() - Method in class org.brains2b.sql.meta.ColumnModel
-
get the type of Object defined by the meta model
- getType() - Method in class org.brains2b.sql.meta.ConstraintModel
-
get the type of Object defined by the meta model
- getType() - Method in class org.brains2b.sql.meta.IndexModel
-
get the type of Object defined by the meta model
- getType() - Method in class org.brains2b.sql.meta.ParameterModel
-
get the type of Object defined by the meta model
- getType() - Method in class org.brains2b.sql.meta.ProcedureModel
-
get the type of Object defined by the meta model
- getType() - Method in interface org.brains2b.sql.meta.SQLMetaModel
-
get the type of Object defined by the meta model
- getType() - Method in class org.brains2b.sql.meta.TableModel
-
get the type of Object defined by the meta model
- getType() - Method in class org.brains2b.sql.meta.TypeModel
-
- getTypeInfo() - Method in class org.brains2b.sql.meta.SQLMetaData
-
get a Types2Java object for transforming types between
the database and Java
- getTypeModel(int, int, int) - Method in class org.brains2b.sql.meta.TypesInfo
-
- getTypeName() - Method in class org.brains2b.sql.meta.ColumnModel
-
get the type description for the column type
- getTypeNames() - Method in class org.brains2b.sql.meta.TypesInfo
-
- getTypes() - Method in class org.brains2b.sql.meta.TypesInfo
-
- getUnion() - Method in class org.brains2b.sql.meta.SelectDescriptor
-
- getURL() - Method in interface org.brains2b.sql.Connector
-
get the user which is connected to the database
- getURL() - Method in class org.brains2b.sql.LocalConnector
-
- getURL() - Method in class org.brains2b.sql.RemoteConnector
-
- getUser() - Method in interface org.brains2b.sql.Connector
-
get the user which is connected to the database
- getUser() - Method in class org.brains2b.sql.LocalConnector
-
Returns the name of the user this connection is using
- getUser() - Method in class org.brains2b.sql.RemoteConnector
-
get the user which is connected to the database
- getValue() - Method in class org.brains2b.sql.meta.ParameterModel
-
get the value for this parameter
- getValue(int) - Method in class org.brains2b.sql.SQLRecord
-
get the value of the column at the given index as an Object
- getValue(String) - Method in class org.brains2b.sql.SQLRecord
-
get the value of the column identified by name as an Object
- getWhere() - Method in class org.brains2b.sql.meta.SelectDescriptor
-
get the WHERE clause of this select statement
- SelectDescriptor - Class in org.brains2b.sql.meta
-
Describe a select statement in terms of the different keywords which
makes it up
- SelectDescriptor(String) - Constructor for class org.brains2b.sql.meta.SelectDescriptor
-
Create an SelectDescriptor on the basis of an select-statement
- SelectDescriptor.JoinDescriptor - Class in org.brains2b.sql.meta
-
- SelectDescriptor.Key - Enum in org.brains2b.sql.meta
-
All recognized Keys for a SELECT statement
- SelectFormatter - Class in org.brains2b.sql.meta
-
Formatter for SQL statements
- SelectFormatter() - Constructor for class org.brains2b.sql.meta.SelectFormatter
-
- setColumn(int, String) - Method in class org.brains2b.sql.SQLRecord
-
set a column identified by name at the specified position
- setColumn(int, String, Class, Object) - Method in class org.brains2b.sql.SQLRecord
-
convinience method to set the column name,class and value at once at a given index
- setColumn(int, String, Class) - Method in class org.brains2b.sql.SQLRecord
-
convenience method to set the column name,class and value at once at a given index
- setColumns(List) - Method in class org.brains2b.sql.meta.ConstraintModel
-
set the columns for this Model
- setColumns(List) - Method in class org.brains2b.sql.meta.IndexModel
-
set the columns for this Model
- setColumns(TableModel) - Method in class org.brains2b.sql.meta.SQLMetaData
-
set the columns for this table
- setColumns(List) - Method in class org.brains2b.sql.meta.TableModel
-
set the columns for this TableModel
- setColumnType(int, Class) - Method in class org.brains2b.sql.SQLRecord
-
set the Class identifying the type of content for this column
by index.
- setConnection(Connection) - Method in class org.brains2b.sql.meta.SQLMetaData
-
set the connection to the Database to
use for the MetaData
- setDataModel(int) - Method in class org.brains2b.sql.meta.TypesInfo
-
- setIndices(TableModel, boolean) - Method in class org.brains2b.sql.meta.SQLMetaData
-
set the Indexes for this table
- setIndices(List) - Method in class org.brains2b.sql.meta.TableModel
-
set the indices for this Model
- setParameters(List) - Method in class org.brains2b.sql.meta.ProcedureModel
-
set the parameters for this ProcedureModel
- setParameters(ProcedureModel) - Method in class org.brains2b.sql.meta.SQLMetaData
-
set the parameters for this procedure
- setPrimaryKey(TableModel) - Method in class org.brains2b.sql.meta.SQLMetaData
-
set the primary key belonging to a table
- setPrimaryKey(TableModel, boolean) - Method in class org.brains2b.sql.meta.SQLMetaData
-
set the primary key belonging to a table
- setPrimaryKey(TableModel, boolean, boolean) - Method in class org.brains2b.sql.meta.SQLMetaData
-
set the primary key belonging to a table
- setPrimaryKey(ConstraintModel) - Method in class org.brains2b.sql.meta.TableModel
-
set the primary key for this table
- setRecord(SQLRecord) - Method in class org.brains2b.sql.meta.ColumnModel
-
set the record for this Model
- setRecord(SQLRecord) - Method in class org.brains2b.sql.meta.ConstraintModel
-
set the record for this Model
- setRecord(SQLRecord) - Method in class org.brains2b.sql.meta.IndexModel
-
set the record for this Model
- setRecord(SQLRecord) - Method in class org.brains2b.sql.meta.TableModel
-
set the record for this Model
- setReturnValue(ParameterModel) - Method in class org.brains2b.sql.meta.ProcedureModel
-
set the return value for this ProcedureModel
- setValue(Object) - Method in class org.brains2b.sql.meta.ParameterModel
-
set the value for this parameter
- setValue(int, Object) - Method in class org.brains2b.sql.SQLRecord
-
set the content value for the specified index
- setValue(String, Object) - Method in class org.brains2b.sql.SQLRecord
-
set the content value for the column identified by name
- SMALLEST - Static variable in class org.brains2b.sql.meta.TypesInfo
-
- SQLHelper - Class in org.brains2b.sql
-
[Short description]
[Long description]
- SQLHelper() - Constructor for class org.brains2b.sql.SQLHelper
-
- SQLKeyWords - Class in org.brains2b.sql.meta
-
Class that implements one single static function isReserved
which checks if a String is a SQL reserved word.
- SQLMetaData - Class in org.brains2b.sql.meta
-
Main DatabaseMetaData class for describing database, table
and column properties on the basis of a supplied connection
- SQLMetaData() - Constructor for class org.brains2b.sql.meta.SQLMetaData
-
Default Constructor
- SQLMetaData(Connection) - Constructor for class org.brains2b.sql.meta.SQLMetaData
-
Constructor for SqlMetadata
- SQLMetaModel - Interface in org.brains2b.sql.meta
-
Interface that defines general information for the wrapper
of the database meta models on the basis of
SQLRecord
- SQLRecord - Class in org.brains2b.sql
-
Object for containing results from a Select statement
- SQLRecord() - Constructor for class org.brains2b.sql.SQLRecord
-
Constructor for SQLRecord.
- SQLRecord(int) - Constructor for class org.brains2b.sql.SQLRecord
-
Constructor for SQLRecord.
- Stream - Interface in org.brains2b.sql.meta.types
-
Simple interface that defines a data-type as stream and supplies
both an output as input stream for the datatype.
- stripQuotes(String) - Static method in class org.brains2b.sql.SQLHelper
-
strip quotes from the beginning and end of a String
from an SQL database
- supportsPseudoIdentifier() - Method in class org.brains2b.sql.meta.TypesInfo
-