public class CallableStatement extends PreparedStatement implements java.sql.CallableStatement
| Modifier and Type | Class and Description |
|---|---|
protected static 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?)
|
PreparedStatement.AppendingBatchVisitor, PreparedStatement.BatchParams, PreparedStatement.BatchVisitor, PreparedStatement.EmulatedPreparedStatementBindings, PreparedStatement.EndPoint, PreparedStatement.ParseInfoStatementImpl.CancelTask| Modifier and Type | Field and Description |
|---|---|
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 |
batchCommandIndex, batchedValuesClause, batchHasPlainStatements, firstCharOfStmt, isLoadDataQuery, isNull, numberOfExecutions, originalSql, parameterCount, parameterMetaData, parameterTypes, parseInfo, rewrittenBatchSize, serverSupportsFracSecs, useTrueBoolean, usingAnsiModebatchedArgs, batchedGeneratedKeys, cancelTimeoutMutex, charConverter, charEncoding, clearWarningsCalled, connection, connectionId, continueBatchOnError, currentCatalog, doEscapeProcessing, eventSink, generatedKeysResults, holdResultsOpenOverClose, isClosed, lastInsertId, lastQueryIsOnDupKeyUpdate, maxFieldSize, maxRows, ON_DUPLICATE_KEY_UPDATE_CLAUSE, openResults, pedantic, PING_MARKER, pingTarget, pointOfOrigin, profileSQL, results, resultSetConcurrency, resultSetType, retrieveGeneratedKeys, statementCounter, statementExecuting, statementId, timeoutInMillis, updateCount, useLegacyDatetimeCode, USES_VARIABLES_FALSE, USES_VARIABLES_TRUE, USES_VARIABLES_UNKNOWN, useUsageAdvisor, version5013OrNewer, warningChain, wasCancelled, wasCancelledByTimeout| Constructor and Description |
|---|
CallableStatement(MySQLConnection conn,
CallableStatement.CallableStatementParamInfo paramInfo)
Creates a new CallableStatement
|
CallableStatement(MySQLConnection conn,
java.lang.String sql,
java.lang.String catalog,
boolean isFunctionCall)
Creates a new CallableStatement
|
| Modifier and Type | Method and Description |
|---|---|
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(MySQLConnection 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(MySQLConnection 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) |
<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 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() |
addBatch, asSql, asSql, canRewrite, canRewriteAsMultiValueInsertAtSqlLevel, checkBounds, clearBatch, computeBatchSize, computeMaxParameterSetSizeAndBatchSize, containsOnDuplicateKeyUpdateInSQL, detectFractionalSecondsSupport, executeBatchedInserts, executeBatchSerially, executeInternal, executePreparedBatchAsMultiStatement, executeUpdate, executeUpdate, fillSendPacket, fillSendPacket, getBytesRepresentation, getBytesRepresentationForBatch, getDateTime, getInstance, getInstance, getInstance, getLocationOfOnDuplicateKeyUpdate, getMetaData, getNonRewrittenSql, getParameterBindings, getParseInfo, getPreparedSql, getRewrittenBatchSize, getUpdateCount, getValuesClause, isNull, isSelectQuery, prepareBatchedInsertSQL, readFully, realClose, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setBytes, setBytesNoEscape, setBytesNoEscapeNoQuotes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDouble, setFloat, setInt, setInternal, setInternal, setLong, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNString, setNull, setNull, setObject, setObject, setObject, setOneBatchedParameterSet, setRef, setRetrieveGeneratedKeys, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL, toStringcancel, checkClosed, checkForDml, checkNullOrEmptyQuery, clearWarnings, close, closeAllOpenResults, closeOnCompletion, containsOnDuplicateKeyInString, createStreamingResultSet, disableStreamingResults, doPingInstead, enableStreamingResults, execute, execute, execute, execute, executeQuery, executeSimpleNonQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, executeUpdate, findStartOfStatement, generatePingResultSet, getBatchedArgs, getBatchedGeneratedKeys, getBatchedGeneratedKeys, getCalendarInstanceForSessionOrNew, getConnection, getExceptionInterceptor, getFetchDirection, getFetchSize, getGeneratedKeys, getGeneratedKeysInternal, getGeneratedKeysInternal, getId, getLastInsertID, getLocalInfileInputStream, getLongUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getOnDuplicateKeyLocation, getOpenResultSetCount, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetInternal, getResultSetType, getWarnings, handleExceptionForBatch, hasDeadlockOrTimeoutRolledBackTx, implicitlyCloseAllOpenResults, isClosed, isCloseOnCompletion, isPoolable, isWrapperFor, processMultiCountsAndKeys, removeOpenResultSet, resetCancelledState, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setHoldResultsOpenOverClose, setLocalInfileInputStream, setMaxFieldSize, setMaxRows, setPingTarget, setPoolable, setQueryTimeout, setResultSetConcurrency, setResultSetType, setupStreamingTimeout, statementBegins, unwrapclone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, waitgetCharacterStream, getCharacterStream, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getRowId, getRowId, getSQLXML, getSQLXML, setNClob, setNClob, setNClob, setNString, setRowId, setSQLXMLgetMetaData, 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, setURLaddBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, 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, isCloseOnCompletion, isPoolable, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeoutprotected 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
public CallableStatement(MySQLConnection conn, CallableStatement.CallableStatementParamInfo paramInfo) throws java.sql.SQLException
conn - the connection creating this statementparamInfo - the SQL to preparejava.sql.SQLException - if an error occurspublic CallableStatement(MySQLConnection 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 catalogjava.sql.SQLException - if an error occursprotected static CallableStatement getInstance(MySQLConnection conn, java.lang.String sql, java.lang.String catalog, boolean isFunctionCall) throws java.sql.SQLException
java.sql.SQLExceptionprotected static CallableStatement getInstance(MySQLConnection conn, CallableStatement.CallableStatementParamInfo paramInfo) throws java.sql.SQLException
java.sql.SQLExceptionpublic void addBatch()
throws java.sql.SQLException
PreparedStatementaddBatch in interface java.sql.PreparedStatementaddBatch in class PreparedStatementjava.sql.SQLException - if a database-access error occurs.StatementImpl.addBatch(java.lang.String)public void clearParameters()
throws java.sql.SQLException
PreparedStatementclearParameters in interface java.sql.PreparedStatementclearParameters in class PreparedStatementjava.sql.SQLException - if a database access error occurspublic boolean execute()
throws java.sql.SQLException
PreparedStatementexecute in interface java.sql.PreparedStatementexecute in class PreparedStatementjava.sql.SQLException - if a database access error occurspublic java.sql.ResultSet executeQuery()
throws java.sql.SQLException
PreparedStatementexecuteQuery in interface java.sql.PreparedStatementexecuteQuery in class PreparedStatementjava.sql.SQLException - if a database access error occurspublic int executeUpdate()
throws java.sql.SQLException
PreparedStatementexecuteUpdate in interface java.sql.PreparedStatementexecuteUpdate in class PreparedStatementjava.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.CallableStatementjava.sql.SQLExceptionCallableStatement.getArray(int)public java.sql.Array getArray(java.lang.String parameterName)
throws java.sql.SQLException
getArray in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getArray(java.lang.String)public java.math.BigDecimal getBigDecimal(int parameterIndex)
throws java.sql.SQLException
getBigDecimal in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getBigDecimal(int)@Deprecated
public java.math.BigDecimal getBigDecimal(int parameterIndex,
int scale)
throws java.sql.SQLException
getBigDecimal in interface java.sql.CallableStatementparameterIndex - scale - java.sql.SQLExceptionCallableStatement.getBigDecimal(int, int)public java.math.BigDecimal getBigDecimal(java.lang.String parameterName)
throws java.sql.SQLException
getBigDecimal in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getBigDecimal(java.lang.String)public java.sql.Blob getBlob(int parameterIndex)
throws java.sql.SQLException
getBlob in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getBlob(int)public java.sql.Blob getBlob(java.lang.String parameterName)
throws java.sql.SQLException
getBlob in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getBlob(java.lang.String)public boolean getBoolean(int parameterIndex)
throws java.sql.SQLException
getBoolean in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getBoolean(int)public boolean getBoolean(java.lang.String parameterName)
throws java.sql.SQLException
getBoolean in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getBoolean(java.lang.String)public byte getByte(int parameterIndex)
throws java.sql.SQLException
getByte in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getByte(int)public byte getByte(java.lang.String parameterName)
throws java.sql.SQLException
getByte in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getByte(java.lang.String)public byte[] getBytes(int parameterIndex)
throws java.sql.SQLException
getBytes in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getBytes(int)public byte[] getBytes(java.lang.String parameterName)
throws java.sql.SQLException
getBytes in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getBytes(java.lang.String)public java.sql.Clob getClob(int parameterIndex)
throws java.sql.SQLException
getClob in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getClob(int)public java.sql.Clob getClob(java.lang.String parameterName)
throws java.sql.SQLException
getClob in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getClob(java.lang.String)public java.sql.Date getDate(int parameterIndex)
throws java.sql.SQLException
getDate in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getDate(int)public java.sql.Date getDate(int parameterIndex,
java.util.Calendar cal)
throws java.sql.SQLException
getDate in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getDate(int, java.util.Calendar)public java.sql.Date getDate(java.lang.String parameterName)
throws java.sql.SQLException
getDate in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.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.CallableStatementjava.sql.SQLExceptionCallableStatement.getDate(java.lang.String, java.util.Calendar)public double getDouble(int parameterIndex)
throws java.sql.SQLException
getDouble in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getDouble(int)public double getDouble(java.lang.String parameterName)
throws java.sql.SQLException
getDouble in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getDouble(java.lang.String)public float getFloat(int parameterIndex)
throws java.sql.SQLException
getFloat in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getFloat(int)public float getFloat(java.lang.String parameterName)
throws java.sql.SQLException
getFloat in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getFloat(java.lang.String)public int getInt(int parameterIndex)
throws java.sql.SQLException
getInt in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getInt(int)public int getInt(java.lang.String parameterName)
throws java.sql.SQLException
getInt in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getInt(java.lang.String)public long getLong(int parameterIndex)
throws java.sql.SQLException
getLong in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getLong(int)public long getLong(java.lang.String parameterName)
throws java.sql.SQLException
getLong in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getLong(java.lang.String)protected int getNamedParamIndex(java.lang.String paramName,
boolean forOut)
throws java.sql.SQLException
java.sql.SQLExceptionpublic java.lang.Object getObject(int parameterIndex)
throws java.sql.SQLException
getObject in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getObject(int)public java.lang.Object getObject(int parameterIndex,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
throws java.sql.SQLException
getObject in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getObject(int, java.util.Map)public java.lang.Object getObject(java.lang.String parameterName)
throws java.sql.SQLException
getObject in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getObject(java.lang.String)public java.lang.Object getObject(java.lang.String parameterName,
java.util.Map<java.lang.String,java.lang.Class<?>> map)
throws java.sql.SQLException
getObject in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getObject(java.lang.String, java.util.Map)public <T> T getObject(int parameterIndex,
java.lang.Class<T> type)
throws java.sql.SQLException
getObject in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic <T> T getObject(java.lang.String parameterName,
java.lang.Class<T> type)
throws java.sql.SQLException
getObject in interface java.sql.CallableStatementjava.sql.SQLExceptionprotected 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.PreparedStatementgetParameterMetaData in class PreparedStatementjava.sql.SQLExceptionPreparedStatement.getParameterMetaData()public java.sql.Ref getRef(int parameterIndex)
throws java.sql.SQLException
getRef in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getRef(int)public java.sql.Ref getRef(java.lang.String parameterName)
throws java.sql.SQLException
getRef in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getRef(java.lang.String)public short getShort(int parameterIndex)
throws java.sql.SQLException
getShort in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getShort(int)public short getShort(java.lang.String parameterName)
throws java.sql.SQLException
getShort in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getShort(java.lang.String)public java.lang.String getString(int parameterIndex)
throws java.sql.SQLException
getString in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getString(int)public java.lang.String getString(java.lang.String parameterName)
throws java.sql.SQLException
getString in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getString(java.lang.String)public java.sql.Time getTime(int parameterIndex)
throws java.sql.SQLException
getTime in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getTime(int)public java.sql.Time getTime(int parameterIndex,
java.util.Calendar cal)
throws java.sql.SQLException
getTime in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getTime(int, java.util.Calendar)public java.sql.Time getTime(java.lang.String parameterName)
throws java.sql.SQLException
getTime in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.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.CallableStatementjava.sql.SQLExceptionCallableStatement.getTime(java.lang.String, java.util.Calendar)public java.sql.Timestamp getTimestamp(int parameterIndex)
throws java.sql.SQLException
getTimestamp in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getTimestamp(int)public java.sql.Timestamp getTimestamp(int parameterIndex,
java.util.Calendar cal)
throws java.sql.SQLException
getTimestamp in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getTimestamp(int, java.util.Calendar)public java.sql.Timestamp getTimestamp(java.lang.String parameterName)
throws java.sql.SQLException
getTimestamp in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.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.CallableStatementjava.sql.SQLExceptionCallableStatement.getTimestamp(java.lang.String, java.util.Calendar)public java.net.URL getURL(int parameterIndex)
throws java.sql.SQLException
getURL in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getURL(int)public java.net.URL getURL(java.lang.String parameterName)
throws java.sql.SQLException
getURL in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.getURL(java.lang.String)protected int mapOutputParameterIndexToRsIndex(int paramIndex)
throws java.sql.SQLException
java.sql.SQLExceptionpublic void registerOutParameter(int parameterIndex,
int sqlType)
throws java.sql.SQLException
registerOutParameter in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.registerOutParameter(int, int)public void registerOutParameter(int parameterIndex,
int sqlType,
int scale)
throws java.sql.SQLException
registerOutParameter in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.registerOutParameter(int, int, int)public void registerOutParameter(int parameterIndex,
int sqlType,
java.lang.String typeName)
throws java.sql.SQLException
registerOutParameter in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.registerOutParameter(int, int, java.lang.String)public void registerOutParameter(java.lang.String parameterName,
int sqlType)
throws java.sql.SQLException
registerOutParameter in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.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.CallableStatementjava.sql.SQLExceptionCallableStatement.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.CallableStatementjava.sql.SQLExceptionCallableStatement.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.CallableStatementjava.sql.SQLExceptionCallableStatement.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.CallableStatementjava.sql.SQLExceptionCallableStatement.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.CallableStatementjava.sql.SQLExceptionCallableStatement.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.CallableStatementjava.sql.SQLExceptionCallableStatement.setBoolean(java.lang.String, boolean)public void setByte(java.lang.String parameterName,
byte x)
throws java.sql.SQLException
setByte in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.setByte(java.lang.String, byte)public void setBytes(java.lang.String parameterName,
byte[] x)
throws java.sql.SQLException
setBytes in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.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.CallableStatementjava.sql.SQLExceptionCallableStatement.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.CallableStatementjava.sql.SQLExceptionCallableStatement.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.CallableStatementjava.sql.SQLExceptionCallableStatement.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.CallableStatementjava.sql.SQLExceptionCallableStatement.setDouble(java.lang.String, double)public void setFloat(java.lang.String parameterName,
float x)
throws java.sql.SQLException
setFloat in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.setFloat(java.lang.String, float)public void setInt(java.lang.String parameterName,
int x)
throws java.sql.SQLException
setInt in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.setInt(java.lang.String, int)public void setLong(java.lang.String parameterName,
long x)
throws java.sql.SQLException
setLong in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.setLong(java.lang.String, long)public void setNull(java.lang.String parameterName,
int sqlType)
throws java.sql.SQLException
setNull in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.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.CallableStatementjava.sql.SQLExceptionCallableStatement.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.CallableStatementjava.sql.SQLExceptionCallableStatement.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.CallableStatementjava.sql.SQLExceptionCallableStatement.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.CallableStatementjava.sql.SQLExceptionCallableStatement.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.CallableStatementjava.sql.SQLExceptionCallableStatement.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.CallableStatementjava.sql.SQLExceptionCallableStatement.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.CallableStatementjava.sql.SQLExceptionCallableStatement.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.CallableStatementjava.sql.SQLExceptionCallableStatement.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.CallableStatementjava.sql.SQLExceptionCallableStatement.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.CallableStatementjava.sql.SQLExceptionCallableStatement.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.CallableStatementjava.sql.SQLExceptionCallableStatement.setURL(java.lang.String, java.net.URL)public boolean wasNull()
throws java.sql.SQLException
wasNull in interface java.sql.CallableStatementjava.sql.SQLExceptionCallableStatement.wasNull()public int[] executeBatch()
throws java.sql.SQLException
PreparedStatementexecuteBatch in interface java.sql.StatementexecuteBatch in class PreparedStatementjava.sql.SQLException - if a database-access error occurs, or the driver does not
support batch statementsjava.sql.BatchUpdateExceptionprotected int getParameterIndexOffset()
PreparedStatementgetParameterIndexOffset in class PreparedStatementpublic void setAsciiStream(java.lang.String parameterName,
java.io.InputStream x)
throws java.sql.SQLException
setAsciiStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setAsciiStream(java.lang.String parameterName,
java.io.InputStream x,
long length)
throws java.sql.SQLException
setAsciiStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setBinaryStream(java.lang.String parameterName,
java.io.InputStream x)
throws java.sql.SQLException
setBinaryStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setBinaryStream(java.lang.String parameterName,
java.io.InputStream x,
long length)
throws java.sql.SQLException
setBinaryStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setBlob(java.lang.String parameterName,
java.sql.Blob x)
throws java.sql.SQLException
setBlob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setBlob(java.lang.String parameterName,
java.io.InputStream inputStream)
throws java.sql.SQLException
setBlob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setBlob(java.lang.String parameterName,
java.io.InputStream inputStream,
long length)
throws java.sql.SQLException
setBlob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setCharacterStream(java.lang.String parameterName,
java.io.Reader reader)
throws java.sql.SQLException
setCharacterStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setCharacterStream(java.lang.String parameterName,
java.io.Reader reader,
long length)
throws java.sql.SQLException
setCharacterStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setClob(java.lang.String parameterName,
java.sql.Clob x)
throws java.sql.SQLException
setClob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setClob(java.lang.String parameterName,
java.io.Reader reader)
throws java.sql.SQLException
setClob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setClob(java.lang.String parameterName,
java.io.Reader reader,
long length)
throws java.sql.SQLException
setClob in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setNCharacterStream(java.lang.String parameterName,
java.io.Reader value)
throws java.sql.SQLException
setNCharacterStream in interface java.sql.CallableStatementjava.sql.SQLExceptionpublic void setNCharacterStream(java.lang.String parameterName,
java.io.Reader value,
long length)
throws java.sql.SQLException
setNCharacterStream in interface java.sql.CallableStatementjava.sql.SQLExceptionprotected boolean checkReadOnlySafeStatement()
throws java.sql.SQLException
PreparedStatementcheckReadOnlySafeStatement in class PreparedStatementjava.sql.SQLException