com.codestudio.sql
Class PoolManPreparedStatement

java.lang.Object
  |
  +--com.codestudio.sql.PoolManStatement
        |
        +--com.codestudio.sql.PoolManPreparedStatement
All Implemented Interfaces:
PooledObject, java.sql.PreparedStatement, java.io.Serializable, java.sql.Statement
Direct Known Subclasses:
PoolManCallableStatement

public class PoolManPreparedStatement
extends PoolManStatement
implements java.sql.PreparedStatement

A PreparedStatement that is aware of its Connection and resources.

It encapsulates a true driver-specific Statement that handles all the necessary JDBC methods by delegation.

See Also:
Serialized Form

Fields inherited from class com.codestudio.sql.PoolManStatement
closed, lastRS, mypool, openres, poolmanCon, resultSetConcurrency, resultSetType, sqlString
 
Constructor Summary
PoolManPreparedStatement(PoolManConnection pcon, java.sql.PreparedStatement s, ObjectPool p)
           
PoolManPreparedStatement(PoolManConnection pcon, java.sql.PreparedStatement s, java.lang.String rawSQL, ObjectPool p)
           
 
Method Summary
 void addBatch()
           
 void clearParameters()
           
 void close()
           
 boolean execute()
           
 java.sql.ResultSet executeQuery()
           
 int executeUpdate()
           
 java.sql.ResultSetMetaData getMetaData()
           
 java.sql.PreparedStatement getNativePreparedStatement()
           
 void setArray(int i, java.sql.Array x)
           
 void setAsciiStream(int i, java.io.InputStream x, int length)
           
 void setBigDecimal(int i, java.math.BigDecimal x)
           
 void setBinaryStream(int i, java.io.InputStream x, int length)
           
 void setBlob(int i, java.sql.Blob x)
           
 void setBoolean(int i, boolean x)
           
 void setByte(int i, byte b)
           
 void setBytes(int i, byte[] x)
           
 void setCharacterStream(int i, java.io.Reader reader, int length)
           
 void setClob(int i, java.sql.Clob clob)
           
 void setDate(int i, java.sql.Date d)
           
 void setDate(int i, java.sql.Date d, java.util.Calendar cal)
           
 void setDouble(int i, double d)
           
 void setFloat(int i, float f)
           
 void setInt(int i, int x)
           
 void setLong(int i, long l)
           
 void setNull(int i, int sqlType)
           
 void setNull(int i, int sqlType, java.lang.String typeName)
           
 void setObject(int i, java.lang.Object o)
           
 void setObject(int i, java.lang.Object o, int targetType)
           
 void setObject(int i, java.lang.Object o, int targetType, int scale)
           
 void setRef(int i, java.sql.Ref ref)
           
 void setShort(int i, short s)
           
 void setString(int i, java.lang.String s)
           
 void setTime(int i, java.sql.Time t)
           
 void setTime(int i, java.sql.Time t, java.util.Calendar cal)
           
 void setTimestamp(int i, java.sql.Timestamp t)
           
 void setTimestamp(int i, java.sql.Timestamp t, java.util.Calendar cal)
           
 void setUnicodeStream(int i, java.io.InputStream x, int length)
           
 java.lang.String toString()
           
 
Methods inherited from class com.codestudio.sql.PoolManStatement
addBatch, cancel, clean, clearBatch, clearWarnings, closeAllResources, execute, executeBatch, executeQuery, executeUpdate, fabricateTableName, getConnection, getFetchDirection, getFetchSize, getMaxFieldSize, getMaxRows, getMoreResults, getNativeStatement, getPool, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetType, getSQL, getUpdateCount, getWarnings, isClosed, removeOpenResultSet, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout, setResultSetConcurrency, setResultSetType
 
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, executeBatch, executeQuery, executeUpdate, getConnection, getFetchDirection, getFetchSize, getMaxFieldSize, getMaxRows, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetType, getUpdateCount, getWarnings, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout
 

Constructor Detail

PoolManPreparedStatement

public PoolManPreparedStatement(PoolManConnection pcon,
                                java.sql.PreparedStatement s,
                                ObjectPool p)

PoolManPreparedStatement

public PoolManPreparedStatement(PoolManConnection pcon,
                                java.sql.PreparedStatement s,
                                java.lang.String rawSQL,
                                ObjectPool p)
Method Detail

close

public void close()
           throws java.sql.SQLException
Specified by:
close in interface java.sql.Statement
Overrides:
close in class PoolManStatement

getNativePreparedStatement

public java.sql.PreparedStatement getNativePreparedStatement()

executeQuery

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

executeUpdate

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

execute

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

addBatch

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

clearParameters

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

getMetaData

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

setArray

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

setAsciiStream

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

setBigDecimal

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

setBinaryStream

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

setBlob

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

setBoolean

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

setByte

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

setBytes

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

setCharacterStream

public void setCharacterStream(int i,
                               java.io.Reader reader,
                               int length)
                        throws java.sql.SQLException
Specified by:
setCharacterStream in interface java.sql.PreparedStatement

setClob

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

setDate

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

setDate

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

setDouble

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

setFloat

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

setInt

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

setLong

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

setNull

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

setNull

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

setObject

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

setObject

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

setObject

public void setObject(int i,
                      java.lang.Object o,
                      int targetType,
                      int scale)
               throws java.sql.SQLException
Specified by:
setObject in interface java.sql.PreparedStatement

setRef

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

setShort

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

setString

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

setTime

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

setTime

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

setTimestamp

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

setTimestamp

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

setUnicodeStream

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

toString

public java.lang.String toString()
Overrides:
toString in class PoolManStatement


Copyright © 1999-2001 The Code Studio. All Rights Reserved.