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.
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( |
||||||
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. |
SQLException | if a database error happens |
---|
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.
SQLException | if a database error happens |
---|
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.
SQLException | if a database error happens |
---|
SQLException | if a database error happens or if the SQL statement does not produce a ResultSet. |
---|
SQLException | if a database error happens or if the SQL statement returns a ResultSet. |
---|
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.
SQLException | if there is a database error |
---|
SQLException | if a database error happens |
---|
parameterIndex | the parameter number index, where the first parameter has index 1 |
---|---|
theArray | a java.sql.Array holing the data to set. |
SQLException | if a database error happens |
---|
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.
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 |
SQLException | if a database error happens |
---|
parameterIndex | the parameter number index, where the first parameter has index 1 |
---|---|
theBigDecimal | the java.math.BigInteger value to set |
SQLException | if a database error happens |
---|
Use this method when a large amount of data needs to be set into a LONGVARBINARY parameter.
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 |
SQLException | if a database error happens |
---|
parameterIndex | the parameter number index, where the first parameter has index 1 |
---|---|
theBlob | a java.sql.Blob holding the data to update the parameter |
SQLException | if a database error happens |
---|
parameterIndex | the parameter number index, where the first parameter has index 1 |
---|---|
theBoolean | the boolean value to update the parameter |
SQLException | if a database error happens |
---|
parameterIndex | the parameter number index, where the first parameter has index 1 |
---|---|
theByte | the byte value to update the parameter |
SQLException | if a database error happens |
---|
parameterIndex | the parameter number index, where the first parameter has index 1 |
---|---|
theBytes | the array of bytes to update the parameter |
SQLException | if a database error happens |
---|
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 |
SQLException | if a database error happens |
---|
parameterIndex | the parameter number index, where the first parameter has index 1 |
---|---|
theClob | a java.sql.Clob holding the data to update the parameter |
SQLException | if a database error happens |
---|
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 |
SQLException | if a database error happens |
---|
parameterIndex | the parameter number index, where the first parameter has index 1 |
---|---|
theDate | a java.sql.Date to update the parameter |
SQLException | if a database error happens |
---|
parameterIndex | the parameter number index, where the first parameter has index 1 |
---|---|
theDouble | the double value to update the parameter |
SQLException | if a database error happens |
---|
parameterIndex | the parameter number index, where the first parameter has index 1 |
---|---|
theFloat | the float value to update the parameter |
SQLException | if a database error happens |
---|
parameterIndex | the parameter number index, where the first parameter has index 1 |
---|---|
theInt | the int value to update the parameter |
SQLException | if a database error happens |
---|
parameterIndex | the parameter number index, where the first parameter has index 1 |
---|---|
theLong | the long value to update the parameter |
SQLException | if a database error happens |
---|
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 |
SQLException | if a database error happens |
---|
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.
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. |
SQLException | if a database error happens |
---|
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.
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 |
SQLException | if a database error happens |
---|
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.
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. |
SQLException | if a database error happens |
---|
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.
parameterIndex | the parameter number index, where the first parameter has index 1 |
---|---|
theObject | the Object containing the value to update the parameter |
SQLException | if a database error happens |
---|
parameterIndex | the parameter number index, where the first parameter has index 1 |
---|---|
theRef | a java.sql.Ref value to update the parameter |
SQLException | if a database error happens |
---|
parameterIndex | the parameter number index, where the first parameter has index 1 |
---|---|
theShort | a short value to update the parameter |
SQLException | if a database error happens |
---|
parameterIndex | the parameter number index, where the first parameter has index 1 |
---|---|
theString | a String value to update the parameter |
SQLException | if a database error happens |
---|
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.
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 |
SQLException | if a database error happens |
---|
parameterIndex | the parameter number index, where the first parameter has index 1 |
---|---|
theTime | a java.sql.Time value to update the parameter |
SQLException | if a database error happens |
---|
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.
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 |
SQLException | if a database error happens |
---|
parameterIndex | the parameter number index, where the first parameter has index 1 |
---|---|
theTimestamp | the java.sql.Timestamp value to update the parameter |
SQLException | if a database error happens |
---|
parameterIndex | the parameter number index, where the first parameter has index 1 |
---|---|
theURL | the URL to update the parameter |
SQLException | if a database error happens |
---|
This method is deprecated. Sets the value of a specified parameter to the characters from a supplied InputStream, with a specified number of bytes.
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 |
SQLException | if a database error happens |
---|
Copyright 2007 Google Inc. | Build 0.9_r1-98467 - 14 Aug 2008 18:56 |