Java java.sql CallableStatement fields, constructors, methods, implement or subclass

Introduction

In this page you can find the methods, fields and constructors for java.sql CallableStatement.

The text is from its open source code.

Implementation

java.sql.CallableStatement has the following implementations.
Click this link to see all its implementation.

Method

void	addBatch() Adds a set of parameters to this `PreparedStatement` object's batch of commands.
void	clearBatch() Empties this `Statement` object's current list of SQL commands.
void	clearParameters() Clears the current parameter values immediately.
void	clearWarnings() Clears all the warnings reported on this `Statement` object.
void	close() Releases this `Statement` object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
boolean	execute() Executes the SQL statement in this `PreparedStatement` object, which may be any kind of SQL statement.
int[]	executeBatch() Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.
ResultSet	executeQuery() Executes the SQL query in this `PreparedStatement` object and returns the `ResultSet` object generated by the query.
int	executeUpdate() Executes the SQL statement in this `PreparedStatement` object, which must be an SQL Data Manipulation Language (DML) statement, such as `INSERT`, `UPDATE` or `DELETE`; or an SQL statement that returns nothing, such as a DDL statement.
Array	getArray(int parameterIndex) Retrieves the value of the designated JDBC `ARRAY` parameter as an java.sql.Array object in the Java programming language.
Array	getArray(String parameterName) Retrieves the value of a JDBC `ARRAY` parameter as an java.sql.Array object in the Java programming language.
BigDecimal	getBigDecimal(int parameterIndex) Retrieves the value of the designated JDBC `NUMERIC` parameter as a `java.math.BigDecimal` object with as many digits to the right of the decimal point as the value contains.
BigDecimal	getBigDecimal(String parameterName) Retrieves the value of a JDBC `NUMERIC` parameter as a `java.math.BigDecimal` object with as many digits to the right of the decimal point as the value contains.
Blob	getBlob(int parameterIndex) Retrieves the value of the designated JDBC `BLOB` parameter as a java.sql.Blob object in the Java programming language.
Blob	getBlob(String parameterName) Retrieves the value of a JDBC `BLOB` parameter as a java.sql.Blob object in the Java programming language.
boolean	getBoolean(int parameterIndex) Retrieves the value of the designated JDBC `BIT` or `BOOLEAN` parameter as a `boolean` in the Java programming language.
boolean	getBoolean(String parameterName) Retrieves the value of a JDBC `BIT` or `BOOLEAN` parameter as a `boolean` in the Java programming language.
byte	getByte(int parameterIndex) Retrieves the value of the designated JDBC `TINYINT` parameter as a `byte` in the Java programming language.
byte	getByte(String parameterName) Retrieves the value of a JDBC `TINYINT` parameter as a `byte` in the Java programming language.
byte[]	getBytes(int parameterIndex) Retrieves the value of the designated JDBC `BINARY` or `VARBINARY` parameter as an array of `byte` values in the Java programming language.
byte[]	getBytes(String parameterName) Retrieves the value of a JDBC `BINARY` or `VARBINARY` parameter as an array of `byte` values in the Java programming language.
Clob	getClob(int parameterIndex) Retrieves the value of the designated JDBC `CLOB` parameter as a `java.sql.Clob` object in the Java programming language.
Clob	getClob(String parameterName) Retrieves the value of a JDBC `CLOB` parameter as a `java.sql.Clob` object in the Java programming language.
Connection	getConnection() Retrieves the `Connection` object that produced this `Statement` object.
java.sql.Date	getDate(int parameterIndex) Retrieves the value of the designated JDBC `DATE` parameter as a `java.sql.Date` object.
java.sql.Date	getDate(String parameterName) Retrieves the value of a JDBC `DATE` parameter as a `java.sql.Date` object.
double	getDouble(int parameterIndex) Retrieves the value of the designated JDBC `DOUBLE` parameter as a `double` in the Java programming language.
double	getDouble(String parameterName) Retrieves the value of a JDBC `DOUBLE` parameter as a `double` in the Java programming language.
float	getFloat(int parameterIndex) Retrieves the value of the designated JDBC `FLOAT` parameter as a `float` in the Java programming language.
float	getFloat(String parameterName) Retrieves the value of a JDBC `FLOAT` parameter as a `float` in the Java programming language.
int	getInt(int parameterIndex) Retrieves the value of the designated JDBC `INTEGER` parameter as an `int` in the Java programming language.
int	getInt(String parameterName) Retrieves the value of a JDBC `INTEGER` parameter as an `int` in the Java programming language.
long	getLong(int parameterIndex) Retrieves the value of the designated JDBC `BIGINT` parameter as a `long` in the Java programming language.
long	getLong(String parameterName) Retrieves the value of a JDBC `BIGINT` parameter as a `long` in the Java programming language.
boolean	getMoreResults() Moves to this `Statement` object's next result, returns `true` if it is a `ResultSet` object, and implicitly closes any current `ResultSet` object(s) obtained with the method `getResultSet`.
boolean	getMoreResults(int current) Moves to this `Statement` object's next result, deals with any current `ResultSet` object(s) according to the instructions specified by the given flag, and returns `true` if the next result is a `ResultSet` object.
Object	getObject(int parameterIndex, java.util.Map> map) Returns an object representing the value of OUT parameter `parameterIndex` and uses `map` for the custom mapping of the parameter value.
Object	getObject(String parameterName, java.util.Map> map) Returns an object representing the value of OUT parameter `parameterName` and uses `map` for the custom mapping of the parameter value.
T	getObject(int parameterIndex, Class type) Returns an object representing the value of OUT parameter parameterIndex and will convert from the SQL type of the parameter to the requested Java data type, if the conversion is supported.
T	getObject(String parameterName, Class type) Returns an object representing the value of OUT parameter parameterName and will convert from the SQL type of the parameter to the requested Java data type, if the conversion is supported.
Object	getObject(int parameterIndex) Retrieves the value of the designated parameter as an `Object` in the Java programming language.
Object	getObject(String parameterName) Retrieves the value of a parameter as an `Object` in the Java programming language.
ParameterMetaData	getParameterMetaData() Retrieves the number, types and properties of this `PreparedStatement` object's parameters.
ResultSet	getResultSet() Retrieves the current result as a `ResultSet` object.
short	getShort(int parameterIndex) Retrieves the value of the designated JDBC `SMALLINT` parameter as a `short` in the Java programming language.
short	getShort(String parameterName) Retrieves the value of a JDBC `SMALLINT` parameter as a `short` in the Java programming language.
String	getString(int parameterIndex) Retrieves the value of the designated JDBC `CHAR`, `VARCHAR`, or `LONGVARCHAR` parameter as a `String` in the Java programming language.
String	getString(String parameterName) Retrieves the value of a JDBC `CHAR`, `VARCHAR`, or `LONGVARCHAR` parameter as a `String` in the Java programming language.
java.sql.Time	getTime(int parameterIndex) Retrieves the value of the designated JDBC `TIME` parameter as a `java.sql.Time` object.
java.sql.Time	getTime(String parameterName) Retrieves the value of a JDBC `TIME` parameter as a `java.sql.Time` object.
java.sql.Timestamp	getTimestamp(int parameterIndex) Retrieves the value of the designated JDBC `TIMESTAMP` parameter as a `java.sql.Timestamp` object.
java.sql.Timestamp	getTimestamp(String parameterName) Retrieves the value of a JDBC `TIMESTAMP` parameter as a `java.sql.Timestamp` object.
java.sql.Timestamp	getTimestamp(int parameterIndex, Calendar cal) Retrieves the value of the designated JDBC `TIMESTAMP` parameter as a `java.sql.Timestamp` object, using the given `Calendar` object to construct the `Timestamp` object.
java.sql.Timestamp	getTimestamp(String parameterName, Calendar cal) Retrieves the value of a JDBC `TIMESTAMP` parameter as a `java.sql.Timestamp` object, using the given `Calendar` object to construct the `Timestamp` object.
int	getUpdateCount() Retrieves the current result as an update count; if the result is a `ResultSet` object or there are no more results, -1 is returned.
SQLWarning	getWarnings() Retrieves the first warning reported by calls on this `Statement` object.
boolean	isClosed() Retrieves whether this `Statement` object has been closed.
void	registerOutParameter(int parameterIndex, int sqlType) Registers the OUT parameter in ordinal position `parameterIndex` to the JDBC type `sqlType`.
void	registerOutParameter(String parameterName, int sqlType) Registers the OUT parameter named `parameterName` to the JDBC type `sqlType`.
void	registerOutParameter(int parameterIndex, SQLType sqlType) Registers the OUT parameter in ordinal position parameterIndex to the JDBC type sqlType .
void	registerOutParameter(String parameterName, SQLType sqlType) Registers the OUT parameter named `parameterName` to the JDBC type sqlType .
void	registerOutParameter(int parameterIndex, int sqlType, int scale) Registers the parameter in ordinal position `parameterIndex` to be of JDBC type `sqlType`.
void	registerOutParameter(int parameterIndex, int sqlType, String typeName) Registers the designated output parameter.
void	registerOutParameter(String parameterName, int sqlType, int scale) Registers the parameter named `parameterName` to be of JDBC type `sqlType`.
void	registerOutParameter(String parameterName, int sqlType, String typeName) Registers the designated output parameter.
void	registerOutParameter(int parameterIndex, SQLType sqlType, int scale) Registers the parameter in ordinal position parameterIndex to be of JDBC type sqlType .
void	registerOutParameter(int parameterIndex, SQLType sqlType, String typeName) Registers the designated output parameter.
void	registerOutParameter(String parameterName, SQLType sqlType, int scale) Registers the parameter named `parameterName` to be of JDBC type sqlType .
void	registerOutParameter(String parameterName, SQLType sqlType, String typeName) Registers the designated output parameter.
void	setArray(int parameterIndex, Array x) Sets the designated parameter to the given `java.sql.Array` object.
void	setBigDecimal(String parameterName, BigDecimal x) Sets the designated parameter to the given `java.math.BigDecimal` value.
void	setBinaryStream(String parameterName, java.io.InputStream x, int length) Sets the designated parameter to the given input stream, which will have the specified number of bytes.
void	setBinaryStream(String parameterName, java.io.InputStream x, long length) Sets the designated parameter to the given input stream, which will have the specified number of bytes.
void	setBlob(String parameterName, Blob x) Sets the designated parameter to the given `java.sql.Blob` object.
void	setBlob(String parameterName, InputStream inputStream) Sets the designated parameter to an InputStream object.
void	setBoolean(String parameterName, boolean x) Sets the designated parameter to the given Java `boolean` value.
void	setCharacterStream(String parameterName, java.io.Reader reader) Sets the designated parameter to the given `Reader` object.
void	setClob(String parameterName, Clob x) Sets the designated parameter to the given `java.sql.Clob` object.
void	setClob(String parameterName, Reader reader) Sets the designated parameter to a `Reader` object.
void	setDate(String parameterName, java.sql.Date x) Sets the designated parameter to the given `java.sql.Date` value using the default time zone of the virtual machine that is running the application.
void	setDouble(String parameterName, double x) Sets the designated parameter to the given Java `double` value.
void	setFetchDirection(int direction) Gives the driver a hint as to the direction in which rows will be processed in `ResultSet` objects created using this `Statement` object.
void	setFetchSize(int rows) Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for `ResultSet` objects generated by this `Statement`.
void	setFloat(String parameterName, float x) Sets the designated parameter to the given Java `float` value.
void	setInt(String parameterName, int x) Sets the designated parameter to the given Java `int` value.
void	setLong(String parameterName, long x) Sets the designated parameter to the given Java `long` value.
void	setMaxRows(int max) Sets the limit for the maximum number of rows that any `ResultSet` object generated by this `Statement` object can contain to the given number.
void	setNCharacterStream(String parameterName, Reader value) Sets the designated parameter to a `Reader` object.
void	setNString(String parameterName, String value) Sets the designated parameter to the given `String` object.
void	setNull(String parameterName, int sqlType) Sets the designated parameter to SQL `NULL`.
void	setNull(String parameterName, int sqlType, String typeName) Sets the designated parameter to SQL `NULL`.
void	setObject(String parameterName, Object x) Sets the value of the designated parameter with the given object.
void	setObject(String parameterName, Object x, int targetSqlType) Sets the value of the designated parameter with the given object.
void	setObject(String parameterName, Object x, SQLType targetSqlType) Sets the value of the designated parameter with the given object.
void	setQueryTimeout(int seconds) Sets the number of seconds the driver will wait for a `Statement` object to execute to the given number of seconds.
void	setShort(String parameterName, short x) Sets the designated parameter to the given Java `short` value.
void	setSQLXML(String parameterName, SQLXML xmlObject) Sets the designated parameter to the given `java.sql.SQLXML` object.
void	setString(String parameterName, String x) Sets the designated parameter to the given Java `String` value.
void	setTime(String parameterName, java.sql.Time x) Sets the designated parameter to the given `java.sql.Time` value.
void	setTimestamp(String parameterName, java.sql.Timestamp x) Sets the designated parameter to the given `java.sql.Timestamp` value.
String	toString() Returns a string representation of the object.
T	unwrap(java.lang.Class iface) Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.
boolean	wasNull() Retrieves whether the last OUT parameter read had the value of SQL `NULL`.