|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectcom.mysql.jdbc.StatementImpl
com.mysql.jdbc.PreparedStatement
com.mysql.jdbc.CallableStatement
public class CallableStatement
Representation of stored procedures for JDBC
Nested Class Summary | |
---|---|
protected class |
CallableStatement.CallableStatementParam
|
protected class |
CallableStatement.CallableStatementParamInfo
|
protected class |
CallableStatement.CallableStatementParamInfoJDBC3
Can't implement this directly, as then you can't use callable statements on JDK-1.3.1, which unfortunately isn't EOL'd yet, and still present quite a bit out there in the wild (Websphere, FreeBSD, anyone?) |
Nested classes/interfaces inherited from class com.mysql.jdbc.PreparedStatement |
---|
PreparedStatement.AppendingBatchVisitor, PreparedStatement.BatchParams, PreparedStatement.BatchVisitor, PreparedStatement.EmulatedPreparedStatementBindings, PreparedStatement.EndPoint, PreparedStatement.ParseInfo |
Nested classes/interfaces inherited from class com.mysql.jdbc.StatementImpl |
---|
StatementImpl.CancelTask |
Field Summary | |
---|---|
protected static java.lang.reflect.Constructor |
JDBC_4_CSTMT_2_ARGS_CTOR
|
protected static java.lang.reflect.Constructor |
JDBC_4_CSTMT_4_ARGS_CTOR
|
protected boolean |
outputParamWasNull
|
protected CallableStatement.CallableStatementParamInfo |
paramInfo
|
Fields inherited from class com.mysql.jdbc.PreparedStatement |
---|
batchedValuesClause, batchHasPlainStatements, firstCharOfStmt, hasLimitClause, isLoadDataQuery, numberOfExecutions, originalSql, parameterCount, parameterMetaData, parameterTypes, parseInfo, rewrittenBatchSize, useTrueBoolean, usingAnsiMode |
Fields inherited from interface java.sql.Statement |
---|
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO |
Constructor Summary | |
---|---|
CallableStatement(ConnectionImpl conn,
CallableStatement.CallableStatementParamInfo paramInfo)
Creates a new CallableStatement |
|
CallableStatement(ConnectionImpl conn,
java.lang.String sql,
java.lang.String catalog,
boolean isFunctionCall)
Creates a new CallableStatement |
Method Summary | |
---|---|
void |
addBatch()
JDBC 2.0 Add a set of parameters to the batch. |
protected boolean |
checkReadOnlySafeStatement()
Check to see if the statement is safe for read-only slaves after failover. |
void |
clearParameters()
In general, parameter values remain in force for repeated used of a Statement. |
boolean |
execute()
Some prepared statements return multiple results; the execute method handles these complex statements as well as the simpler form of statements handled by executeQuery and executeUpdate |
int[] |
executeBatch()
JDBC 2.0 Submit a batch of commands to the database for execution. |
java.sql.ResultSet |
executeQuery()
A Prepared SQL query is executed and its ResultSet is returned |
int |
executeUpdate()
Execute a SQL INSERT, UPDATE or DELETE statement. |
protected java.lang.String |
fixParameterName(java.lang.String paramNameIn)
Adds 'at' symbol to beginning of parameter names if needed. |
java.sql.Array |
getArray(int i)
|
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.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)
|
protected static CallableStatement |
getInstance(ConnectionImpl conn,
CallableStatement.CallableStatementParamInfo paramInfo)
Creates a callable statement instance -- We need to provide factory-style methods so we can support both JDBC3 (and older) and JDBC4 runtimes, otherwise the class verifier complains when it tries to load JDBC4-only interface classes that are present in JDBC4 method signatures. |
protected static CallableStatement |
getInstance(ConnectionImpl conn,
java.lang.String sql,
java.lang.String catalog,
boolean isFunctionCall)
Creates a callable statement instance -- We need to provide factory-style methods so we can support both JDBC3 (and older) and JDBC4 runtimes, otherwise the class verifier complains when it tries to load JDBC4-only interface classes that are present in JDBC4 method signatures. |
int |
getInt(int parameterIndex)
|
int |
getInt(java.lang.String parameterName)
|
long |
getLong(int parameterIndex)
|
long |
getLong(java.lang.String parameterName)
|
protected int |
getNamedParamIndex(java.lang.String paramName,
boolean forOut)
|
java.lang.Object |
getObject(int parameterIndex)
|
java.lang.Object |
getObject(int parameterIndex,
java.util.Map map)
|
java.lang.Object |
getObject(java.lang.String parameterName)
|
java.lang.Object |
getObject(java.lang.String parameterName,
java.util.Map map)
|
protected ResultSetInternalMethods |
getOutputParameters(int paramIndex)
Returns the ResultSet that holds the output parameters, or throws an appropriate exception if none exist, or they weren't returned. |
protected int |
getParameterIndexOffset()
For calling stored functions, this will be -1 as we don't really count the first '?' |
java.sql.ParameterMetaData |
getParameterMetaData()
|
java.sql.Ref |
getRef(int parameterIndex)
|
java.sql.Ref |
getRef(java.lang.String parameterName)
|
short |
getShort(int parameterIndex)
|
short |
getShort(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)
|
protected int |
mapOutputParameterIndexToRsIndex(int paramIndex)
|
void |
registerOutParameter(int parameterIndex,
int sqlType)
|
void |
registerOutParameter(int parameterIndex,
int sqlType,
int scale)
|
void |
registerOutParameter(int parameterIndex,
int 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 |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream x)
|
void |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream x,
int length)
|
void |
setAsciiStream(java.lang.String parameterName,
java.io.InputStream x,
long length)
|
void |
setBigDecimal(java.lang.String parameterName,
java.math.BigDecimal x)
|
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream x)
|
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream x,
int length)
|
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream x,
long length)
|
void |
setBlob(java.lang.String parameterName,
java.sql.Blob x)
|
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 x)
|
void |
setByte(java.lang.String parameterName,
byte x)
|
void |
setBytes(java.lang.String parameterName,
byte[] x)
|
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 x)
|
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 x)
|
void |
setDate(java.lang.String parameterName,
java.sql.Date x,
java.util.Calendar cal)
|
void |
setDouble(java.lang.String parameterName,
double x)
|
void |
setFloat(java.lang.String parameterName,
float x)
|
void |
setInt(java.lang.String parameterName,
int x)
|
void |
setLong(java.lang.String parameterName,
long x)
|
void |
setNCharacterStream(java.lang.String parameterName,
java.io.Reader value)
|
void |
setNCharacterStream(java.lang.String parameterName,
java.io.Reader value,
long length)
|
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 x)
|
void |
setObject(java.lang.String parameterName,
java.lang.Object x,
int targetSqlType)
|
void |
setObject(java.lang.String parameterName,
java.lang.Object x,
int targetSqlType,
int scale)
|
void |
setShort(java.lang.String parameterName,
short x)
|
void |
setString(java.lang.String parameterName,
java.lang.String x)
|
void |
setTime(java.lang.String parameterName,
java.sql.Time x)
|
void |
setTime(java.lang.String parameterName,
java.sql.Time x,
java.util.Calendar cal)
|
void |
setTimestamp(java.lang.String parameterName,
java.sql.Timestamp x)
|
void |
setTimestamp(java.lang.String parameterName,
java.sql.Timestamp x,
java.util.Calendar cal)
|
void |
setURL(java.lang.String parameterName,
java.net.URL val)
|
boolean |
wasNull()
|
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait |
Methods inherited from interface java.sql.CallableStatement |
---|
getCharacterStream, getCharacterStream, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getRowId, getRowId, getSQLXML, getSQLXML, setNClob, setNClob, setNClob, setNString, setRowId, setSQLXML |
Methods inherited from interface java.sql.PreparedStatement |
---|
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, setRef, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL |
Methods inherited from interface java.sql.Statement |
---|
addBatch, cancel, clearBatch, clearWarnings, close, execute, execute, execute, execute, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isPoolable, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout |
Methods inherited from interface java.sql.Wrapper |
---|
isWrapperFor, unwrap |
Field Detail |
---|
protected static final java.lang.reflect.Constructor JDBC_4_CSTMT_2_ARGS_CTOR
protected static final java.lang.reflect.Constructor JDBC_4_CSTMT_4_ARGS_CTOR
protected boolean outputParamWasNull
protected CallableStatement.CallableStatementParamInfo paramInfo
Constructor Detail |
---|
public CallableStatement(ConnectionImpl conn, CallableStatement.CallableStatementParamInfo paramInfo) throws java.sql.SQLException
conn
- the connection creating this statementparamInfo
- the SQL to prepare
java.sql.SQLException
- if an error occurspublic CallableStatement(ConnectionImpl conn, java.lang.String sql, java.lang.String catalog, boolean isFunctionCall) throws java.sql.SQLException
conn
- the connection creating this statementsql
- the SQL to preparecatalog
- the current catalog
java.sql.SQLException
- if an error occursMethod Detail |
---|
protected static CallableStatement getInstance(ConnectionImpl conn, java.lang.String sql, java.lang.String catalog, boolean isFunctionCall) throws java.sql.SQLException
java.sql.SQLException
protected static CallableStatement getInstance(ConnectionImpl conn, CallableStatement.CallableStatementParamInfo paramInfo) throws java.sql.SQLException
java.sql.SQLException
public void addBatch() throws java.sql.SQLException
PreparedStatement
addBatch
in interface java.sql.PreparedStatement
addBatch
in class PreparedStatement
java.sql.SQLException
- if a database-access error occurs.StatementImpl.addBatch(java.lang.String)
public void clearParameters() throws java.sql.SQLException
PreparedStatement
clearParameters
in interface java.sql.PreparedStatement
clearParameters
in class PreparedStatement
java.sql.SQLException
- if a database access error occurspublic boolean execute() throws java.sql.SQLException
PreparedStatement
execute
in interface java.sql.PreparedStatement
execute
in class PreparedStatement
java.sql.SQLException
- if a database access error occurspublic java.sql.ResultSet executeQuery() throws java.sql.SQLException
PreparedStatement
executeQuery
in interface java.sql.PreparedStatement
executeQuery
in class PreparedStatement
java.sql.SQLException
- if a database access error occurspublic int executeUpdate() throws java.sql.SQLException
PreparedStatement
executeUpdate
in interface java.sql.PreparedStatement
executeUpdate
in class PreparedStatement
java.sql.SQLException
- if a database access error occursprotected java.lang.String fixParameterName(java.lang.String paramNameIn) throws java.sql.SQLException
paramNameIn
- the parameter name to 'fix'
java.sql.SQLException
- if the parameter name is null or empty.public java.sql.Array getArray(int i) throws java.sql.SQLException
getArray
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getArray(int)
public java.sql.Array getArray(java.lang.String parameterName) throws java.sql.SQLException
getArray
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getArray(java.lang.String)
public java.math.BigDecimal getBigDecimal(int parameterIndex) throws java.sql.SQLException
getBigDecimal
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getBigDecimal(int)
public java.math.BigDecimal getBigDecimal(int parameterIndex, int scale) throws java.sql.SQLException
getBigDecimal
in interface java.sql.CallableStatement
parameterIndex
- DOCUMENT ME!scale
- DOCUMENT ME!
java.sql.SQLException
- DOCUMENT ME!CallableStatement.getBigDecimal(int, int)
public java.math.BigDecimal getBigDecimal(java.lang.String parameterName) throws java.sql.SQLException
getBigDecimal
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getBigDecimal(java.lang.String)
public java.sql.Blob getBlob(int parameterIndex) throws java.sql.SQLException
getBlob
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getBlob(int)
public java.sql.Blob getBlob(java.lang.String parameterName) throws java.sql.SQLException
getBlob
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getBlob(java.lang.String)
public boolean getBoolean(int parameterIndex) throws java.sql.SQLException
getBoolean
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getBoolean(int)
public boolean getBoolean(java.lang.String parameterName) throws java.sql.SQLException
getBoolean
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getBoolean(java.lang.String)
public byte getByte(int parameterIndex) throws java.sql.SQLException
getByte
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getByte(int)
public byte getByte(java.lang.String parameterName) throws java.sql.SQLException
getByte
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getByte(java.lang.String)
public byte[] getBytes(int parameterIndex) throws java.sql.SQLException
getBytes
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getBytes(int)
public byte[] getBytes(java.lang.String parameterName) throws java.sql.SQLException
getBytes
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getBytes(java.lang.String)
public java.sql.Clob getClob(int parameterIndex) throws java.sql.SQLException
getClob
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getClob(int)
public java.sql.Clob getClob(java.lang.String parameterName) throws java.sql.SQLException
getClob
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getClob(java.lang.String)
public java.sql.Date getDate(int parameterIndex) throws java.sql.SQLException
getDate
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getDate(int)
public java.sql.Date getDate(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException
getDate
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getDate(int, java.util.Calendar)
public java.sql.Date getDate(java.lang.String parameterName) throws java.sql.SQLException
getDate
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getDate(java.lang.String)
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
CallableStatement.getDate(java.lang.String,
java.util.Calendar)
public double getDouble(int parameterIndex) throws java.sql.SQLException
getDouble
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getDouble(int)
public double getDouble(java.lang.String parameterName) throws java.sql.SQLException
getDouble
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getDouble(java.lang.String)
public float getFloat(int parameterIndex) throws java.sql.SQLException
getFloat
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getFloat(int)
public float getFloat(java.lang.String parameterName) throws java.sql.SQLException
getFloat
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getFloat(java.lang.String)
public int getInt(int parameterIndex) throws java.sql.SQLException
getInt
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getInt(int)
public int getInt(java.lang.String parameterName) throws java.sql.SQLException
getInt
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getInt(java.lang.String)
public long getLong(int parameterIndex) throws java.sql.SQLException
getLong
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getLong(int)
public long getLong(java.lang.String parameterName) throws java.sql.SQLException
getLong
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getLong(java.lang.String)
protected int getNamedParamIndex(java.lang.String paramName, boolean forOut) throws java.sql.SQLException
java.sql.SQLException
public java.lang.Object getObject(int parameterIndex) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getObject(int)
public java.lang.Object getObject(int parameterIndex, java.util.Map map) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getObject(int, java.util.Map)
public java.lang.Object getObject(java.lang.String parameterName) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getObject(java.lang.String)
public java.lang.Object getObject(java.lang.String parameterName, java.util.Map map) throws java.sql.SQLException
getObject
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getObject(java.lang.String,
java.util.Map)
protected ResultSetInternalMethods getOutputParameters(int paramIndex) throws java.sql.SQLException
java.sql.SQLException
- if no output parameters were defined, or if no output
parameters were returned.public java.sql.ParameterMetaData getParameterMetaData() throws java.sql.SQLException
getParameterMetaData
in interface java.sql.PreparedStatement
getParameterMetaData
in class PreparedStatement
java.sql.SQLException
PreparedStatement.getParameterMetaData()
public java.sql.Ref getRef(int parameterIndex) throws java.sql.SQLException
getRef
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getRef(int)
public java.sql.Ref getRef(java.lang.String parameterName) throws java.sql.SQLException
getRef
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getRef(java.lang.String)
public short getShort(int parameterIndex) throws java.sql.SQLException
getShort
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getShort(int)
public short getShort(java.lang.String parameterName) throws java.sql.SQLException
getShort
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getShort(java.lang.String)
public java.lang.String getString(int parameterIndex) throws java.sql.SQLException
getString
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getString(int)
public java.lang.String getString(java.lang.String parameterName) throws java.sql.SQLException
getString
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getString(java.lang.String)
public java.sql.Time getTime(int parameterIndex) throws java.sql.SQLException
getTime
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getTime(int)
public java.sql.Time getTime(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException
getTime
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getTime(int, java.util.Calendar)
public java.sql.Time getTime(java.lang.String parameterName) throws java.sql.SQLException
getTime
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getTime(java.lang.String)
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
CallableStatement.getTime(java.lang.String,
java.util.Calendar)
public java.sql.Timestamp getTimestamp(int parameterIndex) throws java.sql.SQLException
getTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getTimestamp(int)
public java.sql.Timestamp getTimestamp(int parameterIndex, java.util.Calendar cal) throws java.sql.SQLException
getTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getTimestamp(int, java.util.Calendar)
public java.sql.Timestamp getTimestamp(java.lang.String parameterName) throws java.sql.SQLException
getTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getTimestamp(java.lang.String)
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
CallableStatement.getTimestamp(java.lang.String,
java.util.Calendar)
public java.net.URL getURL(int parameterIndex) throws java.sql.SQLException
getURL
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getURL(int)
public java.net.URL getURL(java.lang.String parameterName) throws java.sql.SQLException
getURL
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.getURL(java.lang.String)
protected int mapOutputParameterIndexToRsIndex(int paramIndex) throws java.sql.SQLException
java.sql.SQLException
public void registerOutParameter(int parameterIndex, int sqlType) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.registerOutParameter(int, int)
public void registerOutParameter(int parameterIndex, int sqlType, int scale) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.registerOutParameter(int, int, int)
public void registerOutParameter(int parameterIndex, int sqlType, java.lang.String typeName) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.registerOutParameter(int, int,
java.lang.String)
public void registerOutParameter(java.lang.String parameterName, int sqlType) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.registerOutParameter(java.lang.String,
int)
public void registerOutParameter(java.lang.String parameterName, int sqlType, int scale) throws java.sql.SQLException
registerOutParameter
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.registerOutParameter(java.lang.String,
int, int)
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
CallableStatement.registerOutParameter(java.lang.String,
int, java.lang.String)
public void setAsciiStream(java.lang.String parameterName, java.io.InputStream x, int length) throws java.sql.SQLException
setAsciiStream
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.setAsciiStream(java.lang.String,
java.io.InputStream, int)
public void setBigDecimal(java.lang.String parameterName, java.math.BigDecimal x) throws java.sql.SQLException
setBigDecimal
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.setBigDecimal(java.lang.String,
java.math.BigDecimal)
public void setBinaryStream(java.lang.String parameterName, java.io.InputStream x, int length) throws java.sql.SQLException
setBinaryStream
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.setBinaryStream(java.lang.String,
java.io.InputStream, int)
public void setBoolean(java.lang.String parameterName, boolean x) throws java.sql.SQLException
setBoolean
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.setBoolean(java.lang.String, boolean)
public void setByte(java.lang.String parameterName, byte x) throws java.sql.SQLException
setByte
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.setByte(java.lang.String, byte)
public void setBytes(java.lang.String parameterName, byte[] x) throws java.sql.SQLException
setBytes
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.setBytes(java.lang.String, byte[])
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
CallableStatement.setCharacterStream(java.lang.String,
java.io.Reader, int)
public void setDate(java.lang.String parameterName, java.sql.Date x) throws java.sql.SQLException
setDate
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.setDate(java.lang.String, java.sql.Date)
public void setDate(java.lang.String parameterName, java.sql.Date x, java.util.Calendar cal) throws java.sql.SQLException
setDate
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.setDate(java.lang.String, java.sql.Date,
java.util.Calendar)
public void setDouble(java.lang.String parameterName, double x) throws java.sql.SQLException
setDouble
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.setDouble(java.lang.String, double)
public void setFloat(java.lang.String parameterName, float x) throws java.sql.SQLException
setFloat
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.setFloat(java.lang.String, float)
public void setInt(java.lang.String parameterName, int x) throws java.sql.SQLException
setInt
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.setInt(java.lang.String, int)
public void setLong(java.lang.String parameterName, long x) throws java.sql.SQLException
setLong
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.setLong(java.lang.String, long)
public void setNull(java.lang.String parameterName, int sqlType) throws java.sql.SQLException
setNull
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.setNull(java.lang.String, int)
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
CallableStatement.setNull(java.lang.String, int,
java.lang.String)
public void setObject(java.lang.String parameterName, java.lang.Object x) throws java.sql.SQLException
setObject
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.setObject(java.lang.String,
java.lang.Object)
public void setObject(java.lang.String parameterName, java.lang.Object x, int targetSqlType) throws java.sql.SQLException
setObject
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.setObject(java.lang.String,
java.lang.Object, int)
public void setObject(java.lang.String parameterName, java.lang.Object x, int targetSqlType, int scale) throws java.sql.SQLException
setObject
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.setObject(java.lang.String,
java.lang.Object, int, int)
public void setShort(java.lang.String parameterName, short x) throws java.sql.SQLException
setShort
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.setShort(java.lang.String, short)
public void setString(java.lang.String parameterName, java.lang.String x) throws java.sql.SQLException
setString
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.setString(java.lang.String,
java.lang.String)
public void setTime(java.lang.String parameterName, java.sql.Time x) throws java.sql.SQLException
setTime
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.setTime(java.lang.String, java.sql.Time)
public void setTime(java.lang.String parameterName, java.sql.Time x, java.util.Calendar cal) throws java.sql.SQLException
setTime
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.setTime(java.lang.String, java.sql.Time,
java.util.Calendar)
public void setTimestamp(java.lang.String parameterName, java.sql.Timestamp x) throws java.sql.SQLException
setTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.setTimestamp(java.lang.String,
java.sql.Timestamp)
public void setTimestamp(java.lang.String parameterName, java.sql.Timestamp x, java.util.Calendar cal) throws java.sql.SQLException
setTimestamp
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.setTimestamp(java.lang.String,
java.sql.Timestamp, java.util.Calendar)
public void setURL(java.lang.String parameterName, java.net.URL val) throws java.sql.SQLException
setURL
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.setURL(java.lang.String, java.net.URL)
public boolean wasNull() throws java.sql.SQLException
wasNull
in interface java.sql.CallableStatement
java.sql.SQLException
CallableStatement.wasNull()
public int[] executeBatch() throws java.sql.SQLException
PreparedStatement
executeBatch
in interface java.sql.Statement
executeBatch
in class PreparedStatement
java.sql.SQLException
- if a database-access error occurs, or the driver does not
support batch statements
java.sql.BatchUpdateException
- DOCUMENT ME!protected int getParameterIndexOffset()
PreparedStatement
getParameterIndexOffset
in class PreparedStatement
public void setAsciiStream(java.lang.String parameterName, java.io.InputStream x) throws java.sql.SQLException
setAsciiStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setAsciiStream(java.lang.String parameterName, java.io.InputStream x, long length) throws java.sql.SQLException
setAsciiStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setBinaryStream(java.lang.String parameterName, java.io.InputStream x) throws java.sql.SQLException
setBinaryStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setBinaryStream(java.lang.String parameterName, java.io.InputStream x, long length) throws java.sql.SQLException
setBinaryStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setBlob(java.lang.String parameterName, java.sql.Blob x) 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 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 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, long length) throws java.sql.SQLException
setCharacterStream
in interface java.sql.CallableStatement
java.sql.SQLException
public void setClob(java.lang.String parameterName, java.sql.Clob x) 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 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 setNCharacterStream(java.lang.String parameterName, java.io.Reader value) throws java.sql.SQLException
setNCharacterStream
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
protected boolean checkReadOnlySafeStatement() throws java.sql.SQLException
PreparedStatement
checkReadOnlySafeStatement
in class PreparedStatement
java.sql.SQLException
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |