Google

: Class PooledPreparedStatement

com.bitmechanic.sql
Class PooledPreparedStatement

java.lang.Object
  |
  +--com.bitmechanic.sql.PooledStatement
        |
        +--com.bitmechanic.sql.PooledPreparedStatement
Direct Known Subclasses:
PooledCallableStatement

public class PooledPreparedStatement
extends PooledStatement
implements java.sql.PreparedStatement


Field Summary
protected  java.sql.PreparedStatement pstmt
           
 
Fields inherited from class com.bitmechanic.sql.PooledStatement
stmt
 
Constructor Summary
protected PooledPreparedStatement()
           
  PooledPreparedStatement(java.sql.PreparedStatement stmt)
           
 
Method Summary
 void addBatch()
           
 void addBatch(java.lang.String s)
           
 void clearBatch()
           
 void clearParameters()
           
 void close()
           
 boolean execute()
           
 int[] executeBatch()
           
 java.sql.ResultSet executeQuery()
          PreparedStatment methods
 int executeUpdate()
           
 java.sql.Connection getConnection()
           
 int getFetchDirection()
           
 int getFetchSize()
           
 java.sql.ResultSetMetaData getMetaData()
           
 int getResultSetConcurrency()
           
 int getResultSetType()
           
 void setArray(int i, java.sql.Array a)
           
 void setAsciiStream(int index, java.io.InputStream x, int length)
           
 void setBigDecimal(int index, java.math.BigDecimal x)
           
 void setBinaryStream(int index, java.io.InputStream x, int length)
           
 void setBlob(int i, java.sql.Blob b)
           
 void setBoolean(int index, boolean x)
           
 void setByte(int index, byte x)
           
 void setBytes(int index, byte[] x)
           
 void setCharacterStream(int i, java.io.Reader r, int j)
           
 void setClob(int i, java.sql.Clob c)
           
 void setDate(int index, java.sql.Date x)
           
 void setDate(int i, java.sql.Date d, java.util.Calendar c)
           
 void setDouble(int index, double x)
           
 void setFetchDirection(int i)
           
 void setFetchSize(int i)
           
 void setFloat(int index, float x)
           
 void setInt(int index, int x)
           
 void setLong(int index, long x)
           
 void setNull(int index, int sqlType)
           
 void setNull(int i, int j, java.lang.String s)
           
 void setObject(int index, java.lang.Object x)
           
 void setObject(int index, java.lang.Object x, int target)
           
 void setObject(int index, java.lang.Object x, int target, int scale)
           
 void setRef(int i, java.sql.Ref r)
           
 void setShort(int index, short x)
           
 void setString(int index, java.lang.String x)
           
 void setTime(int index, java.sql.Time x)
           
 void setTime(int i, java.sql.Time t, java.util.Calendar c)
           
 void setTimestamp(int index, java.sql.Timestamp x)
           
 void setTimestamp(int i, java.sql.Timestamp t, java.util.Calendar c)
           
 void setUnicodeStream(int index, java.io.InputStream x, int length)
           
 
Methods inherited from class com.bitmechanic.sql.PooledStatement
cancel, clearWarnings, dumpInfo, execute, executeQuery, executeUpdate, getMaxFieldSize, getMaxRows, getMoreResults, getQueryTimeout, getResultSet, getStatement, getUpdateCount, getWarnings, setCursorName, setEscapeProcessing, setMaxFieldSize, setMaxRows, setQueryTimeout
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

pstmt

protected java.sql.PreparedStatement pstmt
Constructor Detail

PooledPreparedStatement

protected PooledPreparedStatement()

PooledPreparedStatement

public PooledPreparedStatement(java.sql.PreparedStatement stmt)
Method Detail

close

public void close()
           throws java.sql.SQLException
Overrides:
close in class PooledStatement

executeQuery

public java.sql.ResultSet executeQuery()
                                throws java.sql.SQLException
PreparedStatment methods
Specified by:
executeQuery in interface java.sql.PreparedStatement

executeUpdate

public int executeUpdate()
                  throws java.sql.SQLException
Specified by:
executeUpdate in interface java.sql.PreparedStatement

setNull

public void setNull(int index,
                    int sqlType)
             throws java.sql.SQLException
Specified by:
setNull in interface java.sql.PreparedStatement

setBoolean

public void setBoolean(int index,
                       boolean x)
                throws java.sql.SQLException
Specified by:
setBoolean in interface java.sql.PreparedStatement

setByte

public void setByte(int index,
                    byte x)
             throws java.sql.SQLException
Specified by:
setByte in interface java.sql.PreparedStatement

setShort

public void setShort(int index,
                     short x)
              throws java.sql.SQLException
Specified by:
setShort in interface java.sql.PreparedStatement

setInt

public void setInt(int index,
                   int x)
            throws java.sql.SQLException
Specified by:
setInt in interface java.sql.PreparedStatement

setLong

public void setLong(int index,
                    long x)
             throws java.sql.SQLException
Specified by:
setLong in interface java.sql.PreparedStatement

setFloat

public void setFloat(int index,
                     float x)
              throws java.sql.SQLException
Specified by:
setFloat in interface java.sql.PreparedStatement

setDouble

public void setDouble(int index,
                      double x)
               throws java.sql.SQLException
Specified by:
setDouble in interface java.sql.PreparedStatement

setBigDecimal

public void setBigDecimal(int index,
                          java.math.BigDecimal x)
                   throws java.sql.SQLException
Specified by:
setBigDecimal in interface java.sql.PreparedStatement

setString

public void setString(int index,
                      java.lang.String x)
               throws java.sql.SQLException
Specified by:
setString in interface java.sql.PreparedStatement

setBytes

public void setBytes(int index,
                     byte[] x)
              throws java.sql.SQLException
Specified by:
setBytes in interface java.sql.PreparedStatement

setDate

public void setDate(int index,
                    java.sql.Date x)
             throws java.sql.SQLException
Specified by:
setDate in interface java.sql.PreparedStatement

setTime

public void setTime(int index,
                    java.sql.Time x)
             throws java.sql.SQLException
Specified by:
setTime in interface java.sql.PreparedStatement

setTimestamp

public void setTimestamp(int index,
                         java.sql.Timestamp x)
                  throws java.sql.SQLException
Specified by:
setTimestamp in interface java.sql.PreparedStatement

setAsciiStream

public void setAsciiStream(int index,
                           java.io.InputStream x,
                           int length)
                    throws java.sql.SQLException
Specified by:
setAsciiStream in interface java.sql.PreparedStatement

setUnicodeStream

public void setUnicodeStream(int index,
                             java.io.InputStream x,
                             int length)
                      throws java.sql.SQLException
Specified by:
setUnicodeStream in interface java.sql.PreparedStatement

setBinaryStream

public void setBinaryStream(int index,
                            java.io.InputStream x,
                            int length)
                     throws java.sql.SQLException
Specified by:
setBinaryStream in interface java.sql.PreparedStatement

clearParameters

public void clearParameters()
                     throws java.sql.SQLException
Specified by:
clearParameters in interface java.sql.PreparedStatement

setObject

public void setObject(int index,
                      java.lang.Object x,
                      int target,
                      int scale)
               throws java.sql.SQLException
Specified by:
setObject in interface java.sql.PreparedStatement

setObject

public void setObject(int index,
                      java.lang.Object x,
                      int target)
               throws java.sql.SQLException
Specified by:
setObject in interface java.sql.PreparedStatement

setObject

public void setObject(int index,
                      java.lang.Object x)
               throws java.sql.SQLException
Specified by:
setObject in interface java.sql.PreparedStatement

execute

public boolean execute()
                throws java.sql.SQLException
Specified by:
execute in interface java.sql.PreparedStatement

setCharacterStream

public void setCharacterStream(int i,
                               java.io.Reader r,
                               int j)
                        throws java.sql.SQLException
Specified by:
setCharacterStream in interface java.sql.PreparedStatement
Overrides:
setCharacterStream in class PooledStatement

getFetchDirection

public int getFetchDirection()
                      throws java.sql.SQLException
Overrides:
getFetchDirection in class PooledStatement

executeBatch

public int[] executeBatch()
                   throws java.sql.SQLException
Overrides:
executeBatch in class PooledStatement

setFetchSize

public void setFetchSize(int i)
                  throws java.sql.SQLException
Overrides:
setFetchSize in class PooledStatement

clearBatch

public void clearBatch()
                throws java.sql.SQLException
Overrides:
clearBatch in class PooledStatement

addBatch

public void addBatch()
              throws java.sql.SQLException
Specified by:
addBatch in interface java.sql.PreparedStatement

addBatch

public void addBatch(java.lang.String s)
              throws java.sql.SQLException
Overrides:
addBatch in class PooledStatement

setRef

public void setRef(int i,
                   java.sql.Ref r)
            throws java.sql.SQLException
Specified by:
setRef in interface java.sql.PreparedStatement

getResultSetConcurrency

public int getResultSetConcurrency()
                            throws java.sql.SQLException
Overrides:
getResultSetConcurrency in class PooledStatement

setClob

public void setClob(int i,
                    java.sql.Clob c)
             throws java.sql.SQLException
Specified by:
setClob in interface java.sql.PreparedStatement

setFetchDirection

public void setFetchDirection(int i)
                       throws java.sql.SQLException
Overrides:
setFetchDirection in class PooledStatement

setDate

public void setDate(int i,
                    java.sql.Date d,
                    java.util.Calendar c)
             throws java.sql.SQLException
Specified by:
setDate in interface java.sql.PreparedStatement

setArray

public void setArray(int i,
                     java.sql.Array a)
              throws java.sql.SQLException
Specified by:
setArray in interface java.sql.PreparedStatement

setBlob

public void setBlob(int i,
                    java.sql.Blob b)
             throws java.sql.SQLException
Specified by:
setBlob in interface java.sql.PreparedStatement

getFetchSize

public int getFetchSize()
                 throws java.sql.SQLException
Overrides:
getFetchSize in class PooledStatement

setTime

public void setTime(int i,
                    java.sql.Time t,
                    java.util.Calendar c)
             throws java.sql.SQLException
Specified by:
setTime in interface java.sql.PreparedStatement

getConnection

public java.sql.Connection getConnection()
                                  throws java.sql.SQLException
Overrides:
getConnection in class PooledStatement

getMetaData

public java.sql.ResultSetMetaData getMetaData()
                                       throws java.sql.SQLException
Specified by:
getMetaData in interface java.sql.PreparedStatement

getResultSetType

public int getResultSetType()
                     throws java.sql.SQLException
Overrides:
getResultSetType in class PooledStatement

setTimestamp

public void setTimestamp(int i,
                         java.sql.Timestamp t,
                         java.util.Calendar c)
                  throws java.sql.SQLException
Specified by:
setTimestamp in interface java.sql.PreparedStatement

setNull

public void setNull(int i,
                    int j,
                    java.lang.String s)
             throws java.sql.SQLException
Specified by:
setNull in interface java.sql.PreparedStatement