de.uplanet.lucy.server.util.db
Interface IDbQuery

All Superinterfaces:

ICloseable

All Known Implementing Classes:

DbQuery

public interface IDbQuery
extends ICloseable

Version:

$Revision: 92937 $

Method Summary

void	close() Close this database query object and all dependent DbPreparedStatement and DbResultSet objects.
java.math.BigDecimal	executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) Typed version of executeAndGetScalarValue(JdbcConnection, String).
java.math.BigDecimal	executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure) Typed version of executeAndGetScalarValue(JdbcConnection, String, Closure).
java.math.BigDecimal	executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback) Typed version of executeAndGetScalarValue(JdbcConnection, String, Object).
java.math.BigDecimal	executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure) Typed version of executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
java.lang.Boolean	executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) Typed version of executeAndGetScalarValue(JdbcConnection, String).
java.lang.Boolean	executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure) Typed version of executeAndGetScalarValue(JdbcConnection, String, Closure).
java.lang.Boolean	executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback) Typed version of executeAndGetScalarValue(JdbcConnection, String, Object).
java.lang.Boolean	executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure) Typed version of executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
java.lang.Byte	executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) Typed version of executeAndGetScalarValue(JdbcConnection, String).
java.lang.Byte	executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure) Typed version of executeAndGetScalarValue(JdbcConnection, String, Closure).
java.lang.Byte	executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback) Typed version of executeAndGetScalarValue(JdbcConnection, String, Object).
java.lang.Byte	executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure) Typed version of executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
java.util.Date	executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) Typed version of executeAndGetScalarValue(JdbcConnection, String).
java.util.Date	executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure) Typed version of executeAndGetScalarValue(JdbcConnection, String, Closure).
java.util.Date	executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback) Typed version of executeAndGetScalarValue(JdbcConnection, String, Object).
java.util.Date	executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure) Typed version of executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
java.lang.Double	executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) Typed version of executeAndGetScalarValue(JdbcConnection, String).
java.lang.Double	executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure) Typed version of executeAndGetScalarValue(JdbcConnection, String, Closure).
java.lang.Double	executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback) Typed version of executeAndGetScalarValue(JdbcConnection, String, Object).
java.lang.Double	executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure) Typed version of executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
java.lang.Float	executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) Typed version of executeAndGetScalarValue(JdbcConnection, String).
java.lang.Float	executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure) Typed version of executeAndGetScalarValue(JdbcConnection, String, Closure).
java.lang.Float	executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback) Typed version of executeAndGetScalarValue(JdbcConnection, String, Object).
java.lang.Float	executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure) Typed version of executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
java.lang.Integer	executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) Typed version of executeAndGetScalarValue(JdbcConnection, String).
java.lang.Integer	executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure) Typed version of executeAndGetScalarValue(JdbcConnection, String, Closure).
java.lang.Integer	executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback) Typed version of executeAndGetScalarValue(JdbcConnection, String, Object).
java.lang.Integer	executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure) Typed version of executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
java.lang.Long	executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) Typed version of executeAndGetScalarValue(JdbcConnection, String).
java.lang.Long	executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure) Typed version of executeAndGetScalarValue(JdbcConnection, String, Closure).
java.lang.Long	executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback) Typed version of executeAndGetScalarValue(JdbcConnection, String, Object).
java.lang.Long	executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure) Typed version of executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
java.lang.Short	executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) Typed version of executeAndGetScalarValue(JdbcConnection, String).
java.lang.Short	executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure) Typed version of executeAndGetScalarValue(JdbcConnection, String, Closure).
java.lang.Short	executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback) Typed version of executeAndGetScalarValue(JdbcConnection, String, Object).
java.lang.Short	executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure) Typed version of executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
java.lang.String	executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) Typed version of executeAndGetScalarValue(JdbcConnection, String).
java.lang.String	executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure) Typed version of executeAndGetScalarValue(JdbcConnection, String, Closure).
java.lang.String	executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback) Typed version of executeAndGetScalarValue(JdbcConnection, String, Object).
java.lang.String	executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure) Typed version of executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
java.sql.Timestamp	executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) Typed version of executeAndGetScalarValue(JdbcConnection, String).
java.sql.Timestamp	executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure) Typed version of executeAndGetScalarValue(JdbcConnection, String, Closure).
java.sql.Timestamp	executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback) Typed version of executeAndGetScalarValue(JdbcConnection, String, Object).
java.sql.Timestamp	executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure) Typed version of executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
java.util.Date	executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) Typed version of executeAndGetScalarValue(JdbcConnection, String).
java.util.Date	executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure) Typed version of executeAndGetScalarValue(JdbcConnection, String, Closure).
java.util.Date	executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback) Typed version of executeAndGetScalarValue(JdbcConnection, String, Object).
java.util.Date	executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure) Typed version of executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
java.lang.Object	executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) Get the value of the first column in the first row of the result set.
java.lang.Object	executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure) Get the value of the first column in the first row of the result set.
java.lang.Object	executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback) Get the value of the first column in the first row of the result set.
java.lang.Object	executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.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, java.lang.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, java.lang.String p_strQuery) Execute an INSERT or UPDATE statement.
int	executeUpdate(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure) Execute a prepared INSERT or UPDATE statement.
DbPreparedStatement	prepare(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) Prepares a statement.

Method Detail

executeAndGetScalarValueHolder

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

java.sql.SQLException

executeAndGetScalarValue

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

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:

java.sql.SQLException

executeAndGetScalarValue

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

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

Throws:

java.sql.SQLException

executeAndGetScalarValue

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

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:

java.sql.SQLException

executeAndGetScalarValue

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

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:

java.sql.SQLException

executeAndGetScalarBooleanValue

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

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

Throws:

java.sql.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

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

Typed version of executeAndGetScalarValue(JdbcConnection, String).

Throws:

java.sql.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

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

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

Throws:

java.sql.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

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

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

Throws:

java.sql.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

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

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

Throws:

java.sql.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

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

Typed version of executeAndGetScalarValue(JdbcConnection, String).

Throws:

java.sql.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

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

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

Throws:

java.sql.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

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

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

Throws:

java.sql.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

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

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

Throws:

java.sql.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

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

Typed version of executeAndGetScalarValue(JdbcConnection, String).

Throws:

java.sql.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

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

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

Throws:

java.sql.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

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

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

Throws:

java.sql.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

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

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

Throws:

java.sql.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

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

Typed version of executeAndGetScalarValue(JdbcConnection, String).

Throws:

java.sql.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

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

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

Throws:

java.sql.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

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

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

Throws:

java.sql.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

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

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

Throws:

java.sql.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

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

Typed version of executeAndGetScalarValue(JdbcConnection, String).

Throws:

java.sql.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

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

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

Throws:

java.sql.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

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

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

Throws:

java.sql.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

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

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

Throws:

java.sql.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

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

Typed version of executeAndGetScalarValue(JdbcConnection, String).

Throws:

java.sql.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

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

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

Throws:

java.sql.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

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

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

Throws:

java.sql.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

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

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

Throws:

java.sql.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

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

Typed version of executeAndGetScalarValue(JdbcConnection, String).

Throws:

java.sql.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

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

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

Throws:

java.sql.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

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

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

Throws:

java.sql.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

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

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

Throws:

java.sql.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

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

Typed version of executeAndGetScalarValue(JdbcConnection, String).

Throws:

java.sql.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

java.math.BigDecimal executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                        java.lang.String p_strQuery,
                                                        java.lang.Object p_valueFallback,
                                                        groovy.lang.Closure p_closure)
                                                        throws java.sql.SQLException,
                                                               ValueCastException

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

Throws:

java.sql.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

java.math.BigDecimal executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                        java.lang.String p_strQuery,
                                                        groovy.lang.Closure p_closure)
                                                        throws java.sql.SQLException,
                                                               ValueCastException

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

Throws:

java.sql.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

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

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

Throws:

java.sql.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

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

Typed version of executeAndGetScalarValue(JdbcConnection, String).

Throws:

java.sql.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

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

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

Throws:

java.sql.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

java.lang.String executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                java.lang.String p_strQuery,
                                                groovy.lang.Closure p_closure)
                                                throws java.sql.SQLException,
                                                       ValueCastException

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

Throws:

java.sql.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

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

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

Throws:

java.sql.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

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

Typed version of executeAndGetScalarValue(JdbcConnection, String).

Throws:

java.sql.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

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

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

Throws:

java.sql.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

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

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

Throws:

java.sql.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

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

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

Throws:

java.sql.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

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

Typed version of executeAndGetScalarValue(JdbcConnection, String).

Throws:

java.sql.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

java.util.Date executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                            java.lang.String p_strQuery,
                                            java.lang.Object p_valueFallback,
                                            groovy.lang.Closure p_closure)
                                            throws java.sql.SQLException,
                                                   ValueCastException

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

Throws:

java.sql.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

java.util.Date executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                            java.lang.String p_strQuery,
                                            groovy.lang.Closure p_closure)
                                            throws java.sql.SQLException,
                                                   ValueCastException

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

Throws:

java.sql.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

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

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

Throws:

java.sql.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

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

Typed version of executeAndGetScalarValue(JdbcConnection, String).

Throws:

java.sql.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

java.util.Date executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                            java.lang.String p_strQuery,
                                            java.lang.Object p_valueFallback,
                                            groovy.lang.Closure p_closure)
                                            throws java.sql.SQLException,
                                                   ValueCastException

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

Throws:

java.sql.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

java.util.Date executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                            java.lang.String p_strQuery,
                                            groovy.lang.Closure p_closure)
                                            throws java.sql.SQLException,
                                                   ValueCastException

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

Throws:

java.sql.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,
                  java.lang.String p_strQuery)
                  throws java.sql.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:

java.sql.SQLException

executeUpdate

int executeUpdate(de.uplanet.jdbc.JdbcConnection p_conn,
                  java.lang.String p_strQuery,
                  groovy.lang.Closure p_closure)
                  throws java.sql.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:

java.sql.SQLException

prepare

DbPreparedStatement prepare(de.uplanet.jdbc.JdbcConnection p_conn,
                            java.lang.String p_strQuery)
                            throws java.sql.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:

java.sql.SQLException - If a database error occurred.

close

void close()
           throws java.sql.SQLException

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

Specified by:

close in interface ICloseable

Throws:

java.sql.SQLException - If a database error occurred.