Show TOC

java.sql.PreparedStatementLocate this document in the navigation structure

Definition

An object that represents a precompiled SQL statement.

Integration

Method Name

Support in Open SQL

Comments

void addBatch( String )

void addBatch()

void cancel()

void clearBatch()

void clearParameters()

void clearWarnings()

void close()

boolean execute (String)

boolean execute()

int[] executeBatch()

ResultSet executeQuery (String)

ResultSet executeQuery()

int executeUpdate (String)

int executeUpdate()

Connection getConnection()

int getFetchDirection()

int getFe tchSize()

Returns FETCH_FORWARD.

int getMaxFieldSize()

int getMaxRows()

Returns 0.

ResultSetMetaData getMetaData()

After prepare call.

boolean getMoreResults()

int getQueryTimeout()

ResultSet getResultSet()

int getResultSetConcurrency()

Returns CONCUR_READ_ONLY.

int getResultSetType()

Returns TYPE_FORWARD_ONLY.

int getUpdateCount()

SQLWarning getWarnings()

void setArray (int, Array)

void setAsciiStream (int, InputStream, int)

void setBigDecimal (int, BigDecimal)

void setBinaryStream (int, InputStream, int)

A stream object can only be used once as an IN parameter, because the SQL operation will consume the stream.

void setBlob (int, Blob)

void setBoolean (int, boolean)

void setByte (int, byte)

void setBytes (int, byte[])

void setCharacterStream (int, Reader, int)

A stream object can only be used once as an IN parameter, because the SQL operation will consume the stream.

void setClob (int, Clob)

void setCursorName (String)

void setDate (int, Date)

void setDate (int, Date, Calendar)

void setDouble (int, double)

void setEscapeProcessing (boolean)

void setFetchDirection (int)

void setFetchSize (int)

void setFloat (int, float)

void setInt (int, int)

void setLong (int, long)

void setMaxFieldSize (int)

void setMaxRows (int)

void setNull (int, int)

void setNull (int, int, String)

void setObject (int, Object)

void setObject (int, Object, int)

void setObject (int, Object, int, int)

void setQueryTimeout (int)

void setRef (int, Ref)

void setShort (int, short)

void setString (int, String)

void setTime (int, Time)

void setTime (int, Time, Calendar)

void setTimestamp (int, Timestamp)

void setTimestamp (int, Timestamp, Calendar)

void setUnicodeStream (int, InputStream, int)