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

Interface IDbQuery

All Superinterfaces:

AutoCloseable, ICloseable

All Known Implementing Classes:

DbQuery

public interface IDbQuery
extends ICloseable

Method Summary

Modifier and Type	Method	Description
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 executeAndGetScalarValue(JdbcConnection, String).
BigDecimal	executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of executeAndGetScalarValue(JdbcConnection, String, Closure).
BigDecimal	executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of 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 executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
Boolean	executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of executeAndGetScalarValue(JdbcConnection, String).
Boolean	executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of executeAndGetScalarValue(JdbcConnection, String, Closure).
Boolean	executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of 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 executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
Byte	executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of executeAndGetScalarValue(JdbcConnection, String).
Byte	executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of executeAndGetScalarValue(JdbcConnection, String, Closure).
Byte	executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of 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 executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
Date	executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of executeAndGetScalarValue(JdbcConnection, String).
Date	executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of executeAndGetScalarValue(JdbcConnection, String, Closure).
Date	executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of 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 executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
Double	executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of executeAndGetScalarValue(JdbcConnection, String).
Double	executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of executeAndGetScalarValue(JdbcConnection, String, Closure).
Double	executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of 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 executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
Float	executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of executeAndGetScalarValue(JdbcConnection, String).
Float	executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of executeAndGetScalarValue(JdbcConnection, String, Closure).
Float	executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of 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 executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
Integer	executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of executeAndGetScalarValue(JdbcConnection, String).
Integer	executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of executeAndGetScalarValue(JdbcConnection, String, Closure).
Integer	executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of 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 executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
Long	executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of executeAndGetScalarValue(JdbcConnection, String).
Long	executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of executeAndGetScalarValue(JdbcConnection, String, Closure).
Long	executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of 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 executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
Short	executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of executeAndGetScalarValue(JdbcConnection, String).
Short	executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of executeAndGetScalarValue(JdbcConnection, String, Closure).
Short	executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of 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 executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
String	executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of executeAndGetScalarValue(JdbcConnection, String).
String	executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of executeAndGetScalarValue(JdbcConnection, String, Closure).
String	executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of 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 executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
Timestamp	executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of executeAndGetScalarValue(JdbcConnection, String).
Timestamp	executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of executeAndGetScalarValue(JdbcConnection, String, Closure).
Timestamp	executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of 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 executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
Date	executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of executeAndGetScalarValue(JdbcConnection, String).
Date	executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of executeAndGetScalarValue(JdbcConnection, String, Closure).
Date	executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of 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 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.
void	setDefaultFetchSize(int p_iDefaultFetchSize)	Set the default fetch size for prepared statements.

Method Detail

getDefaultFetchSize

int getDefaultFetchSize()

Get the default fetch size.

Returns:

The default fetch size.

setDefaultFetchSize

void setDefaultFetchSize(int p_iDefaultFetchSize)

Set the default fetch size for prepared statements.

Parameters:

p_iDefaultFetchSize - The default fetch size.

executeAndGetScalarValueHolder

IValueHolder<?> executeAndGetScalarValueHolder(de.uplanet.jdbc.JdbcConnection p_conn,
                                               String p_strQuery)
                                        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.

Returns:

A value holder that contains the value of the first column in the first row of the result set, or null if the result set is empty.

Throws:

SQLException - If a database error occurred.

executeAndGetScalarValue

Object executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                String p_strQuery,
                                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.

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.

Parameters:

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.

Returns:

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

Throws:

SQLException - If a database error occurred.

executeAndGetScalarValue

Object executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                String p_strQuery)
                         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.

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.

Returns:

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

Throws:

SQLException - If a database error occurred.

executeAndGetScalarValue

Object executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                String p_strQuery,
                                Object p_valueFallback,
                                groovy.lang.Closure<?> p_closure)
                         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.

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.

Parameters:

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.

Returns:

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

Throws:

SQLException - If a database error occurred.

executeAndGetScalarValue

Object executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                String p_strQuery,
                                groovy.lang.Closure<?> p_closure)
                         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.

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.

Parameters:

p_conn - The database connection to be used.

p_strQuery - The query.

p_closure - The closure that prepares the statement.

Returns:

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

Throws:

SQLException - If a database error occurred.

executeAndGetScalarBooleanValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarBooleanValue

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

Typed version of executeAndGetScalarValue(JdbcConnection, String).

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarBooleanValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarBooleanValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarByteValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarByteValue

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

Typed version of executeAndGetScalarValue(JdbcConnection, String).

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarByteValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarByteValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarShortValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarShortValue

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

Typed version of executeAndGetScalarValue(JdbcConnection, String).

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarShortValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarShortValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarIntValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarIntValue

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

Typed version of executeAndGetScalarValue(JdbcConnection, String).

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarIntValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarIntValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarLongValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarLongValue

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

Typed version of executeAndGetScalarValue(JdbcConnection, String).

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarLongValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarLongValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarFloatValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarFloatValue

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

Typed version of executeAndGetScalarValue(JdbcConnection, String).

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarFloatValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarFloatValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarDoubleValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarDoubleValue

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

Typed version of executeAndGetScalarValue(JdbcConnection, String).

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarDoubleValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarDoubleValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarBigDecimalValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarBigDecimalValue

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

Typed version of executeAndGetScalarValue(JdbcConnection, String).

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarBigDecimalValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarBigDecimalValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarStringValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarStringValue

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

Typed version of executeAndGetScalarValue(JdbcConnection, String).

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarStringValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarStringValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarTimestampValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarTimestampValue

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

Typed version of executeAndGetScalarValue(JdbcConnection, String).

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarTimestampValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarTimestampValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarDateValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarDateValue

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

Typed version of executeAndGetScalarValue(JdbcConnection, String).

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarDateValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarDateValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarTimeValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarTimeValue

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

Typed version of executeAndGetScalarValue(JdbcConnection, String).

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarTimeValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarTimeValue

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

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

Throws:

SQLException - If a database error occurred.

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

See Also:

executeAndGetScalarValue(JdbcConnection, String, Closure)

executeUpdate

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

Execute an INSERT or UPDATE statement.

Parameters:

p_conn - The database connection to be used.

p_strQuery - The SQL statement to be executed.

Returns:

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

Throws:

SQLException

executeUpdate

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

Execute a prepared INSERT or UPDATE statement.

Parameters:

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.

Returns:

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

Throws:

SQLException

prepare

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

Prepares a statement.

Parameters:

p_conn - The database connection to be used.

p_strQuery - The (parameterized) SQL query.

Returns:

A prepared statement object.

Throws:

SQLException - If a database error occurred.

close

void close()
    throws SQLException

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

Specified by:

close in interface AutoCloseable

Throws:

SQLException - If a database error occurred.