Package overit.geocall.basic.ui.xlsx

Class XlsxDBStatementView

java.lang.Object

overit.geocall.platform.ui.UINode

overit.geocall.basic.ui.xlsx.XlsxComponent

overit.geocall.basic.ui.xlsx.XlsxContainer

overit.geocall.basic.ui.xlsx.XlsxTableView

overit.geocall.basic.ui.xlsx.XlsxDBStatementView

All Implemented Interfaces:

Serializable, XlsxElement, DBObjectMapper, Identified

@Component
public class XlsxDBStatementView
extends XlsxTableView
implements DBObjectMapper

This class extends XlsxTableView and implements DBObjectMapper.
This class represent an Excel file can have more working sheets, in that case every sheet must have a different name and label, the title is optional.
Manages the rappresentation of the DBView.

See Also:

• Serialized Form

Nested Class Summary

Nested classes/interfaces inherited from class overit.geocall.basic.ui.xlsx.XlsxTableView

XlsxTableView.BreakUtility

Field Summary

Fields

Modifier and Type	Field	Description
protected DBStatement	_dbs
protected int	_dbStatementRow
protected HashMap	_definitions
protected int	_maxRows
protected int	_maxSheetRows
protected DBObjectMap	_objectmap
protected IXlsxValueModificator	_poiValuesModificator
protected ResultSet	_resultSet

Fields inherited from class overit.geocall.basic.ui.xlsx.XlsxTableView

_autoSize, _boldTitles, _breakColumns, _breakColumnsPos, _charSpan, _columnSize, _customSize, _dbv, _defaultStartRow, _enabledChild, _forcedLines4Row, _haveTotal, _lastCol, _lastRow, _lines4Row, _name, _rowHeight, _showTitles, _startCol, _startRow, _titleFont, _titleFontSize, _titleWrap, _vAutoSize

Fields inherited from class overit.geocall.basic.ui.xlsx.XlsxComponent

_align, _cellFormat, _cellFormatClass, _font, _format, _valign, _warning

Constructor Summary

Constructors

Constructor	Description
XlsxDBStatementView()

Method Summary

Modifier and Type	Method	Description
protected int	addCells(int startRow, int startCol, ResultSet rs, org.apache.poi.ss.usermodel.Sheet sheet)
void	define(String field, DBObjectMap dbom)
void	getContent(org.apache.poi.ss.usermodel.Sheet sheet, int startrow, int startCol)
DBObjectMap	getDBObjectMap()	Implementation of the DBObjectMapper interface.
DBStatement	getDBStatement()	Gets the DBStatement.
protected ArrayList	getRow(ResultSet rs, ResultSetMetaData rsmd, int columnCont)
boolean	haveDBObjectMap()	Checks the presence of a valid DBObjectMap contained in the instance.
protected boolean	isCellToAdd(ResultSet _rs)	Deprecated. Implement the interface IXlsValuesModificator and use setXlsValuesModificator(overit.geocall.basic.ui.xlsx.IXlsxValueModificator)
void	setDataView(Object dbstatement)	Needs a DBStatement
void	setDBObjectMap(DBObjectMap objectmap)	Implementation of the DBObjectMapper interface.
void	setMAXROWS(String s)	Sets the max number of rows.
void	setMAXSHEETROWS(String s)	Sets the maximum limit of row for the sheet
void	setXlsValuesModificator(IXlsxValueModificator valuesModificator)	Sets the IXlsxValueModificator.

Methods inherited from class overit.geocall.basic.ui.xlsx.XlsxTableView

addBreakFunctions, addCells, addCells, addNewColumn, addTestata, addTotali, autoSize, customSize, getCharSpan, getDataView, getDeafultStartRow, getEnabledChild, getHeaderFontColor, getHeadTitles, getIdentity, getLines4Row, getName, getOccupationCol, getOccupationRow, getRowHeight, getStartCol, getStartRow, getTitleFont, getTitleFontSize, getTitleWrap, getXlsxColumnPosByName, hasBoldTitles, haveTotal, initChilds, setAUTOSIZE, setBOLDTITLES, setBREAKCOLUMNS, setCHARSPAN, setColumnSizing, setCUSTOMSIZE, setHEADERFONTCOLOR, setHEADTITLES, setIdentity, setLINES4ROW, setNAME, setROWHEIGHT, setStartCol, setSTARTCOL, setStartRow, setSTARTROW, setTITLEFONT, setTITLEFONTSIZE, setTITLEWRAP, setVAUTOSIZE

Methods inherited from class overit.geocall.basic.ui.xlsx.XlsxComponent

getAlign, getBgColor, getBoolean, getBorder, getBorder, getBorder, getBorderColor, getBorderStyle, getCellFormat, getCellStyle, getChildIterator, getChildSize, getColor, getColor, getComment, getDefault, getDocument, getFont, getFontSize, getKey, getLabel, getRegistryName, getSheet, getStyleName, getVAlign, getWarning, hasFontSize, initCellFormat, initChilds, isBold, isEnabled, isForcedBoldState, isForcedFontSize, isHidden, isLocked, isShrinkToFit, isWrap, onInit, setALIGN, setBGCOLOR, setBOLD, setBorder, setBORDER, setBorderColor, setBORDERCOLORRGB, setBorderStyle, setBORDERSTYLE, setCellFormat, setCELLFORMATCLASS, setCellStyle, setCOLOR, setCOMMENT, setDEFAULT, setENABLED, setFONT, setFONTSIZE, setFORMAT, setHIDDEN, setKEY, setLabel, setLABEL, setLOCKED, setREGISTRYNAME, setSheet, setSHRINKTOFIT, setSTYLENAME, setUseBGColor, setUSEBGCOLOR, setUSEDECIMALSPERCENTAGE, setUseHeadColor, setUSEHEADCOLOR, setVALIGN, setWRAP, useBGColor, useDecimalsPercentage, useHeaderColor

Methods inherited from class overit.geocall.platform.ui.UINode

addChild, addChildText, getChildren, getNodeId, getParent, getRoot, getSchema, setNodeId, setParent, setSchema

Methods inherited from class java.lang.Object

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

Methods inherited from interface overit.geocall.basic.ui.xlsx.XlsxElement

getWarning

Field Details

_dbs

protected DBStatement _dbs

_dbStatementRow

protected int _dbStatementRow

_objectmap

protected DBObjectMap _objectmap

_poiValuesModificator

protected IXlsxValueModificator _poiValuesModificator

_resultSet

protected ResultSet _resultSet

_definitions

protected HashMap _definitions

_maxSheetRows

protected int _maxSheetRows

_maxRows

protected int _maxRows

Constructor Details

XlsxDBStatementView

public XlsxDBStatementView()

Method Details

setMAXROWS

public void setMAXROWS(String s)

Sets the max number of rows.

Parameters:

s - The max number to set.

setMAXSHEETROWS

public void setMAXSHEETROWS(String s)

Sets the maximum limit of row for the sheet

Parameters:

s - Maximum number of row

getDBObjectMap

public DBObjectMap getDBObjectMap()

Implementation of the DBObjectMapper interface. Returns the DBObjectMap inside the instance.

Specified by:

getDBObjectMap in interface DBObjectMapper

Returns:

The DBObjectMap inside the instance.

getDBStatement

public DBStatement getDBStatement()

Gets the DBStatement.

Returns:

The DBStatement.

setDBObjectMap

public void setDBObjectMap(DBObjectMap objectmap)

Implementation of the DBObjectMapper interface. Sets the DBObjectMap inside the instance

Specified by:

setDBObjectMap in interface DBObjectMapper

Parameters:

objectmap - The DBObjectMap

setDataView

public void setDataView(Object dbstatement)

Needs a DBStatement

Overrides:

setDataView in class XlsxTableView

Parameters:

dbstatement - The DBStatement

define

public void define(String field,
 DBObjectMap dbom)

setXlsValuesModificator

public void setXlsValuesModificator(IXlsxValueModificator valuesModificator)

Sets the IXlsxValueModificator.

Parameters:

valuesModificator - The IXlsxValueModificator object to set.

getContent

public void getContent(org.apache.poi.ss.usermodel.Sheet sheet,
 int startrow,
 int startCol)
                throws Exception

Specified by:

getContent in interface XlsxElement

Overrides:

getContent in class XlsxTableView

Throws:

Exception

addCells

protected int addCells(int startRow,
 int startCol,
 ResultSet rs,
 org.apache.poi.ss.usermodel.Sheet sheet)
                throws SQLException,
Exception

Throws:

SQLException

Exception

getRow

protected ArrayList getRow(ResultSet rs,
 ResultSetMetaData rsmd,
 int columnCont)
                    throws SQLException

Throws:

SQLException

haveDBObjectMap

public boolean haveDBObjectMap()

Description copied from interface: DBObjectMapper

Checks the presence of a valid DBObjectMap contained in the instance.

Specified by:

haveDBObjectMap in interface DBObjectMapper

Returns:

true if the instance contains a map of object that is not null, false otherwise

isCellToAdd

protected boolean isCellToAdd(ResultSet _rs)
                       throws SQLException

Deprecated.

Implement the interface IXlsValuesModificator and use setXlsValuesModificator(overit.geocall.basic.ui.xlsx.IXlsxValueModificator)

Parameters:

_rs - Implement the interface IXlsValuesModificator and use setXlsValuesModificator(overit.geocall.basic.ui.xlsx.IXlsxValueModificator)

Returns:

Implement the interface IXlsValuesModificator and use setXlsValuesModificator(overit.geocall.basic.ui.xlsx.IXlsxValueModificator)

Throws:

SQLException - Implement the interface IXlsValuesModificator and use setXlsValuesModificator(overit.geocall.basic.ui.xlsx.IXlsxValueModificator)