An object that represents a precompiled SQL statement.
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 |
|