java.sql.CallableStatement
This section describes java.sql.CallableStatement, the API for executing the stored procedure.
Table 1 Support status for java.sql.CallableStatement
Method Name | Return Type | JDBC 4 Is 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 |
NOTE:
- 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.
openGauss 2024-05-07 00:46:52