A JDBC PreparedStatement
. For documentation of this class, see
java.sql.PreparedStatement
.
Methods
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
Name | Type | Description |
---|---|---|
sql | String |
cancel()
For documentation of this method, see java.sql.Statement#cancel()
.
clearBatch()
For documentation of this method, see java.sql.Statement#clearBatch()
.
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
Name | Type | Description |
---|---|---|
sql | String |
Return
Boolean
execute(sql, autoGeneratedKeys)
For documentation of this method, see java.sql.Statement#execute(String, int)
.
Parameters
Name | Type | Description |
---|---|---|
sql | String | |
autoGeneratedKeys | Integer |
Return
Boolean
execute(sql, columnIndexes)
For documentation of this method, see java.sql.Statement#execute(String, int[])
.
Parameters
Name | Type | Description |
---|---|---|
sql | String | |
columnIndexes | Integer[] |
Return
Boolean
execute(sql, columnNames)
For documentation of this method, see java.sql.Statement#execute(String, String[])
.
Parameters
Name | Type | Description |
---|---|---|
sql | String | |
columnNames | String[] |
Return
Boolean
executeBatch()
For documentation of this method, see java.sql.Statement#executeBatch()
.
Return
Integer[]
executeQuery()
For documentation of this method, see java.sql.PreparedStatement#executeQuery()
.
Return
executeQuery(sql)
For documentation of this method, see java.sql.Statement#executeQuery(String)
.
Parameters
Name | Type | Description |
---|---|---|
sql | String |
Return
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
Name | Type | Description |
---|---|---|
sql | String |
Return
Integer
executeUpdate(sql, autoGeneratedKeys)
For documentation of this method, see java.sql.Statement#executeUpdate(String, int)
.
Parameters
Name | Type | Description |
---|---|---|
sql | String | |
autoGeneratedKeys | Integer |
Return
Integer
executeUpdate(sql, columnIndexes)
For documentation of this method, see java.sql.Statement#executeUpdate(String, int)
.
Parameters
Name | Type | Description |
---|---|---|
sql | String | |
columnIndexes | Integer[] |
Return
Integer
executeUpdate(sql, columnNames)
For documentation of this method, see
java.sql.Statement#executeUpdate(String, String[])
.
Parameters
Name | Type | Description |
---|---|---|
sql | String | |
columnNames | String[] |
Return
Integer
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
getMaxFieldSize()
For documentation of this method, see java.sql.Statement#getMaxFieldSize()
.
Return
Integer
getMetaData()
For documentation of this method, see java.sql.PreparedStatement#getMetaData()
.
Return
getMoreResults()
For documentation of this method, see java.sql.Statement#getMoreResults()
.
Return
Boolean
getMoreResults(current)
For documentation of this method, see java.sql.Statement#getMoreResults(int)
.
Parameters
Name | Type | Description |
---|---|---|
current | Integer |
Return
Boolean
getParameterMetaData()
For documentation of this method, see
java.sql.PreparedStatement#getParameterMetaData()
.
Return
getQueryTimeout()
For documentation of this method, see java.sql.Statement#getQueryTimeout()
.
Return
Integer
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
setArray(parameterIndex, x)
For documentation of this method, see
java.sql.PreparedStatement#setArray(int, java.sql.Array)
.
Parameters
Name | Type | Description |
---|---|---|
parameterIndex | Integer | |
x | JdbcArray |
setBigDecimal(parameterIndex, x)
For documentation of this method, see
java.sql.PreparedStatement#setBigDecimal(int, java.math.BigDecimal)
.
Parameters
Name | Type | Description |
---|---|---|
parameterIndex | Integer | |
x | BigNumber |
setBlob(parameterIndex, x)
For documentation of this method, see
java.sql.PreparedStatement#setBlob(int, java.sql.Blob)
.
Parameters
Name | Type | Description |
---|---|---|
parameterIndex | Integer | |
x | JdbcBlob |
setBoolean(parameterIndex, x)
For documentation of this method, see
java.sql.PreparedStatement#setBoolean(int, boolean)
.
Parameters
Name | Type | Description |
---|---|---|
parameterIndex | Integer | |
x | Boolean |
setByte(parameterIndex, x)
For documentation of this method, see java.sql.PreparedStatement#setByte(int, byte)
.
Parameters
Name | Type | Description |
---|---|---|
parameterIndex | Integer | |
x | Byte |
setBytes(parameterIndex, x)
For documentation of this method, see
java.sql.PreparedStatement#setBytes(int, byte[])
.
Parameters
Name | Type | Description |
---|---|---|
parameterIndex | Integer | |
x | Byte[] |
setClob(parameterIndex, x)
For documentation of this method, see
java.sql.PreparedStatement#setClob(int, java.sql.Clob)
.
Parameters
Name | Type | Description |
---|---|---|
parameterIndex | Integer | |
x | JdbcClob |
setCursorName(name)
For documentation of this method, see java.sql.Statement#setCursorName(String)
.
Parameters
Name | Type | Description |
---|---|---|
name | String |
setDate(parameterIndex, x)
For documentation of this method, see
java.sql.PreparedStatement#setDate(int, java.sql.Date)
.
Parameters
Name | Type | Description |
---|---|---|
parameterIndex | Integer | |
x | JdbcDate |
setDate(parameterIndex, x, timeZone)
For documentation of this method, see
java.sql.PreparedStatement#setDate(int, java.sql.Date, java.util.Calendar)
.
Parameters
Name | Type | Description |
---|---|---|
parameterIndex | Integer | |
x | JdbcDate | |
timeZone | String |
setDouble(parameterIndex, x)
For documentation of this method, see
java.sql.PreparedStatement#setDouble(int, double)
.
Parameters
Name | Type | Description |
---|---|---|
parameterIndex | Integer | |
x | Number |
setEscapeProcessing(enable)
For documentation of this method, see java.sql.Statement#setEscapeProcessing(boolean)
.
Parameters
Name | Type | Description |
---|---|---|
enable | Boolean |
setFetchDirection(direction)
For documentation of this method, see java.sql.Statement#setFetchDirection(int)
.
Parameters
Name | Type | Description |
---|---|---|
direction | Integer |
setFetchSize(rows)
For documentation of this method, see java.sql.Statement#setFetchSize(int)
.
Parameters
Name | Type | Description |
---|---|---|
rows | Integer |
setFloat(parameterIndex, x)
For documentation of this method, see java.sql.PreparedStatement#setFloat(int, float)
.
Parameters
Name | Type | Description |
---|---|---|
parameterIndex | Integer | |
x | Number |
setInt(parameterIndex, x)
For documentation of this method, see java.sql.PreparedStatement#setInt(int, int)
.
Parameters
Name | Type | Description |
---|---|---|
parameterIndex | Integer | |
x | Integer |
setLong(parameterIndex, x)
For documentation of this method, see java.sql.PreparedStatement#setLong(int, long)
.
Parameters
Name | Type | Description |
---|---|---|
parameterIndex | Integer | |
x | Integer |
setMaxFieldSize(max)
For documentation of this method, see java.sql.Statement#setMaxFieldSize(int)
.
Parameters
Name | Type | Description |
---|---|---|
max | Integer |
setMaxRows(max)
For documentation of this method, see java.sql.Statement#setMaxRows(int)
.
Parameters
Name | Type | Description |
---|---|---|
max | Integer |
setNClob(parameterIndex, x)
For documentation of this method, see
java.sql.PreparedStatement#setNClob(int, java.sql.NClob)
.
Parameters
Name | Type | Description |
---|---|---|
parameterIndex | Integer | |
x | JdbcClob |
setNString(parameterIndex, x)
For documentation of this method, see
java.sql.PreparedStatement#setNString(int, String)
.
Parameters
Name | Type | Description |
---|---|---|
parameterIndex | Integer | |
x | String |
setNull(parameterIndex, sqlType)
For documentation of this method, see java.sql.PreparedStatement#setNull(int, int)
.
Parameters
Name | Type | Description |
---|---|---|
parameterIndex | Integer | |
sqlType | Integer |
setNull(parameterIndex, sqlType, typeName)
For documentation of this method, see
java.sql.PreparedStatement#setNull(int, int, String)
.
Parameters
Name | Type | Description |
---|---|---|
parameterIndex | Integer | |
sqlType | Integer | |
typeName | String |
setObject(index, x)
For documentation of this method, see
java.sql.PreparedStatement#setObject(int, Object)
.
Parameters
Name | Type | Description |
---|---|---|
index | Integer | |
x | Object |
setObject(parameterIndex, x, targetSqlType)
For documentation of this method, see
java.sql.PreparedStatement#setObject(int, Object, int)
.
Parameters
Name | Type | Description |
---|---|---|
parameterIndex | Integer | |
x | Object | |
targetSqlType | Integer |
setObject(parameterIndex, x, targetSqlType, scaleOrLength)
For documentation of this method, see
java.sql.PreparedStatement#setObject(int, Object, int, int)
.
Parameters
Name | Type | Description |
---|---|---|
parameterIndex | Integer | |
x | Object | |
targetSqlType | Integer | |
scaleOrLength | Integer |
setPoolable(poolable)
For documentation of this method, see java.sql.Statement#setPoolable(boolean)
.
Parameters
Name | Type | Description |
---|---|---|
poolable | Boolean |
setQueryTimeout(seconds)
For documentation of this method, see java.sql.Statement#setQueryTimeout(int)
.
Parameters
Name | Type | Description |
---|---|---|
seconds | Integer |
setRef(parameterIndex, x)
For documentation of this method, see
java.sql.PreparedStatement#setRef(int, java.sql.Ref)
.
Parameters
Name | Type | Description |
---|---|---|
parameterIndex | Integer | |
x | JdbcRef |
setRowId(parameterIndex, x)
For documentation of this method, see
java.sql.PreparedStatement#setRowId(int, java.sql.RowId)
.
Parameters
Name | Type | Description |
---|---|---|
parameterIndex | Integer | |
x | JdbcRowId |
setSQLXML(parameterIndex, x)
For documentation of this method, see
java.sql.PreparedStatement#setSQLXML(int, java.sql.SQLXML)
.
Parameters
Name | Type | Description |
---|---|---|
parameterIndex | Integer | |
x | JdbcSQLXML |
setShort(parameterIndex, x)
For documentation of this method, see java.sql.PreparedStatement#setShort(int, short)
.
Parameters
Name | Type | Description |
---|---|---|
parameterIndex | Integer | |
x | Integer |
setString(parameterIndex, x)
For documentation of this method, see
java.sql.PreparedStatement#setString(int, String)
.
Parameters
Name | Type | Description |
---|---|---|
parameterIndex | Integer | |
x | String |
setTime(parameterIndex, x)
For documentation of this method, see
java.sql.PreparedStatement#setTime(int, java.sql.Time)
.
Parameters
Name | Type | Description |
---|---|---|
parameterIndex | Integer | |
x | JdbcTime |
setTime(parameterIndex, x, timeZone)
For documentation of this method, see
java.sql.PreparedStatement#setTime(int, java.sql.Time, java.util.Calendar)
.
Parameters
Name | Type | Description |
---|---|---|
parameterIndex | Integer | |
x | JdbcTime | |
timeZone | String |
setTimestamp(parameterIndex, x)
For documentation of this method, see
java.sql.PreparedStatement#setTimestamp(int, java.sql.Timestamp)
.
Parameters
Name | Type | Description |
---|---|---|
parameterIndex | Integer | |
x | JdbcTimestamp |
setTimestamp(parameterIndex, x, timeZone)
For documentation of this method, see
java.sql.PreparedStatement#setTimestamp(int, java.sql.Timestamp, java.util.Calendar)
.
Parameters
Name | Type | Description |
---|---|---|
parameterIndex | Integer | |
x | JdbcTimestamp | |
timeZone | String |
setURL(parameterIndex, x)
For documentation of this method, see
java.sql.PreparedStatement#setURL(int, java.net.URL)
.
Parameters
Name | Type | Description |
---|---|---|
parameterIndex | Integer | |
x | String |