Package de.uplanet.lucy.server.util.db
Klasse DbPreparedStatement
java.lang.Object
de.uplanet.lucy.server.util.db.DbPreparedStatement
- Alle implementierten Schnittstellen:
IDbPreparedStatement,ICloseable,AutoCloseable
-
Methodenübersicht
Modifizierer und TypMethodeBeschreibungvoidclose()Close this statement.voidexecute()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 theIDbResultSetobject generated by the query.executeQueryWithResultSet(groovy.lang.Closure<?> p_closure) Executes the SQL query in this object and evaluates the given closure with theIDbResultSetobject generated by the query as parameter and its delegate.intExecutes the SQL statement in this object, which must be an SQL Data Manipulation Language (DML) statement, such asINSERT,UPDATEorDELETE; or an SQL statement that returns nothing, such as a DDL statement.intGet the fetch size of the underlying prepared statement.voidsetBigDecimal(int p_iIdx, Object p_value) Sets the designated parameter to the given number value.voidsetBoolean(int p_iIdx, Object p_value) Sets the designated parameter to the given boolean value.voidSets the designated parameter to the given integer value.voidsetCharacterStream(int p_iIdx, Object p_value) Sets the designated parameter to the value given string value.voidSets the designated parameter to the given date value.voidSets the designated parameter to the given date value.voidSets the designated parameter to the given date value.voidSets the designated parameter to the given floating point number value.voidsetFetchSize(int p_iFetchSize) Set the fetch size of the underlying prepared statement.voidSets the designated parameter to the given floating point number value.voidSets the designated parameter to the given integer number value.voidSets the designated parameter to the given integer number value.voidSets the designated parameter to the given integer number value.voidSets the designated parameter to the given string value.voidSets the designated parameter to the given time value.voidSets the designated parameter to the given time value.voidSets the designated parameter to the given time value.voidsetTimestamp(int p_iIdx, Object p_value) Sets the designated parameter to the given timestamp value.voidsetTimestamp(int p_iIdx, Object p_value, Calendar p_cal) Sets the designated parameter to the given timestamp value.voidsetTimestamp(int p_iIdx, Object p_value, TimeZone p_tz) Sets the designated parameter to the given timestamp value.
-
Methodendetails
-
getFetchSize
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementGet the fetch size of the underlying prepared statement.- Angegeben von:
getFetchSizein SchnittstelleIDbPreparedStatement- Gibt zurück:
- The fetch size.
- Löst aus:
SQLException- Siehe auch:
-
setFetchSize
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementSet the fetch size of the underlying prepared statement.- Angegeben von:
setFetchSizein SchnittstelleIDbPreparedStatement- Parameter:
p_iFetchSize- The fetch size.- Löst aus:
SQLException- Siehe auch:
-
execute
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementExecutes the SQL statement in this object, which may be any kind of SQL statement.- Angegeben von:
executein SchnittstelleIDbPreparedStatement- Löst aus:
SQLException- If a database error occurred.
-
executeUpdate
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementExecutes the SQL statement in this object, which must be an SQL Data Manipulation Language (DML) statement, such asINSERT,UPDATEorDELETE; or an SQL statement that returns nothing, such as a DDL statement.- Angegeben von:
executeUpdatein SchnittstelleIDbPreparedStatement- Löst aus:
SQLException- If a database error occurred.
-
executeQuery
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementExecutes the SQL query in this object and returns theIDbResultSetobject generated by the query.- Angegeben von:
executeQueryin SchnittstelleIDbPreparedStatement- Gibt zurück:
- An
IDbResultSetobject that contains the data produced by the query; nevernull. - Löst aus:
SQLException- If a database error occurred.
-
executeQueryWithResultSet
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementExecutes the SQL query in this object and evaluates the given closure with theIDbResultSetobject generated by the query as parameter and its delegate.- Angegeben von:
executeQueryWithResultSetin SchnittstelleIDbPreparedStatement- Parameter:
p_closure- The closure that processes theIDbResultSet.- Gibt zurück:
- The return value of the given closure.
- Löst aus:
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,
nullis returned.- Angegeben von:
executeAndGetScalarValueHolderin SchnittstelleIDbPreparedStatement- Gibt zurück:
- A value holder that contains the value of the first column in the first
row of the result set, or
nullif the result set is empty. - Löst aus:
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_valueIfNullis returned.- Angegeben von:
executeAndGetScalarValuein SchnittstelleIDbPreparedStatement- Parameter:
p_valueFallback- The return value if the query returns an empty result set ornull.- Gibt zurück:
- The value of the first column in the first row of the result set,
or
p_valueIfNullif the result set is empty, or the value isnull. - Löst aus:
SQLException
-
executeAndGetScalarValue
Get the value of the first column in the first row of the result set.If the result set is empty,
nullis returned.- Angegeben von:
executeAndGetScalarValuein SchnittstelleIDbPreparedStatement- Gibt zurück:
- The value of the first column in the first row of the result set,
or
nullif the result set is empty. - Löst aus:
SQLException
-
executeAndGetScalarBooleanValue
public Boolean executeAndGetScalarBooleanValue(Object p_valueFallback) throws SQLException, ValueCastException Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementTyped version ofIDbPreparedStatement.executeAndGetScalarValue(Object).- Angegeben von:
executeAndGetScalarBooleanValuein SchnittstelleIDbPreparedStatement- Löst aus:
SQLException- If a database error occurred.ValueCastException- If the database value could not be cast to the specific type.- Siehe auch:
-
executeAndGetScalarBooleanValue
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementTyped version ofIDbPreparedStatement.executeAndGetScalarValue().- Angegeben von:
executeAndGetScalarBooleanValuein SchnittstelleIDbPreparedStatement- Löst aus:
SQLException- If a database error occurred.ValueCastException- If the database value could not be cast to the specific type.- Siehe auch:
-
executeAndGetScalarByteValue
public Byte executeAndGetScalarByteValue(Object p_valueFallback) throws SQLException, ValueCastException Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementTyped version ofIDbPreparedStatement.executeAndGetScalarValue(Object).- Angegeben von:
executeAndGetScalarByteValuein SchnittstelleIDbPreparedStatement- Löst aus:
SQLException- If a database error occurred.ValueCastException- If the database value could not be cast to the specific type.- Siehe auch:
-
executeAndGetScalarByteValue
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementTyped version ofIDbPreparedStatement.executeAndGetScalarValue().- Angegeben von:
executeAndGetScalarByteValuein SchnittstelleIDbPreparedStatement- Löst aus:
SQLException- If a database error occurred.ValueCastException- If the database value could not be cast to the specific type.- Siehe auch:
-
executeAndGetScalarShortValue
public Short executeAndGetScalarShortValue(Object p_valueFallback) throws SQLException, ValueCastException Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementTyped version ofIDbPreparedStatement.executeAndGetScalarValue(Object).- Angegeben von:
executeAndGetScalarShortValuein SchnittstelleIDbPreparedStatement- Löst aus:
SQLException- If a database error occurred.ValueCastException- If the database value could not be cast to the specific type.- Siehe auch:
-
executeAndGetScalarShortValue
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementTyped version ofIDbPreparedStatement.executeAndGetScalarValue().- Angegeben von:
executeAndGetScalarShortValuein SchnittstelleIDbPreparedStatement- Löst aus:
SQLException- If a database error occurred.ValueCastException- If the database value could not be cast to the specific type.- Siehe auch:
-
executeAndGetScalarIntValue
public Integer executeAndGetScalarIntValue(Object p_valueFallback) throws SQLException, ValueCastException Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementTyped version ofIDbPreparedStatement.executeAndGetScalarValue(Object).- Angegeben von:
executeAndGetScalarIntValuein SchnittstelleIDbPreparedStatement- Löst aus:
SQLException- If a database error occurred.ValueCastException- If the database value could not be cast to the specific type.- Siehe auch:
-
executeAndGetScalarIntValue
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementTyped version ofIDbPreparedStatement.executeAndGetScalarValue().- Angegeben von:
executeAndGetScalarIntValuein SchnittstelleIDbPreparedStatement- Löst aus:
SQLException- If a database error occurred.ValueCastException- If the database value could not be cast to the specific type.- Siehe auch:
-
executeAndGetScalarLongValue
public Long executeAndGetScalarLongValue(Object p_valueFallback) throws SQLException, ValueCastException Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementTyped version ofIDbPreparedStatement.executeAndGetScalarValue(Object).- Angegeben von:
executeAndGetScalarLongValuein SchnittstelleIDbPreparedStatement- Löst aus:
SQLException- If a database error occurred.ValueCastException- If the database value could not be cast to the specific type.- Siehe auch:
-
executeAndGetScalarLongValue
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementTyped version ofIDbPreparedStatement.executeAndGetScalarValue().- Angegeben von:
executeAndGetScalarLongValuein SchnittstelleIDbPreparedStatement- Löst aus:
SQLException- If a database error occurred.ValueCastException- If the database value could not be cast to the specific type.- Siehe auch:
-
executeAndGetScalarFloatValue
public Float executeAndGetScalarFloatValue(Object p_valueFallback) throws SQLException, ValueCastException Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementTyped version ofIDbPreparedStatement.executeAndGetScalarValue(Object).- Angegeben von:
executeAndGetScalarFloatValuein SchnittstelleIDbPreparedStatement- Löst aus:
SQLException- If a database error occurred.ValueCastException- If the database value could not be cast to the specific type.- Siehe auch:
-
executeAndGetScalarFloatValue
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementTyped version ofIDbPreparedStatement.executeAndGetScalarValue().- Angegeben von:
executeAndGetScalarFloatValuein SchnittstelleIDbPreparedStatement- Löst aus:
SQLException- If a database error occurred.ValueCastException- If the database value could not be cast to the specific type.- Siehe auch:
-
executeAndGetScalarDoubleValue
public Double executeAndGetScalarDoubleValue(Object p_valueFallback) throws SQLException, ValueCastException Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementTyped version ofIDbPreparedStatement.executeAndGetScalarValue(Object).- Angegeben von:
executeAndGetScalarDoubleValuein SchnittstelleIDbPreparedStatement- Löst aus:
SQLException- If a database error occurred.ValueCastException- If the database value could not be cast to the specific type.- Siehe auch:
-
executeAndGetScalarDoubleValue
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementTyped version ofIDbPreparedStatement.executeAndGetScalarValue().- Angegeben von:
executeAndGetScalarDoubleValuein SchnittstelleIDbPreparedStatement- Löst aus:
SQLException- If a database error occurred.ValueCastException- If the database value could not be cast to the specific type.- Siehe auch:
-
executeAndGetScalarBigDecimalValue
public BigDecimal executeAndGetScalarBigDecimalValue(Object p_valueFallback) throws SQLException, ValueCastException Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementTyped version ofIDbPreparedStatement.executeAndGetScalarValue(Object).- Angegeben von:
executeAndGetScalarBigDecimalValuein SchnittstelleIDbPreparedStatement- Löst aus:
SQLException- If a database error occurred.ValueCastException- If the database value could not be cast to the specific type.- Siehe auch:
-
executeAndGetScalarBigDecimalValue
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementTyped version ofIDbPreparedStatement.executeAndGetScalarValue().- Angegeben von:
executeAndGetScalarBigDecimalValuein SchnittstelleIDbPreparedStatement- Löst aus:
SQLException- If a database error occurred.ValueCastException- If the database value could not be cast to the specific type.- Siehe auch:
-
executeAndGetScalarStringValue
public String executeAndGetScalarStringValue(Object p_valueFallback) throws SQLException, ValueCastException Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementTyped version ofIDbPreparedStatement.executeAndGetScalarValue(Object).- Angegeben von:
executeAndGetScalarStringValuein SchnittstelleIDbPreparedStatement- Löst aus:
SQLException- If a database error occurred.ValueCastException- If the database value could not be cast to the specific type.- Siehe auch:
-
executeAndGetScalarStringValue
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementTyped version ofIDbPreparedStatement.executeAndGetScalarValue().- Angegeben von:
executeAndGetScalarStringValuein SchnittstelleIDbPreparedStatement- Löst aus:
SQLException- If a database error occurred.ValueCastException- If the database value could not be cast to the specific type.- Siehe auch:
-
executeAndGetScalarTimestampValue
public Timestamp executeAndGetScalarTimestampValue(Object p_valueFallback) throws SQLException, ValueCastException Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementTyped version ofIDbPreparedStatement.executeAndGetScalarValue(Object).- Angegeben von:
executeAndGetScalarTimestampValuein SchnittstelleIDbPreparedStatement- Löst aus:
SQLException- If a database error occurred.ValueCastException- If the database value could not be cast to the specific type.- Siehe auch:
-
executeAndGetScalarTimestampValue
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementTyped version ofIDbPreparedStatement.executeAndGetScalarValue().- Angegeben von:
executeAndGetScalarTimestampValuein SchnittstelleIDbPreparedStatement- Löst aus:
SQLException- If a database error occurred.ValueCastException- If the database value could not be cast to the specific type.- Siehe auch:
-
executeAndGetScalarDateValue
public Date executeAndGetScalarDateValue(Object p_valueFallback) throws SQLException, ValueCastException Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementTyped version ofIDbPreparedStatement.executeAndGetScalarValue(Object).- Angegeben von:
executeAndGetScalarDateValuein SchnittstelleIDbPreparedStatement- Löst aus:
SQLException- If a database error occurred.ValueCastException- If the database value could not be cast to the specific type.- Siehe auch:
-
executeAndGetScalarDateValue
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementTyped version ofIDbPreparedStatement.executeAndGetScalarValue().- Angegeben von:
executeAndGetScalarDateValuein SchnittstelleIDbPreparedStatement- Löst aus:
SQLException- If a database error occurred.ValueCastException- If the database value could not be cast to the specific type.- Siehe auch:
-
executeAndGetScalarTimeValue
public Date executeAndGetScalarTimeValue(Object p_valueFallback) throws SQLException, ValueCastException Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementTyped version ofIDbPreparedStatement.executeAndGetScalarValue(Object).- Angegeben von:
executeAndGetScalarTimeValuein SchnittstelleIDbPreparedStatement- Löst aus:
SQLException- If a database error occurred.ValueCastException- If the database value could not be cast to the specific type.- Siehe auch:
-
executeAndGetScalarTimeValue
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementTyped version ofIDbPreparedStatement.executeAndGetScalarValue().- Angegeben von:
executeAndGetScalarTimeValuein SchnittstelleIDbPreparedStatement- Löst aus:
SQLException- If a database error occurred.ValueCastException- If the database value could not be cast to the specific type.- Siehe auch:
-
setBoolean
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementSets the designated parameter to the given boolean value.- Angegeben von:
setBooleanin SchnittstelleIDbPreparedStatement- Parameter:
p_iIdx- The first parameter is 1, the second is 2, ...p_value- The parameter value.- Löst aus:
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
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementSets the designated parameter to the given integer number value.- Angegeben von:
setIntin SchnittstelleIDbPreparedStatement- Parameter:
p_iIdx- The first parameter is 1, the second is 2, ...p_value- The parameter value.- Löst aus:
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
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementSets the designated parameter to the given integer number value.- Angegeben von:
setLongin SchnittstelleIDbPreparedStatement- Parameter:
p_iIdx- The first parameter is 1, the second is 2, ...p_value- The parameter value.- Löst aus:
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
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementSets the designated parameter to the given integer number value.- Angegeben von:
setShortin SchnittstelleIDbPreparedStatement- Parameter:
p_iIdx- The first parameter is 1, the second is 2, ...p_value- The parameter value.- Löst aus:
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
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementSets the designated parameter to the given integer value.- Angegeben von:
setBytein SchnittstelleIDbPreparedStatement- Parameter:
p_iIdx- The first parameter is 1, the second is 2, ...p_value- The parameter value.- Löst aus:
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
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementSets the designated parameter to the given number value.- Angegeben von:
setBigDecimalin SchnittstelleIDbPreparedStatement- Parameter:
p_iIdx- The first parameter is 1, the second is 2, ...p_value- The parameter value.- Löst aus:
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
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementSets the designated parameter to the given floating point number value.- Angegeben von:
setFloatin SchnittstelleIDbPreparedStatement- Parameter:
p_iIdx- The first parameter is 1, the second is 2, ...p_value- The parameter value.- Löst aus:
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
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementSets the designated parameter to the given floating point number value.- Angegeben von:
setDoublein SchnittstelleIDbPreparedStatement- Parameter:
p_iIdx- The first parameter is 1, the second is 2, ...p_value- The parameter value.- Löst aus:
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
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementSets 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.
- Angegeben von:
setTimestampin SchnittstelleIDbPreparedStatement- Parameter:
p_iIdx- The first parameter is 1, the second is 2, ...p_value- The parameter value.- Löst aus:
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
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementSets the designated parameter to the given timestamp value.- Angegeben von:
setTimestampin SchnittstelleIDbPreparedStatement- Parameter:
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.- Löst aus:
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
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementSets the designated parameter to the given timestamp value.- Angegeben von:
setTimestampin SchnittstelleIDbPreparedStatement- Parameter:
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.- Löst aus:
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
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementSets 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.
- Angegeben von:
setTimein SchnittstelleIDbPreparedStatement- Parameter:
p_iIdx- The first parameter is 1, the second is 2, ...p_value- The parameter value.- Löst aus:
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
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementSets the designated parameter to the given time value.- Angegeben von:
setTimein SchnittstelleIDbPreparedStatement- Parameter:
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.- Löst aus:
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
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementSets the designated parameter to the given time value.- Angegeben von:
setTimein SchnittstelleIDbPreparedStatement- Parameter:
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.- Löst aus:
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
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementSets 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.
- Angegeben von:
setDatein SchnittstelleIDbPreparedStatement- Parameter:
p_iIdx- The first parameter is 1, the second is 2, ...p_value- The parameter value.- Löst aus:
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
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementSets the designated parameter to the given date value.- Angegeben von:
setDatein SchnittstelleIDbPreparedStatement- Parameter:
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.- Löst aus:
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
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementSets the designated parameter to the given date value.- Angegeben von:
setDatein SchnittstelleIDbPreparedStatement- Parameter:
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.- Löst aus:
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
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementSets the designated parameter to the given string value.- Angegeben von:
setStringin SchnittstelleIDbPreparedStatement- Parameter:
p_iIdx- The first parameter is 1, the second is 2, ...p_value- The parameter value.- Löst aus:
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
Beschreibung aus Schnittstelle kopiert:IDbPreparedStatementSets the designated parameter to the value given string value.- Angegeben von:
setCharacterStreamin SchnittstelleIDbPreparedStatement- Parameter:
p_iIdx- The first parameter is 1, the second is 2, ...p_value- The parameter value.- Löst aus:
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.- Angegeben von:
closein SchnittstelleAutoCloseable- Angegeben von:
closein SchnittstelleIDbPreparedStatement- Löst aus:
SQLException- If a database error occurred.
-