Google Apps Script

Class JdbcPreparedStatement

A JDBC PreparedStatement.

See also

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


addBatch(sql)

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

Parameters

NameTypeDescription
sqlString

cancel()

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


clearBatch()

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


clearParameters()

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


clearWarnings()

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


close()

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


execute()

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

Return

Boolean


execute(sql)

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

Parameters

NameTypeDescription
sqlString

Return

Boolean


execute(sql, autoGeneratedKeys)

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

Parameters

NameTypeDescription
sqlString
autoGeneratedKeysInteger

Return

Boolean


execute(sql, columnIndexes)

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

Parameters

NameTypeDescription
sqlString
columnIndexesInteger[]

Return

Boolean


execute(sql, columnNames)

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

Parameters

NameTypeDescription
sqlString
columnNamesString[]

Return

Boolean


executeBatch()

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

Return

Integer[]


executeQuery()

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

Return

JdbcResultSet


executeQuery(sql)

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

Parameters

NameTypeDescription
sqlString

Return

JdbcResultSet


executeUpdate()

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

Return

Integer


executeUpdate(sql)

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

Parameters

NameTypeDescription
sqlString

Return

Integer


executeUpdate(sql, autoGeneratedKeys)

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

Parameters

NameTypeDescription
sqlString
autoGeneratedKeysInteger

Return

Integer


executeUpdate(sql, columnIndexes)

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

Parameters

NameTypeDescription
sqlString
columnIndexesInteger[]

Return

Integer


executeUpdate(sql, columnNames)

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

Parameters

NameTypeDescription
sqlString
columnNamesString[]

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


getMetaData()

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

Return

JdbcResultSetMetaData


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

NameTypeDescription
currentInteger

Return

Boolean


getParameterMetaData()

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

Return

JdbcParameterMetaData


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


setArray(parameterIndex, x)

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

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcArray

setBigDecimal(parameterIndex, x)

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

Parameters

NameTypeDescription
parameterIndexInteger
xBigNumber

setBlob(parameterIndex, x)

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

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcBlob

setBoolean(parameterIndex, x)

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

Parameters

NameTypeDescription
parameterIndexInteger
xBoolean

setByte(parameterIndex, x)

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

Parameters

NameTypeDescription
parameterIndexInteger
xByte

setBytes(parameterIndex, x)

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

Parameters

NameTypeDescription
parameterIndexInteger
xByte[]

setClob(parameterIndex, x)

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

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcClob

setCursorName(name)

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

Parameters

NameTypeDescription
nameString

setDate(parameterIndex, x)

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

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcDate

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

setDouble(parameterIndex, x)

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

Parameters

NameTypeDescription
parameterIndexInteger
xNumber

setEscapeProcessing(enable)

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

Parameters

NameTypeDescription
enableBoolean

setFetchDirection(direction)

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

Parameters

NameTypeDescription
directionInteger

setFetchSize(rows)

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

Parameters

NameTypeDescription
rowsInteger

setFloat(parameterIndex, x)

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

Parameters

NameTypeDescription
parameterIndexInteger
xNumber

setInt(parameterIndex, x)

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

Parameters

NameTypeDescription
parameterIndexInteger
xInteger

setLong(parameterIndex, x)

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

Parameters

NameTypeDescription
parameterIndexInteger
xInteger

setMaxFieldSize(max)

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

Parameters

NameTypeDescription
maxInteger

setMaxRows(max)

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

Parameters

NameTypeDescription
maxInteger

setNClob(parameterIndex, x)

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

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcClob

setNString(parameterIndex, x)

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

Parameters

NameTypeDescription
parameterIndexInteger
xString

setNull(parameterIndex, sqlType)

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

Parameters

NameTypeDescription
parameterIndexInteger
sqlTypeInteger

setNull(parameterIndex, sqlType, typeName)

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

Parameters

NameTypeDescription
parameterIndexInteger
sqlTypeInteger
typeNameString

setObject(index, x)

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

Parameters

NameTypeDescription
indexInteger
xObject

setObject(parameterIndex, x, targetSqlType)

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

Parameters

NameTypeDescription
parameterIndexInteger
xObject
targetSqlTypeInteger

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

setPoolable(poolable)

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

Parameters

NameTypeDescription
poolableBoolean

setQueryTimeout(seconds)

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

Parameters

NameTypeDescription
secondsInteger

setRef(parameterIndex, x)

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

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcRef

setRowId(parameterIndex, x)

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

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcRowId

setSQLXML(parameterIndex, x)

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

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcSQLXML

setShort(parameterIndex, x)

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

Parameters

NameTypeDescription
parameterIndexInteger
xInteger

setString(parameterIndex, x)

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

Parameters

NameTypeDescription
parameterIndexInteger
xString

setTime(parameterIndex, x)

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

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcTime

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

setTimestamp(parameterIndex, x)

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

Parameters

NameTypeDescription
parameterIndexInteger
xJdbcTimestamp

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

setURL(parameterIndex, x)

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

Parameters

NameTypeDescription
parameterIndexInteger
xString

Authentication required

You need to be signed in with Google+ to do that.

Signing you in...

Google Developers needs your permission to do that.