com.screenscraper.datamanager.sql.util

Class DmPreparedStatement

java.lang.Object

com.screenscraper.datamanager.sql.util.DmPreparedStatement

All Implemented Interfaces:

java.lang.AutoCloseable, java.sql.PreparedStatement, java.sql.Statement, java.sql.Wrapper

public final class DmPreparedStatement
extends java.lang.Object
implements java.sql.PreparedStatement

A wrapper for java.sql.PreparedStatement that adds methods for dealing Directly interacting with the DataObject class, as well of methods to retrive values that were used in the preparation of the PreparedStatement

Field Summary

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

Constructor Summary

Constructors

Constructor and Description
DmPreparedStatement(java.sql.Connection con, java.lang.CharSequence sql) Creates a DmPreparedStatement designed for executeQuery (Lookup as opposed to update) java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE and java.sql.ResultSet.CONCUR_UPDATABLE are set PreparedStatement parameters:
DmPreparedStatement(java.sql.Connection con, java.lang.CharSequence sql, int autoGeneratedKeys) Creates a DmPreparedStatement from the given sql statement with optional retrieval of auto generated keys
DmPreparedStatement(java.sql.Connection con, java.lang.CharSequence sql, java.lang.String[] pk)

Method Summary

Modifier and Type	Method and Description
void	addBatch()
void	addBatch(java.lang.String string)
void	cancel()
void	clearBatch()
void	clearParameters()
void	clearWarnings()
void	close()
void	closeOnCompletion()
boolean	execute()
boolean	execute(java.lang.String string)
boolean	execute(java.lang.String sql, int autoGeneratedKeys)
boolean	execute(java.lang.String sql, int[] columnIndexes)
boolean	execute(java.lang.String sql, java.lang.String[] columnNames)
int[]	executeBatch()
java.sql.ResultSet	executeQuery()
java.sql.ResultSet	executeQuery(java.lang.String string)
java.util.List<java.util.Map<java.lang.String,DataObject>>	executeQueryGetMapList() executes the query normally except instead of returning a ResultSet it returns a List of Map<String columnName, DataObject values>
int	executeUpdate()
int	executeUpdate(java.lang.String string)
int	executeUpdate(java.lang.String sql, int autoGeneratedKeys)
int	executeUpdate(java.lang.String sql, int[] columnIndexes)
int	executeUpdate(java.lang.String sql, java.lang.String[] columnNames)
java.sql.Connection	getConnection()
java.util.List<DataObject>	getData() returns all the set data as a List of DataObjects
DataObject	getData(int i) returns the data set in te ith position as a DataObject
int	getFetchDirection()
int	getFetchSize()
java.sql.ResultSet	getGeneratedKeys()
int	getMaxFieldSize()
int	getMaxRows()
java.sql.ResultSetMetaData	getMetaData()
boolean	getMoreResults()
boolean	getMoreResults(int current)
java.sql.ParameterMetaData	getParameterMetaData()
int	getQueryTimeout()
java.sql.ResultSet	getResultSet()
int	getResultSetConcurrency()
int	getResultSetHoldability()
int	getResultSetType()
long	getRunTime()
java.lang.String	getSql() returns the Sql String that was used to create the PreparedStatement
int	getUpdateCount()
java.sql.SQLWarning	getWarnings()
(package private) void	init(java.sql.PreparedStatement ps, java.lang.CharSequence sql)
boolean	isClosed()
boolean	isCloseOnCompletion()
boolean	isPoolable()
boolean	isWrapperFor(java.lang.Class<?> type)
static DmPreparedStatement	prepareQuery(java.sql.Connection con, java.lang.String sql, java.util.Map<java.lang.String,DataObject> values)
void	setArray(int parameterIndex, java.sql.Array x)
void	setAsciiStream(int i, java.io.InputStream in)
void	setAsciiStream(int parameterIndex, java.io.InputStream x, int length)
void	setAsciiStream(int i, java.io.InputStream in, long l)
void	setBigDecimal(int parameterIndex, java.math.BigDecimal x)
void	setBinaryStream(int i, java.io.InputStream in)
void	setBinaryStream(int parameterIndex, java.io.InputStream x, int length)
void	setBinaryStream(int i, java.io.InputStream in, long l)
void	setBlob(int parameterIndex, java.sql.Blob x)
void	setBlob(int i, java.io.InputStream in)
void	setBlob(int parameterIndex, java.io.InputStream inputStream, long length)
void	setBoolean(int parameterIndex, boolean x)
void	setByte(int parameterIndex, byte x)
void	setBytes(int parameterIndex, byte[] x)
void	setCharacterStream(int i, java.io.Reader reader)
void	setCharacterStream(int parameterIndex, java.io.Reader reader, int length)
void	setCharacterStream(int i, java.io.Reader reader, long l)
void	setClob(int parameterIndex, java.sql.Clob x)
void	setClob(int i, java.io.Reader reader)
void	setClob(int parameterIndex, java.io.Reader reader, long length)
void	setCursorName(java.lang.String string)
void	setData(int i, DataObject data) Set the designated parameter of the given DataNode value.
void	setData(java.util.List<DataObject> data) Sets the PreparedStatement parameter with data, the List must be in the same order as its corresponding parameters in the PreparedStatement
void	setDate(int parameterIndex, java.sql.Date x)
void	setDate(int parameterIndex, java.sql.Date x, java.util.Calendar calendar)
void	setDouble(int parameterIndex, double x)
void	setEscapeProcessing(boolean bln)
void	setFetchDirection(int i)
void	setFetchSize(int i)
void	setFloat(int parameterIndex, float x)
void	setInt(int parameterIndex, int x)
void	setLong(int parameterIndex, long x)
void	setMaxFieldSize(int i)
void	setMaxRows(int i)
void	setNCharacterStream(int i, java.io.Reader reader)
void	setNCharacterStream(int parameterIndex, java.io.Reader value, long length)
void	setNClob(int parameterIndex, java.sql.NClob value)
void	setNClob(int i, 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)
void	setNull(int parameterIndex, 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 i, java.lang.Object o, int i1, int i2)
void	setPoolable(boolean poolable)
void	setQueryTimeout(int i)
void	setRef(int parameterIndex, java.sql.Ref x)
void	setRowId(int parameterIndex, java.sql.RowId x)
void	setShort(int parameterIndex, short x)
void	setSQLXML(int parameterIndex, java.sql.SQLXML xmlObject)
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 calendar)
void	setTimestamp(int parameterIndex, java.sql.Timestamp x)
void	setTimestamp(int parameterIndex, java.sql.Timestamp x, java.util.Calendar calendar)
void	setUnicodeStream(int parameterIndex, java.io.InputStream x, int length) Deprecated.
void	setURL(int parameterIndex, java.net.URL x)
<T> T	unwrap(java.lang.Class<T> type)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface java.sql.PreparedStatement

executeLargeUpdate, setObject, setObject

Methods inherited from interface java.sql.Statement

executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, getLargeMaxRows, getLargeUpdateCount, setLargeMaxRows

Constructor Detail

DmPreparedStatement

public DmPreparedStatement(@NotNull
                           java.sql.Connection con,
                           @NotNull
                           java.lang.CharSequence sql)
                    throws java.sql.SQLException

Creates a DmPreparedStatement designed for executeQuery (Lookup as opposed to update) java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE and java.sql.ResultSet.CONCUR_UPDATABLE are set PreparedStatement parameters:

Parameters:

con - The connection

sql - The sql

Throws:

java.sql.SQLException - On error preparing the statement

DmPreparedStatement

public DmPreparedStatement(@NotNull
                           java.sql.Connection con,
                           @NotNull
                           java.lang.CharSequence sql,
                           int autoGeneratedKeys)
                    throws java.sql.SQLException

Creates a DmPreparedStatement from the given sql statement with optional retrieval of auto generated keys

Parameters:

con - The connection

sql - The sql

autoGeneratedKeys - The return auto generated keys setting

Throws:

java.sql.SQLException - On error preparing the statement

DmPreparedStatement

public DmPreparedStatement(@NotNull
                           java.sql.Connection con,
                           @NotNull
                           java.lang.CharSequence sql,
                           java.lang.String[] pk)
                    throws java.sql.SQLException

Throws:

java.sql.SQLException

Method Detail

prepareQuery

@NotNull
public static DmPreparedStatement prepareQuery(@NotNull
                                                         java.sql.Connection con,
                                                         @NotNull
                                                         java.lang.String sql,
                                                         @NotNull
                                                         java.util.Map<java.lang.String,DataObject> values)
                                                  throws java.sql.SQLException

Throws:

java.sql.SQLException

init

void init(java.sql.PreparedStatement ps,
          @NotNull
          java.lang.CharSequence sql)

getSql

public java.lang.String getSql()

returns the Sql String that was used to create the PreparedStatement

Returns:

String representation of Sql set in the PreparedStatement

getRunTime

public long getRunTime()

getData

@NotNull
public java.util.List<DataObject> getData()

returns all the set data as a List of DataObjects

Returns:

DataObjects that are set in the PreparedStatement

getData

public DataObject getData(int i)

returns the data set in te ith position as a DataObject

Parameters:

i - The offset for which to get data

Returns:

ith DataObject set in the PreparedStatement

setData

public void setData(int i,
                    @Nullable
                    DataObject data)
             throws java.sql.SQLException

Set the designated parameter of the given DataNode value. The driver converts this to its corresponding SQL type when it sends it to the database.

Parameters:

i - The offset

data - The value to set

Throws:

java.sql.SQLException - On error setting the value

setData

public void setData(@NotNull
                    java.util.List<DataObject> data)
             throws java.sql.SQLException

Sets the PreparedStatement parameter with data, the List must be in the same order as its corresponding parameters in the PreparedStatement

Parameters:

data - The data to set

Throws:

java.sql.SQLException - On error setting the data

executeQueryGetMapList

@NotNull
public java.util.List<java.util.Map<java.lang.String,DataObject>> executeQueryGetMapList()
                                                                                            throws java.sql.SQLException

executes the query normally except instead of returning a ResultSet it returns a List of Map<String columnName, DataObject values>

Returns:

List represents rows and Map represents columns of table

Throws:

java.sql.SQLException - On error executing the query

close

public void close()
           throws java.sql.SQLException

Specified by:

close in interface java.lang.AutoCloseable

Specified by:

close in interface java.sql.Statement

Throws:

java.sql.SQLException

executeQuery

public java.sql.ResultSet executeQuery()
                                throws java.sql.SQLException

Specified by:

executeQuery in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

executeUpdate

public int executeUpdate()
                  throws java.sql.SQLException

Specified by:

executeUpdate in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setNull

public void setNull(int parameterIndex,
                    int sqlType)
             throws java.sql.SQLException

Specified by:

setNull in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setBoolean

public void setBoolean(int parameterIndex,
                       boolean x)
                throws java.sql.SQLException

Specified by:

setBoolean in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setByte

public void setByte(int parameterIndex,
                    byte x)
             throws java.sql.SQLException

Specified by:

setByte in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setShort

public void setShort(int parameterIndex,
                     short x)
              throws java.sql.SQLException

Specified by:

setShort in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setInt

public void setInt(int parameterIndex,
                   int x)
            throws java.sql.SQLException

Specified by:

setInt in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setLong

public void setLong(int parameterIndex,
                    long x)
             throws java.sql.SQLException

Specified by:

setLong in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setFloat

public void setFloat(int parameterIndex,
                     float x)
              throws java.sql.SQLException

Specified by:

setFloat in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setDouble

public void setDouble(int parameterIndex,
                      double x)
               throws java.sql.SQLException

Specified by:

setDouble in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setBigDecimal

public void setBigDecimal(int parameterIndex,
                          java.math.BigDecimal x)
                   throws java.sql.SQLException

Specified by:

setBigDecimal in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setString

public void setString(int parameterIndex,
                      java.lang.String x)
               throws java.sql.SQLException

Specified by:

setString in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setBytes

public void setBytes(int parameterIndex,
                     byte[] x)
              throws java.sql.SQLException

Specified by:

setBytes in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setDate

public void setDate(int parameterIndex,
                    java.sql.Date x)
             throws java.sql.SQLException

Specified by:

setDate in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setTime

public void setTime(int parameterIndex,
                    java.sql.Time x)
             throws java.sql.SQLException

Specified by:

setTime in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setTimestamp

public void setTimestamp(int parameterIndex,
                         java.sql.Timestamp x)
                  throws java.sql.SQLException

Specified by:

setTimestamp in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setAsciiStream

public void setAsciiStream(int parameterIndex,
                           java.io.InputStream x,
                           int length)
                    throws java.sql.SQLException

Specified by:

setAsciiStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setUnicodeStream

@Deprecated
public void setUnicodeStream(int parameterIndex,
                                          java.io.InputStream x,
                                          int length)
                                   throws java.sql.SQLException

Deprecated.

Specified by:

setUnicodeStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setBinaryStream

public void setBinaryStream(int parameterIndex,
                            java.io.InputStream x,
                            int length)
                     throws java.sql.SQLException

Specified by:

setBinaryStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

clearParameters

public void clearParameters()
                     throws java.sql.SQLException

Specified by:

clearParameters in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setObject

public void setObject(int parameterIndex,
                      java.lang.Object x,
                      int targetSqlType)
               throws java.sql.SQLException

Specified by:

setObject in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setObject

public void setObject(int parameterIndex,
                      java.lang.Object x)
               throws java.sql.SQLException

Specified by:

setObject in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

execute

public boolean execute()
                throws java.sql.SQLException

Specified by:

execute in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

addBatch

public void addBatch()
              throws java.sql.SQLException

Specified by:

addBatch in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setCharacterStream

public void setCharacterStream(int parameterIndex,
                               java.io.Reader reader,
                               int length)
                        throws java.sql.SQLException

Specified by:

setCharacterStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setRef

public void setRef(int parameterIndex,
                   java.sql.Ref x)
            throws java.sql.SQLException

Specified by:

setRef in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setBlob

public void setBlob(int parameterIndex,
                    java.sql.Blob x)
             throws java.sql.SQLException

Specified by:

setBlob in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setClob

public void setClob(int parameterIndex,
                    java.sql.Clob x)
             throws java.sql.SQLException

Specified by:

setClob in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setArray

public void setArray(int parameterIndex,
                     java.sql.Array x)
              throws java.sql.SQLException

Specified by:

setArray in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

getMetaData

public java.sql.ResultSetMetaData getMetaData()
                                       throws java.sql.SQLException

Specified by:

getMetaData in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setDate

public void setDate(int parameterIndex,
                    java.sql.Date x,
                    java.util.Calendar calendar)
             throws java.sql.SQLException

Specified by:

setDate in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setTime

public void setTime(int parameterIndex,
                    java.sql.Time x,
                    java.util.Calendar calendar)
             throws java.sql.SQLException

Specified by:

setTime in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setTimestamp

public void setTimestamp(int parameterIndex,
                         java.sql.Timestamp x,
                         java.util.Calendar calendar)
                  throws java.sql.SQLException

Specified by:

setTimestamp 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

Specified by:

setNull in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setURL

public void setURL(int parameterIndex,
                   java.net.URL x)
            throws java.sql.SQLException

Specified by:

setURL in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

getParameterMetaData

public java.sql.ParameterMetaData getParameterMetaData()
                                                throws java.sql.SQLException

Specified by:

getParameterMetaData 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

setObject

public void setObject(int i,
                      java.lang.Object o,
                      int i1,
                      int i2)
               throws java.sql.SQLException

Specified by:

setObject in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setAsciiStream

public void setAsciiStream(int i,
                           java.io.InputStream in,
                           long l)
                    throws java.sql.SQLException

Specified by:

setAsciiStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setBinaryStream

public void setBinaryStream(int i,
                            java.io.InputStream in,
                            long l)
                     throws java.sql.SQLException

Specified by:

setBinaryStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setCharacterStream

public void setCharacterStream(int i,
                               java.io.Reader reader,
                               long l)
                        throws java.sql.SQLException

Specified by:

setCharacterStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setAsciiStream

public void setAsciiStream(int i,
                           java.io.InputStream in)
                    throws java.sql.SQLException

Specified by:

setAsciiStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setBinaryStream

public void setBinaryStream(int i,
                            java.io.InputStream in)
                     throws java.sql.SQLException

Specified by:

setBinaryStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setCharacterStream

public void setCharacterStream(int i,
                               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 i,
                                java.io.Reader reader)
                         throws java.sql.SQLException

Specified by:

setNCharacterStream in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setClob

public void setClob(int i,
                    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 i,
                    java.io.InputStream in)
             throws java.sql.SQLException

Specified by:

setBlob in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

setNClob

public void setNClob(int i,
                     java.io.Reader reader)
              throws java.sql.SQLException

Specified by:

setNClob in interface java.sql.PreparedStatement

Throws:

java.sql.SQLException

executeQuery

public java.sql.ResultSet executeQuery(java.lang.String string)
                                throws java.sql.SQLException

Specified by:

executeQuery in interface java.sql.Statement

Throws:

java.sql.SQLException

executeUpdate

public int executeUpdate(java.lang.String string)
                  throws java.sql.SQLException

Specified by:

executeUpdate in interface java.sql.Statement

Throws:

java.sql.SQLException

getMaxFieldSize

public int getMaxFieldSize()
                    throws java.sql.SQLException

Specified by:

getMaxFieldSize in interface java.sql.Statement

Throws:

java.sql.SQLException

setMaxFieldSize

public void setMaxFieldSize(int i)
                     throws java.sql.SQLException

Specified by:

setMaxFieldSize in interface java.sql.Statement

Throws:

java.sql.SQLException

getMaxRows

public int getMaxRows()
               throws java.sql.SQLException

Specified by:

getMaxRows in interface java.sql.Statement

Throws:

java.sql.SQLException

setMaxRows

public void setMaxRows(int i)
                throws java.sql.SQLException

Specified by:

setMaxRows in interface java.sql.Statement

Throws:

java.sql.SQLException

setEscapeProcessing

public void setEscapeProcessing(boolean bln)
                         throws java.sql.SQLException

Specified by:

setEscapeProcessing in interface java.sql.Statement

Throws:

java.sql.SQLException

getQueryTimeout

public int getQueryTimeout()
                    throws java.sql.SQLException

Specified by:

getQueryTimeout in interface java.sql.Statement

Throws:

java.sql.SQLException

setQueryTimeout

public void setQueryTimeout(int i)
                     throws java.sql.SQLException

Specified by:

setQueryTimeout in interface java.sql.Statement

Throws:

java.sql.SQLException

cancel

public void cancel()
            throws java.sql.SQLException

Specified by:

cancel in interface java.sql.Statement

Throws:

java.sql.SQLException

getWarnings

public java.sql.SQLWarning getWarnings()
                                throws java.sql.SQLException

Specified by:

getWarnings in interface java.sql.Statement

Throws:

java.sql.SQLException

clearWarnings

public void clearWarnings()
                   throws java.sql.SQLException

Specified by:

clearWarnings in interface java.sql.Statement

Throws:

java.sql.SQLException

setCursorName

public void setCursorName(java.lang.String string)
                   throws java.sql.SQLException

Specified by:

setCursorName in interface java.sql.Statement

Throws:

java.sql.SQLException

execute

public boolean execute(java.lang.String string)
                throws java.sql.SQLException

Specified by:

execute in interface java.sql.Statement

Throws:

java.sql.SQLException

getResultSet

public java.sql.ResultSet getResultSet()
                                throws java.sql.SQLException

Specified by:

getResultSet in interface java.sql.Statement

Throws:

java.sql.SQLException

getUpdateCount

public int getUpdateCount()
                   throws java.sql.SQLException

Specified by:

getUpdateCount in interface java.sql.Statement

Throws:

java.sql.SQLException

getMoreResults

public boolean getMoreResults()
                       throws java.sql.SQLException

Specified by:

getMoreResults in interface java.sql.Statement

Throws:

java.sql.SQLException

setFetchDirection

public void setFetchDirection(int i)
                       throws java.sql.SQLException

Specified by:

setFetchDirection in interface java.sql.Statement

Throws:

java.sql.SQLException

getFetchDirection

public int getFetchDirection()
                      throws java.sql.SQLException

Specified by:

getFetchDirection in interface java.sql.Statement

Throws:

java.sql.SQLException

setFetchSize

public void setFetchSize(int i)
                  throws java.sql.SQLException

Specified by:

setFetchSize in interface java.sql.Statement

Throws:

java.sql.SQLException

getFetchSize

public int getFetchSize()
                 throws java.sql.SQLException

Specified by:

getFetchSize in interface java.sql.Statement

Throws:

java.sql.SQLException

getResultSetConcurrency

public int getResultSetConcurrency()
                            throws java.sql.SQLException

Specified by:

getResultSetConcurrency in interface java.sql.Statement

Throws:

java.sql.SQLException

getResultSetType

public int getResultSetType()
                     throws java.sql.SQLException

Specified by:

getResultSetType in interface java.sql.Statement

Throws:

java.sql.SQLException

addBatch

public void addBatch(java.lang.String string)
              throws java.sql.SQLException

Specified by:

addBatch in interface java.sql.Statement

Throws:

java.sql.SQLException

clearBatch

public void clearBatch()
                throws java.sql.SQLException

Specified by:

clearBatch in interface java.sql.Statement

Throws:

java.sql.SQLException

executeBatch

public int[] executeBatch()
                   throws java.sql.SQLException

Specified by:

executeBatch in interface java.sql.Statement

Throws:

java.sql.SQLException

getConnection

public java.sql.Connection getConnection()
                                  throws java.sql.SQLException

Specified by:

getConnection in interface java.sql.Statement

Throws:

java.sql.SQLException

getMoreResults

public boolean getMoreResults(int current)
                       throws java.sql.SQLException

Specified by:

getMoreResults in interface java.sql.Statement

Throws:

java.sql.SQLException

getGeneratedKeys

public java.sql.ResultSet getGeneratedKeys()
                                    throws java.sql.SQLException

Specified by:

getGeneratedKeys in interface java.sql.Statement

Throws:

java.sql.SQLException

executeUpdate

public int executeUpdate(java.lang.String sql,
                         int autoGeneratedKeys)
                  throws java.sql.SQLException

Specified by:

executeUpdate in interface java.sql.Statement

Throws:

java.sql.SQLException

executeUpdate

public int executeUpdate(java.lang.String sql,
                         int[] columnIndexes)
                  throws java.sql.SQLException

Specified by:

executeUpdate in interface java.sql.Statement

Throws:

java.sql.SQLException

executeUpdate

public int executeUpdate(java.lang.String sql,
                         java.lang.String[] columnNames)
                  throws java.sql.SQLException

Specified by:

executeUpdate in interface java.sql.Statement

Throws:

java.sql.SQLException

execute

public boolean execute(java.lang.String sql,
                       int autoGeneratedKeys)
                throws java.sql.SQLException

Specified by:

execute in interface java.sql.Statement

Throws:

java.sql.SQLException

execute

public boolean execute(java.lang.String sql,
                       int[] columnIndexes)
                throws java.sql.SQLException

Specified by:

execute in interface java.sql.Statement

Throws:

java.sql.SQLException

execute

public boolean execute(java.lang.String sql,
                       java.lang.String[] columnNames)
                throws java.sql.SQLException

Specified by:

execute in interface java.sql.Statement

Throws:

java.sql.SQLException

getResultSetHoldability

public int getResultSetHoldability()
                            throws java.sql.SQLException

Specified by:

getResultSetHoldability in interface java.sql.Statement

Throws:

java.sql.SQLException

isClosed

public boolean isClosed()
                 throws java.sql.SQLException

Specified by:

isClosed in interface java.sql.Statement

Throws:

java.sql.SQLException

setPoolable

public void setPoolable(boolean poolable)
                 throws java.sql.SQLException

Specified by:

setPoolable in interface java.sql.Statement

Throws:

java.sql.SQLException

isPoolable

public boolean isPoolable()
                   throws java.sql.SQLException

Specified by:

isPoolable in interface java.sql.Statement

Throws:

java.sql.SQLException

unwrap

public <T> T unwrap(java.lang.Class<T> type)
             throws java.sql.SQLException

Specified by:

unwrap in interface java.sql.Wrapper

Throws:

java.sql.SQLException

isWrapperFor

public boolean isWrapperFor(java.lang.Class<?> type)
                     throws java.sql.SQLException

Specified by:

isWrapperFor in interface java.sql.Wrapper

Throws:

java.sql.SQLException

closeOnCompletion

public void closeOnCompletion()
                       throws java.sql.SQLException

Specified by:

closeOnCompletion in interface java.sql.Statement

Throws:

java.sql.SQLException

isCloseOnCompletion

public boolean isCloseOnCompletion()
                            throws java.sql.SQLException

Specified by:

isCloseOnCompletion in interface java.sql.Statement

Throws:

java.sql.SQLException