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.


Last updated: 2011-08-11 10-04
Copyright © 2000-2011 United Planet. All Rights Reserved.