org.waarp.openr66.dao.database

Class DBBusinessDAO

java.lang.Object

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

org.waarp.openr66.dao.database.DBBusinessDAO

All Implemented Interfaces:

Cloneable, AbstractDAO<Business>, BusinessDAO

public class DBBusinessDAO
extends StatementExecutor<Business>
implements BusinessDAO

Implementation of BusinessDAO for standard SQL databases

Field Summary

Fields

Modifier and Type	Field and Description
static String	ALIASES_FIELD
static String	BUSINESS_FIELD
static String	HOSTID_FIELD
static String	OTHERS_FIELD
static String	ROLES_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
DBBusinessDAO(Connection con)

Method Summary

Modifier and Type	Method and Description
protected String	getDeleteAllRequest()
protected String	getDeleteRequest()
protected String	getExistRequest()
Business	getFromResultSet(ResultSet set)
protected String	getGetAllRequest()
protected String	getId(Business e1)
protected String	getInsertRequest()
protected Object[]	getInsertValues(Business business)
protected String	getSelectRequest()
protected String	getUpdateRequest()
protected Object[]	getUpdateValues(Business business)

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

BUSINESS_FIELD

public static final String BUSINESS_FIELD

See Also:

Constant Field Values

ROLES_FIELD

public static final String ROLES_FIELD

See Also:

Constant Field Values

ALIASES_FIELD

public static final String ALIASES_FIELD

See Also:

Constant Field Values

OTHERS_FIELD

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

DBBusinessDAO

public DBBusinessDAO(Connection con)

Method Detail

getId

protected String getId(Business e1)

Specified by:

getId in class StatementExecutor<Business>

getSelectRequest

protected String getSelectRequest()

Specified by:

getSelectRequest in class StatementExecutor<Business>

getGetAllRequest

protected String getGetAllRequest()

Specified by:

getGetAllRequest in class StatementExecutor<Business>

getExistRequest

protected String getExistRequest()

Specified by:

getExistRequest in class StatementExecutor<Business>

getInsertValues

protected Object[] getInsertValues(Business business)

Specified by:

getInsertValues in class StatementExecutor<Business>

getInsertRequest

protected String getInsertRequest()

Specified by:

getInsertRequest in class StatementExecutor<Business>

getUpdateValues

protected Object[] getUpdateValues(Business business)

Specified by:

getUpdateValues in class StatementExecutor<Business>

getUpdateRequest

protected String getUpdateRequest()

Specified by:

getUpdateRequest in class StatementExecutor<Business>

getDeleteRequest

protected String getDeleteRequest()

Specified by:

getDeleteRequest in class StatementExecutor<Business>

getDeleteAllRequest

protected String getDeleteAllRequest()

Specified by:

getDeleteAllRequest in class StatementExecutor<Business>

getFromResultSet

public Business getFromResultSet(ResultSet set)
                          throws SQLException

Specified by:

getFromResultSet in class StatementExecutor<Business>

Throws:

SQLException