org.waarp.openr66.dao.database

Class DBLimitDAO

java.lang.Object

org.waarp.openr66.dao.database.StatementExecutor<Limit>

org.waarp.openr66.dao.database.DBLimitDAO

All Implemented Interfaces:

Cloneable, AbstractDAO<Limit>, LimitDAO

public class DBLimitDAO
extends StatementExecutor<Limit>
implements LimitDAO

Implementation of LimitDAO for standard SQL databases

Field Summary

Fields

Modifier and Type	Field and Description
static String	DELAY_LIMIT_FIELD
static String	HOSTID_FIELD
static String	READ_GLOBAL_LIMIT_FIELD
static String	READ_SESSION_LIMIT_FIELD
protected static String	SQL_COUNT_ALL
protected static String	SQL_DELETE
protected static String	SQL_DELETE_ALL
protected static String	SQL_EXIST
protected static String	SQL_GET_ALL
protected static String	SQL_INSERT
protected static String	SQL_SELECT
protected static String	SQL_UPDATE
protected static String	TABLE
static String	UPDATED_INFO_FIELD
static String	WRITE_GLOBAL_LIMIT_FIELD
static String	WRITE_SESSION_LIMIT_FIELD

Fields inherited from class org.waarp.openr66.dao.database.StatementExecutor

connection, PARAMETER, PARAMETER_COMMA, SQL_COUNT_ALL_PREFIX, WHERE

Constructor Summary

Constructors

Constructor and Description
DBLimitDAO(Connection con)

Method Summary

Modifier and Type	Method and Description
protected String	getCountRequest()
protected String	getDeleteAllRequest()
protected String	getDeleteRequest()
protected String	getExistRequest()
Limit	getFromResultSet(ResultSet set)
protected String	getGetAllRequest()
protected String	getId(Limit e1)
protected String	getInsertRequest()
protected Object[]	getInsertValues(Limit limit)
protected String	getSelectRequest()
protected String	getTable()
protected String	getUpdateRequest()
protected Object[]	getUpdateValues(Limit limit)
protected boolean	isCachedEnable()
protected boolean	isDbTransfer()

Methods inherited from class org.waarp.openr66.dao.database.StatementExecutor

addToCache, clearCache, close, closeResultSet, closeStatement, count, delete, delete, deleteAll, executeAction, executeQuery, executeUpdate, exist, find, find, find, find, find, getAll, getCache, getConnection, getFromCache, insert, isInCache, prepareCountQuery, prepareDeleteQuery, prepareFindParams, prepareFindQuery, removeFromCache, select, setParameters, update, update

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface org.waarp.openr66.dao.AbstractDAO

close, count, delete, deleteAll, exist, find, find, find, find, find, getAll, insert, select, update, update

Field Detail

TABLE

protected static final String TABLE

See Also:

Constant Field Values

HOSTID_FIELD

public static final String HOSTID_FIELD

See Also:

Constant Field Values

READ_GLOBAL_LIMIT_FIELD

public static final String READ_GLOBAL_LIMIT_FIELD

See Also:

Constant Field Values

WRITE_GLOBAL_LIMIT_FIELD

public static final String WRITE_GLOBAL_LIMIT_FIELD

See Also:

Constant Field Values

READ_SESSION_LIMIT_FIELD

public static final String READ_SESSION_LIMIT_FIELD

See Also:

Constant Field Values

WRITE_SESSION_LIMIT_FIELD

public static final String WRITE_SESSION_LIMIT_FIELD

See Also:

Constant Field Values

DELAY_LIMIT_FIELD

public static final String DELAY_LIMIT_FIELD

See Also:

Constant Field Values

UPDATED_INFO_FIELD

public static final String UPDATED_INFO_FIELD

See Also:

Constant Field Values

SQL_DELETE_ALL

protected static final String SQL_DELETE_ALL

See Also:

Constant Field Values

SQL_DELETE

protected static final String SQL_DELETE

See Also:

Constant Field Values

SQL_GET_ALL

protected static final String SQL_GET_ALL

See Also:

Constant Field Values

SQL_COUNT_ALL

protected static final String SQL_COUNT_ALL

See Also:

Constant Field Values

SQL_EXIST

protected static final String SQL_EXIST

See Also:

Constant Field Values

SQL_SELECT

protected static final String SQL_SELECT

See Also:

Constant Field Values

SQL_INSERT

protected static final String SQL_INSERT

See Also:

Constant Field Values

SQL_UPDATE

protected static final String SQL_UPDATE

See Also:

Constant Field Values

Constructor Detail

DBLimitDAO

public DBLimitDAO(Connection con)

Method Detail

isCachedEnable

protected final boolean isCachedEnable()

Specified by:

isCachedEnable in class StatementExecutor<Limit>

getId

protected final String getId(Limit e1)

Specified by:

getId in class StatementExecutor<Limit>

getTable

protected final String getTable()

Specified by:

getTable in class StatementExecutor<Limit>

getSelectRequest

protected final String getSelectRequest()

Specified by:

getSelectRequest in class StatementExecutor<Limit>

getGetAllRequest

protected final String getGetAllRequest()

Specified by:

getGetAllRequest in class StatementExecutor<Limit>

getCountRequest

protected final String getCountRequest()

Specified by:

getCountRequest in class StatementExecutor<Limit>

getExistRequest

protected final String getExistRequest()

Specified by:

getExistRequest in class StatementExecutor<Limit>

getInsertValues

protected final Object[] getInsertValues(Limit limit)

Specified by:

getInsertValues in class StatementExecutor<Limit>

getInsertRequest

protected final String getInsertRequest()

Specified by:

getInsertRequest in class StatementExecutor<Limit>

getUpdateValues

protected final Object[] getUpdateValues(Limit limit)

Specified by:

getUpdateValues in class StatementExecutor<Limit>

getUpdateRequest

protected final String getUpdateRequest()

Specified by:

getUpdateRequest in class StatementExecutor<Limit>

getDeleteRequest

protected final String getDeleteRequest()

Specified by:

getDeleteRequest in class StatementExecutor<Limit>

getDeleteAllRequest

protected final String getDeleteAllRequest()

Specified by:

getDeleteAllRequest in class StatementExecutor<Limit>

getFromResultSet

public final Limit getFromResultSet(ResultSet set)
                             throws SQLException

Specified by:

getFromResultSet in class StatementExecutor<Limit>

Throws:

SQLException

isDbTransfer

protected final boolean isDbTransfer()

Specified by:

isDbTransfer in class StatementExecutor<Limit>