com.caucho.sql
Class UserPreparedStatement

java.lang.Object
  com.caucho.sql.UserStatement
      com.caucho.sql.UserPreparedStatement

All Implemented Interfaces:

java.sql.PreparedStatement, java.sql.Statement, java.sql.Wrapper

Direct Known Subclasses:

UserCallableStatement

public class UserPreparedStatement
extends UserStatement
implements java.sql.PreparedStatement

User-view of prepared statements

Field Summary

protected com.caucho.sql.PreparedStatementCacheItem	_cacheItem
protected java.sql.PreparedStatement	_pstmt
protected static L10N	L

Fields inherited from class com.caucho.sql.UserStatement

_conn, _isPoolable, _stmt

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

void	addBatch() Adds the statement as a batch.
void	clearParameters() Clears the statement's parameters.
void	close() Closes the prepared statement.
boolean	execute() Executes the prepared statement's sql as an update or query
java.sql.ResultSet	executeQuery() Executes the prepared statement's query.
int	executeUpdate() Executes the prepared statement's sql as an update
java.sql.ResultSetMetaData	getMetaData() Returns the result metadata.
java.sql.ParameterMetaData	getParameterMetaData() Returns the prepared statement's meta data.
java.sql.PreparedStatement	getPreparedStatement() Returns the underlying statement.
void	setArray(int index, java.sql.Array value) Sets the parameter as an array
void	setAsciiStream(int parameterIndex, java.io.InputStream x)
void	setAsciiStream(int index, java.io.InputStream value, int length) Sets the parameter as an ascii stream.
void	setAsciiStream(int parameterIndex, java.io.InputStream x, long length)
void	setBigDecimal(int index, java.math.BigDecimal value) Sets the parameter as a BigDecimal
void	setBinaryStream(int parameterIndex, java.io.InputStream x)
void	setBinaryStream(int index, java.io.InputStream value, int length) Sets the parameter as a binary stream.
void	setBinaryStream(int parameterIndex, java.io.InputStream x, long length)
void	setBlob(int index, java.sql.Blob value) Sets the parameter as a blob.
void	setBlob(int parameterIndex, java.io.InputStream inputStream)
void	setBlob(int parameterIndex, java.io.InputStream inputStream, long length)
void	setBoolean(int index, boolean value) Sets the parameter as a boolean.
void	setByte(int index, byte value) Sets the parameter as a byte.
void	setBytes(int index, byte[] value) Sets the parameter as a byte array.
void	setCharacterStream(int parameterIndex, java.io.Reader reader)
void	setCharacterStream(int index, java.io.Reader value, int length) Sets the parameter as an character stream.
void	setCharacterStream(int parameterIndex, java.io.Reader reader, long length)
void	setClob(int index, java.sql.Clob value) Sets the parameter as a clob.
void	setClob(int parameterIndex, java.io.Reader reader)
void	setClob(int parameterIndex, java.io.Reader reader, long length)
void	setDate(int index, java.sql.Date value) Sets the parameter as a date
void	setDate(int index, java.sql.Date value, java.util.Calendar cal) Sets the parameter as a time
void	setDouble(int index, double value) Sets the parameter as a double
void	setFloat(int index, float value) Sets the parameter as a float
void	setInt(int index, int value) Sets the parameter as an int
void	setLong(int index, long value) Sets the parameter as a long
void	setNCharacterStream(int parameterIndex, java.io.Reader value)
void	setNCharacterStream(int parameterIndex, java.io.Reader value, long length)
void	setNClob(int parameterIndex, java.sql.NClob value)
void	setNClob(int parameterIndex, java.io.Reader reader)
void	setNClob(int parameterIndex, java.io.Reader reader, long length)
void	setNString(int parameterIndex, java.lang.String value)
void	setNull(int parameterIndex, int sqlType) Sets the parameter as a null.
void	setNull(int parameterIndex, int sqlType, java.lang.String typeName) Sets the parameter as a null.
void	setObject(int index, java.lang.Object value) Sets the parameter as a object.
void	setObject(int index, java.lang.Object value, int type) Sets the parameter as an object with the given type.
void	setObject(int index, java.lang.Object value, int type, int scale) Sets the parameter as an object with the given type and scale.
void	setRef(int index, java.sql.Ref value) Sets teh parameter as a ref.
void	setRowId(int parameterIndex, java.sql.RowId x)
void	setShort(int index, short value) Sets the parameter as a short.
void	setSQLXML(int parameterIndex, java.sql.SQLXML xmlObject)
void	setString(int index, java.lang.String value) Sets the parameter as a string
void	setTime(int index, java.sql.Time value) Sets the parameter as a time
void	setTime(int index, java.sql.Time value, java.util.Calendar cal) Sets the parameter as a time
void	setTimestamp(int index, java.sql.Timestamp value) Sets the parameter as a timestamp
void	setTimestamp(int index, java.sql.Timestamp value, java.util.Calendar cal) Sets the parameter as a timestamp
void	setUnicodeStream(int index, java.io.InputStream value, int length) Sets the parameter as a unicode stream.
void	setURL(int index, java.net.URL value) Sets the parameter as a URL.
java.lang.String	toString()

Methods inherited from class com.caucho.sql.UserStatement

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

Methods inherited from class java.lang.Object

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

Methods inherited from interface java.sql.Statement

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

Methods inherited from interface java.sql.Wrapper

isWrapperFor, unwrap

Field Detail

L

protected static L10N L

_pstmt

protected java.sql.PreparedStatement _pstmt

_cacheItem

protected com.caucho.sql.PreparedStatementCacheItem _cacheItem

Method Detail

getPreparedStatement

public java.sql.PreparedStatement getPreparedStatement()

Returns the underlying statement.

executeQuery

public java.sql.ResultSet executeQuery()
                                throws java.sql.SQLException

Executes the prepared statement's query.

Specified by:

executeQuery in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

executeUpdate

public int executeUpdate()
                  throws java.sql.SQLException

Executes the prepared statement's sql as an update

Specified by:

executeUpdate in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

execute

public boolean execute()
                throws java.sql.SQLException

Executes the prepared statement's sql as an update or query

Specified by:

execute in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

addBatch

public void addBatch()
              throws java.sql.SQLException

Adds the statement as a batch.

Specified by:

addBatch in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

clearParameters

public void clearParameters()
                     throws java.sql.SQLException

Clears the statement's parameters.

Specified by:

clearParameters in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

getMetaData

public java.sql.ResultSetMetaData getMetaData()
                                       throws java.sql.SQLException

Returns the result metadata.

Specified by:

getMetaData in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

getParameterMetaData

public java.sql.ParameterMetaData getParameterMetaData()
                                                throws java.sql.SQLException

Returns the prepared statement's meta data.

Specified by:

getParameterMetaData in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setNull

public void setNull(int parameterIndex,
                    int sqlType)
             throws java.sql.SQLException

Sets the parameter as a null.

Specified by:

setNull in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setNull

public void setNull(int parameterIndex,
                    int sqlType,
                    java.lang.String typeName)
             throws java.sql.SQLException

Sets the parameter as a null.

Specified by:

setNull in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setBoolean

public void setBoolean(int index,
                       boolean value)
                throws java.sql.SQLException

Sets the parameter as a boolean.

Specified by:

setBoolean in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setByte

public void setByte(int index,
                    byte value)
             throws java.sql.SQLException

Sets the parameter as a byte.

Specified by:

setByte in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setShort

public void setShort(int index,
                     short value)
              throws java.sql.SQLException

Sets the parameter as a short.

Specified by:

setShort in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setInt

public void setInt(int index,
                   int value)
            throws java.sql.SQLException

Sets the parameter as an int

Specified by:

setInt in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setLong

public void setLong(int index,
                    long value)
             throws java.sql.SQLException

Sets the parameter as a long

Specified by:

setLong in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setFloat

public void setFloat(int index,
                     float value)
              throws java.sql.SQLException

Sets the parameter as a float

Specified by:

setFloat in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setDouble

public void setDouble(int index,
                      double value)
               throws java.sql.SQLException

Sets the parameter as a double

Specified by:

setDouble in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setBigDecimal

public void setBigDecimal(int index,
                          java.math.BigDecimal value)
                   throws java.sql.SQLException

Sets the parameter as a BigDecimal

Specified by:

setBigDecimal in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setString

public void setString(int index,
                      java.lang.String value)
               throws java.sql.SQLException

Sets the parameter as a string

Specified by:

setString in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setBytes

public void setBytes(int index,
                     byte[] value)
              throws java.sql.SQLException

Sets the parameter as a byte array.

Specified by:

setBytes in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setDate

public void setDate(int index,
                    java.sql.Date value)
             throws java.sql.SQLException

Sets the parameter as a date

Specified by:

setDate in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setDate

public void setDate(int index,
                    java.sql.Date value,
                    java.util.Calendar cal)
             throws java.sql.SQLException

Sets the parameter as a time

Specified by:

setDate in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setTime

public void setTime(int index,
                    java.sql.Time value)
             throws java.sql.SQLException

Sets the parameter as a time

Specified by:

setTime in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setTime

public void setTime(int index,
                    java.sql.Time value,
                    java.util.Calendar cal)
             throws java.sql.SQLException

Sets the parameter as a time

Specified by:

setTime in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setTimestamp

public void setTimestamp(int index,
                         java.sql.Timestamp value)
                  throws java.sql.SQLException

Sets the parameter as a timestamp

Specified by:

setTimestamp in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setTimestamp

public void setTimestamp(int index,
                         java.sql.Timestamp value,
                         java.util.Calendar cal)
                  throws java.sql.SQLException

Sets the parameter as a timestamp

Specified by:

setTimestamp in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setAsciiStream

public void setAsciiStream(int index,
                           java.io.InputStream value,
                           int length)
                    throws java.sql.SQLException

Sets the parameter as an ascii stream.

Specified by:

setAsciiStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setUnicodeStream

public void setUnicodeStream(int index,
                             java.io.InputStream value,
                             int length)
                      throws java.sql.SQLException

Sets the parameter as a unicode stream.

Specified by:

setUnicodeStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setBinaryStream

public void setBinaryStream(int index,
                            java.io.InputStream value,
                            int length)
                     throws java.sql.SQLException

Sets the parameter as a binary stream.

Specified by:

setBinaryStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setCharacterStream

public void setCharacterStream(int index,
                               java.io.Reader value,
                               int length)
                        throws java.sql.SQLException

Sets the parameter as an character stream.

Specified by:

setCharacterStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setObject

public void setObject(int index,
                      java.lang.Object value,
                      int type,
                      int scale)
               throws java.sql.SQLException

Sets the parameter as an object with the given type and scale.

Specified by:

setObject in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setAsciiStream

public void setAsciiStream(int parameterIndex,
                           java.io.InputStream x,
                           long length)
                    throws java.sql.SQLException

Specified by:

setAsciiStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setBinaryStream

public void setBinaryStream(int parameterIndex,
                            java.io.InputStream x,
                            long length)
                     throws java.sql.SQLException

Specified by:

setBinaryStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setCharacterStream

public void setCharacterStream(int parameterIndex,
                               java.io.Reader reader,
                               long length)
                        throws java.sql.SQLException

Specified by:

setCharacterStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setAsciiStream

public void setAsciiStream(int parameterIndex,
                           java.io.InputStream x)
                    throws java.sql.SQLException

Specified by:

setAsciiStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setBinaryStream

public void setBinaryStream(int parameterIndex,
                            java.io.InputStream x)
                     throws java.sql.SQLException

Specified by:

setBinaryStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setCharacterStream

public void setCharacterStream(int parameterIndex,
                               java.io.Reader reader)
                        throws java.sql.SQLException

Specified by:

setCharacterStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setNCharacterStream

public void setNCharacterStream(int parameterIndex,
                                java.io.Reader value)
                         throws java.sql.SQLException

Specified by:

setNCharacterStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setClob

public void setClob(int parameterIndex,
                    java.io.Reader reader)
             throws java.sql.SQLException

Specified by:

setClob in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setBlob

public void setBlob(int parameterIndex,
                    java.io.InputStream inputStream)
             throws java.sql.SQLException

Specified by:

setBlob in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setNClob

public void setNClob(int parameterIndex,
                     java.io.Reader reader)
              throws java.sql.SQLException

Specified by:

setNClob in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setObject

public void setObject(int index,
                      java.lang.Object value,
                      int type)
               throws java.sql.SQLException

Sets the parameter as an object with the given type.

Specified by:

setObject in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setObject

public void setObject(int index,
                      java.lang.Object value)
               throws java.sql.SQLException

Sets the parameter as a object.

Specified by:

setObject in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setRef

public void setRef(int index,
                   java.sql.Ref value)
            throws java.sql.SQLException

Sets teh parameter as a ref.

Specified by:

setRef in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setBlob

public void setBlob(int index,
                    java.sql.Blob value)
             throws java.sql.SQLException

Sets the parameter as a blob.

Specified by:

setBlob in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setClob

public void setClob(int index,
                    java.sql.Clob value)
             throws java.sql.SQLException

Sets the parameter as a clob.

Specified by:

setClob in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setArray

public void setArray(int index,
                     java.sql.Array value)
              throws java.sql.SQLException

Sets the parameter as an array

Specified by:

setArray in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setURL

public void setURL(int index,
                   java.net.URL value)
            throws java.sql.SQLException

Sets the parameter as a URL.

Specified by:

setURL in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

close

public void close()
           throws java.sql.SQLException

Closes the prepared statement.

Specified by:

close in interface java.sql.Statement

Overrides:

close in class UserStatement

Throws:

java.sql.SQLException

toString

public java.lang.String toString()

Overrides:

toString in class UserStatement

setRowId

public void setRowId(int parameterIndex,
                     java.sql.RowId x)
              throws java.sql.SQLException

Specified by:

setRowId in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setNString

public void setNString(int parameterIndex,
                       java.lang.String value)
                throws java.sql.SQLException

Specified by:

setNString in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setNCharacterStream

public void setNCharacterStream(int parameterIndex,
                                java.io.Reader value,
                                long length)
                         throws java.sql.SQLException

Specified by:

setNCharacterStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setNClob

public void setNClob(int parameterIndex,
                     java.sql.NClob value)
              throws java.sql.SQLException

Specified by:

setNClob in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setClob

public void setClob(int parameterIndex,
                    java.io.Reader reader,
                    long length)
             throws java.sql.SQLException

Specified by:

setClob in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setBlob

public void setBlob(int parameterIndex,
                    java.io.InputStream inputStream,
                    long length)
             throws java.sql.SQLException

Specified by:

setBlob in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setNClob

public void setNClob(int parameterIndex,
                     java.io.Reader reader,
                     long length)
              throws java.sql.SQLException

Specified by:

setNClob in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setSQLXML

public void setSQLXML(int parameterIndex,
                      java.sql.SQLXML xmlObject)
               throws java.sql.SQLException

Specified by:

setSQLXML in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException