Start | Index | Overview • PREV | UP | NEXT

net.simplace.processors.JXLWorkbook2DBProcessor

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

public class JXLWorkbook2DBProcessor extends HSSFWorkbook2DBProcessor {
// Public Constructors
public JXLWorkbook2DBProcessor();

// Constants
public static final DateTimeFormatter SQL_DATE_FORMATTER;

// Protected Instance Methods

protected boolean process() throws PipeLineException;
// Overrides HSSFWorkbook2DBProcessor

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

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

aConnection connection to use
aTableName table name
aColCount count of columns the value wildcards are prepared for

returns the prepared insert statement

}

Hierarchy: java.lang.Object - net.simplace.util.pipeline.FWProcessor - HSSFWorkbook2DBProcessor - JXLWorkbook2DBProcessor