Overview
Package
Class
Use
Tree
Deprecated
Index
Help
PREV NEXT
FRAMES
NO FRAMES
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
Overview
Package
Class
Use
Tree
Deprecated
Index
Help
PREV NEXT
FRAMES
NO FRAMES