B C D E G H M N P R S T U

B

buildStatement(PreparedStatement, Object[]) - Static method in class util.sql.PreparedStatementFactory
Given a prepared statment, set the given values in their corresponding statement indices.

C

closeConn(Connection) - Method in class util.sql.SQLProcessor
Close the connection, can handle null connections.
commitTransaction() - Method in class util.sql.SQLTransaction
Commit all queries and updates that are a part of this transaction.
ComplacentUpdateProcessor - class util.sql.ComplacentUpdateProcessor.
An update processor that doesn't care how many rows were updated.
ConnectionManager - class util.sql.ConnectionManager.
Class to retrieve database connections.
ConnectionManager() - Constructor for class util.sql.ConnectionManager
 

D

DatabaseConnectionException - exception util.sql.DatabaseConnectionException.
Exception thrown when a database connection cannot be established.
DatabaseConnectionException() - Constructor for class util.sql.DatabaseConnectionException
 
DatabaseConnectionException(String) - Constructor for class util.sql.DatabaseConnectionException
 
DatabaseQueryException - exception util.sql.DatabaseQueryException.
Exception thrown when an attempt to query the database fails.
DatabaseQueryException() - Constructor for class util.sql.DatabaseQueryException
 
DatabaseQueryException(String) - Constructor for class util.sql.DatabaseQueryException
 
DatabaseUpdateException - exception util.sql.DatabaseUpdateException.
Exception thrown when an attempt to update the database fails.
DatabaseUpdateException() - Constructor for class util.sql.DatabaseUpdateException
 
DatabaseUpdateException(String) - Constructor for class util.sql.DatabaseUpdateException
 

E

executeQuery(String, Object[], ResultProcessor) - Method in class util.sql.SQLProcessor
Start the execution of SQL query.
executeQuery(String, Object[], ResultProcessor) - Method in class util.sql.SQLTransaction
Execute a query as part of this transaction.
executeUpdate(String, Object[], UpdateProcessor) - Method in class util.sql.SQLProcessor
Execute an update and setup and destroy the connection associate with it.
executeUpdate(String, Object[], UpdateProcessor) - Method in class util.sql.SQLTransaction
Execute an update as part of this transaction.

G

getAllUsers() - Static method in class util.sql.test.TestClient
Get all users
getConnection() - Static method in class util.sql.ConnectionManager
Returns a connection to the database.
getEmail() - Method in class util.sql.test.User
 
getFieldType() - Method in class util.sql.NullSQLType
Get the sql type of the field.
getFirstName() - Method in class util.sql.test.User
 
getId() - Method in class util.sql.test.User
 
getInstance() - Static method in class util.sql.SQLProcessor
Get an instance of a SQLProcessor.
getInstance() - Static method in class util.sql.MandatoryUpdateProcessor
Get an instance of this update processor.
getInstance() - Static method in class util.sql.ComplacentUpdateProcessor
Get an instance of this update processor.
getInstance() - Static method in class util.sql.test.UserResultProcessor
Get an instance of this result processor.
getLastName() - Method in class util.sql.test.User
 
getUser(int) - Static method in class util.sql.test.TestClient
Get a user with the given user id.
getUserName() - Method in class util.sql.test.User
 

H

handleQuery(String, Object[], ResultProcessor, Connection) - Method in class util.sql.SQLProcessor
Method that handles the bulk of the query processing.
handleUpdate(String, Object[], UpdateProcessor, Connection) - Method in class util.sql.SQLProcessor
Method that handles the bulk of the update processing.

M

main(String[]) - Static method in class util.sql.test.TestClient
The test driver for the sql processor.
MandatoryUpdateProcessor - class util.sql.MandatoryUpdateProcessor.
An update processor that mandates that at least one row have been updated as part of the query.

N

NullSQLType - class util.sql.NullSQLType.
Class representing a null value in a prepared statement.
NullSQLType(int) - Constructor for class util.sql.NullSQLType
Default constructor.

P

PreparedStatementFactory - class util.sql.PreparedStatementFactory.
Class that builds prepared statements using only a connection and an array of objects.
PreparedStatementFactory() - Constructor for class util.sql.PreparedStatementFactory
 
process(int) - Method in interface util.sql.UpdateProcessor
Takes the number of rows that were updated as a result of a sql update and do whatever you want with it.
process(int) - Method in class util.sql.MandatoryUpdateProcessor
Takes the number of rows that were updated as a result of a sql update and do whatever you want with it.
process(int) - Method in class util.sql.ComplacentUpdateProcessor
Takes the number of rows that were updated as a result of a sql update and do whatever you want with it.
process(ResultSet) - Method in interface util.sql.ResultProcessor
Takes a result set and munges it into whatever type of object or set of objects it should be.
process(ResultSet) - Method in class util.sql.test.UserResultProcessor
Takes a result set and munges it into whatever type of object or set of objects it should be.

R

ResultProcessor - interface util.sql.ResultProcessor.
Representation of a result set processor.

S

SQLProcessor - class util.sql.SQLProcessor.
Main class for performing all SQL operations, querying, updating, transactions etc...
SQLTransaction - class util.sql.SQLTransaction.
A SQL transaction.
SQLTransaction(SQLProcessor) - Constructor for class util.sql.SQLTransaction
Default constructor.
startTransaction() - Method in class util.sql.SQLProcessor
Start a transaction.
startTransaction() - Method in class util.sql.SQLTransaction
Start a transaction.

T

TestClient - class util.sql.test.TestClient.
Test driver to test all functionality of the framework.
TestClient() - Constructor for class util.sql.test.TestClient
 
toString() - Method in class util.sql.NullSQLType
Get string representation of this object.
toString() - Method in class util.sql.test.User
For easy display purposes.

U

UpdateProcessor - interface util.sql.UpdateProcessor.
Representation of an update processor.
updateUser(User) - Static method in class util.sql.test.TestClient
Get all users
updateUsers(User[]) - Static method in class util.sql.test.TestClient
Update all these users.
User - class util.sql.test.User.
Test user class for dql framework demonstration purposes.
User(int, String, String, String, String) - Constructor for class util.sql.test.User
Default constructor.
UserResultProcessor - class util.sql.test.UserResultProcessor.
Result processor that will form User objects from the given result set.
util.sql - package util.sql
 
util.sql.test - package util.sql.test
 

B C D E G H M N P R S T U