A C D E F G L M N O P S T V

A

about - Static variable in class org.enableit.db.DBUtils
Information on the exact CVS version accessible after compilation
about - Static variable in class org.enableit.db.DatabaseProxy
CVS info about this class and its current version
about - Static variable in class org.enableit.db.GenericDBProxy
Information on the exact CVS version accessible after compilation
about - Static variable in class org.enableit.db.DataLoader
CVS info about this class and its current version
about - Static variable in class org.enableit.db.DBFilter
CVS info about this class and its current version
about - Static variable in class org.enableit.db.ConnectionFactory
Information on the exact CVS version accessible after compilation
about - Static variable in class org.enableit.db.DataSourceProxy
CVS info about this class and its current version
about - Static variable in class org.enableit.db.Column
CVS info about this class and its current version
about - Static variable in class org.enableit.db.ant.DataLoaderTask
CVS info about this class and its current version
addFileset(FileSet) - Method in class org.enableit.db.ant.DataLoaderTask
Adds a set of files (nested fileset attribute).
addFilter(String, DBFilter) - Static method in class org.enableit.db.DBUtils
Adds a 'where' or 'and' clause as appropriate to join on the supplied column and value
addFilter(String, String, String) - Static method in class org.enableit.db.DBUtils
Adds a 'where' or 'and' clause as appropriate to join on the supplied column and value
addFilters(String, List) - Static method in class org.enableit.db.DBUtils
Adds a 'where' or 'and' clause as appropriate to join on the supplied column and value

C

cat - Static variable in class org.enableit.db.DBUtils
The Log4J Category doing the logging.
cat - Static variable in class org.enableit.db.DatabaseProxy
The Log4J Category doing the logging.
cat - Static variable in class org.enableit.db.GenericDBProxy
The Log4J Category doing the logging.
cat - Static variable in class org.enableit.db.DataLoader
The Log4J Category doing the logging.
cat - Static variable in class org.enableit.db.ConnectionFactory
The Log4J Category doing the logging.
cat - Static variable in class org.enableit.db.DataSourceProxy
The Log4J Category doing the logging.
Column - class org.enableit.db.Column.
Represent a database column.
Column() - Constructor for class org.enableit.db.Column
Default Constructor
Column(String) - Constructor for class org.enableit.db.Column
Constructor that sets the column's name.
Column(String, String) - Constructor for class org.enableit.db.Column
Constructor that sets the column's name and datatype.
columns - Variable in class org.enableit.db.DataLoader
The columns to load into.
conn - Variable in class org.enableit.db.test.DatabaseProxyTest
Connection used to perform the tests
ConnectionFactory - class org.enableit.db.ConnectionFactory.
General class intended to hide the process of obtaining database connections to any database
ConnectionFactory() - Constructor for class org.enableit.db.ConnectionFactory
Default Constructor
convertHashMapToArrayList(HashMap) - Static method in class org.enableit.db.DBUtils
Converts a set of name-value pairs stored in a java.util.HashMap to values only stored in a java.util.ArrayList
convertHashtableToArrayList(Hashtable) - Static method in class org.enableit.db.DBUtils
Converts a set of name-value pairs stored in a java.util.Hashtable to values only stored in a java.util.ArrayList
convertResultToList(ResultSet) - Static method in class org.enableit.db.DBUtils
Turns a ResultSet into an ArrayList of TreeMaps

D

DatabaseProxy - class org.enableit.db.DatabaseProxy.
Proxy class to wrap database access in a simple form.
DatabaseProxy() - Constructor for class org.enableit.db.DatabaseProxy
 
DatabaseProxyTest - class org.enableit.db.test.DatabaseProxyTest.
A test class to exercise the DatabaseProxy
DatabaseProxyTest(String) - Constructor for class org.enableit.db.test.DatabaseProxyTest
 
DataLoader - class org.enableit.db.DataLoader.
A class to read CSV files and load data into a database.
DataLoader() - Constructor for class org.enableit.db.DataLoader
Default Constructor
DataLoader(String) - Constructor for class org.enableit.db.DataLoader
Constructor setting mandatory properties.
DataLoaderTask - class org.enableit.db.ant.DataLoaderTask.
A task to invoke the DataLoader class for a FileSet.
DataLoaderTask() - Constructor for class org.enableit.db.ant.DataLoaderTask
Default Constructor
dataSourceName - Variable in class org.enableit.db.DataLoader
The datasource name to use to get a database connection.
DataSourceProxy - class org.enableit.db.DataSourceProxy.
Proxy class to wrap database access in a simple form.
DataSourceProxy() - Constructor for class org.enableit.db.DataSourceProxy
 
datatype - Variable in class org.enableit.db.Column
The column datatype.
DBException - exception org.enableit.db.DBException.
General exception for use by this library's classes when communicating exceptions.
DBException() - Constructor for class org.enableit.db.DBException
DBException Method
DBException(String) - Constructor for class org.enableit.db.DBException
DBException Method
DBFilter - class org.enableit.db.DBFilter.
Provides an encapsulated means to extend a SQL statement's WHERE clause
DBFilter() - Constructor for class org.enableit.db.DBFilter
Default Constructor
DBFilter(String, String) - Constructor for class org.enableit.db.DBFilter
Convenience Constructor setting name and value as object created
DBFilter(String, String, int) - Constructor for class org.enableit.db.DBFilter
Convenience constructor setting name, value and match as object created
DBUtils - class org.enableit.db.DBUtils.
Provides utilities to be used in conjunction with the database proxies.
DBUtils() - Constructor for class org.enableit.db.DBUtils
Default Constructor

E

encode(String) - Static method in class org.enableit.db.SqlEncoder
Encodes characters as escape sequences to prevent errors when passed to a SQL statement Actual chars requiring encoding are: ', newline, \,
EXACT_MATCH - Static variable in class org.enableit.db.DBFilter
A valid match type
execute() - Method in class org.enableit.db.DataLoader
Do the load.
execute() - Method in class org.enableit.db.ant.DataLoaderTask
Performs the copy operation.
executeDmlProcedure(Connection, String, List) - Static method in class org.enableit.db.DatabaseProxy
Execute the supplied stored procedure against the supplied database connection.
executeDmlProcedure(String, ArrayList) - Static method in class org.enableit.db.GenericDBProxy
Execute the supplied stored procedure against a database connection supplied from ConnectionFactory.
executeDmlProcedure(String, String, List) - Static method in class org.enableit.db.DataSourceProxy
Execute the supplied update procedure against a connection obtained from the named DataSource.
executeQuery() - Method in class org.enableit.db.test.DatabaseProxyTest
 
executeQuery(Connection, String) - Static method in class org.enableit.db.DatabaseProxy
Execute the supplied SQL query against the supplied database connection.
executeQuery(Connection, String, int) - Static method in class org.enableit.db.DatabaseProxy
Deprecated. 
use executeQuery(conn:Connection, sql:String):java.util.ArrayList instead
executeQuery(String, int) - Static method in class org.enableit.db.GenericDBProxy
Execute the supplied SQL query against a database connection supplied from ConnectionFactory.
executeQuery(String, String) - Static method in class org.enableit.db.DataSourceProxy
Execute the supplied SQL query against a connection obtained from the named DataSource.
executeQueryProcedure(Connection, String, List, int) - Static method in class org.enableit.db.DatabaseProxy
Execute the supplied stored procedure against the supplied database connection.
executeQueryProcedure(String, List, int) - Static method in class org.enableit.db.GenericDBProxy
Execute the supplied stored procedure against a database connection supplied from ConnectionFactory.
executeQueryProcedure(String, String, List) - Static method in class org.enableit.db.DataSourceProxy
Execute the supplied query procedure against a connection obtained from the named DataSource.
executeUpdate(Connection, String) - Static method in class org.enableit.db.DatabaseProxy
Execute the supplied SQL update query against a the supplied database connection.
executeUpdate(Connection, String, List) - Static method in class org.enableit.db.DatabaseProxy
Execute the supplied SQL update query against a the supplied database connection.
executeUpdate(String) - Static method in class org.enableit.db.GenericDBProxy
Execute the supplied SQL update query against a database connection supplied from ConnectionFactory.
executeUpdate(String, String) - Static method in class org.enableit.db.DataSourceProxy
Execute the supplied SQL update against a the supplied database connection.
executeUpdate(String, String, List) - Static method in class org.enableit.db.DataSourceProxy
Execute the supplied SQL update against a connection obtained from the named DataSource.

F

file - Variable in class org.enableit.db.DataLoader
The file to read.
filesets - Variable in class org.enableit.db.ant.DataLoaderTask
The fileset.

G

GenericDBProxy - class org.enableit.db.GenericDBProxy.
Proxy class to wrap any java application database access in a simple form
GenericDBProxy() - Constructor for class org.enableit.db.GenericDBProxy
 
getConnection() - Static method in class org.enableit.db.ConnectionFactory
Returns a connection to the database identified by the class's resource properties
getConnection(Properties) - Static method in class org.enableit.db.ConnectionFactory
Returns a connection to the database identified by the Properties supplied
getConnection(String) - Static method in class org.enableit.db.DataSourceProxy
Get a connection from the named DataSource.
getConnection(String, String, String, String, String, String, String) - Static method in class org.enableit.db.ConnectionFactory
Returns a connection to the database identified by the supplied properties
getDatatype() - Method in class org.enableit.db.Column
Return the column's name.
getInstance() - Static method in class org.enableit.db.ConnectionFactory
Factory method
getMatch() - Method in class org.enableit.db.DBFilter
Return a string representaion of the match
getMatchType() - Method in class org.enableit.db.DBFilter
Returns the type of match required as an int
getMySQLConnection(Properties) - Static method in class org.enableit.db.ConnectionFactory
 
getName() - Method in class org.enableit.db.DBFilter
Returns the column to filter on
getName() - Method in class org.enableit.db.Column
Return the column's name.
getNextId(String, boolean) - Static method in class org.enableit.db.DBUtils
Returns the next available id for the specified table
getNextIdUsingSQL(String) - Static method in class org.enableit.db.DBUtils
Returns the next available id for the specified table
getSybConnection(Properties) - Static method in class org.enableit.db.ConnectionFactory
 
getValue() - Method in class org.enableit.db.DBFilter
Returns the value of column to filter on
GREATER_THAN_MATCH - Static variable in class org.enableit.db.DBFilter
A valid match type

L

LESS_THAN_MATCH - Static variable in class org.enableit.db.DBFilter
A valid match type
LIST - Static variable in class org.enableit.db.DatabaseProxy
Valid Object type for result set returns

M

main(String[]) - Static method in class org.enableit.db.DataLoader
Used as a simple test of the class.
match - Variable in class org.enableit.db.DBFilter
The type of match required
me - Static variable in class org.enableit.db.ConnectionFactory
Reference to the singleton instance NB the singleton status is not enforced via a synchronise statement

N

name - Variable in class org.enableit.db.DBFilter
The column to filter on
name - Variable in class org.enableit.db.Column
The column name.

O

org.enableit.db - package org.enableit.db
 
org.enableit.db.ant - package org.enableit.db.ant
 
org.enableit.db.test - package org.enableit.db.test
 

P

PROC_GET_NEXT_ID - Static variable in class org.enableit.db.DBUtils
Name of stored procedure used for getNextId
process(String) - Method in class org.enableit.db.DataLoader
Processes a data line.
processComment(String) - Method in class org.enableit.db.DataLoader
Processes a comment line, looking for meta data.
props - Static variable in class org.enableit.db.ConnectionFactory
The current database properties to make connections with

S

setColumnDatatypes(String) - Method in class org.enableit.db.DataLoader
Set the datatypes of the columns to be inserted into.
setColumnNames(String) - Method in class org.enableit.db.DataLoader
Set the names of columns to be inserted into.
setDataSourceName(String) - Method in class org.enableit.db.DataLoader
Set the datasource name to get connections from.
setDatatype(String) - Method in class org.enableit.db.Column
Set the column's datatype.
setFile(File) - Method in class org.enableit.db.DataLoader
Set the file to be loaded.
setFile(String) - Method in class org.enableit.db.DataLoader
Set the file to be loaded.
setMatch(int) - Method in class org.enableit.db.DBFilter
The type of match required
setName(String) - Method in class org.enableit.db.DBFilter
The column to filter on
setProperty(String, String) - Static method in class org.enableit.db.ConnectionFactory
Set a connection property dynamically
setTable(String) - Method in class org.enableit.db.DataLoader
Set the file to be loaded.
setUp() - Method in class org.enableit.db.test.DatabaseProxyTest
The method provided for by the JUnit framework in order that common setup tasks are completed before tests run
setValue(String) - Method in class org.enableit.db.DBFilter
The value of column to filter on
SQL_GET_NEXT_ID - Static variable in class org.enableit.db.DBUtils
Dynamic SQL used for getNextId
SQL_INIT_ID - Static variable in class org.enableit.db.DBUtils
Dynamic SQL used for getNextId, initialises the table if no previous query
SQL_RESULT_SET - Static variable in class org.enableit.db.DatabaseProxy
Valid Object type for result set returns.
SQL_SET_NEXT_ID - Static variable in class org.enableit.db.DBUtils
Dynamic SQL used for getNextIdUsingSQL to update the id to the next one
SqlEncoder - class org.enableit.db.SqlEncoder.
Ensure special characters are escaped before issuing SQL statements.
SqlEncoder() - Constructor for class org.enableit.db.SqlEncoder
Default Constructor
suite() - Static method in class org.enableit.db.test.DatabaseProxyTest
Invoke the tests

T

table - Variable in class org.enableit.db.DataLoader
The Table to load into.
tearDown() - Method in class org.enableit.db.test.DatabaseProxyTest
The method provided for by the JUnit framework in order that common setup tasks are cleaned up after tests are run
toString() - Method in class org.enableit.db.DBFilter
Returns a string representation of the filter

V

value - Variable in class org.enableit.db.DBFilter
The value of column to filter on

A C D E F G L M N O P S T V

Copyright © enableIT.org 1999,2000,2001,2002 All Rights Reserved.