UserPreparedStatement (Resin 4.0.s170329)

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

All Implemented Interfaces:

java.lang.AutoCloseable, 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

Fields
Modifier and Type Field and Description

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

Fields
Modifier and Type	Field and Description
`protected com.caucho.sql.PreparedStatementCacheItem`	`_cacheItem`
`protected java.sql.PreparedStatement`	`_pstmt`
`protected static L10N`	`L`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`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.
`boolean`	`isWrapperFor(java.lang.Class<?> iface)`
`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()`
`<T> T`	`unwrap(java.lang.Class<T> iface)`

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface java.sql.PreparedStatement
executeLargeUpdate, setObject, setObject

Methods inherited from interface java.sql.Statement
addBatch, cancel, clearBatch, clearWarnings, 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

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

unwrap
```
public <T> T unwrap(java.lang.Class<T> iface)
             throws java.sql.SQLException
```
Specified by:

unwrap in interface java.sql.Wrapper

Overrides:

unwrap in class UserStatement

Throws:

java.sql.SQLException

isWrapperFor
```
public boolean isWrapperFor(java.lang.Class<?> iface)
                     throws java.sql.SQLException
```
Specified by:

isWrapperFor in interface java.sql.Wrapper

Overrides:

isWrapperFor in class UserStatement

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.lang.AutoCloseable

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

Class UserPreparedStatement

Field Summary

Fields inherited from class com.caucho.sql.UserStatement

Fields inherited from interface java.sql.Statement

Method Summary

Methods inherited from class com.caucho.sql.UserStatement

Methods inherited from class java.lang.Object

Methods inherited from interface java.sql.PreparedStatement

Methods inherited from interface java.sql.Statement

Field Detail

L

_pstmt

_cacheItem

Method Detail

getPreparedStatement

executeQuery

executeUpdate

execute

addBatch

clearParameters

getMetaData

getParameterMetaData

unwrap

isWrapperFor

setNull

setNull

setBoolean

setByte

setShort

setInt

setLong

setFloat

setDouble

setBigDecimal

setString

setBytes

setDate

setDate

setTime

setTime

setTimestamp

setTimestamp

setAsciiStream

setUnicodeStream

setBinaryStream

setCharacterStream

setObject

setAsciiStream

setBinaryStream

setCharacterStream

setAsciiStream

setBinaryStream

setCharacterStream

setNCharacterStream

setClob

setBlob

setNClob

setObject

setObject

setRef

setBlob

setClob

setArray

setURL

setRowId

setNString

setNCharacterStream

setNClob

setClob

setBlob

setNClob

setSQLXML

close

toString