API 7.2

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 ParsedStatement

SelectStarStatement sss

returns ResultSet

CreateTableStatement cts

returns ResultSet

InsertIntoStatement insert

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

returns ParsedStatement

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

Streaming iterator over XLS files Derived from: http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/hssf/eventusermodel/examples/XLS2CSVmra.java

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)

XlsStreamConnection 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)

XlsStreamConnection conn

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 (sheet, firstSheetRowOffset, firstSheetColOffset)

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)

XlsStreamConnection 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 ParsedStatement

SelectStarStatement sss

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

XlsStreamResultSet 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

XlsxSheetIterator

extends: AbstractXlsSheetIterator

Streaming iterator over XLSX files Derived from: http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/eventusermodel/XLSX2CSV.java

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 ()