org.javasimon.jdbc4

Class SimonPreparedStatement

java.lang.Object

org.javasimon.jdbc4.SimonStatement

org.javasimon.jdbc4.SimonPreparedStatement

All Implemented Interfaces:

AutoCloseable, PreparedStatement, Statement, Wrapper

Direct Known Subclasses:

SimonCallableStatement

public class SimonPreparedStatement
extends SimonStatement
implements PreparedStatement

Simon JDBC proxy prepared statement implementation class.

Since:

2.4

Author:

Radovan Sninsky, Richard "Virgo" Richter

See Also:

PreparedStatement

Field Summary

Fields

Modifier and Type	Field and Description
protected String	sql SQL string.

Fields inherited from class org.javasimon.jdbc4.SimonStatement

batchSql, conn, prefix, split, sqlCmdLabel, sqlNormalizer

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

Method Summary

Modifier and Type	Method and Description
void	addBatch() Adds prepared SQL command into batch list of sql and also into real batch.
void	clearParameters()
boolean	execute() Measure and execute prepared SQL operation.
ResultSet	executeQuery() Measure and execute prepared SQL operation.
int	executeUpdate() Measure and execute prepared SQL operation.
ResultSetMetaData	getMetaData()
ParameterMetaData	getParameterMetaData()
void	setArray(int i, Array array)
void	setAsciiStream(int i, InputStream inputStream)
void	setAsciiStream(int i, InputStream inputStream, int i1)
void	setAsciiStream(int i, InputStream inputStream, long l)
void	setBigDecimal(int i, BigDecimal bigDecimal)
void	setBinaryStream(int i, InputStream inputStream)
void	setBinaryStream(int i, InputStream inputStream, int i1)
void	setBinaryStream(int i, InputStream inputStream, long l)
void	setBlob(int i, Blob blob)
void	setBlob(int i, InputStream inputStream)
void	setBlob(int i, InputStream inputStream, long l)
void	setBoolean(int i, boolean b)
void	setByte(int i, byte b)
void	setBytes(int i, byte[] bytes)
void	setCharacterStream(int i, Reader reader)
void	setCharacterStream(int i, Reader reader, int i1)
void	setCharacterStream(int i, Reader reader, long l)
void	setClob(int i, Clob clob)
void	setClob(int i, Reader reader)
void	setClob(int i, Reader reader, long l)
void	setDate(int i, Date date)
void	setDate(int i, Date date, Calendar calendar)
void	setDouble(int i, double v)
void	setFloat(int i, float v)
void	setInt(int i, int i1)
void	setLong(int i, long l)
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 i, int i1)
void	setNull(int i, int i1, String s)
void	setObject(int i, Object o)
void	setObject(int i, Object o, int i1)
void	setObject(int i, Object o, int i1, int i2)
void	setRef(int i, Ref ref)
void	setRowId(int i, RowId rowId)
void	setShort(int i, short i1)
void	setSQLXML(int i, SQLXML sqlxml)
void	setString(int i, String s)
void	setTime(int i, Time time)
void	setTime(int i, Time time, Calendar calendar)
void	setTimestamp(int i, Timestamp timestamp)
void	setTimestamp(int i, Timestamp timestamp, Calendar calendar)
void	setUnicodeStream(int i, InputStream inputStream, int i1) Deprecated.
void	setURL(int i, URL url)

Methods inherited from class org.javasimon.jdbc4.SimonStatement

addBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, finish, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isWrapperFor, prepare, prepare, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, startSplit, unwrap

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface java.sql.PreparedStatement

executeLargeUpdate, setObject, setObject

Methods inherited from interface java.sql.Statement

addBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, execute, execute, execute, execute, executeBatch, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout

Methods inherited from interface java.sql.Wrapper

isWrapperFor, unwrap

Field Detail

sql

protected String sql

SQL string.

Method Detail

executeQuery

public final ResultSet executeQuery()
                             throws SQLException

Measure and execute prepared SQL operation.

Specified by:

executeQuery in interface PreparedStatement

Returns:

database rows and columns

Throws:

SQLException - if real calls fails

executeUpdate

public final int executeUpdate()
                        throws SQLException

Measure and execute prepared SQL operation.

Specified by:

executeUpdate in interface PreparedStatement

Returns:

count of updated rows

Throws:

SQLException - if real calls fails

execute

public final boolean execute()
                      throws SQLException

Measure and execute prepared SQL operation.

Specified by:

execute in interface PreparedStatement

Returns:

true if the first result is a ResultSet object; false if it is an update count or there are no results

Throws:

SQLException - if real calls fails

addBatch

public final void addBatch()
                    throws SQLException

Adds prepared SQL command into batch list of sql and also into real batch.

Specified by:

addBatch in interface PreparedStatement

Throws:

SQLException - if real calls fails

setNull

public final void setNull(int i,
                          int i1)
                   throws SQLException

Specified by:

setNull in interface PreparedStatement

Throws:

SQLException

setBoolean

public final void setBoolean(int i,
                             boolean b)
                      throws SQLException

Specified by:

setBoolean in interface PreparedStatement

Throws:

SQLException

setByte

public final void setByte(int i,
                          byte b)
                   throws SQLException

Specified by:

setByte in interface PreparedStatement

Throws:

SQLException

setShort

public final void setShort(int i,
                           short i1)
                    throws SQLException

Specified by:

setShort in interface PreparedStatement

Throws:

SQLException

setInt

public final void setInt(int i,
                         int i1)
                  throws SQLException

Specified by:

setInt in interface PreparedStatement

Throws:

SQLException

setLong

public final void setLong(int i,
                          long l)
                   throws SQLException

Specified by:

setLong in interface PreparedStatement

Throws:

SQLException

setFloat

public final void setFloat(int i,
                           float v)
                    throws SQLException

Specified by:

setFloat in interface PreparedStatement

Throws:

SQLException

setDouble

public final void setDouble(int i,
                            double v)
                     throws SQLException

Specified by:

setDouble in interface PreparedStatement

Throws:

SQLException

setBigDecimal

public final void setBigDecimal(int i,
                                BigDecimal bigDecimal)
                         throws SQLException

Specified by:

setBigDecimal in interface PreparedStatement

Throws:

SQLException

setString

public final void setString(int i,
                            String s)
                     throws SQLException

Specified by:

setString in interface PreparedStatement

Throws:

SQLException

setBytes

public final void setBytes(int i,
                           byte[] bytes)
                    throws SQLException

Specified by:

setBytes in interface PreparedStatement

Throws:

SQLException

setDate

public final void setDate(int i,
                          Date date)
                   throws SQLException

Specified by:

setDate in interface PreparedStatement

Throws:

SQLException

setTime

public final void setTime(int i,
                          Time time)
                   throws SQLException

Specified by:

setTime in interface PreparedStatement

Throws:

SQLException

setTimestamp

public final void setTimestamp(int i,
                               Timestamp timestamp)
                        throws SQLException

Specified by:

setTimestamp in interface PreparedStatement

Throws:

SQLException

setAsciiStream

public final void setAsciiStream(int i,
                                 InputStream inputStream,
                                 int i1)
                          throws SQLException

Specified by:

setAsciiStream in interface PreparedStatement

Throws:

SQLException

setUnicodeStream

@Deprecated
public final void setUnicodeStream(int i,
                                                InputStream inputStream,
                                                int i1)
                                         throws SQLException

Deprecated.

Specified by:

setUnicodeStream in interface PreparedStatement

Throws:

SQLException

setBinaryStream

public final void setBinaryStream(int i,
                                  InputStream inputStream,
                                  int i1)
                           throws SQLException

Specified by:

setBinaryStream in interface PreparedStatement

Throws:

SQLException

clearParameters

public final void clearParameters()
                           throws SQLException

Specified by:

clearParameters in interface PreparedStatement

Throws:

SQLException

setObject

public final void setObject(int i,
                            Object o,
                            int i1)
                     throws SQLException

Specified by:

setObject in interface PreparedStatement

Throws:

SQLException

setObject

public final void setObject(int i,
                            Object o)
                     throws SQLException

Specified by:

setObject in interface PreparedStatement

Throws:

SQLException

setObject

public final void setObject(int i,
                            Object o,
                            int i1,
                            int i2)
                     throws SQLException

Specified by:

setObject in interface PreparedStatement

Throws:

SQLException

setCharacterStream

public final void setCharacterStream(int i,
                                     Reader reader,
                                     int i1)
                              throws SQLException

Specified by:

setCharacterStream in interface PreparedStatement

Throws:

SQLException

setRef

public final void setRef(int i,
                         Ref ref)
                  throws SQLException

Specified by:

setRef in interface PreparedStatement

Throws:

SQLException

setBlob

public final void setBlob(int i,
                          Blob blob)
                   throws SQLException

Specified by:

setBlob in interface PreparedStatement

Throws:

SQLException

setClob

public final void setClob(int i,
                          Clob clob)
                   throws SQLException

Specified by:

setClob in interface PreparedStatement

Throws:

SQLException

setArray

public final void setArray(int i,
                           Array array)
                    throws SQLException

Specified by:

setArray in interface PreparedStatement

Throws:

SQLException

getMetaData

public final ResultSetMetaData getMetaData()
                                    throws SQLException

Specified by:

getMetaData in interface PreparedStatement

Throws:

SQLException

setDate

public final void setDate(int i,
                          Date date,
                          Calendar calendar)
                   throws SQLException

Specified by:

setDate in interface PreparedStatement

Throws:

SQLException

setTime

public final void setTime(int i,
                          Time time,
                          Calendar calendar)
                   throws SQLException

Specified by:

setTime in interface PreparedStatement

Throws:

SQLException

setTimestamp

public final void setTimestamp(int i,
                               Timestamp timestamp,
                               Calendar calendar)
                        throws SQLException

Specified by:

setTimestamp in interface PreparedStatement

Throws:

SQLException

setNull

public final void setNull(int i,
                          int i1,
                          String s)
                   throws SQLException

Specified by:

setNull in interface PreparedStatement

Throws:

SQLException

setURL

public final void setURL(int i,
                         URL url)
                  throws SQLException

Specified by:

setURL in interface PreparedStatement

Throws:

SQLException

getParameterMetaData

public final ParameterMetaData getParameterMetaData()
                                             throws SQLException

Specified by:

getParameterMetaData in interface PreparedStatement

Throws:

SQLException

setRowId

public final void setRowId(int i,
                           RowId rowId)
                    throws SQLException

Specified by:

setRowId in interface PreparedStatement

Throws:

SQLException

setNString

public final void setNString(int i,
                             String s)
                      throws SQLException

Specified by:

setNString in interface PreparedStatement

Throws:

SQLException

setNCharacterStream

public final void setNCharacterStream(int i,
                                      Reader reader,
                                      long l)
                               throws SQLException

Specified by:

setNCharacterStream in interface PreparedStatement

Throws:

SQLException

setNClob

public final void setNClob(int i,
                           NClob nClob)
                    throws SQLException

Specified by:

setNClob in interface PreparedStatement

Throws:

SQLException

setClob

public final void setClob(int i,
                          Reader reader,
                          long l)
                   throws SQLException

Specified by:

setClob in interface PreparedStatement

Throws:

SQLException

setBlob

public final void setBlob(int i,
                          InputStream inputStream,
                          long l)
                   throws SQLException

Specified by:

setBlob in interface PreparedStatement

Throws:

SQLException

setNClob

public final void setNClob(int i,
                           Reader reader,
                           long l)
                    throws SQLException

Specified by:

setNClob in interface PreparedStatement

Throws:

SQLException

setSQLXML

public final void setSQLXML(int i,
                            SQLXML sqlxml)
                     throws SQLException

Specified by:

setSQLXML in interface PreparedStatement

Throws:

SQLException

setAsciiStream

public final void setAsciiStream(int i,
                                 InputStream inputStream,
                                 long l)
                          throws SQLException

Specified by:

setAsciiStream in interface PreparedStatement

Throws:

SQLException

setBinaryStream

public final void setBinaryStream(int i,
                                  InputStream inputStream,
                                  long l)
                           throws SQLException

Specified by:

setBinaryStream in interface PreparedStatement

Throws:

SQLException

setCharacterStream

public final void setCharacterStream(int i,
                                     Reader reader,
                                     long l)
                              throws SQLException

Specified by:

setCharacterStream in interface PreparedStatement

Throws:

SQLException

setAsciiStream

public final void setAsciiStream(int i,
                                 InputStream inputStream)
                          throws SQLException

Specified by:

setAsciiStream in interface PreparedStatement

Throws:

SQLException

setBinaryStream

public final void setBinaryStream(int i,
                                  InputStream inputStream)
                           throws SQLException

Specified by:

setBinaryStream in interface PreparedStatement

Throws:

SQLException

setCharacterStream

public final void setCharacterStream(int i,
                                     Reader reader)
                              throws SQLException

Specified by:

setCharacterStream in interface PreparedStatement

Throws:

SQLException

setNCharacterStream

public final void setNCharacterStream(int i,
                                      Reader reader)
                               throws SQLException

Specified by:

setNCharacterStream in interface PreparedStatement

Throws:

SQLException

setClob

public final void setClob(int i,
                          Reader reader)
                   throws SQLException

Specified by:

setClob in interface PreparedStatement

Throws:

SQLException

setBlob

public final void setBlob(int i,
                          InputStream inputStream)
                   throws SQLException

Specified by:

setBlob in interface PreparedStatement

Throws:

SQLException

setNClob

public final void setNClob(int i,
                           Reader reader)
                    throws SQLException

Specified by:

setNClob in interface PreparedStatement

Throws:

SQLException