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

public final class DbPreparedStatement
extends Object
implements IDbPreparedStatement

Methodenübersicht

Modifizierer und Typ	Methode	Beschreibung
void	close()	Close this statement.
void	execute()	Executes the SQL statement in this object, which may be any kind of SQL statement.
BigDecimal	executeAndGetScalarBigDecimalValue()	Typed version of IDbPreparedStatement.executeAndGetScalarValue().
BigDecimal	executeAndGetScalarBigDecimalValue(Object p_valueFallback)	Typed version of IDbPreparedStatement.executeAndGetScalarValue(Object).
Boolean	executeAndGetScalarBooleanValue()	Typed version of IDbPreparedStatement.executeAndGetScalarValue().
Boolean	executeAndGetScalarBooleanValue(Object p_valueFallback)	Typed version of IDbPreparedStatement.executeAndGetScalarValue(Object).
Byte	executeAndGetScalarByteValue()	Typed version of IDbPreparedStatement.executeAndGetScalarValue().
Byte	executeAndGetScalarByteValue(Object p_valueFallback)	Typed version of IDbPreparedStatement.executeAndGetScalarValue(Object).
Date	executeAndGetScalarDateValue()	Typed version of IDbPreparedStatement.executeAndGetScalarValue().
Date	executeAndGetScalarDateValue(Object p_valueFallback)	Typed version of IDbPreparedStatement.executeAndGetScalarValue(Object).
Double	executeAndGetScalarDoubleValue()	Typed version of IDbPreparedStatement.executeAndGetScalarValue().
Double	executeAndGetScalarDoubleValue(Object p_valueFallback)	Typed version of IDbPreparedStatement.executeAndGetScalarValue(Object).
Float	executeAndGetScalarFloatValue()	Typed version of IDbPreparedStatement.executeAndGetScalarValue().
Float	executeAndGetScalarFloatValue(Object p_valueFallback)	Typed version of IDbPreparedStatement.executeAndGetScalarValue(Object).
Integer	executeAndGetScalarIntValue()	Typed version of IDbPreparedStatement.executeAndGetScalarValue().
Integer	executeAndGetScalarIntValue(Object p_valueFallback)	Typed version of IDbPreparedStatement.executeAndGetScalarValue(Object).
Long	executeAndGetScalarLongValue()	Typed version of IDbPreparedStatement.executeAndGetScalarValue().
Long	executeAndGetScalarLongValue(Object p_valueFallback)	Typed version of IDbPreparedStatement.executeAndGetScalarValue(Object).
Short	executeAndGetScalarShortValue()	Typed version of IDbPreparedStatement.executeAndGetScalarValue().
Short	executeAndGetScalarShortValue(Object p_valueFallback)	Typed version of IDbPreparedStatement.executeAndGetScalarValue(Object).
String	executeAndGetScalarStringValue()	Typed version of IDbPreparedStatement.executeAndGetScalarValue().
String	executeAndGetScalarStringValue(Object p_valueFallback)	Typed version of IDbPreparedStatement.executeAndGetScalarValue(Object).
Timestamp	executeAndGetScalarTimestampValue()	Typed version of IDbPreparedStatement.executeAndGetScalarValue().
Timestamp	executeAndGetScalarTimestampValue(Object p_valueFallback)	Typed version of IDbPreparedStatement.executeAndGetScalarValue(Object).
Date	executeAndGetScalarTimeValue()	Typed version of IDbPreparedStatement.executeAndGetScalarValue().
Date	executeAndGetScalarTimeValue(Object p_valueFallback)	Typed version of IDbPreparedStatement.executeAndGetScalarValue(Object).
Object	executeAndGetScalarValue()	Get the value of the first column in the first row of the result set.
Object	executeAndGetScalarValue(Object p_valueFallback)	Get the value of the first column in the first row of the result set.
IValueHolder<?>	executeAndGetScalarValueHolder()	Get the value of the first column in the first row of the result set.
DbResultSet	executeQuery()	Executes the SQL query in this object and returns the IDbResultSet object generated by the query.
Object	executeQueryWithResultSet(groovy.lang.Closure<?> p_closure)	Executes the SQL query in this object and evaluates the given closure with the IDbResultSet object generated by the query as parameter and its delegate.
int	executeUpdate()	Executes the SQL statement in this object, which must be an SQL Data Manipulation Language (DML) statement, such as INSERT, UPDATE or DELETE; or an SQL statement that returns nothing, such as a DDL statement.
int	getFetchSize()	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	setByte(int p_iIdx, Object p_value)	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	setDate(int p_iIdx, Object p_value)	Sets the designated parameter to the given date value.
void	setDate(int p_iIdx, Object p_value, Calendar p_cal)	Sets the designated parameter to the given date value.
void	setDate(int p_iIdx, Object p_value, TimeZone p_tz)	Sets the designated parameter to the given date value.
void	setDouble(int p_iIdx, Object p_value)	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	setFloat(int p_iIdx, Object p_value)	Sets the designated parameter to the given floating point number value.
void	setInt(int p_iIdx, Object p_value)	Sets the designated parameter to the given integer number value.
void	setLong(int p_iIdx, Object p_value)	Sets the designated parameter to the given integer number value.
void	setShort(int p_iIdx, Object p_value)	Sets the designated parameter to the given integer number value.
void	setString(int p_iIdx, Object p_value)	Sets the designated parameter to the given string value.
void	setTime(int p_iIdx, Object p_value)	Sets the designated parameter to the given time value.
void	setTime(int p_iIdx, Object p_value, Calendar p_cal)	Sets the designated parameter to the given time value.
void	setTime(int p_iIdx, Object p_value, TimeZone p_tz)	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.

Von Klasse geerbte Methoden java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methodendetails

getFetchSize

public int getFetchSize()
                 throws SQLException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Get the fetch size of the underlying prepared statement.

Angegeben von:

getFetchSize in Schnittstelle IDbPreparedStatement

Gibt zurück:

The fetch size.

Löst aus:

SQLException

Siehe auch:

• Statement.setFetchSize(int)

setFetchSize

public void setFetchSize(int p_iFetchSize)
                  throws SQLException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Set the fetch size of the underlying prepared statement.

Angegeben von:

setFetchSize in Schnittstelle IDbPreparedStatement

Parameter:

p_iFetchSize - The fetch size.

Löst aus:

SQLException

Siehe auch:

• Statement.setFetchSize(int)

execute

public void execute()
             throws SQLException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Executes the SQL statement in this object, which may be any kind of SQL statement.

Angegeben von:

execute in Schnittstelle IDbPreparedStatement

Löst aus:

SQLException - If a database error occurred.

executeUpdate

public int executeUpdate()
                  throws SQLException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Executes the SQL statement in this object, which must be an SQL Data Manipulation Language (DML) statement, such as INSERT, UPDATE or DELETE; or an SQL statement that returns nothing, such as a DDL statement.

Angegeben von:

executeUpdate in Schnittstelle IDbPreparedStatement

Löst aus:

SQLException - If a database error occurred.

executeQuery

public DbResultSet executeQuery()
                         throws SQLException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Executes the SQL query in this object and returns the IDbResultSet object generated by the query.

Angegeben von:

executeQuery in Schnittstelle IDbPreparedStatement

Gibt zurück:

An IDbResultSet object that contains the data produced by the query; never null.

Löst aus:

SQLException - If a database error occurred.

executeQueryWithResultSet

public Object executeQueryWithResultSet(groovy.lang.Closure<?> p_closure)
                                 throws SQLException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Executes the SQL query in this object and evaluates the given closure with the IDbResultSet object generated by the query as parameter and its delegate.

Angegeben von:

executeQueryWithResultSet in Schnittstelle IDbPreparedStatement

Parameter:

p_closure - The closure that processes the IDbResultSet.

Gibt zurück:

The return value of the given closure.

Löst aus:

SQLException - If a database error occurred.

executeAndGetScalarValueHolder

public IValueHolder<?> executeAndGetScalarValueHolder()
                                               throws SQLException

Get the value of the first column in the first row of the result set.

If the result set is empty, null is returned.

Angegeben von:

executeAndGetScalarValueHolder in Schnittstelle IDbPreparedStatement

Gibt zurück:

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.

Löst aus:

SQLException

executeAndGetScalarValue

public Object executeAndGetScalarValue(Object p_valueFallback)
                                throws SQLException

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.

Angegeben von:

executeAndGetScalarValue in Schnittstelle IDbPreparedStatement

Parameter:

p_valueFallback - The return value if the query returns an empty result set or null.

Gibt zurück:

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 is null.

Löst aus:

SQLException

executeAndGetScalarValue

public Object executeAndGetScalarValue()
                                throws SQLException

Get the value of the first column in the first row of the result set.

If the result set is empty, null is returned.

Angegeben von:

executeAndGetScalarValue in Schnittstelle IDbPreparedStatement

Gibt zurück:

The value of the first column in the first row of the result set, or null if the result set is empty.

Löst aus:

SQLException

executeAndGetScalarBooleanValue

public Boolean executeAndGetScalarBooleanValue(Object p_valueFallback)
                                        throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Typed version of IDbPreparedStatement.executeAndGetScalarValue(Object).

Angegeben von:

executeAndGetScalarBooleanValue in Schnittstelle IDbPreparedStatement

Löst aus:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

Siehe auch:

• IDbPreparedStatement.executeAndGetScalarValue(Object)

executeAndGetScalarBooleanValue

public Boolean executeAndGetScalarBooleanValue()
                                        throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Typed version of IDbPreparedStatement.executeAndGetScalarValue().

Angegeben von:

executeAndGetScalarBooleanValue in Schnittstelle IDbPreparedStatement

Löst aus:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

Siehe auch:

• IDbPreparedStatement.executeAndGetScalarValue()

executeAndGetScalarByteValue

public Byte executeAndGetScalarByteValue(Object p_valueFallback)
                                  throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Typed version of IDbPreparedStatement.executeAndGetScalarValue(Object).

Angegeben von:

executeAndGetScalarByteValue in Schnittstelle IDbPreparedStatement

Löst aus:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

Siehe auch:

• IDbPreparedStatement.executeAndGetScalarValue(Object)

executeAndGetScalarByteValue

public Byte executeAndGetScalarByteValue()
                                  throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Typed version of IDbPreparedStatement.executeAndGetScalarValue().

Angegeben von:

executeAndGetScalarByteValue in Schnittstelle IDbPreparedStatement

Löst aus:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

Siehe auch:

• IDbPreparedStatement.executeAndGetScalarValue()

executeAndGetScalarShortValue

public Short executeAndGetScalarShortValue(Object p_valueFallback)
                                    throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Typed version of IDbPreparedStatement.executeAndGetScalarValue(Object).

Angegeben von:

executeAndGetScalarShortValue in Schnittstelle IDbPreparedStatement

Löst aus:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

Siehe auch:

• IDbPreparedStatement.executeAndGetScalarValue(Object)

executeAndGetScalarShortValue

public Short executeAndGetScalarShortValue()
                                    throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Typed version of IDbPreparedStatement.executeAndGetScalarValue().

Angegeben von:

executeAndGetScalarShortValue in Schnittstelle IDbPreparedStatement

Löst aus:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

Siehe auch:

• IDbPreparedStatement.executeAndGetScalarValue()

executeAndGetScalarIntValue

public Integer executeAndGetScalarIntValue(Object p_valueFallback)
                                    throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Typed version of IDbPreparedStatement.executeAndGetScalarValue(Object).

Angegeben von:

executeAndGetScalarIntValue in Schnittstelle IDbPreparedStatement

Löst aus:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

Siehe auch:

• IDbPreparedStatement.executeAndGetScalarValue(Object)

executeAndGetScalarIntValue

public Integer executeAndGetScalarIntValue()
                                    throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Typed version of IDbPreparedStatement.executeAndGetScalarValue().

Angegeben von:

executeAndGetScalarIntValue in Schnittstelle IDbPreparedStatement

Löst aus:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

Siehe auch:

• IDbPreparedStatement.executeAndGetScalarValue()

executeAndGetScalarLongValue

public Long executeAndGetScalarLongValue(Object p_valueFallback)
                                  throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Typed version of IDbPreparedStatement.executeAndGetScalarValue(Object).

Angegeben von:

executeAndGetScalarLongValue in Schnittstelle IDbPreparedStatement

Löst aus:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

Siehe auch:

• IDbPreparedStatement.executeAndGetScalarValue(Object)

executeAndGetScalarLongValue

public Long executeAndGetScalarLongValue()
                                  throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Typed version of IDbPreparedStatement.executeAndGetScalarValue().

Angegeben von:

executeAndGetScalarLongValue in Schnittstelle IDbPreparedStatement

Löst aus:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

Siehe auch:

• IDbPreparedStatement.executeAndGetScalarValue()

executeAndGetScalarFloatValue

public Float executeAndGetScalarFloatValue(Object p_valueFallback)
                                    throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Typed version of IDbPreparedStatement.executeAndGetScalarValue(Object).

Angegeben von:

executeAndGetScalarFloatValue in Schnittstelle IDbPreparedStatement

Löst aus:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

Siehe auch:

• IDbPreparedStatement.executeAndGetScalarValue(Object)

executeAndGetScalarFloatValue

public Float executeAndGetScalarFloatValue()
                                    throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Typed version of IDbPreparedStatement.executeAndGetScalarValue().

Angegeben von:

executeAndGetScalarFloatValue in Schnittstelle IDbPreparedStatement

Löst aus:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

Siehe auch:

• IDbPreparedStatement.executeAndGetScalarValue()

executeAndGetScalarDoubleValue

public Double executeAndGetScalarDoubleValue(Object p_valueFallback)
                                      throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Typed version of IDbPreparedStatement.executeAndGetScalarValue(Object).

Angegeben von:

executeAndGetScalarDoubleValue in Schnittstelle IDbPreparedStatement

Löst aus:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

Siehe auch:

• IDbPreparedStatement.executeAndGetScalarValue(Object)

executeAndGetScalarDoubleValue

public Double executeAndGetScalarDoubleValue()
                                      throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Typed version of IDbPreparedStatement.executeAndGetScalarValue().

Angegeben von:

executeAndGetScalarDoubleValue in Schnittstelle IDbPreparedStatement

Löst aus:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

Siehe auch:

• IDbPreparedStatement.executeAndGetScalarValue()

executeAndGetScalarBigDecimalValue

public BigDecimal executeAndGetScalarBigDecimalValue(Object p_valueFallback)
                                              throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Typed version of IDbPreparedStatement.executeAndGetScalarValue(Object).

Angegeben von:

executeAndGetScalarBigDecimalValue in Schnittstelle IDbPreparedStatement

Löst aus:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

Siehe auch:

• IDbPreparedStatement.executeAndGetScalarValue(Object)

executeAndGetScalarBigDecimalValue

public BigDecimal executeAndGetScalarBigDecimalValue()
                                              throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Typed version of IDbPreparedStatement.executeAndGetScalarValue().

Angegeben von:

executeAndGetScalarBigDecimalValue in Schnittstelle IDbPreparedStatement

Löst aus:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

Siehe auch:

• IDbPreparedStatement.executeAndGetScalarValue()

executeAndGetScalarStringValue

public String executeAndGetScalarStringValue(Object p_valueFallback)
                                      throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Typed version of IDbPreparedStatement.executeAndGetScalarValue(Object).

Angegeben von:

executeAndGetScalarStringValue in Schnittstelle IDbPreparedStatement

Löst aus:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

Siehe auch:

• IDbPreparedStatement.executeAndGetScalarValue(Object)

executeAndGetScalarStringValue

public String executeAndGetScalarStringValue()
                                      throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Typed version of IDbPreparedStatement.executeAndGetScalarValue().

Angegeben von:

executeAndGetScalarStringValue in Schnittstelle IDbPreparedStatement

Löst aus:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

Siehe auch:

• IDbPreparedStatement.executeAndGetScalarValue()

executeAndGetScalarTimestampValue

public Timestamp executeAndGetScalarTimestampValue(Object p_valueFallback)
                                            throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Typed version of IDbPreparedStatement.executeAndGetScalarValue(Object).

Angegeben von:

executeAndGetScalarTimestampValue in Schnittstelle IDbPreparedStatement

Löst aus:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

Siehe auch:

• IDbPreparedStatement.executeAndGetScalarValue(Object)

executeAndGetScalarTimestampValue

public Timestamp executeAndGetScalarTimestampValue()
                                            throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Typed version of IDbPreparedStatement.executeAndGetScalarValue().

Angegeben von:

executeAndGetScalarTimestampValue in Schnittstelle IDbPreparedStatement

Löst aus:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

Siehe auch:

• IDbPreparedStatement.executeAndGetScalarValue()

executeAndGetScalarDateValue

public Date executeAndGetScalarDateValue(Object p_valueFallback)
                                  throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Typed version of IDbPreparedStatement.executeAndGetScalarValue(Object).

Angegeben von:

executeAndGetScalarDateValue in Schnittstelle IDbPreparedStatement

Löst aus:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

Siehe auch:

• IDbPreparedStatement.executeAndGetScalarValue(Object)

executeAndGetScalarDateValue

public Date executeAndGetScalarDateValue()
                                  throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Typed version of IDbPreparedStatement.executeAndGetScalarValue().

Angegeben von:

executeAndGetScalarDateValue in Schnittstelle IDbPreparedStatement

Löst aus:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

Siehe auch:

• IDbPreparedStatement.executeAndGetScalarValue()

executeAndGetScalarTimeValue

public Date executeAndGetScalarTimeValue(Object p_valueFallback)
                                  throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Typed version of IDbPreparedStatement.executeAndGetScalarValue(Object).

Angegeben von:

executeAndGetScalarTimeValue in Schnittstelle IDbPreparedStatement

Löst aus:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

Siehe auch:

• IDbPreparedStatement.executeAndGetScalarValue(Object)

executeAndGetScalarTimeValue

public Date executeAndGetScalarTimeValue()
                                  throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Typed version of IDbPreparedStatement.executeAndGetScalarValue().

Angegeben von:

executeAndGetScalarTimeValue in Schnittstelle IDbPreparedStatement

Löst aus:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

Siehe auch:

• IDbPreparedStatement.executeAndGetScalarValue()

setBoolean

public void setBoolean(int p_iIdx,
 Object p_value)
                throws SQLException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Sets the designated parameter to the given boolean value.

Angegeben von:

setBoolean in Schnittstelle IDbPreparedStatement

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

public void setInt(int p_iIdx,
 Object p_value)
            throws SQLException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Sets the designated parameter to the given integer number value.

Angegeben von:

setInt in Schnittstelle IDbPreparedStatement

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

public void setLong(int p_iIdx,
 Object p_value)
             throws SQLException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Sets the designated parameter to the given integer number value.

Angegeben von:

setLong in Schnittstelle IDbPreparedStatement

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

public void setShort(int p_iIdx,
 Object p_value)
              throws SQLException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Sets the designated parameter to the given integer number value.

Angegeben von:

setShort in Schnittstelle IDbPreparedStatement

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

public void setByte(int p_iIdx,
 Object p_value)
             throws SQLException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Sets the designated parameter to the given integer value.

Angegeben von:

setByte in Schnittstelle IDbPreparedStatement

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

public void setBigDecimal(int p_iIdx,
 Object p_value)
                   throws SQLException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Sets the designated parameter to the given number value.

Angegeben von:

setBigDecimal in Schnittstelle IDbPreparedStatement

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

public void setFloat(int p_iIdx,
 Object p_value)
              throws SQLException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Sets the designated parameter to the given floating point number value.

Angegeben von:

setFloat in Schnittstelle IDbPreparedStatement

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

public void setDouble(int p_iIdx,
 Object p_value)
               throws SQLException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Sets the designated parameter to the given floating point number value.

Angegeben von:

setDouble in Schnittstelle IDbPreparedStatement

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

public void setTimestamp(int p_iIdx,
 Object p_value)
                  throws SQLException

Beschreibung aus Schnittstelle kopiert: 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.

Angegeben von:

setTimestamp in Schnittstelle IDbPreparedStatement

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

public void setTimestamp(int p_iIdx,
 Object p_value,
 TimeZone p_tz)
                  throws SQLException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Sets the designated parameter to the given timestamp value.

Angegeben von:

setTimestamp in Schnittstelle IDbPreparedStatement

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

public void setTimestamp(int p_iIdx,
 Object p_value,
 Calendar p_cal)
                  throws SQLException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Sets the designated parameter to the given timestamp value.

Angegeben von:

setTimestamp in Schnittstelle IDbPreparedStatement

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

public void setTime(int p_iIdx,
 Object p_value)
             throws SQLException

Beschreibung aus Schnittstelle kopiert: 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.

Angegeben von:

setTime in Schnittstelle IDbPreparedStatement

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

public void setTime(int p_iIdx,
 Object p_value,
 TimeZone p_tz)
             throws SQLException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Sets the designated parameter to the given time value.

Angegeben von:

setTime in Schnittstelle IDbPreparedStatement

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

public void setTime(int p_iIdx,
 Object p_value,
 Calendar p_cal)
             throws SQLException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Sets the designated parameter to the given time value.

Angegeben von:

setTime in Schnittstelle IDbPreparedStatement

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

public void setDate(int p_iIdx,
 Object p_value)
             throws SQLException

Beschreibung aus Schnittstelle kopiert: 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.

Angegeben von:

setDate in Schnittstelle IDbPreparedStatement

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

public void setDate(int p_iIdx,
 Object p_value,
 TimeZone p_tz)
             throws SQLException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Sets the designated parameter to the given date value.

Angegeben von:

setDate in Schnittstelle IDbPreparedStatement

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

public void setDate(int p_iIdx,
 Object p_value,
 Calendar p_cal)
             throws SQLException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Sets the designated parameter to the given date value.

Angegeben von:

setDate in Schnittstelle IDbPreparedStatement

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

public void setString(int p_iIdx,
 Object p_value)
               throws SQLException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Sets the designated parameter to the given string value.

Angegeben von:

setString in Schnittstelle IDbPreparedStatement

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

public void setCharacterStream(int p_iIdx,
 Object p_value)
                        throws SQLException,
IOException

Beschreibung aus Schnittstelle kopiert: IDbPreparedStatement

Sets the designated parameter to the value given string value.

Angegeben von:

setCharacterStream in Schnittstelle IDbPreparedStatement

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

public void close()
           throws SQLException

Close this statement.

Angegeben von:

close in Schnittstelle AutoCloseable

Angegeben von:

close in Schnittstelle IDbPreparedStatement

Löst aus:

SQLException - If a database error occurred.