com.caucho.sql
Class UserPreparedStatement

java.lang.Object
  extended by com.caucho.sql.UserStatement
      extended by 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, onRuntimeException, onSqlException, 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

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

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