API 7.2-SNAPSHOT

    Base Package: com.sqlsheet

    e.sqlsheet

    Driver

    extends: XlsDriver

    sqlsheet implementation of java.sql.Driver.
    Driver ()

    Base

    ResultSetImpl

    extends: Object implements: ResultSet

    ResultSetImpl (columns)
    Object columns
    addRow (data)
    Object data
    @Override
    next () → boolean
    returns boolean
    @Override
    close ()
    @Override
    wasNull () → boolean
    returns boolean
    @Override
    getString (columnIndex) → String
    int columnIndex
    returns String
    @Override
    getBoolean (columnIndex) → boolean
    int columnIndex
    returns boolean
    @Override
    getByte (columnIndex) → byte
    int columnIndex
    returns byte
    @Override
    getShort (columnIndex) → short
    int columnIndex
    returns short
    @Override
    getInt (columnIndex) → int
    int columnIndex
    returns int
    @Override
    getLong (columnIndex) → long
    int columnIndex
    returns long
    @Override
    getFloat (columnIndex) → float
    int columnIndex
    returns float
    @Override
    getDouble (columnIndex) → double
    int columnIndex
    returns double
    @Override
    getBigDecimal (columnIndex, scale) → BigDecimal
    int columnIndex
    int scale
    returns BigDecimal
    @Override
    getBytes (columnIndex) → byte
    int columnIndex
    returns byte
    @Override
    getDate (columnIndex) → Date
    int columnIndex
    returns Date
    @Override
    getTime (columnIndex) → Time
    int columnIndex
    returns Time
    @Override
    getTimestamp (columnIndex) → Timestamp
    int columnIndex
    returns Timestamp
    @Override
    getAsciiStream (columnIndex) → InputStream
    int columnIndex
    returns InputStream
    @Override
    getUnicodeStream (columnIndex) → InputStream
    int columnIndex
    returns InputStream
    @Override
    getBinaryStream (columnIndex) → InputStream
    int columnIndex
    returns InputStream
    @Override
    getString (columnLabel) → String
    String columnLabel
    returns String
    @Override
    getBoolean (columnLabel) → boolean
    String columnLabel
    returns boolean
    @Override
    getByte (columnLabel) → byte
    String columnLabel
    returns byte
    @Override
    getShort (columnLabel) → short
    String columnLabel
    returns short
    @Override
    getInt (columnLabel) → int
    String columnLabel
    returns int
    @Override
    getLong (columnLabel) → long
    String columnLabel
    returns long
    @Override
    getFloat (columnLabel) → float
    String columnLabel
    returns float
    @Override
    getDouble (columnLabel) → double
    String columnLabel
    returns double
    @Override
    getBigDecimal (columnLabel, scale) → BigDecimal
    String columnLabel
    int scale
    returns BigDecimal
    @Override
    getBytes (columnLabel) → byte
    String columnLabel
    returns byte
    @Override
    getDate (columnLabel) → Date
    String columnLabel
    returns Date
    @Override
    getTime (columnLabel) → Time
    String columnLabel
    returns Time
    @Override
    getTimestamp (columnLabel) → Timestamp
    String columnLabel
    returns Timestamp
    @Override
    getAsciiStream (columnLabel) → InputStream
    String columnLabel
    returns InputStream
    @Override
    getUnicodeStream (columnLabel) → InputStream
    String columnLabel
    returns InputStream
    @Override
    getBinaryStream (columnLabel) → InputStream
    String columnLabel
    returns InputStream
    @Override
    getWarnings () → SQLWarning
    returns SQLWarning
    @Override
    clearWarnings ()
    @Override
    getCursorName () → String
    returns String
    @Override
    getMetaData () → ResultSetMetaData
    returns ResultSetMetaData
    @Override
    getObject (columnIndex) → Object
    int columnIndex
    returns Object
    @Override
    getObject (columnLabel) → Object
    String columnLabel
    returns Object
    @Override
    findColumn (columnLabel) → int
    String columnLabel
    returns int
    @Override
    getCharacterStream (columnIndex) → Reader
    int columnIndex
    returns Reader
    @Override
    getCharacterStream (columnLabel) → Reader
    String columnLabel
    returns Reader
    @Override
    getBigDecimal (columnIndex) → BigDecimal
    int columnIndex
    returns BigDecimal
    @Override
    getBigDecimal (columnLabel) → BigDecimal
    String columnLabel
    returns BigDecimal
    @Override
    isBeforeFirst () → boolean
    returns boolean
    @Override
    isAfterLast () → boolean
    returns boolean
    @Override
    isFirst () → boolean
    returns boolean
    @Override
    isLast () → boolean
    returns boolean
    @Override
    beforeFirst ()
    @Override
    afterLast ()
    @Override
    first () → boolean
    returns boolean
    @Override
    last () → boolean
    returns boolean
    @Override
    getRow () → int
    returns int
    @Override
    absolute (row) → boolean
    int row
    returns boolean
    @Override
    relative (rows) → boolean
    int rows
    returns boolean
    @Override
    previous () → boolean
    returns boolean
    @Override
    getFetchDirection () → int
    returns int
    @Override
    setFetchDirection (direction)
    int direction
    @Override
    getFetchSize () → int
    returns int
    @Override
    setFetchSize (rows)
    int rows
    @Override
    getType () → int
    returns int
    @Override
    getConcurrency () → int
    returns int
    @Override
    rowUpdated () → boolean
    returns boolean
    @Override
    rowInserted () → boolean
    returns boolean
    @Override
    rowDeleted () → boolean
    returns boolean
    @Override
    updateNull (columnIndex)
    int columnIndex
    @Override
    updateBoolean (columnIndex, x)
    int columnIndex
    boolean x
    @Override
    updateByte (columnIndex, x)
    int columnIndex
    byte x
    @Override
    updateShort (columnIndex, x)
    int columnIndex
    short x
    @Override
    updateInt (columnIndex, x)
    int columnIndex
    int x
    @Override
    updateLong (columnIndex, x)
    int columnIndex
    long x
    @Override
    updateFloat (columnIndex, x)
    int columnIndex
    float x
    @Override
    updateDouble (columnIndex, x)
    int columnIndex
    double x
    @Override
    updateBigDecimal (columnIndex, x)
    int columnIndex
    BigDecimal x
    @Override
    updateString (columnIndex, x)
    int columnIndex
    String x
    @Override
    updateBytes (columnIndex, x)
    int columnIndex
    byte x
    @Override
    updateDate (columnIndex, x)
    int columnIndex
    Date x
    @Override
    updateTime (columnIndex, x)
    int columnIndex
    Time x
    @Override
    updateTimestamp (columnIndex, x)
    int columnIndex
    Timestamp x
    @Override
    updateAsciiStream (columnIndex, x, length)
    int columnIndex
    InputStream x
    int length
    @Override
    updateBinaryStream (columnIndex, x, length)
    int columnIndex
    InputStream x
    int length
    @Override
    updateCharacterStream (columnIndex, x, length)
    int columnIndex
    Reader x
    int length
    @Override
    updateObject (columnIndex, x, scaleOrLength)
    int columnIndex
    Object x
    int scaleOrLength
    @Override
    updateObject (columnIndex, x)
    int columnIndex
    Object x
    @Override
    updateNull (columnLabel)
    String columnLabel
    @Override
    updateBoolean (columnLabel, x)
    String columnLabel
    boolean x
    @Override
    updateByte (columnLabel, x)
    String columnLabel
    byte x
    @Override
    updateShort (columnLabel, x)
    String columnLabel
    short x
    @Override
    updateInt (columnLabel, x)
    String columnLabel
    int x
    @Override
    updateLong (columnLabel, x)
    String columnLabel
    long x
    @Override
    updateFloat (columnLabel, x)
    String columnLabel
    float x
    @Override
    updateDouble (columnLabel, x)
    String columnLabel
    double x
    @Override
    updateBigDecimal (columnLabel, x)
    String columnLabel
    BigDecimal x
    @Override
    updateString (columnLabel, x)
    String columnLabel
    String x
    @Override
    updateBytes (columnLabel, x)
    String columnLabel
    byte x
    @Override
    updateDate (columnLabel, x)
    String columnLabel
    Date x
    @Override
    updateTime (columnLabel, x)
    String columnLabel
    Time x
    @Override
    updateTimestamp (columnLabel, x)
    String columnLabel
    Timestamp x
    @Override
    updateAsciiStream (columnLabel, x, length)
    String columnLabel
    InputStream x
    int length
    @Override
    updateBinaryStream (columnLabel, x, length)
    String columnLabel
    InputStream x
    int length
    @Override
    updateCharacterStream (columnLabel, reader, length)
    String columnLabel
    Reader reader
    int length
    @Override
    updateObject (columnLabel, x, scaleOrLength)
    String columnLabel
    Object x
    int scaleOrLength
    @Override
    updateObject (columnLabel, x)
    String columnLabel
    Object x
    @Override
    insertRow ()
    @Override
    updateRow ()
    @Override
    deleteRow ()
    @Override
    refreshRow ()
    @Override
    cancelRowUpdates ()
    @Override
    moveToInsertRow ()
    @Override
    moveToCurrentRow ()
    @Override
    getStatement () → Statement
    returns Statement
    @Override
    getObject (columnIndex, map) → Object
    int columnIndex
    Map map
    returns Object
    @Override
    getRef (columnIndex) → Ref
    int columnIndex
    returns Ref
    @Override
    getBlob (columnIndex) → Blob
    int columnIndex
    returns Blob
    @Override
    getClob (columnIndex) → Clob
    int columnIndex
    returns Clob
    @Override
    getArray (columnIndex) → Array
    int columnIndex
    returns Array
    @Override
    getObject (columnLabel, map) → Object
    String columnLabel
    Map map
    returns Object
    @Override
    getRef (columnLabel) → Ref
    String columnLabel
    returns Ref
    @Override
    getBlob (columnLabel) → Blob
    String columnLabel
    returns Blob
    @Override
    getClob (columnLabel) → Clob
    String columnLabel
    returns Clob
    @Override
    getArray (columnLabel) → Array
    String columnLabel
    returns Array
    @Override
    getDate (columnIndex, cal) → Date
    int columnIndex
    Calendar cal
    returns Date
    @Override
    getDate (columnLabel, cal) → Date
    String columnLabel
    Calendar cal
    returns Date
    @Override
    getTime (columnIndex, cal) → Time
    int columnIndex
    Calendar cal
    returns Time
    @Override
    getTime (columnLabel, cal) → Time
    String columnLabel
    Calendar cal
    returns Time
    @Override
    getTimestamp (columnIndex, cal) → Timestamp
    int columnIndex
    Calendar cal
    returns Timestamp
    @Override
    getTimestamp (columnLabel, cal) → Timestamp
    String columnLabel
    Calendar cal
    returns Timestamp
    @Override
    getURL (columnIndex) → URL
    int columnIndex
    returns URL
    @Override
    getURL (columnLabel) → URL
    String columnLabel
    returns URL
    @Override
    updateRef (columnIndex, x)
    int columnIndex
    Ref x
    @Override
    updateRef (columnLabel, x)
    String columnLabel
    Ref x
    @Override
    updateBlob (columnIndex, x)
    int columnIndex
    Blob x
    @Override
    updateBlob (columnLabel, x)
    String columnLabel
    Blob x
    @Override
    updateClob (columnIndex, x)
    int columnIndex
    Clob x
    @Override
    updateClob (columnLabel, x)
    String columnLabel
    Clob x
    @Override
    updateArray (columnIndex, x)
    int columnIndex
    Array x
    @Override
    updateArray (columnLabel, x)
    String columnLabel
    Array x
    @Override
    getRowId (columnIndex) → RowId
    int columnIndex
    returns RowId
    @Override
    getRowId (columnLabel) → RowId
    String columnLabel
    returns RowId
    @Override
    updateRowId (columnIndex, x)
    int columnIndex
    RowId x
    @Override
    updateRowId (columnLabel, x)
    String columnLabel
    RowId x
    @Override
    getHoldability () → int
    returns int
    @Override
    isClosed () → boolean
    returns boolean
    @Override
    updateNString (columnIndex, nString)
    int columnIndex
    String nString
    @Override
    updateNString (columnLabel, nString)
    String columnLabel
    String nString
    @Override
    updateNClob (columnIndex, nClob)
    int columnIndex
    NClob nClob
    @Override
    updateNClob (columnLabel, nClob)
    String columnLabel
    NClob nClob
    @Override
    getNClob (columnIndex) → NClob
    int columnIndex
    returns NClob
    @Override
    getNClob (columnLabel) → NClob
    String columnLabel
    returns NClob
    @Override
    getSQLXML (columnIndex) → SQLXML
    int columnIndex
    returns SQLXML
    @Override
    getSQLXML (columnLabel) → SQLXML
    String columnLabel
    returns SQLXML
    @Override
    updateSQLXML (columnIndex, xmlObject)
    int columnIndex
    SQLXML xmlObject
    @Override
    updateSQLXML (columnLabel, xmlObject)
    String columnLabel
    SQLXML xmlObject
    @Override
    getNString (columnIndex) → String
    int columnIndex
    returns String
    @Override
    getNString (columnLabel) → String
    String columnLabel
    returns String
    @Override
    getNCharacterStream (columnIndex) → Reader
    int columnIndex
    returns Reader
    @Override
    getNCharacterStream (columnLabel) → Reader
    String columnLabel
    returns Reader
    @Override
    updateNCharacterStream (columnIndex, x, length)
    int columnIndex
    Reader x
    long length
    @Override
    updateNCharacterStream (columnLabel, reader, length)
    String columnLabel
    Reader reader
    long length
    @Override
    updateAsciiStream (columnIndex, x, length)
    int columnIndex
    InputStream x
    long length
    @Override
    updateBinaryStream (columnIndex, x, length)
    int columnIndex
    InputStream x
    long length
    @Override
    updateCharacterStream (columnIndex, x, length)
    int columnIndex
    Reader x
    long length
    @Override
    updateAsciiStream (columnLabel, x, length)
    String columnLabel
    InputStream x
    long length
    @Override
    updateBinaryStream (columnLabel, x, length)
    String columnLabel
    InputStream x
    long length
    @Override
    updateCharacterStream (columnLabel, reader, length)
    String columnLabel
    Reader reader
    long length
    @Override
    updateBlob (columnIndex, inputStream, length)
    int columnIndex
    InputStream inputStream
    long length
    @Override
    updateBlob (columnLabel, inputStream, length)
    String columnLabel
    InputStream inputStream
    long length
    @Override
    updateClob (columnIndex, reader, length)
    int columnIndex
    Reader reader
    long length
    @Override
    updateClob (columnLabel, reader, length)
    String columnLabel
    Reader reader
    long length
    @Override
    updateNClob (columnIndex, reader, length)
    int columnIndex
    Reader reader
    long length
    @Override
    updateNClob (columnLabel, reader, length)
    String columnLabel
    Reader reader
    long length
    @Override
    updateNCharacterStream (columnIndex, x)
    int columnIndex
    Reader x
    @Override
    updateNCharacterStream (columnLabel, reader)
    String columnLabel
    Reader reader
    @Override
    updateAsciiStream (columnIndex, x)
    int columnIndex
    InputStream x
    @Override
    updateBinaryStream (columnIndex, x)
    int columnIndex
    InputStream x
    @Override
    updateCharacterStream (columnIndex, x)
    int columnIndex
    Reader x
    @Override
    updateAsciiStream (columnLabel, x)
    String columnLabel
    InputStream x
    @Override
    updateBinaryStream (columnLabel, x)
    String columnLabel
    InputStream x
    @Override
    updateCharacterStream (columnLabel, reader)
    String columnLabel
    Reader reader
    @Override
    updateBlob (columnIndex, inputStream)
    int columnIndex
    InputStream inputStream
    @Override
    updateBlob (columnLabel, inputStream)
    String columnLabel
    InputStream inputStream
    @Override
    updateClob (columnIndex, reader)
    int columnIndex
    Reader reader
    @Override
    updateClob (columnLabel, reader)
    String columnLabel
    Reader reader
    @Override
    updateNClob (columnIndex, reader)
    int columnIndex
    Reader reader
    @Override
    updateNClob (columnLabel, reader)
    String columnLabel
    Reader reader
    @Override
    getObject (columnIndex, type) → T
    int columnIndex
    Class type
    returns T
    @Override
    getObject (columnLabel, type) → T
    String columnLabel
    Class type
    returns T
    @Override
    unwrap (iface) → T
    Class iface
    returns T
    @Override
    isWrapperFor (iface) → boolean
    Class iface
    returns boolean

    XlsDatabaseMetaData

    extends: Object implements: DatabaseMetaData

    XlsDatabaseMetaData (connection)
    XlsConnection connection
    @Override
    allProceduresAreCallable () → boolean
    returns boolean
    @Override
    allTablesAreSelectable () → boolean
    returns boolean
    @Override
    getURL () → String
    returns String
    @Override
    getUserName () → String
    returns String
    @Override
    isReadOnly () → boolean
    returns boolean
    @Override
    nullsAreSortedHigh () → boolean
    returns boolean
    @Override
    nullsAreSortedLow () → boolean
    returns boolean
    @Override
    nullsAreSortedAtStart () → boolean
    returns boolean
    @Override
    nullsAreSortedAtEnd () → boolean
    returns boolean
    @Override
    getDatabaseProductName () → String
    returns String
    @Override
    getDatabaseProductVersion () → String
    returns String
    @Override
    getDriverName () → String
    returns String
    @Override
    getDriverVersion () → String
    returns String
    @Override
    getDriverMajorVersion () → int
    returns int
    @Override
    getDriverMinorVersion () → int
    returns int
    @Override
    usesLocalFiles () → boolean
    returns boolean
    @Override
    usesLocalFilePerTable () → boolean
    returns boolean
    @Override
    supportsMixedCaseIdentifiers () → boolean
    returns boolean
    @Override
    storesUpperCaseIdentifiers () → boolean
    returns boolean
    @Override
    storesLowerCaseIdentifiers () → boolean
    returns boolean
    @Override
    storesMixedCaseIdentifiers () → boolean
    returns boolean
    @Override
    supportsMixedCaseQuotedIdentifiers () → boolean
    returns boolean
    @Override
    storesUpperCaseQuotedIdentifiers () → boolean
    returns boolean
    @Override
    storesLowerCaseQuotedIdentifiers () → boolean
    returns boolean
    @Override
    storesMixedCaseQuotedIdentifiers () → boolean
    returns boolean
    @Override
    getIdentifierQuoteString () → String
    returns String
    @Override
    getSQLKeywords () → String
    returns String
    @Override
    getNumericFunctions () → String
    returns String
    @Override
    getStringFunctions () → String
    returns String
    @Override
    getSystemFunctions () → String
    returns String
    @Override
    getTimeDateFunctions () → String
    returns String
    @Override
    getSearchStringEscape () → String
    returns String
    @Override
    getExtraNameCharacters () → String
    returns String
    @Override
    supportsAlterTableWithAddColumn () → boolean
    returns boolean
    @Override
    supportsAlterTableWithDropColumn () → boolean
    returns boolean
    @Override
    supportsColumnAliasing () → boolean
    returns boolean
    @Override
    nullPlusNonNullIsNull () → boolean
    returns boolean
    @Override
    supportsConvert () → boolean
    returns boolean
    @Override
    supportsConvert (i, i1) → boolean
    int i
    int i1
    returns boolean
    @Override
    supportsTableCorrelationNames () → boolean
    returns boolean
    @Override
    supportsDifferentTableCorrelationNames () → boolean
    returns boolean
    @Override
    supportsExpressionsInOrderBy () → boolean
    returns boolean
    @Override
    supportsOrderByUnrelated () → boolean
    returns boolean
    @Override
    supportsGroupBy () → boolean
    returns boolean
    @Override
    supportsGroupByUnrelated () → boolean
    returns boolean
    @Override
    supportsGroupByBeyondSelect () → boolean
    returns boolean
    @Override
    supportsLikeEscapeClause () → boolean
    returns boolean
    @Override
    supportsMultipleResultSets () → boolean
    returns boolean
    @Override
    supportsMultipleTransactions () → boolean
    returns boolean
    @Override
    supportsNonNullableColumns () → boolean
    returns boolean
    @Override
    supportsMinimumSQLGrammar () → boolean
    returns boolean
    @Override
    supportsCoreSQLGrammar () → boolean
    returns boolean
    @Override
    supportsExtendedSQLGrammar () → boolean
    returns boolean
    @Override
    supportsANSI92EntryLevelSQL () → boolean
    returns boolean
    @Override
    supportsANSI92IntermediateSQL () → boolean
    returns boolean
    @Override
    supportsANSI92FullSQL () → boolean
    returns boolean
    @Override
    supportsIntegrityEnhancementFacility () → boolean
    returns boolean
    @Override
    supportsOuterJoins () → boolean
    returns boolean
    @Override
    supportsFullOuterJoins () → boolean
    returns boolean
    @Override
    supportsLimitedOuterJoins () → boolean
    returns boolean
    @Override
    getSchemaTerm () → String
    returns String
    @Override
    getProcedureTerm () → String
    returns String
    @Override
    getCatalogTerm () → String
    returns String
    @Override
    isCatalogAtStart () → boolean
    returns boolean
    @Override
    getCatalogSeparator () → String
    returns String
    @Override
    supportsSchemasInDataManipulation () → boolean
    returns boolean
    @Override
    supportsSchemasInProcedureCalls () → boolean
    returns boolean
    @Override
    supportsSchemasInTableDefinitions () → boolean
    returns boolean
    @Override
    supportsSchemasInIndexDefinitions () → boolean
    returns boolean
    @Override
    supportsSchemasInPrivilegeDefinitions () → boolean
    returns boolean
    @Override
    supportsCatalogsInDataManipulation () → boolean
    returns boolean
    @Override
    supportsCatalogsInProcedureCalls () → boolean
    returns boolean
    @Override
    supportsCatalogsInTableDefinitions () → boolean
    returns boolean
    @Override
    supportsCatalogsInIndexDefinitions () → boolean
    returns boolean
    @Override
    supportsCatalogsInPrivilegeDefinitions () → boolean
    returns boolean
    @Override
    supportsPositionedDelete () → boolean
    returns boolean
    @Override
    supportsPositionedUpdate () → boolean
    returns boolean
    @Override
    supportsSelectForUpdate () → boolean
    returns boolean
    @Override
    supportsStoredProcedures () → boolean
    returns boolean
    @Override
    supportsSubqueriesInComparisons () → boolean
    returns boolean
    @Override
    supportsSubqueriesInExists () → boolean
    returns boolean
    @Override
    supportsSubqueriesInIns () → boolean
    returns boolean
    @Override
    supportsSubqueriesInQuantifieds () → boolean
    returns boolean
    @Override
    supportsCorrelatedSubqueries () → boolean
    returns boolean
    @Override
    supportsUnion () → boolean
    returns boolean
    @Override
    supportsUnionAll () → boolean
    returns boolean
    @Override
    supportsOpenCursorsAcrossCommit () → boolean
    returns boolean
    @Override
    supportsOpenCursorsAcrossRollback () → boolean
    returns boolean
    @Override
    supportsOpenStatementsAcrossCommit () → boolean
    returns boolean
    @Override
    supportsOpenStatementsAcrossRollback () → boolean
    returns boolean
    @Override
    getMaxBinaryLiteralLength () → int
    returns int
    @Override
    getMaxCharLiteralLength () → int
    returns int
    @Override
    getMaxColumnNameLength () → int
    returns int
    @Override
    getMaxColumnsInGroupBy () → int
    returns int
    @Override
    getMaxColumnsInIndex () → int
    returns int
    @Override
    getMaxColumnsInOrderBy () → int
    returns int
    @Override
    getMaxColumnsInSelect () → int
    returns int
    @Override
    getMaxColumnsInTable () → int
    returns int
    @Override
    getMaxConnections () → int
    returns int
    @Override
    getMaxCursorNameLength () → int
    returns int
    @Override
    getMaxIndexLength () → int
    returns int
    @Override
    getMaxSchemaNameLength () → int
    returns int
    @Override
    getMaxProcedureNameLength () → int
    returns int
    @Override
    getMaxCatalogNameLength () → int
    returns int
    @Override
    getMaxRowSize () → int
    returns int
    @Override
    doesMaxRowSizeIncludeBlobs () → boolean
    returns boolean
    @Override
    getMaxStatementLength () → int
    returns int
    @Override
    getMaxStatements () → int
    returns int
    @Override
    getMaxTableNameLength () → int
    returns int
    @Override
    getMaxTablesInSelect () → int
    returns int
    @Override
    getMaxUserNameLength () → int
    returns int
    @Override
    getDefaultTransactionIsolation () → int
    returns int
    @Override
    supportsTransactions () → boolean
    returns boolean
    @Override
    supportsTransactionIsolationLevel (i) → boolean
    int i
    returns boolean
    @Override
    supportsDataDefinitionAndDataManipulationTransactions () → boolean
    returns boolean
    @Override
    supportsDataManipulationTransactionsOnly () → boolean
    returns boolean
    @Override
    dataDefinitionCausesTransactionCommit () → boolean
    returns boolean
    @Override
    dataDefinitionIgnoredInTransactions () → boolean
    returns boolean
    @Override
    getProcedures (string, string1, string2) → ResultSet
    String string
    String string1
    String string2
    returns ResultSet
    @Override
    getProcedureColumns (string, string1, string2, string3) → ResultSet
    String string
    String string1
    String string2
    String string3
    returns ResultSet
    @Override
    getTables (catalog, schemaPattern, tableNamePattern, types) → ResultSet
    String catalog
    String schemaPattern
    String tableNamePattern
    String types
    returns ResultSet
    @Override
    getSchemas () → ResultSet
    returns ResultSet
    @Override
    getCatalogs () → ResultSet
    returns ResultSet
    @Override
    getTableTypes () → ResultSet
    returns ResultSet
    @Override,| @SuppressWarnings
    getColumns (catalog, schemaPattern, tableNamePattern, columnNamePattern) → ResultSet
    String catalog
    String schemaPattern
    String tableNamePattern
    String columnNamePattern
    returns ResultSet
    @Override
    getColumnPrivileges (string, string1, string2, string3) → ResultSet
    String string
    String string1
    String string2
    String string3
    returns ResultSet
    @Override
    getTablePrivileges (string, string1, string2) → ResultSet
    String string
    String string1
    String string2
    returns ResultSet
    @Override
    getBestRowIdentifier (string, string1, string2, i, bln) → ResultSet
    String string
    String string1
    String string2
    int i
    boolean bln
    returns ResultSet
    @Override
    getVersionColumns (string, string1, string2) → ResultSet
    String string
    String string1
    String string2
    returns ResultSet
    @Override
    getPrimaryKeys (catalog, schema, table) → ResultSet
    String catalog
    String schema
    String table
    returns ResultSet
    @Override
    getImportedKeys (catalog, schema, table) → ResultSet
    String catalog
    String schema
    String table
    returns ResultSet
    @Override
    getExportedKeys (catalog, schema, table) → ResultSet
    String catalog
    String schema
    String table
    returns ResultSet
    @Override
    getCrossReference (parentCatalog, parentSchema, parentTable, foreignCatalog, foreignSchema, foreignTable) → ResultSet
    String parentCatalog
    String parentSchema
    String parentTable
    String foreignCatalog
    String foreignSchema
    String foreignTable
    returns ResultSet
    @Override
    getTypeInfo () → ResultSet
    returns ResultSet
    @Override
    getIndexInfo (catalog, schema, table, unique, approximate) → ResultSet
    String catalog
    String schema
    String table
    boolean unique
    boolean approximate
    returns ResultSet
    @Override
    supportsResultSetType (i) → boolean
    int i
    returns boolean
    @Override
    supportsResultSetConcurrency (i, i1) → boolean
    int i
    int i1
    returns boolean
    @Override
    ownUpdatesAreVisible (i) → boolean
    int i
    returns boolean
    @Override
    ownDeletesAreVisible (i) → boolean
    int i
    returns boolean
    @Override
    ownInsertsAreVisible (i) → boolean
    int i
    returns boolean
    @Override
    othersUpdatesAreVisible (i) → boolean
    int i
    returns boolean
    @Override
    othersDeletesAreVisible (i) → boolean
    int i
    returns boolean
    @Override
    othersInsertsAreVisible (i) → boolean
    int i
    returns boolean
    @Override
    updatesAreDetected (i) → boolean
    int i
    returns boolean
    @Override
    deletesAreDetected (i) → boolean
    int i
    returns boolean
    @Override
    insertsAreDetected (i) → boolean
    int i
    returns boolean
    @Override
    supportsBatchUpdates () → boolean
    returns boolean
    @Override
    getUDTs (string, string1, string2, ints) → ResultSet
    String string
    String string1
    String string2
    int ints
    returns ResultSet
    @Override
    getConnection () → Connection
    returns Connection
    @Override
    supportsSavepoints () → boolean
    returns boolean
    @Override
    supportsNamedParameters () → boolean
    returns boolean
    @Override
    supportsMultipleOpenResults () → boolean
    returns boolean
    @Override
    supportsGetGeneratedKeys () → boolean
    returns boolean
    @Override
    getSuperTypes (string, string1, string2) → ResultSet
    String string
    String string1
    String string2
    returns ResultSet
    @Override
    getSuperTables (string, string1, string2) → ResultSet
    String string
    String string1
    String string2
    returns ResultSet
    @Override
    getAttributes (string, string1, string2, string3) → ResultSet
    String string
    String string1
    String string2
    String string3
    returns ResultSet
    @Override
    supportsResultSetHoldability (i) → boolean
    int i
    returns boolean
    @Override
    getResultSetHoldability () → int
    returns int
    @Override
    getDatabaseMajorVersion () → int
    returns int
    @Override
    getDatabaseMinorVersion () → int
    returns int
    @Override
    getJDBCMajorVersion () → int
    returns int
    @Override
    getJDBCMinorVersion () → int
    returns int
    @Override
    getSQLStateType () → int
    returns int
    @Override
    locatorsUpdateCopy () → boolean
    returns boolean
    @Override
    supportsStatementPooling () → boolean
    returns boolean
    @Override
    getRowIdLifetime () → RowIdLifetime
    returns RowIdLifetime
    @Override
    getSchemas (catalog, schemaPattern) → ResultSet
    String catalog
    String schemaPattern
    returns ResultSet
    @Override
    supportsStoredFunctionsUsingCallSyntax () → boolean
    returns boolean
    @Override
    autoCommitFailureClosesAllResultSets () → boolean
    returns boolean
    @Override
    getClientInfoProperties () → ResultSet
    returns ResultSet
    @Override
    getFunctions (string, string1, string2) → ResultSet
    String string
    String string1
    String string2
    returns ResultSet
    @Override
    getFunctionColumns (string, string1, string2, string3) → ResultSet
    String string
    String string1
    String string2
    String string3
    returns ResultSet
    @Override
    getPseudoColumns (string, string1, string2, string3) → ResultSet
    String string
    String string1
    String string2
    String string3
    returns ResultSet
    @Override
    generatedKeyAlwaysReturned () → boolean
    returns boolean
    @Override
    unwrap (type) → T
    Class type
    returns T
    @Override
    isWrapperFor (type) → boolean
    Class type
    returns boolean

    XlsDriver

    extends: Object implements: Driver provides: Driver, XlsDriver

    SqlSheet implementation of java.sql.Driver.
    XlsDriver ()
    getHomeFolder () → File
    returns File | the actual $HOME folder of the user
    resolveHomeUriStr (uriStr) → String
    String uriStr | uriStr the String representation of an URI containing “~” or “${user.home}”
    returns String | the expanded URI (resolving “~” and “${user.home}” to the actual $HOME folder
    @Override
    getPropertyInfo (url, info) → DriverPropertyInfo
    String url
    Properties info
    returns DriverPropertyInfo
    @SuppressWarnings
    connect (url, info) → Connection
    Attempts to make a database connection to the given URL. The driver should return “null” if it realizes it is the wrong kind of driver to connect to the given URL. This will be common, as when the JDBC driver manager is asked to connect to a given URL it passes the URL to each loaded driver in turn.
    The driver should throw an SQLException if it is the right driver to connect to the given URL but has trouble connecting to the database.
    The url should point to a file or a resource in the class path.
    Valid samples are: ul li``jdbc:xls:file://${user.home}/dataSource.xlsx ``li``jdbc:xls:file://~/dataSource.xlsx ``li``jdbc:xls:resource:/com/sqlsheet/dataSource.xlsx ``/ul
    The Properties argument can be used to pass arbitrary string tag/value pairs as connection arguments. Normally at least “user” and “password” properties should be included in the Properties object.
    B``Note:/B`` If a property is specified as part of the url and is also specified in the Properties object, it is implementation-defined as to which value will take precedence. For maximum portability, an application should only specify a property once.
    String url | url the URL of the database to which to connect
    Properties info | info a list of arbitrary string tag/value pairs as connection arguments. Normally at least a “user” and “password” property should be included.
    returns Connection | a Connection object that represents a connection to the URL
    acceptsURL (url) → boolean
    String url
    returns boolean
    jdbcCompliant () → boolean
    returns boolean
    getMajorVersion () → int
    returns int
    getMinorVersion () → int
    returns int
    getParentLogger () → Logger
    returns Logger

    XlsPreparedStatement

    extends: XlsStatement implements: PreparedStatement

    SqlSheet implementation of java.sql.PreparedStatement.
    XlsPreparedStatement (conn, sql)
    XlsConnection conn
    String sql
    addBatch ()
    clearParameters ()
    execute () → boolean
    returns boolean
    executeUpdate () → int
    returns int
    executeQuery () → ResultSet
    returns ResultSet
    setBigDecimal (arg0, arg1)
    int arg0
    BigDecimal arg1
    setBoolean (arg0, arg1)
    int arg0
    boolean arg1
    setByte (arg0, arg1)
    int arg0
    byte arg1
    setDate (arg0, arg1)
    int arg0
    Date arg1
    setDouble (arg0, arg1)
    int arg0
    double arg1
    setFloat (arg0, arg1)
    int arg0
    float arg1
    setInt (arg0, arg1)
    int arg0
    int arg1
    setLong (arg0, arg1)
    int arg0
    long arg1
    setNull (arg0, arg1)
    int arg0
    int arg1
    setNull (arg0, arg1, arg2)
    int arg0
    int arg1
    String arg2
    setShort (arg0, arg1)
    int arg0
    short arg1
    setString (arg0, arg1)
    int arg0
    String arg1
    setTime (arg0, arg1)
    int arg0
    Time arg1
    setTimestamp (arg0, arg1)
    int arg0
    Timestamp arg1
    setCharacterStream (parameterIndex, reader, length)
    int parameterIndex
    Reader reader
    int length
    setObject (arg0, arg1)
    int arg0
    Object arg1
    setTimestamp (arg0, arg1, arg2)
    int arg0
    Timestamp arg1
    Calendar arg2
    setTime (arg0, arg1, arg2)
    int arg0
    Time arg1
    Calendar arg2
    setArray (arg0, arg1)
    int arg0
    Array arg1
    setAsciiStream (arg0, arg1, arg2)
    int arg0
    InputStream arg1
    int arg2
    setDate (arg0, arg1, arg2)
    int arg0
    Date arg1
    Calendar arg2
    setBytes (arg0, arg1)
    int arg0
    byte arg1
    setClob (arg0, arg1)
    int arg0
    Clob arg1
    setObject (arg0, arg1, arg2)
    int arg0
    Object arg1
    int arg2
    setObject (arg0, arg1, arg2, arg3)
    int arg0
    Object arg1
    int arg2
    int arg3
    setAsciiStream (parameterIndex, x, length)
    int parameterIndex
    InputStream x
    long length
    setBinaryStream (parameterIndex, x, length)
    int parameterIndex
    InputStream x
    long length
    setCharacterStream (parameterIndex, reader, length)
    int parameterIndex
    Reader reader
    long length
    setAsciiStream (parameterIndex, x)
    int parameterIndex
    InputStream x
    setBinaryStream (parameterIndex, x)
    int parameterIndex
    InputStream x
    setCharacterStream (parameterIndex, reader)
    int parameterIndex
    Reader reader
    setNCharacterStream (parameterIndex, value)
    int parameterIndex
    Reader value
    setClob (parameterIndex, reader)
    int parameterIndex
    Reader reader
    setBlob (parameterIndex, inputStream)
    int parameterIndex
    InputStream inputStream
    setNClob (parameterIndex, reader)
    int parameterIndex
    Reader reader
    setRef (arg0, arg1)
    int arg0
    Ref arg1
    getMetaData () → ResultSetMetaData
    returns ResultSetMetaData
    getParameterMetaData () → ParameterMetaData
    returns ParameterMetaData
    getResultSet () → ResultSet
    returns ResultSet
    setRowId (parameterIndex, x)
    int parameterIndex
    RowId x
    setNString (parameterIndex, value)
    int parameterIndex
    String value
    setNCharacterStream (parameterIndex, value, length)
    int parameterIndex
    Reader value
    long length
    setNClob (parameterIndex, value)
    int parameterIndex
    NClob value
    setClob (parameterIndex, reader, length)
    int parameterIndex
    Reader reader
    long length
    setBlob (parameterIndex, inputStream, length)
    int parameterIndex
    InputStream inputStream
    long length
    setNClob (parameterIndex, reader, length)
    int parameterIndex
    Reader reader
    long length
    setSQLXML (parameterIndex, xmlObject)
    int parameterIndex
    SQLXML xmlObject
    setBinaryStream (arg0, arg1, arg2)
    int arg0
    InputStream arg1
    int arg2
    setBlob (arg0, arg1)
    int arg0
    Blob arg1
    setURL (arg0, arg1)
    int arg0
    URL arg1
    setUnicodeStream (arg0, arg1, arg2)
    int arg0
    InputStream arg1
    int arg2
    closeOnCompletion ()
    isCloseOnCompletion () → boolean
    returns boolean

    XlsResultSet

    extends: Object implements: ResultSet

    SqlSheet implementation of java.sql.ResultSet.
    XlsResultSet (wb, s, firstSheetRowOffset, firstSheetColOffset)
    Workbook wb
    Sheet s
    int firstSheetRowOffset
    int firstSheetColOffset
    wrapped (t) → SQLException
    Throwable t
    returns SQLException
    @Override
    getMetaData () → ResultSetMetaData
    returns ResultSetMetaData
    @Override
    getBoolean (columnIndex) → boolean
    int columnIndex
    returns boolean
    @Override
    getBoolean (columnLabel) → boolean
    String columnLabel
    returns boolean
    @Override
    getDouble (columnIndex) → double
    int columnIndex
    returns double
    @Override
    getDouble (columnLabel) → double
    String columnLabel
    returns double
    @Override
    getByte (columnIndex) → byte
    int columnIndex
    returns byte
    @Override
    getByte (columnLabel) → byte
    String columnLabel
    returns byte
    @Override
    getFloat (columnIndex) → float
    int columnIndex
    returns float
    @Override
    getFloat (columnLabel) → float
    String columnLabel
    returns float
    @Override
    getInt (columnIndex) → int
    int columnIndex
    returns int
    @Override
    getInt (columnLabel) → int
    String columnLabel
    returns int
    @Override
    getLong (columnIndex) → long
    int columnIndex
    returns long
    @Override
    getLong (columnLabel) → long
    String columnLabel
    returns long
    @Override
    getObject (columnIndex) → Object
    int columnIndex
    returns Object
    @Override
    getObject (columnLabel) → Object
    String columnLabel
    returns Object
    @Override
    getObject (columnIndex, type) → T
    int columnIndex
    Class type
    returns T
    @Override
    getObject (columnLabel, type) → T
    String columnLabel
    Class type
    returns T
    @Override
    getTimestamp (columnIndex) → Timestamp
    int columnIndex
    returns Timestamp
    @Override
    getTimestamp (columnLabel) → Timestamp
    String columnLabel
    returns Timestamp
    @Override
    getTimestamp (columnIndex, cal) → Timestamp
    int columnIndex
    Calendar cal
    returns Timestamp
    @Override
    getTimestamp (jdbcColumn, cal) → Timestamp
    String jdbcColumn
    Calendar cal
    returns Timestamp
    @Override
    getShort (columnIndex) → short
    int columnIndex
    returns short
    @Override
    getShort (columnLabel) → short
    String columnLabel
    returns short
    @Override
    getString (columnIndex) → String
    int columnIndex
    returns String
    getString (columnLabel) → String
    String columnLabel
    returns String
    updateBoolean (columnIndex, x)
    int columnIndex
    boolean x
    updateBoolean (jdbcColumn, x)
    String jdbcColumn
    boolean x
    updateByte (columnIndex, x)
    int columnIndex
    byte x
    updateByte (jdbcColumn, x)
    String jdbcColumn
    byte x
    updateDouble (columnIndex, x)
    int columnIndex
    double x
    updateDouble (jdbcColumn, x)
    String jdbcColumn
    double x
    updateFloat (columnIndex, x)
    int columnIndex
    float x
    updateFloat (jdbcColumn, x)
    String jdbcColumn
    float x
    updateInt (columnIndex, x)
    int columnIndex
    int x
    updateInt (jdbcColumn, x)
    String jdbcColumn
    int x
    updateLong (columnIndex, x)
    int columnIndex
    long x
    updateLong (jdbcColumn, x)
    String jdbcColumn
    long x
    updateNull (columnIndex)
    int columnIndex
    updateNull (jdbcColumn)
    String jdbcColumn
    updateObject (columnIndex, x)
    int columnIndex
    Object x
    updateObject (jdbcColumn, x)
    String jdbcColumn
    Object x
    updateShort (columnIndex, x)
    int columnIndex
    short x
    updateShort (jdbcColumn, x)
    String jdbcColumn
    short x
    updateString (columnIndex, x)
    int columnIndex
    String x
    updateString (jdbcColumn, x)
    String jdbcColumn
    String x
    absolute (row) → boolean
    int row
    returns boolean
    afterLast ()
    beforeFirst ()
    first () → boolean
    returns boolean
    getFetchDirection () → int
    returns int
    setFetchDirection (direction)
    int direction
    getFetchSize () → int
    returns int
    setFetchSize (rows)
    int rows
    getRow () → int
    returns int
    getType () → int
    returns int
    isAfterLast () → boolean
    returns boolean
    isBeforeFirst () → boolean
    returns boolean
    isFirst () → boolean
    returns boolean
    isLast () → boolean
    returns boolean
    last () → boolean
    returns boolean
    next () → boolean
    returns boolean
    previous () → boolean
    returns boolean
    moveToInsertRow ()
    insertRow ()

    Protected because used also in the resultset metadata to scan the column type

    int columnIndex | columnIndex The index of the column, starting at 1.
    returns Cell | the Cell
    cancelRowUpdates ()
    clearWarnings ()
    @Override
    close ()
    deleteRow ()
    @Override
    findColumn (columnLabel) → int
    String columnLabel
    returns int
    getArray (i) → Array
    int i
    returns Array
    getArray (colName) → Array
    String colName
    returns Array
    @Override
    getAsciiStream (columnIndex) → InputStream
    int columnIndex
    returns InputStream
    getAsciiStream (jdbcColumn) → InputStream
    String jdbcColumn
    returns InputStream
    @Override
    getBigDecimal (columnIndex) → BigDecimal
    int columnIndex
    returns BigDecimal
    @Override
    getBigDecimal (columnLabel) → BigDecimal
    String columnLabel
    returns BigDecimal
    @Override
    getBigDecimal (columnIndex, scale) → BigDecimal
    int columnIndex
    int scale
    returns BigDecimal
    @Override
    getBigDecimal (columnLabel, scale) → BigDecimal
    String columnLabel
    int scale
    returns BigDecimal
    @Override
    getBinaryStream (columnIndex) → InputStream
    int columnIndex
    returns InputStream
    getBinaryStream (jdbcColumn) → InputStream
    String jdbcColumn
    returns InputStream
    getBlob (columnIndex) → Blob
    int columnIndex
    returns Blob
    getBlob (colName) → Blob
    String colName
    returns Blob
    @Override
    getBytes (columnIndex) → byte
    int columnIndex
    returns byte
    getBytes (jdbcColumn) → byte
    String jdbcColumn
    returns byte
    @Override
    getCharacterStream (columnIndex) → Reader
    int columnIndex
    returns Reader
    getCharacterStream (jdbcColumn) → Reader
    String jdbcColumn
    returns Reader
    getClob (i) → Clob
    int i
    returns Clob
    getClob (colName) → Clob
    String colName
    returns Clob
    getConcurrency () → int
    returns int
    getCursorName () → String
    returns String
    @Override
    getDate (columnIndex) → Date
    int columnIndex
    returns Date
    @Override
    getDate (columnLabel) → Date
    String columnLabel
    returns Date
    @Override
    getDate (columnIndex, cal) → Date
    int columnIndex
    Calendar cal
    returns Date
    @Override
    getDate (columnLabel, cal) → Date
    String columnLabel
    Calendar cal
    returns Date
    @Override
    getObject (columnIndex, map) → Object
    int columnIndex
    Map map
    returns Object
    @Override
    getObject (colName, map) → Object
    String colName
    Map map
    returns Object
    getRef (columnIndex) → Ref
    int columnIndex
    returns Ref
    getRef (colName) → Ref
    String colName
    returns Ref
    getStatement () → Statement
    returns Statement
    getTime (columnIndex) → Time
    int columnIndex
    returns Time
    getTime (jdbcColumn) → Time
    String jdbcColumn
    returns Time
    getTime (columnIndex, cal) → Time
    int columnIndex
    Calendar cal
    returns Time
    getTime (jdbcColumn, cal) → Time
    String jdbcColumn
    Calendar cal
    returns Time
    getURL (columnIndex) → URL
    int columnIndex
    returns URL
    getURL (jdbcColumn) → URL
    String jdbcColumn
    returns URL
    getUnicodeStream (columnIndex) → InputStream
    int columnIndex
    returns InputStream
    getUnicodeStream (jdbcColumn) → InputStream
    String jdbcColumn
    returns InputStream
    getWarnings () → SQLWarning
    returns SQLWarning
    moveToCurrentRow ()
    refreshRow ()
    relative (rows) → boolean
    int rows
    returns boolean
    rowDeleted () → boolean
    returns boolean
    rowInserted () → boolean
    returns boolean
    rowUpdated () → boolean
    returns boolean
    updateArray (columnIndex, x)
    int columnIndex
    Array x
    updateArray (jdbcColumn, x)
    String jdbcColumn
    Array x
    getRowId (columnIndex) → RowId
    int columnIndex
    returns RowId
    getRowId (columnLabel) → RowId
    String columnLabel
    returns RowId
    updateRowId (columnIndex, x)
    int columnIndex
    RowId x
    updateRowId (columnLabel, x)
    String columnLabel
    RowId x
    getHoldability () → int
    returns int
    @Override
    isClosed () → boolean
    returns boolean
    updateNString (columnIndex, nString)
    int columnIndex
    String nString
    updateNString (columnLabel, nString)
    String columnLabel
    String nString
    updateNClob (columnIndex, nClob)
    int columnIndex
    NClob nClob
    updateNClob (columnLabel, nClob)
    String columnLabel
    NClob nClob
    getNClob (columnIndex) → NClob
    int columnIndex
    returns NClob
    getNClob (columnLabel) → NClob
    String columnLabel
    returns NClob
    getSQLXML (columnIndex) → SQLXML
    int columnIndex
    returns SQLXML
    getSQLXML (columnLabel) → SQLXML
    String columnLabel
    returns SQLXML
    updateSQLXML (columnIndex, xmlObject)
    int columnIndex
    SQLXML xmlObject
    updateSQLXML (columnLabel, xmlObject)
    String columnLabel
    SQLXML xmlObject
    getNString (columnIndex) → String
    int columnIndex
    returns String
    getNString (columnLabel) → String
    String columnLabel
    returns String
    getNCharacterStream (columnIndex) → Reader
    int columnIndex
    returns Reader
    getNCharacterStream (columnLabel) → Reader
    String columnLabel
    returns Reader
    updateNCharacterStream (columnIndex, x, length)
    int columnIndex
    Reader x
    long length
    updateNCharacterStream (columnLabel, reader, length)
    String columnLabel
    Reader reader
    long length
    updateAsciiStream (columnIndex, x, length)
    int columnIndex
    InputStream x
    long length
    updateBinaryStream (columnIndex, x, length)
    int columnIndex
    InputStream x
    long length
    updateCharacterStream (columnIndex, x, length)
    int columnIndex
    Reader x
    long length
    updateAsciiStream (columnLabel, x, length)
    String columnLabel
    InputStream x
    long length
    updateBinaryStream (columnLabel, x, length)
    String columnLabel
    InputStream x
    long length
    updateCharacterStream (columnLabel, reader, length)
    String columnLabel
    Reader reader
    long length
    updateBlob (columnIndex, inputStream, length)
    int columnIndex
    InputStream inputStream
    long length
    updateBlob (columnLabel, inputStream, length)
    String columnLabel
    InputStream inputStream
    long length
    updateClob (columnIndex, reader, length)
    int columnIndex
    Reader reader
    long length
    updateClob (columnLabel, reader, length)
    String columnLabel
    Reader reader
    long length
    updateNClob (columnIndex, reader, length)
    int columnIndex
    Reader reader
    long length
    updateNClob (columnLabel, reader, length)
    String columnLabel
    Reader reader
    long length
    updateNCharacterStream (columnIndex, x)
    int columnIndex
    Reader x
    updateNCharacterStream (columnLabel, reader)
    String columnLabel
    Reader reader
    updateAsciiStream (columnIndex, x)
    int columnIndex
    InputStream x
    updateBinaryStream (columnIndex, x)
    int columnIndex
    InputStream x
    updateCharacterStream (columnIndex, x)
    int columnIndex
    Reader x
    updateAsciiStream (columnLabel, x)
    String columnLabel
    InputStream x
    updateBinaryStream (columnLabel, x)
    String columnLabel
    InputStream x
    updateCharacterStream (columnLabel, reader)
    String columnLabel
    Reader reader
    updateBlob (columnIndex, inputStream)
    int columnIndex
    InputStream inputStream
    updateBlob (columnLabel, inputStream)
    String columnLabel
    InputStream inputStream
    updateClob (columnIndex, reader)
    int columnIndex
    Reader reader
    updateClob (columnLabel, reader)
    String columnLabel
    Reader reader
    updateNClob (columnIndex, reader)
    int columnIndex
    Reader reader
    updateNClob (columnLabel, reader)
    String columnLabel
    Reader reader
    updateAsciiStream (jdbcColumn, x, length)
    int jdbcColumn
    InputStream x
    int length
    updateAsciiStream (jdbcColumn, x, length)
    String jdbcColumn
    InputStream x
    int length
    updateBigDecimal (jdbcColumn, x)
    int jdbcColumn
    BigDecimal x
    updateBigDecimal (jdbcColumn, x)
    String jdbcColumn
    BigDecimal x
    updateBinaryStream (jdbcColumn, x, length)
    int jdbcColumn
    InputStream x
    int length
    updateBinaryStream (jdbcColumn, x, length)
    String jdbcColumn
    InputStream x
    int length
    updateBlob (jdbcColumn, x)
    int jdbcColumn
    Blob x
    updateBlob (jdbcColumn, x)
    String jdbcColumn
    Blob x
    updateBytes (jdbcColumn, x)
    int jdbcColumn
    byte x
    updateBytes (jdbcColumn, x)
    String jdbcColumn
    byte x
    updateCharacterStream (jdbcColumn, x, length)
    int jdbcColumn
    Reader x
    int length
    updateCharacterStream (jdbcColumn, reader, length)
    String jdbcColumn
    Reader reader
    int length
    updateClob (jdbcColumn, x)
    int jdbcColumn
    Clob x
    updateClob (jdbcColumn, x)
    String jdbcColumn
    Clob x
    updateDate (jdbcColumn, x)
    int jdbcColumn
    Date x
    updateDate (jdbcColumn, x)
    String jdbcColumn
    Date x
    updateObject (jdbcColumn, x, scale)
    int jdbcColumn
    Object x
    int scale
    updateObject (jdbcColumn, x, scale)
    String jdbcColumn
    Object x
    int scale
    updateRef (jdbcColumn, x)
    int jdbcColumn
    Ref x
    updateRef (jdbcColumn, x)
    String jdbcColumn
    Ref x
    updateRow ()
    updateTime (jdbcColumn, x)
    int jdbcColumn
    Time x
    updateTime (jdbcColumn, x)
    String jdbcColumn
    Time x
    updateTimestamp (jdbcColumn, x)
    int jdbcColumn
    Timestamp x
    updateTimestamp (jdbcColumn, x)
    String jdbcColumn
    Timestamp x
    @Override
    wasNull () → boolean
    returns boolean
    unwrap (iface) → T
    Class iface
    returns T
    isWrapperFor (iface) → boolean
    Class iface
    returns boolean

    XlsResultSetMetaData

    extends: Object implements: ResultSetMetaData

    SqlSheet implementation of java.sql.ResultSetMetaData.
    XlsResultSetMetaData (sheet, resultset, firstSheetRowOffset, firstSheetColOffset)
    Sheet sheet
    XlsResultSet resultset
    int firstSheetRowOffset
    int firstSheetColOffset
    getColumnCount () → int
    returns int
    getColumnLabel (jdbcCol) → String
    int jdbcCol
    returns String
    getColumnName (jdbcCol) → String
    int jdbcCol
    returns String
    getCatalogName (arg0) → String
    int arg0
    returns String
    getColumnClassName (jdbcColumn) → String
    int jdbcColumn
    returns String
    getColumnDisplaySize (arg0) → int
    int arg0
    returns int
    getColumnType (jdbcColumn) → int
    int jdbcColumn
    returns int
    getColumnTypeName (jdbcColumn) → String
    int jdbcColumn
    returns String
    getPrecision (arg0) → int
    int arg0
    returns int
    getScale (arg0) → int
    int arg0
    returns int
    getSchemaName (arg0) → String
    int arg0
    returns String
    getTableName (arg0) → String
    int arg0
    returns String
    isAutoIncrement (arg0) → boolean
    int arg0
    returns boolean
    isCaseSensitive (arg0) → boolean
    int arg0
    returns boolean
    isCurrency (arg0) → boolean
    int arg0
    returns boolean
    isDefinitelyWritable (arg0) → boolean
    int arg0
    returns boolean
    isNullable (arg0) → int
    int arg0
    returns int
    isReadOnly (arg0) → boolean
    int arg0
    returns boolean
    isSearchable (arg0) → boolean
    int arg0
    returns boolean
    isSigned (arg0) → boolean
    int arg0
    returns boolean
    isWritable (arg0) → boolean
    int arg0
    returns boolean
    isWrapperFor (iface) → boolean
    Class iface
    returns boolean
    unwrap (iface) → T
    Class iface
    returns T

    XlsStatement

    extends: Object implements: Statement provides: XlsPreparedStatement

    SqlSheet implementation of java.sql.Statement.
    XlsStatement (c)
    XlsConnection c
    getSheetNamed (wb, name) → Sheet
    Workbook wb
    String name
    returns Sheet
    getConnection () → Connection
    returns Connection
    @Override
    close ()
    @Override
    execute (sql) → boolean
    String sql
    returns boolean
    @Override
    executeUpdate (sql) → int
    String sql
    returns int
    @Override
    executeQuery (query) → ResultSet
    String query
    returns ResultSet
    String sql
    returns ResultSet
    returns ResultSet
    returns ResultSet
    setEscapeProcessing (p0)
    boolean p0
    setCursorName (p0)
    String p0
    getMaxFieldSize () → int
    returns int
    setMaxFieldSize (p0)
    int p0
    getMaxRows () → int
    returns int
    setMaxRows (p0)
    int p0
    getQueryTimeout () → int
    returns int
    setQueryTimeout (p0)
    int p0
    getWarnings () → SQLWarning
    returns SQLWarning
    getResultSet () → ResultSet
    returns ResultSet
    getUpdateCount () → int
    returns int
    @Override
    getMoreResults () → boolean
    returns boolean
    @Override
    getMoreResults (current) → boolean
    int current
    returns boolean
    @Override
    getFetchDirection () → int
    returns int
    @Override
    setFetchDirection (p0)
    int p0
    @Override
    getFetchSize () → int
    returns int
    @Override
    setFetchSize (p0)
    int p0
    @Override
    getResultSetConcurrency () → int
    returns int
    @Override
    getResultSetType () → int
    returns int
    @Override
    cancel ()
    clearWarnings ()
    addBatch (p0)
    String p0
    clearBatch ()
    executeBatch () → int
    returns int
    @Override
    getGeneratedKeys () → ResultSet
    returns ResultSet
    executeUpdate (sql, autoGeneratedKeys) → int
    String sql
    int autoGeneratedKeys
    returns int
    @Override
    executeUpdate (sql, columnIndexes) → int
    String sql
    int columnIndexes
    returns int
    @Override
    executeUpdate (sql, columnNames) → int
    String sql
    String columnNames
    returns int
    @Override
    execute (sql, autoGeneratedKeys) → boolean
    String sql
    int autoGeneratedKeys
    returns boolean
    @Override
    execute (sql, columnIndexes) → boolean
    String sql
    int columnIndexes
    returns boolean
    @Override
    execute (sql, columnNames) → boolean
    String sql
    String columnNames
    returns boolean
    @Override
    getResultSetHoldability () → int
    returns int
    returns void
    @Override
    isClosed () → boolean
    returns boolean
    @Override
    isPoolable () → boolean
    returns boolean
    @Override
    setPoolable (poolable)
    boolean poolable
    isWrapperFor (iface) → boolean
    Class iface
    returns boolean
    unwrap (iface) → T
    Class iface
    returns T
    @Override
    closeOnCompletion ()
    @Override
    isCloseOnCompletion () → boolean
    returns boolean

    parser

    JdbcParameter

    extends: Object

    Used to represent a jdbc parameter (‘?’) in a query for a PreparedSatement. A singleton with no fields and no methods. Possibly dumbest class in the world.

    SqlSheetParser

    extends: Object

    Wrapper around the JSQLParser which does all the real work. This class and the rest of the interface in the package are here just to insulate the parent package from the particulars of a particular parser.
    SqlSheetParser ()
    parse (sql) → ParsedStatement
    String sql

    CreateTableStatement

    implements: ParsedStatement provides:

    Handle on a parsed SQL statement of the form CREATE TABLE xxx (xxx xxx, xxx xxx)
    getTable () → String
    returns String
    getColumns () → List
    returns List
    getTypes () → List
    returns List

    DropTableStatement

    implements: ParsedStatement provides:

    Handle on a parsed SQL statement of the form DROP TABLE xxx.
    getTable () → String
    returns String

    InsertIntoStatement

    implements: ParsedStatement provides:

    Handle on a parsed SQL statement of the form INSERT INTO xxx (xxx) VALUE (xxx).
    getTable () → String
    returns String
    getColumns () → List
    returns List
    getValues () → List
    returns List

    ParsedStatement

    provides: CreateTableStatement, DropTableStatement, InsertIntoStatement, SelectStarStatement,

    Marker interface for objects which describe a SQL parsed statement.

    SelectStarStatement

    implements: ParsedStatement provides:

    Handle on a parsed SQL statement of the form SELECT * FROM xxx.
    getTable () → String
    returns String

    stream

    AbstractXlsSheetIterator

    extends: Object implements: Iterable, Iterator provides: XlsSheetIterator, XlsxSheetIterator

    AbstractXlsSheetIterator (filename, sheetName)
    URL filename | filename The file to postConstruct
    String sheetName | sheetName The sheet name
    returns void
    returns void
    returns void
    iterator () → Iterator
    returns Iterator
    hasNext () → boolean
    returns boolean
    next () → Object
    returns Object
    remove ()
    returns URL
    URL fileName
    returns void
    returns String
    String sheetName
    returns void
    returns List
    List columns
    returns void
    returns Map
    Map rowValues
    returns void
    returns Long
    Long currentSheetRowIndex
    returns void
    returns Long
    Long currentIteratorRowIndex
    returns void

    XlsSheetIterator

    extends: AbstractXlsSheetIterator

    XlsSheetIterator (filename, sheetName)
    URL filename
    String sheetName
    postConstruct ()
    Initiates the processing - position stream to the right sheet - extracts columns - extracts first row

    Process few records to get current and maybe few next rows loaded into memory | returns void

    @SuppressWarnings
    processRecord (record)
    Main HSSFListener method, processes events
    Record record
    returns void
    getLastRowNumber () → int
    returns int
    getLastColumnNumber () → int
    returns int

    XlsStreamConnection

    extends: Object implements: Connection

    SqlSheet implementation of java.sql.Connection which uses steaming over XLS
    XlsStreamConnection (xlsFile, info)
    URL xlsFile
    Properties info
    getInt (key, defaultValue) → int
    String key
    int defaultValue
    returns int
    createStatement () → Statement
    returns Statement
    prepareStatement (sql) → PreparedStatement
    String sql
    returns PreparedStatement
    prepareStatement (sql, resultSetType, resultSetConcurrency) → PreparedStatement
    String sql
    int resultSetType
    int resultSetConcurrency
    returns PreparedStatement
    close ()
    getAutoCommit () → boolean
    returns boolean
    setAutoCommit (autoCommit)
    boolean autoCommit
    isClosed () → boolean
    returns boolean
    isReadOnly () → boolean
    returns boolean
    setReadOnly (readOnly)
    boolean readOnly
    getCatalog () → String
    returns String
    setCatalog (catalog)
    String catalog
    getTransactionIsolation () → int
    returns int
    setTransactionIsolation (level)
    int level
    getWarnings () → SQLWarning
    returns SQLWarning
    getTypeMap () → Map
    returns Map
    setTypeMap (map)
    Map map
    commit ()
    rollback ()
    clearWarnings ()
    getMetaData () → DatabaseMetaData
    returns DatabaseMetaData
    prepareCall (sql) → CallableStatement
    String sql
    returns CallableStatement
    nativeSQL (sql) → String
    String sql
    returns String
    createStatement (resultSetType, resultSetConcurrency) → Statement
    int resultSetType
    int resultSetConcurrency
    returns Statement
    prepareCall (sql, resultSetType, resultSetConcurrency) → CallableStatement
    String sql
    int resultSetType
    int resultSetConcurrency
    returns CallableStatement
    getHoldability () → int
    returns int
    setHoldability (param)
    int param
    prepareCall (str, param, param2, param3) → CallableStatement
    String str
    int param
    int param2
    int param3
    returns CallableStatement
    prepareStatement (str, param) → PreparedStatement
    String str
    int param
    returns PreparedStatement
    prepareStatement (str, values) → PreparedStatement
    String str
    int values
    returns PreparedStatement
    prepareStatement (str, str1) → PreparedStatement
    String str
    String str1
    returns PreparedStatement
    createClob () → Clob
    returns Clob
    createBlob () → Blob
    returns Blob
    createNClob () → NClob
    returns NClob
    createSQLXML () → SQLXML
    returns SQLXML
    isValid (timeout) → boolean
    int timeout
    returns boolean
    setClientInfo (name, value)
    String name
    String value
    getClientInfo (name) → String
    String name
    returns String
    getClientInfo () → Properties
    returns Properties
    setClientInfo (properties)
    Properties properties
    createArrayOf (typeName, elements) → Array
    String typeName
    Object elements
    returns Array
    createStruct (typeName, attributes) → Struct
    String typeName
    Object attributes
    returns Struct
    prepareStatement (str, param, param2, param3) → PreparedStatement
    String str
    int param
    int param2
    int param3
    returns PreparedStatement
    releaseSavepoint (savepoint)
    Savepoint savepoint
    rollback (savepoint)
    Savepoint savepoint
    setSavepoint () → Savepoint
    returns Savepoint
    setSavepoint (str) → Savepoint
    String str
    returns Savepoint
    createStatement (resultSetType, resultSetConcurrency, resultSetHoldability) → Statement
    int resultSetType
    int resultSetConcurrency
    int resultSetHoldability
    returns Statement
    unwrap (iface) → T
    Class iface
    returns T
    isWrapperFor (iface) → boolean
    Class iface
    returns boolean
    getSchema () → String
    returns String
    setSchema (string)
    String string
    abort (exctr)
    Executor exctr
    setNetworkTimeout (exctr, i)
    Executor exctr
    int i
    getNetworkTimeout () → int
    returns int
    getWorkBook () → Workbook
    returns Workbook

    XlsStreamDatabaseMetaData

    extends: Object implements: DatabaseMetaData

    XlsStreamDatabaseMetaData (connection)
    @Override
    allProceduresAreCallable () → boolean
    returns boolean
    @Override
    allTablesAreSelectable () → boolean
    returns boolean
    @Override
    getURL () → String
    returns String
    @Override
    getUserName () → String
    returns String
    @Override
    isReadOnly () → boolean
    returns boolean
    @Override
    nullsAreSortedHigh () → boolean
    returns boolean
    @Override
    nullsAreSortedLow () → boolean
    returns boolean
    @Override
    nullsAreSortedAtStart () → boolean
    returns boolean
    @Override
    nullsAreSortedAtEnd () → boolean
    returns boolean
    @Override
    getDatabaseProductName () → String
    returns String
    @Override
    getDatabaseProductVersion () → String
    returns String
    @Override
    getDriverName () → String
    returns String
    @Override
    getDriverVersion () → String
    returns String
    @Override
    getDriverMajorVersion () → int
    returns int
    @Override
    getDriverMinorVersion () → int
    returns int
    @Override
    usesLocalFiles () → boolean
    returns boolean
    @Override
    usesLocalFilePerTable () → boolean
    returns boolean
    @Override
    supportsMixedCaseIdentifiers () → boolean
    returns boolean
    @Override
    storesUpperCaseIdentifiers () → boolean
    returns boolean
    @Override
    storesLowerCaseIdentifiers () → boolean
    returns boolean
    @Override
    storesMixedCaseIdentifiers () → boolean
    returns boolean
    @Override
    supportsMixedCaseQuotedIdentifiers () → boolean
    returns boolean
    @Override
    storesUpperCaseQuotedIdentifiers () → boolean
    returns boolean
    @Override
    storesLowerCaseQuotedIdentifiers () → boolean
    returns boolean
    @Override
    storesMixedCaseQuotedIdentifiers () → boolean
    returns boolean
    @Override
    getIdentifierQuoteString () → String
    returns String
    @Override
    getSQLKeywords () → String
    returns String
    @Override
    getNumericFunctions () → String
    returns String
    @Override
    getStringFunctions () → String
    returns String
    @Override
    getSystemFunctions () → String
    returns String
    @Override
    getTimeDateFunctions () → String
    returns String
    @Override
    getSearchStringEscape () → String
    returns String
    @Override
    getExtraNameCharacters () → String
    returns String
    @Override
    supportsAlterTableWithAddColumn () → boolean
    returns boolean
    @Override
    supportsAlterTableWithDropColumn () → boolean
    returns boolean
    @Override
    supportsColumnAliasing () → boolean
    returns boolean
    @Override
    nullPlusNonNullIsNull () → boolean
    returns boolean
    @Override
    supportsConvert () → boolean
    returns boolean
    @Override
    supportsConvert (i, i1) → boolean
    int i
    int i1
    returns boolean
    @Override
    supportsTableCorrelationNames () → boolean
    returns boolean
    @Override
    supportsDifferentTableCorrelationNames () → boolean
    returns boolean
    @Override
    supportsExpressionsInOrderBy () → boolean
    returns boolean
    @Override
    supportsOrderByUnrelated () → boolean
    returns boolean
    @Override
    supportsGroupBy () → boolean
    returns boolean
    @Override
    supportsGroupByUnrelated () → boolean
    returns boolean
    @Override
    supportsGroupByBeyondSelect () → boolean
    returns boolean
    @Override
    supportsLikeEscapeClause () → boolean
    returns boolean
    @Override
    supportsMultipleResultSets () → boolean
    returns boolean
    @Override
    supportsMultipleTransactions () → boolean
    returns boolean
    @Override
    supportsNonNullableColumns () → boolean
    returns boolean
    @Override
    supportsMinimumSQLGrammar () → boolean
    returns boolean
    @Override
    supportsCoreSQLGrammar () → boolean
    returns boolean
    @Override
    supportsExtendedSQLGrammar () → boolean
    returns boolean
    @Override
    supportsANSI92EntryLevelSQL () → boolean
    returns boolean
    @Override
    supportsANSI92IntermediateSQL () → boolean
    returns boolean
    @Override
    supportsANSI92FullSQL () → boolean
    returns boolean
    @Override
    supportsIntegrityEnhancementFacility () → boolean
    returns boolean
    @Override
    supportsOuterJoins () → boolean
    returns boolean
    @Override
    supportsFullOuterJoins () → boolean
    returns boolean
    @Override
    supportsLimitedOuterJoins () → boolean
    returns boolean
    @Override
    getSchemaTerm () → String
    returns String
    @Override
    getProcedureTerm () → String
    returns String
    @Override
    getCatalogTerm () → String
    returns String
    @Override
    isCatalogAtStart () → boolean
    returns boolean
    @Override
    getCatalogSeparator () → String
    returns String
    @Override
    supportsSchemasInDataManipulation () → boolean
    returns boolean
    @Override
    supportsSchemasInProcedureCalls () → boolean
    returns boolean
    @Override
    supportsSchemasInTableDefinitions () → boolean
    returns boolean
    @Override
    supportsSchemasInIndexDefinitions () → boolean
    returns boolean
    @Override
    supportsSchemasInPrivilegeDefinitions () → boolean
    returns boolean
    @Override
    supportsCatalogsInDataManipulation () → boolean
    returns boolean
    @Override
    supportsCatalogsInProcedureCalls () → boolean
    returns boolean
    @Override
    supportsCatalogsInTableDefinitions () → boolean
    returns boolean
    @Override
    supportsCatalogsInIndexDefinitions () → boolean
    returns boolean
    @Override
    supportsCatalogsInPrivilegeDefinitions () → boolean
    returns boolean
    @Override
    supportsPositionedDelete () → boolean
    returns boolean
    @Override
    supportsPositionedUpdate () → boolean
    returns boolean
    @Override
    supportsSelectForUpdate () → boolean
    returns boolean
    @Override
    supportsStoredProcedures () → boolean
    returns boolean
    @Override
    supportsSubqueriesInComparisons () → boolean
    returns boolean
    @Override
    supportsSubqueriesInExists () → boolean
    returns boolean
    @Override
    supportsSubqueriesInIns () → boolean
    returns boolean
    @Override
    supportsSubqueriesInQuantifieds () → boolean
    returns boolean
    @Override
    supportsCorrelatedSubqueries () → boolean
    returns boolean
    @Override
    supportsUnion () → boolean
    returns boolean
    @Override
    supportsUnionAll () → boolean
    returns boolean
    @Override
    supportsOpenCursorsAcrossCommit () → boolean
    returns boolean
    @Override
    supportsOpenCursorsAcrossRollback () → boolean
    returns boolean
    @Override
    supportsOpenStatementsAcrossCommit () → boolean
    returns boolean
    @Override
    supportsOpenStatementsAcrossRollback () → boolean
    returns boolean
    @Override
    getMaxBinaryLiteralLength () → int
    returns int
    @Override
    getMaxCharLiteralLength () → int
    returns int
    @Override
    getMaxColumnNameLength () → int
    returns int
    @Override
    getMaxColumnsInGroupBy () → int
    returns int
    @Override
    getMaxColumnsInIndex () → int
    returns int
    @Override
    getMaxColumnsInOrderBy () → int
    returns int
    @Override
    getMaxColumnsInSelect () → int
    returns int
    @Override
    getMaxColumnsInTable () → int
    returns int
    @Override
    getMaxConnections () → int
    returns int
    @Override
    getMaxCursorNameLength () → int
    returns int
    @Override
    getMaxIndexLength () → int
    returns int
    @Override
    getMaxSchemaNameLength () → int
    returns int
    @Override
    getMaxProcedureNameLength () → int
    returns int
    @Override
    getMaxCatalogNameLength () → int
    returns int
    @Override
    getMaxRowSize () → int
    returns int
    @Override
    doesMaxRowSizeIncludeBlobs () → boolean
    returns boolean
    @Override
    getMaxStatementLength () → int
    returns int
    @Override
    getMaxStatements () → int
    returns int
    @Override
    getMaxTableNameLength () → int
    returns int
    @Override
    getMaxTablesInSelect () → int
    returns int
    @Override
    getMaxUserNameLength () → int
    returns int
    @Override
    getDefaultTransactionIsolation () → int
    returns int
    @Override
    supportsTransactions () → boolean
    returns boolean
    @Override
    supportsTransactionIsolationLevel (i) → boolean
    int i
    returns boolean
    @Override
    supportsDataDefinitionAndDataManipulationTransactions () → boolean
    returns boolean
    @Override
    supportsDataManipulationTransactionsOnly () → boolean
    returns boolean
    @Override
    dataDefinitionCausesTransactionCommit () → boolean
    returns boolean
    @Override
    dataDefinitionIgnoredInTransactions () → boolean
    returns boolean
    @Override
    getProcedures (string, string1, string2) → ResultSet
    String string
    String string1
    String string2
    returns ResultSet
    @Override
    getProcedureColumns (string, string1, string2, string3) → ResultSet
    String string
    String string1
    String string2
    String string3
    returns ResultSet
    @Override
    getTables (catalog, schemaPattern, tableNamePattern, types) → ResultSet
    String catalog
    String schemaPattern
    String tableNamePattern
    String types
    returns ResultSet
    @Override
    getSchemas () → ResultSet
    returns ResultSet
    @Override
    getCatalogs () → ResultSet
    returns ResultSet
    @Override
    getTableTypes () → ResultSet
    returns ResultSet
    @Override,| @SuppressWarnings
    getColumns (catalog, schemaPattern, tableNamePattern, columnNamePattern) → ResultSet
    String catalog
    String schemaPattern
    String tableNamePattern
    String columnNamePattern
    returns ResultSet
    @Override
    getColumnPrivileges (string, string1, string2, string3) → ResultSet
    String string
    String string1
    String string2
    String string3
    returns ResultSet
    @Override
    getTablePrivileges (string, string1, string2) → ResultSet
    String string
    String string1
    String string2
    returns ResultSet
    @Override
    getBestRowIdentifier (string, string1, string2, i, bln) → ResultSet
    String string
    String string1
    String string2
    int i
    boolean bln
    returns ResultSet
    @Override
    getVersionColumns (string, string1, string2) → ResultSet
    String string
    String string1
    String string2
    returns ResultSet
    @Override
    getPrimaryKeys (catalog, schema, table) → ResultSet
    String catalog
    String schema
    String table
    returns ResultSet
    @Override
    getImportedKeys (catalog, schema, table) → ResultSet
    String catalog
    String schema
    String table
    returns ResultSet
    @Override
    getExportedKeys (catalog, schema, table) → ResultSet
    String catalog
    String schema
    String table
    returns ResultSet
    @Override
    getCrossReference (parentCatalog, parentSchema, parentTable, foreignCatalog, foreignSchema, foreignTable) → ResultSet
    String parentCatalog
    String parentSchema
    String parentTable
    String foreignCatalog
    String foreignSchema
    String foreignTable
    returns ResultSet
    @Override
    getTypeInfo () → ResultSet
    returns ResultSet
    @Override
    getIndexInfo (catalog, schema, table, unique, approximate) → ResultSet
    String catalog
    String schema
    String table
    boolean unique
    boolean approximate
    returns ResultSet
    @Override
    supportsResultSetType (i) → boolean
    int i
    returns boolean
    @Override
    supportsResultSetConcurrency (i, i1) → boolean
    int i
    int i1
    returns boolean
    @Override
    ownUpdatesAreVisible (i) → boolean
    int i
    returns boolean
    @Override
    ownDeletesAreVisible (i) → boolean
    int i
    returns boolean
    @Override
    ownInsertsAreVisible (i) → boolean
    int i
    returns boolean
    @Override
    othersUpdatesAreVisible (i) → boolean
    int i
    returns boolean
    @Override
    othersDeletesAreVisible (i) → boolean
    int i
    returns boolean
    @Override
    othersInsertsAreVisible (i) → boolean
    int i
    returns boolean
    @Override
    updatesAreDetected (i) → boolean
    int i
    returns boolean
    @Override
    deletesAreDetected (i) → boolean
    int i
    returns boolean
    @Override
    insertsAreDetected (i) → boolean
    int i
    returns boolean
    @Override
    supportsBatchUpdates () → boolean
    returns boolean
    @Override
    getUDTs (string, string1, string2, ints) → ResultSet
    String string
    String string1
    String string2
    int ints
    returns ResultSet
    @Override
    getConnection () → Connection
    returns Connection
    @Override
    supportsSavepoints () → boolean
    returns boolean
    @Override
    supportsNamedParameters () → boolean
    returns boolean
    @Override
    supportsMultipleOpenResults () → boolean
    returns boolean
    @Override
    supportsGetGeneratedKeys () → boolean
    returns boolean
    @Override
    getSuperTypes (string, string1, string2) → ResultSet
    String string
    String string1
    String string2
    returns ResultSet
    @Override
    getSuperTables (string, string1, string2) → ResultSet
    String string
    String string1
    String string2
    returns ResultSet
    @Override
    getAttributes (string, string1, string2, string3) → ResultSet
    String string
    String string1
    String string2
    String string3
    returns ResultSet
    @Override
    supportsResultSetHoldability (i) → boolean
    int i
    returns boolean
    @Override
    getResultSetHoldability () → int
    returns int
    @Override
    getDatabaseMajorVersion () → int
    returns int
    @Override
    getDatabaseMinorVersion () → int
    returns int
    @Override
    getJDBCMajorVersion () → int
    returns int
    @Override
    getJDBCMinorVersion () → int
    returns int
    @Override
    getSQLStateType () → int
    returns int
    @Override
    locatorsUpdateCopy () → boolean
    returns boolean
    @Override
    supportsStatementPooling () → boolean
    returns boolean
    @Override
    getRowIdLifetime () → RowIdLifetime
    returns RowIdLifetime
    @Override
    getSchemas (catalog, schemaPattern) → ResultSet
    String catalog
    String schemaPattern
    returns ResultSet
    @Override
    supportsStoredFunctionsUsingCallSyntax () → boolean
    returns boolean
    @Override
    autoCommitFailureClosesAllResultSets () → boolean
    returns boolean
    @Override
    getClientInfoProperties () → ResultSet
    returns ResultSet
    @Override
    getFunctions (string, string1, string2) → ResultSet
    String string
    String string1
    String string2
    returns ResultSet
    @Override
    getFunctionColumns (string, string1, string2, string3) → ResultSet
    String string
    String string1
    String string2
    String string3
    returns ResultSet
    @Override
    getPseudoColumns (string, string1, string2, string3) → ResultSet
    String string
    String string1
    String string2
    String string3
    returns ResultSet
    @Override
    generatedKeyAlwaysReturned () → boolean
    returns boolean
    @Override
    unwrap (type) → T
    Class type
    returns T
    @Override
    isWrapperFor (type) → boolean
    Class type
    returns boolean

    XlsStreamPreparedStatement

    extends: XlsStreamStatement implements: PreparedStatement

    SqlSheet implementation of java.sql.PreparedStatement which uses steaming over XLS
    XlsStreamPreparedStatement (conn, sql, firstSheetRowOffset, firstSheetColOffset)
    String sql
    int firstSheetRowOffset
    int firstSheetColOffset
    addBatch ()
    clearParameters ()
    execute () → boolean
    returns boolean
    executeUpdate () → int
    returns int
    executeQuery () → ResultSet
    returns ResultSet
    setBigDecimal (arg0, arg1)
    int arg0
    BigDecimal arg1
    setBoolean (arg0, arg1)
    int arg0
    boolean arg1
    setByte (arg0, arg1)
    int arg0
    byte arg1
    setDate (arg0, arg1)
    int arg0
    Date arg1
    setDouble (arg0, arg1)
    int arg0
    double arg1
    setFloat (arg0, arg1)
    int arg0
    float arg1
    setInt (arg0, arg1)
    int arg0
    int arg1
    setLong (arg0, arg1)
    int arg0
    long arg1
    setNull (arg0, arg1)
    int arg0
    int arg1
    setNull (arg0, arg1, arg2)
    int arg0
    int arg1
    String arg2
    setShort (arg0, arg1)
    int arg0
    short arg1
    setString (arg0, arg1)
    int arg0
    String arg1
    setTime (arg0, arg1)
    int arg0
    Time arg1
    setTimestamp (arg0, arg1)
    int arg0
    Timestamp arg1
    setCharacterStream (parameterIndex, reader, length)
    int parameterIndex
    Reader reader
    int length
    setObject (arg0, arg1)
    int arg0
    Object arg1
    setTimestamp (arg0, arg1, arg2)
    int arg0
    Timestamp arg1
    Calendar arg2
    setTime (arg0, arg1, arg2)
    int arg0
    Time arg1
    Calendar arg2
    setArray (arg0, arg1)
    int arg0
    Array arg1
    setAsciiStream (arg0, arg1, arg2)
    int arg0
    InputStream arg1
    int arg2
    setDate (arg0, arg1, arg2)
    int arg0
    Date arg1
    Calendar arg2
    setBytes (arg0, arg1)
    int arg0
    byte arg1
    setClob (arg0, arg1)
    int arg0
    Clob arg1
    setObject (arg0, arg1, arg2)
    int arg0
    Object arg1
    int arg2
    setObject (arg0, arg1, arg2, arg3)
    int arg0
    Object arg1
    int arg2
    int arg3
    setAsciiStream (parameterIndex, x, length)
    int parameterIndex
    InputStream x
    long length
    setBinaryStream (parameterIndex, x, length)
    int parameterIndex
    InputStream x
    long length
    setCharacterStream (parameterIndex, reader, length)
    int parameterIndex
    Reader reader
    long length
    setAsciiStream (parameterIndex, x)
    int parameterIndex
    InputStream x
    setBinaryStream (parameterIndex, x)
    int parameterIndex
    InputStream x
    setCharacterStream (parameterIndex, reader)
    int parameterIndex
    Reader reader
    setNCharacterStream (parameterIndex, value)
    int parameterIndex
    Reader value
    setClob (parameterIndex, reader)
    int parameterIndex
    Reader reader
    setBlob (parameterIndex, inputStream)
    int parameterIndex
    InputStream inputStream
    setNClob (parameterIndex, reader)
    int parameterIndex
    Reader reader
    setRef (arg0, arg1)
    int arg0
    Ref arg1
    getMetaData () → ResultSetMetaData
    returns ResultSetMetaData
    getParameterMetaData () → ParameterMetaData
    returns ParameterMetaData
    setRowId (parameterIndex, x)
    int parameterIndex
    RowId x
    setNString (parameterIndex, value)
    int parameterIndex
    String value
    setNCharacterStream (parameterIndex, value, length)
    int parameterIndex
    Reader value
    long length
    setNClob (parameterIndex, value)
    int parameterIndex
    NClob value
    setClob (parameterIndex, reader, length)
    int parameterIndex
    Reader reader
    long length
    setBlob (parameterIndex, inputStream, length)
    int parameterIndex
    InputStream inputStream
    long length
    setNClob (parameterIndex, reader, length)
    int parameterIndex
    Reader reader
    long length
    setSQLXML (parameterIndex, xmlObject)
    int parameterIndex
    SQLXML xmlObject
    setBinaryStream (arg0, arg1, arg2)
    int arg0
    InputStream arg1
    int arg2
    setBlob (arg0, arg1)
    int arg0
    Blob arg1
    setURL (arg0, arg1)
    int arg0
    URL arg1
    setUnicodeStream (arg0, arg1, arg2)
    int arg0
    InputStream arg1
    int arg2
    closeOnCompletion ()
    isCloseOnCompletion () → boolean
    returns boolean

    XlsStreamResultSet

    extends: Object implements: ResultSet

    SqlSheet implementation of java.sql.ResultSet which uses steaming over XLS
    XlsStreamResultSet (wb, sheet, firstSheetRowOffset, firstSheetColOffset)
    Workbook wb
    Sheet sheet
    int firstSheetRowOffset
    int firstSheetColOffset
    int columnIndex
    returns Cell
    getMetaData () → ResultSetMetaData
    returns ResultSetMetaData
    @Override
    getBigDecimal (columnIndex) → BigDecimal
    int columnIndex
    returns BigDecimal
    @Override
    getBigDecimal (columnLabel) → BigDecimal
    String columnLabel
    returns BigDecimal
    @Override
    getBigDecimal (columnIndex, scale) → BigDecimal
    int columnIndex
    int scale
    returns BigDecimal
    @Override
    getBigDecimal (columnLabel, scale) → BigDecimal
    String columnLabel
    int scale
    returns BigDecimal
    @Override
    getDate (columnIndex) → Date
    int columnIndex
    returns Date
    @Override
    getDate (columnLabel) → Date
    String columnLabel
    returns Date
    @Override
    getDate (columnIndex, cal) → Date
    int columnIndex
    Calendar cal
    returns Date
    @Override
    getDate (columnLabel, cal) → Date
    String columnLabel
    Calendar cal
    returns Date
    @Override
    getBoolean (columnIndex) → boolean
    int columnIndex
    returns boolean
    @Override
    getBoolean (columnLabel) → boolean
    String columnLabel
    returns boolean
    @Override
    getDouble (columnIndex) → double
    int columnIndex
    returns double
    @Override
    getDouble (columnLabel) → double
    String columnLabel
    returns double
    @Override
    getByte (columnIndex) → byte
    int columnIndex
    returns byte
    @Override
    getByte (columnLabel) → byte
    String columnLabel
    returns byte
    @Override
    getFloat (columnIndex) → float
    int columnIndex
    returns float
    @Override
    getFloat (columnLabel) → float
    String columnLabel
    returns float
    @Override
    getInt (columnIndex) → int
    int columnIndex
    returns int
    @Override
    getInt (columnLabel) → int
    String columnLabel
    returns int
    @Override
    getLong (columnIndex) → long
    int columnIndex
    returns long
    @Override
    getLong (columnLabel) → long
    String columnLabel
    returns long
    @Override
    getObject (columnIndex) → Object
    int columnIndex
    returns Object
    @Override
    getObject (columnLabel) → Object
    String columnLabel
    returns Object
    @Override
    getObject (columnIndex, type) → T
    int columnIndex
    Class type
    returns T
    @Override
    getObject (columnLabel, type) → T
    String columnLabel
    Class type
    returns T
    @Override
    getTimestamp (columnIndex) → Timestamp
    int columnIndex
    returns Timestamp
    @Override
    getTimestamp (columnLabel) → Timestamp
    String columnLabel
    returns Timestamp
    @Override
    getTimestamp (columnIndex, cal) → Timestamp
    int columnIndex
    Calendar cal
    returns Timestamp
    @Override
    getTimestamp (jdbcColumn, cal) → Timestamp
    String jdbcColumn
    Calendar cal
    returns Timestamp
    @Override
    getShort (columnIndex) → short
    int columnIndex
    returns short
    @Override
    getShort (columnLabel) → short
    String columnLabel
    returns short
    @Override
    getString (columnIndex) → String
    int columnIndex
    returns String
    getString (columnLabel) → String
    String columnLabel
    returns String
    updateBoolean (jdbcColumn, x)
    int jdbcColumn
    boolean x
    updateBoolean (jdbcColumn, x)
    String jdbcColumn
    boolean x
    updateByte (jdbcColumn, x)
    int jdbcColumn
    byte x
    updateByte (jdbcColumn, x)
    String jdbcColumn
    byte x
    updateDouble (jdbcColumn, x)
    int jdbcColumn
    double x
    updateDouble (jdbcColumn, x)
    String jdbcColumn
    double x
    updateFloat (jdbcColumn, x)
    int jdbcColumn
    float x
    updateFloat (jdbcColumn, x)
    String jdbcColumn
    float x
    updateInt (jdbcColumn, x)
    int jdbcColumn
    int x
    updateInt (jdbcColumn, x)
    String jdbcColumn
    int x
    updateLong (jdbcColumn, x)
    int jdbcColumn
    long x
    updateLong (jdbcColumn, x)
    String jdbcColumn
    long x
    updateNull (jdbcColumn)
    int jdbcColumn
    updateNull (jdbcColumn)
    String jdbcColumn
    updateObject (jdbcColumn, x)
    int jdbcColumn
    Object x
    updateObject (jdbcColumn, x)
    String jdbcColumn
    Object x
    updateShort (jdbcColumn, x)
    int jdbcColumn
    short x
    updateShort (jdbcColumn, x)
    String jdbcColumn
    short x
    updateString (jdbcColumn, x)
    int jdbcColumn
    String x
    updateString (jdbcColumn, x)
    String jdbcColumn
    String x
    absolute (row) → boolean
    int row
    returns boolean
    afterLast ()
    beforeFirst ()
    first () → boolean
    returns boolean
    getFetchDirection () → int
    returns int
    setFetchDirection (direction)
    int direction
    getFetchSize () → int
    returns int
    setFetchSize (rows)
    int rows
    getRow () → int
    returns int
    getType () → int
    returns int
    isAfterLast () → boolean
    returns boolean
    isBeforeFirst () → boolean
    returns boolean
    isFirst () → boolean
    returns boolean
    isLast () → boolean
    returns boolean
    last () → boolean
    returns boolean
    next () → boolean
    returns boolean
    previous () → boolean
    returns boolean
    moveToInsertRow ()
    insertRow ()
    cancelRowUpdates ()
    clearWarnings ()
    close ()
    deleteRow ()
    findColumn (jdbcColumn) → int
    String jdbcColumn
    returns int
    getArray (i) → Array
    int i
    returns Array
    getArray (colName) → Array
    String colName
    returns Array
    getAsciiStream (jdbcColumn) → InputStream
    int jdbcColumn
    returns InputStream
    getAsciiStream (jdbcColumn) → InputStream
    String jdbcColumn
    returns InputStream
    getBinaryStream (jdbcColumn) → InputStream
    int jdbcColumn
    returns InputStream
    getBinaryStream (jdbcColumn) → InputStream
    String jdbcColumn
    returns InputStream
    getBlob (i) → Blob
    int i
    returns Blob
    getBlob (colName) → Blob
    String colName
    returns Blob
    getBytes (jdbcColumn) → byte
    int jdbcColumn
    returns byte
    getBytes (jdbcColumn) → byte
    String jdbcColumn
    returns byte
    getCharacterStream (jdbcColumn) → Reader
    int jdbcColumn
    returns Reader
    getCharacterStream (jdbcColumn) → Reader
    String jdbcColumn
    returns Reader
    getClob (i) → Clob
    int i
    returns Clob
    getClob (colName) → Clob
    String colName
    returns Clob
    getConcurrency () → int
    returns int
    getCursorName () → String
    returns String
    getObject (i, map) → Object
    int i
    Map map
    returns Object
    getObject (colName, map) → Object
    String colName
    Map map
    returns Object
    getRef (i) → Ref
    int i
    returns Ref
    getRef (colName) → Ref
    String colName
    returns Ref
    getStatement () → Statement
    returns Statement
    getTime (jdbcColumn) → Time
    int jdbcColumn
    returns Time
    getTime (jdbcColumn) → Time
    String jdbcColumn
    returns Time
    getTime (jdbcColumn, cal) → Time
    int jdbcColumn
    Calendar cal
    returns Time
    getTime (jdbcColumn, cal) → Time
    String jdbcColumn
    Calendar cal
    returns Time
    getURL (jdbcColumn) → URL
    int jdbcColumn
    returns URL
    getURL (jdbcColumn) → URL
    String jdbcColumn
    returns URL
    getUnicodeStream (jdbcColumn) → InputStream
    int jdbcColumn
    returns InputStream
    getUnicodeStream (jdbcColumn) → InputStream
    String jdbcColumn
    returns InputStream
    getWarnings () → SQLWarning
    returns SQLWarning
    moveToCurrentRow ()
    refreshRow ()
    relative (rows) → boolean
    int rows
    returns boolean
    rowDeleted () → boolean
    returns boolean
    rowInserted () → boolean
    returns boolean
    rowUpdated () → boolean
    returns boolean
    updateArray (jdbcColumn, x)
    int jdbcColumn
    Array x
    updateArray (jdbcColumn, x)
    String jdbcColumn
    Array x
    getRowId (columnIndex) → RowId
    int columnIndex
    returns RowId
    getRowId (columnLabel) → RowId
    String columnLabel
    returns RowId
    updateRowId (columnIndex, x)
    int columnIndex
    RowId x
    updateRowId (columnLabel, x)
    String columnLabel
    RowId x
    getHoldability () → int
    returns int
    isClosed () → boolean
    returns boolean
    updateNString (columnIndex, nString)
    int columnIndex
    String nString
    updateNString (columnLabel, nString)
    String columnLabel
    String nString
    updateNClob (columnIndex, nClob)
    int columnIndex
    NClob nClob
    updateNClob (columnLabel, nClob)
    String columnLabel
    NClob nClob
    getNClob (columnIndex) → NClob
    int columnIndex
    returns NClob
    getNClob (columnLabel) → NClob
    String columnLabel
    returns NClob
    getSQLXML (columnIndex) → SQLXML
    int columnIndex
    returns SQLXML
    getSQLXML (columnLabel) → SQLXML
    String columnLabel
    returns SQLXML
    updateSQLXML (columnIndex, xmlObject)
    int columnIndex
    SQLXML xmlObject
    updateSQLXML (columnLabel, xmlObject)
    String columnLabel
    SQLXML xmlObject
    getNString (columnIndex) → String
    int columnIndex
    returns String
    getNString (columnLabel) → String
    String columnLabel
    returns String
    getNCharacterStream (columnIndex) → Reader
    int columnIndex
    returns Reader
    getNCharacterStream (columnLabel) → Reader
    String columnLabel
    returns Reader
    updateNCharacterStream (columnIndex, x, length)
    int columnIndex
    Reader x
    long length
    updateNCharacterStream (columnLabel, reader, length)
    String columnLabel
    Reader reader
    long length
    updateAsciiStream (columnIndex, x, length)
    int columnIndex
    InputStream x
    long length
    updateBinaryStream (columnIndex, x, length)
    int columnIndex
    InputStream x
    long length
    updateCharacterStream (columnIndex, x, length)
    int columnIndex
    Reader x
    long length
    updateAsciiStream (columnLabel, x, length)
    String columnLabel
    InputStream x
    long length
    updateBinaryStream (columnLabel, x, length)
    String columnLabel
    InputStream x
    long length
    updateCharacterStream (columnLabel, reader, length)
    String columnLabel
    Reader reader
    long length
    updateBlob (columnIndex, inputStream, length)
    int columnIndex
    InputStream inputStream
    long length
    updateBlob (columnLabel, inputStream, length)
    String columnLabel
    InputStream inputStream
    long length
    updateClob (columnIndex, reader, length)
    int columnIndex
    Reader reader
    long length
    updateClob (columnLabel, reader, length)
    String columnLabel
    Reader reader
    long length
    updateNClob (columnIndex, reader, length)
    int columnIndex
    Reader reader
    long length
    updateNClob (columnLabel, reader, length)
    String columnLabel
    Reader reader
    long length
    updateNCharacterStream (columnIndex, x)
    int columnIndex
    Reader x
    updateNCharacterStream (columnLabel, reader)
    String columnLabel
    Reader reader
    updateAsciiStream (columnIndex, x)
    int columnIndex
    InputStream x
    updateBinaryStream (columnIndex, x)
    int columnIndex
    InputStream x
    updateCharacterStream (columnIndex, x)
    int columnIndex
    Reader x
    updateAsciiStream (columnLabel, x)
    String columnLabel
    InputStream x
    updateBinaryStream (columnLabel, x)
    String columnLabel
    InputStream x
    updateCharacterStream (columnLabel, reader)
    String columnLabel
    Reader reader
    updateBlob (columnIndex, inputStream)
    int columnIndex
    InputStream inputStream
    updateBlob (columnLabel, inputStream)
    String columnLabel
    InputStream inputStream
    updateClob (columnIndex, reader)
    int columnIndex
    Reader reader
    updateClob (columnLabel, reader)
    String columnLabel
    Reader reader
    updateNClob (columnIndex, reader)
    int columnIndex
    Reader reader
    updateNClob (columnLabel, reader)
    String columnLabel
    Reader reader
    updateAsciiStream (jdbcColumn, x, length)
    int jdbcColumn
    InputStream x
    int length
    updateAsciiStream (jdbcColumn, x, length)
    String jdbcColumn
    InputStream x
    int length
    updateBigDecimal (jdbcColumn, x)
    int jdbcColumn
    BigDecimal x
    updateBigDecimal (jdbcColumn, x)
    String jdbcColumn
    BigDecimal x
    updateBinaryStream (jdbcColumn, x, length)
    int jdbcColumn
    InputStream x
    int length
    updateBinaryStream (jdbcColumn, x, length)
    String jdbcColumn
    InputStream x
    int length
    updateBlob (jdbcColumn, x)
    int jdbcColumn
    Blob x
    updateBlob (jdbcColumn, x)
    String jdbcColumn
    Blob x
    updateBytes (jdbcColumn, x)
    int jdbcColumn
    byte x
    updateBytes (jdbcColumn, x)
    String jdbcColumn
    byte x
    updateCharacterStream (jdbcColumn, x, length)
    int jdbcColumn
    Reader x
    int length
    updateCharacterStream (jdbcColumn, reader, length)
    String jdbcColumn
    Reader reader
    int length
    updateClob (jdbcColumn, x)
    int jdbcColumn
    Clob x
    updateClob (jdbcColumn, x)
    String jdbcColumn
    Clob x
    updateDate (jdbcColumn, x)
    int jdbcColumn
    Date x
    updateDate (jdbcColumn, x)
    String jdbcColumn
    Date x
    updateObject (jdbcColumn, x, scale)
    int jdbcColumn
    Object x
    int scale
    updateObject (jdbcColumn, x, scale)
    String jdbcColumn
    Object x
    int scale
    updateRef (jdbcColumn, x)
    int jdbcColumn
    Ref x
    updateRef (jdbcColumn, x)
    String jdbcColumn
    Ref x
    updateRow ()
    updateTime (jdbcColumn, x)
    int jdbcColumn
    Time x
    updateTime (jdbcColumn, x)
    String jdbcColumn
    Time x
    updateTimestamp (jdbcColumn, x)
    int jdbcColumn
    Timestamp x
    updateTimestamp (jdbcColumn, x)
    String jdbcColumn
    Timestamp x
    wasNull () → boolean
    returns boolean
    unwrap (iface) → T
    Class iface
    returns T
    isWrapperFor (iface) → boolean
    Class iface
    returns boolean

    XlsStreamStatement

    extends: Object implements: Statement provides: XlsStreamPreparedStatement

    SqlSheet implementation of java.sql.Statement which uses steaming over XLS
    XlsStreamStatement (c)
    getConnection () → Connection
    returns Connection
    close ()
    execute (sql) → boolean
    String sql
    returns boolean
    executeUpdate (sql) → int
    String sql
    returns int
    executeQuery (query) → ResultSet
    String query
    returns ResultSet
    String sql
    returns ResultSet
    setEscapeProcessing (p0)
    boolean p0
    setCursorName (p0)
    String p0
    getMaxFieldSize () → int
    returns int
    setMaxFieldSize (p0)
    int p0
    getMaxRows () → int
    returns int
    setMaxRows (p0)
    int p0
    getQueryTimeout () → int
    returns int
    setQueryTimeout (p0)
    int p0
    getWarnings () → SQLWarning
    returns SQLWarning
    getResultSet () → ResultSet
    returns ResultSet
    getUpdateCount () → int
    returns int
    getMoreResults () → boolean
    returns boolean
    getMoreResults (current) → boolean
    int current
    returns boolean
    getFetchDirection () → int
    returns int
    setFetchDirection (p0)
    int p0
    getFetchSize () → int
    returns int
    setFetchSize (p0)
    int p0
    getResultSetConcurrency () → int
    returns int
    getResultSetType () → int
    returns int
    cancel ()
    clearWarnings ()
    addBatch (p0)
    String p0
    clearBatch ()
    executeBatch () → int
    returns int
    getGeneratedKeys () → ResultSet
    returns ResultSet
    executeUpdate (sql, autoGeneratedKeys) → int
    String sql
    int autoGeneratedKeys
    returns int
    executeUpdate (sql, columnIndexes) → int
    String sql
    int columnIndexes
    returns int
    executeUpdate (sql, columnNames) → int
    String sql
    String columnNames
    returns int
    execute (sql, autoGeneratedKeys) → boolean
    String sql
    int autoGeneratedKeys
    returns boolean
    execute (sql, columnIndexes) → boolean
    String sql
    int columnIndexes
    returns boolean
    execute (sql, columnNames) → boolean
    String sql
    String columnNames
    returns boolean
    getResultSetHoldability () → int
    returns int
    returns void
    isClosed () → boolean
    returns boolean
    isPoolable () → boolean
    returns boolean
    setPoolable (poolable)
    boolean poolable
    isWrapperFor (iface) → boolean
    Class iface
    returns boolean
    unwrap (iface) → T
    Class iface
    returns T
    closeOnCompletion ()
    isCloseOnCompletion () → boolean
    returns boolean

    XlsStreamingResultSetMetaData

    extends: Object implements: ResultSetMetaData

    SqlSheet implementation of java.sql.ResultSetMetaData.
    XlsStreamingResultSetMetaData (sheet, resultset, firstSheetRowOffset, firstSheetColOffset)
    Sheet sheet
    int firstSheetRowOffset
    int firstSheetColOffset
    getColumnCount () → int
    returns int
    getColumnLabel (jdbcCol) → String
    int jdbcCol
    returns String
    getColumnName (jdbcCol) → String
    int jdbcCol
    returns String
    getCatalogName (arg0) → String
    int arg0
    returns String
    getColumnClassName (jdbcColumn) → String
    int jdbcColumn
    returns String
    getColumnDisplaySize (arg0) → int
    int arg0
    returns int
    getColumnType (jdbcColumn) → int
    int jdbcColumn
    returns int
    getColumnTypeName (jdbcColumn) → String
    int jdbcColumn
    returns String
    getPrecision (arg0) → int
    int arg0
    returns int
    getScale (arg0) → int
    int arg0
    returns int
    getSchemaName (arg0) → String
    int arg0
    returns String
    getTableName (arg0) → String
    int arg0
    returns String
    isAutoIncrement (arg0) → boolean
    int arg0
    returns boolean
    isCaseSensitive (arg0) → boolean
    int arg0
    returns boolean
    isCurrency (arg0) → boolean
    int arg0
    returns boolean
    isDefinitelyWritable (arg0) → boolean
    int arg0
    returns boolean
    isNullable (arg0) → int
    int arg0
    returns int
    isReadOnly (arg0) → boolean
    int arg0
    returns boolean
    isSearchable (arg0) → boolean
    int arg0
    returns boolean
    isSigned (arg0) → boolean
    int arg0
    returns boolean
    isWritable (arg0) → boolean
    int arg0
    returns boolean
    isWrapperFor (iface) → boolean
    Class iface
    returns boolean
    unwrap (iface) → T
    Class iface
    returns T

    XlsxSheetIterator

    extends: AbstractXlsSheetIterator

    XlsxSheetIterator (filename, sheetName)
    URL filename
    String sheetName
    returns void
    returns void
    returns void
    processNextEvent ()
    Parses and shows the content of one sheet using the specified styles and shared-strings tables.

    heet

    XlsDriver

    extends: XlsDriver

    XlsDriver ()