Package net.simplace.client.pipe.processors

Class JXLWorkbook2DBProcessor

java.lang.Object

net.simplace.pipe.control.FWProcessor

net.simplace.client.pipe.processors.HSSFWorkbook2DBProcessor

net.simplace.client.pipe.processors.JXLWorkbook2DBProcessor

public class JXLWorkbook2DBProcessor
extends HSSFWorkbook2DBProcessor

This processor reads an XLS document into a JXL workbook (JExcelApi) object. The configuration is the same as HSSFWorkbook2DBProcessor.

Author:

Martin Schmitz

Field Summary

Fields

Modifier and Type	Field	Description
static final DateTimeFormatter	SQL_DATE_FORMATTER

Fields inherited from class net.simplace.client.pipe.processors.HSSFWorkbook2DBProcessor

iConnectionPoolName, iJdbcDriver, iJdbcUrl, iPrevAutoCommit, iSourceFile, JDBC_DRIVER_DEFAULT, JDBC_DRIVER_KEY, JDBC_URL_DEFAULT, JDBC_URL_KEY, POOL_NAME_DEFAULT, POOL_NAME_KEY

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

iAllreadyLoopedCount, iContainer, iInObservable, iObservable, iProgressTasks

Constructor Summary

Constructors

Constructor	Description
JXLWorkbook2DBProcessor()

Method Summary

Modifier and Type	Method	Description
protected PreparedStatement	prepareInsertStatement(Connection aConnection, String aTableName, int aColCount)	Prepares a SQL statement "INSERT INTO ...
protected boolean	process()	Must be overridden to implement concrete pipe procedure.

Methods inherited from class net.simplace.client.pipe.processors.HSSFWorkbook2DBProcessor

checkInParameterMap, deleteTable, getConnection

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

SQL_DATE_FORMATTER

public static final DateTimeFormatter SQL_DATE_FORMATTER

Constructor Details

JXLWorkbook2DBProcessor

public JXLWorkbook2DBProcessor()

Method Details

process

protected boolean process()
                   throws PipeLineException

Description copied from class: FWProcessor

Must be overridden to implement concrete pipe procedure.

Overrides:

process in class HSSFWorkbook2DBProcessor

Returns:

success

Throws:

PipeLineException

prepareInsertStatement

protected PreparedStatement prepareInsertStatement(Connection aConnection,
 String aTableName,
 int aColCount)
                                            throws SQLException

Prepares a SQL statement "INSERT INTO ... VALUES (?, ?, ?, ...);" with a wildcard for each column.

Parameters:

aConnection - connection to use

aTableName - table name

aColCount - count of columns the value wildcards are prepared for

Returns:

Throws:

SQLException