Interface PreparedStatement

public void addBatch()
            throws SQLException

This method adds a set of parameters to the batch for JDBC 2.0.

Throws:

SQLException - If an error occurs.

public void clearParameters()
            throws SQLException

This method clears all of the input parameter that have been set on this statement.

Throws:

SQLException - If an error occurs.

public boolean execute()
            throws SQLException

This method executes a prepared SQL query. Some prepared statements return multiple results; the execute method handles these complex statements as well as the simpler form of statements handled by executeQuery and executeUpdate.

Returns:

The result of the SQL statement.

Throws:

SQLException - If an error occurs.

public ResultSet executeQuery()
            throws SQLException

This method executes a prepared SQL query and returns its ResultSet.

Returns:

The ResultSet of the SQL statement.

Throws:

SQLException - If an error occurs.

public int executeUpdate()
            throws SQLException

This method executes an SQL INSERT, UPDATE or DELETE statement. SQL statements that return nothing such as SQL DDL statements can be executed.

Returns:

The result is either the row count for INSERT, UPDATE or DELETE statements; or 0 for SQL statements that return nothing.

Throws:

SQLException - If an error occurs.

public ResultSetMetaData getMetaData()
            throws SQLException

This method returns meta data for the result set from this statement.

Returns:

Meta data for the result set from this statement.

Throws:

SQLException - If an error occurs.

public ParameterMetaData getParameterMetaData()
            throws SQLException

Since:

1.4

public void setArray(int i,
                     Array x)
            throws SQLException

This method sets the specified parameter from the given Java Array value. The default object type to SQL type mapping will be used.

Parameters:

Throws:

SQLException - If an error occurs.

public void setAsciiStream(int parameterIndex,
                           InputStream x,
                           int length)
            throws SQLException

This method sets the specified parameter from the given Java ASCII InputStream value.

Parameters:

length - The number of bytes in the stream.

Throws:

SQLException - If an error occurs.

public void setBigDecimal(int parameterIndex,
                          BigDecimal x)
            throws SQLException

This method sets the specified parameter from the given Java java.math.BigDecimal value.

Parameters:

Throws:

SQLException - If an error occurs.

public void setBinaryStream(int parameterIndex,
                            InputStream x,
                            int length)
            throws SQLException

This method sets the specified parameter from the given Java binary InputStream value.

Parameters:

length - The number of bytes in the stream.

Throws:

SQLException - If an error occurs.

public void setBlob(int i,
                    Blob x)
            throws SQLException

This method sets the specified parameter from the given Java Blob value. The default object type to SQL type mapping will be used.

Parameters:

Throws:

SQLException - If an error occurs.

public void setBoolean(int parameterIndex,
                       boolean x)
            throws SQLException

This method sets the specified parameter from the given Java boolean value.

Parameters:

Throws:

SQLException - If an error occurs.

public void setByte(int parameterIndex,
                    byte x)
            throws SQLException

This method sets the specified parameter from the given Java byte value.

Parameters:

Throws:

SQLException - If an error occurs.

public void setBytes(int parameterIndex,
                     byte[] x)
            throws SQLException

This method sets the specified parameter from the given Java byte array value.

Parameters:

Throws:

SQLException - If an error occurs.

public void setCharacterStream(int parameterIndex,
                               Reader reader,
                               int length)
            throws SQLException

This method sets the specified parameter from the given Java character Reader value.

Parameters:

length - The number of bytes in the stream.

Throws:

SQLException - If an error occurs.

public void setClob(int i,
                    Clob x)
            throws SQLException

This method sets the specified parameter from the given Java Clob value. The default object type to SQL type mapping will be used.

Parameters:

Throws:

SQLException - If an error occurs.

public void setDate(int parameterIndex,
                    Date x)
            throws SQLException

This method sets the specified parameter from the given Java java.sql.Date value.

Parameters:

Throws:

SQLException - If an error occurs.

public void setDate(int parameterIndex,
                    Date x,
                    Calendar cal)
            throws SQLException

This method sets the specified parameter from the given Java java.sql.Date value.

Parameters:

Throws:

SQLException - If an error occurs.

public void setDouble(int parameterIndex,
                      double x)
            throws SQLException

This method sets the specified parameter from the given Java double value.

Parameters:

Throws:

SQLException - If an error occurs.

public void setFloat(int parameterIndex,
                     float x)
            throws SQLException

This method sets the specified parameter from the given Java float value.

Parameters:

Throws:

SQLException - If an error occurs.

public void setInt(int parameterIndex,
                   int x)
            throws SQLException

This method sets the specified parameter from the given Java int value.

Parameters:

Throws:

SQLException - If an error occurs.

public void setLong(int parameterIndex,
                    long x)
            throws SQLException

This method sets the specified parameter from the given Java long value.

Parameters:

Throws:

SQLException - If an error occurs.

public void setNull(int parameterIndex,
                    int sqlType)
            throws SQLException

This method populates the specified parameter with a SQL NULL value for the specified type.

Parameters:

Throws:

SQLException - If an error occurs.

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

This method populates the specified parameter with a SQL NULL value for the specified type.

Parameters:

Throws:

SQLException - If an error occurs.

public void setObject(int parameterIndex,
                      Object x)
            throws SQLException

This method sets the specified parameter from the given Java Object value. The default object type to SQL type mapping will be used.

Parameters:

Throws:

SQLException - If an error occurs.

public void setObject(int parameterIndex,
                      Object x,
                      int targetSqlType)
            throws SQLException

This method sets the specified parameter from the given Java Object value. The specified SQL object type will be used.

Parameters:

Throws:

SQLException - If an error occurs.

See Also:

Types

public void setObject(int parameterIndex,
                      Object x,
                      int targetSqlType,
                      int scale)
            throws SQLException

This method sets the specified parameter from the given Java Object value. The specified SQL object type will be used.

Parameters:

scale - The scale of the value, for numeric values only.

Throws:

SQLException - If an error occurs.

See Also:

Types

public void setRef(int i,
                   Ref x)
            throws SQLException

This method sets the specified parameter from the given Java Ref value. The default object type to SQL type mapping will be used.

Parameters:

Throws:

SQLException - If an error occurs.

public void setShort(int parameterIndex,
                     short x)
            throws SQLException

This method sets the specified parameter from the given Java short value.

Parameters:

Throws:

SQLException - If an error occurs.

public void setString(int parameterIndex,
                      String x)
            throws SQLException

This method sets the specified parameter from the given Java String value.

Parameters:

Throws:

SQLException - If an error occurs.

public void setTime(int parameterIndex,
                    Time x)
            throws SQLException

This method sets the specified parameter from the given Java java.sql.Time value.

Parameters:

Throws:

SQLException - If an error occurs.

public void setTime(int parameterIndex,
                    Time x,
                    Calendar cal)
            throws SQLException

This method sets the specified parameter from the given Java java.sql.Time value.

Parameters:

Throws:

SQLException - If an error occurs.

public void setTimestamp(int parameterIndex,
                         Timestamp x)
            throws SQLException

This method sets the specified parameter from the given Java java.sql.Timestamp value.

Parameters:

Throws:

SQLException - If an error occurs.

public void setTimestamp(int parameterIndex,
                         Timestamp x,
                         Calendar cal)
            throws SQLException

This method sets the specified parameter from the given Java java.sql.Timestamp value.

Parameters:

Throws:

SQLException - If an error occurs.

public void setURL(int parameterIndex,
                   URL x)
            throws SQLException

Since:

1.4

public void setUnicodeStream(int parameterIndex,
                             InputStream x,
                             int length)
            throws SQLException

Deprecated.

This method sets the specified parameter from the given Java Unicode UTF-8 InputStream value.

Parameters:

length - The number of bytes in the stream.

Throws:

SQLException - If an error occurs.