|
||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||
java.lang.Objectorg.h2.message.TraceObject
org.h2.jdbc.JdbcStatement
org.h2.jdbc.JdbcPreparedStatement
org.h2.jdbc.JdbcCallableStatement
public class JdbcCallableStatement
Represents a callable statement.
| Field Summary |
|---|
| Fields inherited from class org.h2.jdbc.JdbcPreparedStatement |
|---|
command |
| Fields inherited from class org.h2.jdbc.JdbcStatement |
|---|
closedByResultSet, conn, fetchSize, maxRows, resultSet, resultSetConcurrency, resultSetType, session, updateCount |
| Fields inherited from class org.h2.message.TraceObject |
|---|
ARRAY, BLOB, CALLABLE_STATEMENT, CLOB, CONNECTION, DATA_SOURCE, DATABASE_META_DATA, PARAMETER_META_DATA, PREPARED_STATEMENT, RESULT_SET, RESULT_SET_META_DATA, SAVEPOINT, SQL_EXCEPTION, STATEMENT, trace, XA_DATA_SOURCE, XA_RESOURCE, XID |
| 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 |
| Method Summary | |
|---|---|
int |
executeUpdate()
Executes a statement (insert, update, delete, create, drop) and returns the update count. |
java.sql.Array |
getArray(int parameterIndex)
Returns the value of the specified column as an Array. |
java.sql.Array |
getArray(java.lang.String parameterName)
Returns the value of the specified column as an Array. |
java.math.BigDecimal |
getBigDecimal(int parameterIndex)
Returns the value of the specified column as a BigDecimal. |
java.math.BigDecimal |
getBigDecimal(int parameterIndex,
int scale)
Deprecated. use getBigDecimal(int) |
java.math.BigDecimal |
getBigDecimal(java.lang.String parameterName)
Returns the value of the specified column as a BigDecimal. |
java.sql.Blob |
getBlob(int parameterIndex)
Returns the value of the specified column as a Blob. |
java.sql.Blob |
getBlob(java.lang.String parameterName)
Returns the value of the specified column as a Blob. |
boolean |
getBoolean(int parameterIndex)
Returns the value of the specified column as a boolean. |
boolean |
getBoolean(java.lang.String parameterName)
Returns the value of the specified column as a boolean. |
byte |
getByte(int parameterIndex)
Returns the value of the specified column as a byte. |
byte |
getByte(java.lang.String parameterName)
Returns the value of the specified column as a byte. |
byte[] |
getBytes(int parameterIndex)
Returns the value of the specified column as a byte array. |
byte[] |
getBytes(java.lang.String parameterName)
Returns the value of the specified column as a byte array. |
java.sql.Clob |
getClob(int parameterIndex)
Returns the value of the specified column as a Clob. |
java.sql.Clob |
getClob(java.lang.String parameterName)
Returns the value of the specified column as a Clob. |
java.sql.Date |
getDate(int parameterIndex)
Returns the value of the specified column as a java.sql.Date. |
java.sql.Date |
getDate(int parameterIndex,
java.util.Calendar cal)
Returns the value of the specified column as a java.sql.Date using a specified time zone. |
java.sql.Date |
getDate(java.lang.String parameterName)
Returns the value of the specified column as a java.sql.Date. |
java.sql.Date |
getDate(java.lang.String parameterName,
java.util.Calendar cal)
Returns the value of the specified column as a java.sql.Date using a specified time zone. |
double |
getDouble(int parameterIndex)
Returns the value of the specified column as a double. |
double |
getDouble(java.lang.String parameterName)
Returns the value of the specified column as a double. |
float |
getFloat(int parameterIndex)
Returns the value of the specified column as a float. |
float |
getFloat(java.lang.String parameterName)
Returns the value of the specified column as a float. |
int |
getInt(int parameterIndex)
Returns the value of the specified column as an int. |
int |
getInt(java.lang.String parameterName)
Returns the value of the specified column as an int. |
long |
getLong(int parameterIndex)
Returns the value of the specified column as a long. |
long |
getLong(java.lang.String parameterName)
Returns the value of the specified column as a long. |
java.lang.Object |
getObject(int parameterIndex)
Returns a column value as a Java object. |
java.lang.Object |
getObject(int parameterIndex,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
[Not supported] Gets a column as a object using the specified type mapping. |
java.lang.Object |
getObject(java.lang.String parameterName)
Returns a column value as a Java object. |
java.lang.Object |
getObject(java.lang.String parameterName,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
[Not supported] Gets a column as a object using the specified type mapping. |
java.sql.Ref |
getRef(int parameterIndex)
[Not supported] Gets a column as a reference. |
java.sql.Ref |
getRef(java.lang.String parameterName)
[Not supported] Gets a column as a reference. |
short |
getShort(int parameterIndex)
Returns the value of the specified column as a short. |
short |
getShort(java.lang.String parameterName)
Returns the value of the specified column as a short. |
java.lang.String |
getString(int parameterIndex)
Returns the value of the specified column as a String. |
java.lang.String |
getString(java.lang.String parameterName)
Returns the value of the specified column as a String. |
java.sql.Time |
getTime(int parameterIndex)
Returns the value of the specified column as a java.sql.Time. |
java.sql.Time |
getTime(int parameterIndex,
java.util.Calendar cal)
Returns the value of the specified column as a java.sql.Time using a specified time zone. |
java.sql.Time |
getTime(java.lang.String parameterName)
Returns the value of the specified column as a java.sql.Time. |
java.sql.Time |
getTime(java.lang.String parameterName,
java.util.Calendar cal)
Returns the value of the specified column as a java.sql.Time using a specified time zone. |
java.sql.Timestamp |
getTimestamp(int parameterIndex)
Returns the value of the specified column as a java.sql.Timestamp. |
java.sql.Timestamp |
getTimestamp(int parameterIndex,
java.util.Calendar cal)
Returns the value of the specified column as a java.sql.Timestamp using a specified time zone. |
java.sql.Timestamp |
getTimestamp(java.lang.String parameterName)
Returns the value of the specified column as a java.sql.Timestamp. |
java.sql.Timestamp |
getTimestamp(java.lang.String parameterName,
java.util.Calendar cal)
Returns the value of the specified column as a java.sql.Timestamp using a specified time zone. |
java.net.URL |
getURL(int parameterIndex)
[Not supported] |
java.net.URL |
getURL(java.lang.String parameterName)
[Not supported] |
void |
registerOutParameter(int parameterIndex,
int sqlType)
Registers the given OUT parameter. |
void |
registerOutParameter(int parameterIndex,
int sqlType,
int scale)
Registers the given OUT parameter. |
void |
registerOutParameter(int parameterIndex,
int sqlType,
java.lang.String typeName)
Registers the given OUT parameter. |
void |
registerOutParameter(java.lang.String parameterName,
int sqlType)
Registers the given OUT parameter. |
void |
registerOutParameter(java.lang.String parameterName,
int sqlType,
int scale)
Registers the given OUT parameter. |
void |
registerOutParameter(java.lang.String parameterName,
int sqlType,
java.lang.String typeName)
Registers the given OUT parameter. |
void |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream x,
int length)
Sets the value of a parameter as an ASCII stream. |
void |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream x,
long length)
Sets the value of a parameter as an ASCII stream. |
void |
setBigDecimal(java.lang.String parameterName,
java.math.BigDecimal x)
Sets the value of a parameter. |
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream x,
int length)
Sets the value of a parameter as an input stream. |
void |
setBoolean(java.lang.String parameterName,
boolean x)
Sets the value of a parameter. |
void |
setByte(java.lang.String parameterName,
byte x)
Sets the value of a parameter. |
void |
setBytes(java.lang.String parameterName,
byte[] x)
Sets the value of a parameter as a byte array. |
void |
setCharacterStream(java.lang.String parameterName,
java.io.Reader x,
int length)
Sets the value of a parameter as a character stream. |
void |
setDate(java.lang.String parameterName,
java.sql.Date x)
Sets the value of a parameter. |
void |
setDate(java.lang.String parameterName,
java.sql.Date x,
java.util.Calendar cal)
Sets the date using a specified time zone. |
void |
setDouble(java.lang.String parameterName,
double x)
Sets the value of a parameter. |
void |
setFloat(java.lang.String parameterName,
float x)
Sets the value of a parameter. |
void |
setInt(java.lang.String parameterName,
int x)
Sets the value of a parameter. |
void |
setLong(java.lang.String parameterName,
long x)
Sets the value of a parameter. |
void |
setNull(java.lang.String parameterName,
int sqlType)
Sets a parameter to null. |
void |
setNull(java.lang.String parameterName,
int sqlType,
java.lang.String typeName)
Sets a parameter to null. |
void |
setObject(java.lang.String parameterName,
java.lang.Object x)
Sets the value of a parameter. |
void |
setObject(java.lang.String parameterName,
java.lang.Object x,
int targetSqlType)
Sets the value of a parameter. |
void |
setObject(java.lang.String parameterName,
java.lang.Object x,
int targetSqlType,
int scale)
Sets the value of a parameter. |
void |
setShort(java.lang.String parameterName,
short x)
Sets the value of a parameter. |
void |
setString(java.lang.String parameterName,
java.lang.String x)
Sets the value of a parameter. |
void |
setTime(java.lang.String parameterName,
java.sql.Time x)
Sets the time using a specified time zone. |
void |
setTime(java.lang.String parameterName,
java.sql.Time x,
java.util.Calendar cal)
Sets the time using a specified time zone. |
void |
setTimestamp(java.lang.String parameterName,
java.sql.Timestamp x)
Sets the value of a parameter. |
void |
setTimestamp(java.lang.String parameterName,
java.sql.Timestamp x,
java.util.Calendar cal)
Sets the timestamp using a specified time zone. |
void |
setURL(java.lang.String parameterName,
java.net.URL val)
[Not supported] |
boolean |
wasNull()
Returns whether the last column accessed was null. |
| Methods inherited from class org.h2.jdbc.JdbcPreparedStatement |
|---|
addBatch, addBatch, checkClosed, clearBatch, clearParameters, close, execute, execute, execute, execute, execute, executeBatch, executeQuery, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getMetaData, getParameterMetaData, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNull, setNull, setObject, setObject, setObject, setRef, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL, toString |
| Methods inherited from class org.h2.message.TraceObject |
|---|
debugCode, debugCodeAssign, debugCodeCall, debugCodeCall, debugCodeCall, getNextId, getTrace, getTraceId, getTraceObjectName, isDebugEnabled, isInfoEnabled, logAndConvert, quote, quoteArray, quoteBigDecimal, quoteBytes, quoteDate, quoteIntArray, quoteMap, quoteTime, quoteTimestamp, setTrace, unsupported |
| Methods inherited from class java.lang.Object |
|---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait |
| Methods inherited from interface java.sql.PreparedStatement |
|---|
addBatch, clearParameters, execute, executeQuery, 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 |
| Method Detail |
|---|
public int executeUpdate()
throws java.sql.SQLException
executeUpdate in interface java.sql.PreparedStatementexecuteUpdate in class JdbcPreparedStatementjava.sql.SQLException - if this object is closed or invalid
public void registerOutParameter(int parameterIndex,
int sqlType)
throws java.sql.SQLException
registerOutParameter in interface java.sql.CallableStatementparameterIndex - the parameter index (1, 2, ...)sqlType - the data type (Types.x) - ignored
java.sql.SQLException
public void registerOutParameter(int parameterIndex,
int sqlType,
java.lang.String typeName)
throws java.sql.SQLException
registerOutParameter in interface java.sql.CallableStatementparameterIndex - the parameter index (1, 2, ...)sqlType - the data type (Types.x) - ignoredtypeName - the SQL type name - ignored
java.sql.SQLException
public void registerOutParameter(int parameterIndex,
int sqlType,
int scale)
throws java.sql.SQLException
registerOutParameter in interface java.sql.CallableStatementparameterIndex - the parameter index (1, 2, ...)sqlType - the data type (Types.x)scale - is ignored
java.sql.SQLException
public void registerOutParameter(java.lang.String parameterName,
int sqlType,
java.lang.String typeName)
throws java.sql.SQLException
registerOutParameter in interface java.sql.CallableStatementparameterName - the parameter namesqlType - the data type (Types.x) - ignoredtypeName - the SQL type name - ignored
java.sql.SQLException
public void registerOutParameter(java.lang.String parameterName,
int sqlType,
int scale)
throws java.sql.SQLException
registerOutParameter in interface java.sql.CallableStatementparameterName - the parameter namesqlType - the data type (Types.x) - ignoredscale - is ignored
java.sql.SQLException
public void registerOutParameter(java.lang.String parameterName,
int sqlType)
throws java.sql.SQLException
registerOutParameter in interface java.sql.CallableStatementparameterName - the parameter namesqlType - the data type (Types.x) - ignored
java.sql.SQLException
public boolean wasNull()
throws java.sql.SQLException
wasNull in interface java.sql.CallableStatementjava.sql.SQLException
public java.net.URL getURL(int parameterIndex)
throws java.sql.SQLException
getURL in interface java.sql.CallableStatementjava.sql.SQLException
public java.lang.String getString(int parameterIndex)
throws java.sql.SQLException
getString in interface java.sql.CallableStatementparameterIndex - (1,2,...)
java.sql.SQLException - if the column is not found or if the result set is closed
public boolean getBoolean(int parameterIndex)
throws java.sql.SQLException
getBoolean in interface java.sql.CallableStatementparameterIndex - (1,2,...)
java.sql.SQLException - if the column is not found or if the result set is
closed
public byte getByte(int parameterIndex)
throws java.sql.SQLException
getByte in interface java.sql.CallableStatementparameterIndex - (1,2,...)
java.sql.SQLException - if the column is not found or if the result set is
closed
public short getShort(int parameterIndex)
throws java.sql.SQLException
getShort in interface java.sql.CallableStatementparameterIndex - (1,2,...)
java.sql.SQLException - if the column is not found or if the result set is
closed
public int getInt(int parameterIndex)
throws java.sql.SQLException
getInt in interface java.sql.CallableStatementparameterIndex - the parameter index (1, 2, ...)
java.sql.SQLException - if the column is not found or if the result set is closed
public long getLong(int parameterIndex)
throws java.sql.SQLException
getLong in interface java.sql.CallableStatementparameterIndex - the parameter index (1, 2, ...)
java.sql.SQLException - if the column is not found or if the result set is
closed
public float getFloat(int parameterIndex)
throws java.sql.SQLException
getFloat in interface java.sql.CallableStatementparameterIndex - the parameter index (1, 2, ...)
java.sql.SQLException - if the column is not found or if the result set is
closed
public double getDouble(int parameterIndex)
throws java.sql.SQLException
getDouble in interface java.sql.CallableStatementparameterIndex - the parameter index (1, 2, ...)
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.math.BigDecimal getBigDecimal(int parameterIndex,
int scale)
throws java.sql.SQLException
getBigDecimal(int)
getBigDecimal in interface java.sql.CallableStatementparameterIndex - the parameter index (1, 2, ...)scale - is ignored
java.sql.SQLException - if the column is not found or if the result set is
closed
public byte[] getBytes(int parameterIndex)
throws java.sql.SQLException
getBytes in interface java.sql.CallableStatementparameterIndex - the parameter index (1, 2, ...)
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.sql.Date getDate(int parameterIndex)
throws java.sql.SQLException
getDate in interface java.sql.CallableStatementparameterIndex - the parameter index (1, 2, ...)
java.sql.SQLException - if the column is not found or if the result set is closed
public java.sql.Time getTime(int parameterIndex)
throws java.sql.SQLException
getTime in interface java.sql.CallableStatementparameterIndex - the parameter index (1, 2, ...)
java.sql.SQLException - if the column is not found or if the result set is closed
public java.sql.Timestamp getTimestamp(int parameterIndex)
throws java.sql.SQLException
getTimestamp in interface java.sql.CallableStatementparameterIndex - the parameter index (1, 2, ...)
java.sql.SQLException - if the column is not found or if the result set is closed
public java.lang.Object getObject(int parameterIndex)
throws java.sql.SQLException
getObject in interface java.sql.CallableStatementparameterIndex - the parameter index (1, 2, ...)
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.math.BigDecimal getBigDecimal(int parameterIndex)
throws java.sql.SQLException
getBigDecimal in interface java.sql.CallableStatementparameterIndex - the parameter index (1, 2, ...)
java.sql.SQLException - if the column is not found or if the result set is closed
public java.lang.Object getObject(int parameterIndex,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
throws java.sql.SQLException
getObject in interface java.sql.CallableStatementjava.sql.SQLException
public java.sql.Ref getRef(int parameterIndex)
throws java.sql.SQLException
getRef in interface java.sql.CallableStatementjava.sql.SQLException
public java.sql.Blob getBlob(int parameterIndex)
throws java.sql.SQLException
getBlob in interface java.sql.CallableStatementparameterIndex - the parameter index (1, 2, ...)
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.sql.Clob getClob(int parameterIndex)
throws java.sql.SQLException
getClob in interface java.sql.CallableStatementparameterIndex - the parameter index (1, 2, ...)
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.sql.Array getArray(int parameterIndex)
throws java.sql.SQLException
getArray in interface java.sql.CallableStatementparameterIndex - the parameter index (1, 2, ...)
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.sql.Date getDate(int parameterIndex,
java.util.Calendar cal)
throws java.sql.SQLException
getDate in interface java.sql.CallableStatementparameterIndex - the parameter index (1, 2, ...)cal - the calendar
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.sql.Time getTime(int parameterIndex,
java.util.Calendar cal)
throws java.sql.SQLException
getTime in interface java.sql.CallableStatementparameterIndex - the parameter index (1, 2, ...)cal - the calendar
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.sql.Timestamp getTimestamp(int parameterIndex,
java.util.Calendar cal)
throws java.sql.SQLException
getTimestamp in interface java.sql.CallableStatementparameterIndex - the parameter index (1, 2, ...)cal - the calendar
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.net.URL getURL(java.lang.String parameterName)
throws java.sql.SQLException
getURL in interface java.sql.CallableStatementjava.sql.SQLException
public java.sql.Timestamp getTimestamp(java.lang.String parameterName,
java.util.Calendar cal)
throws java.sql.SQLException
getTimestamp in interface java.sql.CallableStatementparameterName - the parameter namecal - the calendar
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.sql.Time getTime(java.lang.String parameterName,
java.util.Calendar cal)
throws java.sql.SQLException
getTime in interface java.sql.CallableStatementparameterName - the parameter namecal - the calendar
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.sql.Date getDate(java.lang.String parameterName,
java.util.Calendar cal)
throws java.sql.SQLException
getDate in interface java.sql.CallableStatementparameterName - the parameter namecal - the calendar
java.sql.SQLException - if the column is not found or if the result set is closed
public java.sql.Array getArray(java.lang.String parameterName)
throws java.sql.SQLException
getArray in interface java.sql.CallableStatementparameterName - the parameter name
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.sql.Clob getClob(java.lang.String parameterName)
throws java.sql.SQLException
getClob in interface java.sql.CallableStatementparameterName - the parameter name
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.sql.Blob getBlob(java.lang.String parameterName)
throws java.sql.SQLException
getBlob in interface java.sql.CallableStatementparameterName - the parameter name
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.sql.Ref getRef(java.lang.String parameterName)
throws java.sql.SQLException
getRef in interface java.sql.CallableStatementjava.sql.SQLException
public java.lang.Object getObject(java.lang.String parameterName,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
throws java.sql.SQLException
getObject in interface java.sql.CallableStatementjava.sql.SQLException
public java.math.BigDecimal getBigDecimal(java.lang.String parameterName)
throws java.sql.SQLException
getBigDecimal in interface java.sql.CallableStatementparameterName - the parameter name
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.lang.Object getObject(java.lang.String parameterName)
throws java.sql.SQLException
getObject in interface java.sql.CallableStatementparameterName - the parameter name
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.sql.Timestamp getTimestamp(java.lang.String parameterName)
throws java.sql.SQLException
getTimestamp in interface java.sql.CallableStatementparameterName - the parameter name
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.sql.Time getTime(java.lang.String parameterName)
throws java.sql.SQLException
getTime in interface java.sql.CallableStatementparameterName - the parameter name
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.sql.Date getDate(java.lang.String parameterName)
throws java.sql.SQLException
getDate in interface java.sql.CallableStatementparameterName - the parameter name
java.sql.SQLException - if the column is not found or if the result set is closed
public byte[] getBytes(java.lang.String parameterName)
throws java.sql.SQLException
getBytes in interface java.sql.CallableStatementparameterName - the parameter name
java.sql.SQLException - if the column is not found or if the result set is
closed
public double getDouble(java.lang.String parameterName)
throws java.sql.SQLException
getDouble in interface java.sql.CallableStatementparameterName - the parameter name
java.sql.SQLException - if the column is not found or if the result set is
closed
public float getFloat(java.lang.String parameterName)
throws java.sql.SQLException
getFloat in interface java.sql.CallableStatementparameterName - the parameter name
java.sql.SQLException - if the column is not found or if the result set is
closed
public long getLong(java.lang.String parameterName)
throws java.sql.SQLException
getLong in interface java.sql.CallableStatementparameterName - the parameter name
java.sql.SQLException - if the column is not found or if the result set is
closed
public int getInt(java.lang.String parameterName)
throws java.sql.SQLException
getInt in interface java.sql.CallableStatementparameterName - the parameter name
java.sql.SQLException - if the column is not found or if the result set is closed
public short getShort(java.lang.String parameterName)
throws java.sql.SQLException
getShort in interface java.sql.CallableStatementparameterName - the parameter name
java.sql.SQLException - if the column is not found or if the result set is
closed
public byte getByte(java.lang.String parameterName)
throws java.sql.SQLException
getByte in interface java.sql.CallableStatementparameterName - the parameter name
java.sql.SQLException - if the column is not found or if the result set is
closed
public boolean getBoolean(java.lang.String parameterName)
throws java.sql.SQLException
getBoolean in interface java.sql.CallableStatementparameterName - the parameter name
java.sql.SQLException - if the column is not found or if the result set is
closed
public java.lang.String getString(java.lang.String parameterName)
throws java.sql.SQLException
getString in interface java.sql.CallableStatementparameterName - the parameter name
java.sql.SQLException - if the column is not found or if the result set is closed
public void setNull(java.lang.String parameterName,
int sqlType,
java.lang.String typeName)
throws java.sql.SQLException
setNull in interface java.sql.CallableStatementparameterName - the parameter namesqlType - the data type (Types.x)typeName - this parameter is ignored
java.sql.SQLException - if this object is closed
public void setNull(java.lang.String parameterName,
int sqlType)
throws java.sql.SQLException
setNull in interface java.sql.CallableStatementparameterName - the parameter namesqlType - the data type (Types.x)
java.sql.SQLException - if this object is closed
public void setTimestamp(java.lang.String parameterName,
java.sql.Timestamp x,
java.util.Calendar cal)
throws java.sql.SQLException
setTimestamp in interface java.sql.CallableStatementparameterName - the parameter namex - the valuecal - the calendar
java.sql.SQLException - if this object is closed
public void setTime(java.lang.String parameterName,
java.sql.Time x,
java.util.Calendar cal)
throws java.sql.SQLException
setTime in interface java.sql.CallableStatementparameterName - the parameter namex - the valuecal - the calendar
java.sql.SQLException - if this object is closed
public void setDate(java.lang.String parameterName,
java.sql.Date x,
java.util.Calendar cal)
throws java.sql.SQLException
setDate in interface java.sql.CallableStatementparameterName - the parameter namex - the valuecal - the calendar
java.sql.SQLException - if this object is closed
public void setCharacterStream(java.lang.String parameterName,
java.io.Reader x,
int length)
throws java.sql.SQLException
setCharacterStream in interface java.sql.CallableStatementparameterName - the parameter namex - the valuelength - the maximum number of characters
java.sql.SQLException - if this object is closed
public void setObject(java.lang.String parameterName,
java.lang.Object x)
throws java.sql.SQLException
setObject in interface java.sql.CallableStatementparameterName - the parameter namex - the value
java.sql.SQLException - if this object is closed
public void setObject(java.lang.String parameterName,
java.lang.Object x,
int targetSqlType)
throws java.sql.SQLException
setObject in interface java.sql.CallableStatementparameterName - the parameter namex - the value, null is allowedtargetSqlType - the type as defined in java.sql.Types
java.sql.SQLException - if this object is closed
public void setObject(java.lang.String parameterName,
java.lang.Object x,
int targetSqlType,
int scale)
throws java.sql.SQLException
setObject in interface java.sql.CallableStatementparameterName - the parameter namex - the value, null is allowedtargetSqlType - the type as defined in java.sql.Typesscale - is ignored
java.sql.SQLException - if this object is closed
public void setBinaryStream(java.lang.String parameterName,
java.io.InputStream x,
int length)
throws java.sql.SQLException
setBinaryStream in interface java.sql.CallableStatementparameterName - the parameter namex - the valuelength - the maximum number of bytes
java.sql.SQLException - if this object is closed
public void setAsciiStream(java.lang.String parameterName,
java.io.InputStream x,
long length)
throws java.sql.SQLException
parameterName - the parameter namex - the valuelength - the maximum number of bytes
java.sql.SQLException - if this object is closed
public void setTimestamp(java.lang.String parameterName,
java.sql.Timestamp x)
throws java.sql.SQLException
setTimestamp in interface java.sql.CallableStatementparameterName - the parameter namex - the value
java.sql.SQLException - if this object is closed
public void setTime(java.lang.String parameterName,
java.sql.Time x)
throws java.sql.SQLException
setTime in interface java.sql.CallableStatementparameterName - the parameter namex - the value
java.sql.SQLException - if this object is closed
public void setDate(java.lang.String parameterName,
java.sql.Date x)
throws java.sql.SQLException
setDate in interface java.sql.CallableStatementparameterName - the parameter namex - the value
java.sql.SQLException - if this object is closed
public void setBytes(java.lang.String parameterName,
byte[] x)
throws java.sql.SQLException
setBytes in interface java.sql.CallableStatementparameterName - the parameter namex - the value
java.sql.SQLException - if this object is closed
public void setString(java.lang.String parameterName,
java.lang.String x)
throws java.sql.SQLException
setString in interface java.sql.CallableStatementparameterName - the parameter namex - the value
java.sql.SQLException - if this object is closed
public void setBigDecimal(java.lang.String parameterName,
java.math.BigDecimal x)
throws java.sql.SQLException
setBigDecimal in interface java.sql.CallableStatementparameterName - the parameter namex - the value
java.sql.SQLException - if this object is closed
public void setDouble(java.lang.String parameterName,
double x)
throws java.sql.SQLException
setDouble in interface java.sql.CallableStatementparameterName - the parameter namex - the value
java.sql.SQLException - if this object is closed
public void setFloat(java.lang.String parameterName,
float x)
throws java.sql.SQLException
setFloat in interface java.sql.CallableStatementparameterName - the parameter namex - the value
java.sql.SQLException - if this object is closed
public void setLong(java.lang.String parameterName,
long x)
throws java.sql.SQLException
setLong in interface java.sql.CallableStatementparameterName - the parameter namex - the value
java.sql.SQLException - if this object is closed
public void setInt(java.lang.String parameterName,
int x)
throws java.sql.SQLException
setInt in interface java.sql.CallableStatementparameterName - the parameter namex - the value
java.sql.SQLException - if this object is closed
public void setShort(java.lang.String parameterName,
short x)
throws java.sql.SQLException
setShort in interface java.sql.CallableStatementparameterName - the parameter namex - the value
java.sql.SQLException - if this object is closed
public void setByte(java.lang.String parameterName,
byte x)
throws java.sql.SQLException
setByte in interface java.sql.CallableStatementparameterName - the parameter namex - the value
java.sql.SQLException - if this object is closed
public void setBoolean(java.lang.String parameterName,
boolean x)
throws java.sql.SQLException
setBoolean in interface java.sql.CallableStatementparameterName - the parameter namex - the value
java.sql.SQLException - if this object is closed
public void setURL(java.lang.String parameterName,
java.net.URL val)
throws java.sql.SQLException
setURL in interface java.sql.CallableStatementjava.sql.SQLException
public void setAsciiStream(java.lang.String parameterName,
java.io.InputStream x,
int length)
throws java.sql.SQLException
setAsciiStream in interface java.sql.CallableStatementparameterName - the parameter namex - the valuelength - the maximum number of bytes
java.sql.SQLException - if this object is closed
|
||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||