Class StasiPreparedStatement

java.lang.Object

clazzfish.jdbc.internal.StasiStatement

clazzfish.jdbc.internal.StasiPreparedStatement

All Implemented Interfaces:

AutoCloseable, PreparedStatement, Statement, Wrapper

public final class StasiPreparedStatement
extends StasiStatement
implements PreparedStatement

A simple wrapper for PreparedStatement to be able to find resource problems while reading and writing to the database. It allows us also to measure times of SQL statements.

Why the name "Stasi..."? The Stasi was the official state security service of Eastern Germany which controls the people (like NSA in the U.S. or KGB in Russia, see also Wikipedia). The StasiPreparedStatement controls the embedded PreparedStatement - therefore the name.

Author:

oliver

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	Description
StasiPreparedStatement(PreparedStatement statement, Object... args)	Instantiates a new stasi prepared statement.

Method Summary

Modifier and Type	Method	Description
void	addBatch()	Adds the batch.
void	clearParameters()	Clear parameters.
void	close()	Close the statement.
boolean	execute()	Execute.
ResultSet	executeQuery()	Execute query.
int	executeUpdate()	Execute update.
ResultSetMetaData	getMetaData()	Gets the meta data.
ParameterMetaData	getParameterMetaData()	Gets the parameter meta data.
PreparedStatement	getWrappedPreparedStatement()	In some cicrumstances you may want to acces the original PreparedStatement directly.
void	setArray(int arg0, Array arg1)	Sets the array.
void	setAsciiStream(int arg0, InputStream arg1)	Sets the ascii stream.
void	setAsciiStream(int arg0, InputStream arg1, int arg2)	Sets the ascii stream.
void	setAsciiStream(int arg0, InputStream arg1, long arg2)	Sets the ascii stream.
void	setBigDecimal(int arg0, BigDecimal arg1)	Sets the big decimal.
void	setBinaryStream(int arg0, InputStream arg1)	Sets the binary stream.
void	setBinaryStream(int arg0, InputStream arg1, int arg2)	Sets the binary stream.
void	setBinaryStream(int arg0, InputStream arg1, long arg2)	Sets the binary stream.
void	setBlob(int arg0, InputStream arg1)	Sets the blob.
void	setBlob(int arg0, InputStream arg1, long arg2)	Sets the blob.
void	setBlob(int arg0, Blob arg1)	Sets the blob.
void	setBoolean(int arg0, boolean arg1)	Sets the boolean.
void	setByte(int arg0, byte arg1)	Sets the byte.
void	setBytes(int arg0, byte[] arg1)	Sets the bytes.
void	setCharacterStream(int arg0, Reader arg1)	Sets the character stream.
void	setCharacterStream(int arg0, Reader arg1, int arg2)	Sets the character stream.
void	setCharacterStream(int arg0, Reader arg1, long arg2)	Sets the character stream.
void	setClob(int arg0, Reader arg1)	Sets the clob.
void	setClob(int arg0, Reader arg1, long arg2)	Sets the clob.
void	setClob(int arg0, Clob arg1)	Sets the clob.
void	setDate(int arg0, Date arg1)	Sets the date.
void	setDate(int arg0, Date arg1, Calendar arg2)	Sets the date.
void	setDouble(int arg0, double arg1)	Sets the double.
void	setFloat(int arg0, float arg1)	Sets the float.
void	setInt(int arg0, int arg1)	Sets the int.
void	setLong(int arg0, long arg1)	Sets the long.
void	setNCharacterStream(int arg0, Reader arg1)	Sets the n character stream.
void	setNCharacterStream(int arg0, Reader arg1, long arg2)	Sets the n character stream.
void	setNClob(int arg0, Reader arg1)	Sets the n clob.
void	setNClob(int arg0, Reader arg1, long arg2)	Sets the n clob.
void	setNClob(int arg0, NClob arg1)	Sets the n clob.
void	setNString(int arg0, String arg1)	Sets the n string.
void	setNull(int arg0, int arg1)	Sets the null.
void	setNull(int arg0, int arg1, String arg2)	Sets the null.
void	setObject(int arg0, Object arg1)	Sets the object.
void	setObject(int arg0, Object arg1, int arg2)	Sets the object.
void	setObject(int arg0, Object arg1, int arg2, int arg3)	Sets the object.
void	setRef(int arg0, Ref arg1)	Sets the ref.
void	setRowId(int arg0, RowId arg1)	Sets the row id.
void	setShort(int arg0, short arg1)	Sets the short.
void	setSQLXML(int arg0, SQLXML arg1)	Sets the sqlxml.
void	setString(int arg0, String arg1)	Sets the string.
void	setTime(int arg0, Time arg1)	Sets the time.
void	setTime(int arg0, Time arg1, Calendar arg2)	Sets the time.
void	setTimestamp(int arg0, Timestamp arg1)	Sets the timestamp.
void	setTimestamp(int arg0, Timestamp arg1, Calendar arg2)	Sets the timestamp.
void	setUnicodeStream(int arg0, InputStream arg1, int arg2)	Sets the unicode stream.
void	setURL(int arg0, URL arg1)	Sets the url.
String	toString()	We want to return the real SQL as string represenation.

Methods inherited from class clazzfish.jdbc.internal.StasiStatement

addBatch, cancel, clearBatch, clearWarnings, closeOnCompletion, enrichedSQLException, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getCallerStacktrace, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getStatement, getUpdateCount, getUpdated, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isWrapperFor, saveUpdateStatistic, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, unwrap

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, enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, 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, isSimpleIdentifier, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout

Methods inherited from interface java.sql.Wrapper

isWrapperFor, unwrap

Constructor Details

StasiPreparedStatement

public StasiPreparedStatement(PreparedStatement statement,
 Object... args)

Instantiates a new stasi prepared statement.

Parameters:

statement - the statement

args - the arguments for the creation of the PreparedStatement

Method Details

getWrappedPreparedStatement

public PreparedStatement getWrappedPreparedStatement()

In some cicrumstances you may want to acces the original PreparedStatement directly. Use this method to get it.

Returns:

the wrapped PreparedStatement

Since:

1.6.2

addBatch

public void addBatch()
              throws SQLException

Adds the batch.

Specified by:

addBatch in interface PreparedStatement

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.addBatch()

clearParameters

public void clearParameters()
                     throws SQLException

Clear parameters.

Specified by:

clearParameters in interface PreparedStatement

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.clearParameters()

close

public void close()
           throws SQLException

Close the statement. Because we want to log the SQL we do not call the superclass here but do the close ourself.

Specified by:

close in interface AutoCloseable

Specified by:

close in interface Statement

Overrides:

close in class StasiStatement

Throws:

SQLException - the sQL exception

See Also:

• Statement.close()

execute

public boolean execute()
                throws SQLException

Execute.

Specified by:

execute in interface PreparedStatement

Returns:

true, if successful

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.execute()

executeQuery

public ResultSet executeQuery()
                       throws SQLException

Execute query.

NOTE: The ResultSet which is returned by this method must be closed by the caller.

Specified by:

executeQuery in interface PreparedStatement

Returns:

an open result set

Throws:

SQLException - in case of DB problems

See Also:

• PreparedStatement.executeQuery()

executeUpdate

public int executeUpdate()
                  throws SQLException

Execute update.

Specified by:

executeUpdate in interface PreparedStatement

Returns:

the int

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.executeUpdate()

getMetaData

public ResultSetMetaData getMetaData()
                              throws SQLException

Gets the meta data.

Specified by:

getMetaData in interface PreparedStatement

Returns:

the meta data

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.getMetaData()

getParameterMetaData

public ParameterMetaData getParameterMetaData()
                                       throws SQLException

Gets the parameter meta data.

Specified by:

getParameterMetaData in interface PreparedStatement

Returns:

the parameter meta data

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.getParameterMetaData()

setArray

public void setArray(int arg0,
 Array arg1)
              throws SQLException

Sets the array.

Specified by:

setArray in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setArray(int, Array)

setAsciiStream

public void setAsciiStream(int arg0,
 InputStream arg1,
 int arg2)
                    throws SQLException

Sets the ascii stream.

Specified by:

setAsciiStream in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

arg2 - the arg2

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setAsciiStream(int, InputStream, int)

setAsciiStream

public void setAsciiStream(int arg0,
 InputStream arg1,
 long arg2)
                    throws SQLException

Sets the ascii stream.

Specified by:

setAsciiStream in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

arg2 - the arg2

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setAsciiStream(int, InputStream, long)

setAsciiStream

public void setAsciiStream(int arg0,
 InputStream arg1)
                    throws SQLException

Sets the ascii stream.

Specified by:

setAsciiStream in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setAsciiStream(int, InputStream)

setBigDecimal

public void setBigDecimal(int arg0,
 BigDecimal arg1)
                   throws SQLException

Sets the big decimal.

Specified by:

setBigDecimal in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setBigDecimal(int, BigDecimal)

setBinaryStream

public void setBinaryStream(int arg0,
 InputStream arg1,
 int arg2)
                     throws SQLException

Sets the binary stream.

Specified by:

setBinaryStream in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

arg2 - the arg2

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setBinaryStream(int, InputStream, int)

setBinaryStream

public void setBinaryStream(int arg0,
 InputStream arg1,
 long arg2)
                     throws SQLException

Sets the binary stream.

Specified by:

setBinaryStream in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

arg2 - the arg2

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setBinaryStream(int, InputStream, long)

setBinaryStream

public void setBinaryStream(int arg0,
 InputStream arg1)
                     throws SQLException

Sets the binary stream.

Specified by:

setBinaryStream in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setBinaryStream(int, InputStream)

setBlob

public void setBlob(int arg0,
 Blob arg1)
             throws SQLException

Sets the blob.

Specified by:

setBlob in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setBlob(int, Blob)

setBlob

public void setBlob(int arg0,
 InputStream arg1,
 long arg2)
             throws SQLException

Sets the blob.

Specified by:

setBlob in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

arg2 - the arg2

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setBlob(int, InputStream, long)

setBlob

public void setBlob(int arg0,
 InputStream arg1)
             throws SQLException

Sets the blob.

Specified by:

setBlob in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setBlob(int, InputStream)

setBoolean

public void setBoolean(int arg0,
 boolean arg1)
                throws SQLException

Sets the boolean.

Specified by:

setBoolean in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setBoolean(int, boolean)

setByte

public void setByte(int arg0,
 byte arg1)
             throws SQLException

Sets the byte.

Specified by:

setByte in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setByte(int, byte)

setBytes

public void setBytes(int arg0,
 byte[] arg1)
              throws SQLException

Sets the bytes.

Specified by:

setBytes in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setBytes(int, byte[])

setCharacterStream

public void setCharacterStream(int arg0,
 Reader arg1,
 int arg2)
                        throws SQLException

Sets the character stream.

Specified by:

setCharacterStream in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

arg2 - the arg2

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setCharacterStream(int, Reader, int)

setCharacterStream

public void setCharacterStream(int arg0,
 Reader arg1,
 long arg2)
                        throws SQLException

Sets the character stream.

Specified by:

setCharacterStream in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

arg2 - the arg2

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setCharacterStream(int, Reader, long)

setCharacterStream

public void setCharacterStream(int arg0,
 Reader arg1)
                        throws SQLException

Sets the character stream.

Specified by:

setCharacterStream in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setCharacterStream(int, Reader)

setClob

public void setClob(int arg0,
 Clob arg1)
             throws SQLException

Sets the clob.

Specified by:

setClob in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setClob(int, Clob)

setClob

public void setClob(int arg0,
 Reader arg1,
 long arg2)
             throws SQLException

Sets the clob.

Specified by:

setClob in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

arg2 - the arg2

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setClob(int, Reader, long)

setClob

public void setClob(int arg0,
 Reader arg1)
             throws SQLException

Sets the clob.

Specified by:

setClob in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setClob(int, Reader)

setDate

public void setDate(int arg0,
 Date arg1,
 Calendar arg2)
             throws SQLException

Sets the date.

Specified by:

setDate in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

arg2 - the arg2

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setDate(int, Date, Calendar)

setDate

public void setDate(int arg0,
 Date arg1)
             throws SQLException

Sets the date.

Specified by:

setDate in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setDate(int, Date)

setDouble

public void setDouble(int arg0,
 double arg1)
               throws SQLException

Sets the double.

Specified by:

setDouble in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setDouble(int, double)

setFloat

public void setFloat(int arg0,
 float arg1)
              throws SQLException

Sets the float.

Specified by:

setFloat in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setFloat(int, float)

setInt

public void setInt(int arg0,
 int arg1)
            throws SQLException

Sets the int.

Specified by:

setInt in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setInt(int, int)

setLong

public void setLong(int arg0,
 long arg1)
             throws SQLException

Sets the long.

Specified by:

setLong in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setLong(int, long)

setNCharacterStream

public void setNCharacterStream(int arg0,
 Reader arg1,
 long arg2)
                         throws SQLException

Sets the n character stream.

Specified by:

setNCharacterStream in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

arg2 - the arg2

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setNCharacterStream(int, Reader, long)

setNCharacterStream

public void setNCharacterStream(int arg0,
 Reader arg1)
                         throws SQLException

Sets the n character stream.

Specified by:

setNCharacterStream in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setNCharacterStream(int, Reader)

setNClob

public void setNClob(int arg0,
 NClob arg1)
              throws SQLException

Sets the n clob.

Specified by:

setNClob in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setNClob(int, NClob)

setNClob

public void setNClob(int arg0,
 Reader arg1,
 long arg2)
              throws SQLException

Sets the n clob.

Specified by:

setNClob in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

arg2 - the arg2

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setNClob(int, Reader, long)

setNClob

public void setNClob(int arg0,
 Reader arg1)
              throws SQLException

Sets the n clob.

Specified by:

setNClob in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setNClob(int, Reader)

setNString

public void setNString(int arg0,
 String arg1)
                throws SQLException

Sets the n string.

Specified by:

setNString in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setNString(int, String)

setNull

public void setNull(int arg0,
 int arg1,
 String arg2)
             throws SQLException

Sets the null.

Specified by:

setNull in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

arg2 - the arg2

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setNull(int, int, String)

setNull

public void setNull(int arg0,
 int arg1)
             throws SQLException

Sets the null.

Specified by:

setNull in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setNull(int, int)

setObject

public void setObject(int arg0,
 Object arg1,
 int arg2,
 int arg3)
               throws SQLException

Sets the object.

Specified by:

setObject in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

arg2 - the arg2

arg3 - the arg3

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setObject(int, Object, int, int)

setObject

public void setObject(int arg0,
 Object arg1,
 int arg2)
               throws SQLException

Sets the object.

Specified by:

setObject in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

arg2 - the arg2

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setObject(int, Object, int)

setObject

public void setObject(int arg0,
 Object arg1)
               throws SQLException

Sets the object.

Specified by:

setObject in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setObject(int, Object)

setRef

public void setRef(int arg0,
 Ref arg1)
            throws SQLException

Sets the ref.

Specified by:

setRef in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setRef(int, Ref)

setRowId

public void setRowId(int arg0,
 RowId arg1)
              throws SQLException

Sets the row id.

Specified by:

setRowId in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setRowId(int, RowId)

setSQLXML

public void setSQLXML(int arg0,
 SQLXML arg1)
               throws SQLException

Sets the sqlxml.

Specified by:

setSQLXML in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setSQLXML(int, SQLXML)

setShort

public void setShort(int arg0,
 short arg1)
              throws SQLException

Sets the short.

Specified by:

setShort in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setShort(int, short)

setString

public void setString(int arg0,
 String arg1)
               throws SQLException

Sets the string.

Specified by:

setString in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setString(int, String)

setTime

public void setTime(int arg0,
 Time arg1,
 Calendar arg2)
             throws SQLException

Sets the time.

Specified by:

setTime in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

arg2 - the arg2

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setTime(int, Time, Calendar)

setTime

public void setTime(int arg0,
 Time arg1)
             throws SQLException

Sets the time.

Specified by:

setTime in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setTime(int, Time)

setTimestamp

public void setTimestamp(int arg0,
 Timestamp arg1,
 Calendar arg2)
                  throws SQLException

Sets the timestamp.

Specified by:

setTimestamp in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

arg2 - the arg2

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setTimestamp(int, Timestamp, Calendar)

setTimestamp

public void setTimestamp(int arg0,
 Timestamp arg1)
                  throws SQLException

Sets the timestamp.

Specified by:

setTimestamp in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setTimestamp(int, Timestamp)

setURL

public void setURL(int arg0,
 URL arg1)
            throws SQLException

Sets the url.

Specified by:

setURL in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

Throws:

SQLException - the sQL exception

See Also:

• PreparedStatement.setURL(int, URL)

setUnicodeStream

public void setUnicodeStream(int arg0,
 InputStream arg1,
 int arg2)
                      throws SQLException

Sets the unicode stream.

Specified by:

setUnicodeStream in interface PreparedStatement

Parameters:

arg0 - the arg0

arg1 - the arg1

arg2 - the arg2

Throws:

SQLException - the sQL exception

toString

public String toString()

We want to return the real SQL as string represenation.

Overrides:

toString in class StasiStatement

Returns:

the string

See Also:

• Object.toString()