public abstract class CallableProcedureStatement extends ServerSidePreparedStatement implements java.sql.CallableStatement, java.lang.Cloneable
Modifier and Type | Field and Description |
---|---|
protected boolean |
hasInOutParameters |
protected int[] |
outputParameterMapper |
protected CallableParameterMetaData |
parameterMetadata |
protected java.util.List<CallParameter> |
params
Information about parameters, merely from registerOutputParameter() and setXXX() calls.
|
parameterCount
autoGeneratedKeys, hasLongData, SPEC_ISO_ZONED_DATE_TIME
canUseServerTimeout, closed, connection, executing, fetchSize, lock, maxRows, options, protocol, queryTimeout, results, resultSetConcurrency, resultSetScrollType
Constructor and Description |
---|
CallableProcedureStatement(MariaDbConnection connection,
java.lang.String sql,
int resultSetScrollType,
int resultSetConcurrency)
Constructor for getter/setter of callableStatement.
|
Modifier and Type | Method and Description |
---|---|
CallableProcedureStatement |
clone(MariaDbConnection connection)
Clone data.
|
java.sql.Array |
getArray(int parameterIndex) |
java.sql.Array |
getArray(java.lang.String parameterName) |
java.math.BigDecimal |
getBigDecimal(int parameterIndex) |
java.math.BigDecimal |
getBigDecimal(int parameterIndex,
int scale)
Deprecated.
|
java.math.BigDecimal |
getBigDecimal(java.lang.String parameterName) |
java.sql.Blob |
getBlob(int parameterIndex) |
java.sql.Blob |
getBlob(java.lang.String parameterName) |
boolean |
getBoolean(int parameterIndex) |
boolean |
getBoolean(java.lang.String parameterName) |
byte |
getByte(int parameterIndex) |
byte |
getByte(java.lang.String parameterName) |
byte[] |
getBytes(int parameterIndex) |
byte[] |
getBytes(java.lang.String parameterName) |
java.io.Reader |
getCharacterStream(int parameterIndex) |
java.io.Reader |
getCharacterStream(java.lang.String parameterName) |
java.sql.Clob |
getClob(int parameterIndex) |
java.sql.Clob |
getClob(java.lang.String parameterName) |
java.sql.Date |
getDate(int parameterIndex) |
java.sql.Date |
getDate(int parameterIndex,
java.util.Calendar cal) |
java.sql.Date |
getDate(java.lang.String parameterName) |
java.sql.Date |
getDate(java.lang.String parameterName,
java.util.Calendar cal) |
double |
getDouble(int parameterIndex) |
double |
getDouble(java.lang.String parameterName) |
float |
getFloat(int parameterIndex) |
float |
getFloat(java.lang.String parameterName) |
int |
getInt(int parameterIndex) |
int |
getInt(java.lang.String parameterName) |
long |
getLong(int parameterIndex) |
long |
getLong(java.lang.String parameterName) |
java.io.Reader |
getNCharacterStream(int parameterIndex) |
java.io.Reader |
getNCharacterStream(java.lang.String parameterName) |
java.sql.NClob |
getNClob(int parameterIndex) |
java.sql.NClob |
getNClob(java.lang.String parameterName) |
java.lang.String |
getNString(int parameterIndex) |
java.lang.String |
getNString(java.lang.String parameterName) |
java.lang.Object |
getObject(int parameterIndex) |
<T> T |
getObject(int parameterIndex,
java.lang.Class<T> type) |
java.lang.Object |
getObject(int parameterIndex,
java.util.Map<java.lang.String,java.lang.Class<?>> map) |
java.lang.Object |
getObject(java.lang.String parameterName) |
<T> T |
getObject(java.lang.String parameterName,
java.lang.Class<T> type) |
java.lang.Object |
getObject(java.lang.String parameterName,
java.util.Map<java.lang.String,java.lang.Class<?>> map) |
protected abstract SelectResultSet |
getOutputResult() |
private CallParameter |
getParameter(int index) |
java.sql.ParameterMetaData |
getParameterMetaData()
Retrieves the number, types and properties of this
PreparedStatement object's
parameters. |
java.sql.Ref |
getRef(int parameterIndex) |
java.sql.Ref |
getRef(java.lang.String parameterName) |
java.sql.RowId |
getRowId(int parameterIndex) |
java.sql.RowId |
getRowId(java.lang.String parameterName) |
short |
getShort(int parameterIndex) |
short |
getShort(java.lang.String parameterName) |
java.sql.SQLXML |
getSQLXML(int parameterIndex) |
java.sql.SQLXML |
getSQLXML(java.lang.String parameterName) |
java.lang.String |
getString(int parameterIndex) |
java.lang.String |
getString(java.lang.String parameterName) |
java.sql.Time |
getTime(int parameterIndex) |
java.sql.Time |
getTime(int parameterIndex,
java.util.Calendar cal) |
java.sql.Time |
getTime(java.lang.String parameterName) |
java.sql.Time |
getTime(java.lang.String parameterName,
java.util.Calendar cal) |
java.sql.Timestamp |
getTimestamp(int parameterIndex) |
java.sql.Timestamp |
getTimestamp(int parameterIndex,
java.util.Calendar cal) |
java.sql.Timestamp |
getTimestamp(java.lang.String parameterName) |
java.sql.Timestamp |
getTimestamp(java.lang.String parameterName,
java.util.Calendar cal) |
java.net.URL |
getURL(int parameterIndex) |
java.net.URL |
getURL(java.lang.String parameterName) |
private int |
indexToOutputIndex(int parameterIndex)
Convert parameter index to corresponding outputIndex.
|
private int |
nameToIndex(java.lang.String parameterName)
Convert parameter name to parameter index in the query.
|
private int |
nameToOutputIndex(java.lang.String parameterName)
Convert parameter name to output parameter index in the query.
|
void |
registerOutParameter(int parameterIndex,
int sqlType) |
void |
registerOutParameter(int parameterIndex,
int sqlType,
int scale)
Registers the parameter in ordinal position
parameterIndex to be of JDBC type
sqlType . |
void |
registerOutParameter(int parameterIndex,
int sqlType,
java.lang.String typeName)
Registers the designated output parameter.
|
void |
registerOutParameter(int parameterIndex,
java.sql.SQLType sqlType) |
void |
registerOutParameter(int parameterIndex,
java.sql.SQLType sqlType,
int scale) |
void |
registerOutParameter(int parameterIndex,
java.sql.SQLType sqlType,
java.lang.String typeName) |
void |
registerOutParameter(java.lang.String parameterName,
int sqlType) |
void |
registerOutParameter(java.lang.String parameterName,
int sqlType,
int scale) |
void |
registerOutParameter(java.lang.String parameterName,
int sqlType,
java.lang.String typeName) |
void |
registerOutParameter(java.lang.String parameterName,
java.sql.SQLType sqlType) |
void |
registerOutParameter(java.lang.String parameterName,
java.sql.SQLType sqlType,
int scale) |
void |
registerOutParameter(java.lang.String parameterName,
java.sql.SQLType sqlType,
java.lang.String typeName) |
void |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream inputStream) |
void |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream inputStream,
int length) |
void |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream inputStream,
long length) |
void |
setBigDecimal(java.lang.String parameterName,
java.math.BigDecimal bigDecimal) |
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream inputStream) |
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream inputStream,
int length) |
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream inputStream,
long length) |
void |
setBlob(java.lang.String parameterName,
java.sql.Blob blob) |
void |
setBlob(java.lang.String parameterName,
java.io.InputStream inputStream) |
void |
setBlob(java.lang.String parameterName,
java.io.InputStream inputStream,
long length) |
void |
setBoolean(java.lang.String parameterName,
boolean booleanValue) |
void |
setByte(java.lang.String parameterName,
byte byteValue) |
void |
setBytes(java.lang.String parameterName,
byte[] bytes) |
void |
setCharacterStream(java.lang.String parameterName,
java.io.Reader reader) |
void |
setCharacterStream(java.lang.String parameterName,
java.io.Reader reader,
int length) |
void |
setCharacterStream(java.lang.String parameterName,
java.io.Reader reader,
long length) |
void |
setClob(java.lang.String parameterName,
java.sql.Clob clob) |
void |
setClob(java.lang.String parameterName,
java.io.Reader reader) |
void |
setClob(java.lang.String parameterName,
java.io.Reader reader,
long length) |
void |
setDate(java.lang.String parameterName,
java.sql.Date date) |
void |
setDate(java.lang.String parameterName,
java.sql.Date date,
java.util.Calendar cal) |
void |
setDouble(java.lang.String parameterName,
double doubleValue) |
void |
setFloat(java.lang.String parameterName,
float floatValue) |
void |
setInt(java.lang.String parameterName,
int intValue) |
void |
setLong(java.lang.String parameterName,
long longValue) |
void |
setNCharacterStream(java.lang.String parameterName,
java.io.Reader value) |
void |
setNCharacterStream(java.lang.String parameterName,
java.io.Reader value,
long length) |
void |
setNClob(java.lang.String parameterName,
java.sql.NClob value) |
void |
setNClob(java.lang.String parameterName,
java.io.Reader reader) |
void |
setNClob(java.lang.String parameterName,
java.io.Reader reader,
long length) |
void |
setNString(java.lang.String parameterName,
java.lang.String value) |
void |
setNull(java.lang.String parameterName,
int sqlType) |
void |
setNull(java.lang.String parameterName,
int sqlType,
java.lang.String typeName) |
void |
setObject(java.lang.String parameterName,
java.lang.Object obj) |
void |
setObject(java.lang.String parameterName,
java.lang.Object obj,
int targetSqlType) |
void |
setObject(java.lang.String parameterName,
java.lang.Object obj,
int targetSqlType,
int scale) |
void |
setObject(java.lang.String parameterName,
java.lang.Object obj,
java.sql.SQLType targetSqlType) |
void |
setObject(java.lang.String parameterName,
java.lang.Object obj,
java.sql.SQLType targetSqlType,
int scaleOrLength) |
void |
setParametersVariables()
Set in/out parameters value.
|
void |
setRowId(java.lang.String parameterName,
java.sql.RowId rowid) |
void |
setShort(java.lang.String parameterName,
short shortValue) |
void |
setSQLXML(java.lang.String parameterName,
java.sql.SQLXML xmlObject) |
void |
setString(java.lang.String parameterName,
java.lang.String stringValue) |
void |
setTime(java.lang.String parameterName,
java.sql.Time time) |
void |
setTime(java.lang.String parameterName,
java.sql.Time time,
java.util.Calendar cal) |
void |
setTimestamp(java.lang.String parameterName,
java.sql.Timestamp timestamp) |
void |
setTimestamp(java.lang.String parameterName,
java.sql.Timestamp timestamp,
java.util.Calendar cal) |
void |
setURL(java.lang.String parameterName,
java.net.URL url) |
boolean |
wasNull() |
addBatch, addBatch, clearBatch, clearParameters, close, execute, executeBatch, executeInternal, executeLargeBatch, executeQuery, executeUpdate, getMetaData, getParameterCount, getServerThreadId, setParameter, toString, validParameters
executeLargeUpdate, 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, setNull, setObject, setObject, setObject, setObject, setObject, setRef, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL
cancel, checkClose, checkCloseOnCompletion, clearWarnings, closeOnCompletion, execute, execute, execute, execute, executeBatchEpilogue, executeBatchExceptionEpilogue, executeEpilogue, executeExceptionEpilogue, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeQuery, executeQueryPrologue, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isWrapperFor, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setLocalInfileInputStream, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, setTimerTask, skipMoreResults, testExecute, unwrap
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
addBatch, clearParameters, execute, executeLargeUpdate, executeQuery, executeUpdate, getMetaData, 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
protected java.util.List<CallParameter> params
protected int[] outputParameterMapper
protected CallableParameterMetaData parameterMetadata
protected boolean hasInOutParameters
public CallableProcedureStatement(MariaDbConnection connection, java.lang.String sql, int resultSetScrollType, int resultSetConcurrency) throws java.sql.SQLException
connection
- current connectionsql
- queryresultSetScrollType
- one of the following ResultSet
constants:
ResultSet.TYPE_FORWARD_ONLY
,
ResultSet.TYPE_SCROLL_INSENSITIVE
, or
ResultSet.TYPE_SCROLL_SENSITIVE
resultSetConcurrency
- a concurrency type; one of ResultSet.CONCUR_READ_ONLY
or
ResultSet.CONCUR_UPDATABLE
java.sql.SQLException
- is prepareStatement connection throw any errorpublic CallableProcedureStatement clone(MariaDbConnection connection) throws java.lang.CloneNotSupportedException
clone
in class ServerSidePreparedStatement
connection
- connectionjava.lang.CloneNotSupportedException
- if any error occur.public void setParametersVariables()
protected abstract SelectResultSet getOutputResult() throws java.sql.SQLException
java.sql.SQLException
public java.sql.ParameterMetaData getParameterMetaData() throws java.sql.SQLException
BasePrepareStatement
PreparedStatement
object's
parameters.getParameterMetaData
in interface java.sql.PreparedStatement
getParameterMetaData
in class ServerSidePreparedStatement
ParameterMetaData
object that contains information about the number,
types and properties for each parameter marker of this PreparedStatement
objectjava.sql.SQLException
- if a database access error occurs or this method is called on a closed
PreparedStatement
ParameterMetaData
private int nameToIndex(java.lang.String parameterName) throws java.sql.SQLException
parameterName
- namejava.sql.SQLException
- exceptionprivate int nameToOutputIndex(java.lang.String parameterName) throws java.sql.SQLException
parameterName
- namejava.sql.SQLException
- exceptionprivate int indexToOutputIndex(int parameterIndex) throws java.sql.SQLException
parameterIndex
- indexjava.sql.SQLException
- exceptionpublic boolean wasNull() throws java.sql.SQLException
wasNull
in interface java.sql.CallableStatement
java.sql.SQLException
public java.lang.String getString(int parameterIndex) throws java.sql.SQLException
getString
in interface java.sql.CallableStatement
java.sql.SQLException
public java.lang.String getString(java.lang.String parameterName) throws java.sql.SQLException
getString
in interface java.sql.CallableStatement
java.sql.SQLException
public boolean getBoolean(int parameterIndex) throws java.sql.SQLException
getBoolean
in interface java.sql.CallableStatement
java.sql.SQLException
public boolean getBoolean(java.lang.String parameterName) throws java.sql.SQLException
getBoolean
in interface java.sql.CallableStatement
java.sql.SQLException
public byte getByte(int parameterIndex) throws java.sql.SQLException
getByte
in interface java.sql.CallableStatement
java.sql.SQLException
public byte getByte(java.lang.String parameterName) throws java.sql.SQLException
getByte
in interface java.sql.CallableStatement
java.sql.SQLException
public short getShort(int parameterIndex) throws java.sql.SQLException
getShort
in interface java.sql.CallableStatement
java.sql.SQLException
public short getShort(java.lang.String parameterName) throws java.sql.SQLException
getShort
in interface java.sql.CallableStatement
java.sql.SQLException
public int getInt(java.lang.String parameterName) throws java.sql.SQLException
getInt
in interface java.sql.CallableStatement
java.sql.SQLException
public int getInt(int parameterIndex) throws java.sql.SQLException
getInt
in interface java.sql.CallableStatement
java.sql.SQLException
public long getLong(java.lang.String parameterName) throws java.sql.SQLException
getLong
in interface java.sql.CallableStatement
java.sql.SQLException
public long getLong(int parameterIndex) throws java.sql.SQLException
getLong
in interface java.sql.CallableStatement
java.sql.SQLException
public float getFloat(java.lang.String parameterName) throws java.sql.SQLException
getFloat
in interface java.sql.CallableStatement
java.sql.SQLException
public float getFloat(int parameterIndex) throws java.sql.SQLException
getFloat
in interface java.sql.CallableStatement
java.sql.SQLException
public double getDouble(int parameterIndex) throws java.sql.SQLException
getDouble
in interface java.sql.CallableStatement
java.sql.SQLException
public double getDouble(java.lang.String parameterName) throws java.sql.SQLException
getDouble
in interface java.sql.CallableStatement
java.sql.SQLException
@Deprecated public java.math.BigDecimal getBigDecimal(int parameterIndex, int scale) throws java.sql.SQLException
getBigDecimal
in interface java.sql.CallableStatement
java.sql.SQLException
public java.math.BigDecimal getBigDecimal(int parameterIndex) throws java.sql.SQLException
getBigDecimal
in interface java.sql.CallableStatement
java.sql.SQLException
public java.math.BigDecimal getBigDecimal(java.lang.String parameterName) throws java.sql.SQLException
getBigDecimal
in interface java.sql.CallableStatement
java.sql.SQLException
public byte[] getBytes(java.lang.String parameterName) throws java.sql.SQLException
getBytes
in interface java.sql.CallableStatement
java.sql.SQLException
public byte[] getBytes(int parameterIndex) throws java.sql.SQLException
getBytes
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Date getDate(int parameterIndex) throws java.sql.SQLException
getDate
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Date getDate(java.lang.String parameterName) throws java.sql.SQLException
getDate
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Date getDate(java.lang.String parameterName, java.util.Calendar cal) throws java.sql.SQLException
getDate
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Date getDate(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException
getDate
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Time getTime(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException
getTime
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Time getTime(java.lang.String parameterName) throws java.sql.SQLException
getTime
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Time getTime(java.lang.String parameterName, java.util.Calendar cal) throws java.sql.SQLException
getTime
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Time getTime(int parameterIndex) throws java.sql.SQLException
getTime
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Timestamp getTimestamp(int parameterIndex) throws java.sql.SQLException
getTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Timestamp getTimestamp(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException
getTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Timestamp getTimestamp(java.lang.String parameterName) throws java.sql.SQLException
getTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Timestamp getTimestamp(java.lang.String parameterName, java.util.Calendar cal) throws java.sql.SQLException
getTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
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.CallableStatement
java.sql.SQLException
public java.lang.Object getObject(int parameterIndex) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
java.sql.SQLException
public java.lang.Object getObject(java.lang.String parameterName) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
java.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.CallableStatement
java.sql.SQLException
public <T> T getObject(int parameterIndex, java.lang.Class<T> type) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
java.sql.SQLException
public <T> T getObject(java.lang.String parameterName, java.lang.Class<T> type) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Ref getRef(int parameterIndex) throws java.sql.SQLException
getRef
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Ref getRef(java.lang.String parameterName) throws java.sql.SQLException
getRef
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Blob getBlob(int parameterIndex) throws java.sql.SQLException
getBlob
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Blob getBlob(java.lang.String parameterName) throws java.sql.SQLException
getBlob
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Clob getClob(java.lang.String parameterName) throws java.sql.SQLException
getClob
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Clob getClob(int parameterIndex) throws java.sql.SQLException
getClob
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Array getArray(java.lang.String parameterName) throws java.sql.SQLException
getArray
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.Array getArray(int parameterIndex) throws java.sql.SQLException
getArray
in interface java.sql.CallableStatement
java.sql.SQLException
public java.net.URL getURL(int parameterIndex) throws java.sql.SQLException
getURL
in interface java.sql.CallableStatement
java.sql.SQLException
public java.net.URL getURL(java.lang.String parameterName) throws java.sql.SQLException
getURL
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.RowId getRowId(int parameterIndex) throws java.sql.SQLException
getRowId
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.RowId getRowId(java.lang.String parameterName) throws java.sql.SQLException
getRowId
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.NClob getNClob(int parameterIndex) throws java.sql.SQLException
getNClob
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.NClob getNClob(java.lang.String parameterName) throws java.sql.SQLException
getNClob
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.SQLXML getSQLXML(int parameterIndex) throws java.sql.SQLException
getSQLXML
in interface java.sql.CallableStatement
java.sql.SQLException
public java.sql.SQLXML getSQLXML(java.lang.String parameterName) throws java.sql.SQLException
getSQLXML
in interface java.sql.CallableStatement
java.sql.SQLException
public java.lang.String getNString(int parameterIndex) throws java.sql.SQLException
getNString
in interface java.sql.CallableStatement
java.sql.SQLException
public java.lang.String getNString(java.lang.String parameterName) throws java.sql.SQLException
getNString
in interface java.sql.CallableStatement
java.sql.SQLException
public java.io.Reader getNCharacterStream(int parameterIndex) throws java.sql.SQLException
getNCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public java.io.Reader getNCharacterStream(java.lang.String parameterName) throws java.sql.SQLException
getNCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public java.io.Reader getCharacterStream(int parameterIndex) throws java.sql.SQLException
getCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public java.io.Reader getCharacterStream(java.lang.String parameterName) throws java.sql.SQLException
getCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void registerOutParameter(int parameterIndex, int sqlType, java.lang.String typeName) throws java.sql.SQLException
Registers the designated output parameter.
This version of the method registerOutParameter
should be used for a user-defined
or REF
output parameter. Examples of user-defined types include:
STRUCT
, DISTINCT
,
JAVA_OBJECT
, and named array types.
All OUT parameters must be registered before a stored procedure is executed.
For a user-defined parameter, the fully-qualified SQL
type name of the parameter should also be given, while a REF
parameter requires
that the fully-qualified type name of the referenced type be given. A JDBC driver that does
not need the type code and type name information may ignore it. To be portable, however,
applications should always provide these values for user-defined and REF
parameters.
Although it is intended for user-defined and REF
parameters,
this method may be used to register a parameter of any JDBC type. If the parameter does not
have a user-defined or REF
type, the
typeName parameter is ignored.
Note: When reading the value of an out parameter, you must use the getter method whose Java type corresponds to the parameter's registered SQL type.
registerOutParameter
in interface java.sql.CallableStatement
parameterIndex
- the first parameter is 1, the second is 2,...sqlType
- a value from Types
typeName
- the fully-qualified name of an SQL structured typejava.sql.SQLException
- if the parameterIndex is not valid; if a database
access error occurs or this method is called on a
closed CallableStatement
Types
public void registerOutParameter(int parameterIndex, int sqlType) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
public void registerOutParameter(int parameterIndex, int sqlType, int scale) throws java.sql.SQLException
Registers the parameter in ordinal position
parameterIndex
to be of JDBC type
sqlType
. All OUT parameters must be registered
before a stored procedure is executed.
The JDBC type specified by sqlType
for an OUT
parameter determines the Java type that must be used in the get
method to read the
value of that parameter.
This version of registerOutParameter
should be
used when the parameter is of JDBC type NUMERIC
or DECIMAL
.
registerOutParameter
in interface java.sql.CallableStatement
parameterIndex
- the first parameter is 1, the second is 2, and so onsqlType
- the SQL type code defined by java.sql.Types
.scale
- the desired number of digits to the right of the decimal point. It must
be greater than or equal to zero.java.sql.SQLException
- if the parameterIndex is not valid; if a database
access error occurs or this method is called on a
closed CallableStatement
Types
public void registerOutParameter(java.lang.String parameterName, int sqlType) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
public void registerOutParameter(java.lang.String parameterName, int sqlType, int scale) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
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.CallableStatement
java.sql.SQLException
public void registerOutParameter(int parameterIndex, java.sql.SQLType sqlType) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
public void registerOutParameter(int parameterIndex, java.sql.SQLType sqlType, int scale) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
public void registerOutParameter(int parameterIndex, java.sql.SQLType sqlType, java.lang.String typeName) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
public void registerOutParameter(java.lang.String parameterName, java.sql.SQLType sqlType) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
public void registerOutParameter(java.lang.String parameterName, java.sql.SQLType sqlType, int scale) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
public void registerOutParameter(java.lang.String parameterName, java.sql.SQLType sqlType, java.lang.String typeName) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
private CallParameter getParameter(int index) throws java.sql.SQLException
java.sql.SQLException
public void setSQLXML(java.lang.String parameterName, java.sql.SQLXML xmlObject) throws java.sql.SQLException
setSQLXML
in interface java.sql.CallableStatement
java.sql.SQLException
public void setRowId(java.lang.String parameterName, java.sql.RowId rowid) throws java.sql.SQLException
setRowId
in interface java.sql.CallableStatement
java.sql.SQLException
public void setNString(java.lang.String parameterName, java.lang.String value) throws java.sql.SQLException
setNString
in interface java.sql.CallableStatement
java.sql.SQLException
public void setNCharacterStream(java.lang.String parameterName, java.io.Reader value, long length) throws java.sql.SQLException
setNCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setNCharacterStream(java.lang.String parameterName, java.io.Reader value) throws java.sql.SQLException
setNCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setNClob(java.lang.String parameterName, java.sql.NClob value) throws java.sql.SQLException
setNClob
in interface java.sql.CallableStatement
java.sql.SQLException
public void setNClob(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException
setNClob
in interface java.sql.CallableStatement
java.sql.SQLException
public void setNClob(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
setNClob
in interface java.sql.CallableStatement
java.sql.SQLException
public void setClob(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException
setClob
in interface java.sql.CallableStatement
java.sql.SQLException
public void setClob(java.lang.String parameterName, java.sql.Clob clob) throws java.sql.SQLException
setClob
in interface java.sql.CallableStatement
java.sql.SQLException
public void setClob(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
setClob
in interface java.sql.CallableStatement
java.sql.SQLException
public void setBlob(java.lang.String parameterName, java.io.InputStream inputStream, long length) throws java.sql.SQLException
setBlob
in interface java.sql.CallableStatement
java.sql.SQLException
public void setBlob(java.lang.String parameterName, java.sql.Blob blob) throws java.sql.SQLException
setBlob
in interface java.sql.CallableStatement
java.sql.SQLException
public void setBlob(java.lang.String parameterName, java.io.InputStream inputStream) throws java.sql.SQLException
setBlob
in interface java.sql.CallableStatement
java.sql.SQLException
public void setAsciiStream(java.lang.String parameterName, java.io.InputStream inputStream, long length) throws java.sql.SQLException
setAsciiStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setAsciiStream(java.lang.String parameterName, java.io.InputStream inputStream, int length) throws java.sql.SQLException
setAsciiStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setAsciiStream(java.lang.String parameterName, java.io.InputStream inputStream) throws java.sql.SQLException
setAsciiStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setBinaryStream(java.lang.String parameterName, java.io.InputStream inputStream, long length) throws java.sql.SQLException
setBinaryStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setBinaryStream(java.lang.String parameterName, java.io.InputStream inputStream) throws java.sql.SQLException
setBinaryStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setBinaryStream(java.lang.String parameterName, java.io.InputStream inputStream, int length) throws java.sql.SQLException
setBinaryStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setCharacterStream(java.lang.String parameterName, java.io.Reader reader, long length) throws java.sql.SQLException
setCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setCharacterStream(java.lang.String parameterName, java.io.Reader reader) throws java.sql.SQLException
setCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setCharacterStream(java.lang.String parameterName, java.io.Reader reader, int length) throws java.sql.SQLException
setCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setURL(java.lang.String parameterName, java.net.URL url) throws java.sql.SQLException
setURL
in interface java.sql.CallableStatement
java.sql.SQLException
public void setNull(java.lang.String parameterName, int sqlType) throws java.sql.SQLException
setNull
in interface java.sql.CallableStatement
java.sql.SQLException
public void setNull(java.lang.String parameterName, int sqlType, java.lang.String typeName) throws java.sql.SQLException
setNull
in interface java.sql.CallableStatement
java.sql.SQLException
public void setBoolean(java.lang.String parameterName, boolean booleanValue) throws java.sql.SQLException
setBoolean
in interface java.sql.CallableStatement
java.sql.SQLException
public void setByte(java.lang.String parameterName, byte byteValue) throws java.sql.SQLException
setByte
in interface java.sql.CallableStatement
java.sql.SQLException
public void setShort(java.lang.String parameterName, short shortValue) throws java.sql.SQLException
setShort
in interface java.sql.CallableStatement
java.sql.SQLException
public void setInt(java.lang.String parameterName, int intValue) throws java.sql.SQLException
setInt
in interface java.sql.CallableStatement
java.sql.SQLException
public void setLong(java.lang.String parameterName, long longValue) throws java.sql.SQLException
setLong
in interface java.sql.CallableStatement
java.sql.SQLException
public void setFloat(java.lang.String parameterName, float floatValue) throws java.sql.SQLException
setFloat
in interface java.sql.CallableStatement
java.sql.SQLException
public void setDouble(java.lang.String parameterName, double doubleValue) throws java.sql.SQLException
setDouble
in interface java.sql.CallableStatement
java.sql.SQLException
public void setBigDecimal(java.lang.String parameterName, java.math.BigDecimal bigDecimal) throws java.sql.SQLException
setBigDecimal
in interface java.sql.CallableStatement
java.sql.SQLException
public void setString(java.lang.String parameterName, java.lang.String stringValue) throws java.sql.SQLException
setString
in interface java.sql.CallableStatement
java.sql.SQLException
public void setBytes(java.lang.String parameterName, byte[] bytes) throws java.sql.SQLException
setBytes
in interface java.sql.CallableStatement
java.sql.SQLException
public void setDate(java.lang.String parameterName, java.sql.Date date) throws java.sql.SQLException
setDate
in interface java.sql.CallableStatement
java.sql.SQLException
public void setDate(java.lang.String parameterName, java.sql.Date date, java.util.Calendar cal) throws java.sql.SQLException
setDate
in interface java.sql.CallableStatement
java.sql.SQLException
public void setTime(java.lang.String parameterName, java.sql.Time time) throws java.sql.SQLException
setTime
in interface java.sql.CallableStatement
java.sql.SQLException
public void setTime(java.lang.String parameterName, java.sql.Time time, java.util.Calendar cal) throws java.sql.SQLException
setTime
in interface java.sql.CallableStatement
java.sql.SQLException
public void setTimestamp(java.lang.String parameterName, java.sql.Timestamp timestamp) throws java.sql.SQLException
setTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
public void setTimestamp(java.lang.String parameterName, java.sql.Timestamp timestamp, java.util.Calendar cal) throws java.sql.SQLException
setTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
public void setObject(java.lang.String parameterName, java.lang.Object obj, int targetSqlType, int scale) throws java.sql.SQLException
setObject
in interface java.sql.CallableStatement
java.sql.SQLException
public void setObject(java.lang.String parameterName, java.lang.Object obj, int targetSqlType) throws java.sql.SQLException
setObject
in interface java.sql.CallableStatement
java.sql.SQLException
public void setObject(java.lang.String parameterName, java.lang.Object obj) throws java.sql.SQLException
setObject
in interface java.sql.CallableStatement
java.sql.SQLException
public void setObject(java.lang.String parameterName, java.lang.Object obj, java.sql.SQLType targetSqlType, int scaleOrLength) throws java.sql.SQLException
setObject
in interface java.sql.CallableStatement
java.sql.SQLException
public void setObject(java.lang.String parameterName, java.lang.Object obj, java.sql.SQLType targetSqlType) throws java.sql.SQLException
setObject
in interface java.sql.CallableStatement
java.sql.SQLException