org.waarp.openr66.dao.database

Class DBTransferDAO

java.lang.Object

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

org.waarp.openr66.dao.database.DBTransferDAO

All Implemented Interfaces:

Cloneable, AbstractDAO<Transfer>, TransferDAO

Direct Known Subclasses:

H2TransferDAO, MariaDBTransferDAO, OracleTransferDAO, PostgreSQLTransferDAO

public abstract class DBTransferDAO
extends StatementExecutor<Transfer>
implements TransferDAO

Implementation of TransferDAO for a standard SQL database

Field Summary

Fields

Modifier and Type	Field and Description
static String	BLOCK_SIZE_FIELD
static String	FILE_INFO_FIELD
static String	FILENAME_FIELD
static String	GLOBAL_LAST_STEP_FIELD
static String	GLOBAL_STEP_FIELD
static String	ID_FIELD
static String	ID_RULE_FIELD
static String	INFO_STATUS_FIELD
static String	IS_MOVED_FIELD
static String	ORIGINAL_NAME_FIELD
static String	OWNER_REQUEST_FIELD
static String	RANK_FIELD
static String	REQUESTED_FIELD
static String	REQUESTER_FIELD
static String	RETRIEVE_MODE_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
static String	STEP_FIELD
static String	STEP_STATUS_FIELD
protected static String	TABLE
static String	TRANSFER_INFO_FIELD
static String	TRANSFER_MODE_FIELD
static String	TRANSFER_START_FIELD
static String	TRANSFER_STOP_FIELD
static String	UPDATED_INFO_FIELD

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

connection

Constructor Summary

Constructors

Modifier	Constructor and Description
protected	DBTransferDAO(Connection con)

Method Summary

Modifier and Type	Method and Description
void	delete(Transfer transfer) Remove the specified object from the persistance layer
boolean	exist(long id, String requester, String requested, String owner) Verify if a Transfer object with the specified Special ID exists in the persistance layer
boolean	exist(String id) UnsupportedOperationException
List<Transfer>	find(List<Filter> filters, int limit) Retrieve all Transfer objects to the given filters in a List from the persistance layer
List<Transfer>	find(List<Filter> filters, int limit, int offset) Retrieve all Transfer objects to the given filters in a List from the persistance layer
List<Transfer>	find(List<Filter> filters, String column, boolean ascend) Retrieve all Transfer objects to the given filters in a List from the persistance layer
List<Transfer>	find(List<Filter> filters, String column, boolean ascend, int limit) Retrieve all Transfer objects to the given filters in a List from the persistance layer
List<Transfer>	find(List<Filter> filters, String column, boolean ascend, int limit, int offset) Retrieve all Transfer objects to the given filters in a List from the persistance layer
protected String	getDeleteAllRequest()
protected String	getDeleteRequest()
protected String	getExistRequest()
Transfer	getFromResultSet(ResultSet set)
protected String	getGetAllRequest()
protected String	getId(Transfer e1) UnsupportedOperationException
protected String	getInsertRequest()
protected Object[]	getInsertValues(Transfer transfer)
protected abstract long	getNextId()
protected String	getSelectRequest()
protected String	getUpdateRequest()
protected Object[]	getUpdateValues(Transfer transfer)
void	insert(Transfer transfer) Insert the specified object in the persistance layer
Transfer	select(long id, String requester, String requested, String owner) Retrieve the Transfer object with the specified Special ID from the persistance layer
Transfer	select(String id) UnsupportedOperationException

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

close, closeResultSet, closeStatement, deleteAll, executeAction, executeQuery, executeUpdate, find, getAll, 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, deleteAll, find, getAll, update

Field Detail

TABLE

protected static final String TABLE

See Also:

Constant Field Values

ID_FIELD

public static final String ID_FIELD

See Also:

Constant Field Values

GLOBAL_STEP_FIELD

public static final String GLOBAL_STEP_FIELD

See Also:

Constant Field Values

GLOBAL_LAST_STEP_FIELD

public static final String GLOBAL_LAST_STEP_FIELD

See Also:

Constant Field Values

STEP_FIELD

public static final String STEP_FIELD

See Also:

Constant Field Values

RANK_FIELD

public static final String RANK_FIELD

See Also:

Constant Field Values

STEP_STATUS_FIELD

public static final String STEP_STATUS_FIELD

See Also:

Constant Field Values

RETRIEVE_MODE_FIELD

public static final String RETRIEVE_MODE_FIELD

See Also:

Constant Field Values

FILENAME_FIELD

public static final String FILENAME_FIELD

See Also:

Constant Field Values

IS_MOVED_FIELD

public static final String IS_MOVED_FIELD

See Also:

Constant Field Values

ID_RULE_FIELD

public static final String ID_RULE_FIELD

See Also:

Constant Field Values

BLOCK_SIZE_FIELD

public static final String BLOCK_SIZE_FIELD

See Also:

Constant Field Values

ORIGINAL_NAME_FIELD

public static final String ORIGINAL_NAME_FIELD

See Also:

Constant Field Values

FILE_INFO_FIELD

public static final String FILE_INFO_FIELD

See Also:

Constant Field Values

TRANSFER_INFO_FIELD

public static final String TRANSFER_INFO_FIELD

See Also:

Constant Field Values

TRANSFER_MODE_FIELD

public static final String TRANSFER_MODE_FIELD

See Also:

Constant Field Values

TRANSFER_START_FIELD

public static final String TRANSFER_START_FIELD

See Also:

Constant Field Values

TRANSFER_STOP_FIELD

public static final String TRANSFER_STOP_FIELD

See Also:

Constant Field Values

INFO_STATUS_FIELD

public static final String INFO_STATUS_FIELD

See Also:

Constant Field Values

OWNER_REQUEST_FIELD

public static final String OWNER_REQUEST_FIELD

See Also:

Constant Field Values

REQUESTED_FIELD

public static final String REQUESTED_FIELD

See Also:

Constant Field Values

REQUESTER_FIELD

public static final String REQUESTER_FIELD

See Also:

Constant Field Values

UPDATED_INFO_FIELD

public static final String UPDATED_INFO_FIELD

See Also:

Constant Field Values

SQL_DELETE

protected static final String SQL_DELETE

See Also:

Constant Field Values

SQL_DELETE_ALL

protected static final String SQL_DELETE_ALL

See Also:

Constant Field Values

SQL_EXIST

protected static final String SQL_EXIST

See Also:

Constant Field Values

SQL_GET_ALL

protected static final String SQL_GET_ALL

See Also:

Constant Field Values

SQL_INSERT

protected static final String SQL_INSERT

See Also:

Constant Field Values

SQL_SELECT

protected static final String SQL_SELECT

See Also:

Constant Field Values

SQL_UPDATE

protected static final String SQL_UPDATE

See Also:

Constant Field Values

Constructor Detail

DBTransferDAO

protected DBTransferDAO(Connection con)

Method Detail

getDeleteRequest

protected String getDeleteRequest()

Specified by:

getDeleteRequest in class StatementExecutor<Transfer>

getDeleteAllRequest

protected String getDeleteAllRequest()

Specified by:

getDeleteAllRequest in class StatementExecutor<Transfer>

getExistRequest

protected String getExistRequest()

Specified by:

getExistRequest in class StatementExecutor<Transfer>

getGetAllRequest

protected String getGetAllRequest()

Specified by:

getGetAllRequest in class StatementExecutor<Transfer>

getInsertRequest

protected String getInsertRequest()

Specified by:

getInsertRequest in class StatementExecutor<Transfer>

getSelectRequest

protected String getSelectRequest()

Specified by:

getSelectRequest in class StatementExecutor<Transfer>

getUpdateRequest

protected String getUpdateRequest()

Specified by:

getUpdateRequest in class StatementExecutor<Transfer>

getInsertValues

protected Object[] getInsertValues(Transfer transfer)

Specified by:

getInsertValues in class StatementExecutor<Transfer>

getUpdateValues

protected Object[] getUpdateValues(Transfer transfer)

Specified by:

getUpdateValues in class StatementExecutor<Transfer>

delete

public void delete(Transfer transfer)
            throws DAOConnectionException,
                   DAONoDataException

Description copied from interface: AbstractDAO

Remove the specified object from the persistance layer

Specified by:

delete in interface AbstractDAO<Transfer>

Overrides:

delete in class StatementExecutor<Transfer>

Parameters:

transfer - object to delete

Throws:

DAOConnectionException - If a data access error occurs

DAONoDataException - if no data are available

find

public List<Transfer> find(List<Filter> filters,
                           int limit)
                    throws DAOConnectionException

Description copied from interface: TransferDAO

Retrieve all Transfer objects to the given filters in a List from the persistance layer

Specified by:

find in interface TransferDAO

Parameters:

filters - List of filter

Throws:

DAOConnectionException - If data access error occurs

find

public List<Transfer> find(List<Filter> filters,
                           int limit,
                           int offset)
                    throws DAOConnectionException

Description copied from interface: TransferDAO

Retrieve all Transfer objects to the given filters in a List from the persistance layer

Specified by:

find in interface TransferDAO

Parameters:

filters - List of filter

Throws:

DAOConnectionException - If data access error occurs

find

public List<Transfer> find(List<Filter> filters,
                           String column,
                           boolean ascend)
                    throws DAOConnectionException

Description copied from interface: TransferDAO

Retrieve all Transfer objects to the given filters in a List from the persistance layer

Specified by:

find in interface TransferDAO

Parameters:

filters - List of filter

Throws:

DAOConnectionException - If data access error occurs

find

public List<Transfer> find(List<Filter> filters,
                           String column,
                           boolean ascend,
                           int limit)
                    throws DAOConnectionException

Description copied from interface: TransferDAO

Retrieve all Transfer objects to the given filters in a List from the persistance layer

Specified by:

find in interface TransferDAO

Parameters:

filters - List of filter

Throws:

DAOConnectionException - If data access error occurs

find

public List<Transfer> find(List<Filter> filters,
                           String column,
                           boolean ascend,
                           int limit,
                           int offset)
                    throws DAOConnectionException

Description copied from interface: TransferDAO

Retrieve all Transfer objects to the given filters in a List from the persistance layer

Specified by:

find in interface TransferDAO

Parameters:

filters - List of filter

Throws:

DAOConnectionException - If data access error occurs

exist

public boolean exist(long id,
                     String requester,
                     String requested,
                     String owner)
              throws DAOConnectionException

Description copied from interface: TransferDAO

Verify if a Transfer object with the specified Special ID exists in the persistance layer

Specified by:

exist in interface TransferDAO

Parameters:

id - special ID of the Transfer object verified

Returns:

true if a Transfer object with the specified Special ID exist; false if no Transfer object correspond to the specified Special ID.

Throws:

DAOConnectionException - If a data access error occurs

select

public Transfer select(long id,
                       String requester,
                       String requested,
                       String owner)
                throws DAOConnectionException,
                       DAONoDataException

Description copied from interface: TransferDAO

Retrieve the Transfer object with the specified Special ID from the persistance layer

Specified by:

select in interface TransferDAO

Parameters:

id - special ID of the Transfer object requested

Throws:

DAOConnectionException - If a data access error occurs

DAONoDataException - if no data are available

getNextId

protected abstract long getNextId()
                           throws DAOConnectionException

Throws:

DAOConnectionException

insert

public void insert(Transfer transfer)
            throws DAOConnectionException

Description copied from interface: AbstractDAO

Insert the specified object in the persistance layer

Specified by:

insert in interface AbstractDAO<Transfer>

Overrides:

insert in class StatementExecutor<Transfer>

Parameters:

transfer - object to insert

Throws:

DAOConnectionException - If a data access error occurs

getFromResultSet

public Transfer getFromResultSet(ResultSet set)
                          throws SQLException

Specified by:

getFromResultSet in class StatementExecutor<Transfer>

Throws:

SQLException

select

public Transfer select(String id)

UnsupportedOperationException

Specified by:

select in interface AbstractDAO<Transfer>

Overrides:

select in class StatementExecutor<Transfer>

Parameters:

id - id of the object requested

Returns:

never

exist

public boolean exist(String id)

UnsupportedOperationException

Specified by:

exist in interface AbstractDAO<Transfer>

Overrides:

exist in class StatementExecutor<Transfer>

Parameters:

id - id of the object requested

Returns:

never

getId

protected String getId(Transfer e1)

UnsupportedOperationException

Specified by:

getId in class StatementExecutor<Transfer>

Parameters:

e1 - as Transfer

Returns:

never