java.sql.CallableStatement
java.sql.CallableStatement is an API for executing stored procedures.
| Method Name | Return Type | JDBC4 Supported or Not |
|---|---|---|
| getArray(int parameterIndex) | Array | Yes |
| getBigDecimal(int parameterIndex) | BigDecimal | Yes |
| getBlob(int parameterIndex) | Blob | Yes |
| getBoolean(int parameterIndex) | boolean | Yes |
| getByte(int parameterIndex) | byte | Yes |
| getBytes(int parameterIndex) | byte[] | Yes |
| getClob(int parameterIndex) | Clob | Yes |
| getDate(int parameterIndex) | Date | Yes |
| getDate(int parameterIndex, Calendar cal) | Date | Yes |
| getDouble(int parameterIndex) | double | Yes |
| getFloat(int parameterIndex) | float | Yes |
| getInt(int parameterIndex) | int | Yes |
| getLong(int parameterIndex) | long | Yes |
| getObject(int parameterIndex) | Object | Yes |
| getObject(int parameterIndex, Class<T> type) | Object | Yes |
| getShort(int parameterIndex) | short | Yes |
| getSQLXML(int parameterIndex) | SQLXML | Yes |
| getString(int parameterIndex) | String | Yes |
| getNString(int parameterIndex) | String | Yes |
| getTime(int parameterIndex) | Time | Yes |
| getTime(int parameterIndex, Calendar cal) | Time | Yes |
| getTimestamp(int parameterIndex) | Timestamp | Yes |
| getTimestamp(int parameterIndex, Calendar cal) | Timestamp | Yes |
| registerOutParameter(int parameterIndex, int type) | void | Yes |
| registerOutParameter(int parameterIndex, int sqlType, int type) | void | Yes |
| wasNull() | boolean | Yes |
- The batch operation of statements containing OUT parameter is not allowed.
- The following methods are inherited from java.sql.Statement: close, execute, executeQuery, executeUpdate, getConnection, getResultSet, getUpdateCount, isClosed, setMaxRows, and setFetchSize.
- The following methods are inherited from java.sql.PreparedStatement: addBatch, clearParameters, execute, executeQuery, executeUpdate, getMetaData, setBigDecimal, setBoolean, setByte, setBytes, setDate, setDouble, setFloat, setInt, setLong, setNull, setObject, setString, setTime, and setTimestamp.
- The registerOutParameter(int parameterIndex, int sqlType, int type) method is used only to register the composite data type.
