Package com.gengoai.sql

Class NamedPreparedStatement

java.lang.Object

com.gengoai.sql.NamedPreparedStatement

All Implemented Interfaces:

AutoCloseable, PreparedStatement, Statement, Wrapper

public class NamedPreparedStatement
extends Object
implements PreparedStatement

This class wraps a PreparedStatement allowing the parameters to be named. Named parameters are positioned inside of [::], for example if the parameter was named 'id' it would be represented as [:id:]. This class has all the same methods as a PreparedStatement, but also includes set methods where the name can be specified.

Author:

David B. Bracewell

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
NamedPreparedStatement(Connection connection, String sql)	Creates a new NamedPreparedStatement using an existing connection and SQL string.
NamedPreparedStatement(Connection connection, String sql, boolean generateKeys)	Creates a new NamedPreparedStatement using an existing connection and SQL string.

Method Summary

Modifier and Type	Method	Description
void	addBatch()
void	addBatch(String arg0)
void	cancel()
void	clearBatch()
void	clearParameters()
void	clearWarnings()
void	close()
void	closeOnCompletion()
boolean	containsNamedParameter(String parameterName)	Determines if a named parameter exists in this statement.
boolean	execute()
boolean	execute(String arg0)
boolean	execute(String arg0, int arg1)
boolean	execute(String arg0, int[] arg1)
boolean	execute(String arg0, String[] arg1)
int[]	executeBatch()
ResultSet	executeQuery()
ResultSet	executeQuery(String arg0)
int	executeUpdate()
int	executeUpdate(String arg0)
int	executeUpdate(String arg0, int arg1)
int	executeUpdate(String arg0, int[] arg1)
int	executeUpdate(String arg0, String[] arg1)
void	fromMap(@NonNull Map<String,?> map)
Connection	getConnection()
int	getFetchDirection()
int	getFetchSize()
ResultSet	getGeneratedKeys()
protected Collection<Integer>	getLocationsForName(String name)
int	getMaxFieldSize()
int	getMaxRows()
ResultSetMetaData	getMetaData()
boolean	getMoreResults()
boolean	getMoreResults(int arg0)
ParameterMetaData	getParameterMetaData()
int	getQueryTimeout()
ResultSet	getResultSet()
int	getResultSetConcurrency()
int	getResultSetHoldability()
int	getResultSetType()
int	getUpdateCount()
SQLWarning	getWarnings()
protected void	init(Connection connection, String sql, boolean generateKeys)
boolean	isClosed()
boolean	isCloseOnCompletion()
boolean	isPoolable()
boolean	isWrapperFor(Class<?> arg0)
static String	sanitize(@NonNull String str)
void	setArray(int arg0, Array arg1)
void	setArray(String arg0, Array arg1)	Sets the designated parameter to the given Array object.
void	setAsciiStream(int arg0, InputStream arg1)
void	setAsciiStream(int arg0, InputStream arg1, int arg2)
void	setAsciiStream(int arg0, InputStream arg1, long arg2)
void	setAsciiStream(String arg0, InputStream arg1)	Sets the designated parameter to the given input stream, which will have the specified number of bytes.
void	setAsciiStream(String arg0, InputStream arg1, int arg2)	Sets the designated parameter to the given input stream, which will have the specified number of bytes.
void	setAsciiStream(String arg0, InputStream arg1, long arg2)	Sets the designated parameter to the given input stream, which will have the specified number of bytes.
void	setBigDecimal(int arg0, BigDecimal arg1)
void	setBigDecimal(String arg0, BigDecimal arg1)	Sets the designated parameter to the given java.math.BigDecimal value.
void	setBinaryStream(int arg0, InputStream arg1)
void	setBinaryStream(int arg0, InputStream arg1, int arg2)
void	setBinaryStream(int arg0, InputStream arg1, long arg2)
void	setBinaryStream(String arg0, InputStream arg1)	Sets the designated parameter to the given input stream.
void	setBinaryStream(String arg0, InputStream arg1, int arg2)	Sets the designated parameter to the given input stream, which will have the specified number of bytes.
void	setBinaryStream(String arg0, InputStream arg1, long arg2)	Sets the designated parameter to the given input stream, which will have the specified number of bytes.
void	setBlob(int arg0, InputStream arg1)
void	setBlob(int arg0, InputStream arg1, long arg2)
void	setBlob(int arg0, Blob arg1)
void	setBlob(String arg0, InputStream arg1)	Sets the designated parameter to a InputStream object.
void	setBlob(String arg0, InputStream arg1, long arg2)	Sets the designated parameter to a InputStream object.
void	setBlob(String arg0, Blob arg1)	Sets the designated parameter to the given java.sql.Blob object.
void	setBoolean(int arg0, boolean arg1)
void	setBoolean(String arg0, boolean arg1)	Sets the designated parameter to the given boolean value.
void	setByte(int arg0, byte arg1)
void	setByte(String arg0, byte arg1)	Sets the designated parameter to the given byte value.
void	setBytes(int arg0, byte[] arg1)
void	setBytes(String arg0, byte[] arg1)	Sets the designated parameter to the given Java array of bytes.
void	setCharacterStream(int arg0, Reader arg1)
void	setCharacterStream(int arg0, Reader arg1, int arg2)
void	setCharacterStream(int arg0, Reader arg1, long arg2)
void	setCharacterStream(String arg0, Reader arg1)	Sets the designated parameter to the given Reader object.
void	setCharacterStream(String arg0, Reader arg1, int arg2)	Sets the designated parameter to the given Reader object.
void	setCharacterStream(String arg0, Reader arg1, long arg2)	Sets the designated parameter to the given Reader object.
void	setClob(int arg0, Reader arg1)
void	setClob(int arg0, Reader arg1, long arg2)
void	setClob(int arg0, Clob arg1)
void	setClob(String arg0, Reader arg1)	Sets the designated parameter to a java.sql.Clob object.
void	setClob(String arg0, Reader arg1, long arg2)	Sets the designated parameter to a java.sql.Clob object.
void	setClob(String arg0, Clob arg1)	Sets the designated parameter to a java.sql.Clob object.
void	setCursorName(String arg0)
void	setDate(int arg0, Date arg1)
void	setDate(int arg0, Date arg1, Calendar arg2)
void	setDate(String arg0, Date arg1)	Sets the designated parameter to the given java.sql.Date value using the default time zone of the virtual machine that is running the application.
void	setDate(String arg0, Date arg1, Calendar arg2)	Sets the designated parameter to the given java.sql.Date value, using the given Calendar object.
void	setDouble(int arg0, double arg1)
void	setDouble(String arg0, double arg1)	Sets the designated parameter to the given Java double value.
void	setEscapeProcessing(boolean arg0)
void	setFetchDirection(int arg0)
void	setFetchSize(int arg0)
void	setFloat(int arg0, float arg1)
void	setFloat(String arg0, float arg1)	Sets the designated parameter to the given Java float value.
void	setInt(int arg0, int arg1)
void	setInt(String arg0, int arg1)	Sets the designated parameter to the given Java int value.
void	setLong(int arg0, long arg1)
void	setLong(String arg0, long arg1)	Sets the designated parameter to the given Java long value.
void	setMaxFieldSize(int arg0)
void	setMaxRows(int arg0)
void	setNCharacterStream(int arg0, Reader arg1)
void	setNCharacterStream(int arg0, Reader arg1, long arg2)
void	setNCharacterStream(String arg0, Reader arg1)	Sets the designated parameter to a Reader object.
void	setNCharacterStream(String arg0, Reader arg1, long arg2)	Sets the designated parameter to a Reader object.
void	setNClob(int arg0, Reader arg1)
void	setNClob(int arg0, Reader arg1, long arg2)
void	setNClob(int arg0, NClob arg1)
void	setNClob(String arg0, Reader arg1)	Sets the designated parameter to a Reader object.
void	setNClob(String arg0, Reader arg1, long arg2)	Sets the designated parameter to a Reader object.
void	setNClob(String arg0, NClob arg1)	Sets the designated parameter to a NClob object.
void	setNString(int arg0, String arg1)
void	setNString(String arg0, String arg1)	Sets the designated parameter to the given String object.
void	setNull(int arg0, int arg1)
void	setNull(int arg0, int arg1, String arg2)
void	setNull(String arg0, int arg1)	Sets the designated parameter to SQL NULL
void	setNull(String arg0, int arg1, String arg2)	Sets the designated parameter to SQL NULL.
void	setObject(int arg0, Object arg1)
void	setObject(int arg0, Object arg1, int arg2)
void	setObject(int arg0, Object arg1, int arg2, int arg3)
void	setObject(String arg0, Object arg1)	ets the value of the designated parameter using the given object.
void	setObject(String arg0, Object arg1, int arg2)
void	setObject(String arg0, Object arg1, int arg2, int arg3)
void	setPoolable(boolean arg0)
void	setQueryTimeout(int arg0)
void	setRef(int arg0, Ref arg1)
void	setRef(String arg0, Ref arg1)
void	setRowId(int arg0, RowId arg1)
void	setRowId(String arg0, RowId arg1)
void	setShort(int arg0, short arg1)
void	setShort(String arg0, short arg1)
void	setSQLXML(int arg0, SQLXML arg1)
void	setSQLXML(String arg0, SQLXML arg1)
void	setString(int arg0, String arg1)
void	setString(String arg0, String arg1)
void	setTime(int arg0, Time arg1)
void	setTime(int arg0, Time arg1, Calendar arg2)
void	setTime(String arg0, Time arg1)
void	setTime(String arg0, Time arg1, Calendar arg2)
void	setTimestamp(int arg0, Timestamp arg1)
void	setTimestamp(int arg0, Timestamp arg1, Calendar arg2)
void	setTimestamp(String arg0, Timestamp arg1)
void	setTimestamp(String arg0, Timestamp arg1, Calendar arg2)
void	setUnicodeStream(int arg0, InputStream arg1, int arg2)	Deprecated.
void	setURL(int arg0, URL arg1)
void	setURL(String arg0, URL arg1)
<T> T	unwrap(Class<T> arg0)

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

enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, getLargeMaxRows, getLargeUpdateCount, isSimpleIdentifier, setLargeMaxRows

Constructor Detail

NamedPreparedStatement

public NamedPreparedStatement(Connection connection,
                              String sql)
                       throws SQLException

Creates a new NamedPreparedStatement using an existing connection and SQL string.

Parameters:

connection - The connection to create the statement from

sql - The SQL statement

Throws:

SQLException - Something went wrong creating the statement

NamedPreparedStatement

public NamedPreparedStatement(Connection connection,
                              String sql,
                              boolean generateKeys)
                       throws SQLException

Creates a new NamedPreparedStatement using an existing connection and SQL string.

Parameters:

connection - The connection to create the statement from

sql - The SQL statement

generateKeys - - True will allow the getGeneratedKeys() method to return keys, false will not

Throws:

SQLException - Something went wrong creating the statement

Method Detail

sanitize

public static String sanitize(@NonNull
                              @NonNull String str)

addBatch

public void addBatch()
              throws SQLException

Specified by:

addBatch in interface PreparedStatement

Throws:

SQLException

addBatch

public void addBatch(String arg0)
              throws SQLException

Specified by:

addBatch in interface Statement

Throws:

SQLException

cancel

public void cancel()
            throws SQLException

Specified by:

cancel in interface Statement

Throws:

SQLException

clearBatch

public void clearBatch()
                throws SQLException

Specified by:

clearBatch in interface Statement

Throws:

SQLException

clearParameters

public void clearParameters()
                     throws SQLException

Specified by:

clearParameters in interface PreparedStatement

Throws:

SQLException

clearWarnings

public void clearWarnings()
                   throws SQLException

Specified by:

clearWarnings in interface Statement

Throws:

SQLException

close

public void close()
           throws SQLException

Specified by:

close in interface AutoCloseable

Specified by:

close in interface Statement

Throws:

SQLException

closeOnCompletion

public void closeOnCompletion()
                       throws SQLException

Specified by:

closeOnCompletion in interface Statement

Throws:

SQLException

containsNamedParameter

public boolean containsNamedParameter(String parameterName)

Determines if a named parameter exists in this statement.

Parameters:

parameterName - The name of the parameter to check for

Returns:

True - it exists, False - it does not exist

execute

public boolean execute()
                throws SQLException

Specified by:

execute in interface PreparedStatement

Throws:

SQLException

execute

public boolean execute(String arg0)
                throws SQLException

Specified by:

execute in interface Statement

Throws:

SQLException

execute

public boolean execute(String arg0,
                       int arg1)
                throws SQLException

Specified by:

execute in interface Statement

Throws:

SQLException

execute

public boolean execute(String arg0,
                       int[] arg1)
                throws SQLException

Specified by:

execute in interface Statement

Throws:

SQLException

execute

public boolean execute(String arg0,
                       String[] arg1)
                throws SQLException

Specified by:

execute in interface Statement

Throws:

SQLException

executeBatch

public int[] executeBatch()
                   throws SQLException

Specified by:

executeBatch in interface Statement

Throws:

SQLException

executeQuery

public ResultSet executeQuery()
                       throws SQLException

Specified by:

executeQuery in interface PreparedStatement

Throws:

SQLException

executeQuery

public ResultSet executeQuery(String arg0)
                       throws SQLException

Specified by:

executeQuery in interface Statement

Throws:

SQLException

executeUpdate

public int executeUpdate()
                  throws SQLException

Specified by:

executeUpdate in interface PreparedStatement

Throws:

SQLException

executeUpdate

public int executeUpdate(String arg0)
                  throws SQLException

Specified by:

executeUpdate in interface Statement

Throws:

SQLException

executeUpdate

public int executeUpdate(String arg0,
                         int arg1)
                  throws SQLException

Specified by:

executeUpdate in interface Statement

Throws:

SQLException

executeUpdate

public int executeUpdate(String arg0,
                         int[] arg1)
                  throws SQLException

Specified by:

executeUpdate in interface Statement

Throws:

SQLException

executeUpdate

public int executeUpdate(String arg0,
                         String[] arg1)
                  throws SQLException

Specified by:

executeUpdate in interface Statement

Throws:

SQLException

fromMap

public void fromMap(@NonNull
                    @NonNull Map<String,?> map)
             throws SQLException

Throws:

SQLException

getConnection

public Connection getConnection()
                         throws SQLException

Specified by:

getConnection in interface Statement

Throws:

SQLException

getFetchDirection

public int getFetchDirection()
                      throws SQLException

Specified by:

getFetchDirection in interface Statement

Throws:

SQLException

setFetchDirection

public void setFetchDirection(int arg0)
                       throws SQLException

Specified by:

setFetchDirection in interface Statement

Throws:

SQLException

getFetchSize

public int getFetchSize()
                 throws SQLException

Specified by:

getFetchSize in interface Statement

Throws:

SQLException

setFetchSize

public void setFetchSize(int arg0)
                  throws SQLException

Specified by:

setFetchSize in interface Statement

Throws:

SQLException

getGeneratedKeys

public ResultSet getGeneratedKeys()
                           throws SQLException

Specified by:

getGeneratedKeys in interface Statement

Throws:

SQLException

getLocationsForName

protected Collection<Integer> getLocationsForName(String name)

getMaxFieldSize

public int getMaxFieldSize()
                    throws SQLException

Specified by:

getMaxFieldSize in interface Statement

Throws:

SQLException

setMaxFieldSize

public void setMaxFieldSize(int arg0)
                     throws SQLException

Specified by:

setMaxFieldSize in interface Statement

Throws:

SQLException

getMaxRows

public int getMaxRows()
               throws SQLException

Specified by:

getMaxRows in interface Statement

Throws:

SQLException

setMaxRows

public void setMaxRows(int arg0)
                throws SQLException

Specified by:

setMaxRows in interface Statement

Throws:

SQLException

getMetaData

public ResultSetMetaData getMetaData()
                              throws SQLException

Specified by:

getMetaData in interface PreparedStatement

Throws:

SQLException

getMoreResults

public boolean getMoreResults()
                       throws SQLException

Specified by:

getMoreResults in interface Statement

Throws:

SQLException

getMoreResults

public boolean getMoreResults(int arg0)
                       throws SQLException

Specified by:

getMoreResults in interface Statement

Throws:

SQLException

getParameterMetaData

public ParameterMetaData getParameterMetaData()
                                       throws SQLException

Specified by:

getParameterMetaData in interface PreparedStatement

Throws:

SQLException

getQueryTimeout

public int getQueryTimeout()
                    throws SQLException

Specified by:

getQueryTimeout in interface Statement

Throws:

SQLException

setQueryTimeout

public void setQueryTimeout(int arg0)
                     throws SQLException

Specified by:

setQueryTimeout in interface Statement

Throws:

SQLException

getResultSet

public ResultSet getResultSet()
                       throws SQLException

Specified by:

getResultSet in interface Statement

Throws:

SQLException

getResultSetConcurrency

public int getResultSetConcurrency()
                            throws SQLException

Specified by:

getResultSetConcurrency in interface Statement

Throws:

SQLException

getResultSetHoldability

public int getResultSetHoldability()
                            throws SQLException

Specified by:

getResultSetHoldability in interface Statement

Throws:

SQLException

getResultSetType

public int getResultSetType()
                     throws SQLException

Specified by:

getResultSetType in interface Statement

Throws:

SQLException

getUpdateCount

public int getUpdateCount()
                   throws SQLException

Specified by:

getUpdateCount in interface Statement

Throws:

SQLException

getWarnings

public SQLWarning getWarnings()
                       throws SQLException

Specified by:

getWarnings in interface Statement

Throws:

SQLException

init

protected void init(Connection connection,
                    String sql,
                    boolean generateKeys)
             throws SQLException

Throws:

SQLException

isCloseOnCompletion

public boolean isCloseOnCompletion()
                            throws SQLException

Specified by:

isCloseOnCompletion in interface Statement

Throws:

SQLException

isClosed

public boolean isClosed()
                 throws SQLException

Specified by:

isClosed in interface Statement

Throws:

SQLException

isPoolable

public boolean isPoolable()
                   throws SQLException

Specified by:

isPoolable in interface Statement

Throws:

SQLException

setPoolable

public void setPoolable(boolean arg0)
                 throws SQLException

Specified by:

setPoolable in interface Statement

Throws:

SQLException

isWrapperFor

public boolean isWrapperFor(Class<?> arg0)
                     throws SQLException

Specified by:

isWrapperFor in interface Wrapper

Throws:

SQLException

setArray

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

Specified by:

setArray in interface PreparedStatement

Throws:

SQLException

setArray

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

Sets the designated parameter to the given Array object.

Parameters:

arg0 - The name of the parameter

arg1 - an Array object that maps an SQL ARRAY value

Throws:

SQLException - if a database access error occurs or the name does not exist

setAsciiStream

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

Specified by:

setAsciiStream in interface PreparedStatement

Throws:

SQLException

setAsciiStream

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

Sets the designated parameter to the given input stream, which will have the specified number of bytes.

Parameters:

arg0 - The name of the parameter

arg1 - the Java input stream that contains the ASCII parameter value

Throws:

SQLException - if a database access error occurs or the name does not exist

setAsciiStream

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

Specified by:

setAsciiStream in interface PreparedStatement

Throws:

SQLException

setAsciiStream

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

Sets the designated parameter to the given input stream, which will have the specified number of bytes.

Parameters:

arg0 - The name of the parameter

arg1 - the Java input stream that contains the ASCII parameter value

arg2 - the number of bytes in the stream

Throws:

SQLException - if a database access error occurs or the name does not exist

setAsciiStream

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

Specified by:

setAsciiStream in interface PreparedStatement

Throws:

SQLException

setAsciiStream

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

Sets the designated parameter to the given input stream, which will have the specified number of bytes.

Parameters:

arg0 - The name of the parameter

arg1 - the Java input stream that contains the ASCII parameter value

arg2 - the number of bytes in the stream

Throws:

SQLException - if a database access error occurs or the name does not exist

setBigDecimal

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

Specified by:

setBigDecimal in interface PreparedStatement

Throws:

SQLException

setBigDecimal

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

Sets the designated parameter to the given java.math.BigDecimal value.

Parameters:

arg0 - The name of the parameter

arg1 - the parameter value

Throws:

SQLException - if a database access error occurs or the name does not exist

setBinaryStream

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

Specified by:

setBinaryStream in interface PreparedStatement

Throws:

SQLException

setBinaryStream

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

Sets the designated parameter to the given input stream.

Parameters:

arg0 - The name of the parameter

arg1 - the Java input stream that contains the ASCII parameter value

Throws:

SQLException - if a database access error occurs or the name does not exist

setBinaryStream

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

Specified by:

setBinaryStream in interface PreparedStatement

Throws:

SQLException

setBinaryStream

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

Sets the designated parameter to the given input stream, which will have the specified number of bytes.

Parameters:

arg0 - The name of the parameter

arg1 - the Java input stream that contains the ASCII parameter value

arg2 - the number of bytes in the stream

Throws:

SQLException - if a database access error occurs or the name does not exist

setBinaryStream

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

Specified by:

setBinaryStream in interface PreparedStatement

Throws:

SQLException

setBinaryStream

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

Sets the designated parameter to the given input stream, which will have the specified number of bytes.

Parameters:

arg0 - The name of the parameter

arg1 - the Java input stream that contains the ASCII parameter value

arg2 - the number of bytes in the stream

Throws:

SQLException - if a database access error occurs or the name does not exist

setBlob

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

Sets the designated parameter to the given java.sql.Blob object.

Parameters:

arg0 - The name of the parameter

arg1 - the parameter value

Throws:

SQLException - if a database access error occurs or the name does not exist

setBlob

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

Specified by:

setBlob in interface PreparedStatement

Throws:

SQLException

setBlob

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

Sets the designated parameter to a InputStream object.

Parameters:

arg0 - The name of the parameter

arg1 - the parameter value

Throws:

SQLException - if a database access error occurs or the name does not exist

setBlob

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

Specified by:

setBlob in interface PreparedStatement

Throws:

SQLException

setBlob

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

Sets the designated parameter to a InputStream object.

Parameters:

arg0 - The name of the parameter

arg1 - the parameter value

arg2 - the length in bytes

Throws:

SQLException - if a database access error occurs or the name does not exist

setBlob

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

Specified by:

setBlob in interface PreparedStatement

Throws:

SQLException

setBoolean

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

Sets the designated parameter to the given boolean value.

Parameters:

arg0 - The name of the parameter

arg1 - the parameter value

Throws:

SQLException - if a database access error occurs or the name does not exist

setBoolean

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

Specified by:

setBoolean in interface PreparedStatement

Throws:

SQLException

setByte

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

Sets the designated parameter to the given byte value.

Parameters:

arg0 - The name of the parameter

arg1 - the parameter value

Throws:

SQLException - if a database access error occurs or the name does not exist

setByte

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

Specified by:

setByte in interface PreparedStatement

Throws:

SQLException

setBytes

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

Sets the designated parameter to the given Java array of bytes.

Parameters:

arg0 - The name of the parameter

arg1 - the parameter value

Throws:

SQLException - if a database access error occurs or the name does not exist

setBytes

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

Specified by:

setBytes in interface PreparedStatement

Throws:

SQLException

setCharacterStream

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

Sets the designated parameter to the given Reader object.

Parameters:

arg0 - The name of the parameter

arg1 - the parameter value

Throws:

SQLException - if a database access error occurs or the name does not exist

setCharacterStream

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

Specified by:

setCharacterStream in interface PreparedStatement

Throws:

SQLException

setCharacterStream

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

Sets the designated parameter to the given Reader object.

Parameters:

arg0 - The name of the parameter

arg1 - the parameter value

arg2 - the length in bytes

Throws:

SQLException - if a database access error occurs or the name does not exist

setCharacterStream

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

Specified by:

setCharacterStream in interface PreparedStatement

Throws:

SQLException

setCharacterStream

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

Sets the designated parameter to the given Reader object.

Parameters:

arg0 - The name of the parameter

arg1 - the parameter value

arg2 - the length in bytes

Throws:

SQLException - if a database access error occurs or the name does not exist

setCharacterStream

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

Specified by:

setCharacterStream in interface PreparedStatement

Throws:

SQLException

setClob

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

Sets the designated parameter to a java.sql.Clob object.

Parameters:

arg0 - The name of the parameter

arg1 - the parameter value

Throws:

SQLException - if a database access error occurs or the name does not exist

setClob

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

Specified by:

setClob in interface PreparedStatement

Throws:

SQLException

setClob

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

Sets the designated parameter to a java.sql.Clob object.

Parameters:

arg0 - The name of the parameter

arg1 - the parameter value

Throws:

SQLException - if a database access error occurs or the name does not exist

setClob

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

Specified by:

setClob in interface PreparedStatement

Throws:

SQLException

setClob

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

Sets the designated parameter to a java.sql.Clob object.

Parameters:

arg0 - The name of the parameter

arg1 - the parameter value

arg2 - the length in bytes

Throws:

SQLException - if a database access error occurs or the name does not exist

setClob

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

Specified by:

setClob in interface PreparedStatement

Throws:

SQLException

setCursorName

public void setCursorName(String arg0)
                   throws SQLException

Specified by:

setCursorName in interface Statement

Throws:

SQLException

setDate

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

Sets the designated parameter to the given java.sql.Date value using the default time zone of the virtual machine that is running the application.

Parameters:

arg0 - The name of the parameter

arg1 - the parameter value

Throws:

SQLException - if a database access error occurs or the name does not exist

setDate

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

Specified by:

setDate in interface PreparedStatement

Throws:

SQLException

setDate

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

Sets the designated parameter to the given java.sql.Date value, using the given Calendar object.

Parameters:

arg0 - The name of the parameter

arg1 - the parameter value

arg2 - Calendar for determining timezone

Throws:

SQLException - if a database access error occurs or the name does not exist

setDate

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

Specified by:

setDate in interface PreparedStatement

Throws:

SQLException

setDouble

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

Sets the designated parameter to the given Java double value.

Parameters:

arg0 - The name of the parameter

arg1 - the parameter value

Throws:

SQLException - if a database access error occurs or the name does not exist

setDouble

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

Specified by:

setDouble in interface PreparedStatement

Throws:

SQLException

setEscapeProcessing

public void setEscapeProcessing(boolean arg0)
                         throws SQLException

Specified by:

setEscapeProcessing in interface Statement

Throws:

SQLException

setFloat

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

Sets the designated parameter to the given Java float value.

Parameters:

arg0 - The name of the parameter

arg1 - the parameter value

Throws:

SQLException - if a database access error occurs or the name does not exist

setFloat

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

Specified by:

setFloat in interface PreparedStatement

Throws:

SQLException

setInt

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

Sets the designated parameter to the given Java int value.

Parameters:

arg0 - The name of the parameter

arg1 - the parameter value

Throws:

SQLException - if a database access error occurs or the name does not exist

setInt

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

Specified by:

setInt in interface PreparedStatement

Throws:

SQLException

setLong

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

Sets the designated parameter to the given Java long value.

Parameters:

arg0 - The name of the parameter

arg1 - the parameter value

Throws:

SQLException - if a database access error occurs or the name does not exist

setLong

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

Specified by:

setLong in interface PreparedStatement

Throws:

SQLException

setNCharacterStream

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

Sets the designated parameter to a Reader object.

Parameters:

arg0 - The name of the parameter

arg1 - the parameter value

Throws:

SQLException - if a database access error occurs or the name does not exist

setNCharacterStream

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

Specified by:

setNCharacterStream in interface PreparedStatement

Throws:

SQLException

setNCharacterStream

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

Sets the designated parameter to a Reader object.

Parameters:

arg0 - The name of the parameter

arg1 - the parameter value

arg2 - the number of characters in the parameter data.

Throws:

SQLException - if a database access error occurs or the name does not exist

setNCharacterStream

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

Specified by:

setNCharacterStream in interface PreparedStatement

Throws:

SQLException

setNClob

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

Sets the designated parameter to a NClob object.

Parameters:

arg0 - The name of the parameter

arg1 - the parameter value

Throws:

SQLException - if a database access error occurs or the name does not exist

setNClob

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

Specified by:

setNClob in interface PreparedStatement

Throws:

SQLException

setNClob

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

Sets the designated parameter to a Reader object.

Parameters:

arg0 - The name of the parameter

arg1 - the parameter value

Throws:

SQLException - if a database access error occurs or the name does not exist

setNClob

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

Specified by:

setNClob in interface PreparedStatement

Throws:

SQLException

setNClob

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

Sets the designated parameter to a Reader object.

Parameters:

arg0 - The name of the parameter

arg1 - the parameter value

arg2 - the number of characters in the parameter data.

Throws:

SQLException - if a database access error occurs or the name does not exist

setNClob

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

Specified by:

setNClob in interface PreparedStatement

Throws:

SQLException

setNString

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

Sets the designated parameter to the given String object. The driver converts this to a SQL NCHAR or NVARCHAR or LONGNVARCHAR value (depending on the argument's size relative to the driver's limits on NVARCHAR values) when it sends it to the database.

Parameters:

arg0 - The name of the parameter

arg1 - the parameter value

Throws:

SQLException - if a database access error occurs or the name does not exist

setNString

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

Specified by:

setNString in interface PreparedStatement

Throws:

SQLException

setNull

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

Sets the designated parameter to SQL NULL

Parameters:

arg0 - The name of the parameter

arg1 - the SQL type code defined in java.sql.Types

Throws:

SQLException - if a database access error occurs or the name does not exist

setNull

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

Specified by:

setNull in interface PreparedStatement

Throws:

SQLException

setNull

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

Sets the designated parameter to SQL NULL. This version of the method setNull should be used for user-defined types and REF type parameters. Examples of user-defined types include: STRUCT, DISTINCT, JAVA_OBJECT, and named array types.

Parameters:

arg0 - The name of the parameter

arg1 - the SQL type code defined in java.sql.Types

arg2 - the fully-qualified name of an SQL user-defined type; ignored if the parameter is not a user-defined type or REF

Throws:

SQLException - if a database access error occurs or the name does not exist

setNull

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

Specified by:

setNull in interface PreparedStatement

Throws:

SQLException

setObject

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

ets the value of the designated parameter using the given object. The second parameter must be of type Object; therefore, the java.lang equivalent objects should be used for built-in types. The JDBC specification specifies a standard mapping from Java Object types to SQL types. The given argument will be converted to the corresponding SQL type before being sent to the database. Note that this method may be used to pass datatabase- specific abstract data types, by using a driver-specific Java type. If the object is of a class implementing the interface SQLData, the JDBC driver should call the method SQLData.writeSQL to write it to the SQL data stream. If, on the other hand, the object is of a class implementing Ref, Blob, Clob, NClob, Struct, java.net.URL, RowId, SQLXML or Array, the driver should pass it to the database as a value of the corresponding SQL type.

Parameters:

arg0 - The name of the parameter

arg1 - the object containing the input parameter value

Throws:

SQLException

setObject

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

Specified by:

setObject in interface PreparedStatement

Throws:

SQLException

setObject

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

Throws:

SQLException

See Also:

setObject(int, Object, int)

setObject

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

Specified by:

setObject in interface PreparedStatement

Throws:

SQLException

setObject

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

Throws:

SQLException

See Also:

setObject(int, Object, int, int)

setObject

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

Specified by:

setObject in interface PreparedStatement

Throws:

SQLException

setRef

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

Throws:

SQLException

See Also:

setRef(int, Ref)

setRef

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

Specified by:

setRef in interface PreparedStatement

Throws:

SQLException

setRowId

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

Throws:

SQLException

See Also:

setRowId(int, RowId)

setRowId

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

Specified by:

setRowId in interface PreparedStatement

Throws:

SQLException

setSQLXML

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

Throws:

SQLException

See Also:

setSQLXML(int, SQLXML)

setSQLXML

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

Specified by:

setSQLXML in interface PreparedStatement

Throws:

SQLException

setShort

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

Specified by:

setShort in interface PreparedStatement

Throws:

SQLException

setShort

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

Throws:

SQLException

See Also:

setShort(int, short)

setString

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

Specified by:

setString in interface PreparedStatement

Throws:

SQLException

setString

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

Throws:

SQLException

See Also:

setString(int, String)

setTime

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

Specified by:

setTime in interface PreparedStatement

Throws:

SQLException

setTime

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

Throws:

SQLException

See Also:

setTime(int, Time)

setTime

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

Specified by:

setTime in interface PreparedStatement

Throws:

SQLException

setTime

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

Throws:

SQLException

See Also:

setTime(int, Time, Calendar)

setTimestamp

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

Specified by:

setTimestamp in interface PreparedStatement

Throws:

SQLException

setTimestamp

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

Throws:

SQLException

See Also:

setTimestamp(int, Timestamp)

setTimestamp

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

Specified by:

setTimestamp in interface PreparedStatement

Throws:

SQLException

setTimestamp

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

Throws:

SQLException

See Also:

setTimestamp(int, Timestamp, Calendar)

setURL

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

Specified by:

setURL in interface PreparedStatement

Throws:

SQLException

setURL

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

Throws:

SQLException

See Also:

setURL(int, URL)

setUnicodeStream

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

Deprecated.

Specified by:

setUnicodeStream in interface PreparedStatement

Throws:

SQLException

unwrap

public <T> T unwrap(Class<T> arg0)
             throws SQLException

Specified by:

unwrap in interface Wrapper

Throws:

SQLException