public class SpyPreparedStatement extends SpyStatement implements PreparedStatement
| Modifier and Type | Field and Description |
|---|---|
protected PreparedStatement |
pstm |
protected String |
sql |
conn, stats, stmCLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO| Constructor and Description |
|---|
SpyPreparedStatement(SpyConnection conn,
SpyStats stats,
String sql,
PreparedStatement pstm) |
| Modifier and Type | Method and Description |
|---|---|
void |
addBatch() |
void |
clearParameters() |
boolean |
execute() |
int[] |
executeBatch() |
ResultSet |
executeQuery() |
int |
executeUpdate() |
ResultSetMetaData |
getMetaData() |
ParameterMetaData |
getParameterMetaData() |
void |
setArray(int parameterIndex,
Array x) |
void |
setAsciiStream(int i,
InputStream inputStream) |
void |
setAsciiStream(int parameterIndex,
InputStream x,
int length) |
void |
setAsciiStream(int i,
InputStream inputStream,
long l) |
void |
setBigDecimal(int parameterIndex,
BigDecimal x) |
void |
setBinaryStream(int i,
InputStream inputStream) |
void |
setBinaryStream(int parameterIndex,
InputStream x,
int length) |
void |
setBinaryStream(int i,
InputStream inputStream,
long l) |
void |
setBlob(int parameterIndex,
Blob x) |
void |
setBlob(int i,
InputStream inputStream) |
void |
setBlob(int i,
InputStream inputStream,
long l) |
void |
setBoolean(int parameterIndex,
boolean x) |
void |
setByte(int parameterIndex,
byte x) |
void |
setBytes(int parameterIndex,
byte[] x) |
void |
setCharacterStream(int i,
Reader reader) |
void |
setCharacterStream(int parameterIndex,
Reader x,
int length) |
void |
setCharacterStream(int i,
Reader reader,
long l) |
void |
setClob(int parameterIndex,
Clob x) |
void |
setClob(int i,
Reader reader) |
void |
setClob(int i,
Reader reader,
long l) |
void |
setDate(int parameterIndex,
Date x) |
void |
setDate(int parameterIndex,
Date x,
Calendar cal) |
void |
setDouble(int parameterIndex,
double x) |
void |
setFloat(int parameterIndex,
float x) |
void |
setInt(int parameterIndex,
int x) |
void |
setLong(int parameterIndex,
long x) |
void |
setNCharacterStream(int i,
Reader reader) |
void |
setNCharacterStream(int i,
Reader reader,
long l) |
void |
setNClob(int i,
NClob nClob) |
void |
setNClob(int i,
Reader reader) |
void |
setNClob(int i,
Reader reader,
long l) |
void |
setNString(int i,
String s) |
void |
setNull(int parameterIndex,
int sqlType) |
void |
setNull(int parameterIndex,
int sqlType,
String typeName) |
void |
setObject(int parameterIndex,
Object x) |
void |
setObject(int parameterIndex,
Object x,
int targetSqlType) |
void |
setObject(int parameterIndex,
Object x,
int targetSqlType,
int scale) |
void |
setRef(int parameterIndex,
Ref x) |
void |
setRowId(int i,
RowId rowId) |
void |
setShort(int parameterIndex,
short x) |
void |
setSQLXML(int i,
SQLXML sqlxml) |
void |
setString(int parameterIndex,
String x) |
void |
setTime(int parameterIndex,
Time x) |
void |
setTime(int parameterIndex,
Time x,
Calendar cal) |
void |
setTimestamp(int parameterIndex,
Timestamp x) |
void |
setTimestamp(int parameterIndex,
Timestamp x,
Calendar cal) |
void |
setUnicodeStream(int parameterIndex,
InputStream x,
int length) |
void |
setURL(int parameterIndex,
URL x) |
addBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, execute, execute, execute, execute, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getObject, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isWrapperFor, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, unwrapclone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, waitexecuteLargeUpdate, setObject, setObjectaddBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, execute, execute, execute, execute, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeoutisWrapperFor, unwrapprotected PreparedStatement pstm
protected String sql
public SpyPreparedStatement(SpyConnection conn, SpyStats stats, String sql, PreparedStatement pstm)
public int executeUpdate()
throws SQLException
executeUpdate in interface PreparedStatementSQLExceptionpublic void addBatch()
throws SQLException
addBatch in interface PreparedStatementSQLExceptionpublic int[] executeBatch()
throws SQLException
executeBatch in interface StatementexecuteBatch in class SpyStatementSQLExceptionpublic void clearParameters()
throws SQLException
clearParameters in interface PreparedStatementSQLExceptionpublic boolean execute()
throws SQLException
execute in interface PreparedStatementSQLExceptionpublic void setByte(int parameterIndex,
byte x)
throws SQLException
setByte in interface PreparedStatementSQLExceptionpublic void setDouble(int parameterIndex,
double x)
throws SQLException
setDouble in interface PreparedStatementSQLExceptionpublic void setFloat(int parameterIndex,
float x)
throws SQLException
setFloat in interface PreparedStatementSQLExceptionpublic void setInt(int parameterIndex,
int x)
throws SQLException
setInt in interface PreparedStatementSQLExceptionpublic void setNull(int parameterIndex,
int sqlType)
throws SQLException
setNull in interface PreparedStatementSQLExceptionpublic void setLong(int parameterIndex,
long x)
throws SQLException
setLong in interface PreparedStatementSQLExceptionpublic void setShort(int parameterIndex,
short x)
throws SQLException
setShort in interface PreparedStatementSQLExceptionpublic void setBoolean(int parameterIndex,
boolean x)
throws SQLException
setBoolean in interface PreparedStatementSQLExceptionpublic void setBytes(int parameterIndex,
byte[] x)
throws SQLException
setBytes in interface PreparedStatementSQLExceptionpublic void setAsciiStream(int parameterIndex,
InputStream x,
int length)
throws SQLException
setAsciiStream in interface PreparedStatementSQLExceptionpublic void setBinaryStream(int parameterIndex,
InputStream x,
int length)
throws SQLException
setBinaryStream in interface PreparedStatementSQLExceptionpublic void setUnicodeStream(int parameterIndex,
InputStream x,
int length)
throws SQLException
setUnicodeStream in interface PreparedStatementSQLExceptionpublic void setCharacterStream(int parameterIndex,
Reader x,
int length)
throws SQLException
setCharacterStream in interface PreparedStatementSQLExceptionpublic void setObject(int parameterIndex,
Object x)
throws SQLException
setObject in interface PreparedStatementSQLExceptionpublic void setObject(int parameterIndex,
Object x,
int targetSqlType)
throws SQLException
setObject in interface PreparedStatementSQLExceptionpublic void setObject(int parameterIndex,
Object x,
int targetSqlType,
int scale)
throws SQLException
setObject in interface PreparedStatementSQLExceptionpublic void setNull(int parameterIndex,
int sqlType,
String typeName)
throws SQLException
setNull in interface PreparedStatementSQLExceptionpublic void setString(int parameterIndex,
String x)
throws SQLException
setString in interface PreparedStatementSQLExceptionpublic void setBigDecimal(int parameterIndex,
BigDecimal x)
throws SQLException
setBigDecimal in interface PreparedStatementSQLExceptionpublic void setArray(int parameterIndex,
Array x)
throws SQLException
setArray in interface PreparedStatementSQLExceptionpublic void setBlob(int parameterIndex,
Blob x)
throws SQLException
setBlob in interface PreparedStatementSQLExceptionpublic void setClob(int parameterIndex,
Clob x)
throws SQLException
setClob in interface PreparedStatementSQLExceptionpublic void setDate(int parameterIndex,
Date x)
throws SQLException
setDate in interface PreparedStatementSQLExceptionpublic void setRef(int parameterIndex,
Ref x)
throws SQLException
setRef in interface PreparedStatementSQLExceptionpublic ResultSet executeQuery() throws SQLException
executeQuery in interface PreparedStatementSQLExceptionpublic ResultSetMetaData getMetaData() throws SQLException
getMetaData in interface PreparedStatementSQLExceptionpublic void setTime(int parameterIndex,
Time x)
throws SQLException
setTime in interface PreparedStatementSQLExceptionpublic void setTimestamp(int parameterIndex,
Timestamp x)
throws SQLException
setTimestamp in interface PreparedStatementSQLExceptionpublic void setDate(int parameterIndex,
Date x,
Calendar cal)
throws SQLException
setDate in interface PreparedStatementSQLExceptionpublic void setTime(int parameterIndex,
Time x,
Calendar cal)
throws SQLException
setTime in interface PreparedStatementSQLExceptionpublic void setTimestamp(int parameterIndex,
Timestamp x,
Calendar cal)
throws SQLException
setTimestamp in interface PreparedStatementSQLExceptionpublic ParameterMetaData getParameterMetaData() throws SQLException
getParameterMetaData in interface PreparedStatementSQLExceptionpublic void setURL(int parameterIndex,
URL x)
throws SQLException
setURL in interface PreparedStatementSQLExceptionpublic void setAsciiStream(int i,
InputStream inputStream,
long l)
throws SQLException
setAsciiStream in interface PreparedStatementSQLExceptionpublic void setBinaryStream(int i,
InputStream inputStream,
long l)
throws SQLException
setBinaryStream in interface PreparedStatementSQLExceptionpublic void setCharacterStream(int i,
Reader reader,
long l)
throws SQLException
setCharacterStream in interface PreparedStatementSQLExceptionpublic void setAsciiStream(int i,
InputStream inputStream)
throws SQLException
setAsciiStream in interface PreparedStatementSQLExceptionpublic void setBinaryStream(int i,
InputStream inputStream)
throws SQLException
setBinaryStream in interface PreparedStatementSQLExceptionpublic void setCharacterStream(int i,
Reader reader)
throws SQLException
setCharacterStream in interface PreparedStatementSQLExceptionpublic void setNCharacterStream(int i,
Reader reader)
throws SQLException
setNCharacterStream in interface PreparedStatementSQLExceptionpublic void setClob(int i,
Reader reader)
throws SQLException
setClob in interface PreparedStatementSQLExceptionpublic void setBlob(int i,
InputStream inputStream)
throws SQLException
setBlob in interface PreparedStatementSQLExceptionpublic void setNClob(int i,
Reader reader)
throws SQLException
setNClob in interface PreparedStatementSQLExceptionpublic void setRowId(int i,
RowId rowId)
throws SQLException
setRowId in interface PreparedStatementSQLExceptionpublic void setNString(int i,
String s)
throws SQLException
setNString in interface PreparedStatementSQLExceptionpublic void setNCharacterStream(int i,
Reader reader,
long l)
throws SQLException
setNCharacterStream in interface PreparedStatementSQLExceptionpublic void setNClob(int i,
NClob nClob)
throws SQLException
setNClob in interface PreparedStatementSQLExceptionpublic void setClob(int i,
Reader reader,
long l)
throws SQLException
setClob in interface PreparedStatementSQLExceptionpublic void setBlob(int i,
InputStream inputStream,
long l)
throws SQLException
setBlob in interface PreparedStatementSQLExceptionpublic void setNClob(int i,
Reader reader,
long l)
throws SQLException
setNClob in interface PreparedStatementSQLExceptionpublic void setSQLXML(int i,
SQLXML sqlxml)
throws SQLException
setSQLXML in interface PreparedStatementSQLException