API Overview API Index Package Overview Direct link to this page
JDK 1.6
  java.sql. CallableStatement View Source
Author(s)
Since
Version
Serial
Hierarchy
 Wrapper
      Statement
          PreparedStatement
              CallableStatement
Subinterfaces
Quick Links: Methods   Fields  
Description
public interface CallableStatement
  The interface used to execute SQL stored procedures.
See also:    Connection.prepareCall(java.lang.String) ResultSet
Methods
Hide/Show inherited methods
public Array getArray (int parameterIndex) throws SQLException
  Retrieves the value of the designated JDBC ARRAY parameter as an Array object in the Java programming language.
public Array getArray (String parameterName) throws SQLException
  Retrieves the value of a JDBC ARRAY parameter as an Array object in the Java programming language.
public BigDecimal getBigDecimal (int parameterIndex) throws SQLException
  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.
public BigDecimal getBigDecimal (int parameterIndex, int scale) throws SQLException
  Retrieves the value of the designated JDBC NUMERIC parameter as a java.math.BigDecimal object with scale digits to the right of the decimal point.
public BigDecimal getBigDecimal (String parameterName) throws SQLException
  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.
public Blob getBlob (int parameterIndex) throws SQLException
  Retrieves the value of the designated JDBC BLOB parameter as a Blob object in the Java programming language.
public Blob getBlob (String parameterName) throws SQLException
  Retrieves the value of a JDBC BLOB parameter as a Blob object in the Java programming language.
public boolean getBoolean (int parameterIndex) throws SQLException
  Retrieves the value of the designated JDBC BIT or BOOLEAN parameter as a boolean in the Java programming language.
public boolean getBoolean (String parameterName) throws SQLException
  Retrieves the value of a JDBC BIT or BOOLEAN parameter as a boolean in the Java programming language.
public byte getByte (int parameterIndex) throws SQLException
  Retrieves the value of the designated JDBC TINYINT parameter as a byte in the Java programming language.
public byte getByte (String parameterName) throws SQLException
  Retrieves the value of a JDBC TINYINT parameter as a byte in the Java programming language.
public byte getBytes (int parameterIndex) throws SQLException
  Retrieves the value of the designated JDBC BINARY or VARBINARY parameter as an array of byte values in the Java programming language.
public byte getBytes (String parameterName) throws SQLException
  Retrieves the value of a JDBC BINARY or VARBINARY parameter as an array of byte values in the Java programming language.
public Reader getCharacterStream (int parameterIndex) throws SQLException
  Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.
public Reader getCharacterStream (String parameterName) throws SQLException
  Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.
public Clob getClob (int parameterIndex) throws SQLException
  Retrieves the value of the designated JDBC CLOB parameter as a java.sql.Clob object in the Java programming language.
public Clob getClob (String parameterName) throws SQLException
  Retrieves the value of a JDBC CLOB parameter as a java.sql.Clob object in the Java programming language.
public Date getDate (int parameterIndex) throws SQLException
  Retrieves the value of the designated JDBC DATE parameter as a java.sql.Date object.
public Date getDate (int parameterIndex, Calendar cal) throws SQLException
  Retrieves the value of the designated JDBC DATE parameter as a java.sql.Date object, using the given Calendar object to construct the date.
public Date getDate (String parameterName) throws SQLException
  Retrieves the value of a JDBC DATE parameter as a java.sql.Date object.
public Date getDate (String parameterName, Calendar cal) throws SQLException
  Retrieves the value of a JDBC DATE parameter as a java.sql.Date object, using the given Calendar object to construct the date.
public double getDouble (int parameterIndex) throws SQLException
  Retrieves the value of the designated JDBC DOUBLE parameter as a double in the Java programming language.
public double getDouble (String parameterName) throws SQLException
  Retrieves the value of a JDBC DOUBLE parameter as a double in the Java programming language.
public float getFloat (int parameterIndex) throws SQLException
  Retrieves the value of the designated JDBC FLOAT parameter as a float in the Java programming language.
public float getFloat (String parameterName) throws SQLException
  Retrieves the value of a JDBC FLOAT parameter as a float in the Java programming language.
public int getInt (int parameterIndex) throws SQLException
  Retrieves the value of the designated JDBC INTEGER parameter as an int in the Java programming language.
public int getInt (String parameterName) throws SQLException
  Retrieves the value of a JDBC INTEGER parameter as an int in the Java programming language.
public long getLong (int parameterIndex) throws SQLException
  Retrieves the value of the designated JDBC BIGINT parameter as a long in the Java programming language.
public long getLong (String parameterName) throws SQLException
  Retrieves the value of a JDBC BIGINT parameter as a long in the Java programming language.
public Reader getNCharacterStream (int parameterIndex) throws SQLException
  Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.
public Reader getNCharacterStream (String parameterName) throws SQLException
  Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.
public NClob getNClob (int parameterIndex) throws SQLException
  Retrieves the value of the designated JDBC NCLOB parameter as a java.sql.NClob object in the Java programming language.
public NClob getNClob (String parameterName) throws SQLException
  Retrieves the value of a JDBC NCLOB parameter as a java.sql.NClob object in the Java programming language.
public String getNString (int parameterIndex) throws SQLException
  Retrieves the value of the designated NCHAR, NVARCHAR or LONGNVARCHAR parameter as a String in the Java programming language.
public String getNString (String parameterName) throws SQLException
  Retrieves the value of the designated NCHAR, NVARCHAR or LONGNVARCHAR parameter as a String in the Java programming language.
public Object getObject (int parameterIndex) throws SQLException
  Retrieves the value of the designated parameter as an Object in the Java programming language.
public Object getObject (int parameterIndex, Map<String, Class<Object>> map) throws SQLException
  Returns an object representing the value of OUT parameter parameterIndex and uses map for the custom mapping of the parameter value.
public Object getObject (String parameterName) throws SQLException
  Retrieves the value of a parameter as an Object in the Java programming language.
public Object getObject (String parameterName, Map<String, Class<Object>> map) throws SQLException
  Returns an object representing the value of OUT parameter parameterName and uses map for the custom mapping of the parameter value.
public Ref getRef (int parameterIndex) throws SQLException
  Retrieves the value of the designated JDBC REF(<structured-type>) parameter as a Ref object in the Java programming language.
public Ref getRef (String parameterName) throws SQLException
  Retrieves the value of a JDBC REF(<structured-type>) parameter as a Ref object in the Java programming language.
public RowId getRowId (int parameterIndex) throws SQLException
  Retrieves the value of the designated JDBC ROWID parameter as a java.sql.RowId object.
public RowId getRowId (String parameterName) throws SQLException
  Retrieves the value of the designated JDBC ROWID parameter as a java.sql.RowId object.
public short getShort (int parameterIndex) throws SQLException
  Retrieves the value of the designated JDBC SMALLINT parameter as a short in the Java programming language.
public short getShort (String parameterName) throws SQLException
  Retrieves the value of a JDBC SMALLINT parameter as a short in the Java programming language.
public SQLXML getSQLXML (int parameterIndex) throws SQLException
  Retrieves the value of the designated SQL XML parameter as a java.sql.SQLXML object in the Java programming language.
public SQLXML getSQLXML (String parameterName) throws SQLException
  Retrieves the value of the designated SQL XML parameter as a java.sql.SQLXML object in the Java programming language.
public String getString (int parameterIndex) throws SQLException
  Retrieves the value of the designated JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language.
public String getString (String parameterName) throws SQLException
  Retrieves the value of a JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language.
public Time getTime (int parameterIndex) throws SQLException
  Retrieves the value of the designated JDBC TIME parameter as a java.sql.Time object.
public Time getTime (int parameterIndex, Calendar cal) throws SQLException
  Retrieves the value of the designated JDBC TIME parameter as a java.sql.Time object, using the given Calendar object to construct the time.
public Time getTime (String parameterName) throws SQLException
  Retrieves the value of a JDBC TIME parameter as a java.sql.Time object.
public Time getTime (String parameterName, Calendar cal) throws SQLException
  Retrieves the value of a JDBC TIME parameter as a java.sql.Time object, using the given Calendar object to construct the time.
public Timestamp getTimestamp (int parameterIndex) throws SQLException
  Retrieves the value of the designated JDBC TIMESTAMP parameter as a java.sql.Timestamp object.
public Timestamp getTimestamp (int parameterIndex, Calendar cal) throws SQLException
  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.
public Timestamp getTimestamp (String parameterName) throws SQLException
  Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object.
public Timestamp getTimestamp (String parameterName, Calendar cal) throws SQLException
  Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object, using the given Calendar object to construct the Timestamp object.
public URL getURL (int parameterIndex) throws SQLException
  Retrieves the value of the designated JDBC DATALINK parameter as a java.net.URL object.
public URL getURL (String parameterName) throws SQLException
  Retrieves the value of a JDBC DATALINK parameter as a java.net.URL object.
public void registerOutParameter (int parameterIndex, int sqlType) throws SQLException
  Registers the OUT parameter in ordinal position parameterIndex to the JDBC type sqlType.
public void registerOutParameter (int parameterIndex, int sqlType, int scale) throws SQLException
  Registers the parameter in ordinal position parameterIndex to be of JDBC type sqlType.
public void registerOutParameter (int parameterIndex, int sqlType, String typeName) throws SQLException
  Registers the designated output parameter.
public void registerOutParameter (String parameterName, int sqlType) throws SQLException
  Registers the OUT parameter named parameterName to the JDBC type sqlType.
public void registerOutParameter (String parameterName, int sqlType, int scale) throws SQLException
  Registers the parameter named parameterName to be of JDBC type sqlType.
public void registerOutParameter (String parameterName, int sqlType, String typeName) throws SQLException
  Registers the designated output parameter.
public void setAsciiStream (String parameterName, InputStream x) throws SQLException
  Sets the designated parameter to the given input stream.
public void setAsciiStream (String parameterName, InputStream x, int length) throws SQLException
  Sets the designated parameter to the given input stream, which will have the specified number of bytes.
public void setAsciiStream (String parameterName, InputStream x, long length) throws SQLException
  Sets the designated parameter to the given input stream, which will have the specified number of bytes.
public void setBigDecimal (String parameterName, BigDecimal x) throws SQLException
  Sets the designated parameter to the given java.math.BigDecimal value.
public void setBinaryStream (String parameterName, InputStream x) throws SQLException
  Sets the designated parameter to the given input stream.
public void setBinaryStream (String parameterName, InputStream x, int length) throws SQLException
  Sets the designated parameter to the given input stream, which will have the specified number of bytes.
public void setBinaryStream (String parameterName, InputStream x, long length) throws SQLException
  Sets the designated parameter to the given input stream, which will have the specified number of bytes.
public void setBlob (String parameterName, Blob x) throws SQLException
  Sets the designated parameter to the given java.sql.Blob object.
public void setBlob (String parameterName, InputStream inputStream) throws SQLException
  Sets the designated parameter to a InputStream object.
public void setBlob (String parameterName, InputStream inputStream, long length) throws SQLException
  Sets the designated parameter to a InputStream object.
public void setBoolean (String parameterName, boolean x) throws SQLException
  Sets the designated parameter to the given Java boolean value.
public void setByte (String parameterName, byte x) throws SQLException
  Sets the designated parameter to the given Java byte value.
public void setBytes (String parameterName, byte[] x) throws SQLException
  Sets the designated parameter to the given Java array of bytes.
public void setCharacterStream (String parameterName, Reader reader) throws SQLException
  Sets the designated parameter to the given Reader object.
public void setCharacterStream (String parameterName, Reader reader, int length) throws SQLException
  Sets the designated parameter to the given Reader object, which is the given number of characters long.
public void setCharacterStream (String parameterName, Reader reader, long length) throws SQLException
  Sets the designated parameter to the given Reader object, which is the given number of characters long.
public void setClob (String parameterName, Clob x) throws SQLException
  Sets the designated parameter to the given java.sql.Clob object.
public void setClob (String parameterName, Reader reader) throws SQLException
  Sets the designated parameter to a Reader object.
public void setClob (String parameterName, Reader reader, long length) throws SQLException
  Sets the designated parameter to a Reader object.
public void setDate (String parameterName, Date x) throws SQLException
  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.
public void setDate (String parameterName, Date x, Calendar cal) throws SQLException
  Sets the designated parameter to the given java.sql.Date value, using the given Calendar object.
public void setDouble (String parameterName, double x) throws SQLException
  Sets the designated parameter to the given Java double value.
public void setFloat (String parameterName, float x) throws SQLException
  Sets the designated parameter to the given Java float value.
public void setInt (String parameterName, int x) throws SQLException
  Sets the designated parameter to the given Java int value.
public void setLong (String parameterName, long x) throws SQLException
  Sets the designated parameter to the given Java long value.
public void setNCharacterStream (String parameterName, Reader value) throws SQLException
  Sets the designated parameter to a Reader object.
public void setNCharacterStream (String parameterName, Reader value, long length) throws SQLException
  Sets the designated parameter to a Reader object.
public void setNClob (String parameterName, NClob value) throws SQLException
  Sets the designated parameter to a java.sql.NClob object.
public void setNClob (String parameterName, Reader reader) throws SQLException
  Sets the designated parameter to a Reader object.
public void setNClob (String parameterName, Reader reader, long length) throws SQLException
  Sets the designated parameter to a Reader object.
public void setNString (String parameterName, String value) throws SQLException
  Sets the designated parameter to the given String object.
public void setNull (String parameterName, int sqlType) throws SQLException
  Sets the designated parameter to SQL NULL.
public void setNull (String parameterName, int sqlType, String typeName) throws SQLException
  Sets the designated parameter to SQL NULL.
public void setObject (String parameterName, Object x) throws SQLException
  Sets the value of the designated parameter with the given object.
public void setObject (String parameterName, Object x, int targetSqlType) throws SQLException
  Sets the value of the designated parameter with the given object.
public void setObject (String parameterName, Object x, int targetSqlType, int scale) throws SQLException
  Sets the value of the designated parameter with the given object.
public void setRowId (String parameterName, RowId x) throws SQLException
  Sets the designated parameter to the given java.sql.RowId object.
public void setShort (String parameterName, short x) throws SQLException
  Sets the designated parameter to the given Java short value.
public void setSQLXML (String parameterName, SQLXML xmlObject) throws SQLException
  Sets the designated parameter to the given java.sql.SQLXML object.
public void setString (String parameterName, String x) throws SQLException
  Sets the designated parameter to the given Java String value.
public void setTime (String parameterName, Time x) throws SQLException
  Sets the designated parameter to the given java.sql.Time value.
public void setTime (String parameterName, Time x, Calendar cal) throws SQLException
  Sets the designated parameter to the given java.sql.Time value, using the given Calendar object.
public void setTimestamp (String parameterName, Timestamp x) throws SQLException
  Sets the designated parameter to the given java.sql.Timestamp value.
public void setTimestamp (String parameterName, Timestamp x, Calendar cal) throws SQLException
  Sets the designated parameter to the given java.sql.Timestamp value, using the given Calendar object.
public void setURL (String parameterName, URL val) throws SQLException
  Sets the designated parameter to the given java.net.URL object.
public boolean wasNull () throws SQLException
  Retrieves whether the last OUT parameter read had the value of SQL NULL.
Fields
Hide/Show inherited fields
publicfinalstatic int CLOSE_ALL_RESULTS = "3" [Inherited From PreparedStatement]
  The constant indicating that all ResultSet objects that have previously been kept open should be closed when calling getMoreResults.
publicfinalstatic int CLOSE_CURRENT_RESULT = "1" [Inherited From PreparedStatement]
  The constant indicating that the current ResultSet object should be closed when calling getMoreResults.
publicfinalstatic int EXECUTE_FAILED = "-3" [Inherited From PreparedStatement]
  The constant indicating that an error occured while executing a batch statement.
publicfinalstatic int KEEP_CURRENT_RESULT = "2" [Inherited From PreparedStatement]
  The constant indicating that the current ResultSet object should not be closed when calling getMoreResults.
publicfinalstatic int NO_GENERATED_KEYS = "2" [Inherited From PreparedStatement]
  The constant indicating that generated keys should not be made available for retrieval.
publicfinalstatic int RETURN_GENERATED_KEYS = "1" [Inherited From PreparedStatement]
  The constant indicating that generated keys should be made available for retrieval.
publicfinalstatic int SUCCESS_NO_INFO = "-2" [Inherited From PreparedStatement]
  The constant indicating that a batch statement executed successfully but that no count of the number of rows it affected is available.
Generated By: JavaOnTracks Doclet 0.1.4     ©Thibaut Colar