org.waarp.openr66.dao.database

Class StatementExecutor<E>

java.lang.Object

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

All Implemented Interfaces:

Cloneable, AbstractDAO<E>

Direct Known Subclasses:

DBBusinessDAO, DBHostDAO, DBLimitDAO, DBMultipleMonitorDAO, DBRuleDAO, DBTransferDAO

public abstract class StatementExecutor<E>
extends Object
implements AbstractDAO<E>

Field Summary

Fields

Modifier and Type	Field and Description
protected Connection	connection

Constructor Summary

Constructors

Modifier	Constructor and Description
protected	StatementExecutor(Connection con)

Method Summary

Modifier and Type	Method and Description
void	close()
void	closeResultSet(ResultSet rs)
void	closeStatement(Statement stm)
void	delete(E e1) Remove the specified object from the persistance layer
void	deleteAll() Remove all objects from the persistance layer
void	executeAction(PreparedStatement stm)
ResultSet	executeQuery(PreparedStatement stm)
void	executeUpdate(PreparedStatement stm)
boolean	exist(String id) Verify if an object with the specified id exists in the persistance layer
List<E>	find(List<Filter> filters) Retrieve all objects corresponding to the given filters in a List from the persistance lsayer
List<E>	getAll() Retrieve all objects in a List from the persistance layer
protected abstract String	getDeleteAllRequest()
protected abstract String	getDeleteRequest()
protected abstract String	getExistRequest()
abstract E	getFromResultSet(ResultSet set)
protected abstract String	getGetAllRequest()
protected abstract String	getId(E e1)
protected abstract String	getInsertRequest()
protected abstract Object[]	getInsertValues(E e1)
protected abstract String	getSelectRequest()
protected abstract String	getUpdateRequest()
protected abstract Object[]	getUpdateValues(E e1)
void	insert(E e1) Insert the specified object in the persistance layer
E	select(String id) Retrieve the object with the specified id from the persistance layer
void	setParameters(PreparedStatement stm, Object... values)
void	update(E e1) Update the specified object in the persistance layer

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

connection

protected final Connection connection

Constructor Detail

StatementExecutor

protected StatementExecutor(Connection con)

Method Detail

getFromResultSet

public abstract E getFromResultSet(ResultSet set)
                            throws SQLException,
                                   DAOConnectionException

Throws:

SQLException

DAOConnectionException

setParameters

public void setParameters(PreparedStatement stm,
                          Object... values)
                   throws SQLException

Throws:

SQLException

executeUpdate

public void executeUpdate(PreparedStatement stm)
                   throws SQLException

Throws:

SQLException

executeAction

public void executeAction(PreparedStatement stm)
                   throws SQLException

Throws:

SQLException

executeQuery

public ResultSet executeQuery(PreparedStatement stm)
                       throws SQLException

Throws:

SQLException

closeStatement

public void closeStatement(Statement stm)

closeResultSet

public void closeResultSet(ResultSet rs)

close

public void close()

Specified by:

close in interface AbstractDAO<E>

getId

protected abstract String getId(E e1)

getSelectRequest

protected abstract String getSelectRequest()

getGetAllRequest

protected abstract String getGetAllRequest()

getExistRequest

protected abstract String getExistRequest()

getInsertValues

protected abstract Object[] getInsertValues(E e1)

getInsertRequest

protected abstract String getInsertRequest()

getUpdateValues

protected abstract Object[] getUpdateValues(E e1)

getUpdateRequest

protected abstract String getUpdateRequest()

getDeleteRequest

protected abstract String getDeleteRequest()

getDeleteAllRequest

protected abstract String getDeleteAllRequest()

delete

public void delete(E e1)
            throws DAOConnectionException,
                   DAONoDataException

Description copied from interface: AbstractDAO

Remove the specified object from the persistance layer

Specified by:

delete in interface AbstractDAO<E>

Parameters:

e1 - object to delete

Throws:

DAOConnectionException - If a data access error occurs

DAONoDataException - if no data are available

deleteAll

public void deleteAll()
               throws DAOConnectionException

Description copied from interface: AbstractDAO

Remove all objects from the persistance layer

Specified by:

deleteAll in interface AbstractDAO<E>

Throws:

DAOConnectionException - If a data access error occurs

getAll

public List<E> getAll()
               throws DAOConnectionException

Description copied from interface: AbstractDAO

Retrieve all objects in a List from the persistance layer

Specified by:

getAll in interface AbstractDAO<E>

Throws:

DAOConnectionException - If data access error occurs

find

public List<E> find(List<Filter> filters)
             throws DAOConnectionException

Description copied from interface: AbstractDAO

Retrieve all objects corresponding to the given filters in a List from the persistance lsayer

Specified by:

find in interface AbstractDAO<E>

Parameters:

filters - List of filter

Throws:

DAOConnectionException - If data access error occurs

exist

public boolean exist(String id)
              throws DAOConnectionException

Description copied from interface: AbstractDAO

Verify if an object with the specified id exists in the persistance layer

Specified by:

exist in interface AbstractDAO<E>

Parameters:

id - id of the object verified

Returns:

true if a object with the specified id exist; false if no object correspond to the specified id.

Throws:

DAOConnectionException - If a data access error occurs

select

public E select(String id)
         throws DAOConnectionException,
                DAONoDataException

Description copied from interface: AbstractDAO

Retrieve the object with the specified id from the persistance layer

Specified by:

select in interface AbstractDAO<E>

Parameters:

id - id of the object requested

Throws:

DAOConnectionException - If a data access error occurs

DAONoDataException - if no data are available

insert

public void insert(E e1)
            throws DAOConnectionException

Description copied from interface: AbstractDAO

Insert the specified object in the persistance layer

Specified by:

insert in interface AbstractDAO<E>

Parameters:

e1 - object to insert

Throws:

DAOConnectionException - If a data access error occurs

update

public void update(E e1)
            throws DAOConnectionException,
                   DAONoDataException

Description copied from interface: AbstractDAO

Update the specified object in the persistance layer

Specified by:

update in interface AbstractDAO<E>

Parameters:

e1 - object to update

Throws:

DAOConnectionException - If a data access error occurs

DAONoDataException - if no data are available