Docjar: A Java Source and Docuemnt Enginecom.*    java.*    javax.*    org.*    all    new    plug-in

Quick Search    Search Deep

com.mockobjects.eziba.sql
Class CallableStatement  view CallableStatement download CallableStatement.java

java.lang.Object
  extended bycom.mockobjects.eziba.sql.Statement
      extended bycom.mockobjects.eziba.sql.PreparedStatement
          extended bycom.mockobjects.eziba.sql.CallableStatement
All Implemented Interfaces:
java.sql.CallableStatement, java.sql.PreparedStatement, java.sql.Statement

public class CallableStatement
extends PreparedStatement
implements java.sql.CallableStatement


Field Summary
private  java.util.SortedMap m_outs
           
private  java.lang.Object[] m_results
           
 
Fields inherited from class com.mockobjects.eziba.sql.PreparedStatement
m_args
 
Fields inherited from class com.mockobjects.eziba.sql.Statement
connection, sql
 
Fields inherited from interface java.sql.Statement
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO
 
Constructor Summary
(package private) CallableStatement(Connection p_connection, java.lang.String p_sql)
           
 
Method Summary
 boolean execute()
          This method executes a prepared SQL query.
 java.sql.Array getArray(int i)
          This method returns the value of the specified parameter as a Java Array.
 java.math.BigDecimal getBigDecimal(int parameterIndex)
          This method returns the value of the specified parameter as a Java BigDecimal.
 java.math.BigDecimal getBigDecimal(int parameterIndex, int scale)
          This method returns the value of the specified parameter as a Java BigDecimal.
 java.sql.Blob getBlob(int i)
          This method returns the value of the specified parameter as a Java Blob.
 boolean getBoolean(int parameterIndex)
          This method returns the value of the specified parameter as a Java boolean.
 byte getByte(int parameterIndex)
          This method returns the value of the specified parameter as a Java byte.
 byte[] getBytes(int parameterIndex)
          This method returns the value of the specified parameter as a Java byte array.
 java.sql.Clob getClob(int i)
          This method returns the value of the specified parameter as a Java Clob.
 java.sql.Date getDate(int parameterIndex)
          This method returns the value of the specified parameter as a Java java.sql.Date.
 java.sql.Date getDate(int parameterIndex, java.util.Calendar cal)
          This method returns the value of the specified parameter as a Java java.sql.Date.
 double getDouble(int parameterIndex)
          This method returns the value of the specified parameter as a Java double.
 float getFloat(int parameterIndex)
          This method returns the value of the specified parameter as a Java float.
 int getInt(int parameterIndex)
          This method returns the value of the specified parameter as a Java int.
 long getLong(int parameterIndex)
          This method returns the value of the specified parameter as a Java long.
 java.lang.Object getObject(int parameterIndex)
          This method returns the value of the specified parameter as a Java Object.
 java.lang.Object getObject(int i, java.util.Map map)
          This method returns the value of the specified parameter as a Java Object.
private  java.lang.Object getOutParameter(int i)
           
 java.sql.Ref getRef(int i)
          This method returns the value of the specified parameter as a Java Ref.
 short getShort(int parameterIndex)
          This method returns the value of the specified parameter as a Java short.
 java.lang.String getString(int parameterIndex)
          This method returns the value of the specified parameter as a Java String.
 java.sql.Time getTime(int parameterIndex)
          This method returns the value of the specified parameter as a Java java.sql.Time.
 java.sql.Time getTime(int parameterIndex, java.util.Calendar cal)
          This method returns the value of the specified parameter as a Java java.sql.Time.
 java.sql.Timestamp getTimestamp(int parameterIndex)
          This method returns the value of the specified parameter as a Java java.sql.Timestamp.
 java.sql.Timestamp getTimestamp(int parameterIndex, java.util.Calendar cal)
          This method returns the value of the specified parameter as a Java java.sql.Timestamp.
 void registerOutParameter(int parameterIndex, int sqlType)
          This method registers the specified parameter as an output parameter of the specified SQL type.
 void registerOutParameter(int parameterIndex, int sqlType, int scale)
          This method registers the specified parameter as an output parameter of the specified SQL type and scale.
 void registerOutParameter(int paramIndex, int sqlType, java.lang.String typeName)
          This method registers the specified parameter as an output parameter of the specified SQL type.
 boolean wasNull()
          This method tests whether the value of the last parameter that was fetched was actually a SQL NULL value.
 
Methods inherited from class com.mockobjects.eziba.sql.PreparedStatement
addBatch, clearParameters, executeQuery, executeUpdate, getArguments, getMetaData, getResultSet, getUpdateCount, setArg, setArray, setAsciiStream, setBigDecimal, setBinaryStream, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNull, setNull, setObject, setObject, setObject, setRef, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream
 
Methods inherited from class com.mockobjects.eziba.sql.Statement
addBatch, cancel, clearBatch, clearWarnings, close, execute, executeBatch, executeQuery, executeUpdate, getConnection, getFetchDirection, getFetchSize, getMaxFieldSize, getMaxRows, getMoreResults, getQueryTimeout, getResultSetConcurrency, getResultSetType, getWarnings, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 
Methods inherited from interface java.sql.CallableStatement
getArray, getBigDecimal, getBlob, getBoolean, getByte, getBytes, getClob, getDate, getDate, getDouble, getFloat, getInt, getLong, getObject, getObject, getRef, getShort, getString, getTime, getTime, getTimestamp, getTimestamp, getURL, getURL, registerOutParameter, registerOutParameter, registerOutParameter, setAsciiStream, setBigDecimal, setBinaryStream, setBoolean, setByte, setBytes, setCharacterStream, setDate, setDate, setDouble, setFloat, setInt, setLong, setNull, setNull, setObject, setObject, setObject, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setURL
 
Methods inherited from interface java.sql.PreparedStatement
addBatch, clearParameters, executeQuery, executeUpdate, getMetaData, getParameterMetaData, setArray, setAsciiStream, setBigDecimal, setBinaryStream, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNull, setNull, setObject, setObject, setObject, setRef, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL
 
Methods inherited from interface java.sql.Statement
addBatch, cancel, clearBatch, clearWarnings, close, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout
 

Field Detail

m_results

private java.lang.Object[] m_results

m_outs

private java.util.SortedMap m_outs
Constructor Detail

CallableStatement

CallableStatement(Connection p_connection,
                  java.lang.String p_sql)
Method Detail

execute

public boolean execute()
                throws java.sql.SQLException
Description copied from interface: java.sql.PreparedStatement
This method executes a prepared SQL query. Some prepared statements return multiple results; the execute method handles these complex statements as well as the simpler form of statements handled by executeQuery and executeUpdate.

Specified by:
execute in interface java.sql.PreparedStatement
Overrides:
execute in class PreparedStatement

registerOutParameter

public void registerOutParameter(int parameterIndex,
                                 int sqlType)
Description copied from interface: java.sql.CallableStatement
This method registers the specified parameter as an output parameter of the specified SQL type.

Specified by:
registerOutParameter in interface java.sql.CallableStatement

getOutParameter

private java.lang.Object getOutParameter(int i)
                                  throws java.sql.SQLException

getInt

public int getInt(int parameterIndex)
           throws java.sql.SQLException
Description copied from interface: java.sql.CallableStatement
This method returns the value of the specified parameter as a Java int.

Specified by:
getInt in interface java.sql.CallableStatement

getBigDecimal

public java.math.BigDecimal getBigDecimal(int parameterIndex)
                                   throws java.sql.SQLException
Description copied from interface: java.sql.CallableStatement
This method returns the value of the specified parameter as a Java BigDecimal.

Specified by:
getBigDecimal in interface java.sql.CallableStatement

getString

public java.lang.String getString(int parameterIndex)
                           throws java.sql.SQLException
Description copied from interface: java.sql.CallableStatement
This method returns the value of the specified parameter as a Java String.

Specified by:
getString in interface java.sql.CallableStatement

getArray

public java.sql.Array getArray(int i)
Description copied from interface: java.sql.CallableStatement
This method returns the value of the specified parameter as a Java Array.

Specified by:
getArray in interface java.sql.CallableStatement

getBigDecimal

public java.math.BigDecimal getBigDecimal(int parameterIndex,
                                          int scale)
Deprecated.  

Description copied from interface: java.sql.CallableStatement
This method returns the value of the specified parameter as a Java BigDecimal.

Specified by:
getBigDecimal in interface java.sql.CallableStatement

getBlob

public java.sql.Blob getBlob(int i)
Description copied from interface: java.sql.CallableStatement
This method returns the value of the specified parameter as a Java Blob.

Specified by:
getBlob in interface java.sql.CallableStatement

getBoolean

public boolean getBoolean(int parameterIndex)
Description copied from interface: java.sql.CallableStatement
This method returns the value of the specified parameter as a Java boolean.

Specified by:
getBoolean in interface java.sql.CallableStatement

getByte

public byte getByte(int parameterIndex)
Description copied from interface: java.sql.CallableStatement
This method returns the value of the specified parameter as a Java byte.

Specified by:
getByte in interface java.sql.CallableStatement

getBytes

public byte[] getBytes(int parameterIndex)
Description copied from interface: java.sql.CallableStatement
This method returns the value of the specified parameter as a Java byte array.

Specified by:
getBytes in interface java.sql.CallableStatement

getClob

public java.sql.Clob getClob(int i)
Description copied from interface: java.sql.CallableStatement
This method returns the value of the specified parameter as a Java Clob.

Specified by:
getClob in interface java.sql.CallableStatement

getDate

public java.sql.Date getDate(int parameterIndex)
Description copied from interface: java.sql.CallableStatement
This method returns the value of the specified parameter as a Java java.sql.Date.

Specified by:
getDate in interface java.sql.CallableStatement

getDate

public java.sql.Date getDate(int parameterIndex,
                             java.util.Calendar cal)
Description copied from interface: java.sql.CallableStatement
This method returns the value of the specified parameter as a Java java.sql.Date.

Specified by:
getDate in interface java.sql.CallableStatement

getDouble

public double getDouble(int parameterIndex)
Description copied from interface: java.sql.CallableStatement
This method returns the value of the specified parameter as a Java double.

Specified by:
getDouble in interface java.sql.CallableStatement

getFloat

public float getFloat(int parameterIndex)
Description copied from interface: java.sql.CallableStatement
This method returns the value of the specified parameter as a Java float.

Specified by:
getFloat in interface java.sql.CallableStatement

getLong

public long getLong(int parameterIndex)
Description copied from interface: java.sql.CallableStatement
This method returns the value of the specified parameter as a Java long.

Specified by:
getLong in interface java.sql.CallableStatement

getObject

public java.lang.Object getObject(int parameterIndex)
Description copied from interface: java.sql.CallableStatement
This method returns the value of the specified parameter as a Java Object.

Specified by:
getObject in interface java.sql.CallableStatement

getObject

public java.lang.Object getObject(int i,
                                  java.util.Map map)
Description copied from interface: java.sql.CallableStatement
This method returns the value of the specified parameter as a Java Object.

Specified by:
getObject in interface java.sql.CallableStatement

getRef

public java.sql.Ref getRef(int i)
Description copied from interface: java.sql.CallableStatement
This method returns the value of the specified parameter as a Java Ref.

Specified by:
getRef in interface java.sql.CallableStatement

getShort

public short getShort(int parameterIndex)
Description copied from interface: java.sql.CallableStatement
This method returns the value of the specified parameter as a Java short.

Specified by:
getShort in interface java.sql.CallableStatement

getTime

public java.sql.Time getTime(int parameterIndex)
Description copied from interface: java.sql.CallableStatement
This method returns the value of the specified parameter as a Java java.sql.Time.

Specified by:
getTime in interface java.sql.CallableStatement

getTime

public java.sql.Time getTime(int parameterIndex,
                             java.util.Calendar cal)
Description copied from interface: java.sql.CallableStatement
This method returns the value of the specified parameter as a Java java.sql.Time.

Specified by:
getTime in interface java.sql.CallableStatement

getTimestamp

public java.sql.Timestamp getTimestamp(int parameterIndex)
Description copied from interface: java.sql.CallableStatement
This method returns the value of the specified parameter as a Java java.sql.Timestamp.

Specified by:
getTimestamp in interface java.sql.CallableStatement

getTimestamp

public java.sql.Timestamp getTimestamp(int parameterIndex,
                                       java.util.Calendar cal)
Description copied from interface: java.sql.CallableStatement
This method returns the value of the specified parameter as a Java java.sql.Timestamp.

Specified by:
getTimestamp in interface java.sql.CallableStatement

registerOutParameter

public void registerOutParameter(int parameterIndex,
                                 int sqlType,
                                 int scale)
Description copied from interface: java.sql.CallableStatement
This method registers the specified parameter as an output parameter of the specified SQL type and scale.

Specified by:
registerOutParameter in interface java.sql.CallableStatement

registerOutParameter

public void registerOutParameter(int paramIndex,
                                 int sqlType,
                                 java.lang.String typeName)
Description copied from interface: java.sql.CallableStatement
This method registers the specified parameter as an output parameter of the specified SQL type.

Specified by:
registerOutParameter in interface java.sql.CallableStatement

wasNull

public boolean wasNull()
Description copied from interface: java.sql.CallableStatement
This method tests whether the value of the last parameter that was fetched was actually a SQL NULL value.

Specified by:
wasNull in interface java.sql.CallableStatement