org.waarp.openr66.dao.database

Class DBHostDAO

java.lang.Object

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

org.waarp.openr66.dao.database.DBHostDAO

All Implemented Interfaces:

Cloneable, AbstractDAO<Host>, HostDAO

public class DBHostDAO
extends StatementExecutor<Host>
implements HostDAO

Implementation of HostDAO for standard SQL databases

Field Summary

Fields

Modifier and Type	Field and Description
static String	ADDRESS_FIELD
static String	ADMINROLE_FIELD
static String	HOSTID_FIELD
static String	HOSTKEY_FIELD
static String	IS_ACTIVE_FIELD
static String	IS_CLIENT_FIELD
static String	IS_PROXIFIED_FIELD
static String	IS_SSL_FIELD
static String	PORT_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

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
DBHostDAO(Connection con)

Method Summary

Modifier and Type	Method and Description
protected SynchronizedLruCache<String,Host>	getCache()
protected String	getCountRequest()
protected String	getDeleteAllRequest()
protected String	getDeleteRequest()
protected String	getExistRequest()
Host	getFromResultSet(ResultSet set)
protected String	getGetAllRequest()
protected String	getId(Host e1)
protected String	getInsertRequest()
protected Object[]	getInsertValues(Host host)
protected String	getSelectRequest()
protected String	getTable()
protected String	getUpdateRequest()
protected Object[]	getUpdateValues(Host host)
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, 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

ADDRESS_FIELD

public static final String ADDRESS_FIELD

See Also:

Constant Field Values

PORT_FIELD

public static final String PORT_FIELD

See Also:

Constant Field Values

IS_SSL_FIELD

public static final String IS_SSL_FIELD

See Also:

Constant Field Values

IS_CLIENT_FIELD

public static final String IS_CLIENT_FIELD

See Also:

Constant Field Values

IS_ACTIVE_FIELD

public static final String IS_ACTIVE_FIELD

See Also:

Constant Field Values

IS_PROXIFIED_FIELD

public static final String IS_PROXIFIED_FIELD

See Also:

Constant Field Values

HOSTKEY_FIELD

public static final String HOSTKEY_FIELD

See Also:

Constant Field Values

ADMINROLE_FIELD

public static final String ADMINROLE_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

DBHostDAO

public DBHostDAO(Connection con)

Method Detail

isCachedEnable

protected final boolean isCachedEnable()

Specified by:

isCachedEnable in class StatementExecutor<Host>

getCache

protected final SynchronizedLruCache<String,Host> getCache()

Overrides:

getCache in class StatementExecutor<Host>

getId

protected final String getId(Host e1)

Specified by:

getId in class StatementExecutor<Host>

getTable

protected final String getTable()

Specified by:

getTable in class StatementExecutor<Host>

getSelectRequest

protected final String getSelectRequest()

Specified by:

getSelectRequest in class StatementExecutor<Host>

getGetAllRequest

protected final String getGetAllRequest()

Specified by:

getGetAllRequest in class StatementExecutor<Host>

getCountRequest

protected final String getCountRequest()

Specified by:

getCountRequest in class StatementExecutor<Host>

getExistRequest

protected final String getExistRequest()

Specified by:

getExistRequest in class StatementExecutor<Host>

getInsertValues

protected final Object[] getInsertValues(Host host)
                                  throws WaarpDatabaseSqlException

Specified by:

getInsertValues in class StatementExecutor<Host>

Throws:

WaarpDatabaseSqlException

getInsertRequest

protected final String getInsertRequest()

Specified by:

getInsertRequest in class StatementExecutor<Host>

getUpdateValues

protected final Object[] getUpdateValues(Host host)
                                  throws WaarpDatabaseSqlException

Specified by:

getUpdateValues in class StatementExecutor<Host>

Throws:

WaarpDatabaseSqlException

getUpdateRequest

protected final String getUpdateRequest()

Specified by:

getUpdateRequest in class StatementExecutor<Host>

getDeleteRequest

protected final String getDeleteRequest()

Specified by:

getDeleteRequest in class StatementExecutor<Host>

getDeleteAllRequest

protected final String getDeleteAllRequest()

Specified by:

getDeleteAllRequest in class StatementExecutor<Host>

getFromResultSet

public final Host getFromResultSet(ResultSet set)
                            throws SQLException

Specified by:

getFromResultSet in class StatementExecutor<Host>

Throws:

SQLException

isDbTransfer

protected final boolean isDbTransfer()

Specified by:

isDbTransfer in class StatementExecutor<Host>