connectionpool
Class SmartPreparedStatement

java.lang.Object
  |
  +--connectionpool.SmartStatement
        |
        +--connectionpool.SmartPreparedStatement
Direct Known Subclasses:
SmartCallableStatement
public class SmartPreparedStatement
extends SmartStatement
implements java.sql.PreparedStatement, Close

This class encapsulates a SmartPreparedStatement. Dont expect me to document this class, if you want refer Sun's Documentation.

Method Summary
 void addBatch()
           
 void addBatch(java.lang.String sql)
           
 void cancel()
           
 void clearBatch()
           
 void clearParameters()
           
 void clearWarnings()
           
 void close()
           
 boolean execute()
           
 boolean execute(java.lang.String sql)
           
 int[] executeBatch()
           
 java.sql.ResultSet executeQuery()
           
 java.sql.ResultSet executeQuery(java.lang.String sql)
           
 int executeUpdate()
           
 int executeUpdate(java.lang.String sql)
           
 java.sql.Connection getConnection()
           
 int getFetchDirection()
           
 int getFetchSize()
           
 int getMaxFieldSize()
           
 int getMaxRows()
           
 java.sql.ResultSetMetaData getMetaData()
           
 boolean getMoreResults()
           
 int getQueryTimeout()
           
 java.sql.ResultSet getResultSet()
           
 int getResultSetConcurrency()
           
 int getResultSetType()
           
 int getUpdateCount()
           
 java.sql.SQLWarning getWarnings()
           
 boolean isClosed()
           
 void setArray(int i, java.sql.Array x)
           
 void setAsciiStream(int parameterIndex, java.io.InputStream x, int length)
           
 void setBigDecimal(int parameterIndex, java.math.BigDecimal x)
           
 void setBinaryStream(int parameterIndex, java.io.InputStream x, int length)
           
 void setBlob(int i, java.sql.Blob x)
           
 void setBoolean(int parameterIndex, boolean x)
           
 void setByte(int parameterIndex, byte x)
           
 void setBytes(int parameterIndex, byte[] x)
           
 void setCharacterStream(int parameterIndex, java.io.Reader reader, int length)
           
 void setClob(int i, java.sql.Clob x)
           
 void setCursorName(java.lang.String name)
           
 void setDate(int parameterIndex, java.sql.Date x)
           
 void setDate(int parameterIndex, java.sql.Date x, java.util.Calendar cal)
           
 void setDouble(int parameterIndex, double x)
           
 void setEscapeProcessing(boolean enable)
           
 void setFetchDirection(int direction)
           
 void setFetchSize(int rows)
           
 void setFloat(int parameterIndex, float x)
           
 void setInt(int parameterIndex, int x)
           
 void setLong(int parameterIndex, long x)
           
 void setMaxFieldSize(int max)
           
 void setMaxRows(int max)
           
 void setNull(int parameterIndex, int sqlType)
           
 void setNull(int paramIndex, int sqlType, java.lang.String typeName)
           
 void setObject(int parameterIndex, java.lang.Object x)
           
 void setObject(int parameterIndex, java.lang.Object x, int targetSqlType)
           
 void setObject(int parameterIndex, java.lang.Object x, int targetSqlType, int scale)
           
 void setQueryTimeout(int seconds)
           
 void setRef(int i, java.sql.Ref x)
           
 void setShort(int parameterIndex, short x)
           
 void setString(int parameterIndex, java.lang.String x)
           
 void setTime(int parameterIndex, java.sql.Time x)
           
 void setTime(int parameterIndex, java.sql.Time x, java.util.Calendar cal)
           
 void setTimestamp(int parameterIndex, java.sql.Timestamp x)
           
 void setTimestamp(int parameterIndex, java.sql.Timestamp x, java.util.Calendar cal)
           
 void setUnicodeStream(int parameterIndex, java.io.InputStream x, int length)
           
 java.lang.String toString()
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Method Detail

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

setNull

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

setBoolean

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

setByte

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

setShort

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

setInt

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

setLong

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

setFloat

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

setDouble

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

setBigDecimal

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

setString

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

setBytes

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

setDate

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

setTime

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

setTimestamp

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

setAsciiStream

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

setUnicodeStream

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

setBinaryStream

public void setBinaryStream(int parameterIndex,
                            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 parameterIndex,
                      java.lang.Object x,
                      int targetSqlType,
                      int scale)
               throws java.sql.SQLException
Specified by:
setObject in interface java.sql.PreparedStatement

setObject

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

setObject

public void setObject(int parameterIndex,
                      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

addBatch

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

setCharacterStream

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

setRef

public void setRef(int i,
                   java.sql.Ref x)
            throws java.sql.SQLException
Specified by:
setRef 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

setClob

public void setClob(int i,
                    java.sql.Clob x)
             throws java.sql.SQLException
Specified by:
setClob 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

getMetaData

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

setDate

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

setTime

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

setTimestamp

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

setNull

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

getConnection

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

executeBatch

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

clearBatch

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

addBatch

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

executeQuery

public java.sql.ResultSet executeQuery(java.lang.String sql)
                                throws java.sql.SQLException
Overrides:
executeQuery in class SmartStatement

executeUpdate

public int executeUpdate(java.lang.String sql)
                  throws java.sql.SQLException
Overrides:
executeUpdate in class SmartStatement

close

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

isClosed

public boolean isClosed()
                 throws java.sql.SQLException
Specified by:
isClosed in interface Close
Overrides:
isClosed in class SmartStatement

getMaxFieldSize

public int getMaxFieldSize()
                    throws java.sql.SQLException
Overrides:
getMaxFieldSize in class SmartStatement

setMaxFieldSize

public void setMaxFieldSize(int max)
                     throws java.sql.SQLException
Overrides:
setMaxFieldSize in class SmartStatement

getMaxRows

public int getMaxRows()
               throws java.sql.SQLException
Overrides:
getMaxRows in class SmartStatement

setMaxRows

public void setMaxRows(int max)
                throws java.sql.SQLException
Overrides:
setMaxRows in class SmartStatement

setEscapeProcessing

public void setEscapeProcessing(boolean enable)
                         throws java.sql.SQLException
Overrides:
setEscapeProcessing in class SmartStatement

getQueryTimeout

public int getQueryTimeout()
                    throws java.sql.SQLException
Overrides:
getQueryTimeout in class SmartStatement

setQueryTimeout

public void setQueryTimeout(int seconds)
                     throws java.sql.SQLException
Overrides:
setQueryTimeout in class SmartStatement

cancel

public void cancel()
            throws java.sql.SQLException
Overrides:
cancel in class SmartStatement

getWarnings

public java.sql.SQLWarning getWarnings()
                                throws java.sql.SQLException
Overrides:
getWarnings in class SmartStatement

clearWarnings

public void clearWarnings()
                   throws java.sql.SQLException
Overrides:
clearWarnings in class SmartStatement

setCursorName

public void setCursorName(java.lang.String name)
                   throws java.sql.SQLException
Overrides:
setCursorName in class SmartStatement

execute

public boolean execute(java.lang.String sql)
                throws java.sql.SQLException
Overrides:
execute in class SmartStatement

getResultSet

public java.sql.ResultSet getResultSet()
                                throws java.sql.SQLException
Overrides:
getResultSet in class SmartStatement

getUpdateCount

public int getUpdateCount()
                   throws java.sql.SQLException
Overrides:
getUpdateCount in class SmartStatement

getMoreResults

public boolean getMoreResults()
                       throws java.sql.SQLException
Overrides:
getMoreResults in class SmartStatement

setFetchDirection

public void setFetchDirection(int direction)
                       throws java.sql.SQLException
Overrides:
setFetchDirection in class SmartStatement

getFetchDirection

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

setFetchSize

public void setFetchSize(int rows)
                  throws java.sql.SQLException
Overrides:
setFetchSize in class SmartStatement

getFetchSize

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

getResultSetConcurrency

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

getResultSetType

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

toString

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