pt.moredata.dao.core
Class SQLUpdateBuilder

java.lang.Object
  pt.moredata.dao.core.AbstractSQLStatementBuilder
      pt.moredata.dao.core.SQLUpdateBuilder

All Implemented Interfaces:

SQLStatementBuilder

public class SQLUpdateBuilder

extends AbstractSQLStatementBuilder

implements SQLStatementBuilder

This class is responsible for building SQL update commands. The commans are build from a DataAccessObject. Company MoreData

Version:

$Revision: 1.22 $

Author:

pcarmo

Field Summary

Fields inherited from class pt.moredata.dao.core.AbstractSQLStatementBuilder

_fieldsInfo, _info, _recordSet

Constructor Summary

SQLUpdateBuilder(DAOFieldsInfo fieldsInfo, RecordSet recordSet)
Creates a new instance of SQLUpdateBuilder

Method Summary

protected java.lang.String	getSQLStatement() Builds an update SQL command for interacting with a table of a relational database repository.
protected java.lang.Object	getValueForUpdate(int rowNumber, int columnNumber) Return the value of a giveen cell for use in the update clause.
protected boolean	includeInUpdate(int rowNumber, MetaField field, int updateType) Check if a field is to be included in the update statement.
void	loadData(java.sql.ResultSet resultSet) Load data from a ResultSet into the RecordSet.
protected void	setRecordValueForUpdate(java.sql.PreparedStatement statement, java.lang.String tableName, int rowNumber, int updateType) Set the values of the update statement parameters.
void	setStatementParameters(java.sql.PreparedStatement statement, SQLInformation info) Set the values of a statement parameters.

Methods inherited from class pt.moredata.dao.core.AbstractSQLStatementBuilder

getSQLStatement, getStringObjectWithSpaceAtEnd, setDAOFieldsInfo, setRecordSet, setRecordValue

Methods inherited from class java.lang.Object

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

Methods inherited from interface pt.moredata.dao.SQLStatementBuilder

getSQLStatement, setDAOFieldsInfo, setRecordSet

Constructor Detail

SQLUpdateBuilder

public SQLUpdateBuilder(DAOFieldsInfo fieldsInfo,
                        RecordSet recordSet)

Creates a new instance of SQLUpdateBuilder

Parameters:

fieldsInfo - The DAO fields information object.

recordSet - The DAO RecordSet object witch contains the DAO data.

Method Detail

getSQLStatement

protected java.lang.String getSQLStatement()

Builds an update SQL command for interacting with a table of a relational database repository.

Specified by:

getSQLStatement in class AbstractSQLStatementBuilder

Returns:

A string with the SQL command for interacting with a table of a relational database repository.

includeInUpdate

protected boolean includeInUpdate(int rowNumber,
                                  MetaField field,
                                  int updateType)

Check if a field is to be included in the update statement.

setRecordValueForUpdate

protected void setRecordValueForUpdate(java.sql.PreparedStatement statement,
                                       java.lang.String tableName,
                                       int rowNumber,
                                       int updateType)
                                throws java.sql.SQLException,
                                       WriterException

Set the values of the update statement parameters.

Parameters:

statement - The update statement.

tableName - The table Name of the update statement.

rowNumber - The row number of the update statement.

updateType - The update type used in the construction of the statement.

Throws:

java.sql.SQLException - If there is a database error.

WriterException - If the primary key value is null for the table and row specified. FIXME : Isto nao funnciona para o Oracle

getValueForUpdate

protected java.lang.Object getValueForUpdate(int rowNumber,
                                             int columnNumber)

Return the value of a giveen cell for use in the update clause.

Parameters:

rowNumber - The row number of the cell.

columnNumber - The column number of the cell.

Returns:

The value of a giveen cell for use in the update clause.

setStatementParameters

public void setStatementParameters(java.sql.PreparedStatement statement,
                                   SQLInformation info)
                            throws WriterException

Set the values of a statement parameters.

Specified by:

setStatementParameters in interface SQLStatementBuilder

Parameters:

statement - The prepared statement.

info - Adicional information to help building the sql statement.

Throws:

WriteException - If an error occur will setting the statement parameters.

WriterException

loadData

public void loadData(java.sql.ResultSet resultSet)
              throws ReaderException

Description copied from interface: SQLStatementBuilder

Load data from a ResultSet into the RecordSet. This method could and probably would use state build during the execution of the getSQLStatement() method.

Specified by:

loadData in interface SQLStatementBuilder

Parameters:

resultSet - A resultSet with the data to be loaded into the RecordSet.

Throws:

ReaderException