Public Member Functions | |
void | addBatch () throws SQLException |
void | clearParameters () throws SQLException |
boolean | execute () throws SQLException |
boolean | execute (String sql, int autoGeneratedKeys) throws SQLException |
boolean | execute (String sql, int[] columnIndexes) throws SQLException |
boolean | execute (String sql, String[] columnNames) throws SQLException |
ResultSet | executeQuery () throws SQLException |
int | executeUpdate () throws SQLException |
int | executeUpdate (String sql, int autoGeneratedKeys) throws SQLException |
int | executeUpdate (String sql, int[] columnIndexes) throws SQLException |
int | executeUpdate (String sql, String[] columnNames) throws SQLException |
ResultSet | getGeneratedKeys () throws SQLException |
ResultSetMetaData | getMetaData () throws SQLException |
boolean | getMoreResults (int current) throws SQLException |
ParameterMetaData | getParameterMetaData () throws SQLException |
int | getResultSetHoldability () throws SQLException |
void | setArray (int i, Array x) throws SQLException |
void | setAsciiStream (int parameterIndex, InputStream x, int length) throws SQLException |
void | setBigDecimal (int parameterIndex, BigDecimal x) throws SQLException |
void | setBinaryStream (int parameterIndex, InputStream x, int length) throws SQLException |
void | setBlob (int i, Blob x) throws SQLException |
void | setBoolean (int parameterIndex, boolean x) throws SQLException |
void | setByte (int parameterIndex, byte x) throws SQLException |
void | setBytes (int parameterIndex, byte[] x) throws SQLException |
void | setCharacterStream (int parameterIndex, Reader reader, int length) throws SQLException |
void | setClob (int i, Clob x) throws SQLException |
void | setDate (int parameterIndex, Date x) throws SQLException |
void | setDate (int parameterIndex, Date x, Calendar cal) throws SQLException |
void | setDouble (int parameterIndex, double x) throws SQLException |
void | setFloat (int parameterIndex, float x) throws SQLException |
void | setInt (int parameterIndex, int x) throws SQLException |
void | setLong (int parameterIndex, long x) throws SQLException |
void | setNull (int parameterIndex, int sqlType) throws SQLException |
void | setNull (int paramIndex, int sqlType, String typeName) throws SQLException |
void | setObject (int parameterIndex, Object x) throws SQLException |
void | setObject (int parameterIndex, Object x, int targetSqlType) throws SQLException |
void | setObject (int parameterIndex, Object x, int targetSqlType, int scale) throws SQLException |
void | setRef (int i, Ref x) throws SQLException |
void | setShort (int parameterIndex, short x) throws SQLException |
void | setString (int parameterIndex, String x) throws SQLException |
void | setTime (int parameterIndex, Time x) throws SQLException |
void | setTime (int parameterIndex, Time x, Calendar cal) throws SQLException |
void | setTimestamp (int parameterIndex, Timestamp x) throws SQLException |
void | setTimestamp (int parameterIndex, Timestamp x, Calendar cal) throws SQLException |
void | setUnicodeStream (int parameterIndex, InputStream x, int length) throws SQLException |
void | addBatch (String s) throws SQLException |
void | cancel () throws SQLException |
void | clearBatch () throws SQLException |
void | clearWarnings () throws SQLException |
void | close () throws SQLException |
boolean | execute (String s) throws SQLException |
int[] | executeBatch () throws SQLException |
ResultSet | executeQuery (String s) throws SQLException |
int | executeUpdate (String s) throws SQLException |
Connection | getConnection () throws SQLException |
int | getFetchDirection () throws SQLException |
int | getFetchSize () throws SQLException |
int | getMaxFieldSize () throws SQLException |
int | getMaxRows () throws SQLException |
boolean | getMoreResults () throws SQLException |
int | getQueryTimeout () throws SQLException |
ResultSet | getResultSet () throws SQLException |
int | getResultSetConcurrency () throws SQLException |
int | getResultSetType () throws SQLException |
int | getUpdateCount () throws SQLException |
SQLWarning | getWarnings () throws SQLException |
void | setCursorName (String name) throws SQLException |
void | setEscapeProcessing (boolean enable) throws SQLException |
void | setFetchDirection (int direction) throws SQLException |
void | setFetchSize (int rows) throws SQLException |
void | setMaxFieldSize (int max) throws SQLException |
void | setMaxRows (int max) throws SQLException |
void | setQueryTimeout (int seconds) throws SQLException |
void | setURL (int parameterIndex, URL x) throws SQLException |
Author: Eric HARDESTY
Definition at line 58 of file PreparedStatementWrapper.java.
|
Adds the given SQL command to the current list of commmands for this NOTE: This method is optional.
Definition at line 1450 of file PreparedStatementWrapper.java. |
|
Adds a set of parameters to this
Definition at line 301 of file PreparedStatementWrapper.java. |
|
Cancels this
Definition at line 1467 of file PreparedStatementWrapper.java. |
|
Empties this NOTE: This method is optional.
Definition at line 1487 of file PreparedStatementWrapper.java. |
|
Clears the current parameter values immediately.
In general, parameter values remain in force for repeated use of a statement. Setting a parameter value automatically clears its previous value. However, in some cases it is useful to immediately release the resources used by the current parameter values; this can be done by calling the method
Definition at line 320 of file PreparedStatementWrapper.java. |
|
Clears all the warnings reported on this
Definition at line 1505 of file PreparedStatementWrapper.java. |
|
Releases this
Calling the method
Note: A
Definition at line 1532 of file PreparedStatementWrapper.java. |
|
Executes the given SQL statement, which may return multiple results. In some (uncommon) situations, a single SQL statement may return multiple result sets and/or update counts. Normally you can ignore this unless you are (1) executing a stored procedure that you know may return multiple results or (2) you are dynamically executing an unknown SQL string.
The
Definition at line 1567 of file PreparedStatementWrapper.java. |
|
Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. This array contains the names of the columns in the target table that contain the auto-generated keys that should be made available. The driver will ignore the array if the given SQL statement is not an In some (uncommon) situations, a single SQL statement may return multiple result sets and/or update counts. Normally you can ignore this unless you are (1) executing a stored procedure that you know may return multiple results or (2) you are dynamically executing an unknown SQL string.
The
Definition at line 498 of file PreparedStatementWrapper.java. |
|
Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. This array contains the indexes of the columns in the target table that contain the auto-generated keys that should be made available. The driver will ignore the array if the given SQL statement is not an Under some (uncommon) situations, a single SQL statement may return multiple result sets and/or update counts. Normally you can ignore this unless you are (1) executing a stored procedure that you know may return multiple results or (2) you are dynamically executing an unknown SQL string.
The
Definition at line 450 of file PreparedStatementWrapper.java. |
|
Executes the given SQL statement, which may return multiple results, and signals the driver that any auto-generated keys should be made available for retrieval. The driver will ignore this signal if the SQL statement is not an In some (uncommon) situations, a single SQL statement may return multiple result sets and/or update counts. Normally you can ignore this unless you are (1) executing a stored procedure that you know may return multiple results or (2) you are dynamically executing an unknown SQL string.
The
Definition at line 403 of file PreparedStatementWrapper.java. |
|
Executes the SQL statement in this
The
Definition at line 354 of file PreparedStatementWrapper.java. |
|
Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts. The
A driver is not required to implement this method. The possible implementations and return values have been modified in the Java 2 SDK, Standard Edition, version 1.3 to accommodate the option of continuing to proccess commands in a batch update after a
Definition at line 1624 of file PreparedStatementWrapper.java. |
|
Executes the given SQL statement, which returns a single
Definition at line 1645 of file PreparedStatementWrapper.java. |
|
Executes the SQL query in this
Definition at line 516 of file PreparedStatementWrapper.java. |
|
Executes the given SQL statement, which may be an
Definition at line 1667 of file PreparedStatementWrapper.java. |
|
Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. The driver will ignore the array if the SQL statement is not an
Definition at line 629 of file PreparedStatementWrapper.java. |
|
Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. The driver will ignore the array if the SQL statement is not an
Definition at line 599 of file PreparedStatementWrapper.java. |
|
Executes the given SQL statement and signals the driver with the given flag about whether the auto-generated keys produced by this
Definition at line 569 of file PreparedStatementWrapper.java. |
|
Executes the SQL statement in this
Definition at line 537 of file PreparedStatementWrapper.java. |
|
Retrieves the
Definition at line 1683 of file PreparedStatementWrapper.java. |
|
Retrieves the direction for fetching rows from database tables that is the default for result sets generated from this
Definition at line 1706 of file PreparedStatementWrapper.java. |
|
Retrieves the number of result set rows that is the default fetch size for
Definition at line 1729 of file PreparedStatementWrapper.java. |
|
Retrieves any auto-generated keys created as a result of executing this
Definition at line 650 of file PreparedStatementWrapper.java. |
|
Retrieves the maximum number of bytes that can be returned for character and binary column values in a
Definition at line 1753 of file PreparedStatementWrapper.java. |
|
Retrieves the maximum number of rows that a
Definition at line 1774 of file PreparedStatementWrapper.java. |
|
Retrieves a
Because a NOTE: Using this method may be expensive for some drivers due to the lack of underlying DBMS support.
Definition at line 682 of file PreparedStatementWrapper.java. |
|
Moves to this There are no more results when the following is true: // stmt is a Statement object ((stmt.getMoreResults() == false) && (stmt.getUpdateCount() == -1))
Definition at line 1801 of file PreparedStatementWrapper.java. |
|
Moves to this There are no more results when the following is true: // stmt is a Statement object ((stmt.getMoreResults() == false) && (stmt.getUpdateCount() == -1))
Definition at line 722 of file PreparedStatementWrapper.java. |
|
Retrieves the number, types and properties of this
Definition at line 743 of file PreparedStatementWrapper.java. |
|
Retrieves the number of seconds the driver will wait for a
Definition at line 1820 of file PreparedStatementWrapper.java. |
|
Retrieves the current result as a
Definition at line 1838 of file PreparedStatementWrapper.java. |
|
Retrieves the result set concurrency for
Definition at line 1856 of file PreparedStatementWrapper.java. |
|
Retrieves the result set holdability for
Definition at line 763 of file PreparedStatementWrapper.java. |
|
Retrieves the result set type for
Definition at line 1875 of file PreparedStatementWrapper.java. |
|
Retrieves the current result as an update count; if the result is a
Definition at line 1894 of file PreparedStatementWrapper.java. |
|
Retrieves the first warning reported by calls on this
The warning chain is automatically cleared each time a statement is (re)executed. This method may not be called on a closed
Note: If you are processing a
Definition at line 1923 of file PreparedStatementWrapper.java. |
|
Sets the designated parameter to the given
Definition at line 782 of file PreparedStatementWrapper.java. |
|
Sets the designated parameter to the given input stream, which will have the specified number of bytes. When a very large ASCII value is input to a Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Definition at line 809 of file PreparedStatementWrapper.java. |
|
Sets the designated parameter to the given
Definition at line 827 of file PreparedStatementWrapper.java. |
|
Sets the designated parameter to the given input stream, which will have the specified number of bytes. When a very large binary value is input to a Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Definition at line 853 of file PreparedStatementWrapper.java. |
|
Sets the designated parameter to the given
Definition at line 872 of file PreparedStatementWrapper.java. |
|
Sets the designated parameter to the given Java
Definition at line 890 of file PreparedStatementWrapper.java. |
|
Sets the designated parameter to the given Java
Definition at line 908 of file PreparedStatementWrapper.java. |
|
Sets the designated parameter to the given Java array of bytes. The driver converts this to an SQL
Definition at line 927 of file PreparedStatementWrapper.java. |
|
Sets the designated parameter to the given Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Definition at line 956 of file PreparedStatementWrapper.java. |
|
Sets the designated parameter to the given
Definition at line 975 of file PreparedStatementWrapper.java. |
|
Sets the SQL cursor name to the given
Note: By definition, the execution of positioned updates and deletes must be done by a different
Definition at line 1953 of file PreparedStatementWrapper.java. |
|
Sets the designated parameter to the given
Definition at line 1019 of file PreparedStatementWrapper.java. |
|
Sets the designated parameter to the given
Definition at line 993 of file PreparedStatementWrapper.java. |
|
Sets the designated parameter to the given Java
Definition at line 1037 of file PreparedStatementWrapper.java. |
|
Sets escape processing on or off. If escape scanning is on (the default), the driver will do escape substitution before sending the SQL statement to the database.
Note: Since prepared statements have usually been parsed prior to making this call, disabling escape processing for
Definition at line 1975 of file PreparedStatementWrapper.java. |
|
Gives the driver a hint as to the direction in which rows will be processed in
Note that this method sets the default fetch direction for result sets generated by this
Definition at line 2003 of file PreparedStatementWrapper.java. |
|
Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed. The number of rows specified affects only result sets created using this statement. If the value specified is zero, then the hint is ignored. The default value is zero.
Definition at line 2026 of file PreparedStatementWrapper.java. |
|
Sets the designated parameter to the given Java
Definition at line 1055 of file PreparedStatementWrapper.java. |
|
Sets the designated parameter to the given Java
Definition at line 1073 of file PreparedStatementWrapper.java. |
|
Sets the designated parameter to the given Java
Definition at line 1091 of file PreparedStatementWrapper.java. |
|
Sets the limit for the maximum number of bytes in a
Definition at line 2050 of file PreparedStatementWrapper.java. |
|
Sets the limit for the maximum number of rows that any
Definition at line 2070 of file PreparedStatementWrapper.java. |
|
Sets the designated parameter to SQL Note: To be portable, applications must give the SQL type code and the fully-qualified SQL type name when specifying a NULL user-defined or REF parameter. In the case of a user-defined type the name is the type name of the parameter itself. For a REF parameter, the name is the type name of the referenced type. If a JDBC driver does not need the type code or type name information, it may ignore it. Although it is intended for user-defined and Ref parameters, this method may be used to set a null parameter of any JDBC type. If the parameter does not have a user-defined or REF type, the given typeName is ignored.
Definition at line 1146 of file PreparedStatementWrapper.java. |
|
Sets the designated parameter to SQL Note: You must specify the parameter's SQL type.
Definition at line 1109 of file PreparedStatementWrapper.java. |
|
Sets the value of the designated parameter with the given object. The second argument must be an object type; for integral values, the The given Java object will be converted to the given targetSqlType before being sent to the database.
If the object has a custom mapping (is of a class implementing the interface Note that this method may be used to pass database-specific abstract data types.
Definition at line 1244 of file PreparedStatementWrapper.java. |
|
Sets the value of the designated parameter with the given object. This method is like the method
Definition at line 1205 of file PreparedStatementWrapper.java. |
|
Sets the value of the designated parameter using the given object. The second parameter must be of type
The JDBC specification specifies a standard mapping from Java Note that this method may be used to pass datatabase- specific abstract data types, by using a driver-specific Java type.
If the object is of a class implementing the interface This method throws an exception if there is an ambiguity, for example, if the object is of a class implementing more than one of the interfaces named above.
Definition at line 1185 of file PreparedStatementWrapper.java. |
|
Sets the number of seconds the driver will wait for a
Definition at line 2090 of file PreparedStatementWrapper.java. |
|
Sets the designated parameter to the given
Definition at line 1264 of file PreparedStatementWrapper.java. |
|
Sets the designated parameter to the given Java
Definition at line 1282 of file PreparedStatementWrapper.java. |
|
Sets the designated parameter to the given Java
Definition at line 1303 of file PreparedStatementWrapper.java. |
|
Sets the designated parameter to the given
Definition at line 1347 of file PreparedStatementWrapper.java. |
|
Sets the designated parameter to the given
Definition at line 1321 of file PreparedStatementWrapper.java. |
|
Sets the designated parameter to the given
Definition at line 1392 of file PreparedStatementWrapper.java. |
|
Sets the designated parameter to the given
Definition at line 1366 of file PreparedStatementWrapper.java. |
|
Sets the designated parameter to the given input stream, which will have the specified number of bytes. A Unicode character has two bytes, with the first byte being the high byte, and the second being the low byte.
When a very large Unicode value is input to a Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
Definition at line 1424 of file PreparedStatementWrapper.java. |
|
Sets the designated parameter to the given
Definition at line 2110 of file PreparedStatementWrapper.java. |