Package de.uplanet.lucy.server.util.db
Class DbPreparedStatement
java.lang.Object
de.uplanet.lucy.server.util.db.DbPreparedStatement
- All Implemented Interfaces:
IDbPreparedStatement
,de.uplanet.util.ICloseable
,AutoCloseable
-
Method Summary
Modifier and TypeMethodDescriptionvoid
close()
Close this statement.void
execute()
Executes the SQL statement in this object, which may be any kind of SQL statement.Typed version ofIDbPreparedStatement.executeAndGetScalarValue()
.executeAndGetScalarBigDecimalValue
(Object p_valueFallback) Typed version ofIDbPreparedStatement.executeAndGetScalarValue(Object)
.Typed version ofIDbPreparedStatement.executeAndGetScalarValue()
.executeAndGetScalarBooleanValue
(Object p_valueFallback) Typed version ofIDbPreparedStatement.executeAndGetScalarValue(Object)
.Typed version ofIDbPreparedStatement.executeAndGetScalarValue()
.executeAndGetScalarByteValue
(Object p_valueFallback) Typed version ofIDbPreparedStatement.executeAndGetScalarValue(Object)
.Typed version ofIDbPreparedStatement.executeAndGetScalarValue()
.executeAndGetScalarDateValue
(Object p_valueFallback) Typed version ofIDbPreparedStatement.executeAndGetScalarValue(Object)
.Typed version ofIDbPreparedStatement.executeAndGetScalarValue()
.executeAndGetScalarDoubleValue
(Object p_valueFallback) Typed version ofIDbPreparedStatement.executeAndGetScalarValue(Object)
.Typed version ofIDbPreparedStatement.executeAndGetScalarValue()
.executeAndGetScalarFloatValue
(Object p_valueFallback) Typed version ofIDbPreparedStatement.executeAndGetScalarValue(Object)
.Typed version ofIDbPreparedStatement.executeAndGetScalarValue()
.executeAndGetScalarIntValue
(Object p_valueFallback) Typed version ofIDbPreparedStatement.executeAndGetScalarValue(Object)
.Typed version ofIDbPreparedStatement.executeAndGetScalarValue()
.executeAndGetScalarLongValue
(Object p_valueFallback) Typed version ofIDbPreparedStatement.executeAndGetScalarValue(Object)
.Typed version ofIDbPreparedStatement.executeAndGetScalarValue()
.executeAndGetScalarShortValue
(Object p_valueFallback) Typed version ofIDbPreparedStatement.executeAndGetScalarValue(Object)
.Typed version ofIDbPreparedStatement.executeAndGetScalarValue()
.executeAndGetScalarStringValue
(Object p_valueFallback) Typed version ofIDbPreparedStatement.executeAndGetScalarValue(Object)
.Typed version ofIDbPreparedStatement.executeAndGetScalarValue()
.executeAndGetScalarTimestampValue
(Object p_valueFallback) Typed version ofIDbPreparedStatement.executeAndGetScalarValue(Object)
.Typed version ofIDbPreparedStatement.executeAndGetScalarValue()
.executeAndGetScalarTimeValue
(Object p_valueFallback) Typed version ofIDbPreparedStatement.executeAndGetScalarValue(Object)
.Get the value of the first column in the first row of the result set.executeAndGetScalarValue
(Object p_valueFallback) Get the value of the first column in the first row of the result set.IValueHolder<?>
Get the value of the first column in the first row of the result set.Executes the SQL query in this object and returns theIDbResultSet
object generated by the query.int
Executes the SQL statement in this object, which must be an SQL Data Manipulation Language (DML) statement, such asINSERT
,UPDATE
orDELETE
; or an SQL statement that returns nothing, such as a DDL statement.int
Get the fetch size of the underlying prepared statement.void
setBigDecimal
(int p_iIdx, Object p_value) Sets the designated parameter to the given number value.void
setBoolean
(int p_iIdx, Object p_value) Sets the designated parameter to the given boolean value.void
Sets the designated parameter to the given integer value.void
setCharacterStream
(int p_iIdx, Object p_value) Sets the designated parameter to the value given string value.void
Sets the designated parameter to the given date value.void
Sets the designated parameter to the given date value.void
Sets the designated parameter to the given date value.void
Sets the designated parameter to the given floating point number value.void
setFetchSize
(int p_iFetchSize) Set the fetch size of the underlying prepared statement.void
Sets the designated parameter to the given floating point number value.void
Sets the designated parameter to the given integer number value.void
Sets the designated parameter to the given integer number value.void
Sets the designated parameter to the given integer number value.void
Sets the designated parameter to the given string value.void
Sets the designated parameter to the given time value.void
Sets the designated parameter to the given time value.void
Sets the designated parameter to the given time value.void
setTimestamp
(int p_iIdx, Object p_value) Sets the designated parameter to the given timestamp value.void
setTimestamp
(int p_iIdx, Object p_value, Calendar p_cal) Sets the designated parameter to the given timestamp value.void
setTimestamp
(int p_iIdx, Object p_value, TimeZone p_tz) Sets the designated parameter to the given timestamp value.
-
Method Details
-
getFetchSize
Description copied from interface:IDbPreparedStatement
Get the fetch size of the underlying prepared statement.- Specified by:
getFetchSize
in interfaceIDbPreparedStatement
- Returns:
- The fetch size.
- Throws:
SQLException
- See Also:
-
setFetchSize
Description copied from interface:IDbPreparedStatement
Set the fetch size of the underlying prepared statement.- Specified by:
setFetchSize
in interfaceIDbPreparedStatement
- Parameters:
p_iFetchSize
- The fetch size.- Throws:
SQLException
- See Also:
-
execute
Description copied from interface:IDbPreparedStatement
Executes the SQL statement in this object, which may be any kind of SQL statement.- Specified by:
execute
in interfaceIDbPreparedStatement
- Throws:
SQLException
- If a database error occurred.
-
executeUpdate
Description copied from interface:IDbPreparedStatement
Executes the SQL statement in this object, which must be an SQL Data Manipulation Language (DML) statement, such asINSERT
,UPDATE
orDELETE
; or an SQL statement that returns nothing, such as a DDL statement.- Specified by:
executeUpdate
in interfaceIDbPreparedStatement
- Throws:
SQLException
- If a database error occurred.
-
executeQuery
Description copied from interface:IDbPreparedStatement
Executes the SQL query in this object and returns theIDbResultSet
object generated by the query.- Specified by:
executeQuery
in interfaceIDbPreparedStatement
- Returns:
- An
IDbResultSet
object that contains the data produced by the query; nevernull
. - Throws:
SQLException
- If a database error occurred.
-
executeAndGetScalarValueHolder
Get the value of the first column in the first row of the result set.If the result set is empty,
null
is returned.- Specified by:
executeAndGetScalarValueHolder
in interfaceIDbPreparedStatement
- Returns:
- A value holder that contains the value of the first column in the first
row of the result set, or
null
if the result set is empty. - Throws:
SQLException
-
executeAndGetScalarValue
Get the value of the first column in the first row of the result set.If the result set is empty, or the value is
null
,p_valueIfNull
is returned.- Specified by:
executeAndGetScalarValue
in interfaceIDbPreparedStatement
- Parameters:
p_valueFallback
- The return value if the query returns an empty result set ornull
.- Returns:
- The value of the first column in the first row of the result set,
or
p_valueIfNull
if the result set is empty, or the value isnull
. - Throws:
SQLException
-
executeAndGetScalarValue
Get the value of the first column in the first row of the result set.If the result set is empty,
null
is returned.- Specified by:
executeAndGetScalarValue
in interfaceIDbPreparedStatement
- Returns:
- The value of the first column in the first row of the result set,
or
null
if the result set is empty. - Throws:
SQLException
-
executeAndGetScalarBooleanValue
public Boolean executeAndGetScalarBooleanValue(Object p_valueFallback) throws SQLException, ValueCastException Description copied from interface:IDbPreparedStatement
Typed version ofIDbPreparedStatement.executeAndGetScalarValue(Object)
.- Specified by:
executeAndGetScalarBooleanValue
in interfaceIDbPreparedStatement
- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarBooleanValue
Description copied from interface:IDbPreparedStatement
Typed version ofIDbPreparedStatement.executeAndGetScalarValue()
.- Specified by:
executeAndGetScalarBooleanValue
in interfaceIDbPreparedStatement
- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarByteValue
public Byte executeAndGetScalarByteValue(Object p_valueFallback) throws SQLException, ValueCastException Description copied from interface:IDbPreparedStatement
Typed version ofIDbPreparedStatement.executeAndGetScalarValue(Object)
.- Specified by:
executeAndGetScalarByteValue
in interfaceIDbPreparedStatement
- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarByteValue
Description copied from interface:IDbPreparedStatement
Typed version ofIDbPreparedStatement.executeAndGetScalarValue()
.- Specified by:
executeAndGetScalarByteValue
in interfaceIDbPreparedStatement
- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarShortValue
public Short executeAndGetScalarShortValue(Object p_valueFallback) throws SQLException, ValueCastException Description copied from interface:IDbPreparedStatement
Typed version ofIDbPreparedStatement.executeAndGetScalarValue(Object)
.- Specified by:
executeAndGetScalarShortValue
in interfaceIDbPreparedStatement
- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarShortValue
Description copied from interface:IDbPreparedStatement
Typed version ofIDbPreparedStatement.executeAndGetScalarValue()
.- Specified by:
executeAndGetScalarShortValue
in interfaceIDbPreparedStatement
- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarIntValue
public Integer executeAndGetScalarIntValue(Object p_valueFallback) throws SQLException, ValueCastException Description copied from interface:IDbPreparedStatement
Typed version ofIDbPreparedStatement.executeAndGetScalarValue(Object)
.- Specified by:
executeAndGetScalarIntValue
in interfaceIDbPreparedStatement
- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarIntValue
Description copied from interface:IDbPreparedStatement
Typed version ofIDbPreparedStatement.executeAndGetScalarValue()
.- Specified by:
executeAndGetScalarIntValue
in interfaceIDbPreparedStatement
- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarLongValue
public Long executeAndGetScalarLongValue(Object p_valueFallback) throws SQLException, ValueCastException Description copied from interface:IDbPreparedStatement
Typed version ofIDbPreparedStatement.executeAndGetScalarValue(Object)
.- Specified by:
executeAndGetScalarLongValue
in interfaceIDbPreparedStatement
- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarLongValue
Description copied from interface:IDbPreparedStatement
Typed version ofIDbPreparedStatement.executeAndGetScalarValue()
.- Specified by:
executeAndGetScalarLongValue
in interfaceIDbPreparedStatement
- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarFloatValue
public Float executeAndGetScalarFloatValue(Object p_valueFallback) throws SQLException, ValueCastException Description copied from interface:IDbPreparedStatement
Typed version ofIDbPreparedStatement.executeAndGetScalarValue(Object)
.- Specified by:
executeAndGetScalarFloatValue
in interfaceIDbPreparedStatement
- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarFloatValue
Description copied from interface:IDbPreparedStatement
Typed version ofIDbPreparedStatement.executeAndGetScalarValue()
.- Specified by:
executeAndGetScalarFloatValue
in interfaceIDbPreparedStatement
- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarDoubleValue
public Double executeAndGetScalarDoubleValue(Object p_valueFallback) throws SQLException, ValueCastException Description copied from interface:IDbPreparedStatement
Typed version ofIDbPreparedStatement.executeAndGetScalarValue(Object)
.- Specified by:
executeAndGetScalarDoubleValue
in interfaceIDbPreparedStatement
- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarDoubleValue
Description copied from interface:IDbPreparedStatement
Typed version ofIDbPreparedStatement.executeAndGetScalarValue()
.- Specified by:
executeAndGetScalarDoubleValue
in interfaceIDbPreparedStatement
- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarBigDecimalValue
public BigDecimal executeAndGetScalarBigDecimalValue(Object p_valueFallback) throws SQLException, ValueCastException Description copied from interface:IDbPreparedStatement
Typed version ofIDbPreparedStatement.executeAndGetScalarValue(Object)
.- Specified by:
executeAndGetScalarBigDecimalValue
in interfaceIDbPreparedStatement
- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarBigDecimalValue
Description copied from interface:IDbPreparedStatement
Typed version ofIDbPreparedStatement.executeAndGetScalarValue()
.- Specified by:
executeAndGetScalarBigDecimalValue
in interfaceIDbPreparedStatement
- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarStringValue
public String executeAndGetScalarStringValue(Object p_valueFallback) throws SQLException, ValueCastException Description copied from interface:IDbPreparedStatement
Typed version ofIDbPreparedStatement.executeAndGetScalarValue(Object)
.- Specified by:
executeAndGetScalarStringValue
in interfaceIDbPreparedStatement
- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarStringValue
Description copied from interface:IDbPreparedStatement
Typed version ofIDbPreparedStatement.executeAndGetScalarValue()
.- Specified by:
executeAndGetScalarStringValue
in interfaceIDbPreparedStatement
- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarTimestampValue
public Timestamp executeAndGetScalarTimestampValue(Object p_valueFallback) throws SQLException, ValueCastException Description copied from interface:IDbPreparedStatement
Typed version ofIDbPreparedStatement.executeAndGetScalarValue(Object)
.- Specified by:
executeAndGetScalarTimestampValue
in interfaceIDbPreparedStatement
- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarTimestampValue
Description copied from interface:IDbPreparedStatement
Typed version ofIDbPreparedStatement.executeAndGetScalarValue()
.- Specified by:
executeAndGetScalarTimestampValue
in interfaceIDbPreparedStatement
- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarDateValue
public Date executeAndGetScalarDateValue(Object p_valueFallback) throws SQLException, ValueCastException Description copied from interface:IDbPreparedStatement
Typed version ofIDbPreparedStatement.executeAndGetScalarValue(Object)
.- Specified by:
executeAndGetScalarDateValue
in interfaceIDbPreparedStatement
- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarDateValue
Description copied from interface:IDbPreparedStatement
Typed version ofIDbPreparedStatement.executeAndGetScalarValue()
.- Specified by:
executeAndGetScalarDateValue
in interfaceIDbPreparedStatement
- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarTimeValue
public Date executeAndGetScalarTimeValue(Object p_valueFallback) throws SQLException, ValueCastException Description copied from interface:IDbPreparedStatement
Typed version ofIDbPreparedStatement.executeAndGetScalarValue(Object)
.- Specified by:
executeAndGetScalarTimeValue
in interfaceIDbPreparedStatement
- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
executeAndGetScalarTimeValue
Description copied from interface:IDbPreparedStatement
Typed version ofIDbPreparedStatement.executeAndGetScalarValue()
.- Specified by:
executeAndGetScalarTimeValue
in interfaceIDbPreparedStatement
- Throws:
SQLException
- If a database error occurred.ValueCastException
- If the database value could not be cast to the specific type.- See Also:
-
setBoolean
Description copied from interface:IDbPreparedStatement
Sets the designated parameter to the given boolean value.- Specified by:
setBoolean
in interfaceIDbPreparedStatement
- Parameters:
p_iIdx
- The first parameter is 1, the second is 2, ...p_value
- The parameter value.- Throws:
SQLException
- If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.
-
setInt
Description copied from interface:IDbPreparedStatement
Sets the designated parameter to the given integer number value.- Specified by:
setInt
in interfaceIDbPreparedStatement
- Parameters:
p_iIdx
- The first parameter is 1, the second is 2, ...p_value
- The parameter value.- Throws:
SQLException
- If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.
-
setLong
Description copied from interface:IDbPreparedStatement
Sets the designated parameter to the given integer number value.- Specified by:
setLong
in interfaceIDbPreparedStatement
- Parameters:
p_iIdx
- The first parameter is 1, the second is 2, ...p_value
- The parameter value.- Throws:
SQLException
- If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.
-
setShort
Description copied from interface:IDbPreparedStatement
Sets the designated parameter to the given integer number value.- Specified by:
setShort
in interfaceIDbPreparedStatement
- Parameters:
p_iIdx
- The first parameter is 1, the second is 2, ...p_value
- The parameter value.- Throws:
SQLException
- If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.
-
setByte
Description copied from interface:IDbPreparedStatement
Sets the designated parameter to the given integer value.- Specified by:
setByte
in interfaceIDbPreparedStatement
- Parameters:
p_iIdx
- The first parameter is 1, the second is 2, ...p_value
- The parameter value.- Throws:
SQLException
- If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.
-
setBigDecimal
Description copied from interface:IDbPreparedStatement
Sets the designated parameter to the given number value.- Specified by:
setBigDecimal
in interfaceIDbPreparedStatement
- Parameters:
p_iIdx
- The first parameter is 1, the second is 2, ...p_value
- The parameter value.- Throws:
SQLException
- If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.
-
setFloat
Description copied from interface:IDbPreparedStatement
Sets the designated parameter to the given floating point number value.- Specified by:
setFloat
in interfaceIDbPreparedStatement
- Parameters:
p_iIdx
- The first parameter is 1, the second is 2, ...p_value
- The parameter value.- Throws:
SQLException
- If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.
-
setDouble
Description copied from interface:IDbPreparedStatement
Sets the designated parameter to the given floating point number value.- Specified by:
setDouble
in interfaceIDbPreparedStatement
- Parameters:
p_iIdx
- The first parameter is 1, the second is 2, ...p_value
- The parameter value.- Throws:
SQLException
- If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.
-
setTimestamp
Description copied from interface:IDbPreparedStatement
Sets the designated parameter to the given timestamp value.A calendar with the time zone that is associated with the database connection that was used to create this statement is used to write the timestamp to the database.
- Specified by:
setTimestamp
in interfaceIDbPreparedStatement
- Parameters:
p_iIdx
- The first parameter is 1, the second is 2, ...p_value
- The parameter value.- Throws:
SQLException
- If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.
-
setTimestamp
Description copied from interface:IDbPreparedStatement
Sets the designated parameter to the given timestamp value.- Specified by:
setTimestamp
in interfaceIDbPreparedStatement
- Parameters:
p_iIdx
- The first parameter is 1, the second is 2, ...p_value
- The parameter value.p_tz
- The time zone to be used when writing the timestamp to the database. If this parameter is omitted, the time zone that is associated with the database connection that was used to create this statement is used.- Throws:
SQLException
- If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.
-
setTimestamp
Description copied from interface:IDbPreparedStatement
Sets the designated parameter to the given timestamp value.- Specified by:
setTimestamp
in interfaceIDbPreparedStatement
- Parameters:
p_iIdx
- The first parameter is 1, the second is 2, ...p_value
- The parameter value.p_cal
- The calendar to be used when writing the timestamp to the database. If this parameter is omitted, a calendar with the time zone that is associated with the database connection that was used to create this statement is used.- Throws:
SQLException
- If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.
-
setTime
Description copied from interface:IDbPreparedStatement
Sets the designated parameter to the given time value.A calendar with the time zone that is associated with the database connection that was used to create this statement is used to write the time value to the database.
- Specified by:
setTime
in interfaceIDbPreparedStatement
- Parameters:
p_iIdx
- The first parameter is 1, the second is 2, ...p_value
- The parameter value.- Throws:
SQLException
- If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.
-
setTime
Description copied from interface:IDbPreparedStatement
Sets the designated parameter to the given time value.- Specified by:
setTime
in interfaceIDbPreparedStatement
- Parameters:
p_iIdx
- The first parameter is 1, the second is 2, ...p_value
- The parameter value.p_tz
- The time zone to be used when writing the time value to the database. If this parameter is omitted, the time zone that is associated with the database connection that was used to create this statement is used.- Throws:
SQLException
- If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.
-
setTime
Description copied from interface:IDbPreparedStatement
Sets the designated parameter to the given time value.- Specified by:
setTime
in interfaceIDbPreparedStatement
- Parameters:
p_iIdx
- The first parameter is 1, the second is 2, ...p_value
- The parameter value.p_cal
- The calendar to be used when writing the time to the database. If this parameter is omitted, a calendar with the time zone that is associated with the database connection that was used to create this statement is used.- Throws:
SQLException
- If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.
-
setDate
Description copied from interface:IDbPreparedStatement
Sets the designated parameter to the given date value.A calendar with the time zone that is associated with the database connection that was used to create this statement is used to write the time value to the database.
- Specified by:
setDate
in interfaceIDbPreparedStatement
- Parameters:
p_iIdx
- The first parameter is 1, the second is 2, ...p_value
- The parameter value.- Throws:
SQLException
- If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.
-
setDate
Description copied from interface:IDbPreparedStatement
Sets the designated parameter to the given date value.- Specified by:
setDate
in interfaceIDbPreparedStatement
- Parameters:
p_iIdx
- The first parameter is 1, the second is 2, ...p_value
- The parameter value.p_tz
- The time zone to be used when writing the date value to the database. If this parameter is omitted, the time zone that is associated with the database connection that was used to create this statement is used.- Throws:
SQLException
- If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.
-
setDate
Description copied from interface:IDbPreparedStatement
Sets the designated parameter to the given date value.- Specified by:
setDate
in interfaceIDbPreparedStatement
- Parameters:
p_iIdx
- The first parameter is 1, the second is 2, ...p_value
- The parameter value.p_cal
- The calendar to be used when writing the date to the database. If this parameter is omitted, a calendar with the time zone that is associated with the database connection that was used to create this statement is used.- Throws:
SQLException
- If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.
-
setString
Description copied from interface:IDbPreparedStatement
Sets the designated parameter to the given string value.- Specified by:
setString
in interfaceIDbPreparedStatement
- Parameters:
p_iIdx
- The first parameter is 1, the second is 2, ...p_value
- The parameter value.- Throws:
SQLException
- If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.
-
setCharacterStream
Description copied from interface:IDbPreparedStatement
Sets the designated parameter to the value given string value.- Specified by:
setCharacterStream
in interfaceIDbPreparedStatement
- Parameters:
p_iIdx
- The first parameter is 1, the second is 2, ...p_value
- The parameter value.- Throws:
SQLException
- If the parameter index does not correspond to a parameter marker in the SQL statement, if a database access error occurs, or this method is called on a closed statement.IOException
-
close
Close this statement.- Specified by:
close
in interfaceAutoCloseable
- Specified by:
close
in interfaceIDbPreparedStatement
- Throws:
SQLException
- If a database error occurred.
-