- 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
-
- 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
SQLFragment
s
- 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.
- valueList(SQLValue...) - Static method in class org.clazzes.util.sql.criteria.SQLValue
-
Convenience method to create a list of
SQLValue
s
- 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.