Package net.simplace.client.pipe.processors

Class DB2HSSFWorkbookProcessor

java.lang.Object

net.simplace.pipe.control.FWProcessor

net.simplace.client.pipe.processors.DB2HSSFWorkbookProcessor

Direct Known Subclasses:

DB2JXLWorkbookProcessor

public class DB2HSSFWorkbookProcessor
extends FWProcessor

Author:

Christoph Kunze, Martin Schmitz

Field Summary

Fields

Modifier and Type	Field	Description
protected static final String	DATABASE_CONNECTION_KEY
protected static final String	DATABASE_QUERY_KEY
protected static final String	DEST_FILENAME_KEY
protected static final String	DEST_SHEETNAME_KEY
protected Connection	iDatabaseConnection
protected Map<String,String>	iDatabaseQueries
protected File	iDestFile
protected String	iDestFilename
protected Map<String,String>	iDestSheetNames
protected int	iProgressStep
protected int	iProgressSteps
protected boolean	iRenewFile
protected static final String	RENEWFILE_KEY

Fields inherited from class net.simplace.pipe.control.FWProcessor

iAllreadyLoopedCount, iContainer, iInObservable, iObservable, iProgressTasks

Constructor Summary

Constructors

Constructor	Description
DB2HSSFWorkbookProcessor()

Method Summary

Modifier and Type	Method	Description
protected boolean	checkInParameterMap()	Can be overridden to perform semantic checks on the pipeline Input.
protected String	getTypeName(int aTypeNr)
protected boolean	process()	Must be overridden to implement concrete pipe procedure.
protected void	processDatabaseQuery(org.apache.poi.hssf.usermodel.HSSFWorkbook aWorkbook, String aDatabaseQuery, String aDestSheetName)
protected void	setProgressStepFinished(String aMessage)

Methods inherited from class net.simplace.pipe.control.FWProcessor

checkOutParameterMap, clone, containsParameter, createProcessor, createProcessor, fireTaskEvent, getAllStringInParameters, getConfiguration, getInitialParameters, getInParameter, getInParameter, getInParameters, getNewProgressTask, getOutParameter, getOutParameterKeys, getPipeLine, getProgressTask, getStringInParameter, getStringInParameter, getSystemID, hasConfiguration, isEndOfPipe, pipe, removeOutParameter, setConfiguration, setEndOfPipeFlag, setInitialParameters, setInParameterMap, setLoopedCount, setOutParameter, setStateOfTask, setStateProgressing, toXML

Methods inherited from class java.lang.Object

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

Field Details

DATABASE_CONNECTION_KEY

protected static final String DATABASE_CONNECTION_KEY

See Also:

• Constant Field Values

DATABASE_QUERY_KEY

protected static final String DATABASE_QUERY_KEY

See Also:

• Constant Field Values

DEST_FILENAME_KEY

protected static final String DEST_FILENAME_KEY

See Also:

• Constant Field Values

DEST_SHEETNAME_KEY

protected static final String DEST_SHEETNAME_KEY

See Also:

• Constant Field Values

RENEWFILE_KEY

protected static final String RENEWFILE_KEY

See Also:

• Constant Field Values

iDestFilename

protected String iDestFilename

iDestFile

protected File iDestFile

iDatabaseQueries

protected Map<String,String> iDatabaseQueries

iDatabaseConnection

protected Connection iDatabaseConnection

iDestSheetNames

protected Map<String,String> iDestSheetNames

iRenewFile

protected boolean iRenewFile

iProgressSteps

protected int iProgressSteps

iProgressStep

protected int iProgressStep

Constructor Details

DB2HSSFWorkbookProcessor

public DB2HSSFWorkbookProcessor()

Method Details

checkInParameterMap

protected boolean checkInParameterMap()

Description copied from class: FWProcessor

Can be overridden to perform semantic checks on the pipeline Input.

Overrides:

checkInParameterMap in class FWProcessor

Returns:

true if not overridden by implementations

setProgressStepFinished

protected void setProgressStepFinished(String aMessage)

process

protected boolean process()
                   throws PipeLineException

Description copied from class: FWProcessor

Must be overridden to implement concrete pipe procedure.

Specified by:

process in class FWProcessor

Returns:

success

Throws:

PipeLineException

processDatabaseQuery

protected void processDatabaseQuery(org.apache.poi.hssf.usermodel.HSSFWorkbook aWorkbook,
 String aDatabaseQuery,
 String aDestSheetName)
                             throws PipeLineException

Throws:

PipeLineException

getTypeName

protected String getTypeName(int aTypeNr)
                      throws PipeLineException

Throws:

PipeLineException