Android APIs
public interface

PreparedStatement

implements Statement
java.sql.PreparedStatement
Known Indirect Subclasses

Class Overview

An interface for a precompiled SQL Statement.

An SQL Statement is put into a PreparedStatement and is precompiled so that it can be executed efficiently multiple times.

Setter methods are supplied in the PreparedStatement interface for the setting of IN parameters for the statement. The setter method used for each IN parameter must match the parameter's type.

Summary

[Expand]
Inherited Constants
From interface java.sql.Statement
Public Methods
abstract void addBatch()
Add a set of parameters to the PreparedStatement's command batch.
abstract void clearParameters()
Clear the current parameter values.
abstract boolean execute()
Executes the SQL statement in this PreparedStatement.
abstract ResultSet executeQuery()
Executes the SQL query in the PreparedStatement and returns the ResultSet generated by the query.
abstract int executeUpdate()
Invokes the SQL command contained within the prepared statement.
abstract ResultSetMetaData getMetaData()
Returns a ResultSetMetaData describing the ResultSet that would be produced by execution of the PreparedStatement.
abstract ParameterMetaData getParameterMetaData()
Gets information about the parameters of the PreparedStatement.
abstract void setArray(int parameterIndex, Array theArray)
Sets the value of a specified parameter to the supplied Array.
abstract void setAsciiStream(int parameterIndex, InputStream theInputStream, int length)
Sets the value of a specified parameter to the content of a supplied InputStream, which has a specified number of bytes.
abstract void setAsciiStream(int parameterIndex, InputStream inputStream)
Sets the value of the specified parameter to the bytes from inputStream.
abstract void setAsciiStream(int parameterIndex, InputStream inputStream, long length)
Sets the value of the specified parameter to the next length bytes from inputStream.
abstract void setBigDecimal(int parameterIndex, BigDecimal theBigDecimal)
Sets the value of a specified parameter to a supplied java.math.BigDecimal value.
abstract void setBinaryStream(int parameterIndex, InputStream inputStream)
Sets the value of the specified parameter to the bytes from inputStream.
abstract void setBinaryStream(int parameterIndex, InputStream inputStream, long length)
Sets the value of the specified parameter to the next length bytes from inputStream.
abstract void setBinaryStream(int parameterIndex, InputStream theInputStream, int length)
Sets the value of a specified parameter to the content of a supplied binary InputStream, which has a specified number of bytes.
abstract void setBlob(int parameterIndex, InputStream inputStream, long length)
Sets the value of the specified parameter to the next length bytes from inputStream.
abstract void setBlob(int parameterIndex, InputStream inputStream)
Sets the value of the specified parameter to the bytes from inputStream.
abstract void setBlob(int parameterIndex, Blob theBlob)
Sets the value of a specified parameter to the given Blob object.
abstract void setBoolean(int parameterIndex, boolean theBoolean)
Sets the value of a specified parameter to a supplied boolean value.
abstract void setByte(int parameterIndex, byte theByte)
Sets the value of a specified parameter to a supplied byte value.
abstract void setBytes(int parameterIndex, byte[] theBytes)
Sets the value of a specified parameter to a supplied array of bytes.
abstract void setCharacterStream(int parameterIndex, Reader reader)
Sets the value of the specified parameter to the characters from reader.
abstract void setCharacterStream(int parameterIndex, Reader reader, int length)
Sets the value of a specified parameter to the character content of a Reader object, with the specified length of character data.
abstract void setCharacterStream(int parameterIndex, Reader reader, long length)
Sets the value of the specified parameter to the next length characters from reader.
abstract void setClob(int parameterIndex, Reader reader)
Sets the value of the specified parameter to the characters from reader.
abstract void setClob(int parameterIndex, Reader reader, long length)
Sets the value of the specified parameter to the next length characters from reader.
abstract void setClob(int parameterIndex, Clob theClob)
Sets the value of a specified parameter to the given Clob object.
abstract void setDate(int parameterIndex, Date theDate, Calendar cal)
Sets the value of a specified parameter to a supplied java.sql.Date value, using a supplied Calendar to map the Date.
abstract void setDate(int parameterIndex, Date theDate)
Sets the value of a specified parameter to a supplied java.sql.Date value.
abstract void setDouble(int parameterIndex, double theDouble)
Sets the value of a specified parameter to a supplied double value.
abstract void setFloat(int parameterIndex, float theFloat)
Sets the value of a specified parameter to to a supplied float value.
abstract void setInt(int parameterIndex, int theInt)
Sets the value of a specified parameter to a supplied int value.
abstract void setLong(int parameterIndex, long theLong)
Sets the value of a specified parameter to a supplied long value.
abstract void setNCharacterStream(int parameterIndex, Reader reader)
Sets the value of the specified parameter to the characters from reader.
abstract void setNCharacterStream(int parameterIndex, Reader reader, long length)
Sets the value of the specified parameter to the next length characters from reader.
abstract void setNClob(int parameterIndex, Reader reader)
Sets the value of the specified parameter to the characters from reader.
abstract void setNClob(int parameterIndex, NClob value)
Sets the value of the specified parameter to value.
abstract void setNClob(int parameterIndex, Reader reader, long length)
Sets the value of the specified parameter to the next length characters from reader.
abstract void setNString(int parameterIndex, String theString)
Sets the value of a specified parameter to a supplied string.
abstract void setNull(int parameterIndex, int sqlType)
Sets the value of a specified parameter to SQL NULL.
abstract void setNull(int paramIndex, int sqlType, String typeName)
Sets the value of a specified parameter to SQL NULL.
abstract void setObject(int parameterIndex, Object theObject)
Sets the value of a specified parameter using a supplied object.
abstract void setObject(int parameterIndex, Object theObject, int targetSqlType, int scale)
Sets the value of a specified parameter using a supplied object.
abstract void setObject(int parameterIndex, Object theObject, int targetSqlType)
Sets the value of a specified parameter using a supplied object.
abstract void setRef(int parameterIndex, Ref theRef)
Sets the value of a specified parameter to a supplied REF() value.
abstract void setRowId(int parameterIndex, RowId theRowId)
Sets the value of a specified parameter to a supplied java.sql.RowId.
abstract void setSQLXML(int parameterIndex, SQLXML xmlObject)
Sets the value of the specified parameter to the value of xmlObject.
abstract void setShort(int parameterIndex, short theShort)
Sets the value of a specified parameter to a supplied short value.
abstract void setString(int parameterIndex, String theString)
Sets the value of a specified parameter to a supplied string.
abstract void setTime(int parameterIndex, Time theTime)
Sets the value of a specified parameter to a supplied java.sql.Time value.
abstract void setTime(int parameterIndex, Time theTime, Calendar cal)
Sets the value of a specified parameter to a supplied java.sql.Time value, using a supplied Calendar.
abstract void setTimestamp(int parameterIndex, Timestamp theTimestamp, Calendar cal)
Sets the value of a specified parameter to a supplied java.sql.Timestamp value, using the supplied Calendar.
abstract void setTimestamp(int parameterIndex, Timestamp theTimestamp)
Sets the value of a specified parameter to a supplied java.sql.Timestamp value.
abstract void setURL(int parameterIndex, URL theURL)
Sets the value of a specified parameter to a supplied java.net.URL.
abstract void setUnicodeStream(int parameterIndex, InputStream theInputStream, int length)
This method was deprecated in API level 1. Use setCharacterStream(int, Reader, int)
[Expand]
Inherited Methods
From interface java.sql.Statement
From interface java.sql.Wrapper
From interface java.lang.AutoCloseable

Public Methods

public abstract void addBatch ()

Added in API level 1

Add a set of parameters to the PreparedStatement's command batch.

Throws
SQLException if a database error happens.

public abstract void clearParameters ()

Added in API level 1

Clear the current parameter values.

Typically, parameter values are retained for multiple executions of the Statement. Setting a parameter value replaces the previous value. This method clears the values for all parameters, releasing all resources used by those parameters.

Throws
SQLException if a database error happens.

public abstract boolean execute ()

Added in API level 1

Executes the SQL statement in this PreparedStatement.

A PreparedStatement may return multiple results. The execute method executes the PreparedStatement and returns a flag indicating the kind of result produced by the action. The methods getResultSet or getUpdateCount are used to retrieve the first result, and the second and subsequent results are retrieved with getMoreResults.

Returns
boolean true if the result of the execution is a ResultSet, false if there is no result or if the result is an update count.
Throws
SQLException if a database error happens.

public abstract ResultSet executeQuery ()

Added in API level 1

Executes the SQL query in the PreparedStatement and returns the ResultSet generated by the query.

Returns
ResultSet the ResultSet generated by the query, never null.
Throws
SQLException if a database error happens or if the SQL statement does not produce a ResultSet.

public abstract int executeUpdate ()

Added in API level 1

Invokes the SQL command contained within the prepared statement. This must be INSERT, UPDATE, DELETE, or a command that returns nothing.

Returns
int the number of affected rows for INSERT, UPDATE or DELETE statements, 0 for statements that return nothing.
Throws
SQLException if a database error happens or if the SQL statement returns a ResultSet.

public abstract ResultSetMetaData getMetaData ()

Added in API level 1

Returns a ResultSetMetaData describing the ResultSet that would be produced by execution of the PreparedStatement.

It is possible to know the metadata for the ResultSet without executing the PreparedStatement, because the PreparedStatement is precompiled. As a result the metadata can be queried ahead of time without actually executing the statement.

Returns
ResultSetMetaData a ResultSetMetaData object with the information about the columns of the ResultSet, if the driver can return a ResultSetMetaData. null otherwise.
Throws
SQLException if there is a database error.

public abstract ParameterMetaData getParameterMetaData ()

Added in API level 1

Gets information about the parameters of the PreparedStatement.

Returns
ParameterMetaData a ParameterMetaData object which holds information about the number, type, and properties of the parameters of this PreparedStatement.
Throws
SQLException if a database error happens.

public abstract void setArray (int parameterIndex, Array theArray)

Added in API level 1

Sets the value of a specified parameter to the supplied Array.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
theArray Array: a java.sql.Array giving the new value of the parameter at parameterIndex.
Throws
SQLException if a database error happens.

See also:

public abstract void setAsciiStream (int parameterIndex, InputStream theInputStream, int length)

Added in API level 1

Sets the value of a specified parameter to the content of a supplied InputStream, which has a specified number of bytes.

This is a good method for setting an SQL LONGVARCHAR parameter where the length of the data is large. Data is read from the InputStream until end-of-file is reached or the specified number of bytes is copied.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
theInputStream InputStream: the ASCII InputStream carrying the data to which the parameter at parameterIndex is set.
length int: the number of bytes in the InputStream to copy to the parameter.
Throws
SQLException if a database error happens.

public abstract void setAsciiStream (int parameterIndex, InputStream inputStream)

Added in API level 9

Sets the value of the specified parameter to the bytes from inputStream.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
inputStream InputStream: the InputStream
Throws
SQLException if a database error happens.

public abstract void setAsciiStream (int parameterIndex, InputStream inputStream, long length)

Added in API level 9

Sets the value of the specified parameter to the next length bytes from inputStream.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
inputStream InputStream: the InputStream
length long: character count
Throws
SQLException if a database error happens.

public abstract void setBigDecimal (int parameterIndex, BigDecimal theBigDecimal)

Added in API level 1

Sets the value of a specified parameter to a supplied java.math.BigDecimal value.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
theBigDecimal BigDecimal: the value to which the parameter at parameterIndex is set.
Throws
SQLException if a database error happens.

See also:

public abstract void setBinaryStream (int parameterIndex, InputStream inputStream)

Added in API level 9

Sets the value of the specified parameter to the bytes from inputStream.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
inputStream InputStream: the InputStream
Throws
SQLException if a database error happens.

public abstract void setBinaryStream (int parameterIndex, InputStream inputStream, long length)

Added in API level 9

Sets the value of the specified parameter to the next length bytes from inputStream.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
inputStream InputStream: the InputStream
length long: character count
Throws
SQLException if a database error happens.

public abstract void setBinaryStream (int parameterIndex, InputStream theInputStream, int length)

Added in API level 1

Sets the value of a specified parameter to the content of a supplied binary InputStream, which has a specified number of bytes.

Use this method when a large amount of data needs to be set into a LONGVARBINARY parameter.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
theInputStream InputStream: the binary InputStream carrying the data to update the parameter.
length int: the number of bytes in the InputStream to copy to the parameter.
Throws
SQLException if a database error happens.

public abstract void setBlob (int parameterIndex, InputStream inputStream, long length)

Added in API level 9

Sets the value of the specified parameter to the next length bytes from inputStream.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
inputStream InputStream: the InputStream
length long: character count
Throws
SQLException if a database error happens.

public abstract void setBlob (int parameterIndex, InputStream inputStream)

Added in API level 9

Sets the value of the specified parameter to the bytes from inputStream.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
inputStream InputStream: the InputStream
Throws
SQLException if a database error happens.

public abstract void setBlob (int parameterIndex, Blob theBlob)

Added in API level 1

Sets the value of a specified parameter to the given Blob object.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
theBlob Blob: the java.sql.Blob to which the parameter at parameterIndex is set.
Throws
SQLException if a database error happens.

See also:

public abstract void setBoolean (int parameterIndex, boolean theBoolean)

Added in API level 1

Sets the value of a specified parameter to a supplied boolean value.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
theBoolean boolean: the boolean value to which the parameter at parameterIndex is set.
Throws
SQLException if a database error happens.

public abstract void setByte (int parameterIndex, byte theByte)

Added in API level 1

Sets the value of a specified parameter to a supplied byte value.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
theByte byte: the byte value to which the parameter at parameterIndex is set.
Throws
SQLException if a database error happens.

public abstract void setBytes (int parameterIndex, byte[] theBytes)

Added in API level 1

Sets the value of a specified parameter to a supplied array of bytes. The array is mapped to a VARBINARY or LONGVARBINARY in the database.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
theBytes byte: the array of bytes to which the parameter at parameterIndex is set.
Throws
SQLException if a database error happens.

public abstract void setCharacterStream (int parameterIndex, Reader reader)

Added in API level 9

Sets the value of the specified parameter to the characters from reader.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
reader Reader: the Reader
Throws
SQLException if a database error happens.

public abstract void setCharacterStream (int parameterIndex, Reader reader, int length)

Added in API level 1

Sets the value of a specified parameter to the character content of a Reader object, with the specified length of character data.

Data is read from the Reader until end-of-file is reached or the specified number of characters are copied.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1
reader Reader: the java.io.Reader containing the character data.
length int: the number of characters to be read.
Throws
SQLException if a database error happens.

public abstract void setCharacterStream (int parameterIndex, Reader reader, long length)

Added in API level 9

Sets the value of the specified parameter to the next length characters from reader.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
reader Reader: the Reader
length long: character count
Throws
SQLException if a database error happens.

public abstract void setClob (int parameterIndex, Reader reader)

Added in API level 9

Sets the value of the specified parameter to the characters from reader.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
reader Reader: the Reader
Throws
SQLException if a database error happens.

public abstract void setClob (int parameterIndex, Reader reader, long length)

Added in API level 9

Sets the value of the specified parameter to the next length characters from reader.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
reader Reader: the Reader
length long: character count
Throws
SQLException if a database error happens.

public abstract void setClob (int parameterIndex, Clob theClob)

Added in API level 1

Sets the value of a specified parameter to the given Clob object.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
theClob Clob: a java.sql.Clob holding the data to which the parameter at parameterIndex is set.
Throws
SQLException if a database error happens.

public abstract void setDate (int parameterIndex, Date theDate, Calendar cal)

Added in API level 1

Sets the value of a specified parameter to a supplied java.sql.Date value, using a supplied Calendar to map the Date. The Calendar allows the application to control the timezone used to compute the SQL DATE in the database - without the supplied Calendar, the driver uses the VM defaults. See "Be wary of the default locale".

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
theDate Date: a java.sql.Date to which the parameter at parameterIndex is set.
cal Calendar: a Calendar to use to construct the SQL DATE value.
Throws
SQLException if a database error happens.

See also:

public abstract void setDate (int parameterIndex, Date theDate)

Added in API level 1

Sets the value of a specified parameter to a supplied java.sql.Date value.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
theDate Date: a java.sql.Date to which the parameter at parameterIndex is set.
Throws
SQLException if a database error happens.

public abstract void setDouble (int parameterIndex, double theDouble)

Added in API level 1

Sets the value of a specified parameter to a supplied double value.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
theDouble double: the double value to which the parameter at parameterIndex is set.
Throws
SQLException if a database error happens.

public abstract void setFloat (int parameterIndex, float theFloat)

Added in API level 1

Sets the value of a specified parameter to to a supplied float value.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
theFloat float: the float value to update the parameter.
Throws
SQLException if a database error happens.

public abstract void setInt (int parameterIndex, int theInt)

Added in API level 1

Sets the value of a specified parameter to a supplied int value.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
theInt int: the int value to which the parameter at parameterIndex is set.
Throws
SQLException if a database error happens.

public abstract void setLong (int parameterIndex, long theLong)

Added in API level 1

Sets the value of a specified parameter to a supplied long value.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
theLong long: the long value to which the parameter at parameterIndex is set.
Throws
SQLException if a database error happens.

public abstract void setNCharacterStream (int parameterIndex, Reader reader)

Added in API level 9

Sets the value of the specified parameter to the characters from reader.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
reader Reader: the Reader
Throws
SQLException if a database error happens.

public abstract void setNCharacterStream (int parameterIndex, Reader reader, long length)

Added in API level 9

Sets the value of the specified parameter to the next length characters from reader.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
reader Reader: the Reader
length long: character count
Throws
SQLException if a database error happens.

public abstract void setNClob (int parameterIndex, Reader reader)

Added in API level 9

Sets the value of the specified parameter to the characters from reader.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
reader Reader: the Reader
Throws
SQLException if a database error happens.

public abstract void setNClob (int parameterIndex, NClob value)

Added in API level 9

Sets the value of the specified parameter to value.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
value NClob: the NClob to which the parameter at parameterIndex is set.
Throws
SQLException if a database error happens.

public abstract void setNClob (int parameterIndex, Reader reader, long length)

Added in API level 9

Sets the value of the specified parameter to the next length characters from reader.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
reader Reader: the Reader
length long: character count
Throws
SQLException if a database error happens.

public abstract void setNString (int parameterIndex, String theString)

Added in API level 9

Sets the value of a specified parameter to a supplied string.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
theString String: the String to which the parameter at parameterIndex is set.
Throws
SQLException if a database error happens.

public abstract void setNull (int parameterIndex, int sqlType)

Added in API level 1

Sets the value of a specified parameter to SQL NULL. Don't use this version of setNull for User Defined Types (UDT) or for REF type parameters.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
sqlType int: the SQL type of the parameter, as defined in java.sql.Types.
Throws
SQLException if a database error happens.

public abstract void setNull (int paramIndex, int sqlType, String typeName)

Added in API level 1

Sets the value of a specified parameter to SQL NULL. This version of setNull should be used for User Defined Types (UDTs) and also REF types. UDTs can be STRUCT, DISTINCT, JAVA_OBJECT and named array types.

Applications must provide the SQL type code and also a fully qualified SQL type name when supplying a NULL UDT or REF. For a UDT, the type name is the type name of the parameter itself, but for a REF parameter the type name is the type name of the referenced type.

Parameters
paramIndex int: the parameter number index, where the first parameter has index 1.
sqlType int: the SQL type of the parameter, as defined in java.sql.Types.
typeName String: the fully qualified name of a UDT or REF type - ignored if the parameter is not a UDT.
Throws
SQLException if a database error happens.

See also:

public abstract void setObject (int parameterIndex, Object theObject)

Added in API level 1

Sets the value of a specified parameter using a supplied object.

There is a standard mapping from Java types to SQL types, defined in the JDBC specification. The passed object is then transformed into the appropriate SQL type, and then transferred to the database. setObject can be used to pass abstract data types unique to the database, by using a JDBC driver specific Java type. If the object's class implements the interface SQLData, the JDBC driver calls SQLData.writeSQL to write it to the SQL data stream. If the object's class implements Ref, Blob, Clob, Struct, or Array, the driver passes it to the database as a value of the corresponding SQL type.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
theObject Object: the object containing the value to which the parameter at parameterIndex is set.
Throws
SQLException if a database error happens.

public abstract void setObject (int parameterIndex, Object theObject, int targetSqlType, int scale)

Added in API level 1

Sets the value of a specified parameter using a supplied object.

The object is converted to the given targetSqlType before it is sent to the database. If the object has a custom mapping (its class implements the interface SQLData), the JDBC driver will call the method SQLData.writeSQL to write it to the SQL data stream. If the object's class implements Ref, Blob, Clob, Struct, or Array, the driver will pass it to the database in the form of the relevant SQL type.

Parameters
parameterIndex int: the parameter index, where the first parameter has index 1.
theObject Object: the Object containing the value to which the parameter at parameterIndex is set.
targetSqlType int: the SQL type to send to the database, as defined in java.sql.Types.
scale int: the number of digits after the decimal point - only applies to the types java.sql.Types.DECIMAL and java.sql.Types.NUMERIC - ignored for all other types.
Throws
SQLException if a database error happens.

public abstract void setObject (int parameterIndex, Object theObject, int targetSqlType)

Added in API level 1

Sets the value of a specified parameter using a supplied object.

The object is converted to the given targetSqlType before it is sent to the database. If the object has a custom mapping (its class implements the interface SQLData), the JDBC driver will call the method SQLData.writeSQL to write it to the SQL data stream. If the object's class implements Ref, Blob, Clob, Struct, or Array, the driver will pass it to the database in the form of the relevant SQL type.

Parameters
parameterIndex int: the parameter index, where the first parameter has index 1.
theObject Object: the Object containing the value to which the parameter at parameterIndex is set.
targetSqlType int: the SQL type to send to the database, as defined in java.sql.Types.
Throws
SQLException if a database error happens.

public abstract void setRef (int parameterIndex, Ref theRef)

Added in API level 1

Sets the value of a specified parameter to a supplied REF() value. This is stored as an SQL REF.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
theRef Ref: a java.sql.Ref value to which the parameter at parameterIndex is set.
Throws
SQLException if a database error happens.

See also:

public abstract void setRowId (int parameterIndex, RowId theRowId)

Added in API level 9

Sets the value of a specified parameter to a supplied java.sql.RowId.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
theRowId RowId: the RowId to which the parameter at parameterIndex is set.
Throws
SQLException if a database error happens.

public abstract void setSQLXML (int parameterIndex, SQLXML xmlObject)

Added in API level 9

Sets the value of the specified parameter to the value of xmlObject.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
xmlObject SQLXML: the SQLXML
Throws
SQLException if a database error happens.

public abstract void setShort (int parameterIndex, short theShort)

Added in API level 1

Sets the value of a specified parameter to a supplied short value.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
theShort short: a short value to which the parameter at parameterIndex is set.
Throws
SQLException if a database error happens.

public abstract void setString (int parameterIndex, String theString)

Added in API level 1

Sets the value of a specified parameter to a supplied string.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
theString String: the value to which the parameter at parameterIndex is set.
Throws
SQLException if a database error happens.

public abstract void setTime (int parameterIndex, Time theTime)

Added in API level 1

Sets the value of a specified parameter to a supplied java.sql.Time value.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
theTime Time: a java.sql.Time value to which the parameter at parameterIndex is set.
Throws
SQLException if a database error happens.

public abstract void setTime (int parameterIndex, Time theTime, Calendar cal)

Added in API level 1

Sets the value of a specified parameter to a supplied java.sql.Time value, using a supplied Calendar.

The driver uses the supplied Calendar to create the SQL TIME value, which allows it to use a custom timezone - otherwise the driver uses the VM defaults. See "Be wary of the default locale".

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
theTime Time: a java.sql.Time value to which the parameter at parameterIndex is set.
cal Calendar: a Calendar to use to construct the SQL TIME value.
Throws
SQLException if a database error happens.

See also:

public abstract void setTimestamp (int parameterIndex, Timestamp theTimestamp, Calendar cal)

Added in API level 1

Sets the value of a specified parameter to a supplied java.sql.Timestamp value, using the supplied Calendar.

The driver uses the supplied Calendar to create the SQL TIMESTAMP value, which allows it to use a custom timezone - otherwise the driver uses the VM defaults. See "Be wary of the default locale".

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
theTimestamp Timestamp: the java.sql.Timestamp value to which the parameter at parameterIndex is set.
cal Calendar: a Calendar to use to construct the SQL TIMESTAMP value
Throws
SQLException if a database error happens.

See also:

public abstract void setTimestamp (int parameterIndex, Timestamp theTimestamp)

Added in API level 1

Sets the value of a specified parameter to a supplied java.sql.Timestamp value.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
theTimestamp Timestamp: the java.sql.Timestamp value to which the parameter at parameterIndex is set.
Throws
SQLException if a database error happens.

public abstract void setURL (int parameterIndex, URL theURL)

Added in API level 1

Sets the value of a specified parameter to a supplied java.net.URL.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
theURL URL: the URL to which the parameter at parameterIndex is set.
Throws
SQLException if a database error happens.

See also:

public abstract void setUnicodeStream (int parameterIndex, InputStream theInputStream, int length)

Added in API level 1

This method was deprecated in API level 1.
Use setCharacterStream(int, Reader, int)

Sets the value of a specified parameter to the characters from a supplied InputStream, with a specified number of bytes.

Parameters
parameterIndex int: the parameter number index, where the first parameter has index 1.
theInputStream InputStream: the InputStream with the character data to which the parameter at parameterIndex is set.
length int: the number of bytes to read from the InputStream.
Throws
SQLException if a database error happens.