Class JdbcStatement - Google Apps Script

A JDBC Statement. For documentation of this class, see java.sql.Statement.

Methods

Method	Return type	Brief description
`addBatch(sql)`	`void`	For documentation of this method, see `java.sql.Statement#addBatch(String)`.
`cancel()`	`void`	For documentation of this method, see `java.sql.Statement#cancel()`.
`clearBatch()`	`void`	For documentation of this method, see `java.sql.Statement#clearBatch()`.
`clearWarnings()`	`void`	For documentation of this method, see `java.sql.Statement#clearWarnings()`.
`close()`	`void`	For documentation of this method, see `java.sql.Statement#close()`.
`execute(sql)`	`Boolean`	For documentation of this method, see `java.sql.Statement#execute(String)`.
`execute(sql, autoGeneratedKeys)`	`Boolean`	For documentation of this method, see `java.sql.Statement#execute(String, int)`.
`execute(sql, columnIndexes)`	`Boolean`	For documentation of this method, see `java.sql.Statement#execute(String, int[])`.
`execute(sql, columnNames)`	`Boolean`	For documentation of this method, see `java.sql.Statement#execute(String, String[])`.
`executeBatch()`	`Integer[]`	For documentation of this method, see `java.sql.Statement#executeBatch()`.
`executeQuery(sql)`	`JdbcResultSet`	For documentation of this method, see `java.sql.Statement#executeQuery(String)`.
`executeUpdate(sql)`	`Integer`	For documentation of this method, see `java.sql.Statement#executeUpdate(String)`.
`executeUpdate(sql, autoGeneratedKeys)`	`Integer`	For documentation of this method, see `java.sql.Statement#executeUpdate(String, int)`.
`executeUpdate(sql, columnIndexes)`	`Integer`	For documentation of this method, see `java.sql.Statement#executeUpdate(String, int)`.
`executeUpdate(sql, columnNames)`	`Integer`	For documentation of this method, see `java.sql.Statement#executeUpdate(String, String[])`.
`getConnection()`	`JdbcConnection`	For documentation of this method, see `java.sql.Statement#getConnection()`.
`getFetchDirection()`	`Integer`	For documentation of this method, see `java.sql.Statement#getFetchDirection()`.
`getFetchSize()`	`Integer`	For documentation of this method, see `java.sql.Statement#getFetchSize()`.
`getGeneratedKeys()`	`JdbcResultSet`	For documentation of this method, see `java.sql.Statement#getGeneratedKeys()`.
`getMaxFieldSize()`	`Integer`	For documentation of this method, see `java.sql.Statement#getMaxFieldSize()`.
`getMaxRows()`	`Integer`	For documentation of this method, see `java.sql.Statement#getMaxRows()`.
`getMoreResults()`	`Boolean`	For documentation of this method, see `java.sql.Statement#getMoreResults()`.
`getMoreResults(current)`	`Boolean`	For documentation of this method, see `java.sql.Statement#getMoreResults(int)`.
`getQueryTimeout()`	`Integer`	For documentation of this method, see `java.sql.Statement#getQueryTimeout()`.
`getResultSet()`	`JdbcResultSet`	For documentation of this method, see `java.sql.Statement#getResultSet()`.
`getResultSetConcurrency()`	`Integer`	For documentation of this method, see `java.sql.Statement#getResultSetConcurrency()`.
`getResultSetHoldability()`	`Integer`	For documentation of this method, see `java.sql.Statement#getResultSetHoldability()`.
`getResultSetType()`	`Integer`	For documentation of this method, see `java.sql.Statement#getResultSetType()`.
`getUpdateCount()`	`Integer`	For documentation of this method, see `java.sql.Statement#getUpdateCount()`.
`getWarnings()`	`String[]`	Returns the current set of warnings reported by the driver.
`isClosed()`	`Boolean`	For documentation of this method, see `java.sql.Statement#isClosed()`.
`isPoolable()`	`Boolean`	For documentation of this method, see `java.sql.Statement#isPoolable()`.
`setCursorName(name)`	`void`	For documentation of this method, see `java.sql.Statement#setCursorName(String)`.
`setEscapeProcessing(enable)`	`void`	For documentation of this method, see `java.sql.Statement#setEscapeProcessing(boolean)`.
`setFetchDirection(direction)`	`void`	For documentation of this method, see `java.sql.Statement#setFetchDirection(int)`.
`setFetchSize(rows)`	`void`	For documentation of this method, see `java.sql.Statement#setFetchSize(int)`.
`setMaxFieldSize(max)`	`void`	For documentation of this method, see `java.sql.Statement#setMaxFieldSize(int)`.
`setMaxRows(max)`	`void`	For documentation of this method, see `java.sql.Statement#setMaxRows(int)`.
`setPoolable(poolable)`	`void`	For documentation of this method, see `java.sql.Statement#setPoolable(boolean)`.
`setQueryTimeout(seconds)`	`void`	For documentation of this method, see `java.sql.Statement#setQueryTimeout(int)`.

Detailed documentation

`addBatch(sql)`

For documentation of this method, see java.sql.Statement#addBatch(String).

Parameters

Name	Type	Description
`sql`	`String`

`cancel()`

For documentation of this method, see java.sql.Statement#cancel().

`clearBatch()`

For documentation of this method, see java.sql.Statement#clearBatch().

`clearWarnings()`

For documentation of this method, see java.sql.Statement#clearWarnings().

`close()`

For documentation of this method, see java.sql.Statement#close().

`execute(sql)`

For documentation of this method, see java.sql.Statement#execute(String).

Parameters

Name	Type	Description
`sql`	`String`

Return

Boolean

`execute(sql, autoGeneratedKeys)`

For documentation of this method, see java.sql.Statement#execute(String, int).

Parameters

Name	Type	Description
`sql`	`String`
`autoGeneratedKeys`	`Integer`

Return

Boolean

`execute(sql, columnIndexes)`

For documentation of this method, see java.sql.Statement#execute(String, int[]).

Parameters

Name	Type	Description
`sql`	`String`
`columnIndexes`	`Integer[]`

Return

Boolean

`execute(sql, columnNames)`

For documentation of this method, see java.sql.Statement#execute(String, String[]).

Parameters

Name	Type	Description
`sql`	`String`
`columnNames`	`String[]`

Return

Boolean

`executeBatch()`

For documentation of this method, see java.sql.Statement#executeBatch().

Return

Integer[]

`executeQuery(sql)`

For documentation of this method, see java.sql.Statement#executeQuery(String).

Parameters

Name	Type	Description
`sql`	`String`

Return

JdbcResultSet

`executeUpdate(sql)`

For documentation of this method, see java.sql.Statement#executeUpdate(String).

Parameters

Name	Type	Description
`sql`	`String`

Return

Integer

`executeUpdate(sql, autoGeneratedKeys)`

For documentation of this method, see java.sql.Statement#executeUpdate(String, int).

Parameters

Name	Type	Description
`sql`	`String`
`autoGeneratedKeys`	`Integer`

Return

Integer

`executeUpdate(sql, columnIndexes)`

For documentation of this method, see java.sql.Statement#executeUpdate(String, int).

Parameters

Name	Type	Description
`sql`	`String`
`columnIndexes`	`Integer[]`

Return

Integer

`executeUpdate(sql, columnNames)`

For documentation of this method, see java.sql.Statement#executeUpdate(String, String[]).

Parameters

Name	Type	Description
`sql`	`String`
`columnNames`	`String[]`

Return

Integer

`getConnection()`

For documentation of this method, see java.sql.Statement#getConnection().

Return

JdbcConnection

`getFetchDirection()`

For documentation of this method, see java.sql.Statement#getFetchDirection().

Return

Integer

`getFetchSize()`

For documentation of this method, see java.sql.Statement#getFetchSize().

Return

Integer

`getGeneratedKeys()`

For documentation of this method, see java.sql.Statement#getGeneratedKeys().

Return

JdbcResultSet

`getMaxFieldSize()`

For documentation of this method, see java.sql.Statement#getMaxFieldSize().

Return

Integer

`getMaxRows()`

For documentation of this method, see java.sql.Statement#getMaxRows().

Return

Integer

`getMoreResults()`

For documentation of this method, see java.sql.Statement#getMoreResults().

Return

Boolean

`getMoreResults(current)`

For documentation of this method, see java.sql.Statement#getMoreResults(int).

Parameters

Name	Type	Description
`current`	`Integer`

Return

Boolean

`getQueryTimeout()`

For documentation of this method, see java.sql.Statement#getQueryTimeout().

Return

Integer

`getResultSet()`

For documentation of this method, see java.sql.Statement#getResultSet().

Return

JdbcResultSet

`getResultSetConcurrency()`

For documentation of this method, see java.sql.Statement#getResultSetConcurrency().

Return

Integer

`getResultSetHoldability()`

For documentation of this method, see java.sql.Statement#getResultSetHoldability().

Return

Integer

`getResultSetType()`

For documentation of this method, see java.sql.Statement#getResultSetType().

Return

Integer

`getUpdateCount()`

For documentation of this method, see java.sql.Statement#getUpdateCount().

Return

Integer

`getWarnings()`

Returns the current set of warnings reported by the driver. For documentation of this method, see java.sql.Statement#getWarnings()

Return

String[] — array of warnings

`isClosed()`

For documentation of this method, see java.sql.Statement#isClosed().

Return

Boolean

`isPoolable()`

For documentation of this method, see java.sql.Statement#isPoolable().

Return

Boolean

`setCursorName(name)`

For documentation of this method, see java.sql.Statement#setCursorName(String).

Parameters

Name	Type	Description
`name`	`String`

`setEscapeProcessing(enable)`

For documentation of this method, see java.sql.Statement#setEscapeProcessing(boolean).

Parameters

Name	Type	Description
`enable`	`Boolean`

`setFetchDirection(direction)`

For documentation of this method, see java.sql.Statement#setFetchDirection(int).

Parameters

Name	Type	Description
`direction`	`Integer`

`setFetchSize(rows)`

For documentation of this method, see java.sql.Statement#setFetchSize(int).

Parameters

Name	Type	Description
`rows`	`Integer`

`setMaxFieldSize(max)`

For documentation of this method, see java.sql.Statement#setMaxFieldSize(int).

Parameters

Name	Type	Description
`max`	`Integer`

`setMaxRows(max)`

For documentation of this method, see java.sql.Statement#setMaxRows(int).

Parameters

Name	Type	Description
`max`	`Integer`

`setPoolable(poolable)`

For documentation of this method, see java.sql.Statement#setPoolable(boolean).

Parameters

Name	Type	Description
`poolable`	`Boolean`

`setQueryTimeout(seconds)`

For documentation of this method, see java.sql.Statement#setQueryTimeout(int).

Parameters

Name	Type	Description
`seconds`	`Integer`