Class JdbcStatement

JdbcStatement

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

Methods

MethodReturn typeBrief description
addBatch(sql)voidFor documentation of this method, see java.sql.Statement#addBatch(String).
cancel()voidFor documentation of this method, see java.sql.Statement#cancel().
clearBatch()voidFor documentation of this method, see java.sql.Statement#clearBatch().
clearWarnings()voidFor documentation of this method, see java.sql.Statement#clearWarnings().
close()voidFor documentation of this method, see java.sql.Statement#close().
execute(sql)BooleanFor documentation of this method, see java.sql.Statement#execute(String).
execute(sql, autoGeneratedKeys)BooleanFor documentation of this method, see java.sql.Statement#execute(String, int).
execute(sql, columnIndexes)BooleanFor documentation of this method, see java.sql.Statement#execute(String, int[]).
execute(sql, columnNames)BooleanFor 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)JdbcResultSetFor documentation of this method, see java.sql.Statement#executeQuery(String).
executeUpdate(sql)IntegerFor documentation of this method, see java.sql.Statement#executeUpdate(String).
executeUpdate(sql, autoGeneratedKeys)IntegerFor documentation of this method, see java.sql.Statement#executeUpdate(String, int).
executeUpdate(sql, columnIndexes)IntegerFor documentation of this method, see java.sql.Statement#executeUpdate(String, int).
executeUpdate(sql, columnNames)IntegerFor documentation of this method, see java.sql.Statement#executeUpdate(String, String[]).
getConnection()JdbcConnectionFor documentation of this method, see java.sql.Statement#getConnection().
getFetchDirection()IntegerFor documentation of this method, see java.sql.Statement#getFetchDirection().
getFetchSize()IntegerFor documentation of this method, see java.sql.Statement#getFetchSize().
getGeneratedKeys()JdbcResultSetFor documentation of this method, see java.sql.Statement#getGeneratedKeys().
getMaxFieldSize()IntegerFor documentation of this method, see java.sql.Statement#getMaxFieldSize().
getMaxRows()IntegerFor documentation of this method, see java.sql.Statement#getMaxRows().
getMoreResults()BooleanFor documentation of this method, see java.sql.Statement#getMoreResults().
getMoreResults(current)BooleanFor documentation of this method, see java.sql.Statement#getMoreResults(int).
getQueryTimeout()IntegerFor documentation of this method, see java.sql.Statement#getQueryTimeout().
getResultSet()JdbcResultSetFor documentation of this method, see java.sql.Statement#getResultSet().
getResultSetConcurrency()IntegerFor documentation of this method, see java.sql.Statement#getResultSetConcurrency().
getResultSetHoldability()IntegerFor documentation of this method, see java.sql.Statement#getResultSetHoldability().
getResultSetType()IntegerFor documentation of this method, see java.sql.Statement#getResultSetType().
getUpdateCount()IntegerFor documentation of this method, see java.sql.Statement#getUpdateCount().
getWarnings()String[]Returns the current set of warnings reported by the driver.
isClosed()BooleanFor documentation of this method, see java.sql.Statement#isClosed().
isPoolable()BooleanFor documentation of this method, see java.sql.Statement#isPoolable().
setCursorName(name)voidFor documentation of this method, see java.sql.Statement#setCursorName(String).
setEscapeProcessing(enable)voidFor documentation of this method, see java.sql.Statement#setEscapeProcessing(boolean).
setFetchDirection(direction)voidFor documentation of this method, see java.sql.Statement#setFetchDirection(int).
setFetchSize(rows)voidFor documentation of this method, see java.sql.Statement#setFetchSize(int).
setMaxFieldSize(max)voidFor documentation of this method, see java.sql.Statement#setMaxFieldSize(int).
setMaxRows(max)voidFor documentation of this method, see java.sql.Statement#setMaxRows(int).
setPoolable(poolable)voidFor documentation of this method, see java.sql.Statement#setPoolable(boolean).
setQueryTimeout(seconds)voidFor 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

NameTypeDescription
sqlString

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

NameTypeDescription
sqlString

Return

Boolean

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

NameTypeDescription
sqlString
autoGeneratedKeysInteger

Return

Boolean

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

NameTypeDescription
sqlString
columnIndexesInteger[]

Return

Boolean

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

NameTypeDescription
sqlString
columnNamesString[]

Return

Boolean

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[]

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

NameTypeDescription
sqlString

Return

JdbcResultSet

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

NameTypeDescription
sqlString

Return

Integer

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

NameTypeDescription
sqlString
autoGeneratedKeysInteger

Return

Integer

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

NameTypeDescription
sqlString
columnIndexesInteger[]

Return

Integer

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

NameTypeDescription
sqlString
columnNamesString[]

Return

Integer

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

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

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

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

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

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

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

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

NameTypeDescription
currentInteger

Return

Boolean

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

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

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

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

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

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

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

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

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

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

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

NameTypeDescription
nameString

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

NameTypeDescription
enableBoolean

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

NameTypeDescription
directionInteger

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

NameTypeDescription
rowsInteger

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

NameTypeDescription
maxInteger

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

NameTypeDescription
maxInteger

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

NameTypeDescription
poolableBoolean

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

NameTypeDescription
secondsInteger

Authorization

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

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

发送以下问题的反馈:

此网页
Apps Script
Apps Script
需要帮助?请访问我们的支持页面