Class JdbcStatement

AI-generated Key Takeaways

JdbcStatement represents a JDBC Statement and mirrors the documentation found in java.sql.Statement.
It includes methods for executing various SQL commands like addBatch, execute, executeQuery, and executeUpdate.
Methods are available to manage the statement's state, such as cancel, clearBatch, clearWarnings, and close.
You can retrieve information about the statement and its results using methods like getWarnings, getResultSet, and getUpdateCount.
Several methods allow setting properties like setFetchSize, setMaxRows, and setQueryTimeout.

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[]`	For documentation of this method, see `java.sql.Statement#getWarnings()`.
`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`	The SQL command to add to this statement, typically an SQL `INSERT` or `UPDATE`.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`cancel()`

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

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`clearBatch()`

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

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`clearWarnings()`

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

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`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`	The SQL statement to execute.

Return

Boolean — true if the first result is a result set; false if it is an update count or if there are no results.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`execute(sql, autoGeneratedKeys)`

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

Parameters

Name	Type	Description
`sql`	`String`	The SQL statement to execute.
`autoGeneratedKeys`	`Integer`	A flag that indicates whether auto-generated keys are made available for future retrieval; either `Jdbc.Statement.RETURN_GENERATED_KEYS` or `Jdbc.Statement.NO_GENERATED_KEYS`.

Return

Boolean — true if the first result is a result set; false if it is an update count or if there are no results.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`execute(sql, columnIndexes)`

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

Parameters

Name	Type	Description
`sql`	`String`	The SQL statement to execute.
`columnIndexes`	`Integer[]`	The column indices in the whose auto-generated keys are made available for future retrieval.

Return

Boolean — true if the first result is a result set; false if it is an update count or if there are no results.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`execute(sql, columnNames)`

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

Parameters

Name	Type	Description
`sql`	`String`	The SQL statement to execute.
`columnNames`	`String[]`	The names of columns in the whose auto-generated keys are made available for future retrieval.

Return

Boolean — true if the first result is a result set; false if it is an update count or if there are no results.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`executeBatch()`

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

Return

Integer[] — The update counts for each command in the batch, using the same order in which commands were added to the batch.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`executeQuery(sql)`

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

Parameters

Name	Type	Description
`sql`	`String`	The SQL statement to execute, typically a static `SELECT`.

Return

JdbcResultSet — A result set containing the results of the execution. This is never null.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`executeUpdate(sql)`

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

Parameters

Name	Type	Description
`sql`	`String`	The SQL Data Manipulation Language statement to execute (such as `INSERT`, `UPDATE`, or `DELETE`), or else a statement that returns nothing (such as a DDL statement).

Return

Integer — Either the row count for for Data Manipulation Language statements, or 0 for statements that return nothing.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`executeUpdate(sql, autoGeneratedKeys)`

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

Parameters

Name	Type	Description
`sql`	`String`	The SQL Data Manipulation Language statement to execute (such as `INSERT`, `UPDATE`, or `DELETE`), or else a statement that returns nothing (such as a DDL statement).
`autoGeneratedKeys`	`Integer`	A flag that indicates whether auto-generated keys are made available for future retrieval; either `Jdbc.Statement.RETURN_GENERATED_KEYS` or `Jdbc.Statement.NO_GENERATED_KEYS`.

Return

Integer — Either the row count for for Data Manipulation Language statements, or 0 for statements that return nothing.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`executeUpdate(sql, columnIndexes)`

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

Parameters

Name	Type	Description
`sql`	`String`	The SQL Data Manipulation Language statement to execute (such as `INSERT`, `UPDATE`, or `DELETE`), or else a statement that returns nothing (such as a DDL statement).
`columnIndexes`	`Integer[]`	The column indices in the whose auto-generated keys are made available for future retrieval.

Return

Integer — Either the row count for for Data Manipulation Language statements, or 0 for statements that return nothing.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`executeUpdate(sql, columnNames)`

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

Parameters

Name	Type	Description
`sql`	`String`	The SQL Data Manipulation Language statement to execute (such as `INSERT`, `UPDATE`, or `DELETE`), or else a statement that returns nothing (such as a DDL statement).
`columnNames`	`String[]`	The names of columns in the whose auto-generated keys are made available for future retrieval.

Return

Integer — Either the row count for for Data Manipulation Language statements, or 0 for statements that return nothing.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`getConnection()`

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

Return

JdbcConnection — The connection that produced this statement.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`getFetchDirection()`

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

Return

Integer — The default direction for result sets generated by this statement, which is either Jdbc.ResultSet.FETCH_FORWARD or Jdbc.ResultSet.FETCH_REVERSE.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`getFetchSize()`

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

Return

Integer — The default row fetch size for result sets generated from this statement.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`getGeneratedKeys()`

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

Return

JdbcResultSet — A result set containing the auto-generated keys generated by the execution of this statement.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`getMaxFieldSize()`

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

Return

Integer — The current column byte size limit for columns storing character and binary values; a value of zero indictates no limit.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`getMaxRows()`

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

Return

Integer — The current maximum number of rows for a result set produced by this statement; a value of 0 indicates no limit.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`getMoreResults()`

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

Return

Boolean — true if the next result is a result set; false otherwise.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`getMoreResults(current)`

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

Parameters

Name	Type	Description
`current`	`Integer`	A flag that indicates what happens to current result sets when retrieved. This value is one of `Jdbc.Statement.CLOSE_CURRENT_RESULT`, `Jdbc.Statement.KEEP_CURRENT_RESULT`, or `Jdbc.Statement.CLOSE_ALL_RESULTS`.

Return

Boolean — true if the next result is a result set; false otherwise.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`getQueryTimeout()`

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

Return

Integer — The current query timeout in seconds; a value of zero indicates no timeout.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`getResultSet()`

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

Return

JdbcResultSet — The current result set, or null if the result is an update count or there are no more results.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`getResultSetConcurrency()`

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

Return

Integer — The result set concurrency for result sets generated from this statement, which is either Jdbc.ResultSet.CONCUR_READ_ONLY or Jdbc.ResultSet.CONCUR_UPDATABLE.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`getResultSetHoldability()`

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

Return

Integer — The result set holdability, which is either Jdbc.ResultSet.HOLD_CURSORS_OVER_COMMIT or Jdbc.ResultSet.CLOSE_CURSORS_AT_COMMIT.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`getResultSetType()`

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

Return

Integer — The result set type for result sets generated from this statement, which is Jdbc.ResultSet.TYPE_FORWARD_ONLY, Jdbc.ResultSet.TYPE_SCROLL_INSENSITIVE, or Jdbc.ResultSet.TYPE_SCROLL_INSENSITIVE.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`getUpdateCount()`

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

Return

Integer — The current result as an update count, or -1 if the current result is a result set or if there are no more results.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`getWarnings()`

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

Return

String[] — The current set of warnings, or null if there are no warnings.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`isClosed()`

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

Return

Boolean — true if this statement is closed; false otherwise.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`isPoolable()`

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

Return

Boolean — true if this statement is poolable; false otherwise.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`setCursorName(name)`

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

Parameters

Name	Type	Description
`name`	`String`	The new cursor name, which must be unique within a connection.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`setEscapeProcessing(enable)`

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

Parameters

Name	Type	Description
`enable`	`Boolean`	If `true`, escape processing is enabled; otherwise it is disabled.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`setFetchDirection(direction)`

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

Parameters

Name	Type	Description
`direction`	`Integer`	The specified direction to set, which is either `Jdbc.ResultSet.FETCH_FORWARD` or `Jdbc.ResultSet.FETCH_REVERSE`.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`setFetchSize(rows)`

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

Parameters

Name	Type	Description
`rows`	`Integer`	The number of rows to fetch.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`setMaxFieldSize(max)`

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

Parameters

Name	Type	Description
`max`	`Integer`	The new column byte size limit; a value of zero indicates no limit.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`setMaxRows(max)`

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

Parameters

Name	Type	Description
`max`	`Integer`	The maximum number of rows a result set generated by this statement can have. A value of 0 indicates no limit.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`setPoolable(poolable)`

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

Parameters

Name	Type	Description
`poolable`	`Boolean`	If `true`, requests that this statement be pooled; otherwise requests it not be pooled.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

`setQueryTimeout(seconds)`

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

Parameters

Name	Type	Description
`seconds`	`Integer`	The new query timeout in seconds; a value of 0 indicates no timeout.

Authorization

Scripts that use this method require authorization with one or more of the following scopes:

https://www.googleapis.com/auth/script.external_request

Class JdbcStatement Stay organized with collections Save and categorize content based on your preferences.

AI-generated Key Takeaways

Methods

Detailed documentation

addBatch(sql)

Parameters

Authorization

cancel()

Authorization

clearBatch()

Authorization

clearWarnings()

Authorization

close()

execute(sql)

Parameters

Return

Authorization

execute(sql, autoGeneratedKeys)

Parameters

Return

Authorization

execute(sql, columnIndexes)

Parameters

Return

Authorization

execute(sql, columnNames)

Parameters

Return

Authorization

executeBatch()

Return

Authorization

executeQuery(sql)

Parameters

Return

Authorization

executeUpdate(sql)

Parameters

Return

Authorization

executeUpdate(sql, autoGeneratedKeys)

Parameters

Return

Authorization

executeUpdate(sql, columnIndexes)

Parameters

Return

Authorization

executeUpdate(sql, columnNames)

Parameters

Return

Authorization

getConnection()

Return

Authorization

getFetchDirection()

Return

Authorization

getFetchSize()

Return

Authorization

getGeneratedKeys()

Return

Authorization

getMaxFieldSize()

Return

Authorization

getMaxRows()

Return

Authorization

getMoreResults()

Return

Authorization

getMoreResults(current)

Parameters

Return

Authorization

getQueryTimeout()

Return

Class JdbcStatement

`addBatch(sql)`

`cancel()`

`clearBatch()`

`clearWarnings()`

`close()`

`execute(sql)`

`execute(sql, autoGeneratedKeys)`

`execute(sql, columnIndexes)`

`execute(sql, columnNames)`

`executeBatch()`

`executeQuery(sql)`

`executeUpdate(sql)`

`executeUpdate(sql, autoGeneratedKeys)`

`executeUpdate(sql, columnIndexes)`

`executeUpdate(sql, columnNames)`

`getConnection()`

`getFetchDirection()`

`getFetchSize()`

`getGeneratedKeys()`

`getMaxFieldSize()`

`getMaxRows()`

`getMoreResults()`

`getMoreResults(current)`

`getQueryTimeout()`

`getResultSet()`

`getResultSetConcurrency()`

`getResultSetHoldability()`

`getResultSetType()`

`getUpdateCount()`

`getWarnings()`

`isClosed()`

`isPoolable()`

`setCursorName(name)`

`setEscapeProcessing(enable)`

`setFetchDirection(direction)`

`setFetchSize(rows)`

`setMaxFieldSize(max)`

`setMaxRows(max)`

`setPoolable(poolable)`

`setQueryTimeout(seconds)`