Android
java.sql
public interface

java.sql.PreparedStatement

java.sql.PreparedStatement Statement

An interface for a Precompiled SQL Statement.

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

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 type of the IN parameter being set.

Known Indirect Subclasses

Summary

Constants inherited from interface java.sql.Statement

Public Methods

          void  addBatch()
Add a set of parameters to the PreparedStatement's command batch.
          void  clearParameters()
Clear the current parameter values.
          boolean  execute()
Executes the SQL statement in this PreparedStatement.
          ResultSet  executeQuery()
Execute the SQL query in the PreparedStatement and return the ResultSet generated by the query.
          int  executeUpdate()
Invoke the SQL command contained within the Prepared Statement.
          ResultSetMetaData  getMetaData()
Returns a ResultSetMetaData containing data from the ResultSet that is produced when the PreparedStatement is invoked.
          ParameterMetaData  getParameterMetaData()
Gets information about the parameters of the PreparedStatement.
          void  setArray(int parameterIndex, Array theArray)
Sets the value of a specified parameter to the supplied Array object.
          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.
          void  setBigDecimal(int parameterIndex, BigDecimal theBigDecimal)
Sets the value of a specified parameter to a supplied java.math.BigDecimal value.
          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.
          void  setBlob(int parameterIndex, Blob theBlob)
Sets the value of a specified parameter to the given Blob object.
          void  setBoolean(int parameterIndex, boolean theBoolean)
Sets the value of a specified parameter to a supplied boolean value.
          void  setByte(int parameterIndex, byte theByte)
Sets the value of a specified parameter to a supplied byte value.
          void  setBytes(int parameterIndex, byte[] theBytes)
Sets the value of a specified parameter to a supplied array of bytes.
          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.
          void  setClob(int parameterIndex, Clob theClob)
Sets the value of a specified parameter to the given Clob object.
          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.
          void  setDate(int parameterIndex, Date theDate)
Sets the value of a specified parameter to a supplied java.sql.Date value.
          void  setDouble(int parameterIndex, double theDouble)
Sets the value of a specified parameter to a supplied double value.
          void  setFloat(int parameterIndex, float theFloat)
Sets the value of a specified parameter to to a supplied float value.
          void  setInt(int parameterIndex, int theInt)
Sets the value of a specified parameter to a supplied int value.
          void  setLong(int parameterIndex, long theLong)
Sets the value of a specified parameter to a supplied long value.
          void  setNull(int parameterIndex, int sqlType)
Sets the value of a specified parameter to SQL NULL.
          void  setNull(int paramIndex, int sqlType, String typeName)
Sets the value of a specified parameter to SQL NULL.
          void  setObject(int parameterIndex, Object theObject, int targetSqlType)
Sets the value of a specified parameter using a supplied object.
          void  setObject(int parameterIndex, Object theObject, int targetSqlType, int scale)
Sets the value of a specified parameter using a supplied object.
          void  setObject(int parameterIndex, Object theObject)
Sets the value of a specified parameter using a supplied object.
          void  setRef(int parameterIndex, Ref theRef)
Sets the value of a specified parameter to a supplied REF() value.
          void  setShort(int parameterIndex, short theShort)
Sets the value of a specified parameter to a supplied short value.
          void  setString(int parameterIndex, String theString)
Sets the value of a specified parameter to a supplied String.
          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.
          void  setTime(int parameterIndex, Time theTime)
Sets the value of a specified parameter to a supplied java.sql.Time value.
          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.
          void  setTimestamp(int parameterIndex, Timestamp theTimestamp)
Sets the value of a specified parameter to a supplied java.sql.Timestamp value.
          void  setURL(int parameterIndex, URL theURL)
Sets the value of a specified parameter to a supplied java.net.URL.
          void  setUnicodeStream(int parameterIndex, InputStream theInputStream, int length)
This method is deprecated. Sets the value of a specified parameter to the characters from a supplied InputStream, with a specified number of bytes.
Methods inherited from interface java.sql.Statement

Details

Public Methods

public void addBatch()

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

Throws

SQLException if a database error happens

public void clearParameters()

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

Executes the SQL statement in this PreparedStatement.

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

Returns

  • 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 ResultSet executeQuery()

Execute the SQL query in the PreparedStatement and return the ResultSet generated by the query.

Returns

  • 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 int executeUpdate()

Invoke the SQL command contained within the Prepared Statement. This must be INSERT, UPDATE, DELETE, or a command that returns nothing.

Returns

  • the count of 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 ResultSetMetaData getMetaData()

Returns a ResultSetMetaData containing data from the ResultSet that is produced when the PreparedStatement is invoked.

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

  • 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 ParameterMetaData getParameterMetaData()

Gets information about the parameters of the PreparedStatement.

Returns

  • 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 void setArray(int parameterIndex, Array theArray)

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

Parameters

parameterIndex the parameter number index, where the first parameter has index 1
theArray a java.sql.Array holing the data to set.

Throws

SQLException if a database error happens

public 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.

This is a good method for setting an SQL LONVARCHAR 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 the parameter number index, where the first parameter has index 1
theInputStream the ASCII InputStream carrying the data to update the parameter
length the number of bytes in the InputStream to copy to the parameter

Throws

SQLException if a database error happens

public void setBigDecimal(int parameterIndex, BigDecimal theBigDecimal)

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

Parameters

parameterIndex the parameter number index, where the first parameter has index 1
theBigDecimal the java.math.BigInteger value to set

Throws

SQLException if a database error happens

public 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.

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

Parameters

parameterIndex the parameter number index, where the first parameter has index 1
theInputStream the binary InputStream carrying the data to update the parameter
length the number of bytes in the InputStream to copy to the parameter

Throws

SQLException if a database error happens

public void setBlob(int parameterIndex, Blob theBlob)

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

Parameters

parameterIndex the parameter number index, where the first parameter has index 1
theBlob a java.sql.Blob holding the data to update the parameter

Throws

SQLException if a database error happens

public void setBoolean(int parameterIndex, boolean theBoolean)

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

Parameters

parameterIndex the parameter number index, where the first parameter has index 1
theBoolean the boolean value to update the parameter

Throws

SQLException if a database error happens

public void setByte(int parameterIndex, byte theByte)

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

Parameters

parameterIndex the parameter number index, where the first parameter has index 1
theByte the byte value to update the parameter

Throws

SQLException if a database error happens

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

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 the parameter number index, where the first parameter has index 1
theBytes the array of bytes to update the parameter

Throws

SQLException if a database error happens

public 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.

Parameters

parameterIndex the parameter number index, where the first parameter has index 1
reader the java.io.Reader encompassing the character data
length the amount of characters to be read

Throws

SQLException if a database error happens

public void setClob(int parameterIndex, Clob theClob)

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

Parameters

parameterIndex the parameter number index, where the first parameter has index 1
theClob a java.sql.Clob holding the data to update the parameter

Throws

SQLException if a database error happens

public 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. 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 default timezone of the Java virtual machine.

Parameters

parameterIndex the parameter number index, where the first parameter has index 1
theDate a java.sql.Date to update the parameter
cal a Calendar to use to construct the SQL DATE value

Throws

SQLException if a database error happens

public void setDate(int parameterIndex, Date theDate)

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

Parameters

parameterIndex the parameter number index, where the first parameter has index 1
theDate a java.sql.Date to update the parameter

Throws

SQLException if a database error happens

public void setDouble(int parameterIndex, double theDouble)

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

Parameters

parameterIndex the parameter number index, where the first parameter has index 1
theDouble the double value to update the parameter

Throws

SQLException if a database error happens

public void setFloat(int parameterIndex, float theFloat)

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

Parameters

parameterIndex the parameter number index, where the first parameter has index 1
theFloat the float value to update the parameter

Throws

SQLException if a database error happens

public void setInt(int parameterIndex, int theInt)

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

Parameters

parameterIndex the parameter number index, where the first parameter has index 1
theInt the int value to update the parameter

Throws

SQLException if a database error happens

public void setLong(int parameterIndex, long theLong)

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

Parameters

parameterIndex the parameter number index, where the first parameter has index 1
theLong the long value to update the parameter

Throws

SQLException if a database error happens

public void setNull(int parameterIndex, int sqlType)

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

Parameters

parameterIndex the parameter number index, where the first parameter has index 1
sqlType the SQL Type of the parameter, as defined in java.sql.Types

Throws

SQLException if a database error happens

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

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 the parameter number index, where the first parameter has index 1
sqlType the SQL Type of the parameter, as defined in java.sql.Types
typeName 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

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

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 the parameter index, where the first parameter has index 1
theObject the Object containing the value to update the parameter
targetSqlType the SQL Type to send to the database, as defined in java.sql.Types

Throws

SQLException if a database error happens

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

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 the parameter index, where the first parameter has index 1
theObject the Object containing the value to update the parameter
targetSqlType the SQL Type to send to the database, as defined in java.sql.Types
scale 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 void setObject(int parameterIndex, Object theObject)

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 the parameter number index, where the first parameter has index 1
theObject the Object containing the value to update the parameter

Throws

SQLException if a database error happens

public void setRef(int parameterIndex, Ref theRef)

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

Parameters

parameterIndex the parameter number index, where the first parameter has index 1
theRef a java.sql.Ref value to update the parameter

Throws

SQLException if a database error happens

public void setShort(int parameterIndex, short theShort)

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

Parameters

parameterIndex the parameter number index, where the first parameter has index 1
theShort a short value to update the parameter

Throws

SQLException if a database error happens

public void setString(int parameterIndex, String theString)

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

Parameters

parameterIndex the parameter number index, where the first parameter has index 1
theString a String value to update the parameter

Throws

SQLException if a database error happens

public 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.

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 default timezone of the Java virtual machine.

Parameters

parameterIndex the parameter number index, where the first parameter has index 1
theTime a java.sql.Time value to update the parameter
cal a Calendar to use to construct the SQL TIME value

Throws

SQLException if a database error happens

public void setTime(int parameterIndex, Time theTime)

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

Parameters

parameterIndex the parameter number index, where the first parameter has index 1
theTime a java.sql.Time value to update the parameter

Throws

SQLException if a database error happens

public 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.

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 default timezone of the Java virtual machine.

Parameters

parameterIndex the parameter number index, where the first parameter has index 1
theTimestamp the java.sql.Timestamp value to update the parameter
cal a Calendar to use to construct the SQL TIMESTAMP value

Throws

SQLException if a database error happens

public void setTimestamp(int parameterIndex, Timestamp theTimestamp)

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

Parameters

parameterIndex the parameter number index, where the first parameter has index 1
theTimestamp the java.sql.Timestamp value to update the parameter

Throws

SQLException if a database error happens

public void setURL(int parameterIndex, URL theURL)

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

Parameters

parameterIndex the parameter number index, where the first parameter has index 1
theURL the URL to update the parameter

Throws

SQLException if a database error happens

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

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

Parameters

parameterIndex the parameter number index, where the first parameter has index 1
theInputStream the InputStream with the character data to update the parameter
length the number of bytes to read from the InputStream

Throws

SQLException if a database error happens
Copyright 2007 Google Inc. Build 0.9_r1-98467 - 14 Aug 2008 18:48