Class JdbcPreparedStatement

JdbcPreparedStatement

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

Methods

MethodReturn typeBrief description
addBatch()voidFor documentation of this method, see java.sql.PreparedStatement#addBatch().
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().
clearParameters()voidFor documentation of this method, see java.sql.PreparedStatement#clearParameters().
clearWarnings()voidFor documentation of this method, see java.sql.Statement#clearWarnings().
close()voidFor documentation of this method, see java.sql.Statement#close().
execute()BooleanFor documentation of this method, see java.sql.PreparedStatement#execute().
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()JdbcResultSetFor documentation of this method, see java.sql.PreparedStatement#executeQuery().
executeQuery(sql)JdbcResultSetFor documentation of this method, see java.sql.Statement#executeQuery(String).
executeUpdate()IntegerFor documentation of this method, see java.sql.PreparedStatement#executeUpdate().
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().
getMetaData()JdbcResultSetMetaDataFor documentation of this method, see java.sql.PreparedStatement#getMetaData().
getMoreResults()BooleanFor documentation of this method, see java.sql.Statement#getMoreResults().
getMoreResults(current)BooleanFor documentation of this method, see java.sql.Statement#getMoreResults(int).
getParameterMetaData()JdbcParameterMetaDataFor documentation of this method, see java.sql.PreparedStatement#getParameterMetaData().
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().
setArray(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setArray(int, java.sql.Array).
setBigDecimal(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setBigDecimal(int, java.math.BigDecimal).
setBlob(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setBlob(int, java.sql.Blob).
setBoolean(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setBoolean(int, boolean).
setByte(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setByte(int, byte).
setBytes(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setBytes(int, byte[]).
setClob(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setClob(int, java.sql.Clob).
setCursorName(name)voidFor documentation of this method, see java.sql.Statement#setCursorName(String).
setDate(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setDate(int, java.sql.Date).
setDate(parameterIndex, x, timeZone)voidFor documentation of this method, see java.sql.PreparedStatement#setDate(int, java.sql.Date, java.util.Calendar).
setDouble(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setDouble(int, double).
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).
setFloat(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setFloat(int, float).
setInt(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setInt(int, int).
setLong(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setLong(int, long).
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).
setNClob(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setNClob(int, java.sql.NClob).
setNString(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setNString(int, String).
setNull(parameterIndex, sqlType)voidFor documentation of this method, see java.sql.PreparedStatement#setNull(int, int).
setNull(parameterIndex, sqlType, typeName)voidFor documentation of this method, see java.sql.PreparedStatement#setNull(int, int, String).
setObject(index, x)voidFor documentation of this method, see java.sql.PreparedStatement#setObject(int, Object).
setObject(parameterIndex, x, targetSqlType)voidFor documentation of this method, see java.sql.PreparedStatement#setObject(int, Object, int).
setObject(parameterIndex, x, targetSqlType, scaleOrLength)voidFor documentation of this method, see java.sql.PreparedStatement#setObject(int, Object, int, 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).
setRef(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setRef(int, java.sql.Ref).
setRowId(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setRowId(int, java.sql.RowId).
setSQLXML(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setSQLXML(int, java.sql.SQLXML).
setShort(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setShort(int, short).
setString(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setString(int, String).
setTime(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setTime(int, java.sql.Time).
setTime(parameterIndex, x, timeZone)voidFor documentation of this method, see java.sql.PreparedStatement#setTime(int, java.sql.Time, java.util.Calendar).
setTimestamp(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setTimestamp(int, java.sql.Timestamp).
setTimestamp(parameterIndex, x, timeZone)voidFor documentation of this method, see java.sql.PreparedStatement#setTimestamp(int, java.sql.Timestamp, java.util.Calendar).
setURL(parameterIndex, x)voidFor documentation of this method, see java.sql.PreparedStatement#setURL(int, java.net.URL).

Detailed documentation

addBatch()

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

Authorization

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

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

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

clearParameters()

For documentation of this method, see java.sql.PreparedStatement#clearParameters().

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

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

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)

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

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

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

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

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

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)

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

getMetaData()

For documentation of this method, see java.sql.PreparedStatement#getMetaData().

Return

JdbcResultSetMetaData

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

getParameterMetaData()

For documentation of this method, see java.sql.PreparedStatement#getParameterMetaData().

Return

JdbcParameterMetaData

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

setArray(parameterIndex, x)

For documentation of this method, see java.sql.PreparedStatement#setArray(int, java.sql.Array).

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcArray

Authorization

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

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

setBigDecimal(parameterIndex, x)

For documentation of this method, see java.sql.PreparedStatement#setBigDecimal(int, java.math.BigDecimal).

Parameters

NameTypeDescription
parameterIndexInteger
xBigNumber

Authorization

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

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

setBlob(parameterIndex, x)

For documentation of this method, see java.sql.PreparedStatement#setBlob(int, java.sql.Blob).

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcBlob

Authorization

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

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

setBoolean(parameterIndex, x)

For documentation of this method, see java.sql.PreparedStatement#setBoolean(int, boolean).

Parameters

NameTypeDescription
parameterIndexInteger
xBoolean

Authorization

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

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

setByte(parameterIndex, x)

For documentation of this method, see java.sql.PreparedStatement#setByte(int, byte).

Parameters

NameTypeDescription
parameterIndexInteger
xByte

Authorization

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

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

setBytes(parameterIndex, x)

For documentation of this method, see java.sql.PreparedStatement#setBytes(int, byte[]).

Parameters

NameTypeDescription
parameterIndexInteger
xByte[]

Authorization

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

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

setClob(parameterIndex, x)

For documentation of this method, see java.sql.PreparedStatement#setClob(int, java.sql.Clob).

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcClob

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

setDate(parameterIndex, x)

For documentation of this method, see java.sql.PreparedStatement#setDate(int, java.sql.Date).

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcDate

Authorization

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

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

setDate(parameterIndex, x, timeZone)

For documentation of this method, see java.sql.PreparedStatement#setDate(int, java.sql.Date, java.util.Calendar).

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcDate
timeZoneString

Authorization

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

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

setDouble(parameterIndex, x)

For documentation of this method, see java.sql.PreparedStatement#setDouble(int, double).

Parameters

NameTypeDescription
parameterIndexInteger
xNumber

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

setFloat(parameterIndex, x)

For documentation of this method, see java.sql.PreparedStatement#setFloat(int, float).

Parameters

NameTypeDescription
parameterIndexInteger
xNumber

Authorization

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

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

setInt(parameterIndex, x)

For documentation of this method, see java.sql.PreparedStatement#setInt(int, int).

Parameters

NameTypeDescription
parameterIndexInteger
xInteger

Authorization

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

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

setLong(parameterIndex, x)

For documentation of this method, see java.sql.PreparedStatement#setLong(int, long).

Parameters

NameTypeDescription
parameterIndexInteger
xInteger

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

setNClob(parameterIndex, x)

For documentation of this method, see java.sql.PreparedStatement#setNClob(int, java.sql.NClob).

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcClob

Authorization

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

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

setNString(parameterIndex, x)

For documentation of this method, see java.sql.PreparedStatement#setNString(int, String).

Parameters

NameTypeDescription
parameterIndexInteger
xString

Authorization

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

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

setNull(parameterIndex, sqlType)

For documentation of this method, see java.sql.PreparedStatement#setNull(int, int).

Parameters

NameTypeDescription
parameterIndexInteger
sqlTypeInteger

Authorization

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

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

setNull(parameterIndex, sqlType, typeName)

For documentation of this method, see java.sql.PreparedStatement#setNull(int, int, String).

Parameters

NameTypeDescription
parameterIndexInteger
sqlTypeInteger
typeNameString

Authorization

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

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

setObject(index, x)

For documentation of this method, see java.sql.PreparedStatement#setObject(int, Object).

Parameters

NameTypeDescription
indexInteger
xObject

Authorization

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

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

setObject(parameterIndex, x, targetSqlType)

For documentation of this method, see java.sql.PreparedStatement#setObject(int, Object, int).

Parameters

NameTypeDescription
parameterIndexInteger
xObject
targetSqlTypeInteger

Authorization

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

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

setObject(parameterIndex, x, targetSqlType, scaleOrLength)

For documentation of this method, see java.sql.PreparedStatement#setObject(int, Object, int, int).

Parameters

NameTypeDescription
parameterIndexInteger
xObject
targetSqlTypeInteger
scaleOrLengthInteger

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

setRef(parameterIndex, x)

For documentation of this method, see java.sql.PreparedStatement#setRef(int, java.sql.Ref).

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcRef

Authorization

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

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

setRowId(parameterIndex, x)

For documentation of this method, see java.sql.PreparedStatement#setRowId(int, java.sql.RowId).

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcRowId

Authorization

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

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

setSQLXML(parameterIndex, x)

For documentation of this method, see java.sql.PreparedStatement#setSQLXML(int, java.sql.SQLXML).

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcSQLXML

Authorization

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

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

setShort(parameterIndex, x)

For documentation of this method, see java.sql.PreparedStatement#setShort(int, short).

Parameters

NameTypeDescription
parameterIndexInteger
xInteger

Authorization

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

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

setString(parameterIndex, x)

For documentation of this method, see java.sql.PreparedStatement#setString(int, String).

Parameters

NameTypeDescription
parameterIndexInteger
xString

Authorization

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

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

setTime(parameterIndex, x)

For documentation of this method, see java.sql.PreparedStatement#setTime(int, java.sql.Time).

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcTime

Authorization

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

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

setTime(parameterIndex, x, timeZone)

For documentation of this method, see java.sql.PreparedStatement#setTime(int, java.sql.Time, java.util.Calendar).

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcTime
timeZoneString

Authorization

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

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

setTimestamp(parameterIndex, x)

For documentation of this method, see java.sql.PreparedStatement#setTimestamp(int, java.sql.Timestamp).

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcTimestamp

Authorization

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

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

setTimestamp(parameterIndex, x, timeZone)

For documentation of this method, see java.sql.PreparedStatement#setTimestamp(int, java.sql.Timestamp, java.util.Calendar).

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcTimestamp
timeZoneString

Authorization

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

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

setURL(parameterIndex, x)

For documentation of this method, see java.sql.PreparedStatement#setURL(int, java.net.URL).

Parameters

NameTypeDescription
parameterIndexInteger
xString

Authorization

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

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

Send feedback about...

Apps Script
Apps Script
Need help? Visit our support page.