|
MySQL Connector/J size='-1'>5.0.8 | ||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectcom.mysql.jdbc.Statement
com.mysql.jdbc.PreparedStatement
com.mysql.jdbc.CallableStatement
Representation of stored procedures for JDBC
Field Summary | |
protected com.mysql.jdbc.CallableStatement.CallableStatementParamInfo |
paramInfo
|
Fields inherited from class com.mysql.jdbc.PreparedStatement |
batchHasPlainStatements, firstCharOfStmt, hasLimitClause, isLoadDataQuery, numberOfExecutions, originalSql, parameterCount, parameterMetaData, useTrueBoolean |
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(Connection conn,
com.mysql.jdbc.CallableStatement.CallableStatementParamInfo paramInfo)
Creates a new CallableStatement |
|
CallableStatement(Connection conn,
java.lang.String catalog)
Creates a new CallableStatement |
|
CallableStatement(Connection 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. |
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. |
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)
|
int |
getInt(int parameterIndex)
|
int |
getInt(java.lang.String parameterName)
|
long |
getLong(int parameterIndex)
|
long |
getLong(java.lang.String parameterName)
|
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 int |
getParameterIndexOffset()
For calling stored functions, this will be -1 as we don't really count the first '?' parameter marker, it's only syntax, but JDBC counts it as #1, otherwise it will return 0 |
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)
|
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,
int length)
|
void |
setBigDecimal(java.lang.String parameterName,
java.math.BigDecimal x)
|
void |
setBinaryStream(java.lang.String parameterName,
java.io.InputStream x,
int 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,
int 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 |
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.PreparedStatement |
getMetaData, setArray, setAsciiStream, setBigDecimal, setBinaryStream, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNull, setNull, setObject, setObject, setObject, setRef, setShort, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL |
Methods inherited from interface java.sql.Statement |
addBatch, cancel, clearBatch, clearWarnings, close, execute, execute, execute, execute, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout |
Field Detail |
protected com.mysql.jdbc.CallableStatement.CallableStatementParamInfo paramInfo
Constructor Detail |
public CallableStatement(Connection conn, com.mysql.jdbc.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(Connection conn, java.lang.String catalog) throws java.sql.SQLException
conn
- the connection creating this statementcatalog
- catalog the current catalog
java.sql.SQLException
- if an error occurspublic CallableStatement(Connection 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 |
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.Statement.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 occurspublic 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)
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)
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)
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 statementsprotected int getParameterIndexOffset()
PreparedStatement
getParameterIndexOffset
in class PreparedStatement
|
MySQL Connector/J size='-1'>5.0.8 | ||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |