public class JdbcCallableStatement extends JdbcPreparedStatement implements CallableStatement, JdbcCallableStatementBackwardsCompat
command
closedByResultSet, conn, fetchSize, generatedKeys, maxRows, resultSet, resultSetConcurrency, resultSetType, session, updateCount
ARRAY, BLOB, CALLABLE_STATEMENT, CLOB, CONNECTION, DATA_SOURCE, DATABASE_META_DATA, PARAMETER_META_DATA, PREPARED_STATEMENT, RESULT_SET, RESULT_SET_META_DATA, SAVEPOINT, STATEMENT, trace, XA_DATA_SOURCE, XID
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO
Modifier and Type | Method and Description |
---|---|
long |
executeLargeUpdate()
Executes a statement (insert, update, delete, create, drop)
and returns the update count.
|
int |
executeUpdate()
Executes a statement (insert, update, delete, create, drop)
and returns the update count.
|
Array |
getArray(int parameterIndex)
Returns the value of the specified column as an Array.
|
Array |
getArray(String parameterName)
Returns the value of the specified column as an Array.
|
BigDecimal |
getBigDecimal(int parameterIndex)
Returns the value of the specified column as a BigDecimal.
|
BigDecimal |
getBigDecimal(int parameterIndex,
int scale)
Deprecated.
|
BigDecimal |
getBigDecimal(String parameterName)
Returns the value of the specified column as a BigDecimal.
|
Blob |
getBlob(int parameterIndex)
Returns the value of the specified column as a Blob.
|
Blob |
getBlob(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(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(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(String parameterName)
Returns the value of the specified column as a byte array.
|
Reader |
getCharacterStream(int parameterIndex)
Returns the value of the specified column as a reader.
|
Reader |
getCharacterStream(String parameterName)
Returns the value of the specified column as a reader.
|
Clob |
getClob(int parameterIndex)
Returns the value of the specified column as a Clob.
|
Clob |
getClob(String parameterName)
Returns the value of the specified column as a Clob.
|
Date |
getDate(int parameterIndex)
Returns the value of the specified column as a java.sql.Date.
|
Date |
getDate(int parameterIndex,
Calendar cal)
Returns the value of the specified column as a java.sql.Date using a
specified time zone.
|
Date |
getDate(String parameterName)
Returns the value of the specified column as a java.sql.Date.
|
Date |
getDate(String parameterName,
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(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(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(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(String parameterName)
Returns the value of the specified column as a long.
|
Reader |
getNCharacterStream(int parameterIndex)
Returns the value of the specified column as a reader.
|
Reader |
getNCharacterStream(String parameterName)
Returns the value of the specified column as a reader.
|
NClob |
getNClob(int parameterIndex)
Returns the value of the specified column as a Clob.
|
NClob |
getNClob(String parameterName)
Returns the value of the specified column as a Clob.
|
String |
getNString(int parameterIndex)
Returns the value of the specified column as a String.
|
String |
getNString(String parameterName)
Returns the value of the specified column as a String.
|
Object |
getObject(int parameterIndex)
Returns a column value as a Java object.
|
<T> T |
getObject(int parameterIndex,
Class<T> type)
[Not supported]
|
Object |
getObject(int parameterIndex,
Map<String,Class<?>> map)
[Not supported] Gets a column as a object using the specified type
mapping.
|
Object |
getObject(String parameterName)
Returns a column value as a Java object.
|
<T> T |
getObject(String parameterName,
Class<T> type)
[Not supported]
|
Object |
getObject(String parameterName,
Map<String,Class<?>> map)
[Not supported] Gets a column as a object using the specified type
mapping.
|
Ref |
getRef(int parameterIndex)
[Not supported] Gets a column as a reference.
|
Ref |
getRef(String parameterName)
[Not supported] Gets a column as a reference.
|
RowId |
getRowId(int parameterIndex)
[Not supported] Returns the value of the specified column as a row id.
|
RowId |
getRowId(String parameterName)
[Not supported] Returns the value of the specified column as a row id.
|
short |
getShort(int parameterIndex)
Returns the value of the specified column as a short.
|
short |
getShort(String parameterName)
Returns the value of the specified column as a short.
|
SQLXML |
getSQLXML(int parameterIndex)
[Not supported] Returns the value of the specified column as a SQLXML
object.
|
SQLXML |
getSQLXML(String parameterName)
[Not supported] Returns the value of the specified column as a SQLXML
object.
|
String |
getString(int parameterIndex)
Returns the value of the specified column as a String.
|
String |
getString(String parameterName)
Returns the value of the specified column as a String.
|
Time |
getTime(int parameterIndex)
Returns the value of the specified column as a java.sql.Time.
|
Time |
getTime(int parameterIndex,
Calendar cal)
Returns the value of the specified column as a java.sql.Time using a
specified time zone.
|
Time |
getTime(String parameterName)
Returns the value of the specified column as a java.sql.Time.
|
Time |
getTime(String parameterName,
Calendar cal)
Returns the value of the specified column as a java.sql.Time using a
specified time zone.
|
Timestamp |
getTimestamp(int parameterIndex)
Returns the value of the specified column as a java.sql.Timestamp.
|
Timestamp |
getTimestamp(int parameterIndex,
Calendar cal)
Returns the value of the specified column as a java.sql.Timestamp using a
specified time zone.
|
Timestamp |
getTimestamp(String parameterName)
Returns the value of the specified column as a java.sql.Timestamp.
|
Timestamp |
getTimestamp(String parameterName,
Calendar cal)
Returns the value of the specified column as a java.sql.Timestamp using a
specified time zone.
|
URL |
getURL(int parameterIndex)
[Not supported]
|
URL |
getURL(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,
String typeName)
Registers the given OUT parameter.
|
void |
registerOutParameter(String parameterName,
int sqlType)
Registers the given OUT parameter.
|
void |
registerOutParameter(String parameterName,
int sqlType,
int scale)
Registers the given OUT parameter.
|
void |
registerOutParameter(String parameterName,
int sqlType,
String typeName)
Registers the given OUT parameter.
|
void |
setAsciiStream(String parameterName,
InputStream x)
Sets the value of a parameter as an ASCII stream.
|
void |
setAsciiStream(String parameterName,
InputStream x,
int length)
Sets the value of a parameter as an ASCII stream.
|
void |
setAsciiStream(String parameterName,
InputStream x,
long length)
Sets the value of a parameter as an ASCII stream.
|
void |
setBigDecimal(String parameterName,
BigDecimal x)
Sets the value of a parameter.
|
void |
setBinaryStream(String parameterName,
InputStream x)
Sets the value of a parameter as an input stream.
|
void |
setBinaryStream(String parameterName,
InputStream x,
int length)
Sets the value of a parameter as an input stream.
|
void |
setBinaryStream(String parameterName,
InputStream x,
long length)
Sets the value of a parameter as an input stream.
|
void |
setBlob(String parameterName,
Blob x)
Sets the value of a parameter as a Blob.
|
void |
setBlob(String parameterName,
InputStream x)
Sets the value of a parameter as a Blob.
|
void |
setBlob(String parameterName,
InputStream x,
long length)
Sets the value of a parameter as a Blob.
|
void |
setBoolean(String parameterName,
boolean x)
Sets the value of a parameter.
|
void |
setByte(String parameterName,
byte x)
Sets the value of a parameter.
|
void |
setBytes(String parameterName,
byte[] x)
Sets the value of a parameter as a byte array.
|
void |
setCharacterStream(String parameterName,
Reader x)
Sets the value of a parameter as a character stream.
|
void |
setCharacterStream(String parameterName,
Reader x,
int length)
Sets the value of a parameter as a character stream.
|
void |
setCharacterStream(String parameterName,
Reader x,
long length)
Sets the value of a parameter as a character stream.
|
void |
setClob(String parameterName,
Clob x)
Sets the value of a parameter as a Clob.
|
void |
setClob(String parameterName,
Reader x)
Sets the value of a parameter as a character stream.
|
void |
setClob(String parameterName,
Reader x,
long length)
Sets the value of a parameter as a Clob.
|
void |
setDate(String parameterName,
Date x)
Sets the value of a parameter.
|
void |
setDate(String parameterName,
Date x,
Calendar cal)
Sets the date using a specified time zone.
|
void |
setDouble(String parameterName,
double x)
Sets the value of a parameter.
|
void |
setFloat(String parameterName,
float x)
Sets the value of a parameter.
|
void |
setInt(String parameterName,
int x)
Sets the value of a parameter.
|
void |
setLong(String parameterName,
long x)
Sets the value of a parameter.
|
void |
setNCharacterStream(String parameterName,
Reader x)
Sets the value of a parameter as a character stream.
|
void |
setNCharacterStream(String parameterName,
Reader x,
long length)
Sets the value of a parameter as a character stream.
|
void |
setNClob(String parameterName,
NClob x)
Sets the value of a parameter as a Clob.
|
void |
setNClob(String parameterName,
Reader x)
Sets the value of a parameter as a Clob.
|
void |
setNClob(String parameterName,
Reader x,
long length)
Sets the value of a parameter as a Clob.
|
void |
setNString(String parameterName,
String x)
Sets the value of a parameter.
|
void |
setNull(String parameterName,
int sqlType)
Sets a parameter to null.
|
void |
setNull(String parameterName,
int sqlType,
String typeName)
Sets a parameter to null.
|
void |
setObject(String parameterName,
Object x)
Sets the value of a parameter.
|
void |
setObject(String parameterName,
Object x,
int targetSqlType)
Sets the value of a parameter.
|
void |
setObject(String parameterName,
Object x,
int targetSqlType,
int scale)
Sets the value of a parameter.
|
void |
setRowId(String parameterName,
RowId x)
[Not supported] Sets the value of a parameter as a row id.
|
void |
setShort(String parameterName,
short x)
Sets the value of a parameter.
|
void |
setSQLXML(String parameterName,
SQLXML x)
[Not supported] Sets the value of a parameter as a SQLXML object.
|
void |
setString(String parameterName,
String x)
Sets the value of a parameter.
|
void |
setTime(String parameterName,
Time x)
Sets the time using a specified time zone.
|
void |
setTime(String parameterName,
Time x,
Calendar cal)
Sets the time using a specified time zone.
|
void |
setTimestamp(String parameterName,
Timestamp x)
Sets the value of a parameter.
|
void |
setTimestamp(String parameterName,
Timestamp x,
Calendar cal)
Sets the timestamp using a specified time zone.
|
void |
setURL(String parameterName,
URL val)
[Not supported]
|
boolean |
wasNull()
Returns whether the last column accessed was null.
|
addBatch, addBatch, checkClosed, clearBatch, clearParameters, close, execute, execute, execute, execute, execute, executeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeQuery, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getGeneratedKeys, 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, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setNull, setNull, setObject, setObject, setObject, setRef, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL, toString
cancel, clearWarnings, closeOldResultSet, closeOnCompletion, enquoteIdentifier, executeLargeBatch, getConnection, getFetchDirection, getFetchSize, getLargeMaxRows, getLargeUpdateCount, getLastExecutedCommandType, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isCancelled, isClosed, isCloseOnCompletion, isPoolable, isSimpleIdentifier, isWrapperFor, setCursorName, setEscapeProcessing, setExecutingStatement, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, unwrap
debugCode, debugCodeAssign, debugCodeCall, debugCodeCall, debugCodeCall, getNextId, getTraceId, getTraceObjectName, isDebugEnabled, isInfoEnabled, logAndConvert, quote, quoteArray, quoteBigDecimal, quoteBytes, quoteDate, quoteIntArray, quoteMap, quoteTime, quoteTimestamp, setTrace, unsupported
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, setObject, setObject
addBatch, clearParameters, execute, executeQuery, 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, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setNull, setNull, setObject, setObject, setObject, setObject, setObject, setRef, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL
addBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, execute, execute, execute, execute, executeBatch, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout
isWrapperFor, unwrap
public int executeUpdate() throws SQLException
executeUpdate
in interface PreparedStatement
executeUpdate
in class JdbcPreparedStatement
SQLException
- if this object is closed or invalidpublic long executeLargeUpdate() throws SQLException
executeLargeUpdate
in interface PreparedStatement
executeLargeUpdate
in interface JdbcPreparedStatementBackwardsCompat
executeLargeUpdate
in class JdbcPreparedStatement
SQLException
- if this object is closed or invalidpublic void registerOutParameter(int parameterIndex, int sqlType) throws SQLException
registerOutParameter
in interface CallableStatement
parameterIndex
- the parameter index (1, 2, ...)sqlType
- the data type (Types.x) - ignoredSQLException
public void registerOutParameter(int parameterIndex, int sqlType, String typeName) throws SQLException
registerOutParameter
in interface CallableStatement
parameterIndex
- the parameter index (1, 2, ...)sqlType
- the data type (Types.x) - ignoredtypeName
- the SQL type name - ignoredSQLException
public void registerOutParameter(int parameterIndex, int sqlType, int scale) throws SQLException
registerOutParameter
in interface CallableStatement
parameterIndex
- the parameter index (1, 2, ...)sqlType
- the data type (Types.x)scale
- is ignoredSQLException
public void registerOutParameter(String parameterName, int sqlType, String typeName) throws SQLException
registerOutParameter
in interface CallableStatement
parameterName
- the parameter namesqlType
- the data type (Types.x) - ignoredtypeName
- the SQL type name - ignoredSQLException
public void registerOutParameter(String parameterName, int sqlType, int scale) throws SQLException
registerOutParameter
in interface CallableStatement
parameterName
- the parameter namesqlType
- the data type (Types.x) - ignoredscale
- is ignoredSQLException
public void registerOutParameter(String parameterName, int sqlType) throws SQLException
registerOutParameter
in interface CallableStatement
parameterName
- the parameter namesqlType
- the data type (Types.x) - ignoredSQLException
public boolean wasNull() throws SQLException
wasNull
in interface CallableStatement
SQLException
public URL getURL(int parameterIndex) throws SQLException
getURL
in interface CallableStatement
SQLException
public String getString(int parameterIndex) throws SQLException
getString
in interface CallableStatement
parameterIndex
- (1,2,...)SQLException
- if the column is not found or if this object is
closedpublic boolean getBoolean(int parameterIndex) throws SQLException
getBoolean
in interface CallableStatement
parameterIndex
- (1,2,...)SQLException
- if the column is not found or if this object is
closedpublic byte getByte(int parameterIndex) throws SQLException
getByte
in interface CallableStatement
parameterIndex
- (1,2,...)SQLException
- if the column is not found or if this object is
closedpublic short getShort(int parameterIndex) throws SQLException
getShort
in interface CallableStatement
parameterIndex
- (1,2,...)SQLException
- if the column is not found or if this object is
closedpublic int getInt(int parameterIndex) throws SQLException
getInt
in interface CallableStatement
parameterIndex
- the parameter index (1, 2, ...)SQLException
- if the column is not found or if this object is
closedpublic long getLong(int parameterIndex) throws SQLException
getLong
in interface CallableStatement
parameterIndex
- the parameter index (1, 2, ...)SQLException
- if the column is not found or if this object is
closedpublic float getFloat(int parameterIndex) throws SQLException
getFloat
in interface CallableStatement
parameterIndex
- the parameter index (1, 2, ...)SQLException
- if the column is not found or if this object is
closedpublic double getDouble(int parameterIndex) throws SQLException
getDouble
in interface CallableStatement
parameterIndex
- the parameter index (1, 2, ...)SQLException
- if the column is not found or if this object is
closed@Deprecated public BigDecimal getBigDecimal(int parameterIndex, int scale) throws SQLException
getBigDecimal(int)
getBigDecimal
in interface CallableStatement
parameterIndex
- the parameter index (1, 2, ...)scale
- is ignoredSQLException
- if the column is not found or if this object is
closedpublic byte[] getBytes(int parameterIndex) throws SQLException
getBytes
in interface CallableStatement
parameterIndex
- the parameter index (1, 2, ...)SQLException
- if the column is not found or if this object is
closedpublic Date getDate(int parameterIndex) throws SQLException
getDate
in interface CallableStatement
parameterIndex
- the parameter index (1, 2, ...)SQLException
- if the column is not found or if this object is
closedpublic Time getTime(int parameterIndex) throws SQLException
getTime
in interface CallableStatement
parameterIndex
- the parameter index (1, 2, ...)SQLException
- if the column is not found or if this object is
closedpublic Timestamp getTimestamp(int parameterIndex) throws SQLException
getTimestamp
in interface CallableStatement
parameterIndex
- the parameter index (1, 2, ...)SQLException
- if the column is not found or if this object is
closedpublic Object getObject(int parameterIndex) throws SQLException
getObject
in interface CallableStatement
parameterIndex
- the parameter index (1, 2, ...)SQLException
- if the column is not found or if this object is
closedpublic BigDecimal getBigDecimal(int parameterIndex) throws SQLException
getBigDecimal
in interface CallableStatement
parameterIndex
- the parameter index (1, 2, ...)SQLException
- if the column is not found or if this object is
closedpublic Object getObject(int parameterIndex, Map<String,Class<?>> map) throws SQLException
getObject
in interface CallableStatement
SQLException
public Ref getRef(int parameterIndex) throws SQLException
getRef
in interface CallableStatement
SQLException
public Blob getBlob(int parameterIndex) throws SQLException
getBlob
in interface CallableStatement
parameterIndex
- the parameter index (1, 2, ...)SQLException
- if the column is not found or if this object is
closedpublic Clob getClob(int parameterIndex) throws SQLException
getClob
in interface CallableStatement
parameterIndex
- the parameter index (1, 2, ...)SQLException
- if the column is not found or if this object is
closedpublic Array getArray(int parameterIndex) throws SQLException
getArray
in interface CallableStatement
parameterIndex
- the parameter index (1, 2, ...)SQLException
- if the column is not found or if this object is
closedpublic Date getDate(int parameterIndex, Calendar cal) throws SQLException
getDate
in interface CallableStatement
parameterIndex
- the parameter index (1, 2, ...)cal
- the calendarSQLException
- if the column is not found or if this object is
closedpublic Time getTime(int parameterIndex, Calendar cal) throws SQLException
getTime
in interface CallableStatement
parameterIndex
- the parameter index (1, 2, ...)cal
- the calendarSQLException
- if the column is not found or if this object is
closedpublic Timestamp getTimestamp(int parameterIndex, Calendar cal) throws SQLException
getTimestamp
in interface CallableStatement
parameterIndex
- the parameter index (1, 2, ...)cal
- the calendarSQLException
- if the column is not found or if this object is
closedpublic URL getURL(String parameterName) throws SQLException
getURL
in interface CallableStatement
SQLException
public Timestamp getTimestamp(String parameterName, Calendar cal) throws SQLException
getTimestamp
in interface CallableStatement
parameterName
- the parameter namecal
- the calendarSQLException
- if the column is not found or if this object is
closedpublic Time getTime(String parameterName, Calendar cal) throws SQLException
getTime
in interface CallableStatement
parameterName
- the parameter namecal
- the calendarSQLException
- if the column is not found or if this object is
closedpublic Date getDate(String parameterName, Calendar cal) throws SQLException
getDate
in interface CallableStatement
parameterName
- the parameter namecal
- the calendarSQLException
- if the column is not found or if this object is
closedpublic Array getArray(String parameterName) throws SQLException
getArray
in interface CallableStatement
parameterName
- the parameter nameSQLException
- if the column is not found or if this object is
closedpublic Clob getClob(String parameterName) throws SQLException
getClob
in interface CallableStatement
parameterName
- the parameter nameSQLException
- if the column is not found or if this object is
closedpublic Blob getBlob(String parameterName) throws SQLException
getBlob
in interface CallableStatement
parameterName
- the parameter nameSQLException
- if the column is not found or if this object is
closedpublic Ref getRef(String parameterName) throws SQLException
getRef
in interface CallableStatement
SQLException
public Object getObject(String parameterName, Map<String,Class<?>> map) throws SQLException
getObject
in interface CallableStatement
SQLException
public BigDecimal getBigDecimal(String parameterName) throws SQLException
getBigDecimal
in interface CallableStatement
parameterName
- the parameter nameSQLException
- if the column is not found or if this object is
closedpublic Object getObject(String parameterName) throws SQLException
getObject
in interface CallableStatement
parameterName
- the parameter nameSQLException
- if the column is not found or if this object is
closedpublic Timestamp getTimestamp(String parameterName) throws SQLException
getTimestamp
in interface CallableStatement
parameterName
- the parameter nameSQLException
- if the column is not found or if this object is
closedpublic Time getTime(String parameterName) throws SQLException
getTime
in interface CallableStatement
parameterName
- the parameter nameSQLException
- if the column is not found or if this object is
closedpublic Date getDate(String parameterName) throws SQLException
getDate
in interface CallableStatement
parameterName
- the parameter nameSQLException
- if the column is not found or if this object is
closedpublic byte[] getBytes(String parameterName) throws SQLException
getBytes
in interface CallableStatement
parameterName
- the parameter nameSQLException
- if the column is not found or if this object is
closedpublic double getDouble(String parameterName) throws SQLException
getDouble
in interface CallableStatement
parameterName
- the parameter nameSQLException
- if the column is not found or if this object is
closedpublic float getFloat(String parameterName) throws SQLException
getFloat
in interface CallableStatement
parameterName
- the parameter nameSQLException
- if the column is not found or if this object is
closedpublic long getLong(String parameterName) throws SQLException
getLong
in interface CallableStatement
parameterName
- the parameter nameSQLException
- if the column is not found or if this object is
closedpublic int getInt(String parameterName) throws SQLException
getInt
in interface CallableStatement
parameterName
- the parameter nameSQLException
- if the column is not found or if this object is
closedpublic short getShort(String parameterName) throws SQLException
getShort
in interface CallableStatement
parameterName
- the parameter nameSQLException
- if the column is not found or if this object is
closedpublic byte getByte(String parameterName) throws SQLException
getByte
in interface CallableStatement
parameterName
- the parameter nameSQLException
- if the column is not found or if this object is
closedpublic boolean getBoolean(String parameterName) throws SQLException
getBoolean
in interface CallableStatement
parameterName
- the parameter nameSQLException
- if the column is not found or if this object is
closedpublic String getString(String parameterName) throws SQLException
getString
in interface CallableStatement
parameterName
- the parameter nameSQLException
- if the column is not found or if this object is
closedpublic RowId getRowId(int parameterIndex) throws SQLException
getRowId
in interface CallableStatement
parameterIndex
- the parameter index (1, 2, ...)SQLException
public RowId getRowId(String parameterName) throws SQLException
getRowId
in interface CallableStatement
parameterName
- the parameter nameSQLException
public NClob getNClob(int parameterIndex) throws SQLException
getNClob
in interface CallableStatement
parameterIndex
- the parameter index (1, 2, ...)SQLException
- if the column is not found or if this object is
closedpublic NClob getNClob(String parameterName) throws SQLException
getNClob
in interface CallableStatement
parameterName
- the parameter nameSQLException
- if the column is not found or if this object is
closedpublic SQLXML getSQLXML(int parameterIndex) throws SQLException
getSQLXML
in interface CallableStatement
SQLException
public SQLXML getSQLXML(String parameterName) throws SQLException
getSQLXML
in interface CallableStatement
SQLException
public String getNString(int parameterIndex) throws SQLException
getNString
in interface CallableStatement
parameterIndex
- the parameter index (1, 2, ...)SQLException
- if the column is not found or if this object is
closedpublic String getNString(String parameterName) throws SQLException
getNString
in interface CallableStatement
parameterName
- the parameter nameSQLException
- if the column is not found or if this object is
closedpublic Reader getNCharacterStream(int parameterIndex) throws SQLException
getNCharacterStream
in interface CallableStatement
parameterIndex
- the parameter index (1, 2, ...)SQLException
- if the column is not found or if this object is
closedpublic Reader getNCharacterStream(String parameterName) throws SQLException
getNCharacterStream
in interface CallableStatement
parameterName
- the parameter nameSQLException
- if the column is not found or if this object is
closedpublic Reader getCharacterStream(int parameterIndex) throws SQLException
getCharacterStream
in interface CallableStatement
parameterIndex
- the parameter index (1, 2, ...)SQLException
- if the column is not found or if this object is
closedpublic Reader getCharacterStream(String parameterName) throws SQLException
getCharacterStream
in interface CallableStatement
parameterName
- the parameter nameSQLException
- if the column is not found or if this object is
closedpublic void setNull(String parameterName, int sqlType, String typeName) throws SQLException
setNull
in interface CallableStatement
parameterName
- the parameter namesqlType
- the data type (Types.x)typeName
- this parameter is ignoredSQLException
- if this object is closedpublic void setNull(String parameterName, int sqlType) throws SQLException
setNull
in interface CallableStatement
parameterName
- the parameter namesqlType
- the data type (Types.x)SQLException
- if this object is closedpublic void setTimestamp(String parameterName, Timestamp x, Calendar cal) throws SQLException
setTimestamp
in interface CallableStatement
parameterName
- the parameter namex
- the valuecal
- the calendarSQLException
- if this object is closedpublic void setTime(String parameterName, Time x, Calendar cal) throws SQLException
setTime
in interface CallableStatement
parameterName
- the parameter namex
- the valuecal
- the calendarSQLException
- if this object is closedpublic void setDate(String parameterName, Date x, Calendar cal) throws SQLException
setDate
in interface CallableStatement
parameterName
- the parameter namex
- the valuecal
- the calendarSQLException
- if this object is closedpublic void setCharacterStream(String parameterName, Reader x, int length) throws SQLException
setCharacterStream
in interface CallableStatement
parameterName
- the parameter namex
- the valuelength
- the maximum number of charactersSQLException
- if this object is closedpublic void setObject(String parameterName, Object x) throws SQLException
setObject
in interface CallableStatement
parameterName
- the parameter namex
- the valueSQLException
- if this object is closedpublic void setObject(String parameterName, Object x, int targetSqlType) throws SQLException
setObject
in interface CallableStatement
parameterName
- the parameter namex
- the value, null is allowedtargetSqlType
- the type as defined in java.sql.TypesSQLException
- if this object is closedpublic void setObject(String parameterName, Object x, int targetSqlType, int scale) throws SQLException
setObject
in interface CallableStatement
parameterName
- the parameter namex
- the value, null is allowedtargetSqlType
- the type as defined in java.sql.Typesscale
- is ignoredSQLException
- if this object is closedpublic void setBinaryStream(String parameterName, InputStream x, int length) throws SQLException
setBinaryStream
in interface CallableStatement
parameterName
- the parameter namex
- the valuelength
- the maximum number of bytesSQLException
- if this object is closedpublic void setAsciiStream(String parameterName, InputStream x, long length) throws SQLException
setAsciiStream
in interface CallableStatement
parameterName
- the parameter namex
- the valuelength
- the maximum number of bytesSQLException
- if this object is closedpublic void setTimestamp(String parameterName, Timestamp x) throws SQLException
setTimestamp
in interface CallableStatement
parameterName
- the parameter namex
- the valueSQLException
- if this object is closedpublic void setTime(String parameterName, Time x) throws SQLException
setTime
in interface CallableStatement
parameterName
- the parameter namex
- the valueSQLException
- if this object is closedpublic void setDate(String parameterName, Date x) throws SQLException
setDate
in interface CallableStatement
parameterName
- the parameter namex
- the valueSQLException
- if this object is closedpublic void setBytes(String parameterName, byte[] x) throws SQLException
setBytes
in interface CallableStatement
parameterName
- the parameter namex
- the valueSQLException
- if this object is closedpublic void setString(String parameterName, String x) throws SQLException
setString
in interface CallableStatement
parameterName
- the parameter namex
- the valueSQLException
- if this object is closedpublic void setBigDecimal(String parameterName, BigDecimal x) throws SQLException
setBigDecimal
in interface CallableStatement
parameterName
- the parameter namex
- the valueSQLException
- if this object is closedpublic void setDouble(String parameterName, double x) throws SQLException
setDouble
in interface CallableStatement
parameterName
- the parameter namex
- the valueSQLException
- if this object is closedpublic void setFloat(String parameterName, float x) throws SQLException
setFloat
in interface CallableStatement
parameterName
- the parameter namex
- the valueSQLException
- if this object is closedpublic void setLong(String parameterName, long x) throws SQLException
setLong
in interface CallableStatement
parameterName
- the parameter namex
- the valueSQLException
- if this object is closedpublic void setInt(String parameterName, int x) throws SQLException
setInt
in interface CallableStatement
parameterName
- the parameter namex
- the valueSQLException
- if this object is closedpublic void setShort(String parameterName, short x) throws SQLException
setShort
in interface CallableStatement
parameterName
- the parameter namex
- the valueSQLException
- if this object is closedpublic void setByte(String parameterName, byte x) throws SQLException
setByte
in interface CallableStatement
parameterName
- the parameter namex
- the valueSQLException
- if this object is closedpublic void setBoolean(String parameterName, boolean x) throws SQLException
setBoolean
in interface CallableStatement
parameterName
- the parameter namex
- the valueSQLException
- if this object is closedpublic void setURL(String parameterName, URL val) throws SQLException
setURL
in interface CallableStatement
SQLException
public void setRowId(String parameterName, RowId x) throws SQLException
setRowId
in interface CallableStatement
SQLException
public void setNString(String parameterName, String x) throws SQLException
setNString
in interface CallableStatement
parameterName
- the parameter namex
- the valueSQLException
- if this object is closedpublic void setNCharacterStream(String parameterName, Reader x, long length) throws SQLException
setNCharacterStream
in interface CallableStatement
parameterName
- the parameter namex
- the valuelength
- the maximum number of charactersSQLException
- if this object is closedpublic void setNClob(String parameterName, NClob x) throws SQLException
setNClob
in interface CallableStatement
parameterName
- the parameter namex
- the valueSQLException
- if this object is closedpublic void setClob(String parameterName, Reader x, long length) throws SQLException
setClob
in interface CallableStatement
parameterName
- the parameter namex
- the valuelength
- the maximum number of charactersSQLException
- if this object is closedpublic void setBlob(String parameterName, InputStream x, long length) throws SQLException
setBlob
in interface CallableStatement
parameterName
- the parameter namex
- the valuelength
- the maximum number of bytesSQLException
- if this object is closedpublic void setNClob(String parameterName, Reader x, long length) throws SQLException
setNClob
in interface CallableStatement
parameterName
- the parameter namex
- the valuelength
- the maximum number of charactersSQLException
- if this object is closedpublic void setBlob(String parameterName, Blob x) throws SQLException
setBlob
in interface CallableStatement
parameterName
- the parameter namex
- the valueSQLException
- if this object is closedpublic void setClob(String parameterName, Clob x) throws SQLException
setClob
in interface CallableStatement
parameterName
- the parameter namex
- the valueSQLException
- if this object is closedpublic void setAsciiStream(String parameterName, InputStream x) throws SQLException
setAsciiStream
in interface CallableStatement
parameterName
- the parameter namex
- the valueSQLException
- if this object is closedpublic void setAsciiStream(String parameterName, InputStream x, int length) throws SQLException
setAsciiStream
in interface CallableStatement
parameterName
- the parameter namex
- the valuelength
- the maximum number of bytesSQLException
- if this object is closedpublic void setBinaryStream(String parameterName, InputStream x) throws SQLException
setBinaryStream
in interface CallableStatement
parameterName
- the parameter namex
- the valueSQLException
- if this object is closedpublic void setBinaryStream(String parameterName, InputStream x, long length) throws SQLException
setBinaryStream
in interface CallableStatement
parameterName
- the parameter namex
- the valuelength
- the maximum number of bytesSQLException
- if this object is closedpublic void setBlob(String parameterName, InputStream x) throws SQLException
setBlob
in interface CallableStatement
parameterName
- the parameter namex
- the valueSQLException
- if this object is closedpublic void setCharacterStream(String parameterName, Reader x) throws SQLException
setCharacterStream
in interface CallableStatement
parameterName
- the parameter namex
- the valueSQLException
- if this object is closedpublic void setCharacterStream(String parameterName, Reader x, long length) throws SQLException
setCharacterStream
in interface CallableStatement
parameterName
- the parameter namex
- the valuelength
- the maximum number of charactersSQLException
- if this object is closedpublic void setClob(String parameterName, Reader x) throws SQLException
setClob
in interface CallableStatement
parameterName
- the parameter namex
- the valueSQLException
- if this object is closedpublic void setNCharacterStream(String parameterName, Reader x) throws SQLException
setNCharacterStream
in interface CallableStatement
parameterName
- the parameter namex
- the valueSQLException
- if this object is closedpublic void setNClob(String parameterName, Reader x) throws SQLException
setNClob
in interface CallableStatement
parameterName
- the parameter namex
- the valueSQLException
- if this object is closedpublic void setSQLXML(String parameterName, SQLXML x) throws SQLException
setSQLXML
in interface CallableStatement
SQLException
public <T> T getObject(int parameterIndex, Class<T> type) throws SQLException
getObject
in interface CallableStatement
parameterIndex
- the parameter index (1, 2, ...)type
- the class of the returned valueSQLException
public <T> T getObject(String parameterName, Class<T> type) throws SQLException
getObject
in interface CallableStatement
parameterName
- the parameter nametype
- the class of the returned valueSQLException
Copyright © 2020 JBoss by Red Hat. All rights reserved.