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

Constructor Summary

Constructors

Constructor and Description
DBHostDAO(Connection con)

Method Summary

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

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

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_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)
          throws DAOConnectionException

Throws:

DAOConnectionException

Method Detail

getId

protected String getId(Host e1)

Specified by:

getId in class StatementExecutor<Host>

getSelectRequest

protected String getSelectRequest()

Specified by:

getSelectRequest in class StatementExecutor<Host>

getGetAllRequest

protected String getGetAllRequest()

Specified by:

getGetAllRequest in class StatementExecutor<Host>

getExistRequest

protected String getExistRequest()

Specified by:

getExistRequest in class StatementExecutor<Host>

getInsertValues

protected Object[] getInsertValues(Host host)

Specified by:

getInsertValues in class StatementExecutor<Host>

getInsertRequest

protected String getInsertRequest()

Specified by:

getInsertRequest in class StatementExecutor<Host>

getUpdateValues

protected Object[] getUpdateValues(Host host)

Specified by:

getUpdateValues in class StatementExecutor<Host>

getUpdateRequest

protected String getUpdateRequest()

Specified by:

getUpdateRequest in class StatementExecutor<Host>

getDeleteRequest

protected String getDeleteRequest()

Specified by:

getDeleteRequest in class StatementExecutor<Host>

getDeleteAllRequest

protected String getDeleteAllRequest()

Specified by:

getDeleteAllRequest in class StatementExecutor<Host>

getFromResultSet

public Host getFromResultSet(ResultSet set)
                      throws SQLException

Specified by:

getFromResultSet in class StatementExecutor<Host>

Throws:

SQLException