Show TOC Start of Content Area

Object documentation java.sql.PreparedStatement  Locate the document in its SAP Library structure

Definition

An object that represents a precompiled SQL statement.

 

Integration

Methods of Interface java.sql.PreparedStatement

Method Name

Support in Open SQL

Comments

void addBatch( String )

r

 

void addBatch()

a

 

void cancel()

r

 

void clearBatch()

a

 

void clearParameters()

a

 

void clearWarnings()

a

 

void close()

a

 

boolean execute (String)

r

 

boolean execute()

a

 

int[] executeBatch()

a

 

ResultSet executeQuery (String)

r

 

ResultSet executeQuery()

a

 

int executeUpdate (String)

r

 

int executeUpdate()

a

 

Connection getConnection()

r

 

int getFetchDirection()

a

 

int getFe tchSize()

a

Returns FETCH_FORWARD.

int getMaxFieldSize()

a

 

int getMaxRows()

a

Returns 0.

ResultSetMetaData getMetaData()

a

After prepare call.

boolean getMoreResults()

r

 

int getQueryTimeout()

a

 

ResultSet getResultSet()

a

 

int getResultSetConcurrency()

a

Returns CONCUR_READ_ONLY.

int getResultSetType()

a

Returns TYPE_FORWARD_ONLY.

int getUpdateCount()

a

 

SQLWarning getWarnings()

a

 

void setArray (int, Array)

r

 

void setAsciiStream (int, InputStream, int)

r

 

void setBigDecimal (int, BigDecimal)

a

 

void setBinaryStream (int, InputStream, int)

a

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

void setBlob (int, Blob)

a

 

void setBoolean (int, boolean)

a

 

void setByte (int, byte)

a

 

void setBytes (int, byte[])

a

 

void setCharacterStream (int, Reader, int)

a

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

void setClob (int, Clob)

a

 

void setCursorName (String)

r

 

void setDate (int, Date)

a

 

void setDate (int, Date, Calendar)

r

 

void setDouble (int, double)

a

 

void setEscapeProcessing (boolean)

r

 

void setFetchDirection (int)

r

 

void setFetchSize (int)

r

 

void setFloat (int, float)

a

 

void setInt (int, int)

a

 

void setLong (int, long)

a

 

void setMaxFieldSize (int)

r

 

void setMaxRows (int)

a

 

void setNull (int, int)

a

 

void setNull (int, int, String)

r

 

void setObject (int, Object)

a

 

void setObject (int, Object, int)

r

 

void setObject (int, Object, int, int)

r

 

void setQueryTimeout (int)

r

 

void setRef (int, Ref)

r

 

void setShort (int, short)

a

 

void setString (int, String)

a

 

void setTime (int, Time)

a

 

void setTime (int, Time, Calendar)

r

 

void setTimestamp (int, Timestamp)

a

 

void setTimestamp (int, Timestamp, Calendar)

a

 

void setUnicodeStream (int, InputStream, int)

r

 

 

 

 

 

End of Content Area