Skip navigation links
A C D E F G H I J L N O P R S T U V 

A

AbstractHiLoIdGenerator - Class in org.clazzes.util.sql.dao
A Hi-Lo ID generator, which generates IDs in block with a configurable bock size.
AbstractHiLoIdGenerator() - Constructor for class org.clazzes.util.sql.dao.AbstractHiLoIdGenerator
 
AbstrBasicDAO<T> - Class in org.clazzes.util.sql.dao
A basic DAO support class for entities without a simple foreign key.
AbstrBasicDAO(String, String...) - Constructor for class org.clazzes.util.sql.dao.AbstrBasicDAO
 
AbstrIdDAO<T> - Class in org.clazzes.util.sql.dao
DAO framework class covering basic database-operations.
AbstrIdDAO(Class<T>, String, String, String...) - Constructor for class org.clazzes.util.sql.dao.AbstrIdDAO
Default Constructor.
and(SQLFragment, SQLFragment) - Static method in class org.clazzes.util.sql.criteria.SQLCondition
 
and(SQLFragment...) - Static method in class org.clazzes.util.sql.criteria.SQLCondition
 
AppendListEntityConsumer<T> - Class in org.clazzes.util.sql.dao
An entity consumer, which appends rthe received entites to a list.
AppendListEntityConsumer(List<T>) - Constructor for class org.clazzes.util.sql.dao.AppendListEntityConsumer
 

C

close() - Method in class org.clazzes.util.sql.helper.JDBCTransaction
Roll back the transaction.
columnList(String, String...) - Static method in class org.clazzes.util.sql.criteria.SQLValue
Convenience method to create a list of SQLValues representing columns from one table
columnNameList(SQLValue[], boolean) - Method in class org.clazzes.util.sql.SQLStatementGenerator
Generates a list of column names from the given String array in the appropriate dialect.
commaParenthesis(SQLFragment...) - Static method in class org.clazzes.util.sql.criteria.SQLConstruct
 
commaSeperated(SQLFragment...) - Static method in class org.clazzes.util.sql.criteria.SQLConstruct
 
commit() - Method in class org.clazzes.util.sql.helper.JDBCTransaction
Commit the transaction.
consumeEntity(T) - Method in class org.clazzes.util.sql.dao.AppendListEntityConsumer
 
consumeEntity(T) - Method in interface org.clazzes.util.sql.dao.IEntityConsumer
Process the next entity received as part of a result set.

D

DEFAULT_ID_TABLE_NAME - Static variable in class org.clazzes.util.sql.dao.AbstractHiLoIdGenerator
 
DEFAULT_NEXT_ID_COL_NAME - Static variable in class org.clazzes.util.sql.dao.AbstractHiLoIdGenerator
 
delete(Serializable) - Method in class org.clazzes.util.sql.dao.AbstrIdDAO
Remove DTO for the given id.
delete(Serializable) - Method in interface org.clazzes.util.sql.dao.IIdDAO
 
delete(String, SQLCondition) - Method in class org.clazzes.util.sql.SQLStatementGenerator
Generates a DELETE statement for a given SQLDialect as follows:

DELETE FROM tableName [WHERE condition]
deleteBatch(Collection<? extends Serializable>) - Method in class org.clazzes.util.sql.dao.AbstrIdDAO
 
deleteBatch(Collection<? extends Serializable>) - Method in interface org.clazzes.util.sql.dao.IIdDAO
 
deleteWithCondition(SQLCondition, StatementPreparer) - Method in class org.clazzes.util.sql.dao.AbstrBasicDAO
Delete all POJOs, matching the given SQLCondition, prepared with the given StatementPreparer.
doLock() - Method in interface org.clazzes.util.sql.ha.IHaLockManager
 
doLock() - Method in class org.clazzes.util.sql.ha.SqlHaLockManager
 
dropConnection() - Method in class org.clazzes.util.sql.helper.JDBCTransaction
 

E

eq(SQLFragment, SQLFragment) - Static method in class org.clazzes.util.sql.criteria.SQLCondition
 

F

fetchAndLock(JDBCTransaction) - Method in class org.clazzes.util.sql.ha.SqlHaLockManager
 
fetchConnection(DataSource) - Static method in class org.clazzes.util.sql.helper.JDBCTransaction
 
fetchNextId(Statement) - Method in class org.clazzes.util.sql.dao.AbstractHiLoIdGenerator
 
fillDtoFromResultSet(ResultSet) - Method in class org.clazzes.util.sql.dao.AbstrBasicDAO
Convenience method to fill in a POJO from a ResultSet which was obtained from the database.
fillInsertValues(PreparedStatement) - Method in interface org.clazzes.util.sql.dao.StatementPreparer
Given a statement, this method fills the placeholders of that statement.
fillPreparedStatementFromDto(PreparedStatement, T) - Method in class org.clazzes.util.sql.dao.AbstrBasicDAO
Convenience method to set the values from a POJO to a PreparedStatement.
forFragment(SQLFragment, SQLOrder.OrderDirection) - Static method in class org.clazzes.util.sql.criteria.SQLOrder
 
formatIsolationLevel(int) - Static method in class org.clazzes.util.sql.helper.JDBCHelper
Format the transaction isolation level constants as a string.
forTableColumn(String, String, SQLOrder.OrderDirection) - Static method in class org.clazzes.util.sql.criteria.SQLOrder
 

G

generateNext() - Method in class org.clazzes.util.sql.dao.AbstractHiLoIdGenerator
 
generateNext() - Method in interface org.clazzes.util.sql.dao.IdGenerator
 
generateUID() - Method in class org.clazzes.util.sql.dao.AbstrIdDAO
Convenience method which generates a unique Id for this object.
get(Serializable) - Method in class org.clazzes.util.sql.dao.AbstrIdDAO
Get an Object for the given id or null if no such DTO exists.
get(Serializable) - Method in interface org.clazzes.util.sql.dao.IIdDAO
 
getAll() - Method in class org.clazzes.util.sql.dao.AbstrBasicDAO
Returns POJOs for all tuples in this.getTableName().
getAll() - Method in interface org.clazzes.util.sql.dao.IBasicDAO
 
getBaseId() - Method in class org.clazzes.util.sql.dao.AbstractHiLoIdGenerator
Returns the current base id, to which the lo value is added.
getBaseId() - Method in class org.clazzes.util.sql.dao.HibernateHiLoIdGenerator
 
getBaseId() - Method in class org.clazzes.util.sql.dao.HiLoIdGenerator
 
getBatch(Serializable...) - Method in class org.clazzes.util.sql.dao.AbstrIdDAO
Returns a List containing all DTOs for the given ids.
getBatch(Collection<? extends Serializable>) - Method in class org.clazzes.util.sql.dao.AbstrIdDAO
Returns a List containing all Objects for the given ids.
getBatch(Serializable...) - Method in interface org.clazzes.util.sql.dao.IIdDAO
Returns a List containing all DTOs for the given ids.
getBatch(Collection<? extends Serializable>) - Method in interface org.clazzes.util.sql.dao.IIdDAO
Returns a List containing all DTOs for the given ids.
getBlockSize() - Method in class org.clazzes.util.sql.dao.AbstractHiLoIdGenerator
 
getBoolean(ResultSet, int) - Static method in class org.clazzes.util.sql.helper.JDBCHelper
 
getBoolean(ResultSet, String) - Static method in class org.clazzes.util.sql.helper.JDBCHelper
 
getByte(ResultSet, int) - Static method in class org.clazzes.util.sql.helper.JDBCHelper
 
getByte(ResultSet, String) - Static method in class org.clazzes.util.sql.helper.JDBCHelper
 
getColumnCount() - Method in class org.clazzes.util.sql.dao.AbstrBasicDAO
 
getColumnName(int) - Method in class org.clazzes.util.sql.dao.AbstrBasicDAO
Get the table column name with in dex i.
getColumnNames() - Method in class org.clazzes.util.sql.dao.AbstrBasicDAO
 
getConnection() - Method in class org.clazzes.util.sql.helper.JDBCTransaction
 
getConnectionThreadLocalKey() - Method in class org.clazzes.util.sql.ha.SqlHaLockManager
 
getDataSource() - Method in class org.clazzes.util.sql.dao.AbstractHiLoIdGenerator
 
getDataSource() - Method in class org.clazzes.util.sql.ha.SqlHaLockManager
 
getDialect() - Method in class org.clazzes.util.sql.SQLStatementGenerator
 
getDouble(ResultSet, int) - Static method in class org.clazzes.util.sql.helper.JDBCHelper
 
getDouble(ResultSet, String) - Static method in class org.clazzes.util.sql.helper.JDBCHelper
 
getEntityClass() - Method in class org.clazzes.util.sql.dao.AbstrIdDAO
 
getEnum(ResultSet, int, Class<T>) - Static method in class org.clazzes.util.sql.helper.JDBCHelper
Fetch an enum value from an integer column of a result set interpreted as the ordinal of the given enum class.
getFloat(ResultSet, int) - Static method in class org.clazzes.util.sql.helper.JDBCHelper
 
getFloat(ResultSet, String) - Static method in class org.clazzes.util.sql.helper.JDBCHelper
 
getGenerator() - Method in class org.clazzes.util.sql.dao.AbstrBasicDAO
 
getHaLockManager() - Method in class org.clazzes.util.sql.ha.HaLockInterceptor
 
getHiStepSize() - Method in class org.clazzes.util.sql.dao.AbstractHiLoIdGenerator
Returns the step size, by which the hi value (as stored in the database) is incremented when a new block has to be started.
getHiStepSize() - Method in class org.clazzes.util.sql.dao.HibernateHiLoIdGenerator
 
getHiStepSize() - Method in class org.clazzes.util.sql.dao.HiLoIdGenerator
 
getHiValue() - Method in class org.clazzes.util.sql.dao.AbstractHiLoIdGenerator
Getter to the hi value as stored in the corresponding database table, in order to make it available for test cases.
getI18nString(ResultSet, int) - Static method in class org.clazzes.util.sql.helper.JDBCHelper
Returns an I18nString based on the value for the given column in the given ResultSet (which is expected to be a string).
getId(T) - Method in class org.clazzes.util.sql.dao.AbstrIdDAO
 
getId(DTO) - Method in interface org.clazzes.util.sql.dao.IIdDAO
 
getIdClass() - Method in class org.clazzes.util.sql.dao.AbstrIdDAO
 
getIdClass() - Method in interface org.clazzes.util.sql.dao.IIdDAO
 
getIdGenerator() - Method in class org.clazzes.util.sql.dao.AbstrIdDAO
 
getIdTableName() - Method in class org.clazzes.util.sql.dao.AbstractHiLoIdGenerator
 
getInitialHiValue() - Method in class org.clazzes.util.sql.dao.AbstractHiLoIdGenerator
Returns the very first hi value the generator writes into the database (if none was written before).
getInitialHiValue() - Method in class org.clazzes.util.sql.dao.HibernateHiLoIdGenerator
 
getInitialHiValue() - Method in class org.clazzes.util.sql.dao.HiLoIdGenerator
 
getInt(ResultSet, int) - Static method in class org.clazzes.util.sql.helper.JDBCHelper
 
getInt(ResultSet, String) - Static method in class org.clazzes.util.sql.helper.JDBCHelper
 
getLastLockTime() - Method in interface org.clazzes.util.sql.ha.IHaLock
 
getLastNodeName() - Method in interface org.clazzes.util.sql.ha.IHaLock
 
getLastUnlockTime() - Method in interface org.clazzes.util.sql.ha.IHaLock
 
getList() - Method in class org.clazzes.util.sql.dao.AppendListEntityConsumer
 
getListSize(SQLCondition, StatementPreparer) - Method in class org.clazzes.util.sql.dao.AbstrBasicDAO
Detects the number of POJOs that match would be returned by getList().
getListWithCondition(SQLCondition, StatementPreparer) - Method in class org.clazzes.util.sql.dao.AbstrBasicDAO
Returns a list of POJOs, matching the given SQLCondition, prepared with the given StatementPreparer.
getLockTime() - Method in interface org.clazzes.util.sql.ha.IHaLock
 
getLong(ResultSet, int) - Static method in class org.clazzes.util.sql.helper.JDBCHelper
 
getLong(ResultSet, String) - Static method in class org.clazzes.util.sql.helper.JDBCHelper
 
getNextIdColumnName() - Method in class org.clazzes.util.sql.dao.AbstractHiLoIdGenerator
 
getNodeName() - Method in interface org.clazzes.util.sql.ha.IHaLock
 
getNodeName() - Method in interface org.clazzes.util.sql.ha.IHaLockManager
 
getNodeName() - Method in class org.clazzes.util.sql.ha.SqlHaLockManager
 
getPkColumn() - Method in class org.clazzes.util.sql.dao.AbstrIdDAO
 
getShort(ResultSet, int) - Static method in class org.clazzes.util.sql.helper.JDBCHelper
 
getShort(ResultSet, String) - Static method in class org.clazzes.util.sql.helper.JDBCHelper
 
getSQLValueForId(Serializable) - Method in class org.clazzes.util.sql.dao.AbstrIdDAO
 
getSubList(SQLCondition, StatementPreparer, SQLOrder[], int, int) - Method in class org.clazzes.util.sql.dao.AbstrBasicDAO
Returns a list of POJOs, matching the given SQLCondition, prepared with the given StatementPreparer.
getSubSystem() - Method in interface org.clazzes.util.sql.ha.IHaLock
 
getSubSystem() - Method in interface org.clazzes.util.sql.ha.IHaLockManager
 
getSubSystem() - Method in class org.clazzes.util.sql.ha.SqlHaLockManager
 
getTableName() - Method in class org.clazzes.util.sql.dao.AbstrBasicDAO
 
getTableName() - Method in class org.clazzes.util.sql.ha.SqlHaLockManager
 
getThreadLocalKey() - Method in class org.clazzes.util.sql.ha.HaLockInterceptor
 
getUniqueWithCondition(SQLCondition, StatementPreparer) - Method in class org.clazzes.util.sql.dao.AbstrBasicDAO
Returns a POJO, matching the given SQLCondition, prepared with the given StatementPreparer.
getUtcSeconds(ResultSet, int) - Static method in class org.clazzes.util.sql.helper.JDBCHelper
Helper function for the case, that utc seconds are stored in Java code in an attribute of type Double, and mapped to a database column of type e.g. date, datetime or timestamp.
gt(SQLFragment, SQLFragment) - Static method in class org.clazzes.util.sql.criteria.SQLCondition
 
gtEquals(SQLFragment, SQLFragment) - Static method in class org.clazzes.util.sql.criteria.SQLCondition
 

H

HaLockInterceptor - Class in org.clazzes.util.sql.ha
An interceptor locking on a given IHaLockManger instance.
HaLockInterceptor() - Constructor for class org.clazzes.util.sql.ha.HaLockInterceptor
 
HibernateHiLoIdGenerator - Class in org.clazzes.util.sql.dao
 
HibernateHiLoIdGenerator() - Constructor for class org.clazzes.util.sql.dao.HibernateHiLoIdGenerator
 
HiLoIdGenerator - Class in org.clazzes.util.sql.dao
 
HiLoIdGenerator() - Constructor for class org.clazzes.util.sql.dao.HiLoIdGenerator
 

I

IBasicDAO<DTO> - Interface in org.clazzes.util.sql.dao
A basic DAO for entities, which do not have a simple primary key.
IdGenerator - Interface in org.clazzes.util.sql.dao
A thread-safe generator for IDs of type Long.
IEntityConsumer<T> - Interface in org.clazzes.util.sql.dao
A callback, which receives objects during the traversal of an SQL result set.
IHaLock - Interface in org.clazzes.util.sql.ha
A concurrent lock across multiple HA node.
IHaLockManager - Interface in org.clazzes.util.sql.ha
A H/A lock manager for cross-node locks.
IIdDAO<DTO> - Interface in org.clazzes.util.sql.dao
A DAO interface for entities identified by IDs.
in(SQLFragment, SQLFragment) - Static method in class org.clazzes.util.sql.criteria.SQLCondition
 
initialize() - Method in class org.clazzes.util.sql.dao.AbstractHiLoIdGenerator
An initialization function, which check the database table for a single row with the next high value.
initialize() - Method in class org.clazzes.util.sql.ha.SqlHaLockManager
Initialize this lock manager after setting all configuration properties.
innerJoin(String, String, SQLCondition, SQLCondition, SQLValue[]) - Method in class org.clazzes.util.sql.SQLStatementGenerator
Generates a SELECT/INNER JOIN statement for a given SQLDialect as follows:

SELECT columnList FROM tableName1 INNER JOIN tableName2 ON joinCondition [WHERE queryCondition]

Whereby columnList is replaced by the wildcard character '*' if it is null
insert(String, SQLValue[]) - Method in class org.clazzes.util.sql.SQLStatementGenerator
Generates a INSERT statement for the given SQLDialect as follows:

INSERT INTO tableName (columnName[0], columnName[1], ... columnName[n]) VALUES (?
INSERT_VALUE - Static variable in class org.clazzes.util.sql.criteria.SQLValue
 
integerValue(long) - Static method in class org.clazzes.util.sql.criteria.SQLValue
Creates a SQLValue representing a long constant.
invoke(MethodInvocation) - Method in class org.clazzes.util.sql.ha.HaLockInterceptor
 
isI18nMapString(String) - Static method in class org.clazzes.util.sql.helper.JDBCHelper
Returns wether the given String is a valid I18nString serialization, something like {"de" : "Deutsche Übersetzung", "en" : "English translation" }.
isNull(SQLFragment) - Static method in class org.clazzes.util.sql.criteria.SQLCondition
 
isOpen() - Method in class org.clazzes.util.sql.helper.JDBCTransaction
 

J

JDBCHelper - Class in org.clazzes.util.sql.helper
Static helper functions for Number object binding/fetching from JDBC result sets and prepared statements.
JDBCHelper() - Constructor for class org.clazzes.util.sql.helper.JDBCHelper
 
JDBCTransaction - Class in org.clazzes.util.sql.helper
An auto-closeable transaction, which imposes a given isolation level for usage with java7's try-with-resources
JDBCTransaction(DataSource) - Constructor for class org.clazzes.util.sql.helper.JDBCTransaction
Pull a connection from the given datasource and open a transaction with the default isolation level of the datasource.
JDBCTransaction(DataSource, int) - Constructor for class org.clazzes.util.sql.helper.JDBCTransaction
Pull a connection from the given datasource and open a transaction with the given isolation level.
JDBCTransaction(Connection) - Constructor for class org.clazzes.util.sql.helper.JDBCTransaction
Open a transaction on the given connection using the default isolation level of the connection.
JDBCTransaction(Connection, int) - Constructor for class org.clazzes.util.sql.helper.JDBCTransaction
Open a transaction on the given connection using the given isolation level.

L

like(SQLFragment, SQLFragment) - Static method in class org.clazzes.util.sql.criteria.SQLCondition
 
lt(SQLFragment, SQLFragment) - Static method in class org.clazzes.util.sql.criteria.SQLCondition
 
ltEquals(SQLFragment, SQLFragment) - Static method in class org.clazzes.util.sql.criteria.SQLCondition
 

N

notEq(SQLFragment, SQLFragment) - Static method in class org.clazzes.util.sql.criteria.SQLCondition
 
notLike(SQLFragment, SQLFragment) - Static method in class org.clazzes.util.sql.criteria.SQLCondition
 
notNull(SQLFragment) - Static method in class org.clazzes.util.sql.criteria.SQLCondition
 

O

openTransaction() - Method in class org.clazzes.util.sql.ha.SqlHaLockManager
 
or(SQLFragment, SQLFragment) - Static method in class org.clazzes.util.sql.criteria.SQLCondition
 
or(SQLFragment...) - Static method in class org.clazzes.util.sql.criteria.SQLCondition
 
org.clazzes.util.sql - package org.clazzes.util.sql
Utility package providing a simple framework to create SQL statements for various dialects.
org.clazzes.util.sql.criteria - package org.clazzes.util.sql.criteria
 
org.clazzes.util.sql.dao - package org.clazzes.util.sql.dao
 
org.clazzes.util.sql.ha - package org.clazzes.util.sql.ha
 
org.clazzes.util.sql.helper - package org.clazzes.util.sql.helper
 

P

parenthesis(SQLFragment...) - Static method in class org.clazzes.util.sql.criteria.SQLConstruct
 
parseI18nString(String) - Static method in class org.clazzes.util.sql.helper.JDBCHelper
Parses the given databaseString as I18nString.
placeholderList(int) - Method in class org.clazzes.util.sql.SQLStatementGenerator
Generates a list of PreparedStatement placeholders ('?')

R

rollback() - Method in class org.clazzes.util.sql.helper.JDBCTransaction
runInSerializableTransaction(JdbcStatementAction<Long>) - Method in class org.clazzes.util.sql.dao.AbstractHiLoIdGenerator
 

S

save(T) - Method in class org.clazzes.util.sql.dao.AbstrBasicDAO
 
save(T) - Method in class org.clazzes.util.sql.dao.AbstrIdDAO
 
save(DTO) - Method in interface org.clazzes.util.sql.dao.IBasicDAO
Save the given DTO an generate a new ID.
saveBatch(List<T>) - Method in class org.clazzes.util.sql.dao.AbstrBasicDAO
 
saveBatch(List<T>) - Method in class org.clazzes.util.sql.dao.AbstrIdDAO
 
saveBatch(List<DTO>) - Method in interface org.clazzes.util.sql.dao.IBasicDAO
Save the given list of DTOs in a database batch and generate new IDs for them.
select(String, SQLValue[], SQLCondition) - Method in class org.clazzes.util.sql.SQLStatementGenerator
Generates a SELECT statement for the given SQLDialect as follows:

For columnNames == null:

SELECT * FROM tableName [WHERE condition]

For columnNames !
select(String, SQLValue[], SQLCondition, SQLOrder[]) - Method in class org.clazzes.util.sql.SQLStatementGenerator
Generates a SELECT statement for the given SQLDialect as follows:

For columnNames == null:

SELECT * FROM tableName [WHERE condition]

For columnNames !
selectDistinct(String, SQLValue[], SQLCondition) - Method in class org.clazzes.util.sql.SQLStatementGenerator
Generates a SELECT DISTINCT statement for the given SQLDialect as follows:

For columnNames == null:

SELECT DISTINCT * FROM tableName [WHERE condition]

For columnNames !
selectDistinct(String, SQLValue[], SQLCondition, SQLOrder[]) - Method in class org.clazzes.util.sql.SQLStatementGenerator
Generates a SELECT DISTINCT statement for the given SQLDialect as follows:

For columnNames == null:

SELECT DISTINCT * FROM tableName [WHERE condition]

For columnNames !
setBlockSize(long) - Method in class org.clazzes.util.sql.dao.AbstractHiLoIdGenerator
 
setBoolean(PreparedStatement, int, Boolean) - Static method in class org.clazzes.util.sql.helper.JDBCHelper
Call ps.setBoolean(parameterIndex,b.booleanValue()) or ps.setNull(parameterIndex,Types.BOOLEAN) when b is null.
setByte(PreparedStatement, int, Number) - Static method in class org.clazzes.util.sql.helper.JDBCHelper
Call ps.setByte(parameterIndex,b.byteValue()) or ps.setNull(parameterIndex,Types.TINYINT) when b is null.
setConnectionThreadLocalKey(String) - Method in class org.clazzes.util.sql.ha.SqlHaLockManager
 
setDataSource(DataSource) - Method in class org.clazzes.util.sql.dao.AbstractHiLoIdGenerator
 
setDataSource(DataSource) - Method in class org.clazzes.util.sql.ha.SqlHaLockManager
Set the configured data source.
setDouble(PreparedStatement, int, Number) - Static method in class org.clazzes.util.sql.helper.JDBCHelper
Call ps.setDouble(parameterIndex,d.doubleValue()) or ps.setNull(parameterIndex,Types.DOUBLE) when b is null.
setEnum(PreparedStatement, int, T) - Static method in class org.clazzes.util.sql.helper.JDBCHelper
Set an enum value as an integer parameter to a prepared statement using the ordinal of an enum value.
setFloat(PreparedStatement, int, Number) - Static method in class org.clazzes.util.sql.helper.JDBCHelper
Call ps.setFloat(parameterIndex,f.floatValue()) or ps.setNull(parameterIndex,Types.FLOAT) when b is null.
setGenerator(SQLStatementGenerator) - Method in class org.clazzes.util.sql.dao.AbstrBasicDAO
 
setHaLockManager(IHaLockManager) - Method in class org.clazzes.util.sql.ha.HaLockInterceptor
 
setI18nString(PreparedStatement, int, I18nString) - Static method in class org.clazzes.util.sql.helper.JDBCHelper
 
setIdGenerator(IdGenerator) - Method in class org.clazzes.util.sql.dao.AbstrIdDAO
 
setIdOnStatement(PreparedStatement, int, Object) - Method in class org.clazzes.util.sql.dao.AbstrIdDAO
 
setIdProvided(boolean) - Method in class org.clazzes.util.sql.dao.AbstrIdDAO
 
setIdTableName(String) - Method in class org.clazzes.util.sql.dao.AbstractHiLoIdGenerator
 
setInt(PreparedStatement, int, Number) - Static method in class org.clazzes.util.sql.helper.JDBCHelper
Call ps.setInt(parameterIndex,i.intValue()) or ps.setNull(parameterIndex,Types.INTEGER) when b is null.
setLong(PreparedStatement, int, Number) - Static method in class org.clazzes.util.sql.helper.JDBCHelper
Call ps.setLong(parameterIndex,l.longValue()) or ps.setNull(parameterIndex,Types.BIGINT) when b is null.
setNextIdColumnName(String) - Method in class org.clazzes.util.sql.dao.AbstractHiLoIdGenerator
 
setNodeName(String) - Method in class org.clazzes.util.sql.ha.SqlHaLockManager
Set the node name to report to the locking DB table.
setShort(PreparedStatement, int, Number) - Static method in class org.clazzes.util.sql.helper.JDBCHelper
Call ps.setShort(parameterIndex,s.shortValue()) or ps.setNull(parameterIndex,Types.SMALLINT) when b is null.
setSubSystem(String) - Method in class org.clazzes.util.sql.ha.SqlHaLockManager
 
setTableName(String) - Method in class org.clazzes.util.sql.ha.SqlHaLockManager
Set the name of the DB table used for locking.
setThreadLocalKey(String) - Method in class org.clazzes.util.sql.ha.HaLockInterceptor
 
setUtcSeconds(PreparedStatement, int, Double) - Static method in class org.clazzes.util.sql.helper.JDBCHelper
Helper function for the case, that utc seconds are stored in Java code in an attribute of type Double, and mapped to a database column of type e.g. date, datetime or timestamp.
SQLCondition - Class in org.clazzes.util.sql.criteria
A convenience class for wrapping condition testing for sql statement generation
SQLCondition(SQLCondition.OperationType, SQLFragment, SQLFragment) - Constructor for class org.clazzes.util.sql.criteria.SQLCondition
 
SQLConstruct - Class in org.clazzes.util.sql.criteria
A convenience class to aid the creation of complex sql statements by wrapping SQLFragments
SQLConstruct(SQLConstruct.ConstructType, SQLConstruct.LinkType, SQLFragment...) - Constructor for class org.clazzes.util.sql.criteria.SQLConstruct
 
SQLConstruct.ConstructType - Enum in org.clazzes.util.sql.criteria
 
SQLConstruct.LinkType - Enum in org.clazzes.util.sql.criteria
 
SQLDialect - Enum in org.clazzes.util.sql
List of supported SQL dialects, for cases in which specific statements should/could be used for optimisation.
SQLFragment - Interface in org.clazzes.util.sql
Interface for classes describing sql conditions and other fragments of statements as dialect-independent objects
SqlHaLockManager - Class in org.clazzes.util.sql.ha
A lock manager operating on a database table with the structure SUBSYSTEM VARCHAR(40) NOT NULL PRIMARY KEY, NODE_NAME VARCHAR(40) NOT NULL, LOCK_TIME BIGINT NOT NULL, UNLOCK_TIME BIGINT NOT NULL, STATUS INT NOT NULL
SqlHaLockManager() - Constructor for class org.clazzes.util.sql.ha.SqlHaLockManager
Create a new lock manage instance.
SQLOrder - Class in org.clazzes.util.sql.criteria
 
SQLOrder(SQLFragment, SQLOrder.OrderDirection) - Constructor for class org.clazzes.util.sql.criteria.SQLOrder
 
SQLOrder.OrderDirection - Enum in org.clazzes.util.sql.criteria
 
SQLStatementGenerator - Class in org.clazzes.util.sql
A generator for simple SQL-statements, providing support for different SQL-dialects.
SQLStatementGenerator(SQLDialect) - Constructor for class org.clazzes.util.sql.SQLStatementGenerator
 
SQLValue - Class in org.clazzes.util.sql.criteria
A convenience class for wrapping column information and placeholder values for SQL statement generation
SQLValue(SQLValue.ValueType, String...) - Constructor for class org.clazzes.util.sql.criteria.SQLValue
 
SQLValue.ValueType - Enum in org.clazzes.util.sql.criteria
An internal Enumeration to denote the types of values a SQLValue can represent
startTransaction() - Method in class org.clazzes.util.sql.helper.JDBCTransaction
 
StatementPreparer - Interface in org.clazzes.util.sql.dao
Classes that have the capability to fill the placeholders of a prepared statement.
STATUS_LOCKED - Static variable in class org.clazzes.util.sql.ha.SqlHaLockManager
 
STATUS_NO_LOCK - Static variable in class org.clazzes.util.sql.ha.SqlHaLockManager
 
STATUS_UNLOCKED - Static variable in class org.clazzes.util.sql.ha.SqlHaLockManager
 
streamListWithCondition(IEntityConsumer<T>, SQLCondition, StatementPreparer) - Method in class org.clazzes.util.sql.dao.AbstrBasicDAO
Stream a list of POJOs, matching the given SQLCondition, prepared with the given StatementPreparer.
streamSubList(IEntityConsumer<T>, SQLCondition, StatementPreparer, SQLOrder[], int, int) - Method in class org.clazzes.util.sql.dao.AbstrBasicDAO
Stream a list of POJOs, matching the given SQLCondition, prepared with the given StatementPreparer.
stringValue(String) - Static method in class org.clazzes.util.sql.criteria.SQLValue
Creates a SQLValue representing a string constant.

T

tableColumn(String, String) - Static method in class org.clazzes.util.sql.criteria.SQLValue
Create a SQLValue representation of an arbitrary table column
toSQL(SQLDialect) - Method in class org.clazzes.util.sql.criteria.SQLCondition
 
toSQL(SQLDialect) - Method in class org.clazzes.util.sql.criteria.SQLConstruct
 
toSQL(SQLDialect) - Method in class org.clazzes.util.sql.criteria.SQLOrder
 
toSQL(SQLDialect) - Method in class org.clazzes.util.sql.criteria.SQLValue
 
toSQL(SQLDialect) - Method in interface org.clazzes.util.sql.SQLFragment
 

U

update(T) - Method in class org.clazzes.util.sql.dao.AbstrBasicDAO
 
update(T) - Method in class org.clazzes.util.sql.dao.AbstrIdDAO
 
update(DTO) - Method in interface org.clazzes.util.sql.dao.IBasicDAO
 
update(String, SQLValue[], SQLCondition) - Method in class org.clazzes.util.sql.SQLStatementGenerator
Generates a UPDATE statement for a given SQLDialect as follows:

UPDATE tableName SET columnName[0]=?
updateBatch(Collection<T>) - Method in class org.clazzes.util.sql.dao.AbstrBasicDAO
 
updateBatch(Collection<T>) - Method in class org.clazzes.util.sql.dao.AbstrIdDAO
 
updateBatch(Collection<DTO>) - Method in interface org.clazzes.util.sql.dao.IBasicDAO
Update a collection of objects as an SQL batch.
updateStatus(JDBCTransaction, int) - Method in class org.clazzes.util.sql.ha.SqlHaLockManager
 

V

valueList(SQLValue...) - Static method in class org.clazzes.util.sql.criteria.SQLValue
Convenience method to create a list of SQLValues
valueOf(String) - Static method in enum org.clazzes.util.sql.criteria.SQLConstruct.ConstructType
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum org.clazzes.util.sql.criteria.SQLConstruct.LinkType
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum org.clazzes.util.sql.criteria.SQLOrder.OrderDirection
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum org.clazzes.util.sql.criteria.SQLValue.ValueType
Returns the enum constant of this type with the specified name.
valueOf(String) - Static method in enum org.clazzes.util.sql.SQLDialect
Returns the enum constant of this type with the specified name.
values() - Static method in enum org.clazzes.util.sql.criteria.SQLConstruct.ConstructType
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum org.clazzes.util.sql.criteria.SQLConstruct.LinkType
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum org.clazzes.util.sql.criteria.SQLOrder.OrderDirection
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum org.clazzes.util.sql.criteria.SQLValue.ValueType
Returns an array containing the constants of this enum type, in the order they are declared.
values() - Static method in enum org.clazzes.util.sql.SQLDialect
Returns an array containing the constants of this enum type, in the order they are declared.
A C D E F G H I J L N O P R S T U V 

Copyright © 2017 Clazzes.org. All rights reserved.