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_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

Constructor Summary

Constructors

Constructor and Description
DBLimitDAO(Connection con)

Method Summary

Modifier and Type	Method and Description
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	getUpdateRequest()
protected Object[]	getUpdateValues(Limit limit)

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

close, closeResultSet, closeStatement, delete, deleteAll, executeAction, executeQuery, executeUpdate, exist, find, getAll, insert, select, setParameters, 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, delete, deleteAll, exist, find, getAll, insert, select, 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_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

getId

protected String getId(Limit e1)

Specified by:

getId in class StatementExecutor<Limit>

getSelectRequest

protected String getSelectRequest()

Specified by:

getSelectRequest in class StatementExecutor<Limit>

getGetAllRequest

protected String getGetAllRequest()

Specified by:

getGetAllRequest in class StatementExecutor<Limit>

getExistRequest

protected String getExistRequest()

Specified by:

getExistRequest in class StatementExecutor<Limit>

getInsertValues

protected Object[] getInsertValues(Limit limit)

Specified by:

getInsertValues in class StatementExecutor<Limit>

getInsertRequest

protected String getInsertRequest()

Specified by:

getInsertRequest in class StatementExecutor<Limit>

getUpdateValues

protected Object[] getUpdateValues(Limit limit)

Specified by:

getUpdateValues in class StatementExecutor<Limit>

getUpdateRequest

protected String getUpdateRequest()

Specified by:

getUpdateRequest in class StatementExecutor<Limit>

getDeleteRequest

protected String getDeleteRequest()

Specified by:

getDeleteRequest in class StatementExecutor<Limit>

getDeleteAllRequest

protected String getDeleteAllRequest()

Specified by:

getDeleteAllRequest in class StatementExecutor<Limit>

getFromResultSet

public Limit getFromResultSet(ResultSet set)
                       throws SQLException

Specified by:

getFromResultSet in class StatementExecutor<Limit>

Throws:

SQLException