Package de.uplanet.lucy.server.util.db

Klasse DbQuery

java.lang.Object

de.uplanet.lucy.server.util.db.DbQuery

Alle implementierten Schnittstellen:

IDbQuery, ICloseable, AutoCloseable

public final class DbQuery
extends Object
implements IDbQuery

This class provides a database API that is intended to be used in scripting environments.

Konstruktorübersicht

Konstruktoren

Konstruktor	Beschreibung
DbQuery()

Methodenübersicht

Modifizierer und Typ	Methode	Beschreibung
void	close()	Close this database query object and all dependent DbPreparedStatement and DbResultSet objects.
BigDecimal	executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
BigDecimal	executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
BigDecimal	executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
BigDecimal	executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
Boolean	executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
Boolean	executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
Boolean	executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
Boolean	executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
Byte	executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
Byte	executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
Byte	executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
Byte	executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
Date	executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
Date	executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
Date	executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
Date	executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
Double	executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
Double	executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
Double	executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
Double	executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
Float	executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
Float	executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
Float	executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
Float	executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
Integer	executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
Integer	executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
Integer	executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
Integer	executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
Long	executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
Long	executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
Long	executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
Long	executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
Short	executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
Short	executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
Short	executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
Short	executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
String	executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
String	executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
String	executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
String	executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
Timestamp	executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
Timestamp	executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
Timestamp	executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
Timestamp	executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
Date	executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
Date	executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
Date	executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
Date	executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
Object	executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Get the value of the first column in the first row of the result set.
Object	executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Get the value of the first column in the first row of the result set.
Object	executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Get the value of the first column in the first row of the result set.
Object	executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)	Get the value of the first column in the first row of the result set.
IValueHolder<?>	executeAndGetScalarValueHolder(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Get the value of the first column in the first row of the result set.
int	executeUpdate(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Execute an INSERT or UPDATE statement.
int	executeUpdate(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Execute a prepared INSERT or UPDATE statement.
int	getDefaultFetchSize()	Get the default fetch size.
DbPreparedStatement	prepare(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Prepares a statement.
Object	prepareWithStatement(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Creates a IDbPreparedStatement and evaluates the given closure with it as parameter and its delegate.
void	setDefaultFetchSize(int p_iDefaultFetchSize)	Set the default fetch size for prepared statements created by this class.

Von Klasse geerbte Methoden java.lang.Object

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

Konstruktordetails

DbQuery

public DbQuery()

Methodendetails

getDefaultFetchSize

public int getDefaultFetchSize()

Get the default fetch size. The default value is 100.

Angegeben von:

getDefaultFetchSize in Schnittstelle IDbQuery

Gibt zurück:

The default fetch size.

setDefaultFetchSize

public void setDefaultFetchSize(int p_iDefaultFetchSize)

Set the default fetch size for prepared statements created by this class.

Angegeben von:

setDefaultFetchSize in Schnittstelle IDbQuery

Parameter:

p_iDefaultFetchSize - The default fetch size.

executeAndGetScalarValueHolder

public IValueHolder<?> executeAndGetScalarValueHolder(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery)
                                               throws SQLException

Beschreibung aus Schnittstelle kopiert: IDbQuery

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 IDbQuery

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 - If a database error occurred.

executeAndGetScalarValue

public Object executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 Object p_valueFallback)
                                throws SQLException

Beschreibung aus Schnittstelle kopiert: IDbQuery

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.

Note: The type of the result depends on the database column's datatype. To coerce the result to a specific type use the respective executeAndGetScalarValueXxx methods.

Angegeben von:

executeAndGetScalarValue in Schnittstelle IDbQuery

Parameter:

p_conn - The database connection to be used.

p_strQuery - The query.

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 - If a database error occurred.

executeAndGetScalarValue

public Object executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery)
                                throws SQLException

Beschreibung aus Schnittstelle kopiert: IDbQuery

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

If the result set is empty, null is returned.

Note: The type of the result depends on the database column's datatype. To coerce the result to a specific type use the respective executeAndGetScalarValueXxx methods.

Angegeben von:

executeAndGetScalarValue in Schnittstelle IDbQuery

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 - If a database error occurred.

executeAndGetScalarValue

public Object executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 Object p_valueFallback,
 groovy.lang.Closure<?> p_closure)
                                throws SQLException

Beschreibung aus Schnittstelle kopiert: IDbQuery

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.

Note: The type of the result depends on the database column's datatype. To coerce the result to a specific type use the respective executeAndGetScalarValueXxx methods.

Angegeben von:

executeAndGetScalarValue in Schnittstelle IDbQuery

Parameter:

p_conn - The database connection to be used.

p_strQuery - The query.

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

p_closure - The closure that prepares the statement.

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 - If a database error occurred.

executeAndGetScalarValue

public Object executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 groovy.lang.Closure<?> p_closure)
                                throws SQLException

Beschreibung aus Schnittstelle kopiert: IDbQuery

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.

Note: The type of the result depends on the database column's datatype. To coerce the result to a specific type use the respective executeAndGetScalarValueXxx methods.

Angegeben von:

executeAndGetScalarValue in Schnittstelle IDbQuery

Parameter:

p_conn - The database connection to be used.

p_strQuery - The query.

p_closure - The closure that prepares the statement.

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 - If a database error occurred.

executeAndGetScalarBooleanValue

public Boolean executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 Object p_valueFallback)
                                        throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Angegeben von:

executeAndGetScalarBooleanValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarBooleanValue

public Boolean executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery)
                                        throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Angegeben von:

executeAndGetScalarBooleanValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarBooleanValue

public Boolean executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 Object p_valueFallback,
 groovy.lang.Closure<?> p_closure)
                                        throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Angegeben von:

executeAndGetScalarBooleanValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarBooleanValue

public Boolean executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 groovy.lang.Closure<?> p_closure)
                                        throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Angegeben von:

executeAndGetScalarBooleanValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarByteValue

public Byte executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 Object p_valueFallback)
                                  throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Angegeben von:

executeAndGetScalarByteValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarByteValue

public Byte executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery)
                                  throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Angegeben von:

executeAndGetScalarByteValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarByteValue

public Byte executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 Object p_valueFallback,
 groovy.lang.Closure<?> p_closure)
                                  throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Angegeben von:

executeAndGetScalarByteValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarByteValue

public Byte executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 groovy.lang.Closure<?> p_closure)
                                  throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Angegeben von:

executeAndGetScalarByteValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarShortValue

public Short executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 Object p_valueFallback)
                                    throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Angegeben von:

executeAndGetScalarShortValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarShortValue

public Short executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery)
                                    throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Angegeben von:

executeAndGetScalarShortValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarShortValue

public Short executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 Object p_valueFallback,
 groovy.lang.Closure<?> p_closure)
                                    throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Angegeben von:

executeAndGetScalarShortValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarShortValue

public Short executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 groovy.lang.Closure<?> p_closure)
                                    throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Angegeben von:

executeAndGetScalarShortValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarIntValue

public Integer executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 Object p_valueFallback)
                                    throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Angegeben von:

executeAndGetScalarIntValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarIntValue

public Integer executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery)
                                    throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Angegeben von:

executeAndGetScalarIntValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarIntValue

public Integer executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 Object p_valueFallback,
 groovy.lang.Closure<?> p_closure)
                                    throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Angegeben von:

executeAndGetScalarIntValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarIntValue

public Integer executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 groovy.lang.Closure<?> p_closure)
                                    throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Angegeben von:

executeAndGetScalarIntValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarLongValue

public Long executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 Object p_valueFallback)
                                  throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Angegeben von:

executeAndGetScalarLongValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarLongValue

public Long executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery)
                                  throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Angegeben von:

executeAndGetScalarLongValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarLongValue

public Long executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 Object p_valueFallback,
 groovy.lang.Closure<?> p_closure)
                                  throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Angegeben von:

executeAndGetScalarLongValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarLongValue

public Long executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 groovy.lang.Closure<?> p_closure)
                                  throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Angegeben von:

executeAndGetScalarLongValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarFloatValue

public Float executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 Object p_valueFallback)
                                    throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Angegeben von:

executeAndGetScalarFloatValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarFloatValue

public Float executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery)
                                    throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Angegeben von:

executeAndGetScalarFloatValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarFloatValue

public Float executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 Object p_valueFallback,
 groovy.lang.Closure<?> p_closure)
                                    throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Angegeben von:

executeAndGetScalarFloatValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarFloatValue

public Float executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 groovy.lang.Closure<?> p_closure)
                                    throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Angegeben von:

executeAndGetScalarFloatValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarDoubleValue

public Double executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 Object p_valueFallback)
                                      throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Angegeben von:

executeAndGetScalarDoubleValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarDoubleValue

public Double executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery)
                                      throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Angegeben von:

executeAndGetScalarDoubleValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarDoubleValue

public Double executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 Object p_valueFallback,
 groovy.lang.Closure<?> p_closure)
                                      throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Angegeben von:

executeAndGetScalarDoubleValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarDoubleValue

public Double executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 groovy.lang.Closure<?> p_closure)
                                      throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Angegeben von:

executeAndGetScalarDoubleValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarBigDecimalValue

public BigDecimal executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 Object p_valueFallback)
                                              throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Angegeben von:

executeAndGetScalarBigDecimalValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarBigDecimalValue

public BigDecimal executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery)
                                              throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Angegeben von:

executeAndGetScalarBigDecimalValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarBigDecimalValue

public BigDecimal executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 Object p_valueFallback,
 groovy.lang.Closure<?> p_closure)
                                              throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Angegeben von:

executeAndGetScalarBigDecimalValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarBigDecimalValue

public BigDecimal executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 groovy.lang.Closure<?> p_closure)
                                              throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Angegeben von:

executeAndGetScalarBigDecimalValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarStringValue

public String executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 Object p_valueFallback)
                                      throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Angegeben von:

executeAndGetScalarStringValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarStringValue

public String executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery)
                                      throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Angegeben von:

executeAndGetScalarStringValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarStringValue

public String executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 Object p_valueFallback,
 groovy.lang.Closure<?> p_closure)
                                      throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Angegeben von:

executeAndGetScalarStringValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarStringValue

public String executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 groovy.lang.Closure<?> p_closure)
                                      throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Angegeben von:

executeAndGetScalarStringValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarTimestampValue

public Timestamp executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 Object p_valueFallback)
                                            throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Angegeben von:

executeAndGetScalarTimestampValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarTimestampValue

public Timestamp executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery)
                                            throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Angegeben von:

executeAndGetScalarTimestampValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarTimestampValue

public Timestamp executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 Object p_valueFallback,
 groovy.lang.Closure<?> p_closure)
                                            throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Angegeben von:

executeAndGetScalarTimestampValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarTimestampValue

public Timestamp executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 groovy.lang.Closure<?> p_closure)
                                            throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Angegeben von:

executeAndGetScalarTimestampValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarDateValue

public Date executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 Object p_valueFallback)
                                  throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Angegeben von:

executeAndGetScalarDateValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarDateValue

public Date executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery)
                                  throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Angegeben von:

executeAndGetScalarDateValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarDateValue

public Date executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 Object p_valueFallback,
 groovy.lang.Closure<?> p_closure)
                                  throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Angegeben von:

executeAndGetScalarDateValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarDateValue

public Date executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 groovy.lang.Closure<?> p_closure)
                                  throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Angegeben von:

executeAndGetScalarDateValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarTimeValue

public Date executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 Object p_valueFallback)
                                  throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Angegeben von:

executeAndGetScalarTimeValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarTimeValue

public Date executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery)
                                  throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Angegeben von:

executeAndGetScalarTimeValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarTimeValue

public Date executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 Object p_valueFallback,
 groovy.lang.Closure<?> p_closure)
                                  throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Angegeben von:

executeAndGetScalarTimeValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarTimeValue

public Date executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 groovy.lang.Closure<?> p_closure)
                                  throws SQLException,
ValueCastException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Angegeben von:

executeAndGetScalarTimeValue in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.

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

Siehe auch:

• IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeUpdate

public int executeUpdate(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery)
                  throws SQLException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Execute an INSERT or UPDATE statement.

Angegeben von:

executeUpdate in Schnittstelle IDbQuery

Parameter:

p_conn - The database connection to be used.

p_strQuery - The SQL statement to be executed.

Gibt zurück:

The number of affected rows in the database, or 0.

Löst aus:

SQLException

executeUpdate

public int executeUpdate(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 groovy.lang.Closure<?> p_closure)
                  throws SQLException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Execute a prepared INSERT or UPDATE statement.

Angegeben von:

executeUpdate in Schnittstelle IDbQuery

Parameter:

p_conn - The database connection to be used.

p_strQuery - The (prepared) SQL statement to be executed.

p_closure - The closure that prepares the statement.

Gibt zurück:

The number of affected rows in the database, or 0.

Löst aus:

SQLException

prepare

public DbPreparedStatement prepare(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery)
                            throws SQLException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Prepares a statement.

Angegeben von:

prepare in Schnittstelle IDbQuery

Parameter:

p_conn - The database connection to be used.

p_strQuery - The (parameterized) SQL query.

Gibt zurück:

A prepared statement object.

Löst aus:

SQLException - If a database error occurred.

prepareWithStatement

public Object prepareWithStatement(de.uplanet.jdbc.JdbcConnection p_conn,
 String p_strQuery,
 groovy.lang.Closure<?> p_closure)
                            throws SQLException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Creates a IDbPreparedStatement and evaluates the given closure with it as parameter and its delegate.

Angegeben von:

prepareWithStatement in Schnittstelle IDbQuery

Parameter:

p_conn - The database connection to be used.

p_strQuery - The (parameterized) SQL query.

p_closure - The closure that prepares and executes the statement.

Gibt zurück:

The return value of the given closure.

Löst aus:

SQLException - If a database error occurred.

close

public void close()
           throws SQLException

Beschreibung aus Schnittstelle kopiert: IDbQuery

Close this database query object and all dependent DbPreparedStatement and DbResultSet objects.

Angegeben von:

close in Schnittstelle AutoCloseable

Angegeben von:

close in Schnittstelle IDbQuery

Löst aus:

SQLException - If a database error occurred.