Class PreparedStatementWrapper
- java.lang.Object
-
- com.gargoylesoftware.base.resource.jdbc.StatementWrapper
-
- com.gargoylesoftware.base.resource.jdbc.PreparedStatementWrapper
-
- All Implemented Interfaces:
java.lang.AutoCloseable
,java.sql.PreparedStatement
,java.sql.Statement
,java.sql.Wrapper
- Direct Known Subclasses:
CallableStatementWrapper
public class PreparedStatementWrapper extends StatementWrapper implements java.sql.PreparedStatement
A wrapper for a PreparedStatement- Version:
- $Revision: 1.3 $
-
-
Field Summary
Fields Modifier and Type Field Description private java.sql.PreparedStatement
delegate_
-
Constructor Summary
Constructors Constructor Description PreparedStatementWrapper(java.sql.PreparedStatement statement)
Create a PreparedStatementWrapper
-
Method Summary
All Methods Instance Methods Concrete Methods Deprecated Methods Modifier and Type Method Description void
addBatch()
Adds a set of parameters to thisPreparedStatement
object's batch of commands.void
clearParameters()
Clears the current parameter values immediately.boolean
execute()
Executes any kind of SQL statement.java.sql.ResultSet
executeQuery()
Executes the SQL query in thisPreparedStatement
object and returns the result set generated by the query.int
executeUpdate()
Executes the SQL INSERT, UPDATE or DELETE statement in thisPreparedStatement
object.java.sql.ResultSetMetaData
getMetaData()
Gets the number, types and properties of aResultSet
object's columns.java.sql.ParameterMetaData
getParameterMetaData()
Retrieves the number, types and properties of thisPreparedStatement
object's parameters.void
setArray(int i, java.sql.Array x)
Sets the designated parameter to the givenArray
object.void
setAsciiStream(int parameterIndex, java.io.InputStream x)
void
setAsciiStream(int parameterIndex, java.io.InputStream x, int length)
Sets the designated parameter to the given input stream, which will have the specified number of bytes.void
setAsciiStream(int parameterIndex, java.io.InputStream x, long length)
void
setBigDecimal(int parameterIndex, java.math.BigDecimal x)
Sets the designated parameter to ajava.math.BigDecimal
value.void
setBinaryStream(int parameterIndex, java.io.InputStream x)
void
setBinaryStream(int parameterIndex, java.io.InputStream x, int length)
Sets the designated parameter to the given input stream, which will have the specified number of bytes.void
setBinaryStream(int parameterIndex, java.io.InputStream x, long length)
void
setBlob(int parameterIndex, java.io.InputStream inputStream)
void
setBlob(int parameterIndex, java.io.InputStream inputStream, long length)
void
setBlob(int i, java.sql.Blob x)
Sets the designated parameter to the givenBlob
object.void
setBoolean(int parameterIndex, boolean x)
Sets the designated parameter to a Javaboolean
value.void
setByte(int parameterIndex, byte x)
Sets the designated parameter to a Javabyte
value.void
setBytes(int parameterIndex, byte[] x)
Sets the designated parameter to a Java array of bytes.void
setCharacterStream(int parameterIndex, java.io.Reader reader)
void
setCharacterStream(int parameterIndex, java.io.Reader reader, int length)
Sets the designated parameter to the givenReader
object, which is the given number of characters long.void
setCharacterStream(int parameterIndex, java.io.Reader reader, long length)
void
setClob(int parameterIndex, java.io.Reader reader)
void
setClob(int parameterIndex, java.io.Reader reader, long length)
void
setClob(int i, java.sql.Clob x)
Sets the designated parameter to the givenClob
object.void
setDate(int parameterIndex, java.sql.Date x)
Sets the designated parameter to avalue.
void
setDate(int parameterIndex, java.sql.Date x, java.util.Calendar cal)
Sets the designated parameter to the givenjava.sql.Date
value, using the givenCalendar
object.void
setDouble(int parameterIndex, double x)
Sets the designated parameter to a Javadouble
value.void
setFloat(int parameterIndex, float x)
Sets the designated parameter to a Javafloat
value.void
setInt(int parameterIndex, int x)
Sets the designated parameter to a Javaint
value.void
setLong(int parameterIndex, long x)
Sets the designated parameter to a Javalong
value.void
setNCharacterStream(int parameterIndex, java.io.Reader value)
void
setNCharacterStream(int parameterIndex, java.io.Reader value, long length)
void
setNClob(int parameterIndex, java.io.Reader reader)
void
setNClob(int parameterIndex, java.io.Reader reader, long length)
void
setNClob(int parameterIndex, java.sql.NClob value)
void
setNString(int parameterIndex, java.lang.String value)
void
setNull(int parameterIndex, int sqlType)
Sets the designated parameter to SQLNULL
.void
setNull(int paramIndex, int sqlType, java.lang.String typeName)
Sets the designated parameter to SQLNULL
.void
setObject(int parameterIndex, java.lang.Object x)
Sets the value of the designated parameter using the given object.void
setObject(int parameterIndex, java.lang.Object x, int targetSqlType)
Sets the value of the designated parameter with the given object.void
setObject(int parameterIndex, java.lang.Object x, int targetSqlType, int scale)
Sets the value of the designated parameter with the given object.void
setRef(int i, java.sql.Ref x)
Sets the designated parameter to the givenREF(<structured-type>)
value.void
setRowId(int parameterIndex, java.sql.RowId x)
void
setShort(int parameterIndex, short x)
Sets the designated parameter to a Javashort
value.void
setSQLXML(int parameterIndex, java.sql.SQLXML xmlObject)
void
setString(int parameterIndex, java.lang.String x)
Sets the designated parameter to a JavaString
value.void
setTime(int parameterIndex, java.sql.Time x)
Sets the designated parameter to ajava.sql.Time
value.void
setTime(int parameterIndex, java.sql.Time x, java.util.Calendar cal)
Sets the designated parameter to the givenjava.sql.Time
value, using the givenCalendar
object.void
setTimestamp(int parameterIndex, java.sql.Timestamp x)
Sets the designated parameter to ajava.sql.Timestamp
value.void
setTimestamp(int parameterIndex, java.sql.Timestamp x, java.util.Calendar cal)
Sets the designated parameter to the givenjava.sql.Timestamp
value, using the givenCalendar
object.void
setUnicodeStream(int parameterIndex, java.io.InputStream x, int length)
Deprecated.void
setURL(int parameterIndex, java.net.URL x)
Sets the designated parameter to the givenjava.net.URL
value.-
Methods inherited from class com.gargoylesoftware.base.resource.jdbc.StatementWrapper
addBatch, cancel, checkIsOpen, clearBatch, clearWarnings, close, closeOnCompletion, execute, execute, execute, execute, executeBatch, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getDelegate, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isWrapperFor, setConnection, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, unwrap, wrapResultSet
-
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
addBatch, cancel, clearBatch, clearWarnings, close, 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
-
-
-
-
Method Detail
-
setNull
public final void setNull(int parameterIndex, int sqlType) throws java.sql.SQLException
Sets the designated parameter to SQLNULL
.Note: You must specify the parameter's SQL type.
- Specified by:
setNull
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, ...sqlType
- the SQL type code defined injava.sql.Types
- Throws:
java.sql.SQLException
- if a database access error occurs
-
setBoolean
public final void setBoolean(int parameterIndex, boolean x) throws java.sql.SQLException
Sets the designated parameter to a Javaboolean
value. The driver converts this to an SQLBIT
value when it sends it to the database.- Specified by:
setBoolean
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value- Throws:
java.sql.SQLException
- if a database access error occurs
-
setByte
public final void setByte(int parameterIndex, byte x) throws java.sql.SQLException
Sets the designated parameter to a Javabyte
value. The driver converts this to an SQLTINYINT
value when it sends it to the database.- Specified by:
setByte
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value- Throws:
java.sql.SQLException
- if a database access error occurs
-
setShort
public final void setShort(int parameterIndex, short x) throws java.sql.SQLException
Sets the designated parameter to a Javashort
value. The driver converts this to an SQLSMALLINT
value when it sends it to the database.- Specified by:
setShort
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value- Throws:
java.sql.SQLException
- if a database access error occurs
-
setInt
public final void setInt(int parameterIndex, int x) throws java.sql.SQLException
Sets the designated parameter to a Javaint
value. The driver converts this to an SQLINTEGER
value when it sends it to the database.- Specified by:
setInt
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value- Throws:
java.sql.SQLException
- if a database access error occurs
-
setLong
public final void setLong(int parameterIndex, long x) throws java.sql.SQLException
Sets the designated parameter to a Javalong
value. The driver converts this to an SQLBIGINT
value when it sends it to the database.- Specified by:
setLong
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value- Throws:
java.sql.SQLException
- if a database access error occurs
-
setFloat
public final void setFloat(int parameterIndex, float x) throws java.sql.SQLException
Sets the designated parameter to a Javafloat
value. The driver converts this to an SQLFLOAT
value when it sends it to the database.- Specified by:
setFloat
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value- Throws:
java.sql.SQLException
- if a database access error occurs
-
setDouble
public final void setDouble(int parameterIndex, double x) throws java.sql.SQLException
Sets the designated parameter to a Javadouble
value. The driver converts this to an SQLDOUBLE
value when it sends it to the database.- Specified by:
setDouble
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value- Throws:
java.sql.SQLException
- if a database access error occurs
-
setBigDecimal
public final void setBigDecimal(int parameterIndex, java.math.BigDecimal x) throws java.sql.SQLException
Sets the designated parameter to ajava.math.BigDecimal
value. The driver converts this to an SQLNUMERIC
value when it sends it to the database.- Specified by:
setBigDecimal
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value- Throws:
java.sql.SQLException
- if a database access error occurs
-
setString
public final void setString(int parameterIndex, java.lang.String x) throws java.sql.SQLException
Sets the designated parameter to a JavaString
value. The driver converts this to an SQLVARCHAR
orLONGVARCHAR
value (depending on the argument's size relative to the driver's limits onVARCHAR
values) when it sends it to the database.- Specified by:
setString
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value- Throws:
java.sql.SQLException
- if a database access error occurs
-
setBytes
public final void setBytes(int parameterIndex, byte[] x) throws java.sql.SQLException
Sets the designated parameter to a Java array of bytes. The driver converts this to an SQLVARBINARY
orLONGVARBINARY
(depending on the argument's size relative to the driver's limits onVARBINARY
values) when it sends it to the database.- Specified by:
setBytes
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value- Throws:
java.sql.SQLException
- if a database access error occurs
-
setDate
public final void setDate(int parameterIndex, java.sql.Date x) throws java.sql.SQLException
Sets the designated parameter to avalue. The driver converts this to an SQL
DATE
value when it sends it to the database.- Specified by:
setDate
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value- Throws:
java.sql.SQLException
- if a database access error occurs
-
setTime
public final void setTime(int parameterIndex, java.sql.Time x) throws java.sql.SQLException
Sets the designated parameter to ajava.sql.Time
value. The driver converts this to an SQLTIME
value when it sends it to the database.- Specified by:
setTime
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value- Throws:
java.sql.SQLException
- if a database access error occurs
-
setTimestamp
public final void setTimestamp(int parameterIndex, java.sql.Timestamp x) throws java.sql.SQLException
Sets the designated parameter to ajava.sql.Timestamp
value. The driver converts this to an SQLTIMESTAMP
value when it sends it to the database.- Specified by:
setTimestamp
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter value- Throws:
java.sql.SQLException
- if a database access error occurs
-
setAsciiStream
public final void setAsciiStream(int parameterIndex, java.io.InputStream x, int length) throws java.sql.SQLException
Sets the designated parameter to the given input stream, which will have the specified number of bytes. When a very large ASCII value is input to aLONGVARCHAR
parameter, it may be more practical to send it via ajava.io.InputStream
. Data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from ASCII to the database char format.Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
- Specified by:
setAsciiStream
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the Java input stream that contains the ASCII parameter valuelength
- the number of bytes in the stream- Throws:
java.sql.SQLException
- if a database access error occurs
-
setUnicodeStream
public final void setUnicodeStream(int parameterIndex, java.io.InputStream x, int length) throws java.sql.SQLException
Deprecated.Sets the designated parameter to the given input stream, which will have the specified number of bytes. When a very large UNICODE value is input to aLONGVARCHAR
parameter, it may be more practical to send it via ajava.io.InputStream
object. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format. The byte format of the Unicode stream must be Java UTF-8, as defined in the Java Virtual Machine Specification.Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
- Specified by:
setUnicodeStream
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the java input stream which contains the UNICODE parameter valuelength
- the number of bytes in the stream- Throws:
java.sql.SQLException
- if a database access error occurs
-
setBinaryStream
public final void setBinaryStream(int parameterIndex, java.io.InputStream x, int length) throws java.sql.SQLException
Sets the designated parameter to the given input stream, which will have the specified number of bytes. When a very large binary value is input to aLONGVARBINARY
parameter, it may be more practical to send it via ajava.io.InputStream
object. The data will be read from the stream as needed until end-of-file is reached.Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
- Specified by:
setBinaryStream
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the java input stream which contains the binary parameter valuelength
- the number of bytes in the stream- Throws:
java.sql.SQLException
- if a database access error occurs
-
setObject
public final void setObject(int parameterIndex, java.lang.Object x, int targetSqlType, int scale) throws java.sql.SQLException
Sets the value of the designated parameter with the given object. The second argument must be an object type; for integral values, the
java.lang
equivalent objects should be used.The given Java object will be converted to the given targetSqlType before being sent to the database. If the object has a custom mapping (is of a class implementing the interface
SQLData
), the JDBC driver should call the methodSQLData.writeSQL
to write it to the SQL data stream. If, on the other hand, the object is of a class implementing Ref, Blob, Clob, Struct, or Array, the driver should pass it to the database as a value of the corresponding SQL type.Note that this method may be used to pass datatabase- specific abstract data types.
- Specified by:
setObject
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the object containing the input parameter valuetargetSqlType
- the SQL type (as defined in java.sql.Types) to be sent to the database. The scale argument may further qualify this type.scale
- for java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types, this is the number of digits after the decimal point. For all other types, this value will be ignored.- Throws:
java.sql.SQLException
- if a database access error occurs
-
setObject
public final void setObject(int parameterIndex, java.lang.Object x, int targetSqlType) throws java.sql.SQLException
Sets the value of the designated parameter with the given object. This method is like the methodsetObject
above, except that it assumes a scale of zero.- Specified by:
setObject
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the object containing the input parameter valuetargetSqlType
- the SQL type (as defined in java.sql.Types) to be sent to the database- Throws:
java.sql.SQLException
- if a database access error occurs
-
setObject
public final void setObject(int parameterIndex, java.lang.Object x) throws java.sql.SQLException
Sets the value of the designated parameter using the given object. The second parameter must be of type
Object
; therefore, thejava.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 methodSQLData.writeSQL
to write it to the SQL data stream. If, on the other hand, the object is of a class implementing Ref, Blob, Clob, Struct, or Array, then the driver should pass it to the database as a value of the corresponding SQL type. This method throws an exception if there is an ambiguity, for example, if the object is of a class implementing more than one of the interfaces named above.- Specified by:
setObject
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the object containing the input parameter value- Throws:
java.sql.SQLException
- if a database access error occurs
-
setCharacterStream
public final void setCharacterStream(int parameterIndex, java.io.Reader reader, int length) throws java.sql.SQLException
Sets the designated parameter to the givenReader
object, which is the given number of characters long. When a very large UNICODE value is input to aLONGVARCHAR
parameter, it may be more practical to send it via ajava.io.Reader
object. The data will be read from the stream as needed until end-of-file is reached. The JDBC driver will do any necessary conversion from UNICODE to the database char format.Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
- Specified by:
setCharacterStream
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, ...reader
- the java reader which contains the UNICODE datalength
- the number of characters in the stream- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.2
-
setRef
public final void setRef(int i, java.sql.Ref x) throws java.sql.SQLException
Sets the designated parameter to the givenREF(<structured-type>)
value.- Specified by:
setRef
in interfacejava.sql.PreparedStatement
- Parameters:
i
- the first parameter is 1, the second is 2, ...x
- an SQLREF
value- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.2
-
setBlob
public final void setBlob(int i, java.sql.Blob x) throws java.sql.SQLException
Sets the designated parameter to the givenBlob
object.- Specified by:
setBlob
in interfacejava.sql.PreparedStatement
- Parameters:
i
- the first parameter is 1, the second is 2, ...x
- aBlob
object that maps an SQLBLOB
value- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.2
-
setClob
public final void setClob(int i, java.sql.Clob x) throws java.sql.SQLException
Sets the designated parameter to the givenClob
object.- Specified by:
setClob
in interfacejava.sql.PreparedStatement
- Parameters:
i
- the first parameter is 1, the second is 2, ...x
- aClob
object that maps an SQLCLOB
value- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.2
-
setArray
public final void setArray(int i, java.sql.Array x) throws java.sql.SQLException
Sets the designated parameter to the givenArray
object. Sets an Array parameter.- Specified by:
setArray
in interfacejava.sql.PreparedStatement
- Parameters:
i
- the first parameter is 1, the second is 2, ...x
- anArray
object that maps an SQLARRAY
value- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.2
-
setDate
public final void setDate(int parameterIndex, java.sql.Date x, java.util.Calendar cal) throws java.sql.SQLException
Sets the designated parameter to the givenjava.sql.Date
value, using the givenCalendar
object. The driver uses theCalendar
object to construct an SQLDATE
value, which the driver then sends to the database. With a aCalendar
object, the driver can calculate the date taking into account a custom timezone. If noCalendar
object is specified, the driver uses the default timezone, which is that of the virtual machine running the application.- Specified by:
setDate
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter valuecal
- theCalendar
object the driver will use to construct the date- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.2
-
setTime
public final void setTime(int parameterIndex, java.sql.Time x, java.util.Calendar cal) throws java.sql.SQLException
Sets the designated parameter to the givenjava.sql.Time
value, using the givenCalendar
object. The driver uses theCalendar
object to construct an SQLTIME
value, which the driver then sends to the database. With a aCalendar
object, the driver can calculate the time taking into account a custom timezone. If noCalendar
object is specified, the driver uses the default timezone, which is that of the virtual machine running the application.- Specified by:
setTime
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter valuecal
- theCalendar
object the driver will use to construct the time- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.2
-
setTimestamp
public final void setTimestamp(int parameterIndex, java.sql.Timestamp x, java.util.Calendar cal) throws java.sql.SQLException
Sets the designated parameter to the givenjava.sql.Timestamp
value, using the givenCalendar
object. The driver uses theCalendar
object to construct an SQLTIMESTAMP
value, which the driver then sends to the database. With a aCalendar
object, the driver can calculate the timestamp taking into account a custom timezone. If noCalendar
object is specified, the driver uses the default timezone, which is that of the virtual machine running the application.- Specified by:
setTimestamp
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the parameter valuecal
- theCalendar
object the driver will use to construct the timestamp- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.2
-
setNull
public final void setNull(int paramIndex, int sqlType, java.lang.String typeName) throws java.sql.SQLException
Sets the designated parameter to SQLNULL
. This version of the methodsetNull
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.Note: To be portable, applications must give the SQL type code and the fully-qualified SQL type name when specifying a NULL user-defined or REF parameter. In the case of a user-defined type the name is the type name of the parameter itself. For a REF parameter, the name is the type name of the referenced type. If a JDBC driver does not need the type code or type name information, it may ignore it. Although it is intended for user-defined and Ref parameters, this method may be used to set a null parameter of any JDBC type. If the parameter does not have a user-defined or REF type, the given typeName is ignored.
- Specified by:
setNull
in interfacejava.sql.PreparedStatement
- Parameters:
paramIndex
- the first parameter is 1, the second is 2, ...sqlType
- a value fromjava.sql.Types
typeName
- the fully-qualified name of an SQL user-defined type; ignored if the parameter is not a user-defined type or REF- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.2
-
getMetaData
public final java.sql.ResultSetMetaData getMetaData() throws java.sql.SQLException
Gets the number, types and properties of aResultSet
object's columns.- Specified by:
getMetaData
in interfacejava.sql.PreparedStatement
- Returns:
- the description of a
ResultSet
object's columns - Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.2
-
executeQuery
public final java.sql.ResultSet executeQuery() throws java.sql.SQLException
Executes the SQL query in thisPreparedStatement
object and returns the result set generated by the query.- Specified by:
executeQuery
in interfacejava.sql.PreparedStatement
- Returns:
- a
ResultSet
object that contains the data produced by the query; nevernull
- Throws:
java.sql.SQLException
- if a database access error occurs
-
executeUpdate
public final int executeUpdate() throws java.sql.SQLException
Executes the SQL INSERT, UPDATE or DELETE statement in thisPreparedStatement
object. In addition, SQL statements that return nothing, such as SQL DDL statements, can be executed.- Specified by:
executeUpdate
in interfacejava.sql.PreparedStatement
- Returns:
- either the row count for INSERT, UPDATE or DELETE statements; or 0 for SQL statements that return nothing
- Throws:
java.sql.SQLException
- if a database access error occurs
-
clearParameters
public final void clearParameters() throws java.sql.SQLException
Clears the current parameter values immediately.In general, parameter values remain in force for repeated use of a statement. Setting a parameter value automatically clears its previous value. However, in some cases it is useful to immediately release the resources used by the current parameter values; this can be done by calling the method
clearParameters
.- Specified by:
clearParameters
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
- if a database access error occurs
-
execute
public final boolean execute() throws java.sql.SQLException
Executes any kind of SQL statement. Some prepared statements return multiple results; theexecute
method handles these complex statements as well as the simpler form of statements handled by the methodsexecuteQuery
andexecuteUpdate
.- Specified by:
execute
in interfacejava.sql.PreparedStatement
- Returns:
- Unknown
- Throws:
java.sql.SQLException
- if a database access error occurs
-
addBatch
public final void addBatch() throws java.sql.SQLException
Adds a set of parameters to thisPreparedStatement
object's batch of commands.- Specified by:
addBatch
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
- if a database access error occurs
-
setURL
public void setURL(int parameterIndex, java.net.URL x) throws java.sql.SQLException
Sets the designated parameter to the givenjava.net.URL
value. The driver converts this to an SQLDATALINK
value when it sends it to the database.- Specified by:
setURL
in interfacejava.sql.PreparedStatement
- Parameters:
parameterIndex
- the first parameter is 1, the second is 2, ...x
- thejava.net.URL
object to be set- Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
-
getParameterMetaData
public java.sql.ParameterMetaData getParameterMetaData() throws java.sql.SQLException
Retrieves the number, types and properties of thisPreparedStatement
object's parameters.- Specified by:
getParameterMetaData
in interfacejava.sql.PreparedStatement
- Returns:
- a
ParameterMetaData
object that contains information about the number, types and properties of thisPreparedStatement
object's parameters - Throws:
java.sql.SQLException
- if a database access error occurs- Since:
- 1.4
- See Also:
ParameterMetaData
-
setNClob
public void setNClob(int parameterIndex, java.io.Reader reader) throws java.sql.SQLException
- Specified by:
setNClob
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setBlob
public void setBlob(int parameterIndex, java.io.InputStream inputStream) throws java.sql.SQLException
- Specified by:
setBlob
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setClob
public void setClob(int parameterIndex, java.io.Reader reader) throws java.sql.SQLException
- Specified by:
setClob
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setNCharacterStream
public void setNCharacterStream(int parameterIndex, java.io.Reader value) throws java.sql.SQLException
- Specified by:
setNCharacterStream
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setCharacterStream
public void setCharacterStream(int parameterIndex, java.io.Reader reader) throws java.sql.SQLException
- Specified by:
setCharacterStream
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setBinaryStream
public void setBinaryStream(int parameterIndex, java.io.InputStream x) throws java.sql.SQLException
- Specified by:
setBinaryStream
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setAsciiStream
public void setAsciiStream(int parameterIndex, java.io.InputStream x) throws java.sql.SQLException
- Specified by:
setAsciiStream
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setCharacterStream
public void setCharacterStream(int parameterIndex, java.io.Reader reader, long length) throws java.sql.SQLException
- Specified by:
setCharacterStream
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setBinaryStream
public void setBinaryStream(int parameterIndex, java.io.InputStream x, long length) throws java.sql.SQLException
- Specified by:
setBinaryStream
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setAsciiStream
public void setAsciiStream(int parameterIndex, java.io.InputStream x, long length) throws java.sql.SQLException
- Specified by:
setAsciiStream
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setSQLXML
public void setSQLXML(int parameterIndex, java.sql.SQLXML xmlObject) throws java.sql.SQLException
- Specified by:
setSQLXML
in interfacejava.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 interfacejava.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 interfacejava.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 interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setNClob
public void setNClob(int parameterIndex, java.sql.NClob value) throws java.sql.SQLException
- Specified by:
setNClob
in interfacejava.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 interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setNString
public void setNString(int parameterIndex, java.lang.String value) throws java.sql.SQLException
- Specified by:
setNString
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
setRowId
public void setRowId(int parameterIndex, java.sql.RowId x) throws java.sql.SQLException
- Specified by:
setRowId
in interfacejava.sql.PreparedStatement
- Throws:
java.sql.SQLException
-
-