Index (SQL 1.3.0 API)

A B C D E G H I L N O P R S T U V W
All Classes and Interfaces|All Packages|Constant Field Values|Serialized Form

A

abort() - Method in class com.blackrook.sql.SQLConnection.Transaction: Aborts this transaction and prevents further calls on it.
accept(SQLConnection) - Method in interface com.blackrook.sql.util.SQLConnectionConsumer: Accepts the connection, does something with it, and returns nothing.
accept(SQLConnection.Transaction) - Method in interface com.blackrook.sql.util.SQLTransactionConsumer: Accepts the transaction, does something with it, and returns nothing.
apply(SQLConnection) - Method in interface com.blackrook.sql.util.SQLConnectionFunction: Accepts the connection, does something with it, and returns a result.
apply(SQLConnection.Transaction) - Method in interface com.blackrook.sql.util.SQLTransactionFunction: Accepts the transaction, does something with it, and returns a result.

B

buildQuery(String) - Method in class com.blackrook.sql.SQLAbstractDAO: Creates a query builder that is pre-populated with a query fragment.

C

call(SQLConnectionFunction) - Method in class com.blackrook.sql.SQLAbstractDAO: Gets a connection and performs a function on it, returning the result.
callBatch(PreparedStatement, int, Object[][]) - Static method in class com.blackrook.sql.SQL: Performs a series of update queries on a single statement on a connection and returns the batch result.
callBatch(PreparedStatement, int, Collection) - Static method in class com.blackrook.sql.SQL: Performs a series of update queries on a single statement on a connection and returns the batch result.
callBatch(PreparedStatement, Object[][]) - Static method in class com.blackrook.sql.SQL: Performs a series of update queries on a single statement on a connection and returns the batch result, using a default batching amount (1024).
callBatch(PreparedStatement, Collection) - Static method in class com.blackrook.sql.SQL: Performs a series of update queries on a single statement on a connection and returns the batch result, using a default batching amount (1024).
callLargeBatch(PreparedStatement, int, Object[][]) - Static method in class com.blackrook.sql.SQL: Performs a series of update queries on a single statement on a connection and returns the batch result.
callLargeBatch(PreparedStatement, int, Collection) - Static method in class com.blackrook.sql.SQL: Performs a series of update queries on a single statement on a connection and returns the batch result.
callLargeBatch(PreparedStatement, Object[][]) - Static method in class com.blackrook.sql.SQL: Performs a series of update queries on a single statement on a connection and returns the batch result, using a default batching amount (1024).
callLargeBatch(PreparedStatement, Collection) - Static method in class com.blackrook.sql.SQL: Performs a series of update queries on a single statement on a connection and returns the batch result, using a default batching amount (1024).
callStatement(PreparedStatement, boolean, Object...) - Static method in class com.blackrook.sql.SQL: Performs a query on a connection and extracts the data into a SQLResult object.
close() - Method in class com.blackrook.sql.SQLConnection: Closes this connection.
close() - Method in class com.blackrook.sql.SQLConnection.Transaction: If this transaction is not finished, this aborts it.
close() - Method in class com.blackrook.sql.SQLPool: Closes all open connections in the pool.
column(String, SQLAbstractDAO.Operator, Object) - Static method in class com.blackrook.sql.SQLAbstractDAO: Creates a column operation criterion.
columnIn(String, Object...) - Static method in class com.blackrook.sql.SQLAbstractDAO: Creates a column "in" criterion.
columnIsNull(String) - Static method in class com.blackrook.sql.SQLAbstractDAO: Creates a null column criterion.
columnNames - Variable in class com.blackrook.sql.SQLResult: Query Columns.
columnNotIn(String, Object...) - Static method in class com.blackrook.sql.SQLAbstractDAO: Creates a column "not in" criterion.
com.blackrook.sql - package com.blackrook.sql: Contains classes relevant to querying SQL databases.
com.blackrook.sql.hints - package com.blackrook.sql.hints: Contains annotations for hinting at various uses of data types and fields concerning database operations.
com.blackrook.sql.struct - package com.blackrook.sql.struct: Additional helper data structures and methods.
com.blackrook.sql.util - package com.blackrook.sql.util: Contains Utility classes.
commit() - Method in class com.blackrook.sql.SQLConnection.Transaction: Commits the actions completed so far in this transaction.
complete() - Method in class com.blackrook.sql.SQLConnection.Transaction: Completes this transaction and prevents further calls on it.
construct(Constructor, Object...) - Static method in class com.blackrook.sql.struct.Utils: Creates a new instance of a class from a class type.
create(Class) - Static method in class com.blackrook.sql.struct.Utils: Creates a new instance of a class from a class type.
createObjectFromResultRow(Class, ResultSet) - Static method in class com.blackrook.sql.SQL: Creates a new object from the current result row and sets the fields on it using row information.
createObjectFromResultRow(Class, ResultSet, String[]) - Static method in class com.blackrook.sql.SQL: Creates a new object from the current result row and sets the fields on it using row information.
createObjectsFromResultSet(Class, ResultSet) - Static method in class com.blackrook.sql.SQL: Creates new objects from the result set and sets the fields on them using row information.

D

DataAccessFailureException(String) - Constructor for exception class com.blackrook.sql.SQLAbstractDAO.DataAccessFailureException: Creates a new exception.
DataAccessFailureException(String, Throwable) - Constructor for exception class com.blackrook.sql.SQLAbstractDAO.DataAccessFailureException: Creates a new exception.
DataAccessTimeoutException(String) - Constructor for exception class com.blackrook.sql.SQLAbstractDAO.DataAccessTimeoutException: Creates a new exception.
DataAccessTimeoutException(String, Throwable) - Constructor for exception class com.blackrook.sql.SQLAbstractDAO.DataAccessTimeoutException: Creates a new exception.
DEFAULT_BATCH_SIZE - Static variable in interface com.blackrook.sql.SQLCallable: Default batch size.

E

EQUAL - Enum constant in enum com.blackrook.sql.SQLAbstractDAO.Operator: Equals

G

getAllColumnNamesFromResultSet(ResultSet) - Static method in class com.blackrook.sql.SQL: Returns the names of the columns in a ResultSet in the order that they appear in the result.
getArrayDimensions(Class) - Static method in class com.blackrook.sql.struct.Utils: Gets how many dimensions that this array, represented by the provided type, has.
getArrayDimensions(Object) - Static method in class com.blackrook.sql.struct.Utils: Gets how many array dimensions that an object (presumably an array) has.
getArrayType(Class) - Static method in class com.blackrook.sql.struct.Utils: Gets the class type of this array type, if this is an array type.
getArrayType(Object) - Static method in class com.blackrook.sql.struct.Utils: Gets the class type of this array, if this is an array.
getAvailableConnection() - Method in class com.blackrook.sql.SQLPool: Retrieves an available connection from the pool.
getAvailableConnection(long) - Method in class com.blackrook.sql.SQLPool: Retrieves an available connection from the pool.
getAvailableConnectionCount() - Method in class com.blackrook.sql.SQLPool: Gets the number of available connections.
getBoolean(int) - Method in class com.blackrook.sql.SQLRow: Gets the boolean value of a column.
getBoolean(String) - Method in class com.blackrook.sql.SQLRow: Gets the boolean value of a column.
getByte(int) - Method in class com.blackrook.sql.SQLRow: Gets the byte value of a column.
getByte(String) - Method in class com.blackrook.sql.SQLRow: Gets the byte value of a column.
getByteArray(int) - Method in class com.blackrook.sql.SQLRow: Gets the byte array value of a column, if this can be represented as such (usually Blobs).
getByteArray(String) - Method in class com.blackrook.sql.SQLRow: Gets the byte array value of a column, if this can be represented as such (usually Blobs).
getColumnNames() - Method in class com.blackrook.sql.SQLResult: Gets the names of the columns.
getConnection() - Method in class com.blackrook.sql.SQLConnector: Returns a new, opened JDBC Connection using the credentials stored with this connector.
getConnectionAnd(long, SQLConnectionConsumer) - Method in class com.blackrook.sql.SQLPool: Retrieves a connection from this pool, passes it to the provided SQLConnectionConsumer function, calls it, then returns it to the pool.
getConnectionAnd(long, SQLConnectionFunction) - Method in class com.blackrook.sql.SQLPool: Retrieves a connection from this pool, passes it to the provided SQLConnectionFunction, calls it, returns it to the pool, and returns the result.
getConnectionAnd(SQLConnectionConsumer) - Method in class com.blackrook.sql.SQLConnector: Creates a connection, passes it to the provided SQLConnectionConsumer function, then closes it.
getConnectionAnd(SQLConnectionConsumer) - Method in class com.blackrook.sql.SQLPool: Retrieves a connection from this pool, passes it to the provided SQLConnectionConsumer function, then returns it to the pool.
getConnectionAnd(SQLConnectionFunction) - Method in class com.blackrook.sql.SQLConnector: Creates a connection, passes it to the provided SQLConnectionFunction, calls it, closes it, and returns the result.
getConnectionAnd(SQLConnectionFunction) - Method in class com.blackrook.sql.SQLPool: Retrieves a connection from this pool, passes it to the provided SQLConnectionFunction, calls it, returns it to the pool, and returns the result.
getDate(int) - Method in class com.blackrook.sql.SQLRow: Gets the Date value of the object, or null if not a Date.
getDate(String) - Method in class com.blackrook.sql.SQLRow: Gets the Date value of the object, or null if not a Date.
getDouble(int) - Method in class com.blackrook.sql.SQLRow: Gets the double value of a column.
getDouble(String) - Method in class com.blackrook.sql.SQLRow: Gets the double value of a column.
getEnumInstance(String, Class) - Static method in class com.blackrook.sql.struct.Utils: Returns the enum instance of a class given class and name, or null if not a valid name.
getFieldValue(Object, Field) - Static method in class com.blackrook.sql.struct.Utils: Gets the value of a field on an object.
getFloat(int) - Method in class com.blackrook.sql.SQLRow: Gets the float value of a column.
getFloat(String) - Method in class com.blackrook.sql.SQLRow: Gets the float value of a column.
getId() - Method in class com.blackrook.sql.SQLResult
getIds() - Method in class com.blackrook.sql.SQLResult
getInt(int) - Method in class com.blackrook.sql.SQLRow: Gets the integer value of a column.
getInt(String) - Method in class com.blackrook.sql.SQLRow: Gets the integer value of a column.
getJDBCURL() - Method in class com.blackrook.sql.SQLConnector: Returns the full JDBC URL for this specific connector.
getLong(int) - Method in class com.blackrook.sql.SQLRow: Gets the long value of a column.
getLong(String) - Method in class com.blackrook.sql.SQLRow: Gets the long value of a column.
getNull(int) - Method in class com.blackrook.sql.SQLRow: Gets if a column's value is null.
getNull(String) - Method in class com.blackrook.sql.SQLRow: Gets if a column's value is null.
getResult(Class, String, Object...) - Method in interface com.blackrook.sql.SQLCallable: Performs a query and creates objects from the resultant rows, setting relevant fields on them.
getResult(Class, String, Object...) - Method in class com.blackrook.sql.SQLConnection
getResult(Class, String, Object...) - Method in class com.blackrook.sql.SQLConnection.Transaction
getResult(String, Object...) - Method in interface com.blackrook.sql.SQLCallable: Performs a query that returns rows and extracts them into a result.
getResult(String, Object...) - Method in class com.blackrook.sql.SQLConnection
getResult(String, Object...) - Method in class com.blackrook.sql.SQLConnection.Transaction
getResult(Connection, Class, String, Object...) - Static method in class com.blackrook.sql.SQL: Performs a query on a connection and creates objects from it, setting relevant fields.
getResult(Connection, String, Object...) - Static method in class com.blackrook.sql.SQL: Performs a query on a connection and extracts the data into a SQLResult.
getRow() - Method in class com.blackrook.sql.SQLResult: Gets the first row, or only row in this result, or null if no rows.
getRow(Class, String, Object...) - Method in interface com.blackrook.sql.SQLCallable: Performs a query and creates an object from it from the first result row extracted, setting relevant fields.
getRow(Class, String, Object...) - Method in class com.blackrook.sql.SQLConnection
getRow(Class, String, Object...) - Method in class com.blackrook.sql.SQLConnection.Transaction
getRow(String, Object...) - Method in interface com.blackrook.sql.SQLCallable: Performs a query and extracts the first row result into a single SQLRow.
getRow(String, Object...) - Method in class com.blackrook.sql.SQLConnection
getRow(String, Object...) - Method in class com.blackrook.sql.SQLConnection.Transaction
getRow(Connection, Class, String, Object...) - Static method in class com.blackrook.sql.SQL: Performs a query on a connection and creates an object from it from the first row, setting relevant fields.
getRow(Connection, String, Object...) - Static method in class com.blackrook.sql.SQL: Performs a query on a connection and extracts the data into a single SQLRow.
getRowCount() - Method in class com.blackrook.sql.SQLResult: Gets the amount of affected/returned rows from this query.
getRows() - Method in class com.blackrook.sql.SQLResult: Retrieves the rows from the query result.
getShort(int) - Method in class com.blackrook.sql.SQLRow: Gets the short value of a column.
getShort(String) - Method in class com.blackrook.sql.SQLRow: Gets the short value of a column.
getSQLException() - Method in exception class com.blackrook.sql.util.SQLRuntimeException
getString(int) - Method in class com.blackrook.sql.SQLRow: Gets the string value of a column.
getString(String) - Method in class com.blackrook.sql.SQLRow: Gets the string value of a column.
getTimestamp(int) - Method in class com.blackrook.sql.SQLRow: Gets the Timestamp value of the object, or null if not a Timestamp or Date.
getTimestamp(String) - Method in class com.blackrook.sql.SQLRow: Gets the Timestamp value of the object, or null if not a Timestamp or Date.
getTotalConnectionCount() - Method in class com.blackrook.sql.SQLPool: Gets the number of total connections.
getTransaction(Connection, SQLConnection.TransactionLevel) - Static method in class com.blackrook.sql.SQL: Starts a transaction with a provided level.
getTransactionAnd(Connection, SQLConnection.TransactionLevel, SQLTransactionConsumer) - Static method in class com.blackrook.sql.SQL: Starts a transaction with a provided level, performs actions on it, then auto-closes it.
getTransactionAnd(Connection, SQLConnection.TransactionLevel, SQLTransactionFunction) - Static method in class com.blackrook.sql.SQL: Starts a transaction with a provided level, performs actions on it, returns a value, then auto-closes it.
getUpdateBatch(String, int, Object[][]) - Method in interface com.blackrook.sql.SQLCallable: Performs a series of update queries on a single statement on a connection and returns the batch result.
getUpdateBatch(String, int, Collection) - Method in interface com.blackrook.sql.SQLCallable: Performs a series of update queries on a single statement on a connection and returns the batch result.
getUpdateBatch(String, int, Collection) - Method in class com.blackrook.sql.SQLConnection
getUpdateBatch(String, int, Collection) - Method in class com.blackrook.sql.SQLConnection.Transaction
getUpdateBatch(String, Object[][]) - Method in interface com.blackrook.sql.SQLCallable: Performs a series of update queries on a single statement on a connection and returns the batch result.
getUpdateBatch(String, Collection) - Method in interface com.blackrook.sql.SQLCallable: Performs a series of update queries on a single statement on a connection and returns the batch result.
getUpdateBatch(Connection, String, int, Object[][]) - Static method in class com.blackrook.sql.SQL: Performs a series of update queries on a single statement on a connection and returns the batch result.
getUpdateBatch(Connection, String, int, Collection) - Static method in class com.blackrook.sql.SQL: Performs a series of update queries on a single statement on a connection and returns the batch result.
getUpdateBatch(Connection, String, Object[][]) - Static method in class com.blackrook.sql.SQL: Performs a series of update queries on a single statement on a connection and returns the batch result.
getUpdateBatch(Connection, String, Collection) - Static method in class com.blackrook.sql.SQL: Performs a series of update queries on a single statement on a connection and returns the batch result.
getUpdateBatchResult(String, Object[][]) - Method in interface com.blackrook.sql.SQLCallable: Performs an update query (INSERT, DELETE, UPDATE, or other commands that do not return rows) and extracts each set of result data into a SQLResult.
getUpdateBatchResult(String, Collection) - Method in interface com.blackrook.sql.SQLCallable: Performs an update query (INSERT, DELETE, UPDATE, or other commands that do not return rows) and extracts each set of result data into a SQLResult.
getUpdateBatchResult(String, Collection) - Method in class com.blackrook.sql.SQLConnection
getUpdateBatchResult(String, Collection) - Method in class com.blackrook.sql.SQLConnection.Transaction
getUpdateBatchResult(Connection, String, Object[][]) - Static method in class com.blackrook.sql.SQL: Performs an update query (INSERT, DELETE, UPDATE, or other commands that do not return rows) and extracts each set of result data into a SQLResult.
getUpdateBatchResult(Connection, String, Collection) - Static method in class com.blackrook.sql.SQL: Performs an update query (INSERT, DELETE, UPDATE, or other commands that do not return rows) and extracts each set of result data into a SQLResult.
getUpdateLargeBatch(String, int, Object[][]) - Method in interface com.blackrook.sql.SQLCallable: Performs a series of update queries on a single statement on a connection and returns the batch result.
getUpdateLargeBatch(String, int, Collection) - Method in interface com.blackrook.sql.SQLCallable: Performs a series of update queries on a single statement on a connection and returns the batch result.
getUpdateLargeBatch(String, int, Collection) - Method in class com.blackrook.sql.SQLConnection
getUpdateLargeBatch(String, int, Collection) - Method in class com.blackrook.sql.SQLConnection.Transaction
getUpdateLargeBatch(String, Object[][]) - Method in interface com.blackrook.sql.SQLCallable: Performs a series of update queries on a single statement on a connection and returns the batch result.
getUpdateLargeBatch(String, Collection) - Method in interface com.blackrook.sql.SQLCallable: Performs a series of update queries on a single statement on a connection and returns the batch result.
getUpdateLargeBatch(Connection, String, int, Object[][]) - Static method in class com.blackrook.sql.SQL: Performs a series of update queries on a single statement on a connection and returns the batch result.
getUpdateLargeBatch(Connection, String, int, Collection) - Static method in class com.blackrook.sql.SQL: Performs a series of update queries on a single statement on a connection and returns the batch result.
getUpdateLargeBatch(Connection, String, Object[][]) - Static method in class com.blackrook.sql.SQL: Performs a series of update queries on a single statement on a connection and returns the batch result.
getUpdateLargeBatch(Connection, String, Collection) - Static method in class com.blackrook.sql.SQL: Performs a series of update queries on a single statement on a connection and returns the batch result.
getUpdateResult(String, Object...) - Method in interface com.blackrook.sql.SQLCallable: Performs an update query (INSERT, DELETE, UPDATE, or other commands that do not return rows) and extracts the data/affected data/generated data into a SQLResult.
getUpdateResult(String, Object...) - Method in class com.blackrook.sql.SQLConnection
getUpdateResult(String, Object...) - Method in class com.blackrook.sql.SQLConnection.Transaction
getUpdateResult(Connection, String, Object...) - Static method in class com.blackrook.sql.SQL: Performs an update query (INSERT, DELETE, UPDATE, or other commands that do not return rows) on a connection and extracts the data/affected data/generated data into a SQLResult.
getUsedConnectionCount() - Method in class com.blackrook.sql.SQLPool: Gets the number of connections in use.
GREATER - Enum constant in enum com.blackrook.sql.SQLAbstractDAO.Operator: Greater Than
GREATER_EQUAL - Enum constant in enum com.blackrook.sql.SQLAbstractDAO.Operator: Greater Than or Equal

H

hasNext() - Method in class com.blackrook.sql.SQLResult.SQLResultIterator

I

id(SQLConnectionFunction) - Method in class com.blackrook.sql.SQLAbstractDAO: Gets a connection and performs a function on it, and if the affected row count is 1, return the id.
ids(SQLConnectionFunction) - Method in class com.blackrook.sql.SQLAbstractDAO: Gets a connection and performs a function on it, and returns the generated ids.
inTransaction() - Method in class com.blackrook.sql.SQLConnection
invokeBlind(Method, Object, Object...) - Static method in class com.blackrook.sql.struct.Utils: Blindly invokes a method, only throwing a RuntimeException if something goes wrong.
isArray(Class) - Static method in class com.blackrook.sql.struct.Utils: Tests if a class is actually an array type.
isArray(Object) - Static method in class com.blackrook.sql.struct.Utils: Tests if an object is actually an array type.
isClosed() - Method in class com.blackrook.sql.SQLConnection
isEmpty(Object) - Static method in class com.blackrook.sql.struct.Utils: Checks if a value is "empty."
isFinished() - Method in class com.blackrook.sql.SQLConnection.Transaction
isNull(T, T) - Static method in class com.blackrook.sql.struct.Utils: Returns the first object if it is not null, otherwise returns the second.
isUpdate() - Method in class com.blackrook.sql.SQLResult
iterator() - Method in class com.blackrook.sql.SQLResult

L

LESS - Enum constant in enum com.blackrook.sql.SQLAbstractDAO.Operator: Less Than
LESS_EQUAL - Enum constant in enum com.blackrook.sql.SQLAbstractDAO.Operator: Less Than or Equal
LIKE - Enum constant in enum com.blackrook.sql.SQLAbstractDAO.Operator: Like clause
limit(int) - Method in class com.blackrook.sql.SQLAbstractDAO.QueryStringBuilder: Adds "limit" criteria.

N

next() - Method in class com.blackrook.sql.SQLResult.SQLResultIterator
nextId - Variable in class com.blackrook.sql.SQLResult: Next id, if generated.
NOT_EQUAL - Enum constant in enum com.blackrook.sql.SQLAbstractDAO.Operator: Not Equals
NOT_LIKE - Enum constant in enum com.blackrook.sql.SQLAbstractDAO.Operator: Not like clause

O

offset(int) - Method in class com.blackrook.sql.SQLAbstractDAO.QueryStringBuilder: Adds "offset" criteria.
orderBy(Function, SQLAbstractDAO.Ordering...) - Method in class com.blackrook.sql.SQLAbstractDAO.QueryStringBuilder: Adds "order by" criteria.

P

parameters(SQLAbstractDAO.Criterion...) - Static method in class com.blackrook.sql.SQLAbstractDAO: Extracts the values from a set of criteria (to be used as parameters).
parseBoolean(String) - Static method in class com.blackrook.sql.struct.Utils: Attempts to parse a boolean from a string.
parseBoolean(String, boolean) - Static method in class com.blackrook.sql.struct.Utils: Attempts to parse a boolean from a string.
parseByte(String) - Static method in class com.blackrook.sql.struct.Utils: Attempts to parse a byte from a string.
parseByte(String, byte) - Static method in class com.blackrook.sql.struct.Utils: Attempts to parse a byte from a string.
parseChar(String) - Static method in class com.blackrook.sql.struct.Utils: Attempts to parse a char from a string.
parseChar(String, char) - Static method in class com.blackrook.sql.struct.Utils: Attempts to parse a byte from a string.
parseDouble(String) - Static method in class com.blackrook.sql.struct.Utils: Attempts to parse a double from a string.
parseDouble(String, double) - Static method in class com.blackrook.sql.struct.Utils: Attempts to parse a double from a string.
parseFloat(String) - Static method in class com.blackrook.sql.struct.Utils: Attempts to parse a float from a string.
parseFloat(String, float) - Static method in class com.blackrook.sql.struct.Utils: Attempts to parse a float from a string.
parseInt(String) - Static method in class com.blackrook.sql.struct.Utils: Attempts to parse an int from a string.
parseInt(String, int) - Static method in class com.blackrook.sql.struct.Utils: Attempts to parse an int from a string.
parseLong(String) - Static method in class com.blackrook.sql.struct.Utils: Attempts to parse a long from a string.
parseLong(String, long) - Static method in class com.blackrook.sql.struct.Utils: Attempts to parse a long from a string.
parseShort(String) - Static method in class com.blackrook.sql.struct.Utils: Attempts to parse a short from a string.
parseShort(String, short) - Static method in class com.blackrook.sql.struct.Utils: Attempts to parse a short from a string.

R

READ_COMMITTED - Enum constant in enum com.blackrook.sql.SQLConnection.TransactionLevel: From Connection: A constant indicating that dirty reads are prevented; non-repeatable reads and phantom reads can occur.
READ_UNCOMMITTED - Enum constant in enum com.blackrook.sql.SQLConnection.TransactionLevel: From Connection: A constant indicating that dirty reads, non-repeatable reads and phantom reads can occur.
releaseConnection(SQLConnection) - Method in class com.blackrook.sql.SQLPool: Releases a connection back to the pool.
REPEATABLE_READ - Enum constant in enum com.blackrook.sql.SQLConnection.TransactionLevel: From Connection: A constant indicating that dirty reads and non-repeatable reads are prevented; phantom reads can occur.
reset() - Method in class com.blackrook.sql.SQLResult.SQLResultIterator: Resets the iterator to the beginning.
rollback() - Method in class com.blackrook.sql.SQLConnection.Transaction: Rolls back this entire transaction.
rollback(Savepoint) - Method in class com.blackrook.sql.SQLConnection.Transaction: Rolls back this transaction to a Savepoint.
rowCount - Variable in class com.blackrook.sql.SQLResult: Rows affected or returned in the query.
rowCount(SQLConnectionFunction) - Method in class com.blackrook.sql.SQLAbstractDAO: Gets a connection and performs a function on it, returning the altered row count.
rows - Variable in class com.blackrook.sql.SQLResult: List of rows of associative data.

S

SERIALIZABLE - Enum constant in enum com.blackrook.sql.SQLConnection.TransactionLevel: From Connection: A constant indicating that dirty reads, non-repeatable reads and phantom reads are prevented.
setAcquireTimeout(long) - Method in class com.blackrook.sql.SQLAbstractDAO: Sets this DAO's connection acquisition timeout.
setFieldValue(Object, Field, Object) - Static method in class com.blackrook.sql.struct.Utils: Sets the value of a field on an object.
setSavepoint() - Method in class com.blackrook.sql.SQLConnection.Transaction: Calls Connection.setSavepoint() on the encapsulated connection.
setSavepoint(String) - Method in class com.blackrook.sql.SQLConnection.Transaction: Calls Connection.setSavepoint() on the encapsulated connection.
SQL - Class in com.blackrook.sql: Core database utilities object.
SQLAbstractDAO - Class in com.blackrook.sql: Abstract DAO class.
SQLAbstractDAO(SQLPool) - Constructor for class com.blackrook.sql.SQLAbstractDAO: Creates this DAO attached to the provided pool, no connection acquisition timeout.
SQLAbstractDAO(SQLPool, long) - Constructor for class com.blackrook.sql.SQLAbstractDAO: Creates this DAO attached to the provided pool, no connection acquisition timeout.
SQLAbstractDAO.Criterion - Class in com.blackrook.sql: A single criterion.
SQLAbstractDAO.DataAccessFailureException - Exception Class in com.blackrook.sql: Exception thrown when a Data Access Object fails at storage or retrieval unexpectedly.
SQLAbstractDAO.DataAccessTimeoutException - Exception Class in com.blackrook.sql: Exception thrown when a Data Access Object fails at storage or retrieval unexpectedly.
SQLAbstractDAO.Operator - Enum in com.blackrook.sql: A criterion operator.
SQLAbstractDAO.Ordering - Class in com.blackrook.sql: A single ordering criterion.
SQLAbstractDAO.QueryStringBuilder - Class in com.blackrook.sql: Query string builder.
SQLCallable - Interface in com.blackrook.sql: The interface used for all SQL connections that can have queries performed through them.
SQLConnection - Class in com.blackrook.sql: A wrapped SQL connection for ease-of-querying.
SQLConnection.Transaction - Class in com.blackrook.sql: A transaction object that holds a connection that guarantees an isolation level of some kind.
SQLConnection.TransactionLevel - Enum in com.blackrook.sql: Enumeration of transaction levels.
SQLConnectionConsumer - Interface in com.blackrook.sql.util: A special consumer that takes a SQLConnection, but throws SQLExceptions.
SQLConnectionFunction<R> - Interface in com.blackrook.sql.util: A special consumer that takes a SQLConnection, but throws SQLExceptions.
SQLConnector - Class in com.blackrook.sql: Core database JDBC connector object.
SQLConnector(String, String) - Constructor for class com.blackrook.sql.SQLConnector: Constructs a new database connector.
SQLConnector(String, String, String, String) - Constructor for class com.blackrook.sql.SQLConnector: Constructs a new database connector.
SQLConnector(String, String, Properties) - Constructor for class com.blackrook.sql.SQLConnector: Constructs a new database connector.
SQLIgnore - Annotation Type in com.blackrook.sql.hints: Placing this annotation on public fields or getter/setter methods on POJOs hints at this field not being included in the resulting collection/table.
SQLName - Annotation Type in com.blackrook.sql.hints: Placing this annotation on public fields or getter/setter methods on POJOs hints that this field uses a different field or column name in a collection or table.
SQLPool - Class in com.blackrook.sql: This is a database connection pool class for a bunch of shared, managed connections.
SQLPool(SQLConnector, int) - Constructor for class com.blackrook.sql.SQLPool: Creates a new connection pool from a SQLConnector.
SQLResult - Class in com.blackrook.sql: The data encapsulation of the result of a query ResultSet.
SQLResult.SQLResultIterator - Class in com.blackrook.sql: The iterator returned to iterate through this result.
SQLResultIterator() - Constructor for class com.blackrook.sql.SQLResult.SQLResultIterator
SQLRow - Class in com.blackrook.sql: SQLRow object.
SQLRuntimeException - Exception Class in com.blackrook.sql.util: An exception thrown to wrap a SQLException.
SQLRuntimeException(IOException) - Constructor for exception class com.blackrook.sql.util.SQLRuntimeException: Creates a new SQLRuntimeException from an IOException.
SQLRuntimeException(String, IOException) - Constructor for exception class com.blackrook.sql.util.SQLRuntimeException: Creates a new SQLRuntimeException from an IOException.
SQLRuntimeException(String, SQLException) - Constructor for exception class com.blackrook.sql.util.SQLRuntimeException: Creates a new SQLRuntimeException from a SQLException.
SQLRuntimeException(SQLException) - Constructor for exception class com.blackrook.sql.util.SQLRuntimeException: Creates a new SQLRuntimeException from a SQLException.
SQLTransactionConsumer - Interface in com.blackrook.sql.util: A special consumer that takes a SQLTransaction, but throws SQLExceptions.
SQLTransactionFunction<R> - Interface in com.blackrook.sql.util: A special consumer that takes a SQLTransaction, but throws SQLExceptions.
startTransaction(SQLConnection.TransactionLevel) - Method in class com.blackrook.sql.SQLConnection: Starts a transaction with a provided level.
startTransactionAnd(SQLConnection.TransactionLevel, SQLTransactionConsumer) - Method in class com.blackrook.sql.SQLConnection: Starts a transaction with a provided level, performs actions on it, then auto-closes it.
startTransactionAnd(SQLConnection.TransactionLevel, SQLTransactionFunction) - Method in class com.blackrook.sql.SQLConnection: Starts a transaction with a provided level, performs actions on it, returns a value, then auto-closes it.

T

toString() - Method in enum com.blackrook.sql.SQLAbstractDAO.Operator
toString() - Method in class com.blackrook.sql.SQLAbstractDAO.QueryStringBuilder
transaction(SQLConnection.TransactionLevel, SQLTransactionFunction) - Method in class com.blackrook.sql.SQLAbstractDAO: Gets a connection and performs a function on it, returning the result.

U

update - Variable in class com.blackrook.sql.SQLResult: Was this an update query?
updated(SQLConnectionFunction) - Method in class com.blackrook.sql.SQLAbstractDAO: Gets a connection and performs a function on it, and if the affected row count is 1, return true.
Utils - Class in com.blackrook.sql.struct: A utility class.
Utils() - Constructor for class com.blackrook.sql.struct.Utils

V

value() - Element in annotation type com.blackrook.sql.hints.SQLName: Specifies the column/field name.
value(SQLConnectionFunction, Function) - Method in class com.blackrook.sql.SQLAbstractDAO: Lifts a single value from a queried SQLRow and returns it, returning null if the row is null.
valueCaseInsenstiveMap(SQLConnectionFunction, BiConsumer) - Method in class com.blackrook.sql.SQLAbstractDAO: Lifts a map of values from a queried SQLResult and returns it as an immutable map of case-insensitive string key to value.
valueList(SQLConnectionFunction, Function) - Method in class com.blackrook.sql.SQLAbstractDAO: Lifts a list of single values from a queried SQLResult and returns it as an immutable list.
valueMap(SQLConnectionFunction, BiConsumer) - Method in class com.blackrook.sql.SQLAbstractDAO: Lifts a map of values from a queried SQLResult and returns it as an immutable map of key to value.
valueOf(String) - Static method in enum com.blackrook.sql.SQLAbstractDAO.Operator: Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum com.blackrook.sql.SQLConnection.TransactionLevel: Returns the enum constant of this type with the specified name.
values() - Static method in enum com.blackrook.sql.SQLAbstractDAO.Operator: Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum com.blackrook.sql.SQLConnection.TransactionLevel: Returns an array containing the constants of this enum type, in the order they are declared.
valueSet(SQLConnectionFunction, Function) - Method in class com.blackrook.sql.SQLAbstractDAO: Lifts a list of single values from a queried SQLResult and returns it as an immutable set of unique values.
valueSortedMap(SQLConnectionFunction, BiConsumer) - Method in class com.blackrook.sql.SQLAbstractDAO: Lifts a sorted map of values from a queried SQLResult and returns it as an immutable map of key to value.
valueSortedSet(SQLConnectionFunction, Function) - Method in class com.blackrook.sql.SQLAbstractDAO: Lifts a list of single values from a queried SQLResult and returns it as an immutable sorted set of unique values.

W

where(Function, SQLAbstractDAO.Criterion...) - Method in class com.blackrook.sql.SQLAbstractDAO.QueryStringBuilder: Adds "where" criteria.

A B C D E G H I L N O P R S T U V W
All Classes and Interfaces|All Packages|Constant Field Values|Serialized Form